eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.AR_TRX_SUMMARY_HIST

Object Details

Object Name:	AR_TRX_SUMMARY_HIST
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_TRX_SUMMARY_HIST
Subobject Name:
Status:	VALID

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 AR business events, raised during the AR business flows, to update the summary table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_TRX_SUMMARY_HIST_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	HISTORY_ID
AR_TRX_SUMMARY_HIST_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID
AR_TRX_SUMMARY_HIST_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID PREVIOUS_HISTORY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
HISTORY_ID	NUMBER	(15)	Yes	History Record Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CUSTOMER_TRX_ID	NUMBER	(15)		Identifies the transaction.
CASH_RECEIPT_ID	NUMBER	(15)		Identifies the payment.
PAYMENT_SCHEDULE_ID	NUMBER	(15)		Identifies the payment schedule of the transaction.
PREVIOUS_HISTORY_ID	NUMBER	(15)		Unique identifier of the previous history record of the current transaction.
DUE_DATE	DATE			Due date of the 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	(15)		ICustomer account identifier.
SITE_USE_ID	NUMBER	(15)		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.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HISTORY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CUSTOMER_TRX_ID
,      CASH_RECEIPT_ID
,      PAYMENT_SCHEDULE_ID
,      PREVIOUS_HISTORY_ID
,      DUE_DATE
,      AMOUNT_IN_DISPUTE
,      AMOUNT_DUE_ORIGINAL
,      AMOUNT_ADJUSTED
,      COMPLETE_FLAG
,      CUSTOMER_ID
,      SITE_USE_ID
,      AMOUNT_DUE_REMAINING
,      CURRENCY_CODE
,      TRX_DATE
,      EVENT_NAME
,      INSTALLMENTS
FROM AR.AR_TRX_SUMMARY_HIST;

Dependencies

[top of page]

AR.AR_TRX_SUMMARY_HIST does not reference any database object

AR.AR_TRX_SUMMARY_HIST is referenced by following:

APPS: AR_TRX_SUMMARY_HIST