|
|
|
| PRODUCTION |
PRODUCTS |
| BOXNO INTEGER |
CODE CHAR(8) NOT NULL |
| PRODUCT CHAR(6) |
NAME CHAR(20) |
| SERIAL CHAR(11) |
QUALITY CHAR(8) |
| WHOLE SMALLINT |
FSIZE CHAR(8) |
| PIECES SMALLINT |
STYLE CHAR(8) |
| UNITS SMALLINT |
SCC CHAR(14) |
| DATECODE DATE |
PACKAGE CHAR(8) |
| CUSTOMER CHAR(6) |
LABEL CHAR(8) |
| LOT SMALLINT |
MINWGT NUMERIC(9, 2) |
| FARM CHAR(6) |
MAXWGT NUMERIC(9, 2) |
| CAGE SMALLINT |
BXS_PALLET SMALLINT |
| BOXTYPE SMALLINT |
STATIONS CHAR(20) |
| LABELWEIGHT NUMERIC(9, 2) |
TYPE CHAR(3) |
| GROSSWEIGHT NUMERIC(9, 2) |
PRICE NUMERIC(9, 2) |
| NETWEIGHT NUMERIC(9, 2) |
|
| TIMESTAMP DATE |
|
| PRICE NUMERIC(9, 2) |
|
| PACKINGSTATION SMALLINT |
|
| OPER CHAR(6) |
|
| STATUS SMALLINT |
|
| ORDERID CHAR(10) |
|
| SLIPID CHAR(10) |
|
| VOUCHERID CHAR(10) |
|
| INVOICEID CHAR(10) |
|
| INVENTORY CHAR(8) |
|
| DATESTR CHAR(11) |
|
| PVALUE NUMERIC(9, 2) |
|
| CURRENCY SMALLINT |
|
| WF INTEGER |
|
| |
|
| RXBUFF |
SCANDATA |
| ID INTEGER |
BATCH INTEGER |
| COMMAND CHAR(20) |
RECVTIME DATE |
| DATA CHAR(250) |
CUSTOMER CHAR(6) NOT NULL |
| STATION CHAR(50) |
ORDERID CHAR(10) NOT NULL |
| TIMESTAMP CHAR(20) |
SERIAL CHAR(11) NOT NULL |
| TIMEIS CHAR(20) |
TIMESTAMP DATE NOT NULL |
| |
STATUS SMALLINT |
|
|
