[Home] [Help] [Dependency Information]
Object Name: | AR_COLLECTION_INDICATORS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | AR |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COLLECTION_INDICATOR_ID | NUMBER | (15) | Yes | |
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 | ||
DSO_DAYS | NUMBER | (4) | Yes | |
CONVENTIONAL_DSO | NUMBER | (5) | Yes | |
GROSS_RECEIVABLES | NUMBER | (22) | Yes | |
OPEN_CM | NUMBER | (22) | Yes | |
OPEN_PAYMENTS | NUMBER | (22) | Yes | |
INVOICE_SPLIT_AMOUNT | NUMBER | (22) | Yes | |
INVOICE_AMOUNT_OVER | NUMBER | (22) | Yes | |
INVOICE_AMOUNT_UNDER | NUMBER | (22) | Yes | |
INVOICE_COUNT_OVER | NUMBER | (9) | Yes | |
INVOICE_COUNT_UNDER | NUMBER | (9) | Yes | |
AMOUNT_COLLECTED | NUMBER | (22) | Yes | |
PAYMENT_PATTERN_CURRENT_SALES | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_1PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_2PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_3PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_4PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_5PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_6PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_7PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_8PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_9PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_10PERIOD_PRIOR | NUMBER | (4) | Yes | |
PAYMENT_PATTERN_11PERIOD_PRIOR | NUMBER | (4) | Yes | |
CREDIT_MEMO_AMOUNT | NUMBER | (22) | Yes | |
WRITEOFF_AMOUNT | NUMBER | (22) | Yes | |
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 |
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#;
|
|
|