CTX Payments

CTX Allottment and Deduction Flat File Examples

Table of Contents


Input File Example

                                
DHDR                JSC VENMIS98035     JOHNSON SPACE CENTER281-550-9800VENMISM98333       980206                  
A9999999990000009000V40000004PRUDENTIAL INS         C0110002063456-155                                                                                         N
RM SY123456789                           4500                    TN          SUSAN SMITH                           
RM SY923457001                           4500                    TN          MARY JONES                            
A9999999990000016925V40000004TRAVIS COUNTY          C01100039077777                                                                                            N
RM SY123457093                           3000                    3H          ILENE MONARCH                         
RM SY123459110                           6000                    3H          RAY BOWMAN CASE #11776952392          
RM SY223458769                           7925                    3H67935     WALLY JONES                           
DEOR      0000000002          000000025925      

Output Example

101 111000038 11103618398022010049094101DALLAS FRB             AUSTIN DISB CTR        DTSGA001
 5200US TREASURY     220                 111036183 CTXEDI MISC        980206   2111036180000275
 6220110002063456-155         000000900040000004       0006PRUDENTIAL INS      1111036189008292
 705ISA*00*0000000000*00*0000000000*ZZ*US TREASURY 220*ZZ*FEDERAL PAYMENT*980220*10000019008292
 7053*U*00200*000000001*0*T*~\GS*RA*US TREASURY*FEDERAL PAY*980220*1003*2*X*003040\S00029008292
 705T*820*009008292\BPR*C*90*C*ACH*CTX*01*111036183*ZZ*40000004***01*011000206*DA*3400039008292
 70556-155*980206*VEN\REF*72*M98333\N1*PE*PRUDENTIAL INS*FI*999999999\N1*PR*JOHNSON 00049008292
 705SPACE CENTER\ENT*1\RMR*SY*123456789*AI*45\REF*TN**SUSAN SMITH\RMR*SY*923457001*A00059008292
 705I*45\REF*TN**MARY JONES\SE*11*009008292\GE*1*2\IEA*1*000000001\                 00069008292
 62201100039077777            000001692540000004       0007TRAVIS COUNTY       1111036189008293
 705ISA*00*0000000000*00*0000000000*ZZ*US TREASURY 220*ZZ*FEDERAL PAYMENT*980220*10000019008293
 7053*U*00200*000000001*0*T*~\GS*RA*US TREASURY*FEDERAL PAY*980220*1003*2*X*003040\S00029008293
 705T*820*009008293\BPR*C*169.25*C*ACH*CTX*01*111036183*ZZ*40000004***01*011000390*D00039008293
 705A*77777*980206*VEN\REF*72*M98333\N1*PE*TRAVIS COUNTY*FI*999999999\N1*PR*JOHNSON 00049008293
 705SPACE CENTER\ENT*2\RMR*SY*123457093*AI*30\REF*3H**ILENE MONARCH\RMR*SY*12345911000059008293
 705*AI*60\REF*3H**RAY BOWMAN CASE #11776952392\RMR*SY*223458769*AI*79.25\REF*3H*67900069008293
 70535*WALLY JONES\SE*13*009008293\GE*1*2\IEA*1*000000001\                          00079008293
 82000000150002200059000000000000000000025925111036183                          111036180000275
 9000001000002000000150002200059000000000000000000025925                                       
 9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999

Flat File Data Example

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 999999999 9000 V 40000004 PRUDENTIAL INS. 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' SY 123456789 4500
 
 
TN
 
SUSAN SMITH
 


Second 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' SY 923457001 4500
 
 
TN
 
MARY JONES
 


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 999999999 16925 V 40000004 TRAVIS COUNTY C 01100039 0 77777
 
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' SY 123457093 3000
 
 
3H
 
ILENE MONARCH
 
Second 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' SY 123459110 6000
 
 
3H
 
RAY BOWMAN CASE #11776952392
 


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' SY 223458769 7925
 
 
3H 67935 WALLY JONES
 


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