10.1 Upload Files
This topic describes the systematic instruction to upload a file for entering the instrument collection data into the system.
The uploaded files are not processed until it is approved. The file format accepted by the system includes “.csv” files.
| Field Column 1 | Field Column | Field Column 3 | Field Column 4 |
|---|---|---|---|
| PAYMENT_NO | REMITTER_ACC_NO | COUNTERPARTY_CODE | FILLER7 |
| CURRENCY | BANK_CODE | AUTO_RECONCILE | FILLER8 |
| AMOUNT | EFT_REF_NO | COUNTERPARTY_ID | FILLER9 |
| PAYMENT_MODE | INSTRUMENT_DATE | IS_PUA | FILLER10 |
| PAYMENT_DATE | INSTRUMENT_BANK | INDIRECT_PAYMENT | FILLER7 |
| CREDIT_ACC_NO | INSTRUMENT_BRANCH | BANK_CHARGE_AMT | FILLER8 |
| FLAG | MANDATE_REF_NO | DEDUC_AMT | FILLER9 |
| ENTITY_REF_NO | CREDIT_NOTE_REF_NO | INST_CLEARED | FILLER10 |
| REMARKS | VIRTUAL_AC_FLAG | FILLER1 | PORTAL_REFERENCE |
| PAYMENT_PARTY_ID | DEBIT_CREDIT_INDICATOR | FILLER2 | SOURCE_TXN_ID |
| PAYMENT_PARTY_NAME | GEN_APPROPRIATION | FILLER3 | MSG_TYPE |
| BENEFICIARY_ID | SPEC_APPROPRIATION | FILLER4 | - |
| BENEFICIARY_NAME | ALLOCATION_REQUIRED | FILLER5 | - |
| PROGRAM_CODE | PAYMENT_PARTY_CODE | FILLER6 | - |
Table 10-1 Relationship File - Supported Fields
| Field Column 1 | Field Column 2 | Field Column 3 | Field Column 4 |
|---|---|---|---|
| INDICATOR | PAY_MAX_DAYS_OVERDUE | CATEGORY | HOLIDAY_TREATMENT |
| CORPORATE_ID | PAY_VALIDATE_LINKED_PO | ADDRESS_TYPE | AUTO_ACCEPTANCE |
| EFF_FROM_DATE | PAY_EXCESS_HANDLING | COUNTRY_CODE | NO_OF_DAYS |
| EXPIRES_ON | PAY_EXCESS_REFUND_PARTY | ADDRESS_LINE_1 | EXTERNAL_CODE |
| AUTO_DEBIT_APPLICABLE | PAY_EXCESS_REFUND_PAYMENT_MODE | ADDRESS_LINE_2 | DIVISION_CODE |
| HOLIDAY_TREATMENT | IS_ANOMALY_DETECTION_REQ | ADDRESS_LINE_3 | CORPORATE_DIVISION_CODE |
| AUTO_ACCEPTANCE | PAY_IS_ANOMALY_DETECTION_REQ | ADDRESS_LINE_4 | ALLOW_OVERDUE_RCV |
| NO_OF_DAYS | CATEGORY | PIN | MAX_DAYS_OVERDUE |
| ALLOW_OVERDUE_RCV | Counterparty Details | COUNTRY | EXCESS_HANDLING |
| MAX_DAYS_OVERDUE | INDICATOR | PREFFERED_COMM_MODE | EXCESS_REFUND_PARTY |
| EXCESS_HANDLING | CORPORATE_ID | MOBILE_NUMBER | EXCESS_REFUND_PAYMENT_MODE |
| EXCESS_REFUND_PARTY | COUNTERPARTYID | PHONE_NUMBER | VALIDATE_LINKED_PO |
| EXCESS_REFUND_PAYMENT_MODE | REGISTRATION_NUMBER | IS_ANOMALY_DETECTION_REQ | |
| VALIDATE_LINKED_PO | PARTY_TYPE | FAX_NUMBER | - |
| PAY_AUTO_DEBIT_APPLICABLE | STATUS | TAX_REF_NO_1 | - |
| PAY_HOLIDAY_TREATMENT | PROGRAM_CODE | TAX_REF_NO_2 | - |
| PAY_AUTO_ACCEPTANCE | NAME | GIIN | - |
| PAY_NO_OF_DAYS | SHORT_NAME | EXPIRES_ON | - |
| PAY_ALLOW_OVERDUE_RCV | INDUSTRY | AUTO_DEBIT_APPLICABLE | - |
Table 10-2 Invoice File - Supported Fields
| Field Column 1 | Field Column 2 | Field Column 3 | Field Column 4 |
|---|---|---|---|
| INDICATOR | NET_INV_AMOUNT | SUPPLIER_ID | BANK |
| INVOICE_NO | TAX_AMOUNT | BUYER_NAME | BRANCH |
| INVOICE_DATE | DISCOUNT | SUPPLIER_NAME | BIC_ROUTING_CODE |
| INVOICE_DUE_DATE | PO_NUMBER | PREACCEPTED | FUNDING_REQ_AMT |
| BUYER_CODE | BUYER_DIV_CODE | ACCEPTANCE_AMOUNT | FILLER1 |
| SUPPLIER_CODE | SUPPLIER_DIV_CODE | PROGRAM_ID | FILLER2 |
| CURRENCY | DISPUTED | VIRTUAL_AC_FLAG | FILLER3 |
| BASE_INV_AMOUNT | BUYER_ID | REPAYMENT_AC_NO | FILLER4 |
| - | - | - | INVOICE_ID |
| - | - | - | FUNDING_REQ_DATE |
| COMMODITY LIST | - | - | - |
| INDICATOR | UNIT_COST | NET_COST | - |
| COMMODITY_CODE | TOTAL_COST | - | - |
| COMMODITY_NAME | TAX_AMOUNT | - | - |
| QUANTITY | DISCOUNT_AMOUNT | - | - |
Table 10-3 Invoice File to link multiple POs - Supported Fields
| Field Column 1 | Field Column 2 | Field Column 3 | Field Column 4 |
|---|---|---|---|
| INDICATOR | BUYER_NAME | NET_PMT_TERMS | BENE_ADDR1_FOR_CAN |
| INVOICE_NO | SUPPLIER_NAME | PMT_CONDITION | BENE_ADDR2_FOR_CAN |
| INVOICE_DATE | PREACCEPTED | SHIPMENT_DATE | BENE_ADDR3_FOR_CAN |
| INVOICE_VALUE_DATE | ACCEPTANCE_AMOUNT | SHIPMENT_NUMBER | BENE_ADDR4_FOR_CAN |
| INVOICE_DUE_DATE | PROGRAM_ID | SHIPMENT_ADDRESS | BENE_CNTRY_FOR_CAN |
| BUYER_CODE | VIRTUAL_AC_FLAG | SHIPMENT_COUNTRY | BENE_PHONE_FOR_CAN |
| SUPPLIER_CODE | REPAYMENT_AC_NO | CITY | BENE_EMAIL_FOR_CAN |
| CURRENCY | VIRTUAL_AC_FLAG | ZIP CODE | INTERMEDIARY_BANK_CODE_FOR_CAN |
| BASE_INV_AMOUNT | REPAYMENT_AC_NO | PHONE NUMBER | INTERMEDIARY_BANK_NAME_FOR_CAN |
| NET_INV_AMOUNT | BANK | TAX ID | INTERMEDIARY_BANK_ADDR1_FOR_CAN |
| TAX_AMOUNT | BRANCH | REASON_FOR_EXPORT | INTERMEDIARY_BANK_ADDR2_FOR_CAN |
| DISCOUNT | BIC_ROUTING_CODE | TERMS_OF_SALE | INTERMEDIARY_BANK_ADDR3_FOR_CAN |
| DISCOUNT1_DAYS | FUNDING_REQ_AMT | COUNTRY_OF_ORIGIN | INTERMEDIARY_BANK_ADDR4_FOR_CAN |
| DISCOUNT1_PERC | FILLER1 | REMARKS | DISBURSEMENT_CREDT_ACCOUNT |
| DISCOUNT2 DAYS | FILLER2 | MISC_CHARGE1_DESC | ACCOUNT_NAME_FOR_DCA |
| DISCOUNT2 PERC | FILLER3 | MISC_CHARGE1_AMOUNT | PAYMENT_MODE_FOR_DCA |
| BUYER_DIV_CODE | FILLER4 | MISC_CHARGE2_DESC | BENE_ADDR1_FOR_DCA |
| SUPPLIER_DIV_CODE | INVOICE_ID | MISC_CHARGE2_AMOUNT | BENE_ADDR2_FOR_DCA |
| DISPUTED | FUNDING_REQ_DATE | USE_EARMARKED_LIMITS | BENE_ADDR3_FOR_DCA |
| BUYER_ID | - | ACCOUNT_NAME_FOR_CAN | BENE_ADDR4_FOR_DCA |
| SUPPLIER_ID | - | PAYMENT_MODE_FOR_CAN | BENE_CNTRY_FOR_DCA |
| - | - | - | BENE_PHONE_FOR_DCA |
| - | - | - | BENE_EMAIL_FOR_DCA |
| - | - | - | BANK_NAME_FOR_DCA |
| - | - | - | BRANCH_NAME_FOR_DCA |
| - | - | - | BANK_IDENTIFIER_CODE_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_CODE_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_NAME_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_ADDR1_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_ADDR2_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_ADDR3_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_ADDR4_FOR_DCA |
| - | - | - | SHIPMENT_ADDRESS2 |
| - | - | - | SHIPMENT_ADDRESS3 |
| - | - | - | SHIPMENT_ADDRESS4 |
| PO | - | - | - |
| INDICATOR | - | - | - |
| PO_NUMBER | - | - | - |
| INVOICE_AMOUNT_ALLOCATED | - | - | - |
| PO_NUMBER | - | - | - |
| COMMODITY LIST | - | - | - |
| INDICATOR | TOTAL_COST | - | - |
| COMMODITY_CODE | TAX_AMOUNT | - | - |
| COMMODITY_CODE | DISCOUNT_AMOUNT | - | - |
| QUANTITY | NET_COST | - | - |
| UNIT_COST | - | - | - |
Table 10-4 Purchase Order File - Supported Fields
| Field Column 1 | Field Column 2 | Field Column 3 | Field Column 4 |
|---|---|---|---|
| INDICATOR | PREACCEPTED | PHONE NUMBER | FILLER 5 |
| PO_EXTERNAL_NUMBER | FUNDING REQUEST AMOUNT | PAYMENT_TERMS | FILLER 6 |
| PO_DATE | ACCEPTED AMOUNT | COUNTRY_OF_ORIGIN | PO_ID |
| CURRENCY | BUYER DIVISION CODE | MISC_CHARGE 1_DESC | DISBURSEMENT_CREDT_ACCOUNT |
| BASE PO AMOUNT | SUPPLIER DIVISION CODE | MISC_CHARGE 1_AMOUNT | ACCOUNT_NAME_FOR_DCA |
| BUYER ID | PREACCEPTED | MISC_CHARGE 2_DESC | PAYMENT_MODE_FOR_DCA |
| BUYER NAME | FUNDING REQUEST AMOUNT | MISC_CHARGE 2_AMOUNT | BENE_ADDR1_FOR_DCA |
| DISCOUNT AMOUNT | FUNDING_REQ_DATE | FILLER 1 | BENE_ADDR2_FOR_DCA |
| NET_PO_AMOUNT | PROGRAM_ID | FILLER 2 | BENE_ADDR3_FOR_DCA |
| ACCEPTED_AMOUNT | COUNTRY | FILLER 3 | BENE_ADDR4_FOR_DCA |
| BUYER_DIVISION_CODE | CITY | FILLER 4 | BENE_CNTRY_FOR_DCA |
| - | - | - | BENE_PHONE_FOR_DCA |
| - | - | - | BENE_EMAIL_FOR_DCA |
| - | - | - | BANK_NAME_FOR_DCA |
| - | - | - | BRANCH_NAME_FOR_DCA |
| - | - | - | BANK_IDENTIFIER_CODE_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_CODE_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_NAME_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_ADDR1_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_ADDR2_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_ADDR3_FOR_DCA |
| - | - | - | INTERMEDIARY_BANK_ADDR4_FOR_DCA |
| COMMODITY LIST | - | - | - |
| INDICATOR | TOTAL_COST | - | - |
| COMMODITY_CODE | TAX_AMOUNT | - | - |
| COMMODITY_NAME | DISCOUNT_AMOUNT | - | - |
| QUANTITY | NET_COST | - | - |
| UNIT_COST | - | - | - |
Table 10-5 Credit Note – Seller File - Supported Fields
| Field Column 1 | Field Column 2 | Field Column 3 | Field Column 4 |
|---|---|---|---|
| INDICATOR | TAX_AMOUNT | FILLER1 | DEDUC_AMT |
| CN_NO | DISCOUNT | FILLER2 | PMT_VALUE_DATE |
| CN_ID | BUYER_DIV_CODE | FILLER3 | INDIRECT_PAYMENT |
| LINK_INVOICE_NO | SUPPLIER_DIV_CODE | FILLER4 | SOURCE_TXN_ID |
| CN_DATE | BUYER_ID | FILLER5 | MSG_TYPE |
| CN_EXPIRY_DATE | SUPPLIER_ID | FILLER6 | - |
| BUYER_CODE | BUYER_NAME | FILLER7 | - |
| SUPPLIER_CODE | SUPPLIER_NAME | FILLER8 | - |
| CURRENCY | PROGRAM_ID | FILLER9 | - |
| BASE_CN_AMOUNT | ADJUST_REASON_CODE | FILLER10 | - |
| NET_CN_AMOUNT | REMARKS | BANK_CHARGE_AMT | - |
| COMMODITY LIST | - | - | - |
| INDICATOR | TOTAL_COST | - | - |
| COMMODITY_CODE | TAX_AMOUNT | - | - |
| COMMODITY_NAME | DISCOUNT_AMOUNT | - | - |
| QUANTITY | NET_COST | - | - |
| UNIT_COST | - | - | - |
Table 10-6 Debit Note – Buyer File - Supported Fields
| Field Column 1 | Field Column 2 | Field Column 3 | Field Column 4 |
|---|---|---|---|
| INDICATOR | PREACCEPTED | FILLER10 | INTERMEDIARY_BANK_ADDR3_FOR_CAN |
| DN_NO | ACCEPTANCE_AMOUNT | SHIPMENT_NO | INTERMEDIARY_BANK_ADDR4_FOR_CAN |
| DN_ID | PROGRAM_ID | SHIPMENT_DATE | DISBURSEMENT_CREDT_ACCOUNT |
| LINK_INVOICE_NO | VIRTUAL_AC_FLAG | SHIPMENT_ADDRESS | ACCOUNT_NAME_FOR_DCA |
| DN_DATE | REPAYMENT_AC_NO | SHIPMENT_COUNTRY | PAYMENT_MODE_FOR_DCA |
| DN_DUE_DATE | BANK | EXPORT_REASON | BENE_ADDR1_FOR_DCA |
| BUYER_CODE | BRANCH | SALE_TERMS | BENE_ADDR2_FOR_DCA |
| SUPPLIER_CODE | BIC_ROUTING_CODE | PAYMENT_TERMS | BENE_ADDR3_FOR_DCA |
| CURRENCY | FUNDING_REQ_AMT | COUNTRY_OF_ORIGIN | BENE_ADDR4_FOR_DCA |
| BASE_DN_AMOUNT | ADJUST_REASON_CODE | FUNDING_REQ_DATE | BENE_CNTRY_FOR_DCA |
| NET_DN_AMOUNT | REMARKS | ACCOUNT_NAME_FOR_CAN | BENE_PHONE_FOR_DCA |
| TAX_AMOUNT | FILLER1 | PAYMENT_MODE_FOR_CAN | BENE_EMAIL_FOR_DCA |
| DISCOUNT | FILLER2 | BENE_ADDR1_FOR_CAN | BANK_NAME_FOR_DCA |
| BUYER_DIV_CODE | FILLER3 | BENE_ADDR2_FOR_CAN | BRANCH_NAME_FOR_DCA |
| SUPPLIER_DIV_CODE | FILLER4 | BENE_ADDR3_FOR_CAN | BANK_IDENTIFIER_CODE_FOR_DCA |
| DISPUTED | FILLER5 | BENE_ADDR4_FOR_CAN | INTERMEDIARY_BANK_CODE_FOR_DCA |
| BUYER_ID | FILLER6 | BENE_CNTRY_FOR_CAN | INTERMEDIARY_BANK_NAME_FOR_DCA |
| SUPPLIER_ID | FILLER7 | BENE_PHONE_FOR_CAN | INTERMEDIARY_BANK_ADDR1_FOR_DCA |
| BUYER_NAME | FILLER8 | BENE_EMAIL_FOR_CAN | INTERMEDIARY_BANK_ADDR2_FOR_DCA |
| SUPPLIER_NAME | FILLER9 | INTERMEDIARY_BANK_CODE_FOR_CAN | INTERMEDIARY_BANK_ADDR3_FOR_DCA |
| - | - | INTERMEDIARY_BANK_NAME_FOR_CAN | INTERMEDIARY_BANK_ADDR4_FOR_DCA |
| - | - | INTERMEDIARY_BANK_ADDR1_FOR_CAN | SHIPMENT_ADDRESS2 |
| - | - | INTERMEDIARY_BANK_ADDR2_FOR_CAN | SHIPMENT_ADDRESS3 |
| COMMODITY LIST | - | - | SHIPMENT_ADDRESS4 |
| INDICATOR | TOTAL_COST | - | - |
| COMMODITY_CODE | TAX_AMOUNT | - | - |
| COMMODITY_NAME | DISCOUNT_AMOUNT | - | - |
| QUANTITY | NET_COST | - | - |
| UNIT_COST | - | - | - |
- On Home screen, click File Management. Under File Management, click File Upload.The File Upload screen displays.
Parent topic: File Management