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