Previous Next JavaScript must be enabled to correctly display this content

## 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.
33 | BANK_CHARGE_AMT | NUMBER | (28,4) | O | Bank Charge Amount
34 | DEDUC_AMT | NUMBER | (28,4) | O | Deduct Amount
35 | PMT_VALUE_DATE | DATE | YYYY-MM-DD | O | PMT Value date
36 | INDIRECT_PAYMENT | VARCHAR2 | 1 | O | Indirect Payment
37 | SOURCE_TXN_ID | VARCHAR2 | 40 | O | Source Txn Id
38 | MSG_TYPE | VARCHAR2 | 20 | O | Message Type

Parent topic: File Upload