Previous Next JavaScript must be enabled to correctly display this content

## 3.4 Debit Note

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

Table 3-6 Debit Note File Upload

S.No | Attribute Name | Type | Character | Mandatory/Optional | Description
--- | --- | --- | --- | --- | ---
1 | INDICATOR* | VARCHAR2 | 1 | M | This flag indicates the record type. For Debit Notes indicator will be DN.
2 | DN_NO | VARCHAR2 | 25 | M | Debit Note Reference Number provided by the client.
3 | DN_ID | VARCHAR2 | 40 | O | Debit Note ID from Channel.
4 | LINK_INVOICE_NO | VARCHAR2 | 25 | O | Invoice Numbers in pipe-separated format, if multiple. Invoices with same currency as debit note currency should be allowed, otherwise the record should get rejected with appropriate message.
5 | DN_DATE | DATE | - | M | Debit Note Date.
6 | DN_DUE_DATE | DATE | - | M | Debit Note Due Date.
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 | Currency of Debit Note.
10 | BASE_DN_AMOUNT* | NUMBER | (28,4) | O | This field captures the base Note amount, i.e. taxes and discounts if any are not reflected.
11 | NET_DN_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 | (28,4) | 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 | DISPUTED | VARCHAR2 | 1 | O | Flag to capture if an Note has been disputed by the buyer.
17 | BUYER_ID** | VARCHAR2 | 20 | CM | At least one of buyer code/buyer ID is mandatory.
18 | SUPPLIER_ID** | VARCHAR2 | 20 | CM | At least one of supplier code/supplier ID is mandatory.
19 | BUYER_NAME | VARCHAR2 | 50 | O | Name of the Buyer
20 | SUPPLIER_NAME | VARCHAR2 | 50 | O | Name of the Supplier
21 | PREACCEPTED | VARCHAR2 | 1 | O | Flag Whether Debit Note is Preaccepted Y/N
22 | ACCEPTANCE_AMOUNT | NUMBER | (28,4) | O | Less than or equal to debit note amount.
23 | PROGRAM_ID | VARCHAR2 | 50 | O | Program ID may be input for Notes. In case, if not provided, application will derive the same for OBSCF and OBSCFCM application codes.
24 | 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.
25 | REPAYMENT_AC_NO** | VARCHAR2 | 50 | CM | The account to which repayments may be made for an Note.
26 | BANK** | VARCHAR2 | 200 | O | Name of the Bank.
27 | BRANCH** | VARCHAR2 | 3 | O | Name of the Bank Branch.
28 | BIC_ROUTING_CODE*** | NUMBER | 9 | O | BIC code/Routing code.
29 | FUNDING_REQ_AMT | NUMBER | (28,4) | O | Should be less than or equal to Acceptance Amount.
30 | ADJUST_REASON_CODE | VARCHAR2 | 70 | O | Reason codes to be stored in the backend.
31 | REMARKS | VARCHAR2 | 400 | O | Field to capture Remarks.
32 | FILLER1 | DATE | - | O | Filler fields to capture additional information.
33 | FILLER2 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
34 | FILLER3 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
35 | FILLER4 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
36 | FILLER5 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
37 | FILLER6 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
38 | FILLER7 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
39 | FILLER8 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
40 | FILLER9 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
41 | FILLER10 | VARCHAR2 | 25 | O | Filler fields to capture additional information.
42 | SHIPMENT_NO | VARCHAR2 | 100 | O | Reference number of Shipment.
43 | SHIPMENT_DATE | DATE | - | O | Date of Shipment.
44 | SHIPMENT_ADDRESS | VARCHAR2 | 150 | O | Destination address of shipment.
45 | SHIPMENT_COUNTRY | VARCHAR2 | 3 | O | Destination Country.
46 | EXPORT_REASON | VARCHAR2 | 50 | O | Reason of Export.
47 | SALE_TERMS | VARCHAR2 | 3 | O | Any of the Incoterms (as per ICC 2020) may be provided.
48 | PAYMENT_TERMS | VARCHAR2 | 150 | O | Terms of Payment.
49 | COUNTRY_OF_ORIGIN | VARCHAR2 | 3 | O | Country of Origin of Shipment.
50 | FUNDING_REQ_DATE | DATE | - | N | Funding Date
51 | ACCOUNT_NAME_FOR_CAN | VARCHAR2 | 200 | N | Account Name For Collection.
52 | PAYMENT_MODE_FOR_CAN | VARCHAR2 | 50 | N | Payment Mode For Collection
53 | BENE_ADDR1_FOR_CAN | VARCHAR2 | 200 | N | Bene Addr1 For Collection.
54 | BENE_ADDR2_FOR_CAN | VARCHAR2 | 200 | N | Bene Addr2 For Collection.
55 | BENE_ADDR3_FOR_CAN | VARCHAR2 | 200 | N | Bene Addr3 For Collection.
56 | BENE_ADDR4_FOR_CAN | VARCHAR2 | 200 | N | Bene Addr4 For Collection.
57 | BENE_CNTRY_FOR_CAN | VARCHAR2 | 3 | N | Bene Cntry For Collection.
58 | BENE_PHONE_FOR_CAN | NUMBER | - | N | Bene Phone For Collection.
59 | BENE_EMAIL_FOR_CAN | VARCHAR2 | 150 | N | Bene Email For Collection.
60 | INTERMEDIARY_BANK_CODE_FOR_CAN | VARCHAR2 | 9 | N | Intermediary Bank Code For Collection.
61 | INTERMEDIARY_BANK_NAME_FOR_CAN | VARCHAR2 | 200 | N | Intermediary Bank Name For Collection.
62 | INTERMEDIARY_BANK_ADDR1_FOR_CAN | VARCHAR2 | 200 | N | Intermediary Bank Addr1 For Collection.
63 | INTERMEDIARY_BANK_ADDR2_FOR_CAN | VARCHAR2 | 200 | N | Intermediary Bank Addr2 For Collection.
64 | INTERMEDIARY_BANK_ADDR3_FOR_CAN | VARCHAR2 | 200 | N | Intermediary Bank Addr3 For Collection.
65 | INTERMEDIARY_BANK_ADDR4_FOR_CAN | VARCHAR2 | 200 | N | Intermediary Bank Addr4 For Collection.
66 | DISBURSEMENT_CREDT_ACCOUNT | VARCHAR2 | 200 | N | Disbursement Credt Account.
67 | ACCOUNT_NAME_FOR_DCA | VARCHAR2 | 200 | N | Account Name For Dca.
68 | PAYMENT_MODE_FOR_DCA | VARCHAR2 | 50 | N | Payment Mode For Dca.
69 | BENE_ADDR1_FOR_DCA | VARCHAR2 | 200 | N | Bene Addr1 For Dca.
70 | BENE_ADDR2_FOR_DCA | VARCHAR2 | 200 | N | Bene Addr2 For Dca.
71 | BENE_ADDR3_FOR_DCA | VARCHAR2 | 200 | N | Bene Addr3 For Dca.
72 | BENE_ADDR4_FOR_DCA | VARCHAR2 | 200 | N | Bene Addr4 For Dca.
73 | BENE_CNTRY_FOR_DCA | VARCHAR2 | 3 | N | Bene Cntry For Dca.
74 | BENE_PHONE_FOR_DCA | NUMBER | - | N | Bene Phone For Dca.
75 | BENE_EMAIL_FOR_DCA | VARCHAR2 | 150 | N | Bene Email For Dca.
76 | BANK_NAME_FOR_DCA | VARCHAR2 | 200 | N | Bank Name For Dca.
77 | BRANCH_NAME_FOR_DCA | VARCHAR2 | 50 | N | Branch Name For Dca.
78 | BANK_IDENTIFIER_CODE_FOR_DCA | VARCHAR2 | 9 | N | Bank Identifier Code For Dca.
79 | INTERMEDIARY_BANK_CODE_FOR_DCA | VARCHAR2 | 9 | N | Intermediary Bank Code For Dca.
80 | INTERMEDIARY_BANK_NAME_FOR_DCA | VARCHAR2 | 200 | N | Intermediary Bank Name For Dca.
81 | INTERMEDIARY_BANK_ADDR1_FOR_DCA | VARCHAR2 | 200 | N | Intermediary Bank Addr1 For Dca.
82 | INTERMEDIARY_BANK_ADDR2_FOR_DCA | VARCHAR2 | 200 | N | Intermediary Bank Addr2 For Dca.
83 | INTERMEDIARY_BANK_ADDR3_FOR_DCA | VARCHAR2 | 200 | N | Intermediary Bank Addr3 For Dca.
84 | INTERMEDIARY_BANK_ADDR4_FOR_DCA | VARCHAR2 | 200 | N | Intermediary Bank Addr4 For Dca.
85 | SHIPMENT_ADDRESS2 | VARCHAR2 | 105 | N | Shipment Address line 2
86 | SHIPMENT_ADDRESS3 | VARCHAR2 | 105 | N | Shipment Address line 3
87 | SHIPMENT_ADDRESS4 | VARCHAR2 | 105 | N | Shipment Address line 4

Parent topic: File Upload