3.3 Credit Note
Credit Note File Upload is used for the bulk creation of Credit Notes.
File Naming Convention: OBSCF-CREDIT-NOTE-BUYER_suffix or OBSCF-CREDIT-NOTE-SELLER_suffix
For example: OBSCF-CREDIT-NOTE-BUYER_04Sep2023
File Format: .csv
The following table describes the details of file structure.
Table 3-4 Credit Note - File Structure
| Sequence Number | Field Name | Description | Data Type | Field Length | Mandatory (Y/CM/N) |
|---|---|---|---|---|---|
| 1 | INDICATOR | Credit Note Indicator | VARCHAR2 | 1 | Y |
| 2 | CN_NO | Credit Note Reference Number | VARCHAR2 | 25 | Y |
| 3 | CN_ID | Credit Note Id from Channel | VARCHAR2 | 25 | N |
| 4 | LINK_INVOICE_NO | Invoice Numbers | VARCHAR2 | 25 | N |
| 5 | CN_DATE | Credit Note Date |
DATE Format: YYYY-MM-DD |
- | Y |
| 6 | CN_EXPIRY_DATE | Expiry Date of Credit Note |
DATE Format: YYYY-MM-DD |
- | Y |
| 7 | BUYER_CODE | Code of the Buyer | VARCHAR2 | 100 | N |
| 8 | SUPPLIER_CODE | Code of the Supplier | VARCHAR2 | 100 | N |
| 9 | CURRENCY | Currency of Credit Note | VARCHAR2 | 3 | Y |
| 10 | BASE_CN_AMOUNT | Base Credit Note Amount | NUMBER | 28,4 | N |
| 11 | NET_CN_AMOUNT | Net Credit Note Amount | NUMBER | 28,4 | N |
| 12 | TAX_AMOUNT | Tax amount | NUMBER | 28,4 | N |
| 13 | DISCOUNT | Discount on Credit Note Amount | NUMBER | 28,4 | N |
| 14 | BUYER_DIV_CODE | Buyer Division Code | VARCHAR2 | 20 | N |
| 15 | SUPPLIER_DIV_CODE | Supplier Division Code | VARCHAR2 | 20 | N |
| 16 | BUYER_ID | Buyer Id | VARCHAR2 | 20 | Y |
| 17 | SUPPLIER_ID | Supplier Id | VARCHAR2 | 20 | Y |
| 18 | BUYER_NAME | Buyer Name | VARCHAR2 | 105 | N |
| 19 | SUPPLIER_NAME | Supplier Name | VARCHAR2 | 105 | N |
| 20 | PROGRAM_ID | Program Id | VARCHAR2 | 20 | N |
| 21 | ADJUST_REASON_CODE | Reason for Adjustment | VARCHAR2 | 2 | N |
| 22 | REMARKS | Remarks | VARCHAR2 | 200 | N |
| 23 | FILLER1 | Additional Field |
DATE Format: YYYY-MM-DD |
- | N |
| 24 | FILLER2 | Additional Field |
DATE Format: YYYY-MM-DD |
- | N |
| 25 | FILLER3 | Additional Field | VARCHAR2 | 25 | N |
| 26 | FILLER4 | Additional Field | VARCHAR2 | 25 | N |
| 27 | FILLER5 | Additional Field | VARCHAR2 | 25 | N |
| 28 | FILLER6 | Additional Field | VARCHAR2 | 25 | N |
| 29 | FILLER7 | Additional Field | VARCHAR2 | 25 | N |
| 30 | FILLER8 | Additional Field | VARCHAR2 | 25 | N |
| 31 | FILLER9 | Additional Field | VARCHAR2 | 25 | N |
| 32 | FILLER10 | Additional Field | VARCHAR2 | 25 | N |
| - | COMMODITIES CHILD RECORD | - | - | - | - |
| 1 | INDICATOR | Commodity Indicator | VARCHAR2 | 1 | CM |
| 2 | INVOICE_NUMBER | Invoice Number | VARCHAR2 | 25 | CM |
| 3 | COMMODITY_CODE | Commodity Code | VARCHAR2 | 20 | CM |
| 4 | COMMODITY_NAME | Commodity Name | VARCHAR2 | 50 | CM |
| 5 | QUANTITY | Quantity | NUMBER | 28,4 | CM |
| 6 | UNIT_COST | Cost per Unit of the commodity | NUMBER | 28,4 | CM |
| 7 | TOTAL_COST | Total Cost of the commodity | NUMBER | 28,4 | CM |
| 8 | TAX_AMOUNT | Tax amount of the commodity | NUMBER | 28,4 | CM |
| 9 | DISCOUNT_AMOUNT | Discount amount of the commodity | NUMBER | 28,4 | CM |
| 10 | NET_COST | Net Amount of the commodity | NUMBER | 28,4 | CM |
Parent topic: File Upload