Name - Type
Created - Double
LastChanged - Double
Number - Long - Indexed
ID - Currency - Indexed
Code - String * 20 - Indexed
Description - String * 32 - Indexed
Class - String * 16 - Indexed
Manufacturer - String * 20 - Indexed
Department - String * 8
Category - String * 8
Location - String * 8
Store - Long
Parent - Long
LongDescription String - * 40
Comment - Long
SerialNumbers - Long
Price - Currency
ListPrice - Currency
SalePrice - Currency
PriceLevel1 - Currency
PriceLevel2 - Currency
PriceLevel3 - Currency
OldPrice - Currency
PriceChangedOn - Double
LastPrintedPrice - Currency
XFerPrice1 - Currency
XFerQty1 - Single
XFerPrice2 - Currency
XFerQty2 - Single
Cost - Currency
LastCost - Currency
FixedCost - Currency
QOH - Single
QAllocated - Single
QLayaway - Single
QOrdered - Singlev
MinQ - Single
MaxQ - Single
OrderQ - Single
OrderMultiplier - Single
OrderUnit - String * 8
OrderInterval - Single
AvgFillDate - Long
AvgFillRatio - Single
SaleQty - Single
SaleUnit - String * 8
TotalSold - Single
TotalPurchased - Single
TotalVarianceQty - Single
TotalTransferedQty - Singlev
LastSold - Long
LastShipped - Long
LastPurchased - Long
LastRecvd - Long
LastTransfered - Long
LastCounted - Long
AvgLeadTime - Long
PriceCode - String * 4
TaxCode - String * 4
CommissionCode - String * 4
MatrixTable - String * 4
SecurityLevel - Long
Flag - Long
- 1 = Service Item
- 2 = OnSale
- 4 = No Price Tag
- 8 = Scripted Item (hidden)
- 16 = Serialized Item
- 32 = Use Scale
- 64 = Not Discountable
- 128 = Rental Item
- 256 = Web Item
- 512 = Closeout Item
- 8192 = User Flag 1
- 16384 = User Flag 2
- 32768 = FoodStamp Item
- 65536 = WIC Item
- 131072 = Cannot be Cleared from Trans
- 262144 = Bulk Item
Weight - Single
DisplayArea - Single
DisplayQty - Single
V1Number - Long
V1PartNum - String * 20
V1Cost - Currency
V1LastPurchased - Long
V1LastQtyOrdered - Single
V2Number - Long
V2PartNum - String * 20
V2Cost - Currency
V2LastPurchased - Long
V1LastQtyOrdered - Single
V3Number - Long
V3PartNum - String * 20
V3Cost - Currency
V3LastPurchased - Long
V3LastQtyOrdered - Single
V4Number - Long
V4PartNum - String * 20
V4Cost - Currency
V4LastPurchased Long
V4LastQtyOrdered - Single
ChildQty - Single
UserDate1 - Long
UserDate2 - Long
UserNumber1 - Currency
UserNumber2 - Currency
UserShortInfo1 - String * 4
UserShortInfo2 - String * 4
UserInfo1 - String * 20
UserInfo2 - String * 20
UserLongInfo1 - String * 40
UserLongInfo2 - String * 40
UserFlags - Long
Reserved - String * 256