SQL Basics
 

 
STATION VOIDS
ID SMALLINT BOXNO INTEGER
NAME CHAR(20) PRODUCT CHAR(6)
STATUS SMALLINT SERIAL CHAR(11)
SEQUENCE SMALL INT WHOLE SMALLINT
BOXNO INTEGER PIECES SMALLINT
PRODUCT CHAR(6) UNITS SMALLINT
UNITS SMALLINT DATECODE DATE
DATECODE DATE CUSTOMER CHAR(6)
CUSTOMER CHAR(6) LOT SMALLINT
LOT SMALLINT FARM CHAR(6)
FARM CHAR(6) CAGE SMALLINT
CAGE SMALLINT BOXTYPE SMALLINT
BOXTYPE SMALLINT LABELWEIGHT NUMERIC(9, 2)
DATETIME DATE GROSSWEIGHT NUMERIC(9, 2)
OPER CHAR(6) NETWEIGHT NUMERIC(9, 2)
CNT_PRODUCTS SMALLINT TIMESTAMP DATE
CNT_CUSTOMERS SMALLINT PRICE NUMERIC(9, 2)
CNT_BOXTYPES SMALLINT PACKSTATION SMALLINT
CNT_FARMS SMALLINT OPER CHAR(6)
PASSWORD1 CHAR(9) STATUS SMALLINT
PASSWORD2 CHAR(9) ORDERID CHAR(10)
  SLIPID CHAR(10)
TXBUFF VOUCHERID CHAR(10)
ID INTEGER INVOICEID CHAR(10)
COMMAND CHAR(20) INVENTORY CHAR(8)
DATA CHAR(250) DATESTR CHAR(11)
STATIONLIST CHAR(50) PVALUE NUMERIC(9, 2)
  CURRENCY SMALLINT

                                                                 

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