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 | REPAYMENT_AC_NO | Repayment Account Number | VARCHAR2 | 50 | N |
| 25 | BANK | Name of the Bank | VARCHAR2 | 200 | N |
| 26 | BRANCH | Name of the Bank Branch | VARCHAR2 | 3 | N |
| 27 | BIC_ROUTING_CODE | BIC routing Code | VARCHAR2 | 9 | N |
| 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 |
| - | 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