Previous Next JavaScript must be enabled to correctly display this content

## 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 cashflow codes and cashflow transactions etc. 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 | EMAIL | 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-INVOICES-BUYER_suffix.csv or OBSCF-INVOICES-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 | - | - | -

1. On Home screen, click File Management. Under File Management, click File Upload.
   The File Upload screen displays.

   Figure 11-1 File Upload

   Description of "Figure 11-1 File Upload"
2. Drag and drop the file to be uploaded in the highlighted box. or, Click inside the highlighted box to select the file to be uploaded.
3. In the Enter Source Code field, specify the source code of the application to associate the file records to.
4. Click Upload to upload the records from the file. Once the file is uploaded, it cannot be deleted.
   A message appears stating that the file has been uploaded successfully.

Parent topic: File Management