HomeFAQ'sTraining & EventsPublicationsProgramsAbout FMSA-Z IndexNavigation Help
	Advanced Search | RSS | Subscribe | Contact FMS

CTX VENDOR PAYMENTS LAYOUT

DHDR= File Header Record

A = Payment Record
RM = Remittance Record
RM
RM
RM
Etc.

A = Payment Record
RM = Remittance Record
RM
RM
Etc.

.
.
.
.
.
.

DEOR = File Trailer Record

All Alpha - Numeric fields should be left justified.
All Numeric fields should be right justified.

Field No.	Field Length	Field Type	Field Position	Description	Notes
1	4	Alpha/ Numeric	1 - 4	Record ID	"DHDR"
2	16	Alpha/ Numeric	5 - 20	Blanks
3	4	Alpha/ Numeric	21 - 24	Agency Name	ex: AGRI
4	6	Alpha/ Numeric	25 - 30	VENMIS
5	5	Numeric	31 - 35	Creation Date	YYDDD
6	5	Alpha/ Numeric	36 - 40	Blanks
7	20	Alpha/ Numeric	41 - 60	Agency Name	(Optional)
8	12	Alpha/ Numeric	61 - 72	Agency Telephone Number	(Optional)
9	6	Alpha/ Numeric	73 - 78	VENMIS
10	11	Alpha/ Numeric	79 - 89	Schedule Number	Mandatory
11	8	Numeric	90 - 97	Settlement Date	Mandatory YYMMDD or YYYYMMDD
12	63	Alpha/ Numeric	98 - 160	Blanks

Payment Record

Field No.	Field Length	Field Type	Field Position	Description	Notes	FN
1	1	Alpha/ Numeric	1	Record ID	"A"
2	9	Numeric	2 - 10	Payee ID (TIN Number)	Taxpayer Identification Number
3	10	Numeric	11 - 20	Total Payment Amount	No Decimal	1
4	1	Alpha/ Numeric	21	Line Code	"V"
5	8	Numeric	22 - 29	Agency Location Code (ALC)
6	23	Alpha/ Numeric	30 - 52	Payee Name	Name field in ACH CTX is limited to 16 characters.
7	1	Alpha/ Numeric	53	Account Type	"C" or "S"
8	8	Numeric	54 - 61	Receiving RTN
9	1	Numeric	62	Check Digit
10	17	Alpha/ Numeric	63 - 79	Receiving Account Number
11	80	Alpha/ Numeric	80 - 159	Blanks
12	1	Alpha/ Numeric	160	Eligible For Offset Code	Y or N

1. Total amount must equal the sum of all associated Remittance Records. (Field 4 of Remittance Records.)

Field No.	Field Length	Field Type	Field Position	Description	Notes	FN
1	3	Alpha/ Numeric	1 - 3	Record ID	"RM"
2	2	Alpha/ Numeric	4 - 5	Document Reference Type		1
3	30	Alpha/ Numeric	6 - 35	Document Number
4	10	Numeric	36 - 45	Actual Amount Paid	No Decimal	2
5	10	Numeric	46 - 55	Original Document Amount	No Decimal Optional
6	10	Numeric	56 - 65	Discount Amount Taken	No Decimal Optional
7	2	Alpha/ Numeric	66 - 67	Additional Info Type	Optional	3
8	10	Alpha/ Numeric	68 - 77	Additional Info Number	Optional	4
9	80	Alpha/ Numeric	78 - 157	Informational Note	Optional	5
10	3	Alpha/ Numeric	158 - 160	Blanks

1. Recommended Document Reference Types:

IV - SELLER'S INVOICE NUMBER
CT - CONTRACT NUMBER
PO - PURCHASE ORDER NUMBER

2. Sum of all Remittance amounts must equal total dollar amount in the Payment Record, field 3.

3. Recommended Additional Info Types:

RB - RATE CODE NUMBER
CM - CREDIT MEMO

4. Use prompt pay annual interest rate. Example: 8.125%

5. Example: $3.16 is interest for 20 days.

1. Must match number of Payment ("A") Records in file.

2. Must match sum of all total dollar amounts in Field 3 of Payment ("A") Records in file.

Last Updated:  March 08, 2011

Download Adobe Acrobat Reader, previous versions of the Reader, Microsoft Excel Viewer, PowerPoint Viewer or Word Viewer
Accessibility FMS Privacy Policy	Web Site Inventory & Publication Schedule	E-Government Open Government	Freedom of Information Act	Information Quality Act
HomeFAQ'sTraining & EventsPublicationsProgramsAbout FMSA-Z IndexNavigation Help