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