3.5 Credit Note

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

Table 3-7 Credit Note File Upload

S.No Attribute Name Type Character Mandatory/Optional Description
1 INDICATOR* VARCHAR2 1 M This flag indicates the record type. CN indicates Credit Note
2 CN_NO VARCHAR2 25 M Credit Note Reference Number provided by the client.
3 CN_ID VARCHAR2 25 O Credit Note Id from Channel.
4 LINK_INVOICE_NO VARCHAR2 25 O Invoice Numbers in pipe-separated format, if multiple.
5 CN_DATE DATE - Y Credit Note Date
6 CN_EXPIRY_DATE DATE - M Expiry Date of Credit Note.
7 BUYER_CODE* VARCHAR2 100 CM At least one of buyer code/buyer ID is mandatory
8 SUPPLIER_CODE** VARCHAR2 100 CM At least one of supplier code/supplier ID is mandatory.
9 CURRENCY* VARCHAR2 3 M Note Currency is captured through this field. This is always same as Invoice Currency.
10 BASE_CN_AMOUNT* NUMBER (28,4) O This field captures the base Note amount, i.e. taxes and discounts if any are not reflected.
11 NET_CN_AMOUNT* NUMBER (28,4) M Net Note amount is the Note amount after adjusting for taxes and discounts.
12 TAX_AMOUNT NUMBER (28,4) O The tax amount charged against a note is captured in this field.
13 DISCOUNT NUMBER - O The discount amount on the base note amount is captured in this field.
14 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.
15 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.
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 20 O Buyer Name
19 SUPPLIER_NAME VARCHAR2 20 O Supplier Name
20 PROGRAM_ID VARCHAR2 20 O Program ID may be input for Notes. In case, it is not provided, it may be derived.
21 ADJUST_REASON_CODE VARCHAR2 2 O Reason codes to be stored in the backend.
22 REMARKS VARCHAR2 200 O Field to capture Remarks.
23 FILLER1 DATE - O Filler fields to capture additional information.
24 FILLER2 DATE - O Filler fields to capture additional information.
25 FILLER3 VARCHAR2 25 O Filler fields to capture additional information.
26 FILLER4 VARCHAR2 25 O Filler fields to capture additional information.
27 FILLER5 VARCHAR2 25 O Filler fields to capture additional information.
28 FILLER6 VARCHAR2 25 O Filler fields to capture additional information.
29 FILLER7 VARCHAR2 25 O Filler fields to capture additional information.
30 FILLER8 VARCHAR2 25 O Filler fields to capture additional information.
31 FILLER9 VARCHAR2 25 O Filler fields to capture additional information.
32 FILLER10 VARCHAR2 25 O Filler fields to capture additional information.

Parent topic: File Upload