SQL Basics
 

 
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)

                                                                 

                                                      Phone: (506) 857-0909
                                                        Fax: (506) 858-9271
                                                  Email: advatek@nbnet.nb.ca