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