|
|
|
|
INVOICEBKP
|
ORDERDETAILS
|
|
IDEN CHAR(10) NOT NULL
|
ITEM SMALLINT NOT NULL
|
|
CUSTOMER CHAR(6)
|
IDEN CHAR910) NOT NULL
|
|
PACKINGSLIP CHAR(10)
|
PRODUCT CHAR(6) NOT NULL
|
|
SHIP_DATE DATE
|
WHOLE SMALINT
|
|
INVOICE_DATE DATE
|
PIECES SMALLINT
|
|
WHOE SMALLINT
|
UNITS SMALLINT
|
|
PIECES SMALLINT
|
CUSTOMER CHAR(6)
|
|
UNITS SMALLINT
|
GROSSWEIGHT NUMERIC(9, 2)
|
|
GROSSWEIGHT NUMERIC(9, 2)
|
NETWEIGHT NUMERIC(9, 2)
|
|
NETWEIGHT NUMERIC(9, 2)
|
ORDERED SMALLINT
|
|
SUBTOTAL NUMERIC(9, 2)
|
FILLED SMALLINT
|
|
CHARGE1 NUMERIC(9, 2)
|
SUBSTITUTED SMALLINT
|
|
CHARGE2 NUMERIC(9, 2)
|
STATUS SMALLINT
|
|
CHARGE3 NUMERIC(9, 2)
|
AMOUNT NUMERIC(9, 2)
|
|
CREDIT1 NUMERIC(9, 2)
|
PRICE NUMERIC(9, 2)
|
|
CREDIT2 NUMERIC(9, 2)
|
|
|
CREDIT3 NUMERIC(9, 2)
|
ORDERDETAILSBKP
|
|
TOTAL NUMERIC(9, 2)
|
ITEM SMALLINT NOT NULL
|
|
NOTES CHAR(50)
|
IDEN CHAR(10) NOT NULL
|
|
PO_NUMBER CHAR(30)
|
PRODUCT CHAR(6) NOT NULL
|
|
FOB CHAR(30)
|
WHOLE SMALLINT
|
|
SALETERMS CHAR(30)
|
PIECES SMALLINT
|
|
TOADDRESS CHAR(200)
|
UNITS SMALLINT
|
|
STATUS SMALLINT
|
CUSTOMER CHAR(6)
|
|
TOT_CASES SMALLINT
|
GROSSWEIGHT NUMERIC(9, 20)
|
|
CURRENCY SMALLINT
|
NETWEIGHT NUMERIC(9, 2)
|
|
USEXCHANGE NUMERIC(9, 4)
|
ORDERED SMALLINT
|
|
CDNEXCHANGE NUMERIC(9, 4)
|
FILLED SMALLINT
|
|
DATESTR CHAR(11)
|
SUBSTITUTED SMALLINT
|
|
SLIPS VARCHAR(100)
|
STATUS SMALLINT
|
|
PRINTCUR SMALLINT
|
AMOUNT NUMERIC(9, 2)
|
|
|
PRICE NUMERIC(9, 2)
|
|
|
