74330226R0045 Attachment 3 Payroll ITS File Specifications.pdf
PDF 47 KB Posted
- Attached to
- ABMC Global Payroll Services
- Solicitation number
- 74330226R0045
- Issued by
- Not on record
About this file
This document is a technical specification for a Foreign Wire Payment Advanced Rate Payment file format used for federal vendor payments. The file structure consists of three main record types: File Header Record, Wire Payment Detail Record, and Trailer Record.
The File Header Record contains basic file identification information including the filename (formatted as XXMMDDYY.001), current date, batch sequence number, and descriptive file title indicating the type of payments. The Wire Payment Detail Record contains payment details with mandatory fields including the Agency's Account Location Code (ALC), schedule number, value date (in YYMMDD format, must be two business days from the file name date), base amount in USD, foreign exchange amount with currency code, and payment routing information via SWIFT address. Additional required fields include beneficiary account number, beneficiary name and address, payment information, and bank details. The record also accommodates Treasury Account Symbol (TAS) data (up to 100 repeating entries per payment) and Business Event Type Code (BETC) for agency-specific accounting requirements. The Trailer Record concludes the file with record count (front-filled with zeroes) and total USD amount for all payments without punctuation. All monetary amounts must include decimals, SWIFT addresses must be 8 or 11 alphanumeric characters, and validation rules require rejection of files with invalid or missing critical fields such as the filename, current date, ALC, base amount, and foreign exchange amount.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 74330226R0044-45 Vendor Questions.xlsx | XLSX spreadsheet | |
| 74330226R0045 Attachment 4 GL File Specs.pdf | ||
| 74330226R0045 Attachment 2 Questions Matrix.xlsx | XLSX spreadsheet | |
| 74330226R0045 Attachment 1 PWS.pdf | ||
| 74330226R0045 RFP Instructions.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
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
File details come from the government source that posted it. Updated .