Previous Next JavaScript must be enabled to correctly display this content

## 3.3 Invoice

This topics describes the information to perform the bulk upload for the Invoice in Oracle Banking Cash Management.

Table 3-5 Invoice File Upload

S.No | Attribute Name | Type | Characters | Mandatory/Optional | Description
--- | --- | --- | --- | --- | ---
1 | INDICATOR* | VARCHAR2 | 1 | M | This flag indicates the record type. “I” lists invoice details, “S” lists shipment details and “C” lists commodity details.
2 | INVOICE_NO* | VARCHAR2 | 25 | M | Invoice number given by the supplier is captured through this field.
3 | INVOICE_DATE* | DATE | - | M | Invoice date as provided by the supplier.
4 | INVOICE_DUE_DATE** | DATE | - | O | Mandatory based on the product. Will not be mandatory for dealer finance for example.
5 | BUYER_CODE** | VARCHAR2 | 100 | CM | At least one of buyer code/buyer ID is mandatory.
6 | SUPPLIER_CODE** | VARCHAR2 | 100 | CM | At least one of supplier code/supplier ID is mandatory.
7 | CURRENCY* | VARCHAR2 | 3 | M | Invoice Currency is captured through this field.
8 | BASE_INV_AMOUNT* | NUMBER | (28,4) | M | This field captures the base invoice amount, i.e. taxes and discounts if any are not reflected.
9 | NET_INV_AMOUNT* | NUMBER | (28,4) | M | Net invoice amount is the invoice amount after adjusting for taxes and discounts.
10 | TAX_AMOUNT | NUMBER | (28,4) | O | The tax amount charged against an invoice is captured in this field.
11 | DISCOUNT | NUMBER | - | O | The discount amount on the base invoice amount is captured in this field.
12 | PO_NUMBER | VARCHAR2 | 25 | O | The underlying PO number against an invoice may be captured in this field, if available.
13 | BUYER_DIV_CODE | VARCHAR2 | 20 | O | The division code of the buyer as maintained in the division code master may be captured in this field.
14 | SUPPLIER_DIV_CODE | VARCHAR2 | 20 | O | The division code of the supplier as maintained in the division code master may be captured in this field.
15 | DISPUTED | VARCHAR2 | 1 | O | Flag to capture if an invoice has been disputed by the buyer. Such invoices will not be financed.
16 | BUYER_ID** | VARCHAR2 | 20 | CM | At least one of buyer code/buyer ID is mandatory.
17 | SUPPLIER_ID** | VARCHAR2 | 20 | CM | At least one of supplier code/supplier ID is mandatory.
18 | BUYER_NAME | VARCHAR2 | 50 | CM | At least one of supplier code/supplier ID is mandatory.
19 | SUPPLIER_NAME | VARCHAR2 | 50 | CM | The supplier name as per the masters may be captured in this field. There will be no validations for the same.
20 | PREACCEPTED | VARCHAR2 | 1 | O | Flag to capture if an invoice is pre-accepted by the buyer. The maintenance for auto-acceptance of invoice will be validated.
21 | ACCEPTANCE_AMOUNT | NUMBER | (28,4) | O | Accepted Amount is always less than or equal to the net invoice amount.
22 | PROGRAM_ID | VARCHAR2 | 50 | O | Program ID may be input for invoices which require finance, where multiple programs exist between the supplier and buyer. If only one program is defined, the same can be derived by the system.
23 | VIRTUAL_AC_FLAG* | VARCHAR2 | 1 | CM | Flag to define if the repayment is to be made to a virtual account or to a physical account.
24 | REPAYMENT_AC_NO** | VARCHAR2 | 50 | CM | The account to which repayments may be made for an invoice. The same may be pre-defined at maintenance level itself.
25 | BANK** | VARCHAR2 | 200 | O | If repayment account is given and is not an account of the system bank (virtual or physical), bank, branch BIC become mandatory.
26 | BRANCH** | VARCHAR2 | 3 | O | If repayment account is given and is not an account of the system bank (virtual or physical), bank, branch BIC become mandatory.
27 | BIC_ROUTING_CODE** | NUMBER | 9 | O | If repayment account is given and is not an account of the system bank (virtual or physical), bank, branch BIC become mandatory.
28 | FUNDING_REQ_AMT | NUMBER | (28,4) | O | If repayment account is given and is not an account of the system bank (virtual or physical), bank, branch BIC become mandatory.
29 | FILLER1 | DATE | - | O | Filler fields to capture additional information.
30 | FILLER2 | VARCHAR2 | 25 | 0 | Filler fields to capture additional information.
31 | FILLER3 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
32 | FILLER4 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
33 | INVOICE_ID* | VARCHAR2 | 40 | O | Filler fields to capture additional information.
34 | FUNDING_REQ_DATE | DATE | - | O | Funding Date

Parent topic: File Upload