TABLE DETAIL REFERENCE: ItemNonInventory
(USA 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 31TrueTrueTrueTrue%s
FullName12 VARCHAR 159TrueFalseFalseFalse%s
BarCodeValue12 VARCHAR 50TrueTrueTrueFalse%s
BarCodeAssignEvenIfUsed-7 BIT 1FalseTrueTrueFalse
1
0
true
false
BarCodeAllowOverride-7 BIT 1FalseTrueTrueFalse
1
0
true
false
IsActive-7 BIT 1TrueTrueTrueFalse
1
0
true
false
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ClassRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
ParentRefListID12 VARCHAR 36TrueTrueTrueFalse%s
ParentRefFullName12 VARCHAR 159TrueTrueTrueFalse%s
Sublevel4 INTEGER 4TrueFalseFalseFalse%11.0f
ManufacturerPartNumber12 VARCHAR 31TrueTrueTrueFalse%s
UnitOfMeasureSetRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
UnitOfMeasureSetRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
ForceUOMChange-7 BIT 1TrueTrueFalseFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 3TrueTrueTrueFalse%s Yes
SalesOrPurchaseDesc12 VARCHAR 4095TrueTrueTrueFalse%s
SalesOrPurchasePrice3 DECIMAL 18TrueTrueTrueTrue%10.5f
SalesOrPurchasePricePercent3 DECIMAL 18TrueTrueTrueTrue%10.5f
SalesOrPurchaseAccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
SalesOrPurchaseAccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
SalesOrPurchaseApplyAccountRefToExistingTxns-7 BIT 1TrueTrueFalseFalse
1
0
true
false
SalesAndPurchaseSalesDesc12 VARCHAR 4095TrueTrueTrueFalse%s
SalesAndPurchaseSalesPrice3 DECIMAL 18TrueTrueTrueFalse%10.5f
SalesAndPurchaseIncomeAccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
SalesAndPurchaseIncomeAccountRefFullName12 VARCHAR 159TrueTrueTrueFalse%s Yes
SalesAndPurchaseApplyIncomeAccountRefToExistingTxns-7 BIT 1TrueTrueFalseFalse
1
0
true
false
SalesAndPurchasePurchaseDesc12 VARCHAR 4095TrueTrueTrueFalse%s
SalesAndPurchasePurchaseCost3 DECIMAL 18TrueTrueTrueFalse%10.5f
SalesAndPurchaseExpenseAccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
SalesAndPurchaseExpenseAccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
SalesAndPurchaseApplyExpenseAccountRefToExistingTxns-7 BIT 1TrueTrueFalseFalse
1
0
true
false
SalesAndPurchasePrefVendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesAndPurchasePrefVendorRefFullName12 VARCHAR 41TrueTrueTrueFalse%s Yes
ExternalGUID12 VARCHAR 40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}
CustomFieldALU12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldALU212 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldApproved12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldColor12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCompletedby12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldCustomer12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldInspectedBy12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldOrdered12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldPulled12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldPulledby12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldQtyPriceBreak12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldRequiredDate12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldStartDate12 VARCHAR 30TrueTrueTrueFalse%s
CustomFieldStyle12 VARCHAR 30TrueTrueTrueFalse%s