Previous Next JavaScript must be enabled to correctly display this content

## 3.2 Payment

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

Table 3-4 Payment File Upload

S.No | Attribute Name | Type | Character | Mandatory/Optional | Description
--- | --- | --- | --- | --- | ---
1 | DEBIT_CREDIT_INDIATOR | VARCHAR2 | 1 | M | Debit/Credit Indicator
2 | PAYMENT_NO | VARCHAR2 | 50 | M | Reference number of core/payment
3 | CURRENCY | VARCHAR2 | 3 | M | Payment Currency
4 | AMOUNT | NUMBER | (28,4) | M | Payment Amount
5 | GEN_APPROPRIATION | VARCHAR2 | 3 | O | Generic Appropriation
6 | SPEC_APPROPRIATION | VARCHAR2 | 50 | O | Specific Appropriation
7 | PAYMENT_MODE | VARCHAR2 | 20 | M | Different modes of payment such as Account Transfer, EFT, Cheque or Cash
8 | PAYMENT_DATE | DATE | - | M | Date of Payment
9 | PAYMENT_PARTY_CODE | VARCHAR2 | 30 | O | External Code of the Payment Party
10 | COUNTERPARTY_CODE | VARCHAR2 | 30 | O | External Code of the Counter Party
11 | VIRTUAL_AC_FLAG | VARCHAR2 | 1 | O | Virtual Account Flag Y/N
12 | CREDIT_ACC_NO | VARCHAR2 | 35 | CM | Credit account number
13 | AUTO_RECONCILE | VARCHAR2 | 1 | M | Auto Reconciliation Y/N
14 | FLAG | VARCHAR2 | 1 | O | Send as F for Finance Recon, I for InvoiceRecon
15 | ENTITY_REF_NO | VARCHAR2 | 50 | O | Entity Reference Number
16 | REMARKS | VARCHAR2 | 150 | O | Remarks
17 | PAYMENT_PARTY_ID | VARCHAR2 | 20 | O | Payment Party Id
18 | PAYMENT_PARTY_NAME | VARCHAR2 | 50 | O | Name of Payment Party
19 | COUNTERPARTY_ID | VARCHAR2 | 20 | O | Counter Party Id
20 | COUNTERPARTY_NAME | VARCHAR2 | 50 | O | Name of Counter Party
21 | BENEFICIARY_ID | VARCHAR2 | 20 | O | Beneficiary Party Id
22 | BENEFICIARY_NAME | VARCHAR2 | 50 | O | Name of Beneficiary
23 | PROGRAM_CODE | VARCHAR2 | 20 | O | Program id basis Payment party id and Bene code
24 | REMITTER_ACC_NO | VARCHAR2 | 35 | O | Remitter Account number
25 | BANK_CODE | VARCHAR2 | 30 | O | IFSC Code of Remitter Bank
26 | EFT_REF_NO | VARCHAR2 | 50 | O | Electronic Fund Transfer Reference Number
27 | INSTRUMENT_DATE | DATE | - | O | Date of the Instrument like cheque etc
28 | INSTRUMENT_BANK | VARCHAR2 | 50 | O | Bank Name of the Instrument presented
29 | INSTRUMENT_BRANCH | VARCHAR2 | 50 | O | Branch of the Instrument presented
30 | MANDATE_REF_NO | VARCHAR2 | 35 | O | Reference number of Mandate
31 | CREDIT_NOTE_REF_NO | VARCHAR2 | 35 | O | Reference number of Credit Note
32 | ALLOCATION_REQUIRED | VARCHAR2 | 1 | M | Allocation to Virtual Account Y/N
33 | FILLER1 | VARCHAR2 | 25 | O | Additional Field
34 | FILLER2 | VARCHAR2 | 25 | O | Additional Field
35 | FILLER3 | VARCHAR2 | 25 | O | Additional Field
36 | FILLER4 | VARCHAR2 | 25 | O | Additional Field
37 | FILLER5 | VARCHAR2 | 25 | O | Additional Field
38 | FILLER6 | VARCHAR2 | 25 | O | Additional Field
39 | FILLER7 | VARCHAR2 | 25 | O | Additional Field
40 | FILLER8 | VARCHAR2 | 25 | O | Additional Field
41 | FILLER9 | VARCHAR2 | 25 | O | Additional Field
42 | FILLER10 | VARCHAR2 | 25 | O | Additional Field
43 | IS_PUA | VARCHAR2 | 1 | O | At the time of reconciliation of incoming payment with Invoice, OBCM application checks if the value is Y in payment record, then the application should mark the reconciled invoice record as PUA.
44 | BANK_CHARGE_AMT | NUMBER(28,4) | - | O | Bank Charge Amount
45 | DEDUC_AMT | NUMBER(28,4) | - | O | Deduction Amount
46 | INST_CLEARED | VARCHAR2 | 1 | O | Instrument Cleared
47 | INDIRECT_PAYMENT | VARCHAR2 | 1 | O | Indirect Payment
48 | PORTAL_REFERENCE | VARCHAR2 | 255 | O | Portal Reference
49 | SOURCE_TXN_ID | VARCHAR2 | 40 | O | Portal Reference
50 | MSG_TYPE | VARCHAR2 | 20 | O | Portal Reference

Parent topic: File Upload