TABLE DETAIL REFERENCE: Item
(Canada VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueFalseFalseFalse%s
FullName12 VARCHAR 209TrueFalseFalseFalse%s
BarCodeValue12 VARCHAR 50TrueFalseFalseFalse%s
Description12 VARCHAR 4095TrueFalseFalseFalse%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
AcquiredAs12 VARCHAR 3TrueFalseFalseTrue
New
Old
ParentRefListID12 VARCHAR 36TrueFalseFalseFalse%s
ParentRefFullName12 VARCHAR 209TrueFalseFalseFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
ManufacturerPartNumber12 VARCHAR 31TrueFalseFalseFalse%s
UnitOfMeasureSetRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
UnitOfMeasureSetRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
IsPrintItemsInGroup-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Type12 VARCHAR 25TrueFalseFalseFalse%s
SalesTaxCodeRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueFalseFalseFalse%s Yes
SalesOrPurchaseDesc12 VARCHAR 4095TrueFalseFalseFalse%s
SalesOrPurchasePrice3 DECIMAL 18TrueFalseFalseTrue%10.5f
SalesOrPurchasePricePercent3 DECIMAL 18TrueFalseFalseTrue%10.5f
SalesOrPurchaseAccountRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
SalesOrPurchaseAccountRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
SalesAndPurchaseSalesDesc12 VARCHAR 4095TrueFalseFalseFalse%s
SalesAndPurchaseSalesPrice3 DECIMAL 18TrueFalseFalseFalse%10.5f
SalesAndPurchaseIncomeAccountRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
SalesAndPurchaseIncomeAccountRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
SalesAndPurchasePurchaseDesc12 VARCHAR 4095TrueFalseFalseFalse%s
SalesAndPurchasePurchaseCost3 DECIMAL 18TrueFalseFalseFalse%10.5f
SalesAndPurchaseExpenseAccountRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
SalesAndPurchaseExpenseAccountRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
SalesAndPurchasePrefVendorRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
SalesAndPurchasePrefVendorRefFullName12 VARCHAR 41TrueFalseFalseFalse%s Yes
ItemDesc12 VARCHAR 4095TrueFalseFalseFalse%s
SpecialItemType12 VARCHAR 24TrueFalseFalseFalse
FinanceCharge
ReimbursableExpenseGroup
ReimbursableExpenseSubtotal
Yes
SalesDesc12 VARCHAR 4095TrueFalseFalseFalse%s
SalesPrice3 DECIMAL 18TrueFalseFalseFalse%10.5f
IncomeAccountRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
IncomeAccountRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
PurchaseDesc12 VARCHAR 4095TrueFalseFalseFalse%s
PurchaseCost3 DECIMAL 18TrueFalseFalseFalse%10.5f
COGSAccountRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
COGSAccountRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
PrefVendorRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PrefVendorRefFullName12 VARCHAR 41TrueFalseFalseFalse%s Yes
AssetAccountRefListID12 VARCHAR 36TrueFalseFalseTrue%s Yes
AssetAccountRefFullName12 VARCHAR 159TrueFalseFalseTrue%s Yes
ReorderPoint3 DECIMAL 18TrueFalseFalseFalse%10.5f
BuildPoint3 DECIMAL 18TrueFalseFalseFalse%10.5f
QuantityOnHand3 DECIMAL 18TrueFalseFalseFalse%10.5f
AverageCost3 DECIMAL 18TrueFalseFalseFalse%10.5f
QuantityOnOrder3 DECIMAL 18TrueFalseFalseFalse%10.5f
QuantityOnSalesOrder3 DECIMAL 18TrueFalseFalseFalse%10.5f
InventoryDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
DepositToAccountRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
DepositToAccountRefFullName12 VARCHAR 159TrueFalseFalseFalse%s Yes
PaymentMethodRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
PaymentMethodRefFullName12 VARCHAR 31TrueFalseFalseFalse%s Yes
TaxRate3 DECIMAL 18TrueFalseFalseFalse%10.5f
TaxVendorRefListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TaxVendorRefFullName12 VARCHAR 41TrueFalseFalseFalse%s Yes