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

TABLE: AR.AR_COLIND

Object Details
Object Name: AR_COLIND
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory 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:

SchemaAR
ViewAR_COLIND#