| Item Name | Item Description | Item Depends On | It Ext Column | Item Key | Item Id |
| Address Line 1 | The first address line of the payment. | Payments.Address Line 1 | ADDRESS_LINE_1 | ADDRESS_LINE_1 | 115092 |
| Address Line 2 | The second address line of the payment. | Payments.Address Line 2 | ADDRESS_LINE_2 | ADDRESS_LINE_2 | 115103 |
| Address Line 3 | The third address line of the payment. | Payments.Address Line 3 | ADDRESS_LINE_3 | ADDRESS_LINE_3 | 115112 |
| Amount | Payment amount. | Payments.Amount | AMOUNT | AMOUNT | 115853 |
| Bank Account ID | The Unique system ID of the bank account | Payments.Bank Account ID | BANK_ACCOUNT_ID | BANK_ACCOUNT_ID | 119005 |
| Bank Account Name | The name of the bank account | Payments.Bank Account Name | BANK_ACCOUNT_NAME | BANK_ACCOUNT_NAME | 119024 |
| Check Date | Payment date. | Payments.Check Date | CHECK_DATE | PAYMENT_DOCUMENT_DATE | 152201 |
| Check Id | Payment unique identifier. | Payments.Check Id | CHECK_ID | PAYMENT_DOCUMENT_ID | 152202 |
| Check Number | Payment number. | Payments.Check Number | CHECK_NUMBER | PAYMENT_DOCUMENT_NUMBER | 152203 |
| Check Sequence Number | Payment document sequence number. | Payments.Check Sequence Number | CHECK_SEQUENCE_NUMBER | PAYMENT_SEQUENCE_NUMBER | 152253 |
| Check Voucher Number | | Payments.Check Voucher Number | CHECK_VOUCHER_NUMBER | CHECK_VOUCHER_NUMBER | 121969 |
| Checkrun Name | The payment batch name. (index) | Payments.Checkrun Name | CHECKRUN_NAME | CHECKRUN_NAME | 121956 |
| Cleared Amount | The payment amount that cleared the bank. | Payments.Cleared Amount | CLEARED_AMOUNT | CLEARED_AMOUNT | 122138 |
| Cleared Charges Amount | Cleared payment charges amount. | Payments.Cleared Charges Amount | CLEARED_CHARGES_AMOUNT | CLEARED_CHARGES_AMOUNT | 122140 |
| Cleared Charges Functional Amount | Cleared payment charges base amount. | Payments.Cleared Charges Functional Amount | CLEARED_CHARGES_FUNCTIONAL_AMT | CLEARED_CHARGES_FUNCTIONAL_AMT | 122141 |
| Cleared Currency Exchange Date | Date the clearing exchange rate is effective. Usually accounting date of a transaction. | Payments.Cleared Currency Exchange Date | CLEARED_CURRENCY_EXCH_DATE | CLEARED_CURRENCY_EXCH_DATE | 122143 |
| Cleared Currency Exchange Date - Day | | Payments.Cleared Currency Exchange Date | | CLEARED_CURRENCY_EXCH_DATE_DAY | 170495 |
| Cleared Currency Exchange Date - Month | | Payments.Cleared Currency Exchange Date | | CLEARED_CURRENCY_EXCH_DATE_MONTH | 170497 |
| Cleared Currency Exchange Date - Quarter | | Payments.Cleared Currency Exchange Date | | CLEARED_CURRENCY_EXCH_DATE_QUARTER | 170499 |
| Cleared Currency Exchange Date - Year | | Payments.Cleared Currency Exchange Date | | CLEARED_CURRENCY_EXCH_DATE_YEAR | 170501 |
| Cleared Currency Exchange Rate | Exchange rate at which the payment cleared. For foreign currency payments only. | Payments.Cleared Currency Exchange Rate | CLEARED_CURRENCY_EXCH_RATE | CLEARED_CURRENCY_EXCH_RATE | 122144 |
| Cleared Currency Exchange Rate Type | Exchange rate type at payment clearing time. For foreign currency payments only. | Payments.Cleared Currency Exchange Rate Type | CLEARED_CRNCY_EXCH_RATE_TYPE | CLEARED_CRNCY_EXCH_RATE_TYPE | 122142 |
| Cleared Date | Payment cleared date. | Payments.Cleared Date | CLEARED_DATE | CLEARED_DATE | 122145 |
| Cleared Date - Day | | Payments.Cleared Date | | CLEARED_DATE_DAY | 170503 |
| Cleared Date - Month | | Payments.Cleared Date | | CLEARED_DATE_MONTH | 170505 |
| Cleared Date - Quarter | | Payments.Cleared Date | | CLEARED_DATE_QUARTER | 170507 |
| Cleared Date - Year | | Payments.Cleared Date | | CLEARED_DATE_YEAR | 170509 |
| Cleared Error Amount | Cleared payment error amount. | Payments.Cleared Error Amount | CLEARED_ERROR_AMOUNT | CLEARED_ERROR_AMOUNT | 122146 |
| Cleared Error Functional Amount | Cleared payment error in functional amount. | Payments.Cleared Error Functional Amount | CLEARED_ERROR_FUNCTIONAL_AMT | CLEARED_ERROR_FUNCTIONAL_AMT | 122147 |
| Cleared Functional Amount | Payment cleared amount in functional currency. | Payments.Cleared Functional Amount | CLEARED_FUNCTIONAL_AMOUNT | CLEARED_FUNCTIONAL_AMOUNT | 122148 |
| Context Value | | Payments.Context Value | GLBL_CONTEXT_VALUE | GLBL_CONTEXT_VALUE | 266410 |
| Created By | Standard WHO column. | Payments.Created By | CREATED_BY | CREATED_BY | 124518 |
| Creation Date | Standard WHO column. | Payments.Creation Date | CREATION_DATE | CREATION_DATE | 125950 |
| Currency Code | Currency code for this transaction | Payments.Currency Code | CURRENCY_CODE | CURRENCY_CODE | 126992 |
| Currency Exchange Date | Date exchange rate is effective. Usually the accounting date of the transaction. | Payments.Currency Exchange Date | CURRENCY_EXCHANGE_DATE | CURRENCY_EXCHANGE_DATE | 127190 |
| Currency Exchange Date - Day | | Payments.Currency Exchange Date | | CURRENCY_EXCHANGE_DATE_DAY | 174170 |
| Currency Exchange Date - Month | | Payments.Currency Exchange Date | | CURRENCY_EXCHANGE_DATE_MONTH | 174174 |
| Currency Exchange Date - Quarter | | Payments.Currency Exchange Date | | CURRENCY_EXCHANGE_DATE_QUARTER | 174178 |
| Currency Exchange Date - Year | | Payments.Currency Exchange Date | | CURRENCY_EXCHANGE_DATE_YEAR | 174182 |
| Currency Exchange Rate | Exchange rate for foreign currency payments. | Payments.Currency Exchange Rate | CURRENCY_EXCHANGE_RATE | CURRENCY_EXCHANGE_RATE | 127192 |
| Currency Exchange Rate Type | Exchange rate type for foreign currency payments. | Payments.Currency Exchange Rate Type | CURRENCY_EXCHANGE_RATE_TYPE | CURRENCY_EXCHANGE_RATE_TYPE | 127216 |
| External Bank Account ID | The Unique system ID of the External bank account | Payments.External Bank Account ID | EXTERNAL_BANK_ACCOUNT_ID | EXTERNAL_BANK_ACCOUNT_ID | 134147 |
| Functional Amount | Payment amount in functional currency. | Payments.Functional Amount | FUNCTIONAL_AMOUNT | FUNCTIONAL_AMOUNT | 134883 |
| Future Pay Due Date | Negotiable date for future dated payment. | Payments.Future Pay Due Date | FUTURE_PAY_DUE_DATE | FUTURE_PAY_DUE_DATE | 134971 |
| Future Pay Due Date - Day | | Payments.Future Pay Due Date | | FUTURE_PAY_DUE_DATE_DAY | 180575 |
| Future Pay Due Date - Month | | Payments.Future Pay Due Date | | FUTURE_PAY_DUE_DATE_MONTH | 180579 |
| Future Pay Due Date - Quarter | | Payments.Future Pay Due Date | | FUTURE_PAY_DUE_DATE_QUARTER | 180583 |
| Future Pay Due Date - Year | | Payments.Future Pay Due Date | | FUTURE_PAY_DUE_DATE_YEAR | 180587 |
| Last Update Date | Standard WHO column. | Payments.Last Update Date | LAST_UPDATE_DATE | LAST_UPDATE_DATE | 140481 |
| Last Updated By | Standard WHO column. | Payments.Last Updated By | LAST_UPDATED_BY | LAST_UPDATED_BY | 139142 |
| Payment Delivery Date | | Payments.Payment Delivery Date | GLBL_PAYMENT_DELIVERY_DATE_2 | GLBL_PAYMENT_DELIVERY_DATE_2 | 266411 |
| Payment Document Date - Day | | Payments.Check Date | | PAYMENT_DOCUMENT_DATE_DAY | 187607 |
| Payment Document Date - Month | | Payments.Check Date | | PAYMENT_DOCUMENT_DATE_MONTH | 187609 |
| Payment Document Date - Quarter | | Payments.Check Date | | PAYMENT_DOCUMENT_DATE_QUARTER | 187611 |
| Payment Document Date - Year | | Payments.Check Date | | PAYMENT_DOCUMENT_DATE_YEAR | 187613 |
| Payment Method | | Payments.Payment Method | PAYMENT_METHOD | PAYMENT_METHOD | 152218 |
| Payment Method Descr | | Payments.Payment Method Descr | PAYMENT_METHOD_DESCR | PAYMENT_METHOD_DESCR | 266409 |
| Payment Status | Status of payment (for example, negotiable). | Payments.Payment Status | PAYMENT_STATUS | PAYMENT_STATUS | 152255 |
| Payment Status Descr | | Payments.Payment Status Descr | PAYMENT_STATUS_DESCR | PAYMENT_STATUS_DESCR | 266408 |
| Payment Type | Flag that indicates payment type. | Payments.Payment Type | PAYMENT_TYPE | PAYMENT_TYPE | 152309 |
| Payment Type Descr | | Payments.Payment Type Descr | PAYMENT_TYPE_DESCR | PAYMENT_TYPE_DESCR | 266407 |
| Stamp Duty Amount | Stamp duty tax amount. | Payments.Stamp Duty Amount | STAMP_DUTY_AMOUNT | STAMP_DUTY_AMOUNT | 162818 |
| Stamp Duty Functional Amount | Stamp duty tax amount in functional currency. | Payments.Stamp Duty Functional Amount | STAMP_DUTY_FUNCTIONAL_AMOUNT | STAMP_DUTY_FUNCTIONAL_AMOUNT | 162819 |
| Stop Payment Recorded Date | Date and time user recorded stop payment. | Payments.Stop Payment Recorded Date | STOP_PAYMENT_RECORDED_DATE | STOP_PAYMENT_RECORDED_DATE | 163694 |
| Stop Payment Recorded User Id | User who recorded stop payment. | Payments.Stop Payment Recorded User Id | STOP_PAYMENT_RECORDED_USER_ID | STOP_PAYMENT_RECORDED_USER_ID | 163695 |
| Stop Payment Released Date | Date and time user released stop payment. | Payments.Stop Payment Released Date | STOP_PAYMENT_RELEASED_DATE | STOP_PAYMENT_RELEASED_DATE | 163696 |
| Stop Payment Released User Id | User who released stop payment. | Payments.Stop Payment Released User Id | STOP_PAYMENT_RELEASED_USER_ID | STOP_PAYMENT_RELEASED_USER_ID | 163697 |
| Supplier Tax Invoice Number | | Payments.Supplier Tax Invoice Number | GLBL_SUPPLIER_TAX_INVOICE_NU_2 | GLBL_SUPPLIER_TAX_INVOICE_NU_2 | 266414 |
| Tax Accounting Period | | Payments.Tax Accounting Period | GLBL_TAX_ACCOUNTING_PERIOD_2 | GLBL_TAX_ACCOUNTING_PERIOD_2 | 266415 |
| Tax Invoice Date | | Payments.Tax Invoice Date | GLBL_TAX_INVOICE_DATE_2 | GLBL_TAX_INVOICE_DATE_2 | 266413 |
| Tax Invoice Number | | Payments.Tax Invoice Number | GLBL_TAX_INVOICE_NUMBER_2 | GLBL_TAX_INVOICE_NUMBER_2 | 266412 |
| Transfer Priority | Transfer priority for bank charges (Japanese feature). | Payments.Transfer Priority | TRANSFER_PRIORITY | TRANSFER_PRIORITY | 165941 |
| Treasury Payment Date | The date the payment processed through the internal clearing organization. | Payments.Treasury Payment Date | TREASURY_PAYMENT_DATE | TREASURY_PAYMENT_DATE | 166009 |
| Treasury Payment Number | The number assigned to a pryment processed through the internal clearing organization. | Payments.Treasury Payment Number | TREASURY_PAYMENT_NUMBER | TREASURY_PAYMENT_NUMBER | 166010 |
| US Standard GL Transaction Code | Transaction code for creating US standard general ledger journal entries. (Oracle Public Sector Payables) | Payments.US Standard GL Transaction Code | USSGL_TRANSACTION_CODE | USSGL_TRANSACTION_CODE | 167042 |
| Vendor Bank Account Number | The suppliers bank account number for electronic fund transfer payment purposes. | Payments.Vendor Bank Account Number | VENDOR_BANK_ACCOUNT_NUMBER | VENDOR_BANK_ACCOUNT_NUMBER | 167413 |
| Vendor Bank Account Type | The suppliers bank account type code for electronic fund transfer payment purposes. | Payments.Vendor Bank Account Type | VENDOR_BANK_ACCOUNT_TYPE | VENDOR_BANK_ACCOUNT_TYPE | 167414 |
| Vendor City | The city name of the payee. | Payments.Vendor City | VENDOR_CITY | VENDOR_CITY | 167418 |
| Vendor Country | The country name of the payee. | Payments.Vendor Country | VENDOR_COUNTRY | VENDOR_COUNTRY | 167422 |
| Vendor Id | | Payments.Vendor Id | VENDOR_ID | VENDOR_ID | 167427 |
| Vendor Name | The supplier or payer name. | Payments.Vendor Name | VENDOR_NAME | VENDOR_NAME | 167447 |
| Vendor Postal Code | The state or province postal code of the payee. | Payments.Vendor Postal Code | VENDOR_POSTAL_CODE | VENDOR_POSTAL_CODE | 167472 |
| Vendor Site Code | The supplier or payer site code, in the case a supplier has multiple pay sites. | Payments.Vendor Site Code | VENDOR_SITE_CODE | VENDOR_SITE_CODE | 167475 |
| Vendor Site Id | | Payments.Vendor Site Id | VENDOR_SITE_ID | VENDOR_SITE_ID | 167477 |
| Vendor State | The state name of the payee. | Payments.Vendor State | VENDOR_STATE | VENDOR_STATE | 167484 |
| Void Date | Payment void date. | Payments.Void Date | VOID_DATE | VOID_DATE | 167545 |
| Void Date - Day | | Payments.Void Date | | VOID_DATE_DAY | 193274 |
| Void Date - Month | | Payments.Void Date | | VOID_DATE_MONTH | 193276 |
| Void Date - Quarter | | Payments.Void Date | | VOID_DATE_QUARTER | 193278 |
| Void Date - Year | | Payments.Void Date | | VOID_DATE_YEAR | 193280 |