eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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