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 14, 2014