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