TABLE DETAIL REFERENCE: ItemInventoryAssembly
(Australia ,New Zealand,Singapore Southeast Asia 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
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
IsTaxIncluded-7 BIT 1TrueTrueTrueFalse
1
0
true
false
SalesTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
SalesTaxCodeRefFullName12 VARCHAR 6TrueTrueTrueFalse%s Yes
SalesDesc12 VARCHAR 4095TrueTrueTrueFalse%s
SalesPrice3 DECIMAL 16TrueTrueTrueFalse%8.5f
IncomeAccountRefListID12 VARCHAR 36TrueFalseTrueTrue%s Yes
IncomeAccountRefFullName12 VARCHAR 159TrueFalseTrueTrue%s Yes
PurchaseDesc12 VARCHAR 4095TrueTrueTrueFalse%s
PurchaseCost3 DECIMAL 16TrueTrueTrueFalse%8.5f
PurchaseTaxCodeRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PurchaseTaxCodeRefFullName12 VARCHAR 31TrueTrueTrueFalse%s Yes
COGSAccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
COGSAccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
PrefVendorRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PrefVendorRefFullName12 VARCHAR 41TrueTrueTrueFalse%s Yes
AssetAccountRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
AssetAccountRefFullName12 VARCHAR 159TrueTrueTrueTrue%s Yes
BuildPoint3 DECIMAL 16TrueTrueTrueFalse%8.5f
Maximum3 DECIMAL 16TrueTrueTrueFalse%8.5f
QuantityOnHand3 DECIMAL 16TrueFalseTrueFalse%8.5f
TotalValue3 DECIMAL 13TrueFalseTrueFalse%8.2f
InventoryDate9 DATE 6TrueFalseTrueFalseCCCC-MM-DD
AverageCost3 DECIMAL 16TrueFalseFalseFalse%8.5f
QuantityOnOrder3 DECIMAL 16TrueFalseFalseFalse%8.5f
QuantityOnSalesOrder3 DECIMAL 16TrueFalseFalseFalse%8.5f