item

Type: table

Columns

Column	Type	Attributes	Description
averagecost	decimal
balance	decimal
cogsaccountrowid	int
cogsclassrowid	int
commissionable	smallint
commissionpercent	decimal
companyrowid	int
costmethod	varchar
defaultsitelocationrowid	int
defaultsiterowid	int
description	varchar
discountpricemethod	varchar
establisheddate	datetime
expenseaccountrowid	int
expenseclassrowid	int
explodesku	smallint
featurecode	varchar
haschildren	smallint
inventoryaccountrowid	int
inventoryclassrowid	int
isactive	tinyint
issku	smallint
itemcategoryattribute1	varchar
itemcategoryattribute2	varchar
itemcategoryattribute3	varchar
itemcategoryattribute4	varchar
itemcategorylistitemrowid	int
itemcategoryrule	varchar
itemid	varchar
itemtypelistitemrowid	int
lotserialnbrtracking	smallint
minimumqty	decimal
nestlevel	smallint
parentrowid	int
priceatskulevel	smallint
pricelevelrowid	int
pricetiertype	varchar
purchaseproductlinerowid	int
qtyonhand	decimal
qtyonpurchaseorder	decimal
qtyonquote	decimal
qtyonsalesorder	decimal
reorderqty	decimal
rowid	int	auto_increment
salesaccountrowid	int
salesclassrowid	int
salesproductlinerowid	int
sellable	smallint
sortorder	varchar
subjectrowid	int
taxable	smallint
unitcost	decimal
unitprice	decimal
unitpriceeffectivedate	datetime
unitrowid	int
updatetimestamp	timestamp	on update CURRENT_TIMESTAMP
varianceaccountrowid	int
varianceclassrowid	int
vendorrolepolicyrowid	int

v.ismain -- Wed, Feb 28, 2018 2:58 PM