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

TABLE: ISC.ISC_EDW_BOOKINGS_F_DLOG

Object Details
Object Name: ISC_EDW_BOOKINGS_F_DLOG
Object Type: TABLE
Owner: ISC
FND Design Data: TableISC.ISC_EDW_BOOKINGS_F_DLOG
Subobject Name:
Status: VALID


This is the delete log table for the Bookings fact


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
SOURCE_LIST_FK_KEY NUMBER

System generated foreign key to the Source List dimension
UNIT_SELL_PRC_T NUMBER

Unit Sell Price in Transaction Currency
UNIT_SELL_PRC_G NUMBER

Unit Sell Price in Warehouse Currency
SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
USER_FK5_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK1_KEY NUMBER

System generated foreign key to user defined dimension
EVENT_OFFER_REG_FK_KEY NUMBER

System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Registration)
TARGET_SEGMENT_ACTL_FK_KEY NUMBER

System generated foreign key to the Marketing Target Segment Level dimension (Marketing Target Segment Level Actual)
TARGET_SEGMENT_INIT_FK_KEY NUMBER

System generated foreign key to the Marketing Target Segment Level dimension (Marketing Target Segment Level Attributed)
BOOKINGS_PK_KEY NUMBER

System generated unique identifier
CUSTOMER_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Customer)
EVENT_OFFER_INIT_FK_KEY NUMBER

System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Attributed)
EVENT_OFFER_ACTL_FK_KEY NUMBER

System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Actual)
SHIP_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
ORDER_SOURCE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Source)
RETURN_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Return Reason)
DEMAND_CLASS_FK_KEY NUMBER

System generated foreign key to the Demand Class Dimension
MEDCHN_INIT_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Attributed)
MEDCHN_ACTL_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Actual)
UNIT_COST_G NUMBER

Unit Cost in Warehouse Currency
UNIT_COST_T NUMBER

Unit Cost in Transaction Currency
UNIT_LIST_PRC_G NUMBER

Unit List Price in Warehouse Currency
UNIT_LIST_PRC_T NUMBER

Unit List Price in Transaction Currency
AGREEMENT_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Customer Agreement Type)
UOM_UOM_FK_KEY NUMBER

System generated foreign key to the UoM dimension
DATE_SCHEDULED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Scheduled)
DATE_PROMISED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Promised)
DATE_REQUESTED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Requested)
DATE_BOOKED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Booked)
SALES_CHANNEL_FK_KEY NUMBER

System generated foreign key to the Sales Channel dimension
TASK_FK_KEY NUMBER

System generated foreign key to the Project dimension (Project Task)
SALES_PERSON_FK_KEY NUMBER

Reserved for future use
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
INV_ORG_FK_KEY NUMBER

System generated foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
OFFER_LINE_FK_KEY NUMBER

System generated foreign key to the Marketing Offer dimension (Line level)
OFFER_HDR_FK_KEY NUMBER

System generated foreign key to the Marketing Offer dimension (Header level)
MARKET_SEGMENT_FK_KEY NUMBER

System generated foreign key to the Market Segment dimension
ORDER_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Type)
ORDER_CATEGORY_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Category)
CANCEL_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Cancel Reason)
TOP_MODEL_FK_KEY NUMBER

System generated foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
ITEM_ORG_FK_KEY NUMBER

System generated foreign key to the Item dimension (Organization Item)
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
SHIP_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
BILL_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Bill-to Location)
CURRENCY_TRN_FK_KEY NUMBER

System generated foreign key to the Currency dimension (Transaction Currency)
CAMPAIGN_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign Schedule dimension (Campaign Schedule Actual)
CAMPAIGN_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign Schedule dimension (Campaign Schedule Attributed)
CAMPAIGN_STATUS_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Actual)
CAMPAIGN_STATUS_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Attributed)
CONVERSION_RATE NUMBER

Currency Conversion Rate
USER_MEASURE5 NUMBER

User defined measure
USER_MEASURE4 NUMBER

User defined measure
USER_MEASURE3 NUMBER

User defined measure
USER_MEASURE2 NUMBER

User defined measure
USER_MEASURE1 NUMBER

User defined measure
QTY_SHIPPED NUMBER

Quantity Shipped
QTY_RETURNED NUMBER

Quantity Returned
QTY_RESERVED NUMBER

Quantity Reserved
QTY_ORDERED NUMBER

Quantity Ordered
QTY_INVOICED NUMBER

Quantity Invoiced
QTY_CANCELLED NUMBER

Quantity Cancelled
PRICE_LIST_ID VARCHAR2 (80)
Id of the Price List from which the List Price was issued
CUST_PO_NUMBER VARCHAR2 (80)
Customer's Purchase Order Number
AGREEMENT_ID VARCHAR2 (80)
Id of the Agreement to which this order relates
CONFIGURATION_ITEM_FLAG VARCHAR2 (40)
Flag indicating if the item is part of a configuration
INCLUDED_ITEM_FLAG VARCHAR2 (40)
Used as invoiceable_flag. Future realeases will have a new column for invoiceable_flag. This flag is set to "Y" if the sales order line is not from an Internal order, is not an "INCLUDED" item, and the invoiceable flag for this item = "Y"
TRANSACTABLE_FLAG VARCHAR2 (40)
Reserved for future use
ORDER_NUMBER VARCHAR2 (80)
Sales Order Number in the source system
LINE_ID VARCHAR2 (80)
Sales Order Line Identifier in the source system
LINE_DETAILS_ID VARCHAR2 (80)
Sales Order Line Details Identifier in the source system
HEADER_ID VARCHAR2 (80)
Sales Order Header Identifier in the source system
CONVERSION_TYPE VARCHAR2 (80)
Currency Conversion Type
BOOKINGS_PK VARCHAR2 (240)
Unique Identifier
LAST_UPDATE_DATE DATE

Standard Who column
CREATION_DATE DATE

Standard Who column
CONVERSION_DATE DATE

Currency Conversion Date
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User defined attribute
SHIPPABLE_FLAG VARCHAR2 (40)
Shippable Flag
DATE_LATEST_SHIP DATE

Date Latest Ship
DATE_LATEST_PICK DATE

Date Latest Pick
FULFILLMENT_FLAG VARCHAR2 (40)
Flag indicating if the line has been fulfilled (typically fully shipped and invoiced for shippable items, fully invoiced for non-shippable items)
DATE_FULFILLED DATE

Date Fulfilled
QTY_FULFILLED NUMBER

Quantity Fulfilled
BOOKED_DATE DATE

Date Booked
PROMISED_DATE DATE

Date Promised
ORDERED_DATE DATE

Date Ordered
REQUESTED_DATE DATE

Date Requested
TOTAL_NET_ORDER_VALUE NUMBER

Total net value for the entire order (non additive across lines of the same order)
ITEM_TYPE_CODE VARCHAR2 (80)
Code for the item type : STANDARD, CONFIG, KIT, MODEL, CLASS, OPTION, INCLUDED, SERVICE
SCHEDULED_DATE DATE

Date Scheduled
Query Text

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


SELECT SOURCE_LIST_FK_KEY
,      UNIT_SELL_PRC_T
,      UNIT_SELL_PRC_G
,      SET_OF_BOOKS_FK_KEY
,      USER_FK5_KEY
,      USER_FK4_KEY
,      USER_FK3_KEY
,      USER_FK2_KEY
,      USER_FK1_KEY
,      EVENT_OFFER_REG_FK_KEY
,      TARGET_SEGMENT_ACTL_FK_KEY
,      TARGET_SEGMENT_INIT_FK_KEY
,      BOOKINGS_PK_KEY
,      CUSTOMER_FK_KEY
,      EVENT_OFFER_INIT_FK_KEY
,      EVENT_OFFER_ACTL_FK_KEY
,      SHIP_TO_CUST_FK_KEY
,      BILL_TO_CUST_FK_KEY
,      ORDER_SOURCE_FK_KEY
,      RETURN_REASON_FK_KEY
,      DEMAND_CLASS_FK_KEY
,      MEDCHN_INIT_FK_KEY
,      MEDCHN_ACTL_FK_KEY
,      UNIT_COST_G
,      UNIT_COST_T
,      UNIT_LIST_PRC_G
,      UNIT_LIST_PRC_T
,      AGREEMENT_TYPE_FK_KEY
,      UOM_UOM_FK_KEY
,      DATE_SCHEDULED_FK_KEY
,      DATE_PROMISED_FK_KEY
,      DATE_REQUESTED_FK_KEY
,      DATE_BOOKED_FK_KEY
,      SALES_CHANNEL_FK_KEY
,      TASK_FK_KEY
,      SALES_PERSON_FK_KEY
,      OPERATING_UNIT_FK_KEY
,      INV_ORG_FK_KEY
,      OFFER_LINE_FK_KEY
,      OFFER_HDR_FK_KEY
,      MARKET_SEGMENT_FK_KEY
,      ORDER_TYPE_FK_KEY
,      ORDER_CATEGORY_FK_KEY
,      CANCEL_REASON_FK_KEY
,      TOP_MODEL_FK_KEY
,      ITEM_ORG_FK_KEY
,      INSTANCE_FK_KEY
,      SHIP_TO_LOC_FK_KEY
,      BILL_TO_LOC_FK_KEY
,      CURRENCY_TRN_FK_KEY
,      CAMPAIGN_ACTL_FK_KEY
,      CAMPAIGN_INIT_FK_KEY
,      CAMPAIGN_STATUS_ACTL_FK_KEY
,      CAMPAIGN_STATUS_INIT_FK_KEY
,      CONVERSION_RATE
,      USER_MEASURE5
,      USER_MEASURE4
,      USER_MEASURE3
,      USER_MEASURE2
,      USER_MEASURE1
,      QTY_SHIPPED
,      QTY_RETURNED
,      QTY_RESERVED
,      QTY_ORDERED
,      QTY_INVOICED
,      QTY_CANCELLED
,      PRICE_LIST_ID
,      CUST_PO_NUMBER
,      AGREEMENT_ID
,      CONFIGURATION_ITEM_FLAG
,      INCLUDED_ITEM_FLAG
,      TRANSACTABLE_FLAG
,      ORDER_NUMBER
,      LINE_ID
,      LINE_DETAILS_ID
,      HEADER_ID
,      CONVERSION_TYPE
,      BOOKINGS_PK
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CONVERSION_DATE
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      USER_ATTRIBUTE21
,      USER_ATTRIBUTE22
,      USER_ATTRIBUTE23
,      USER_ATTRIBUTE24
,      USER_ATTRIBUTE25
,      SHIPPABLE_FLAG
,      DATE_LATEST_SHIP
,      DATE_LATEST_PICK
,      FULFILLMENT_FLAG
,      DATE_FULFILLED
,      QTY_FULFILLED
,      BOOKED_DATE
,      PROMISED_DATE
,      ORDERED_DATE
,      REQUESTED_DATE
,      TOTAL_NET_ORDER_VALUE
,      ITEM_TYPE_CODE
,      SCHEDULED_DATE
FROM ISC.ISC_EDW_BOOKINGS_F_DLOG;

Dependencies

[top of page]

ISC.ISC_EDW_BOOKINGS_F_DLOG does not reference any database object

ISC.ISC_EDW_BOOKINGS_F_DLOG is referenced by following:

SchemaAPPS
SynonymISC_EDW_BOOKINGS_F_DLOG