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