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

TABLE: AR.AR_COLLECTION_INDICATORS_ALL

Object Details
Object Name: AR_COLLECTION_INDICATORS_ALL
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.AR_COLLECTION_INDICATORS_ALL
Subobject Name:
Status: VALID


The AR_COLLECTION_INDICATORS_ALL table stores collection information for the Oracle Business Intelligence System (BIS) Collection Indicators report. Run this report monthly for Oracle Receivables to record and store your collection data. Each row includes collector effectiveness indicator information for one month. Use this information on the report to determine how effectively your organization collects on outstanding receivables.
.
The primary key for this table is COLLECTION_INDICATOR_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_COLLECTION_INDICATORS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOLLECTION_INDICATOR_ID
Columns
Name Datatype Length Mandatory Comments
COLLECTION_INDICATOR_ID NUMBER (15) Yes Identifier of the collection indicator
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
REPORT_DATE DATE
Yes Date entered to run the report
DSO_DAYS NUMBER (4) Yes Number of days used in CONVENTIONAL_DSO calculation
CONVENTIONAL_DSO NUMBER (5) Yes Conventional Day Sales Outstanding = (GROSS_RECEIVABLES/Original amount of debit items) * DSO_DAYS
GROSS_RECEIVABLES NUMBER (22) Yes Sum of all open invoices as of the REPORT_DATE
OPEN_CM NUMBER (22) Yes Sum of open credit memos
OPEN_PAYMENTS NUMBER (22) Yes Sum of open receipts
INVOICE_SPLIT_AMOUNT NUMBER (22) Yes User-defined amount to determine sales above and below this split amount
INVOICE_AMOUNT_OVER NUMBER (22) Yes Sum of invoices above the invoice split amount
INVOICE_AMOUNT_UNDER NUMBER (22) Yes Sum of invoices below the invoice split amount
INVOICE_COUNT_OVER NUMBER (9) Yes Number of invoices above the invoice split amount
INVOICE_COUNT_UNDER NUMBER (9) Yes Number of invoices below the invoice split amount
AMOUNT_COLLECTED NUMBER (22) Yes Sum of receipts collected
PAYMENT_PATTERN_CURRENT_SALES NUMBER (4) Yes Collected amount over invoiced amount for current period
PAYMENT_PATTERN_1PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period one
PAYMENT_PATTERN_2PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period two
PAYMENT_PATTERN_3PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period three
PAYMENT_PATTERN_4PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period four
PAYMENT_PATTERN_5PERIOD_PRIOR NUMBER (4) Yes Represents collected amount over invoiced amount for period five
PAYMENT_PATTERN_6PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period six
PAYMENT_PATTERN_7PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period seven
PAYMENT_PATTERN_8PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period eight
PAYMENT_PATTERN_9PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period nine
PAYMENT_PATTERN_10PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period ten
PAYMENT_PATTERN_11PERIOD_PRIOR NUMBER (4) Yes Collected amount over invoiced amount for period eleven
CREDIT_MEMO_AMOUNT NUMBER (22) Yes Sum of credit memos created in period
WRITEOFF_AMOUNT NUMBER (22) Yes Sum of adjustments created in period
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER (15)
Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
REQUEST_ID NUMBER (15)
Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT COLLECTION_INDICATOR_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REPORT_DATE
,      DSO_DAYS
,      CONVENTIONAL_DSO
,      GROSS_RECEIVABLES
,      OPEN_CM
,      OPEN_PAYMENTS
,      INVOICE_SPLIT_AMOUNT
,      INVOICE_AMOUNT_OVER
,      INVOICE_AMOUNT_UNDER
,      INVOICE_COUNT_OVER
,      INVOICE_COUNT_UNDER
,      AMOUNT_COLLECTED
,      PAYMENT_PATTERN_CURRENT_SALES
,      PAYMENT_PATTERN_1PERIOD_PRIOR
,      PAYMENT_PATTERN_2PERIOD_PRIOR
,      PAYMENT_PATTERN_3PERIOD_PRIOR
,      PAYMENT_PATTERN_4PERIOD_PRIOR
,      PAYMENT_PATTERN_5PERIOD_PRIOR
,      PAYMENT_PATTERN_6PERIOD_PRIOR
,      PAYMENT_PATTERN_7PERIOD_PRIOR
,      PAYMENT_PATTERN_8PERIOD_PRIOR
,      PAYMENT_PATTERN_9PERIOD_PRIOR
,      PAYMENT_PATTERN_10PERIOD_PRIOR
,      PAYMENT_PATTERN_11PERIOD_PRIOR
,      CREDIT_MEMO_AMOUNT
,      WRITEOFF_AMOUNT
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORG_ID
FROM AR.AR_COLLECTION_INDICATORS_ALL;

Dependencies

[top of page]

AR.AR_COLLECTION_INDICATORS_ALL does not reference any database object

AR.AR_COLLECTION_INDICATORS_ALL is referenced by following:

SchemaAR
ViewAR_COLLECTION_INDICATORS_ALL#