AR_TRX_SUMMARY_HIST
This table stores the history of all the modifications performed on different transactions, which would affect the data in the summary tables. The history data in this table is used by the subscriptions of the various receivables business events, raised during the Receivables business flows, to update the summary table.
Details
-
Schema: FUSION
-
Object owner: AR
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AR_TRX_SUMMARY_HIST_PK |
HISTORY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| HISTORY_ID | NUMBER | 18 | Yes | History Record Identifier | |
| 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. | |
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CUSTOMER_TRX_ID | NUMBER | 18 | Identifies the transaction. | ||
| CASH_RECEIPT_ID | NUMBER | 18 | Identifies the payment. | ||
| PAYMENT_SCHEDULE_ID | NUMBER | 18 | Identifies the payment schedule of the transaction. | ||
| PREVIOUS_HISTORY_ID | NUMBER | 18 | Unique identifier of the previous history record of the current transaction. | ||
| DUE_DATE | DATE | Due date of the transaction installment. | |||
| AMOUNT_IN_DISPUTE | NUMBER | Amount in dispute against the installment of the transaction. | |||
| AMOUNT_DUE_ORIGINAL | NUMBER | Amount due original on the transaction. | |||
| AMOUNT_ADJUSTED | NUMBER | Amount adjusted on the installment. | |||
| COMPLETE_FLAG | VARCHAR2 | 1 | Indicates whether processing of the current record is complete. Valid values are Y and N. | ||
| CUSTOMER_ID | NUMBER | 18 | Customer account identifier. | ||
| SITE_USE_ID | NUMBER | 18 | Site use identifier. | ||
| AMOUNT_DUE_REMAINING | NUMBER | Current amount due remaining. | |||
| CURRENCY_CODE | VARCHAR2 | 30 | Lookup code for the currency of the transaction. | ||
| TRX_DATE | DATE | Transaction Date | |||
| EVENT_NAME | VARCHAR2 | 240 | Business event associated with the current record. | ||
| INSTALLMENTS | NUMBER | Number of installments of the current transaction. | |||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AR_TRX_SUMMARY_HIST | hz_cust_site_uses_all | SITE_USE_ID |
| AR_TRX_SUMMARY_HIST | hz_cust_accounts | CUSTOMER_ID |
| AR_TRX_SUMMARY_HIST | ra_customer_trx_all | CUSTOMER_TRX_ID |
| AR_TRX_SUMMARY_HIST | ar_cash_receipts_all | CASH_RECEIPT_ID |
| AR_TRX_SUMMARY_HIST | ar_payment_schedules_all | PAYMENT_SCHEDULE_ID |
| AR_TRX_SUMMARY_HIST | ar_cash_receipt_history_all | PREVIOUS_HISTORY_ID |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| AR_TRX_SUMMARY_HIST_N2 | Non Unique | PAYMENT_SCHEDULE_ID, PREVIOUS_HISTORY_ID |
| AR_TRX_SUMMARY_HIST_U1 | Unique | HISTORY_ID |
| AR_TRX_SUMMARY_HIST_N1 | Non Unique | CUSTOMER_TRX_ID |