ItemInventoryAssembly Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ListID12VARCHAR36TrueFalseFalseFalse%s2.0US, CA, UK
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ2.0US, CA, UK
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ2.0US, CA, UK
EditSequence12VARCHAR16TrueFalseFalseFalse%s2.0US, CA, UK
Name12VARCHAR31TrueTrueTrueTrue%s2.0US, CA, UK
FullName12VARCHAR159TrueFalseFalseFalse%s2.0US, CA, UK
BarCode_Value12VARCHAR50TrueTrueTrueFalse%s12.0US, CA, UK
BarCode_AssignEvenIfUsed-7BIT2FalseTrueTrueFalse
1
0
true
false
2.0US, CA, UK
BarCode_AllowOverride-7BIT2FalseTrueTrueFalse
1
0
true
false
2.0US, CA, UK
IsActive-7BIT2TrueTrueTrueFalse
1
0
true
false
2.0US, CA, UK
ClassRef_ListID12VARCHAR36TrueTrueTrueFalse%s12.0US, CA, UK
ClassRef_FullName12VARCHAR159TrueTrueTrueFalse%s12.0US, CA, UK
ParentRef_ListID12VARCHAR36TrueTrueTrueFalse%s2.0US, CA, UK
ParentRef_FullName12VARCHAR159TrueTrueTrueFalse%s2.0US, CA, UK
Sublevel4INTEGER9TrueFalseFalseFalse%12.0f2.0US, CA, UK
ManufacturerPartNumber12VARCHAR31TrueTrueTrueFalse%s12.0US, CA, UK
UnitOfMeasureSetRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID7.0US, CA, UK
UnitOfMeasureSetRef_FullName12VARCHAR31TrueTrueTrueFalse%sName7.0US, CA, UK
ForceUOMChange-7BIT1TrueTrueFalseFalse
1
0
true
false
7.0US, CA, UK
SalesTaxCodeRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID2.0US, CA, UK
SalesTaxCodeRef_FullName12VARCHAR3TrueTrueTrueFalse%sName2.0US, CA, UK
SalesDesc12VARCHAR4095TrueTrueTrueFalse%s2.0US, CA, UK
SalesPrice2NUMERIC18TrueTrueTrueFalse%10.5f2.0US, CA, UK
IncomeAccountRef_ListID12VARCHAR36TrueTrueTrueTrue%sListID2.0US, CA, UK
IncomeAccountRef_FullName12VARCHAR159TrueTrueTrueTrue%sFullName2.0US, CA, UK
ApplyIncomeAccountRefToExistingTxns-7BIT2TrueTrueFalseFalse
1
0
true
false
2.0US, CA, UK
PurchaseDesc12VARCHAR4095TrueTrueTrueFalse%s2.0US, CA, UK
PurchaseCost2NUMERIC15TrueTrueTrueFalse%10.5f2.0US, CA, UK
COGSAccountRef_ListID12VARCHAR36TrueTrueTrueTrue%sListID2.0US, CA, UK
COGSAccountRef_FullName12VARCHAR159TrueTrueTrueTrue%sFullName2.0US, CA, UK
PrefVendorRef_ListID12VARCHAR36TrueTrueTrueFalse%sListID2.0US, CA, UK
PrefVendorRef_FullName12VARCHAR41TrueTrueTrueFalse%sFullName2.0US, CA, UK
AssetAccountRef_ListID12VARCHAR36TrueTrueTrueTrue%sListID2.0US, CA, UK
AssetAccountRef_FullName12VARCHAR159TrueTrueTrueTrue%sFullName2.0US, CA, UK
BuildPoint4INTEGER92.0US, CA, UK
QuantityOnHand4INTEGER9TrueFalseTrueFalse%10.5f2.0US, CA, UK
Max4INTEGER913.0US, CA, UK
TotalValue2NUMERIC15TrueFalseTrueFalse%10.2f2.0US, CA, UK
InventoryDate91DATE10TrueFalseTrueFalseCCCC-MM-DD2.0US, CA, UK
QuantityOnOrder3DECIMAL18TrueFalseFalseFalse%10.5f2.0US, CA, UK
QuantityOnSalesOrder3DECIMAL18TrueFalseFalseFalse%10.5f2.0US, CA, UK
ExternalGUID12VARCHAR40TrueFalseTrueFalse{XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX}8.0US, CA, UK
ClearItemsInGroup-7BIT22.0US, CA, UK
CFColor12VARCHAR255TrueTrueTrueFalse%s2.0US, CA, UK
CFMaterial12VARCHAR255TrueTrueTrueFalse%s2.0US, CA, UK

Back to list of tables.