|
|
|
|
VOIDSBKP
|
VOUCHERS
|
|
BOXNO INTEGER
|
IDEN CHAR(10) NOT NULL
|
|
PRODUCT CHAR(6)
|
FARM CHAR(6)
|
|
SERIAL CHAR(11)
|
INVOICE_DATE DATE
|
|
WHOLE SMALLINT
|
WHOLE SMALLINT
|
|
PIECES SMALLINT
|
PIECES SMALLINT
|
|
UNITS SMALLINT
|
UNITS SMALLINT
|
|
DATECODE DATE
|
GROSSWEIGHT NUMERIC(9, 2)
|
|
CUSTOMER CHAR(6)
|
NETWEIGHT NUMERIC(9, 2)
|
|
LOT SMALLINT
|
COMMISSION NUMERIC(9, 2)
|
|
FARM CHAR(6)
|
PROCESSING NUMERIC(9, 2)
|
|
CAGE SMALLINT
|
BOOM_TRUCK NUMERIC(9, 2)
|
|
BOXTYPE SMALLINT
|
TAGS NUMERIC(9, 2)
|
|
LABELWEIGHT NUMERIC(9, 2)
|
TRAYS NUMERIC(9, 2)
|
|
GROSSWEIGHT NUMERIC(9, 2)
|
FREIGHT NUMERIC(9, 2)
|
|
NETWEIGHT NUMERIC(9, 2)
|
SUBTOTAL NUMERIC(9, 2)
|
|
TIMESTAMP DATE
|
CHARGE1 NUMERIC(9, 2)
|
|
PRICE NUMERIC(9, 2)
|
CHARGE2 NUMERIC(9, 2)
|
|
PACKSTATION SMALLINT
|
CHARGE3 NUMERIC(9, 2)
|
|
OPER CHAR(6)
|
CREDIT1 NUMERIC(9, 2)
|
|
STATUS SMALLINT
|
CREDIT2 NUMERIC(9, 2)
|
|
ORDERID CHAR(10)
|
CREDIT3 NUMERIC(9, 2)
|
|
SLIPID CHAR(10)
|
TOTAL NUMERIC(9, 2)
|
|
VOUCHERID CHAR(10)
|
NOTES CHAR(50)
|
|
INVOICEID CHAR(10)
|
PO_NUMBER CHAR(30)
|
|
INVENTORY CHAR(8)
|
FOB CHAR(30)
|
|
DATESTR CHAR(11)
|
SALETERMS CHAR(30)
|
|
PVALUE NUMERIC(9, 2)
|
TOADDRESS CHAR(200)
|
|
CURRENCY SMALLINT
|
STATUS SMALLINT
|
|
|
TOT_CASES SMALLINT
|
|
|
AMOUNT NUMERIC(9, 2)
|
|
|
FROM_DAY DATE
|
|
|
TO_DAY DATE
|
|
|
CURRENCY SMALLINT
|
|
|
USEXCHANGE NUMERIC(9, 4)
|
|
|
CDNEXCHANGE NUMERIC(9, 4)
|
|
|
DATESTR CHAR(11)
|
|
|
