[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ISC_EDW_BOOKINGS_F |
|---|---|
| Object Type: | TABLE |
| Owner: | ISC |
| FND Design Data: |  ISC.ISC_EDW_BOOKINGS_F
|
| Subobject Name: | |
| Status: | VALID |
This fact table stores information collected from Booked Sales Orders as well as
Cancellations and Returns. Data is retrieved from Sales Order Headers and Sales
Order Lines, and is kept at the lowest transaction level. The measures available in
this fact table are Dates (Booked, Requested, Promised, Scheduled, Ordered, Latest
Ship, Latest Pick, Fulfilled ), Quantities (Ordered, Reserved, Shipped, Invoiced, Canceled,
Returned, Fulfilled), expressed in Base Unit of Measure, and Prices (List, Unit Sell, and Cost),
stored in original Transaction Currency as well as in Global Warehouse Currency.
Reference to source transactions (Instance, Order Number, Header Id, Line Id,
Line Detail Id) is also kept. Bookings measures (except for Total Net Order Value) can be
aggregated by Item, Order Category, Trading Partner, Geography, Project, Demand Class, Cancellation Reason, Time, Inventory Organization, Internal Organization, Set of Books,
Order Type, Order Source, Sales Channel, Return Reason, Unit of Measure, Currency, Agreement, Sales Person, Instance, Campaign Schedule, Campaign Status, Marketing Event Offer, Market Segment, Media Channel, Marketing Offer, Marketing Target Segment Level, and Source List.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 30 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ISC_EDW_BOOKINGS_F_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 BOOKINGS_PK
|
| ISC_EDW_BOOKINGS_F_N1 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CAMPAIGN_INIT_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N10 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TOP_MODEL_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N11 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CANCEL_REASON_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N12 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ORDER_CATEGORY_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N13 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ORDER_TYPE_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N14 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
MARKET_SEGMENT_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N15 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
MEDCHN_INIT_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N16 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
MEDCHN_ACTL_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N17 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
OFFER_HDR_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N18 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
OFFER_LINE_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N19 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SOURCE_LIST_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N2 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CAMPAIGN_ACTL_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N20 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
INV_ORG_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N21 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
OPERATING_UNIT_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N22 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SALES_PERSON_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N23 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TASK_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N24 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SALES_CHANNEL_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N25 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_BOOKED_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N26 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_REQUESTED_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N27 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_PROMISED_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N28 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DATE_SCHEDULED_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N29 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
UOM_UOM_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N30 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
DEMAND_CLASS_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N31 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
RETURN_REASON_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N32 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SET_OF_BOOKS_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N33 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ORDER_SOURCE_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N34 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
BILL_TO_CUST_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N35 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SHIP_TO_CUST_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N37 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
EVENT_OFFER_ACTL_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N38 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
EVENT_OFFER_INIT_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N39 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CUSTOMER_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N4 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CURRENCY_TRN_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N40 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TARGET_SEGMENT_INIT_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N41 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
TARGET_SEGMENT_ACTL_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N42 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
EVENT_OFFER_REG_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N43 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
AGREEMENT_TYPE_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N44 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CAMPAIGN_STATUS_ACTL_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N45 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
CAMPAIGN_STATUS_INIT_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N47 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
HEADER_ID
FULFILLMENT_FLAG
|
| ISC_EDW_BOOKINGS_F_N48 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
FULFILLMENT_FLAG
|
| ISC_EDW_BOOKINGS_F_N6 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
BILL_TO_LOC_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N7 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
SHIP_TO_LOC_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N8 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
INSTANCE_FK_KEY
|
| ISC_EDW_BOOKINGS_F_N9 | BITMAP | NONUNIQUE |
APPS_TS_SUMMARY
|
ITEM_ORG_FK_KEY
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BOOKINGS_PK | VARCHAR2 | (240) | Unique Identifier | |
| BOOKINGS_PK_KEY | NUMBER | Yes | System generated unique identifier | |
| AGREEMENT_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Customer Agreement Type) | ||
| BILL_TO_CUST_FK_KEY | NUMBER | System generated foreign key to the Trading Partner dimension (Bill-to Site) | ||
| BILL_TO_LOC_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Bill-to Location) | ||
| 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) | ||
| CANCEL_REASON_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Cancel Reason) | ||
| CURRENCY_TRN_FK_KEY | NUMBER | System generated foreign key to the Currency dimension (Transaction Currency) | ||
| CUSTOMER_FK_KEY | NUMBER | System generated foreign key to the Trading Partner dimension (Customer) | ||
| DATE_BOOKED_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Date Booked) | ||
| DATE_REQUESTED_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Date Requested) | ||
| DATE_PROMISED_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Date Promised) | ||
| DATE_SCHEDULED_FK_KEY | NUMBER | System generated foreign key to the Time dimension (Date Scheduled) | ||
| DEMAND_CLASS_FK_KEY | NUMBER | System generated foreign key to the Demand Class Dimension | ||
| EVENT_OFFER_ACTL_FK_KEY | NUMBER | System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Actual) | ||
| EVENT_OFFER_INIT_FK_KEY | NUMBER | System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Attributed) | ||
| EVENT_OFFER_REG_FK_KEY | NUMBER | System generated foreign key to the Marketing Event Offer dimension (Marketing Event Offer Registration) | ||
| INSTANCE_FK_KEY | NUMBER | System generated foreign key to the Instance dimension | ||
| INV_ORG_FK_KEY | NUMBER | System generated foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued | ||
| ITEM_ORG_FK_KEY | NUMBER | System generated foreign key to the Item dimension (Organization Item) | ||
| MARKET_SEGMENT_FK_KEY | NUMBER | System generated foreign key to the Market Segment dimension | ||
| MEDCHN_ACTL_FK_KEY | NUMBER | System generated foreign key to the Media Channel dimension (Media Channel Actual) | ||
| MEDCHN_INIT_FK_KEY | NUMBER | System generated foreign key to the Media Channel dimension (Media Channel Attributed) | ||
| OFFER_HDR_FK_KEY | NUMBER | System generated foreign key to the Marketing Offer dimension (Header level) | ||
| OFFER_LINE_FK_KEY | NUMBER | System generated foreign key to the Marketing Offer dimension (Line level) | ||
| OPERATING_UNIT_FK_KEY | NUMBER | System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked | ||
| ORDER_CATEGORY_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Sales Order Category) | ||
| ORDER_SOURCE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Sales Order Source) | ||
| ORDER_TYPE_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Sales Order Type) | ||
| RETURN_REASON_FK_KEY | NUMBER | System generated foreign key to the Lookup dimension (Return Reason) | ||
| SALES_CHANNEL_FK_KEY | NUMBER | System generated foreign key to the Sales Channel dimension | ||
| SALES_PERSON_FK_KEY | NUMBER | Reserved for future use | ||
| SET_OF_BOOKS_FK_KEY | NUMBER | System generated foreign key to the Set of Books dimension (GL Set of Book) | ||
| SHIP_TO_CUST_FK_KEY | NUMBER | System generated foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped | ||
| SHIP_TO_LOC_FK_KEY | NUMBER | System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped | ||
| SOURCE_LIST_FK_KEY | NUMBER | System generated foreign key to the Source List dimension | ||
| 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) | ||
| TASK_FK_KEY | NUMBER | System generated foreign key to the Project dimension (Project Task) | ||
| 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) | ||
| UOM_UOM_FK_KEY | NUMBER | System generated foreign key to the UoM dimension | ||
| AGREEMENT_ID | VARCHAR2 | (80) | Id of the Agreement to which this order relates | |
| BOOKED_DATE | DATE | Date Booked | ||
| CONFIGURATION_ITEM_FLAG | VARCHAR2 | (40) | Flag indicating if the item is part of a configuration | |
| CONVERSION_DATE | DATE | Currency Conversion Date | ||
| CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
| CONVERSION_TYPE | VARCHAR2 | (80) | Currency Conversion Type | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| CUST_PO_NUMBER | VARCHAR2 | (80) | Customer's Purchase Order Number | |
| DATE_FULFILLED | DATE | Date Fulfilled | ||
| 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) | |
| HEADER_ID | VARCHAR2 | (80) | Sales Order Header Identifier in the source system | |
| 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" | |
| ITEM_TYPE_CODE | VARCHAR2 | (80) | Code for the item type : STANDARD, CONFIG, KIT, MODEL, CLASS, OPTION, INCLUDED, SERVICE | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LINE_DETAILS_ID | VARCHAR2 | (80) | Sales Order Line Details Identifier in the source system | |
| LINE_ID | VARCHAR2 | (80) | Sales Order Line Identifier in the source system | |
| ORDER_NUMBER | VARCHAR2 | (80) | Sales Order Number in the source system | |
| ORDERED_DATE | DATE | Date Ordered | ||
| PRICE_LIST_ID | VARCHAR2 | (80) | Id of the Price List from which the List Price was issued | |
| PROMISED_DATE | DATE | Date Promised | ||
| QTY_CANCELLED | NUMBER | Quantity Canceled | ||
| QTY_INVOICED | NUMBER | Quantity Invoiced | ||
| QTY_FULFILLED | NUMBER | Quantity Fulfilled | ||
| QTY_ORDERED | NUMBER | Quantity Ordered | ||
| QTY_RESERVED | NUMBER | Quantity Reserved | ||
| QTY_RETURNED | NUMBER | Quantity Returned | ||
| QTY_SHIPPED | NUMBER | Quantity Shipped | ||
| REQUESTED_DATE | DATE | Date Requested | ||
| SCHEDULED_DATE | DATE | Date Scheduled | ||
| SHIPPABLE_FLAG | VARCHAR2 | (40) | Shippable Flag | |
| TOTAL_NET_ORDER_VALUE | NUMBER | Total net value for the entire order (non additive across lines of the same order) | ||
| TRANSACTABLE_FLAG | VARCHAR2 | (40) | Reserved for future use | |
| 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 | ||
| UNIT_SELL_PRC_G | NUMBER | Unit Sell Price in Warehouse Currency | ||
| UNIT_SELL_PRC_T | NUMBER | Unit Sell Price in Transaction Currency | ||
| 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 | |
| USER_FK1_KEY | NUMBER | System generated foreign key to user defined dimension | ||
| USER_FK2_KEY | NUMBER | System generated foreign key to user defined dimension | ||
| USER_FK3_KEY | NUMBER | System generated foreign key to user defined dimension | ||
| USER_FK4_KEY | NUMBER | System generated foreign key to user defined dimension | ||
| USER_FK5_KEY | NUMBER | System generated foreign key to user defined dimension | ||
| USER_MEASURE1 | NUMBER | User defined measure | ||
| USER_MEASURE2 | NUMBER | User defined measure | ||
| USER_MEASURE3 | NUMBER | User defined measure | ||
| USER_MEASURE4 | NUMBER | User defined measure | ||
| USER_MEASURE5 | NUMBER | User defined measure |
Cut, paste (and edit) the following text to query this object:
SELECT BOOKINGS_PK
, BOOKINGS_PK_KEY
, AGREEMENT_TYPE_FK_KEY
, BILL_TO_CUST_FK_KEY
, BILL_TO_LOC_FK_KEY
, CAMPAIGN_ACTL_FK_KEY
, CAMPAIGN_INIT_FK_KEY
, CAMPAIGN_STATUS_ACTL_FK_KEY
, CAMPAIGN_STATUS_INIT_FK_KEY
, CANCEL_REASON_FK_KEY
, CURRENCY_TRN_FK_KEY
, CUSTOMER_FK_KEY
, DATE_BOOKED_FK_KEY
, DATE_REQUESTED_FK_KEY
, DATE_PROMISED_FK_KEY
, DATE_SCHEDULED_FK_KEY
, DEMAND_CLASS_FK_KEY
, EVENT_OFFER_ACTL_FK_KEY
, EVENT_OFFER_INIT_FK_KEY
, EVENT_OFFER_REG_FK_KEY
, INSTANCE_FK_KEY
, INV_ORG_FK_KEY
, ITEM_ORG_FK_KEY
, MARKET_SEGMENT_FK_KEY
, MEDCHN_ACTL_FK_KEY
, MEDCHN_INIT_FK_KEY
, OFFER_HDR_FK_KEY
, OFFER_LINE_FK_KEY
, OPERATING_UNIT_FK_KEY
, ORDER_CATEGORY_FK_KEY
, ORDER_SOURCE_FK_KEY
, ORDER_TYPE_FK_KEY
, RETURN_REASON_FK_KEY
, SALES_CHANNEL_FK_KEY
, SALES_PERSON_FK_KEY
, SET_OF_BOOKS_FK_KEY
, SHIP_TO_CUST_FK_KEY
, SHIP_TO_LOC_FK_KEY
, SOURCE_LIST_FK_KEY
, TARGET_SEGMENT_ACTL_FK_KEY
, TARGET_SEGMENT_INIT_FK_KEY
, TASK_FK_KEY
, TOP_MODEL_FK_KEY
, UOM_UOM_FK_KEY
, AGREEMENT_ID
, BOOKED_DATE
, CONFIGURATION_ITEM_FLAG
, CONVERSION_DATE
, CONVERSION_RATE
, CONVERSION_TYPE
, CREATION_DATE
, CUST_PO_NUMBER
, DATE_FULFILLED
, DATE_LATEST_SHIP
, DATE_LATEST_PICK
, FULFILLMENT_FLAG
, HEADER_ID
, INCLUDED_ITEM_FLAG
, ITEM_TYPE_CODE
, LAST_UPDATE_DATE
, LINE_DETAILS_ID
, LINE_ID
, ORDER_NUMBER
, ORDERED_DATE
, PRICE_LIST_ID
, PROMISED_DATE
, QTY_CANCELLED
, QTY_INVOICED
, QTY_FULFILLED
, QTY_ORDERED
, QTY_RESERVED
, QTY_RETURNED
, QTY_SHIPPED
, REQUESTED_DATE
, SCHEDULED_DATE
, SHIPPABLE_FLAG
, TOTAL_NET_ORDER_VALUE
, TRANSACTABLE_FLAG
, UNIT_COST_G
, UNIT_COST_T
, UNIT_LIST_PRC_G
, UNIT_LIST_PRC_T
, UNIT_SELL_PRC_G
, UNIT_SELL_PRC_T
, 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
, USER_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
FROM ISC.ISC_EDW_BOOKINGS_F;
ISC.ISC_EDW_BOOKINGS_F does not reference any database object
ISC.ISC_EDW_BOOKINGS_F is referenced by following:
APPS
ISC_EDW_BOOKINGS_F
|
|
|
|