'COMPONENTS identifies the component parts used to assemble a product in PRODUCT. It also contains the price information for each component. COMPONENTS and PRODCOMP provide a single-level bill of materials for each product.
COMMENT ON COLUMN USERID.ORDER_SUMMARY.ORDERREF IS
'Order reference number.
';
COMMENT ON COLUMN USERID.ORDER_SUMMARY.CUSTNO IS
'CelDial customer number.
';
COMMENT ON COLUMN USERID.ORDER_SUMMARY.SHIPID IS
'Ship location identifier.
';
COMMENT ON COLUMN USERID.ORDER_SUMMARY.ORDERDATE IS
'Order date.
';
COMMENT ON COLUMN USERID.ORDER_SUMMARY.CUSTSHIPDATE IS
'Customer requested ship date.
';
COMMENT ON COLUMN USERID.ORDER_SUMMARY.PLANSHIPDATE IS
'Planned ship date.
';
COMMENT ON COLUMN USERID.ORDER_SUMMARY.STATUS IS
'Order status.
';
COMMENT ON COLUMN USERID.ORDER_SUMMARY.COMMENTS IS
'Comments.
';
COMMENT ON TABLE USERID.ORDER_SUMMARY IS
'ORDER_SUMMARY tracks the status of both retail and wholesale customer orders. It contains general information that applies to all the order lines (ORDER_DETAIL) contained in the order.
'PRODSHOW contains a bitmap image of the product. Enables the telemarketers to verify that the product ID number corresponds to the product description.