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

transparent spacer graphicFMS Hometransparent 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 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 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.