|
|
|
|
ORDERS
|
ORDERSBKP
|
|
IDEN CHAR(10) NOT NULL
|
IDEN CHAR(10) NOT NULL
|
|
CUSTOMER CHAR(6)
|
CUSTOMER CHAR(6)
|
|
PACKINGSLIP CHAR(10)
|
PACKINGSLIP CHAR(10)
|
|
ENTRY_DATE DATE
|
ENTRY_DATE DATE
|
|
SCAN_DATE DATE
|
SCAN_DATE DATE
|
|
ITEMS_ORD SMALLINT
|
ITEMS_ORD SMALLINT
|
|
ITEMS_SCAN SMALLINT
|
ITEMS_SCAN SMALLINT
|
|
ITEMS_ADD SMALLINT
|
ITEMS_ADD SMALLINT
|
|
ITEMS_UNFILL SMALLINT
|
ITEMS_UNFILL SMALLINT
|
|
ENTRY_PERSON CHAR(10)
|
ENTRY_PERSON CHAR(10)
|
|
CONTACT CHAR(20)
|
CONTACT CHAR(20)
|
|
NOTES CHAR(50)
|
NOTES CHAR(50)
|
|
STATUS SMALLINT
|
STATUS SMALLINT
|
|
TOTCASES SMALLINT
|
TOTCASES SMALLINT
|
|
WHOLE SMALLINT
|
WHOLE SMALLINT
|
|
PIECES SMALLINT
|
PIECES SMALLINT
|
|
NETWEIGHT NUMERIC(9, 2)
|
NETWEIGHT NUMERIC(9, 2)
|
|
GROSSWEIGHT NUMERIC(9, 2)
|
GROSSWEIGHT NUMERIC(9, 2)
|
|
AMOUNT NUMERIC(9, 2)
|
AMOUNT NUMERIC(9, 2)
|
|
STATIONS CHAR(20)
|
STATIONS CHAR(20)
|
|
DATESTR CHAR(11)
|
DATESTR CHAR(11)
|
|
|
|
|
ORDITEMS
|
PACKAGES
|
|
ITEM SMALLINT
|
CODE CHAR(8) NOT NULL
|
|
IDEN CHAR(10)
|
NAME CHAR(20)
|
|
PRODUCT CHAR(6)
|
TARE NUMERIC(9, 2)
|
|
CUSTOMER CHAR(6)
|
MINWGT NUMERIC(9, 2)
|
|
ORDERITEM CHAR(10)
|
MAXWGT NUMERIC(9, 2)
|
|
FILLITEM CHAR(10)
|
STATIONS CHAR(20)
|
|
STATUS SMALLINT
|
|
|
|
