|
|
|
|
DETAILS
|
DETAILSBKP
|
|
ITEM SMALLINT
|
ITEM SMALLINT
|
|
IDEN CHAR(10)
|
IDEN CHAR(10)
|
|
PRODUCT CHAR(6)
|
PRODUCT CHAR(6)
|
|
PIECES SMALLINT
|
PIECES SMALLINT
|
|
UNITS SMALLINT
|
UNITS SMALLINT
|
|
CUSTOMER CHAR(6)
|
CUSTOMER CHAR(6)
|
|
GROSSWEIGHT NUMERIC(9, 2)
|
GROSSWEIGHT NUMERIC(9, 2)
|
|
NETWEIGHT NUMERIC(9, 2)
|
NETWEIGHT NUMERIC(9, 2)
|
|
PRICE NUMERIC(9, 2)
|
PRICE NUMERIC(9, 2)
|
|
STATUS SMALLINT
|
STATUS SMALLINT
|
|
DET_DATE DATE
|
DET_DATE DATE
|
|
PRICETOCDN NUMERIC(9, 4)
|
PRICETOCDN NUMERIC(9, 4)
|
|
PRICETOUS NUMERIC(9, 4)
|
PRICETOUS NUMERIC(9, 4)
|
|
CASES SMALLINT
|
CASES SMALLINT
|
|
UNIT CHAR(3)
|
UNIT CHAR(3)
|
|
CURRENCY SMALLINT
|
CURRENCY SMALLINT
|
|
WHOLE INTEGER
|
WHLE INTEGER
|
|
|
|
|
FARMS
|
INVOICES (CONTINUED)
|
|
CODE CHAR(8) NOT NULL
|
CREDIT1 NUMERIC(9, 2)
|
|
NAME CHAR(20)
|
CREDIT2 NUMERIC(9, 2)
|
|
ADDRESS CHAR(200)
|
CREDIT3 NUMERIC(9, 2)
|
|
STATIONS CHAR(20)
|
TOTAL NUMERIC(9, 2)
|
|
|
NOTES CHAR(50)
|
|
INVOICES
|
PO_NUMBER CHAR(30)
|
|
IDEN CHAR(10) NOT NULL
|
FOB CHAR(30)
|
|
CUSTOMER CHAR(6)
|
SALETERMS CHAR(30)
|
|
PACKINGSLIP CHAR(10)
|
TOADDRESS CHAR(200)
|
|
SHIP_DATE DATE
|
STATUS SMALLINT
|
|
INVOICE_DATE DATE
|
TOT_CASES SMALLINT
|
|
PIECES SMALLINT
|
CURRENCY SMALLINT
|
|
UNITS SMALLINT
|
USEXCHANGE NUMERIC(9, 4)
|
|
GROSSWEIGHT NUMERIC(9, 2)
|
CDNEXCHANGE NUMERIC(9, 4)
|
|
NETWEIGHT NUMERIC(9, 2)
|
DATESTR CHAR(11)
|
|
SUBTOTAL NUMERIC(9, 2)
|
SLIPS VARCHAR(100)
|
|
CHARGE1 NUMERIC(9, 2)
|
PRINTCUR SMALLINT
|
|
CHARGE2 NUMERIC(9, 2)
|
WHOLE INTEGER
|
|
CHARGE3 NUMERIC(9, 2)
|
|
|
|
