|
|
|
| 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 |
|
|
|
