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