[Home] [Help] [Dependency Information]
Object Name: | MLOG$_ISC_BOOK_SUM2_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
snapshot log for master table ISC.ISC_BOOK_SUM2_F
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTUAL_SHIPMENT_DATE | DATE | |||
ATO_LINE_ID | NUMBER | |||
BOOKED_AMT_F | NUMBER | |||
BOOKED_AMT_F1 | NUMBER | |||
BOOKED_AMT_G | NUMBER | |||
BOOKED_AMT_G1 | NUMBER | |||
BOOKED_DATE | DATE | |||
BOOKED_LIST_AMT_F | NUMBER | |||
BOOKED_LIST_AMT_F1 | NUMBER | |||
BOOKED_LIST_AMT_G | NUMBER | |||
BOOKED_LIST_AMT_G1 | NUMBER | |||
BOOKED_QTY_INV | NUMBER | |||
COUNT_PDUE_LINE | NUMBER | |||
COUNT_SHIP_LINE | NUMBER | |||
CURRENCY_FUNC_ID | VARCHAR2 | (30) | ||
CURR_WH_FUNC_ID | VARCHAR2 | (30) | ||
CUSTOMER_ID | NUMBER | |||
FLOW_STATUS_CODE | VARCHAR2 | (80) | ||
FULFILLED_AMT_F | NUMBER | |||
FULFILLED_AMT_F1 | NUMBER | |||
FULFILLED_AMT_G | NUMBER | |||
FULFILLED_AMT_G1 | NUMBER | |||
FULFILLED_DATE | DATE | |||
FULFILLED_FLAG | VARCHAR2 | (30) | ||
FULFILLED_QTY_INV | NUMBER | |||
HEADER_ID | NUMBER | |||
H_MARKETING_SOURCE_CODE_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
INVOICED_AMT_F | NUMBER | |||
INVOICED_AMT_F1 | NUMBER | |||
INVOICED_AMT_G | NUMBER | |||
INVOICED_AMT_G1 | NUMBER | |||
INVOICED_QTY_INV | NUMBER | |||
INVOICE_TO_ORG_ID | NUMBER | |||
INV_ORG_ID | NUMBER | |||
INV_OU_ID | NUMBER | |||
INV_UOM_CODE | VARCHAR2 | (30) | ||
ITEM_ID | NUMBER | |||
ITEM_INV_ORG_ID | NUMBER | |||
ITEM_TYPE_CODE | VARCHAR2 | (80) | ||
LINE_CATEGORY_CODE | VARCHAR2 | (80) | ||
LINE_ID | NUMBER | |||
LINE_ITEM_TYPE | NUMBER | |||
LINE_NUMBER | VARCHAR2 | (240) | ||
MARKETING_SOURCE_CODE_ID | NUMBER | |||
OPEN_FLAG | VARCHAR2 | (1) | ||
ORDERED_DATE | DATE | |||
ORDERED_QUANTITY | NUMBER | |||
ORDER_CATEGORY_ID | VARCHAR2 | (80) | ||
ORDER_DATE_TYPE_CODE | VARCHAR2 | (80) | ||
ORDER_NUMBER | NUMBER | |||
ORDER_QUANTITY_UOM | VARCHAR2 | (30) | ||
ORDER_SOURCE_ID | VARCHAR2 | (80) | ||
ORDER_TYPE_ID | VARCHAR2 | (80) | ||
ORG_OU_ID | NUMBER | |||
PROMISE_DATE | DATE | |||
REQUEST_DATE | DATE | |||
RETURN_REASON_ID | VARCHAR2 | (80) | ||
SALES_CHANNEL_ID | VARCHAR2 | (80) | ||
SCHEDULE_SHIP_DATE | DATE | |||
SERVICE_PARENT_LINE_ID | NUMBER | |||
SHIPPABLE_FLAG | VARCHAR2 | (30) | ||
SHIPPED_AMT_F | NUMBER | |||
SHIPPED_AMT_F1 | NUMBER | |||
SHIPPED_AMT_G | NUMBER | |||
SHIPPED_AMT_G1 | NUMBER | |||
SHIPPED_DATE | DATE | |||
SHIPPED_QTY_INV | NUMBER | |||
SHIP_TO_ORG_ID | NUMBER | |||
SHIP_TO_PARTY_ID | NUMBER | |||
SOLD_TO_ORG_ID | NUMBER | |||
TIME_ACT_SHIP_DATE_ID | DATE | |||
TIME_BOOKED_DATE_ID | DATE | |||
TIME_FULFILLED_DATE_ID | DATE | |||
TIME_ORDERED_DATE_ID | DATE | |||
TIME_PROMISE_DATE_ID | DATE | |||
TIME_REQUEST_DATE_ID | DATE | |||
TIME_SCHEDULE_DATE_ID | DATE | |||
TIME_SHIPPED_DATE_ID | DATE | |||
TOP_MODEL_ITEM_ID | NUMBER | |||
TOP_MODEL_LINE_ID | NUMBER | |||
TOP_MODEL_ORG_ID | NUMBER | |||
UNIT_LIST_PRICE | NUMBER | |||
UNIT_SELLING_PRICE | NUMBER | |||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) | ||
BLANKET_LINE_NUMBER | NUMBER | |||
BLANKET_NUMBER | NUMBER | |||
CHARGE_PERIODICITY_CODE | VARCHAR2 | (30) | ||
FREIGHT_CHARGE | NUMBER | |||
FREIGHT_CHARGE_F | NUMBER | |||
FREIGHT_CHARGE_G | NUMBER | |||
FREIGHT_CHARGE_G1 | NUMBER | |||
FREIGHT_COST | NUMBER | |||
FREIGHT_COST_F | NUMBER | |||
FREIGHT_COST_G | NUMBER | |||
FREIGHT_COST_G1 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ACTUAL_SHIPMENT_DATE
, ATO_LINE_ID
, BOOKED_AMT_F
, BOOKED_AMT_F1
, BOOKED_AMT_G
, BOOKED_AMT_G1
, BOOKED_DATE
, BOOKED_LIST_AMT_F
, BOOKED_LIST_AMT_F1
, BOOKED_LIST_AMT_G
, BOOKED_LIST_AMT_G1
, BOOKED_QTY_INV
, COUNT_PDUE_LINE
, COUNT_SHIP_LINE
, CURRENCY_FUNC_ID
, CURR_WH_FUNC_ID
, CUSTOMER_ID
, FLOW_STATUS_CODE
, FULFILLED_AMT_F
, FULFILLED_AMT_F1
, FULFILLED_AMT_G
, FULFILLED_AMT_G1
, FULFILLED_DATE
, FULFILLED_FLAG
, FULFILLED_QTY_INV
, HEADER_ID
, H_MARKETING_SOURCE_CODE_ID
, INVENTORY_ITEM_ID
, INVOICED_AMT_F
, INVOICED_AMT_F1
, INVOICED_AMT_G
, INVOICED_AMT_G1
, INVOICED_QTY_INV
, INVOICE_TO_ORG_ID
, INV_ORG_ID
, INV_OU_ID
, INV_UOM_CODE
, ITEM_ID
, ITEM_INV_ORG_ID
, ITEM_TYPE_CODE
, LINE_CATEGORY_CODE
, LINE_ID
, LINE_ITEM_TYPE
, LINE_NUMBER
, MARKETING_SOURCE_CODE_ID
, OPEN_FLAG
, ORDERED_DATE
, ORDERED_QUANTITY
, ORDER_CATEGORY_ID
, ORDER_DATE_TYPE_CODE
, ORDER_NUMBER
, ORDER_QUANTITY_UOM
, ORDER_SOURCE_ID
, ORDER_TYPE_ID
, ORG_OU_ID
, PROMISE_DATE
, REQUEST_DATE
, RETURN_REASON_ID
, SALES_CHANNEL_ID
, SCHEDULE_SHIP_DATE
, SERVICE_PARENT_LINE_ID
, SHIPPABLE_FLAG
, SHIPPED_AMT_F
, SHIPPED_AMT_F1
, SHIPPED_AMT_G
, SHIPPED_AMT_G1
, SHIPPED_DATE
, SHIPPED_QTY_INV
, SHIP_TO_ORG_ID
, SHIP_TO_PARTY_ID
, SOLD_TO_ORG_ID
, TIME_ACT_SHIP_DATE_ID
, TIME_BOOKED_DATE_ID
, TIME_FULFILLED_DATE_ID
, TIME_ORDERED_DATE_ID
, TIME_PROMISE_DATE_ID
, TIME_REQUEST_DATE_ID
, TIME_SCHEDULE_DATE_ID
, TIME_SHIPPED_DATE_ID
, TOP_MODEL_ITEM_ID
, TOP_MODEL_LINE_ID
, TOP_MODEL_ORG_ID
, UNIT_LIST_PRICE
, UNIT_SELLING_PRICE
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
, BLANKET_LINE_NUMBER
, BLANKET_NUMBER
, CHARGE_PERIODICITY_CODE
, FREIGHT_CHARGE
, FREIGHT_CHARGE_F
, FREIGHT_CHARGE_G
, FREIGHT_CHARGE_G1
, FREIGHT_COST
, FREIGHT_COST_F
, FREIGHT_COST_G
, FREIGHT_COST_G1
FROM ISC.MLOG$_ISC_BOOK_SUM2_F;
ISC.MLOG$_ISC_BOOK_SUM2_F does not reference any database object
ISC.MLOG$_ISC_BOOK_SUM2_F is referenced by following:
|
|
|