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