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.

Parent topic: File Upload