Item Table

Back to list of tables.

Column Data type Data type name Length Can be queried? Can be updated? Can be inserted? Mandatory when inserting? Format Refers To Version introduced in Edition available in
ListID 12 VARCHAR 36 True False False False %s 1.0 US, CA, UK
TimeCreated 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
TimeModified 93 TIMESTAMP 23 True False False False CCCC-MM-DDThh:mm:ssZ 1.0 US, CA, UK
EditSequence 12 VARCHAR 16 True False False False %s 1.0 US, CA, UK
Name 12 VARCHAR 31 True True True True %s 1.0 US, CA, UK
FullName 12 VARCHAR 209 True False False False %s 1.0 US, CA, UK
Type 12 VARCHAR 32 1.0 US, CA, UK
BarCode_Value 12 VARCHAR 50 True True True False %s 12.0 US, CA, UK
ItemDesc 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
IsActive -7 BIT 2 True True True False
1
0
true
false
 1.0 US, CA, UK
ClassRef_ListID 12 VARCHAR 36 True True True False %s 12.0 US, CA, UK
ClassRef_FullName 12 VARCHAR 159 True True True False %s 12.0 US, CA, UK
ParentRef_ListID 12 VARCHAR 36 True True True False %s 1.0 US, CA, UK
ParentRef_FullName 12 VARCHAR 159 True True True False %s 1.0 US, CA, UK
Sublevel 4 INTEGER 9 True False False False %11.0f 1.0 US, CA, UK
ManufacturerPartNumber 12 VARCHAR 31 True True True False %s 7.0 US, CA, UK
UnitOfMeasureSetRef_ListID 12 VARCHAR 36 True True True False %s ListID 7.0 US, CA, UK
UnitOfMeasureSetRef_FullName 12 VARCHAR 31 True True True False %s Name 7.0 US, CA, UK
SalesTaxCodeRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
SalesTaxCodeRef_FullName 12 VARCHAR 3 True True True False %s Name 1.0 US, CA, UK
SalesOrPurchase_Desc 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
SalesOrPurchase_Price 2 NUMERIC 15 True True True True %10.5f 1.0 US, CA, UK
SalesOrPurchase_PricePercent 2 NUMERIC 15 True True True True %10.5f 1.0 US, CA, UK
SalesOrPurchase_AccountRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
SalesOrPurchase_AccountRef_FullName 12 VARCHAR 159 True True True True %s FullName 1.0 US, CA, UK
SalesAndPurchase_SalesDesc 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
SalesAndPurchase_SalesPrice 3 DECIMAL 18 True True True False %10.5f 1.0 US, CA, UK
SalesAndPurchase_IncomeAccountRefListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
SalesAndPurchase_IncomeAccountRefFullName 12 VARCHAR 159 True True True True %s FullName 1.0 US, CA, UK
SalesAndPurchase_ApplyIncomeAccountRefToExistingTxns -7 BIT 1 True True False False
1
0
true
false
 1.0 US, CA, UK
SalesAndPurchase_PurchaseDesc 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
SalesAndPurchase_PurchaseCost 3 DECIMAL 18 True True True False %10.5f 1.0 US, CA, UK
SalesAndPurchase_ExpenseAccountRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
SalesAndPurchase_ExpenseAccountRef_FullName 12 VARCHAR 159 True True True True %s FullName 1.0 US, CA, UK
SalesAndPurchase_PrefVendorRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
SalesAndPurchase_PrefVendorRef_FullName 12 VARCHAR 41 True True True False %s Name 1.0 US, CA, UK
SalesDesc 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
SalesPrice 2 NUMERIC 18 True True True False %10.5f 1.0 US, CA, UK
IncomeAccountRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
IncomeAccountRef_FullName 12 VARCHAR 159 True True True True %s FullName 1.0 US, CA, UK
PurchaseDesc 12 VARCHAR 4095 True True True False %s 1.0 US, CA, UK
PurchaseCost 2 NUMERIC 15 True True True False %10.5f 1.0 US, CA, UK
COGSAccountRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
COGSAccountRef_FullName 12 VARCHAR 159 True True True True %s FullName 1.0 US, CA, UK
PrefVendorRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
PrefVendorRef_FullName 12 VARCHAR 41 True True True False %s FullName 1.0 US, CA, UK
AssetAccountRef_ListID 12 VARCHAR 36 True True True True %s ListID 1.0 US, CA, UK
AssetAccountRef_FullName 12 VARCHAR 159 True True True True %s FullName 1.0 US, CA, UK
ReorderPoint 4 INTEGER 9 True True True False %10.5f 1.0 US, CA, UK
BuildPoint 4 INTEGER 9 2.0 US, CA, UK
QuantityOnHand 4 INTEGER 9 True False True False %10.5f 1.0 US, CA, UK
AverageCost 3 DECIMAL 18 True False False False %10.5f 1.0 US, CA, UK
QuantityOnOrder 4 INTEGER 9 True False False False %10.5f 1.0 US, CA, UK
QuantityOnSalesOrder 4 INTEGER 9 True False False False %10.5f 2.0 US, CA, UK
VendorOrPayeeName 12 VARCHAR 50 True True True False %s 3.0 US, CA, UK
FixedAssetSalesInfo_SalesDesc 12 VARCHAR 50 True True True False %s 3.0 US, CA, UK
FixedAssetSalesInfo_SalesDate 91 DATE 10 True True True False CCCC-MM-DD 3.0 US, CA, UK
FixedAssetSalesInfo_SalesPrice 2 NUMERIC 15 True True True False %10.5f 3.0 US, CA, UK
FixedAssetSalesInfo_SalesExpense 2 NUMERIC 15 True True True False %10.5f 3.0 US, CA, UK
AssetDesc 12 VARCHAR 50 True True True False %s 3.0 US, CA, UK
Location 12 VARCHAR 50 True True True False %s 3.0 US, CA, UK
PONumber 12 VARCHAR 30 True True True False %s 3.0 US, CA, UK
SerialNumber 12 VARCHAR 30 True True True False %s 3.0 US, CA, UK
WarrantyExpDate 91 DATE 10 True True True False CCCC-MM-DD 3.0 US, CA, UK
Notes 12 VARCHAR 4095 True True True False %s 3.0 US, CA, UK
AssetNumber 12 VARCHAR 10 True True True False %s 3.0 US, CA, UK
CostBasis 2 NUMERIC 15 True True True False %10.2f 3.0 US, CA, UK
YearEndAccumulatedDepreciation 2 NUMERIC 15 True True True False %10.2f 3.0 US, CA, UK
YearEndBookValue 2 NUMERIC 15 True True True False %10.2f 3.0 US, CA, UK
DiscountRate 2 NUMERIC 15 True True True True %10.5f 1.0 US, CA, UK
DiscountRatePercent 2 NUMERIC 18 True True True True %10.5f 1.0 US, CA, UK
AccountRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
AccountRef_FullName 12 VARCHAR 159 True True True False %s fullname 1.0 US, CA, UK
DepositToAccountRef_ListID 12 VARCHAR 36 True True True False %s 1.0 US, CA, UK ListID
DepositToAccountRef_FullName 12 VARCHAR 159 True True True False %s 1.0 US, CA, UK FullName
PaymentMethodRef_ListID 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK ListID
PaymentMethodRef_FullName 12 VARCHAR 31 True True True False %s 1.0 US, CA, UK Name
TaxVendorRef_ListID 12 VARCHAR 36 True True True False %s ListID 1.0 US, CA, UK
TaxVendorRef_FullName 12 VARCHAR 41 True True True False %s Name 1.0 US, CA, UK
IsPrintItemsInGroup -7 BIT 1 True True True False
1
0
true
false
 1.0 US, CA, UK
SpecialItemType 12 VARCHAR 24 True False False False
FinanceCharge
ReimbursableExpenseGroup
ReimbursableExpenseSubtotal
 SpecialItemType 6.0 US, CA, UK

Back to list of tables.