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 |
Parent topic: File Upload