[Home] [Help] [Dependency Information]
Object Name: | ISCBV_EDW_BACKLOG_SUM1_B_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This is the base view for the Backlog Summary 1 Fact
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BACKLOG_SUM1_PK | VARCHAR2 | (71) | Unique identifier | |
CUSTOMER_ID | VARCHAR2 | (40) | Foreign key to the customer level of Trading Partner dimension | |
FUNCTIONAL_CURRENCY | VARCHAR2 | (15) | Foreign key to the Currency dimension | |
INSTANCE_CODE | VARCHAR2 | (30) | Code of the source instance | |
OPERATING_UNIT_ID | VARCHAR2 | (40) | Foreign key to the operating unit level of Organization dimension | |
SET_OF_BOOKS_ID | VARCHAR2 | (40) | Foreign key to the Set of Books dimension | |
DATE_BOOKED | DATE | Date of the transaction when it has been booked | ||
DATE_OF_SNAPSHOT | DATE | Date of the latest collection, "as of" date | ||
DAYS_OPEN | NUMBER | Total number of days between the booked date and today (sysdate) for backlog orders | ||
DLQT_BKLG_AMT_B | NUMBER | Total amount of delinquent backlog in base currency | ||
DLQT_BKLG_AMT_G | NUMBER | Total amount of delinquent backlog in warehouse currency | ||
DLQT_BKLG_LINE_COUNT | NUMBER | Total number of delinquent backlog lines | ||
HEADER_ID | VARCHAR2 | (40) | Unique identifier of the Header of an order | |
MAX_DAYS_LATE | NUMBER | Total number of days between the scheduled date and today (sysdate) for delinquent backlog orders | ||
ORDER_NUMBER | VARCHAR2 | (40) | Order Number | |
SHIP_BKLG_AMT_B | NUMBER | Total amount of shipping backlog in base currency | ||
SHIP_BKLG_AMT_G | NUMBER | Total amount of shipping backlog in warehouse currency | ||
SHIP_BKLG_LINE_COUNT | NUMBER | Total number of shipping backlog lines |
Cut, paste (and edit) the following text to query this object:
SELECT BACKLOG_SUM1_PK
, CUSTOMER_ID
, FUNCTIONAL_CURRENCY
, INSTANCE_CODE
, OPERATING_UNIT_ID
, SET_OF_BOOKS_ID
, DATE_BOOKED
, DATE_OF_SNAPSHOT
, DAYS_OPEN
, DLQT_BKLG_AMT_B
, DLQT_BKLG_AMT_G
, DLQT_BKLG_LINE_COUNT
, HEADER_ID
, MAX_DAYS_LATE
, ORDER_NUMBER
, SHIP_BKLG_AMT_B
, SHIP_BKLG_AMT_G
, SHIP_BKLG_LINE_COUNT
FROM APPS.ISCBV_EDW_BACKLOG_SUM1_B_FCV;
|
|
|