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_STATEMENT_LINE_CLUSTERS

Object Details

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

The AR_STATEMENT_LINE_CLUSTERS table is an interim table that is used in statement generation and contains a row for every line that appears on a statement. The LINE_CLUSTER_ID column groups rows and represents the set of lines that appear on one statement.
.
The primary keys for this table are LINE_CLUSTER_ID, CUSTOMER_TRX_SEQUENCE, PAYMENT_SCHEDULE_SEQUENCE, TRX_ORDER_SEQUENCE, and GENERAL_SEQUENCE.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_STATEMENT_LINE_CLUSTERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_CLUSTER_ID
AR_STATEMENT_LINE_CLUSTERS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_SEQUENCE
AR_STATEMENT_LINE_CLUSTERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GENERAL_SEQUENCE

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_CLUSTER_ID	NUMBER	(15)	Yes	Identifier for the line cluster
CUSTOMER_TRX_SEQUENCE	NUMBER	(15)	Yes	Customer_trx_id. Foreign key to the RA_CUSTOMER_TRX_ALL table.
PAYMENT_SCHEDULE_SEQUENCE	NUMBER	(15)	Yes	Payment schedule ID of the INVOICE_NUMBER which serves as a foreign key to the AR_PAYMENT_SCHEDULES table
TRX_ORDER_SEQUENCE	NUMBER	(15)	Yes	Specifies the ordering of statement lines
GENERAL_SEQUENCE	NUMBER	(15)	Yes	Unique identifier from the AR_STATEMENT_LINE_CLUSTERS_S sequence
INVOICE_NUMBER	VARCHAR2	(30)		Transaction number
TRX_DATE	DATE			The date of the transaction
TRANSACTION	VARCHAR2	(100)		Transaction description
DUE_DATE	DATE			Due date of the transaction
REFERENCE	VARCHAR2	(100)		Reference
BILL_TO_LOCATION	VARCHAR2	(100)		Address of the bill to location
TRX_AMOUNT	NUMBER			The amount of the transaction
AMOUNT_DUE	NUMBER			The amount due
ADJUSTMENT_ID	NUMBER	(15)		Adjustment identifier. Foreign key to the AR_ADJUSTMENTS table.
CUSTOMER_ID	NUMBER	(15)	Yes	Customer identifier. Foreign key to the RA_CUSTOMERS table.
RECEIVABLE_APPLICATION_ID	NUMBER	(15)		Application identifier. Foreign key to the AR_RECEIVABLE_APPLICATIONS table.
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
SITE_USE_ID	NUMBER	(15)		Site use identifier of the transaction. Foreign key to the RA_SITE_USES_ALL table.
BILL_TO_CITY	VARCHAR2	(60)		Bill-to city
ORIG_PAYMENT_AMOUNT	NUMBER			Original payment amount
TRANSACTION_CODE	VARCHAR2	(80)		Transaction class. CB, CM, DM, DEP, GUAR, INV, or PMT
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)		Currency code of the receipt being applied to the invoice
AMOUNT_APPLIED_FROM	NUMBER			Amount applied in the receipt currency

Query Text

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


SELECT LINE_CLUSTER_ID
,      CUSTOMER_TRX_SEQUENCE
,      PAYMENT_SCHEDULE_SEQUENCE
,      TRX_ORDER_SEQUENCE
,      GENERAL_SEQUENCE
,      INVOICE_NUMBER
,      TRX_DATE
,      TRANSACTION
,      DUE_DATE
,      REFERENCE
,      BILL_TO_LOCATION
,      TRX_AMOUNT
,      AMOUNT_DUE
,      ADJUSTMENT_ID
,      CUSTOMER_ID
,      RECEIVABLE_APPLICATION_ID
,      REQUEST_ID
,      SITE_USE_ID
,      BILL_TO_CITY
,      ORIG_PAYMENT_AMOUNT
,      TRANSACTION_CODE
,      RECEIPT_CURRENCY_CODE
,      AMOUNT_APPLIED_FROM
FROM AR.AR_STATEMENT_LINE_CLUSTERS;

Dependencies

[top of page]

AR.AR_STATEMENT_LINE_CLUSTERS does not reference any database object

AR.AR_STATEMENT_LINE_CLUSTERS is referenced by following:

APPS: AR_STATEMENT_LINE_CLUSTERS