3.1 Invoice
Invoice File Upload is used for the bulk creation of Invoices.
File Naming Convention: OBSCF-INVOICE-BUYER_suffix or OBSCF-INVOICE-SELLER_suffix
For example: OBSCF-INVOICE-BUYER_27april2020
File Format: .csv
The following table describes the details of file structure of Invoices only.
Table 3-1 Invoice - File Structure
| Sequence Number | Field Name | Description | Data Type | Field Length | Mandatory (Y/CM/N) |
|---|---|---|---|---|---|
| 1 | INDICATOR | Invoice Buyer Indicator | VARCHAR2 | 1 | Y |
| 2 | INVOICE_NO | Invoice Number | VARCHAR2 | 40 | Y |
| 3 | INVOICE_DATE | Date of Invoice |
DATE Format: YYYY-MM-DD |
- | Y |
| 4 | INVOICE_DUE_DATE | Due Date of Invoice |
DATE Format: YYYY-MM-DD |
- | Y |
| 5 | CURRENCY | Currency of Invoice | VARCHAR2 | 3 | Y |
| 6 | BASE_INV_AMOUNT | Base invoice amount | NUMBER | 28,4 | Y |
| 7 | NET_INV_AMOUNT | Net invoice amount | NUMBER | 28,4 | N |
| 8 | PO_NUMBER | Purchase order Number | VARCHAR2 | 25 | N |
| 9 | DISPUTED | Whether Invoice is Disputed Y/N | VARCHAR2 | 1 | N |
| 10 | BUYER_ID | Buyer Id | VARCHAR2 | 20 | Y |
| 11 | SUPPLIER_ID | Supplier Id | VARCHAR2 | 20 | Y |
| 12 | PREACCEPTED | Invoice Pre-accept Flag Y/N | VARCHAR2 | 10 | N |
| 13 | ACCEPTANCE_AMOUNT | Invoice Acceptance Amount | NUMBER | 28,4 | N |
| 14 | PROGRAM_ID | Program Id | VARCHAR2 | - | N |
| 15 | VIRTUAL_AC_FLAG | Virtual Account Flag Y/N | VARCHAR2 | 1 | N |
| 16 | BANK | Name of the Bank | VARCHAR2 | 200 | N |
| 17 | BRANCH | Name of the Bank Branch | VARCHAR2 | 3 | N |
| 18 | BIC_ROUTING_CODE | BIC routing Code | VARCHAR2 | 9 | N |
| 19 | FUNDING_REQ_AMT | Amount of Funding required | NUMBER | 28,4 | N |
| 20 | FILLER1 | Additional Field |
DATE Format: YYYY-MM-DD |
- | N |
| 21 | FILLER2 | Additional Field | VARCHAR2 | 25 | N |
| 22 | FILLER3 | Additional Field | VARCHAR2 | 25 | N |
| 23 | FILLER4 | Additional Field | VARCHAR2 | 25 | N |
| 24 | INVOICE_ID | Invoice Id from Channel | VARCHAR2 | 40 | N |
The following table describes the details of file structure of Invoices with Commodities.
Table 3-2 Invoice with Commodity - File Structure
| Sequence Number | Field Name | Description | Data Type | Field Length | Mandatory (Y/CM/N) |
|---|---|---|---|---|---|
| 1 | INDICATOR | Invoice Buyer Indicator | VARCHAR2 | 1 | Y |
| 2 | INVOICE_NO | Invoice Number | VARCHAR2 | 40 | Y |
| 3 | INVOICE_DATE | Date of Invoice |
DATE Format: YYYY-MM-DD |
- | Y |
| 4 | INVOICE_DUE_DATE | Due Date of Invoice |
DATE Format: YYYY-MM-DD |
- | Y |
| 5 | BUYER_CODE | Code of the Buyer | VARCHAR2 | 100 | N |
| 6 | SUPPLIER_CODE | Code of the Supplier | VARCHAR2 | 100 | N |
| 7 | CURRENCY | Currency of Invoice | VARCHAR2 | 3 | Y |
| 8 | BASE_INV_AMOUNT | Base invoice amount | NUMBER | 28,4 | Y |
| 9 | NET_INV_AMOUNT | Net invoice amount | NUMBER | 28,4 | N |
| 10 | TAX_AMOUNT | Tax amount | NUMBER | 28,4 | N |
| 11 | DISCOUNT | Discount amount | NUMBER | - | N |
| 12 | PO_NUMBER | Purchase order Number | VARCHAR2 | 25 | N |
| 13 | BUYER_DIV_CODE | Buyer Division Code | VARCHAR2 | 20 | Y |
| 14 | SUPPLIER_DIV_CODE | Supplier Division Code | VARCHAR2 | 20 | Y |
| 15 | DISPUTED | Whether Invoice is Disputed Y/N | VARCHAR2 | 1 | N |
| 16 | BUYER_ID | Buyer Id | VARCHAR2 | 20 | Y |
| 17 | SUPPLIER_ID | Supplier Id | VARCHAR2 | 20 | Y |
| 18 | BUYER_NAME | Buyer Name | VARCHAR2 | 105 | CM |
| 19 | SUPPLIER_NAME | Supplier Name | VARCHAR2 | 105 | CM |
| 20 | PREACCEPTED | Invoice Pre-accept Flag Y/N | VARCHAR2 | 10 | N |
| 21 | ACCEPTANCE_AMOUNT | Invoice Acceptance Amount | NUMBER | 28,4 | N |
| 22 | PROGRAM_ID | Program Id | VARCHAR2 | - | N |
| 23 | VIRTUAL_AC_FLAG | Virtual Account Flag Y/N | VARCHAR2 | 1 | N |
| 24 | COLLECTION/REPAYMENT_AC_NO | Collection/Repayment Account Number | VARCHAR2 | 50 | N |
| 25 | BANK_NAME_FOR_CAN | Name of the Bank FOR CAN | VARCHAR | 200 | Mandatory if CAN is provided and BIC is null |
| 26 | BRANCH_NAME_FOR_CAN | Name of the Bank Branch of the CAN | VARCHAR | 3 | Mandatory if CAN is provided and BIC is null |
| 27 | BANK_IDENTIFIER_CODE for CAN | BANK_IDENTIFIER_CODE for CAN | VARCHAR | 11 | Optional |
| 28 | FUNDING_REQ_AMT | Amount of Funding required | NUMBER | 28,4 | N |
| 29 | FILLER1 | Additional Field |
DATE Format: YYYY-MM-DD |
- | N |
| 30 | FILLER2 | Additional Field | VARCHAR2 | 25 | N |
| 31 | FILLER3 | Additional Field | VARCHAR2 | 25 | N |
| 32 | FILLER4 | Additional Field | VARCHAR2 | 25 | N |
| 33 | INVOICE_ID | Invoice Id from Channel | VARCHAR2 | 40 | N |
| 34 | FUNDING_REQ_DATE | Funding Date |
DATE Format: YYYY-MM-DD |
- | N |
| 35 | ACCOUNT_NAME_FOR_CAN | User should mention the account name for Collection/Repayment account | VARCHAR2 | 200 | Mandatory if CAN is provided |
| 36 | PAYMENT_MODE_FOR_CAN |
User should mention whether it is an internal account transfer or EFT or Cross Border Transfer. Acceptable values are 'AC', 'EFT' or 'CBT' |
VARCHAR | 3 | Mandatory if CAN is provided |
| 37 | BENE_ADDR1_FOR_CAN |
User can enter the beneficiary's address line1 for Collection/Repayment Account Applicable only for CBT |
VARCHAR2 | 200 | Optional |
| 38 | BENE_ADDR2_FOR_CAN | User can enter the beneficiary's address line2 for Collection/Repayment Account | VARCHAR2 | 200 | Optional |
| 39 | BENE_ADDR3_FOR_CAN | User can enter the beneficiary's address line3 for Collection/Repayment Account | VARCHAR2 | 200 | Optional |
| 40 | BENE_ADDR4_FOR_CAN | User can enter the beneficiary's address line4 for Collection/Repayment Account | VARCHAR2 | 200 | Optional |
| 41 | BENE_CNTRY_FOR_CAN | User can enter the beneficiary's country for Collection/Repayment Account | VARCHAR2 | 50 | Optional |
| 42 | BENE_PHONE_FOR_CAN | User can enter the beneficiary's Phone number for Collection/Repayment Account | VARCHAR2 | 20 | Optional |
| 43 | BENE_EMAIL_FOR_CAN | User can enter the beneficiary's email id for Collection/Repayment Account | VARCHAR2 | 50 | Optional |
| 44 | INTERMEDIARY_BANK_CODE_FOR_CAN | User can enter the Intermediary bank swift code here if Payment Credit Mode is CBT | VARCHAR | 11 | Optional |
| 45 | INTERMEDIARY_BANK_NAME_FOR_CAN | User can mentioned the Intermediary Bank Name | VARCHAR | 200 | Optional |
| 46 | INTERMEDIARY_BANK_ADDR1_FOR_CAN | User can mentioned the Intermediary Bank Address | VARCHAR | 200 | Optional |
| 47 | INTERMEDIARY_BANK_ADDR2_FOR_CAN | User can mentioned the Intermediary Bank Address | VARCHAR2 | 200 | Optional |
| 48 | INTERMEDIARY_BANK_ADDR3_FOR_CAN | User can mentioned the Intermediary Bank Address | VARCHAR2 | 200 | Optional |
| 49 | INTERMEDIARY_BANK_ADDR4_FOR_CAN | User can mentioned the Intermediary Bank Address | VARCHAR2 | 200 | Optional |
| 50 | DISBURSEMENT_Credit_Account (hereafter referred as DCA) | User can enter an account number to receive the invoice payment. Can be a CASA or a GL account. IF its an IBAN number then should be mentioned in the same field. | VARCHAR | 50 | Optional |
| 51 | ACCOUNT_NAME_FOR_DCA | User should mention the account name for Disbursement credit account | VARCHAR2 | 200 | Mandatory if DCA is provided |
| 52 | PAYMENT_CREDIT_MODE_DCA | User should mention whether it is an internal account transfer or EFT or Cross Border Transfer. Acceptable values are 'AC', 'EFT' or 'CBT' | VARCHAR | 3 | Mandatory if DCA is provided |
| 53 | BENE_ADDR1_FOR_DCA |
User can enter the beneficiary's address line1 for Disbursement Credit Account Applicable only for CBT |
VARCHAR2 | 200 | Optional |
| 54 | BENE_ADDR2_FOR_DCA | User can enter the beneficiary's address line2 for Disbursement Credit Account | VARCHAR2 | 200 | Optional |
| 55 | BENE_ADDR3_FOR_DCA | User can enter the beneficiary's address line3 for Disbursement Credit Account | VARCHAR2 | 200 | Optional |
| 56 | BENE_ADDR4_FOR_DCA | User can enter the beneficiary's address line4 for Disbursement Credit Account | VARCHAR2 | 200 | Optional |
| 57 | BENE_CNTRY_FOR_DCA | User can enter the beneficiary's country for Disbursement Credit Account | VARCHAR2 | 50 | Optional |
| 58 | BENE_PHONE_FOR_DCA | User can enter the beneficiary's Phone number for Disbursement Account | VARCHAR2 | 20 | Optional |
| 59 | BENE_EMAIL_FOR_DCA | User can enter the beneficiary's email id for Disbursement Credit Account | VARCHAR2 | 50 | Optional |
| 60 | BANK_NAME_FOR_DCA | User can mentioned the Name of the Bank | VARCHAR | 200 | Mandatory if DCA is provided and BIC is null |
| 61 | BRANCH_NAME_FOR_DCA | User can mentioned the Branch code of the DCA | VARCHAR | 3 | Mandatory if DCA is provided and BIC is null |
| 62 | BANK_IDENTIFIER_CODE_FOR_DCA | User can enter the IFSC code here if Payment Credit Mode if EFT and can enter the swift BIC if the Payment credit mode is CBT | VARCHAR | 11 | Mandatory if DCA is provided and Bank Name is null |
| 63 | INTERMEDIARY_BANK_IDENTIFIER_CODE_FOR_DCA | User can enter the Intermediary bank swift code here if Payment Credit Mode is CBT | VARCHAR | 11 | Optional |
| 64 | INTERMEDIARY_BANK_NAME_FOR_DCA | User can mentioned the Intermediary Bank Name | VARCHAR | 200 | Optional |
| 65 | INTERMEDIARY_BANK_ADDR1_FOR_DCA | User can mentioned the Intermediary Bank Address | VARCHAR | 200 | Optional |
| 66 | INTERMEDIARY_BANK_ADDR2_FOR_DCA | User can mentioned the Intermediary Bank Address | VARCHAR2 | 200 | Optional |
| 67 | INTERMEDIARY_BANK_ADDR3_FOR_DCA | User can mentioned the Intermediary Bank Address | VARCHAR2 | 200 | Optional |
| 68 | INTERMEDIARY_BANK_ADDR4_FOR_DCA | User can mentioned the Intermediary Bank Address | VARCHAR2 | 200 | Optional |
| - | COMMODITIES CHILD RECORD | - | - | - | - |
| 1 | INDICATOR | Commodity Indicator | VARCHAR2 | 1 | CM |
| 2 | COMMODITY_CODE | Commodity Code | VARCHAR2 | 20 | CM |
| 3 | COMMODITY_NAME | Commodity Name | VARCHAR2 | 50 | CM |
| 4 | QUANTITY | Quantity | NUMBER | 28,4 | CM |
| 5 | UNIT_COST | Cost per Unit of the commodity | NUMBER | 28,4 | CM |
| 6 | TOTAL_COST | Total Cost of the commodity | NUMBER | 28,4 | CM |
| 7 | TAX_AMOUNT | Tax amount of the commodity | NUMBER | 28,4 | CM |
| 8 | DISCOUNT_AMOUNT | Discount amount of the commodity | NUMBER | 28,4 | CM |
| 9 | NET_COST | Net Amount of the commodity | NUMBER | 28,4 | CM |
Parent topic: File Upload