[Home] [Help] [Dependency Information]
Object Name: | ISC_BOOK_SUM2_PDUE2_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Base summary table for past due information on the Customer Fulfillment Management page. This table stores current past due amounts and days late according to the scheduled shipment date and the promised date. It stores the information in snapshots at the line level. It contains current past due amounts in the global (primary and secondary) currency and organization functional currency.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_BOOK_SUM2_PDUE2_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CUSTOMER_ID |
ISC_BOOK_SUM2_PDUE2_F_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SOLD_TO_ORG_ID |
ISC_BOOK_SUM2_PDUE2_F_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SHIP_TO_ORG_ID |
ISC_BOOK_SUM2_PDUE2_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 | ||
TIME_BOOKED_DATE_ID | DATE | Indicates the date when the order was booked | ||
TIME_SNAPSHOT_DATE_ID | DATE | Date on which the snapshot was taken | ||
ORDER_NUMBER | NUMBER | User-visible number of the order | ||
HEADER_ID | NUMBER | Order Header Identifier | ||
DAYS_LATE | NUMBER | Count of Days Late (to schedule) | ||
DAYS_LATE_PROMISE | NUMBER | Count of Days Late (to promise) | ||
PDUE_AMT_F | NUMBER | Past Due amount in Functional currency | ||
PDUE_AMT_G | NUMBER | Past Due amount in Global currency | ||
PDUE_QTY | NUMBER | Past Due Quantity | ||
UOM | VARCHAR2 | (30) | Unit Of Measure Code | |
LATE_SCHEDULE_FLAG | NUMBER | Grouping ID Column for Past Due Schedule Order Lines | ||
LATE_PROMISE_FLAG | NUMBER | Grouping ID Column for Past Due Promise Order Lines | ||
LINE_NUMBER | VARCHAR2 | (240) | Line sequence number within the order | |
PDUE_LINE_CNT | NUMBER | Count of Lines Past Due Schedule | ||
PDUE_AMT_G1 | NUMBER | Past Due amount in Secondary Global currency | ||
SOLD_TO_ORG_ID | NUMBER | Sold to Organization ID | ||
SHIP_TO_ORG_ID | NUMBER | Ship to Organization ID | ||
TOP_MODEL_LINE_ID | NUMBER | Top Model Line Id | ||
LINE_ID | NUMBER | Line Id | ||
ITEM_TYPE_CODE | VARCHAR2 | (80) | Item Type Code |
Cut, paste (and edit) the following text to query this object:
SELECT INV_ORG_ID
, INVENTORY_ITEM_ID
, CUSTOMER_ID
, TIME_BOOKED_DATE_ID
, TIME_SNAPSHOT_DATE_ID
, ORDER_NUMBER
, HEADER_ID
, DAYS_LATE
, DAYS_LATE_PROMISE
, PDUE_AMT_F
, PDUE_AMT_G
, PDUE_QTY
, UOM
, LATE_SCHEDULE_FLAG
, LATE_PROMISE_FLAG
, LINE_NUMBER
, PDUE_LINE_CNT
, PDUE_AMT_G1
, SOLD_TO_ORG_ID
, SHIP_TO_ORG_ID
, TOP_MODEL_LINE_ID
, LINE_ID
, ITEM_TYPE_CODE
FROM ISC.ISC_BOOK_SUM2_PDUE2_F;
ISC.ISC_BOOK_SUM2_PDUE2_F does not reference any database object
ISC.ISC_BOOK_SUM2_PDUE2_F is referenced by following:
|
|
|