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: ISC.ISC_EDW_BACKLOG_SUM1_F

Object Details

Object Name:	ISC_EDW_BACKLOG_SUM1_F
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

This summary table holds Backlog Summary information. It holds data at the order level. Key measures are calculated from Order Management and populated into this table. It is used for Risk Indicator portlet and related drilldown views.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_EDW_BACKLOG_SUM1_F_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	BACKLOG_SUM1_PK
ISC_EDW_BACKLOG_SUM1_F_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	OPERATING_UNIT_FK_KEY
ISC_EDW_BACKLOG_SUM1_F_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	CUSTOMER_FK_KEY
ISC_EDW_BACKLOG_SUM1_F_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	INSTANCE_FK_KEY
ISC_EDW_BACKLOG_SUM1_F_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SET_OF_BOOKS_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
BACKLOG_SUM1_PK	VARCHAR2	(240)		Unique Identifier
CREATION_DATE	DATE		Yes	Date of the Backlog Snapshot
LAST_UPDATE_DATE	DATE		Yes	Date of the Backlog Snapshot
CUSTOMER_FK_KEY	NUMBER			Foreign key to the customer level of Trading Partner dimension
FUNCTIONAL_CURRENCY_FK_KEY	NUMBER			Foreign key to the Currency dimension
INSTANCE_FK_KEY	NUMBER			Foreign key to the day level of the Instance dimension
SET_OF_BOOKS_FK_KEY	NUMBER			Foreign key to the Set of Books dimension
OPERATING_UNIT_FK_KEY	NUMBER			Foreign key to the operating unit level of Organization dimension
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
MAX_DAYS_LATE	NUMBER			Total number of days between the scheduled date and today (sysdate) for delinquent backlog orders
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
CUSTOMER_NAME	VARCHAR2	(80)		Customer name
DATE_BOOKED	DATE			Date of the transaction when it has been booked
DATE_OF_SNAPSHOT	DATE			Date of the latest collection, "as of" date
HEADER_ID	VARCHAR2	(80)		Unique identifier of the Header of an order
INSTANCE_CODE	VARCHAR2	(80)		Code of the source instance
OPERATING_UNIT_NAME	VARCHAR2	(80)		Operating unit name
ORDER_NUMBER	VARCHAR2	(80)		Order Number

Query Text

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


SELECT BACKLOG_SUM1_PK
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CUSTOMER_FK_KEY
,      FUNCTIONAL_CURRENCY_FK_KEY
,      INSTANCE_FK_KEY
,      SET_OF_BOOKS_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      DAYS_OPEN
,      DLQT_BKLG_AMT_B
,      DLQT_BKLG_AMT_G
,      DLQT_BKLG_LINE_COUNT
,      MAX_DAYS_LATE
,      SHIP_BKLG_AMT_B
,      SHIP_BKLG_AMT_G
,      SHIP_BKLG_LINE_COUNT
,      CUSTOMER_NAME
,      DATE_BOOKED
,      DATE_OF_SNAPSHOT
,      HEADER_ID
,      INSTANCE_CODE
,      OPERATING_UNIT_NAME
,      ORDER_NUMBER
FROM ISC.ISC_EDW_BACKLOG_SUM1_F;

Dependencies

[top of page]

ISC.ISC_EDW_BACKLOG_SUM1_F does not reference any database object

ISC.ISC_EDW_BACKLOG_SUM1_F is referenced by following:

APPS: ISC_EDW_BACKLOG_SUM1_F