[Home] [Help] [Dependency Information]
Object Name: | ISC_BOOK_SUM2_BKORD_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Base summary table for backorder information on the Shipping Management page. This table stores current backorder quantity and days late according to the scheduled shipment date and request date. It stores the information in snapshots at the line level.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_BOOK_SUM2_BKORD_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CUSTOMER_ID |
ISC_BOOK_SUM2_BKORD_F_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SOLD_TO_ORG_ID |
ISC_BOOK_SUM2_BKORD_F_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SHIP_TO_ORG_ID |
ISC_BOOK_SUM2_BKORD_F_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INV_ORG_ID | NUMBER | Inventory Organization Identifier | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item ID | ||
CUSTOMER_ID | NUMBER | Customer Identifier | ||
ORDER_NUMBER | NUMBER | User-visible number of the order | ||
HEADER_ID | NUMBER | Order Header Identifier | ||
TIME_REQUEST_DATE_ID | DATE | Ordered Item Request date | ||
TIME_SCHEDULE_DATE_ID | DATE | Date Scheduled to ship item | ||
TIME_SNAPSHOT_DATE_ID | DATE | Date on which the snapshot was taken | ||
LINE_NUMBER | VARCHAR2 | (240) | Line sequence number within the order | |
DAYS_LATE_REQUEST | NUMBER | Count of Days Late (to request) | ||
DAYS_LATE_SCHEDULE | NUMBER | Count of Days Late (to schedule) | ||
BACKORDER_QTY | NUMBER | Backordered Quantity | ||
UOM | VARCHAR2 | (30) | Unit Of Measure Code | |
BACKORDER_LINE_CNT | NUMBER | Count of Backordered Order Lines | ||
SOLD_TO_ORG_ID | NUMBER | Sold to Organization ID | ||
SHIP_TO_ORG_ID | NUMBER | Ship to Organization ID | ||
LINE_ID | NUMBER | Line Id |
Cut, paste (and edit) the following text to query this object:
SELECT INV_ORG_ID
, INVENTORY_ITEM_ID
, CUSTOMER_ID
, ORDER_NUMBER
, HEADER_ID
, TIME_REQUEST_DATE_ID
, TIME_SCHEDULE_DATE_ID
, TIME_SNAPSHOT_DATE_ID
, LINE_NUMBER
, DAYS_LATE_REQUEST
, DAYS_LATE_SCHEDULE
, BACKORDER_QTY
, UOM
, BACKORDER_LINE_CNT
, SOLD_TO_ORG_ID
, SHIP_TO_ORG_ID
, LINE_ID
FROM ISC.ISC_BOOK_SUM2_BKORD_F;
ISC.ISC_BOOK_SUM2_BKORD_F does not reference any database object
ISC.ISC_BOOK_SUM2_BKORD_F is referenced by following:
|
|
|