1. Receivables and Payables User Guide
  2. File Management
  3. Upload Files

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 format accepted by the system includes “.csv” files.

Table 11-1 Payment File - Supported Fields

Field Column 1 Field Column 2 Field Column 3 Field Column 4
DEBIT_CREDIT_INDIATOR VIRTUAL_AC_FLAG BENEFICIARY_ID FILLER1
PAYMENT_NO CREDIT_ACC_NO BENEFICIARY_NAME FILLER2
CURRENCY AUTO_RECONCILE PROGRAM_CODE FILLER3
AMOUNT FLAG REMITTER_ACC_NO FILLER4
GEN_APPROPRIATION ENTITY_REF_NO BANK_CODE FILLER5
SPEC_APPROPRIATION REMARKS EFT_REF_NO FILLER6
PAYMENT_MODE PAYMENT_PARTY_ID INSTRUMENT_DATE FILLER7
PAYMENT_DATE PAYMENT_PARTY_NAME INSTRUMENT_BANK FILLER8
PAYMENT_PARTY_CODE COUNTERPARTY_ID INSTRUMENT_BRANCH FILLER9
COUNTERPARTY_CODE COUNTERPARTY_NAME MANDATE_REF_NO FILLER10
- CREDIT_NOTE_REF_NO ALLOCATION_REQUIRED -

Table 11-2 Relationship File - Supported Fields

Field Column 1 Field Column 2 Field Column 3 Field Column 4
INDICATOR REGISTRATION_NUMBER ADDRESS_LINE_2 TAX_REF_NO_2
CORPORATE_ID PARTY_TYPE ADDRESS_LINE_3 GIIN
EFF_FROM_DATE STATUS ADDRESS_LINE_4 EXPIRES_ON
EXPIRES_ON PROGRAM_CODE PIN AUTO_DEBIT_APPLICABLE
AUTO_DEBIT_APPLICABLE NAME COUNTRY HOLIDAY_TREATMENT
HOLIDAY_TREATMENT SHORT_NAME PREFFERED_COMM_MODE AUTO_ACCEPTANCE
AUTO_ACCEPTANCE INDUSTRY MOBILE_NUMBER NO_OF_DAYS
NO_OF_DAYS CATEGORY PHONE_NUMBER EXTERNAL_CODE
INDICATOR ADDRESS_TYPE EMAIL DIVISION_CODE
CORPORATE_ID COUNTRY_CODE FAX_NUMBER CORPORATE_DIVISION_CODE
COUNTERPARTYID ADDRESS_LINE_1 TAX_REF_NO_1 -

Table 11-3 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

Table 11-4 Invoice File to link multiple POs - Supported Fields

Field Column 1 Field Column 2 Field Column 3 Field Column 4
INDICATOR TAX AMOUNT SUPPLY_ID BIC_ROUTING_CODE
INVOICE_NO DISCOUNT BUYER_NAME FUNDING_REQ_AMT
INVOICE_DATE DISCOUNT1 DAYS SUPPLIER_NAME FILLER1
INVOICE_VALUE_DATE DISCOUNT1 PERC PREACCEPTED FILLER2
INVOICE_DUE_DATE DISCOUNT2 DAYS ACCEPTANCE_AMOUNT FILLER3
BUYER_CODE DISCOUNT2 PERC PROGRAM_ID FILLER4
SUPPLIER_CODE BUYER_DIV_CODE VIRTUAL_AC_FLAG INVOICE_ID
CURRENCY SUPPLIER_DIV_CODE REPAYMENT_AC_NO FUNDING_REQ_DATE
BASE_INV_AMOUNT DISPUTED BANK NET PMT TERMS
NET_INV_AMOUNT BUYER_ID BRANCH PMT CONDITION
PO - - -
INDICATOR PO NUMBER INVOICE_AMOUNT_ALLOCATED -
COMMODITY - - -
INDICATOR COMMODITY_NAME TOTAL_COST NET_COST
PO_NUMBER QUANTITY TAX_AMOUNT -
COMMODITY_CODE UNIT_COST DISCOUNT_AMOUNT -

Table 11-5 Purchase Order File - Supported Fields

Field Column 1 Field Column 2 Field Column 3 Field Column 4
Indicator Supplier id Buyer Division Code City
External PO No Buyer Name Supplier Division Code Tax id
PO Date Supplier Name Pre Accepted Filler 1
Promised shipment Date Discount Amount Funding Request Amount Filler 2
Currency Tax Amount Shipment Address Filler 3
Base PO Amount Net PO Amount Country Filler 4
Buyer Id Acceptance Amount Zip Filler 5
- - - Filler 6
COMMODITY LIST - - -
Indicator Commodity Code Commodity Name Quantity
Cost per unit Total Cost Tax Amount Discount Amount
- - - Net Amount

Table 11-6 Credit Note – Seller File - Supported Fields

Field Column 1 Field Column 2 Field Column 3 Field Column 4
CN_NO TAX_AMOUNT REMARKS FILLER10
CN_ID DISCOUNT FILLER1 INVOICE_NUMBER
LINK_INVOICE_NO BUYER_DIV_CODE FILLER2 COMMODITY_CODE
CN_DATE SUPPLIER_DIV_CODE FILLER3 COMMODITY_NAME
CN_EXPIRY_DATE BUYER_ID FILLER4 QUANTITY
BUYER_CODE SUPPLIER_ID FILLER5 UNIT_COST
SUPPLIER_CODE BUYER_NAME FILLER6 TOTAL_COST
CURRENCY SUPPLIER_NAME FILLER7 TAX_AMOUNT
BASE_CN_AMOUNT PROGRAM_ID FILLER8 DISCOUNT_AMOUNT
NET_CN_AMOUNT ADJUST_REASON_CODE FILLER9 NET_COST

Table 11-7 Debit Note – Buyer File - Supported Fields

Field Column 1 Field Column 2 Field Column 3 Field Column 4
DN_NO DISPUTED ADJUST_REASON_CODE SHIPMENT_ADDRESS
DN_ID BUYER_ID REMARKS SHIPMENT_COUNTRY
LINK_INVOICE_NO SUPPLIER_ID FILLER1 EXPORT_REASON
DN_DATE BUYER_NAME FILLER2 SALE_TERMS
DN_DUE_DATE SUPPLIER_NAME FILLER3 PAYMENT_TERMS
BUYER_CODE PREACCEPTED FILLER4 COUNTRY_OF_ORIGIN
SUPPLIER_CODE ACCEPTANCE_AMOUNT FILLER5 INVOICE_NUMBER
CURRENCY PROGRAM_ID FILLER6 COMMODITY_CODE
BASE_DN_AMOUNT VIRTUAL_AC_FLAG FILLER7 COMMODITY_NAME
NET_DN_AMOUNT REPAYMENT_AC_NO FILLER8 QUANTITY
TAX_AMOUNT BANK FILLER9 UNIT_COST
DISCOUNT BRANCH FILLER10 TOTAL_COST
BUYER_DIV_CODE BIC_ROUTING_CODE SHIPMENT_NO TAX_AMOUNT
SUPPLIER_DIV_CODE FUNDING_REQ_AMT SHIPMENT_DATE DISCOUNT_AMOUNT
- - - NET_COST
Specify User ID and Password, and login to Home screen.
  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 follows
    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