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_COLIND

Object Details

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

The AR_COLIND table is a temporary table used by the Oracle Business Intelligence System (BIS). This table stores values that the drill down reports from the Collection Indicators report use to calculate the Days Sales Outstanding (DSO) as well as the receivables turnover.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
CUSTOMER_ID	NUMBER	(15)	Identifies the customer associated with the report values
ORIG_AMT	NUMBER		Sum of the original amounts in functional currency from payment schedules that fall within report cut-off period
ADJ1_AMT	NUMBER		The sum of all adjustments that fall within the cut-off period
REC_AMT	NUMBER		The total amount received after the cut-off period
ADJ2_AMT	NUMBER		The sum of all adjustments created after the cut-off period
REM_AMT	NUMBER		Sum of the remaining amount in functional currency from payment schedules that fall within report cut-off period

Query Text

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


SELECT CUSTOMER_ID
,      ORIG_AMT
,      ADJ1_AMT
,      REC_AMT
,      ADJ2_AMT
,      REM_AMT
FROM AR.AR_COLIND;

Dependencies

[top of page]

AR.AR_COLIND does not reference any database object

AR.AR_COLIND is referenced by following:

APPS: AR_COLIND