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
Last updated