FMS Web site bannerFMS Programs Banner Tab Read FMS Web site privacy policy Skip to Main Content Department of the Treasury Web site Programs main page
 

transparent spacer graphicHometransparent spacer graphicFAQ'stransparent spacer graphicTraining & Eventstransparent spacer graphicPublicationstransparent spacer graphicProgramstransparent spacer graphicAbout FMStransparent spacer graphicA-Z Indextransparent spacer graphicNavigation Helptransparent spacer graphic
   
 
     arrow pointing right Advanced Search | RSSXML | Subscribe | Contact FMS Skip secondary navigation
  spacer graphic

CTX Payments

CTX Vendor Payments Flat File Examples

Table of Contents


Input File Example

DHDR                JSC VENMIS98035     JOHNSON SPACE CENTER281-550-9800VENMISM98333       980206                                                               
A0176643000000011796V40000004DAVID JONES CO         C0110002063456-155                                                                                         N
RM IV23456                              41796                    
RM IV23457                             -30000                    CM          CREDIT MEMO ADJUSTMENT  
A0425577710000110316V40000004SOFTBANK               C01100039077777                                                                                            N
RM IV23457                              40316     40000          RB8.125%    $3.16 INTEREST FOR 20 DAYS 
RM IV23459                              40000     40200       200               
RM IV23458                              30000                                   
DEOR      0000000002          000000122112

Output Example

101 111000038 11103618398021813346094101DALLAS FRB             AUSTIN DISB CTR        DTSGA001
5200US TREASURY     220                 111036183 CTXEDI MISC        980206   2111036180000272
6220110002063456-155         000001179640000004       0006DAVID JONES CO      1111036189008286
705ISA*00*0000000000*00*0000000000*ZZ*US TREASURY 220*ZZ*FEDERAL PAYMENT*980218*13300019008286
7053*U*00200*000000001*0*T*~\GS*RA*US TREASURY*FEDERAL PAY*980218*1333*2*X*003040\S00029008286
705T*820*009008286\BPR*C*117.96*C*ACH*CTX*01*111036183*ZZ*40000004***01*011000206*D00039008286
705A*3456-155*980206*VEN\REF*72*M98333\N1*PE*DAVID JONES CO*FI*017664300\N1*PR*JOHN00049008286
705SON SPACE CENTER\ENT*1\RMR*IV*23456*AI*417.96\RMR*IV*23457*AI*-300\REF*CM**CREDI00059008286
705T MEMO ADJUSTMENT\SE*10*009008286\GE*1*2\IEA*1*000000001\                       00069008286
62201100039077777            000011031640000004       0007SOFTBANK            1111036189008287
705ISA*00*0000000000*00*0000000000*ZZ*US TREASURY 220*ZZ*FEDERAL PAYMENT*980218*13300019008287
7053*U*00200*000000001*0*T*~\GS*RA*US TREASURY*FEDERAL PAY*980218*1333*2*X*003040\S00029008287
705T*820*009008287\BPR*C*1103.16*C*ACH*CTX*01*111036183*ZZ*40000004***01*011000390*00039008287
705DA*77777*980206*VEN\REF*72*M98333\N1*PE*SOFTBANK*FI*042557771\N1*PR*JOHNSON SPAC00049008287
705E CENTER\ENT*2\RMR*IV*23457*AI*403.16*400\REF*RB*8.125%*$3.16 INTEREST FOR 20 DA00059008287
705YS\RMR*IV*23459*AI*400*402*2\RMR*IV*23458*AI*300\SE*11*009008287\GE*1*2\IEA*1*0000069008287
7050000001\                                                                        00079008287
82000000150002200059000000000000000000122112111036183                          111036180000272
9000001000002000000150002200059000000000000000000122112
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
VENDOR PAYMENTS
Flat File Data
FILE HEADER RECORD

Record ID

1 - 4

 Blanks

5 - 20

 Agency Name
21 - 24 		VENMIS
25 - 30 		Creation
Date
31 - 35 		Blanks
36 - 40 		Agency Name
41 - 60 		Agency
Telephone Number
61 - 72 		VENMIS
73 - 78 		Schedule Number
79 - 89 		Settlement Date
90 - 97 		Blanks
98 - 160
DHDR
JSC VENMIS 98035
Johnson Space Center 281-550-9800 VENMIS M97333 980206


FIRST PAYMENT RECORD

Record ID

1

 Payee ID
(TIN Number)

2 - 10

 Total Payment
Amount

11 - 20

 Line Code

21

 Agency
Location
Code (ALC)
22 - 29 		Payee Name

30 - 52

 Account
Type

53

 Receiving
RTN

54 - 61

 Check
Digit

62

 Receiving
Account
Number
63 - 79 		Blanks

80 - 159

 Eligible
For Offset
Code
160
A 017664300 11796 V 40000004 DAVID JONES CO C 01100020 6 3456-155
N


First Associated Remittance Record
Record ID

1 - 3

 Document Reference Type

4 - 5

 Document
Number

6 - 35

 Actual Amount
Paid

36 - 45

 Original
Document
Amount
46 - 55 		Discount
Amount
Taken
56 - 65 		Additional
Info Type

66 - 67

 Additional
Info
Number
68 - 77 		Informational
Note

78 - 157

 Blanks 158 - 160
'RMb with a / through it' IV 23456 41796


Second Associated Remittance Record with Credit Memo
Record ID

1 - 3

 Document Reference Type

4 - 5

 Document
Number

6 - 35

 Actual Amount
Paid

36 - 45

 Original
Document
Amount
46 - 55 		Discount
Amount
Taken
56 - 65 		Additional
Info Type

66 - 67

 Additional
Info
Number
68 - 77 		Informational
Note

78 - 157

 Blanks 158 - 160
'RMb with a / through it' IV 23457 -30000
CM
Credit Memo Adjustment


SECOND PAYMENT RECORD

Record ID

1

 Payee ID
(TIN Number)

2 - 10

 Total Payment
Amount

11 - 20

 Line Code

21

 Agency
Location
Code (ALC)
22 - 29 		Payee Name

30 - 52

 Account
Type

53

 Receiving
RTN

54 - 61

 Check
Digit

62

 Receiving
Account
Number
63 - 79 		Blanks

80 - 159

 Eligible
For Offset
Code
160
A 042557771 110316 V 40000004 SOFTBANK C 01100039 0 77777
N


First Associated Remittance Record with interest penality
Record ID

1 - 3

 Document Reference Type

4 - 5

 Document
Number

6 - 35

 Actual Amount Paid

36 - 45

 Original
Document
Amount
46 - 55 		Discount
Amount
Taken
56 - 65 		Additional
Info Type

66 - 67

 Additional
Info
Number
68 - 77 		Informational
Note

78 - 157

 Blanks 158 - 160
'RMb with a / through it' IV 23457 40316 40000
RB 8.125% $3.16 interest for 20 days


Second Associated Remittance Record with discount
Record ID

1 - 3

 Document Reference Type

4 - 5

 Document
Number

6 - 35

 Actual Amount
Paid

36 - 45

 Original
Document
Amount
46 - 55 		Discount
Amount
Taken
56 - 65 		Additional
Info Type

66 - 67

 Additional
Info
Number
68 - 77 		Informational
Note

78 - 157

 Blanks 158 - 160
'RMb with a / through it' IV 23459 40000 40200 200


Third Associated Remittance Record
Record ID

1 - 3

 Document Reference Type

4 - 5

 Document
Number

6 - 35

 Actual Amount
Paid

36 - 45

 Original
Document
Amount
46 - 55 		Discount
Amount
Taken
56 - 65 		Additional
Info Type

66 - 67

 Additional
Info
Number
68 - 77 		Informational
Note

78 - 157

 Blanks 158 - 160
'RMb with a / through it' IV 23458 30000


FILE TRAILER RECORD
Record ID

1 - 4

 Blanks

5 - 10

 (File Total)
Record Count

11 - 20

 Blanks

5 - 10

 (File Total)
Total Amount

31 - 42

 Blank

43

 (Tape Total)
Cumulative Record
Count
44 - 55 		Blank

56

 (Tape Total)
Cumulative Amount

57 - 70

 Blanks

71 - 60
DEOR
0000000002
000000025925



   Last Updated:  March 08, 2011

Accessibility
FMS Privacy Policy 		Web Site Inventory &
Publication Schedule 		E-Government
Open Government 		Freedom of
Information Act 		Information
Quality Act
Link to Treasury Department Web Site. Link will open a new browser window. Link to Treasury No Fear Act Page. Link will open a new browser window. Link to Recovery.gov: Your Money At Work. Link will open a new browser window. Link to Regulations.gov. Link will open a new browser window. Link to USA.gov. Link will open a new browser window.