AP_PAYMENT_HISTORY_ALL
AP_PAYMENT_HISTORY_ALL stores the clearing/unclearing history for payments. It also stores the maturity history for future dated payments. The table contains a row for each future dated payment, once the future dated payment matures, i.e. becomes negotiable. Any time a payment is cleared or uncleared, a row is inserted into this table for the payment. The values for TRANSACTION_TYPE can be PAYMENT MATURITY, PAYMENT CLEARING, or PAYMENT UNCLEARING. Each row in this table also has the accounting status for the maturity, clearing or unclearing event.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_PAYMENT_HISTORY_PK |
PAYMENT_HISTORY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PAYMENT_HISTORY_ID | NUMBER | 18 | Yes | Identifier of the history of payment event. | |
| CHECK_ID | NUMBER | 18 | Yes | Identifier of the payment document. | |
| TRANSACTION_DATE | DATE | Transaction date in the payment history. | |||
| TRANSACTION_AMOUNT | NUMBER | Transaction amount in the payment history. | |||
| TRANSACTION_TYPE | VARCHAR2 | 30 | Yes | Transaction type - value can be PAYMENT MATURITY, PAYMENT CLEARING, or PAYMENT UNCLEARING | |
| POSTED_FLAG | VARCHAR2 | 1 | Yes | Flag to indicate whether the maturity, clearing or unclearing transaction has been accounted (Y or N) | |
| ERROR_AMOUNT | NUMBER | Error amount on the reconciled payment. | |||
| CHARGE_AMOUNT | NUMBER | Bank charge amount on the reconciled payment. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Ledger currency code in the payment history. | ||
| MATCHED_FLAG | VARCHAR2 | 1 | Flag to indicate whether the payment is matched to a bank statement line (Y or N). If yes, then the payment will be reconciled, else it will be cleared | ||
| ACCOUNTING_EVENT_ID | NUMBER | 18 | Identifier of the accounting event. | ||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | |||
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
| PROGRAM_ID | NUMBER | 18 | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| ACCOUNTING_DATE | DATE | Yes | Accounting date for accounting entries for this transaction | ||
| MRC_EXCHANGE_RATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: | ||
| MRC_EXCHANGE_RATE_DATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: | ||
| MRC_EXCHANGE_RATE_TYPE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: | ||
| REV_PMT_HIST_ID | NUMBER | 18 | Payment history identifier of the reversed payment history transaction | ||
| TRX_BANK_AMOUNT | NUMBER | Amount to clear including charges and errors in the bank account currency | |||
| ERRORS_BANK_AMOUNT | NUMBER | Reconciliation error amount in the bank account currency | |||
| CHARGES_BANK_AMOUNT | NUMBER | Bank charges amount in the bank account currency | |||
| TRX_PMT_AMOUNT | NUMBER | Yes | Amount to clear including charges and errors in the payment currency | ||
| ERRORS_PMT_AMOUNT | NUMBER | Reconciliation error amount in the payment currency | |||
| CHARGES_PMT_AMOUNT | NUMBER | Bank charges amount in the payment currency | |||
| TRX_BASE_AMOUNT | NUMBER | Amount to clear including charges and errors in the base currency | |||
| ERRORS_BASE_AMOUNT | NUMBER | Reconciliation error amount in the base currency | |||
| CHARGES_BASE_AMOUNT | NUMBER | Bank charges amount in the base currency | |||
| BANK_CURRENCY_CODE | VARCHAR2 | 15 | Currency code of bank account used for payment. | ||
| BANK_TO_BASE_XRATE_TYPE | VARCHAR2 | 30 | Exchange rate type for bank account currency to base currency exchange rate | ||
| BANK_TO_BASE_XRATE_DATE | DATE | Date currency conversion rate is effective for bank account currency to base currency | |||
| BANK_TO_BASE_XRATE | NUMBER | Exchange rate from bank account currency to base currency | |||
| PMT_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code of payment in payment history. | |
| PMT_TO_BASE_XRATE_TYPE | VARCHAR2 | 30 | Exchange rate type for payment currency to base currency exchange rate | ||
| PMT_TO_BASE_XRATE_DATE | DATE | Date currency conversion rate is effective for payment currency to base currency | |||
| PMT_TO_BASE_XRATE | NUMBER | Exchange rate from payment currency to base currency | |||
| MRC_PMT_TO_BASE_XRATE_TYPE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate type for payment currency to base currency conversion rate pairs | ||
| MRC_PMT_TO_BASE_XRATE_DATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and date currency conversion rate is effective for payment currency to base currency pairs | ||
| MRC_PMT_TO_BASE_XRATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate from payment currency to base currency pairs | ||
| MRC_BANK_TO_BASE_XRATE_TYPE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate type for bank account currency to base currency conversion rate pairs | ||
| MRC_BANK_TO_BASE_XRATE_DATE | VARCHAR2 | 2000 | Multiple reporting currencies only: Concatenated string of reporting set of books id and currency conversion rate date from bank account currency to base currency conversion date pairs | ||
| MRC_BANK_TO_BASE_XRATE | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and currency conversion rate from bank account currency to base currency pairs | ||
| MRC_TRX_BASE_AMOUNT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and amount to clear including charges and errors pairs | ||
| MRC_ERRORS_BASE_AMOUNT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and reconciliation error amount in the base currency pairs | ||
| MRC_CHARGES_BASE_AMOUNT | VARCHAR2 | 2000 | Multiple Reporting Currencies only: Concatenated string of reporting set of books id and bank charges in the base currency pairs | ||
| RELATED_EVENT_ID | NUMBER | 18 | Originating transaction event id | ||
| HISTORICAL_FLAG | VARCHAR2 | 1 | Flag to indicate whether the payment transaction is a result of upgraded data | ||
| INVOICE_ADJUSTMENT_EVENT_ID | NUMBER | 18 | Related adjusted invoice that resulted in a cascade event | ||
| GAIN_LOSS_INDICATOR | VARCHAR2 | 1 | Indicates whether the payment related transaction resulted in gain or loss (G or L) | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| PMT_TO_BANK_XRATE_TYPE | VARCHAR2 | 30 | Type of exchange rate used to convert payment to disbursement bank account currency. | ||
| PMT_TO_BANK_XRATE_DATE | DATE | Date when the payment is converted to disbursement bank account currency. | |||
| PMT_TO_BANK_XRATE | NUMBER | Exchange rate used to convert payment to disbursement bank account currency. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_PAYMENT_HISTORY_ALL | ap_checks_all | CHECK_ID |
| AP_PAYMENT_HISTORY_ALL | gl_daily_conversion_types | PMT_TO_BASE_XRATE_TYPE |
| AP_PAYMENT_HISTORY_ALL | ap_payment_history_all | PAYMENT_HISTORY_ID |
| AP_PAYMENT_HISTORY_ALL | ap_payment_history_all | REV_PMT_HIST_ID |
| ap_payment_hist_dists | ap_payment_history_all | PAYMENT_HISTORY_ID |
| ap_payment_history_all | ap_payment_history_all | PAYMENT_HISTORY_ID |
| ap_payment_history_all | ap_payment_history_all | REV_PMT_HIST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_PAYMENT_HISTORY_N1 | Non Unique | Default | CHECK_ID |
| AP_PAYMENT_HISTORY_N2 | Non Unique | Default | ACCOUNTING_EVENT_ID |
| AP_PAYMENT_HISTORY_N3 | Non Unique | Default | POSTED_FLAG |
| AP_PAYMENT_HISTORY_N4 | Non Unique | Default | ACCOUNTING_DATE |
| AP_PAYMENT_HISTORY_U1 | Unique | Default | PAYMENT_HISTORY_ID |
| AP_PAYMENT_HISTORY_U2 | Unique | Default | REV_PMT_HIST_ID |