[Home] [Help]
View: ISC_OPI_TOP_ORD_WK_S
Product: | ISC - Supply Chain Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT "SOBL_BOOK_FK_KEY"
, "OPER_UNIT_FK_KEY"
, "CAL_DAY_FK_KEY"
, "TPRT_FK_KEY"
, "ORDER_NUMBER"
, "CUSTOMER_NAME"
, "ORDERED_DATE"
, "NET_BOOKED_VALUE"
, "BOOKED_DATE"
, "SHIPPED_VALUE"
, "LATEST_SHIP_DATE"
, "FULFILLED_VALUE"
, "FULFILLED_DATE"
, "INVOICED_VALUE"
, "HEADER_ID"
, "NUM_OF_ORDERS"
, "RANK"
FROM ISC_OPI_TOP_ORD_WK_BASE_V
WHERE RANK < 101
Columns
Name |
SOBL_BOOK_FK_KEY |
OPER_UNIT_FK_KEY |
CAL_DAY_FK_KEY |
TPRT_FK_KEY |
ORDER_NUMBER |
CUSTOMER_NAME |
ORDERED_DATE |
NET_BOOKED_VALUE |
BOOKED_DATE |
SHIPPED_VALUE |
LATEST_SHIP_DATE |
FULFILLED_VALUE |
FULFILLED_DATE |
INVOICED_VALUE |
HEADER_ID |
NUM_OF_ORDERS |
RANK |