11.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 can contain data records of invoices, purchase orders, payments, counterparties and so on. The file format accepted by the system includes “.csv” files.
Payment File
Naming Convention: OBSCF-PAYMENT_suffix.csv
The file name should begin with ‘OBSCF-PAYMENT’. The suffix can be a string that makes the file name unique.
| 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 | - |
Relationship File
Naming Convention: OBSCF-RELATIONSHIP-MASTER_suffix.csv
The file name should begin with ‘OBSCF-RELATIONSHIP-MASTER’. The suffix can be a string that makes the file name unique.
Table 11-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 | - |
Invoice File
Naming Convention: OBSCF-INVOICE-BUYER_suffix.csv or OBSCF-INVOICE-SELLER_suffix.csv
The file name should begin with ‘OBSCF-INVOICE-BUYER’ or ‘OBSCF-INVOICE-SELLER’. The suffix can be a string that makes the file name unique.
Table 11-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 | - | - |
Invoice File to link multiple POs
Naming Convention: OBSCFCM-INVOICES-PO-BUYER_suffix.csv or OBSCFCM-INVOICES-PO-SELLER_suffix.csv
The file name should begin with ‘OBSCFCM-INVOICES-PO-BUYER’ or ‘OBSCFCM-INVOICES-PO-SELLER’. The suffix can be a string that makes the file name unique.
Table 11-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 | - | - | - |
Purchase Order File
Naming Convention: OBSCF-PURCHASE-ORDER-BUYER_suffix.csv or OBSCF-PURCHASE-ORDER-SELLER_suffix.csv
The file name should begin with ‘OBSCF-PURCHASE-ORDER-BUYER’ or ‘OBSCF-PURCHASE-ORDER-SELLER’. The suffix can be a string that makes the file name unique.
Table 11-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 | - | - | - |
Credit Note - Seller File
Naming Convention: OBSCF-CREDIT-NOTE-BUYER_suffix.csv or OBSCF-CREDIT-NOTE-SELLER_suffix.csv
The file name should begin with ‘OBSCF-CREDIT-NOTE-BUYER’ or ‘OBSCF-CREDIT-NOTE-SELLER'. The suffix can be a string that makes the file name unique.
Table 11-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 | - | - | - |
Debit Note - Buyer File
Naming Convention: OBSCF-DEBIT-NOTE-BUYER_suffix.csv or OBSCF-DEBIT-NOTE-SELLER_suffix.csv
The file name should begin with ‘OBSCF-DEBIT-NOTE-BUYER’ or ‘OBSCF-DEBIT-NOTE-SELLER’. The suffix can be a string that makes the file name unique.
Table 11-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