Appendix III ITS Standard File Format.pdf

File Header Record

EXAMPLE: XXMMDDYY.001 MMDDYY 01 VENDOR PAYMENTS

*ENDMSG*

# Field Name Type Length Start

Position End

Position KFC Validation Rules Notes

1 File Name AN 12 1 12 If invalid or missing, reject the file

Should be XXMMDDYY.001, where MMDDYY is current business month, day and year. The file extension".001" can be incremented if multiple file are processed on same day, for example ".002". The 2-character alpha beginning is agency specific. Recommend using 2 characters that represent the customer Agency's name - this would need to be confirmed with ITS.gov prior to use

2 Current Date AN 6 14 19 If invalid or missing, reject the file Date should match date in file name 3 Batch Sequence Number N 2 21 22 4 Descriptive File Title AN 19 24 43 Type of payments 5 *ENDMSG* AN 8 1 8 Concludes header record

Wire Payment Detail Record

# Field Name Type Length Start

Position End

Position KFC Validation Rules Notes

6 [FXR] A Required for wire payments. Start of payment record 7 :ALC: N 8 1 8 If invalid or missing, reject the file Should be Agency's ALC

8 :SCHEDULE: AN 10 1 10 Manually validated against SPS certification Schedule Number, no minimum

9 :30 VALUE DATE: AN 6 1 6

Must be two business days from date in file name

In YYMMDD format. US holidays should be taken into consideration

10 :BASE AMT: AN 21 1 21 If missing, reject the file "USD" space USD amount indicated, including decimals 11 :FX AMT: AN 21 1 21 If missing, reject the file 3 digit currency code space FX total including decimal 12 :57D PAY THRU: AN 8/11 1 11 If missing, reject the file SWIFT Address should be 8 or 11 alphanumeric characters 13 BANK NAME AN 35 1 35 Not all foreign wires / countries require full bank name 14 BANK ADDRESS AN 35 1 35 Not all foreign wires / countries require full bank address 15 BANK ADDRESS AN 35 1 35 Not all foreign wires / countries require full bank address 16 BANK ADDRESS AN 35 1 35 Not all foreign wires / countries require full bank address

17 :59 BENEFICIARY: AN 34 1 34

Beneficiary Account Number can be up to 34 alphanumeric characters

18 BENEFICIARY NAME AN 35 1 35

Not all foreign wires / countries require full beneficiary address

19 BENEFICIARY ADDRESS AN 35 1 35

Not all foreign wires / countries require full beneficiary address

20 BENEFICIARY ADDRESS AN 35 1 35

Not all foreign wires / countries require full beneficiary address

21 BENEFICIARY ADDRESS AN 35 1 35

22 :70 BENEF INFO:

23 PAYMENT INFORMATION AN 35 1 35

24 PAYMENT INFORMATION AN 35 1 35

25 PAYMENT INFORMATION AN 35 1 35

FOREIGN WIRE PAYMENT

ADVANCED RATE PAYMENT

26 PAYMENT INFORMATION AN 35 1 35

27 :72 RECEIVER INFO:

28 BANK DETAILS AN 35 1 35

Some foreign currencies require additional bank details (i.e.

bank contact phone number, in country vendor codes). These requirements should be populated in this field

29 BANK DETAILS AN 35 1 35

Some foreign currencies require additional bank details (i.e.

bank contact phone number, in country vendor codes). These requirements should be populated in this field

30 BANK DETAILS AN 35 1 35

Some foreign currencies require additional bank details (i.e.

bank contact phone number, in country vendor codes). These requirements should be populated in this field

31 BANK DETAILS AN 35 1 35

Some foreign currencies require additional bank details (i.e.

bank contact phone number, in country vendor codes). These requirements should be populated in this field

*32 :TAS: N 2 1 2 TAS Sub-level Prefix Code *33 N 3 3 5 TAS Allocation Transfer Agency Identifier *34 N 3 6 8 TAS Agency Identifier *35 N 4 9 12 TAS Beginning Period of Availability *36 N 4 13 16 TAS Ending Period of Availability *37 AN 1 17 17 TAS Availability Code *38 N 4 18 21 TAS Main Account Code *39 N 3 22 24 TAS Sub-Account Code *40 :BETC: AN 8 1 8 Businss Event Type Code *41 :AMT: N 17 1 17 USD amount including decimals *42 *ENDMSG* A Constitutes end of payment record

Trailer Record

EXAMPLE: *ENDFILE* 000001 00000000000000000

# Field Name Type Length Start

Position End

Position KFC Validation Rules Notes

43 *ENDFILE* A 9 1 9

44 Record Count N 6 11 16 Front fill with zeroes; total number of payments in file 45 File Total AN 16 18 33 Total USD found in file for all payments, no punctuation

Footnotes

* Lines 32, 33, 34, 35, 36, 37, 38, 39, 40, 41 can repeat up to 100 per payment to fulfill agency requirements for TAS / BETC