Back
Inventory (IN) - INCATWKS
| Name |
Type |
Length |
Decimal |
Relation |
Description |
| ITEMNUM |
String |
25 |
|
|
IN ITEMNUM |
| WHNUM |
String |
8 |
|
|
IN WHNUM |
| REOQTY |
Decimal |
10 |
3 |
|
IN REOQTY |
| ITEMDESC |
String |
60 |
|
|
IN ITEMDESC |
| STANDCOST |
Decimal |
12 |
4 |
|
IN STANDCOST |
| STANDPRICE |
Decimal |
12 |
4 |
|
IN STANDPRICE |
| SHIPPEDQT1 |
Decimal |
7 |
0 |
|
IN SHIPPEDQT1 |
| SHIPPEDQT2 |
Decimal |
7 |
0 |
|
IN SHIPPEDQT2 |
| SHIPPEDQT3 |
Decimal |
7 |
0 |
|
IN SHIPPEDQT3 |
| SALES1 |
Decimal |
7 |
0 |
|
IN SALES1 |
| SALES2 |
Decimal |
7 |
0 |
|
IN SALES2 |
| SALES3 |
Decimal |
7 |
0 |
|
IN SALES3 |
| ONHAND |
Decimal |
7 |
0 |
|
IN ONHAND |
| OPENINGBAL |
Decimal |
7 |
0 |
|
IN OPENINGBAL |
| PTDRECEIPT |
Decimal |
7 |
0 |
|
IN PTDRECEIPT |
| PTDADJUSTM |
Decimal |
7 |
0 |
|
IN PTDADJUSTM |
| PTDSALES |
Decimal |
7 |
0 |
|
IN PTDSALES |
| OPENPURCHA |
Decimal |
7 |
0 |
|
IN OPENPURCHA |
| OPENSALES |
Decimal |
7 |
0 |
|
IN OPENSALES |
| AVAILABLE |
Decimal |
7 |
0 |
|
IN AVAILABLE |
| NOTPICKED |
Decimal |
7 |
0 |
|
IN NOTPICKED |
| PICKED |
Decimal |
7 |
0 |
|
IN PICKED |
| INSTOCK |
Decimal |
7 |
0 |
|
IN INSTOCK |
| ONWATER |
Decimal |
7 |
0 |
|
IN ONWATER |
| VENDOR |
String |
10 |
|
|
IN VENDOR |
| KEYID |
String |
12 |
|
|
IN KEYID |
| CAT1 |
Decimal |
10 |
2 |
|
IN CAT1 |
| CAT2 |
Decimal |
10 |
2 |
|
IN CAT2 |
| SHOW1 |
Decimal |
10 |
2 |
|
IN SHOW1 |
| SHOW2 |
Decimal |
10 |
2 |
|
IN SHOW2 |
| COST2 |
Decimal |
7 |
0 |
|
IN COST2 |
| COST3 |
Decimal |
7 |
0 |
|
IN COST3 |
| COST1 |
Decimal |
7 |
0 |
|
IN COST1 |
| LASTSOLD |
DateTime |
8 |
|
|
IN LASTSOLD |
| LASTRCPT |
DateTime |
8 |
|
|
IN LASTRCPT |
| ITEMDIV |
String |
4 |
|
|
IN ITEMDIV |
| GP1 |
Decimal |
7 |
0 |
|
IN GP1 |
| GP2 |
Decimal |
7 |
0 |
|
IN GP2 |
| GP3 |
Decimal |
7 |
0 |
|
IN GP3 |
| GPP1 |
Decimal |
6 |
0 |
|
IN GPP1 |
| GPP2 |
Decimal |
6 |
0 |
|
IN GPP2 |
| GPP3 |
Decimal |
6 |
0 |
|
IN GPP3 |