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.

[Home] [Help]

Table: AR_STATEMENT_LINE_CLUSTERS

Product:	AR - Receivables
Description:	Interim table of transaction lines that appear on a statement
Implementation/DBA Data:	AR.AR_STATEMENT_LINE_CLUSTERS

Primary Key: AR_STATEMENT_LINE_CLUSTERS_PK

LINE_CLUSTER_ID
CUSTOMER_TRX_SEQUENCE
PAYMENT_SCHEDULE_SEQUENCE
TRX_ORDER_SEQUENCE
GENERAL_SEQUENCE

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_STATEMENT_LINE_CLUSTERS	AR_ADJUSTMENTS_ALL	AR_STATEMENT_LINE_CLUSTERS.ADJUSTMENT_ID
AR_STATEMENT_LINE_CLUSTERS	HZ_CUST_ACCOUNTS	AR_STATEMENT_LINE_CLUSTERS.CUSTOMER_ID
AR_STATEMENT_LINE_CLUSTERS	AR_RECEIVABLE_APPLICATIONS_ALL	AR_STATEMENT_LINE_CLUSTERS.RECEIVABLE_APPLICATION_ID
AR_STATEMENT_LINE_CLUSTERS	HZ_CUST_SITE_USES_ALL	AR_STATEMENT_LINE_CLUSTERS.SITE_USE_ID