|
|
|
| SCANREPORT |
SCANS |
| BATCH INTEGER |
BATCH INTEGER |
| RECVTIME DATE |
RECVTIME DATE |
| CUSTOMER CHAR(6) NOT NULL |
CUSTOMER CHAR(6) NOT NULL |
| ORDERID CHAR(10) NOT NULL |
ORDERID CHAR(10) NOT NULL |
| SERIAL CHAR(11) NOT NULL |
SERIAL CHAR(11) NOT NULL |
| TIMESTAMP DATE NOT NULL |
TIMESTAMP DATE NOT NULL |
| STATUS SMALLINT |
STATUS SMALLINT |
| PASS SMALLINT |
|
| BOXNO INTEGER |
|
| PRODUCT CHAR(6) |
|
| |
|
| SLIPS |
SLIPSBKP |
| IDEN CHAR(10) NOT NULL |
IDEN CHAR(10) NOT NULL |
| CUSTOMER CHAR(6) |
CUSTOMER CHAR(6) |
| ORDERID CHAR(10) |
ORDERID CHAR(10) |
| INVOICE CHAR(10) |
INVOICE CHAR(10) |
| PACK_DATE DATE |
PACK_DATE DATE |
| SHIP_DATE DATE |
SHIP_DATE DATE |
| PIECES SMALLINT |
PIECES SMALLINT |
| UNITS SMALLINT |
UNITS SMALLINT |
| GROSSWEIGHT NUMERIC(9, 2) |
GROSSWEIGHT NUMERIC(9, 2) |
| NETWEIGHT NUMERIC(9, 2) |
NETWEIGHT NUMERIC(9, 2) |
| NOTES CHAR(50) |
NOTES CHAR(50) |
| PO_NUMBER CHAR(30) |
PO_NUMBER CHAR(30) |
| SHIPADDRESS CHAR(200) |
SHIPADDRESS CHAR(200) |
| WAYBILL CHAR(30) |
WAYBILL CHAR(30) |
| PREPAID SMALLINT |
PREPAID SMALLINT |
| STATUS SMALLINT |
STATUS SMALLINT |
| TOTCASES SMALLINT |
TOTCASES SMALLINT |
| DATESTR CHAR(11) |
DATESTR CHAR(11) |
| AMOUNT NUMERIC(9, 2) |
AMOUNT NUMIERIC(9, 2) |
| SHIPPER CHAR(20) |
SHIPPER CHAR(20) |
| SENDER CHAR(8) |
SENDER CHAR(8) |
| SENDADDRESS CHAR(200) |
SENDADDRES CHAR(200) |
| WHOLE INTEGER |
WHOLE INTEGER |
|
|
