D.7_Appendix_D_â_File_Layout.doc
DOC document 37 KB Posted
- Attached to
- Commercial Banking Services Federal contract opportunity
- Solicitation number
- 75FCMC19R0006
About this file
Attachment D.7 Appendix D - File Layout
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| 75FCMC19R0006_Solicitation_Amendment_2.pdf | ||
| Solicitation_Questions_and_Answers_75FCMC19R0006.xlsx | XLSX spreadsheet | |
| 75FCMC19R0006_Solicitation_Amendment_1.pdf | ||
| D.4_Contractor_Business_Ethics_COI_and_Compliance_Program_Requirements.docx | DOCX document | |
| D.3_Contractor_Personal_Conflicts_of_Interest_Financial_Disclousre_Template.docx | DOCX document | |
| D.5_Appendix_A_B_F.xlsx | XLSX spreadsheet | |
| D.2_Past_Performance_Questionnaire.docx | DOCX document | |
| D.8_Appendix_E_â_(Sample)_Map_of_MAC_Jurisdictions.pdf | ||
| D.6_Appendix_C_â_(Template)_Tripartite_Agreement.doc | DOC document | |
| 75FCMC19R0006.pdf | ||
| D.1_Statement_of_Work.docx | DOCX document | |
| D.9_Exhibit_1_-_(Template)_Invoice_with_pricing_and_Volumes_of_Services.xlsx | XLSX spreadsheet |
Show all 12
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Appendix –D
Account Reconciliation
ARP Standard Issue Input Format for Mainframe Data Transmission/FTP TC "ARP Standard Issue Input Format for Mainframe Data Transmission/FTP" \f C \l "4" Please use the standard layout format listed below to produce issue data for transmission to Financial Institution for your Full Account Reconciliation and Positive Pay Services.
The file you create should follow the specifications listed below:
· Each record will contain 145 characters
· The decimal is implied
· Each file may contain multiple accounts
· You will need to create a total record for each account (after the detail records)
DETAIL RECORD1
| Field/ Column |
| Position |
| Length/Column Width |
| Contents |
| Description |
| 1/A |
| 01-02 |
| 2 |
| '01' |
| Record Code |
| 2/B |
| 03-14 |
| 12 |
| Numeric |
| Account Number2 |
| 3/C |
| 15-24 |
| 10 |
| Numeric |
| Serial/Check Number2 |
| 4/D |
| 25-36 |
| 12 |
| $$$$$$$$$$¢¢ |
| Amount2 |
| 5/E |
| 37-44 |
| 8 |
| MMDDYYYY |
| Issue Date2 |
| 6/F |
| 45-45 |
| 1 |
| Alpha/Numeric |
| Blank or "V" for Void |
| 7/G |
| 46-85 |
| 40 |
| Alpha/Numeric |
| First Payee Name |
| 8/H |
| 86-125 |
| 40 |
| Alpha/Numeric |
| Second Payee Name |
| 9/I |
| 126-145 |
| 20 |
| Blank |
| Filler |
TOTAL RECORD3
| Field/ Column |
| Position |
| Length/Column Width |
| Contents |
| Description |
| 1/A |
| 01-02 |
| 2 |
| '02' |
| Record Code |
| 2/B |
| 03-14 |
| 12 |
| Numeric |
| Account Number2 |
| 3/C |
| 15-24 |
| 10 |
| Numeric |
| Total Detail Records2 |
| 4/D |
| 25-36 |
| 12 |
| $$$$$$$$$$¢¢ |
| Total Amount2 |
| 5/E-I |
| 37-145 |
| 109 |
| Blank |
| Filler4 |
1 The detail record contains all of the issue data information.
2 These fields/columns are right justified and zero filled.
3 The Total Record is a summary of the information in the Detail record. It is a count of items and a total dollar amount.
4 Each record cannot exceed 145 characters, including the line feed / carriage return. Line feed / carriage return should be set at position 145.
File details come from the government source that posted it.