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