AR_STATEMENT_LINE_CLUSTERS

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.

Details

• Schema: FUSION

• Object owner: AR

• Object type: TABLE

• Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
AR_STATEMENT_LINE_CLUSTERS_PK	LINE_CLUSTER_ID, CUSTOMER_TRX_SEQUENCE, PAYMENT_SCHEDULE_SEQUENCE, TRX_ORDER_SEQUENCE, GENERAL_SEQUENCE

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
LINE_CLUSTER_ID	NUMBER		18	Yes	Identifier for the line cluster	Active
CUSTOMER_TRX_SEQUENCE	NUMBER		18	Yes	Foreign key reference to RA_CUSTOMER_TRX_ALL table.	Active
PAYMENT_SCHEDULE_SEQUENCE	NUMBER		18	Yes	Payment schedule ID of the INVOICE_NUMBER which serves as a foreign key to the AR_PAYMENT_SCHEDULES table	Active
TRX_ORDER_SEQUENCE	NUMBER		18	Yes	Specifies the ordering of statement lines	Active
GENERAL_SEQUENCE	NUMBER		18	Yes	Unique identifier from the AR_STATEMENT_LINE_CLUSTERS_S sequence	Active
INVOICE_NUMBER	VARCHAR2	30			Transaction number	Active
TRX_DATE	DATE				The date of the transaction	Active
TRANSACTION	VARCHAR2	100			Transaction description	Active
DUE_DATE	DATE				Due date of the transaction	Active
REFERENCE	VARCHAR2	100			Refers to any receipt or credit memo related to the statement line. It stores the receipt or credit memo number.	Active
BILL_TO_LOCATION	VARCHAR2	150			Address of the bill to location	Active
TRX_AMOUNT	NUMBER				The amount of the transaction	Active
AMOUNT_DUE	NUMBER				The amount due	Active
ADJUSTMENT_ID	NUMBER		18		Adjustment identifier. Foreign key to the AR_ADJUSTMENTS table.	Active
CUSTOMER_ID	NUMBER		18	Yes	Customer identifier. Foreign key to the RA_CUSTOMERS table.	Active
RECEIVABLE_APPLICATION_ID	NUMBER		18		Application identifier. Foreign key to the AR_RECEIVABLE_APPLICATIONS table.	Active
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
SITE_USE_ID	NUMBER		18		Site use identifier of the transaction. Foreign key to the RA_SITE_USES_ALL table.	Active
BILL_TO_CITY	VARCHAR2	60			City of the customer bill to address.	Active
ORIG_PAYMENT_AMOUNT	NUMBER				Original payment amount	Active
TRANSACTION_CODE	VARCHAR2	80			Transaction class. CB, CM, DM, INV, or PMT	Active
RECEIPT_CURRENCY_CODE	VARCHAR2	15			Currency code of the receipt being applied to the invoice	Active
AMOUNT_APPLIED_FROM	NUMBER				Amount applied in the receipt currency	Active
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.	Active
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.	Active
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.	Active
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.	Active
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.	Active
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Active

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_STATEMENT_LINE_CLUSTERS	hz_cust_site_uses_all	SITE_USE_ID
AR_STATEMENT_LINE_CLUSTERS	hz_cust_accounts	CUSTOMER_ID
AR_STATEMENT_LINE_CLUSTERS	ar_receivable_applications_all	RECEIVABLE_APPLICATION_ID
AR_STATEMENT_LINE_CLUSTERS	ar_adjustments_all	ADJUSTMENT_ID

Indexes

Index	Uniqueness	Tablespace	Columns
AR_STATEMENT_LINE_CLUSTERS_N1	Non Unique	FUSION_TS_TX_DATA	LINE_CLUSTER_ID
AR_STATEMENT_LINE_CLUSTERS_N2	Non Unique	FUSION_TS_TX_DATA	PAYMENT_SCHEDULE_SEQUENCE
AR_STATEMENT_LINE_CLUSTERS_N3	Non Unique	FUSION_TS_TX_DATA	GENERAL_SEQUENCE