InventoryItem

PX.Objects.IN

View API Entity: StockItem/entity/Default/24.200.001/StockItem

142 of 142 fields

	Field Name	Type	Display Name	Foreign Key
	`InventoryCD`Default Navigation	`nvarchar(30)`	Inventory ID	-
Description:Key field. The user-friendly unique identifier of the Inventory Item. The structure of the identifier is determined by the INVENTORY Segmented Key.
	`ABCCodeID`Default Navigation	`char(1)`	ABC Code	INABCCode
Description:The ABC code, to which the item is assigned for the purpose of physical inventories. The field is relevant only for Stock Items (see StkItem). Corresponds to the INABCCode.ABCCodeID field.
	`ABCCodeIsFixed`	`bit`	Fixed ABC Code	-
Description:When set to "true", indicates that the system must not change the ABC Code assigned to the item when ABC code assignments are updated. The field is relevant only for Stock Items (see StkItem). Defaults to "false".
	`AttributeDescriptionGroupID`	`int`		-
Description:References to parent Group INAttributeDescriptionGroup.GroupID
	`Attributes` API Nonexistent in DB	`unspecified`		-
Description:Reserved for internal use. Provides the values of attributes associated with the item. For more information see the CSAnswers class.
	`Availability` API	`char(1)`	Availability	-
Description:No description available
	`AvailabilityAdjustment`	`decimal(19, 6)`	Availability Adjustment	-
Description:Value to adjust availability when exporting availability to external eStores.
	`BaseItemVolume`	`decimal(19, 6)`	Volume	-
Description:The volume of the Base Unit of the item. Given in the Volume Unit of this item.
	`BaseItemWeight`	`decimal(19, 6)`	Weight	-
Description:The weight of the Base Unit of the item. Given in the Weight Unit of this item.
	`BasePrice`Obsolete	`decimal(19, 6)`	Default Price	-
Description:The price used as the default price, if there are no other prices defined for this item in any price list in the Accounts Receivable module.
	`BaseUnit`Default Navigation	`nvarchar(6)`	Base Unit	INUnit
Description:The Unit of Measure used as the base unit for the Inventory Item. Defaults to the Base Unit associated with the Item Class. Corresponds to the INUnit.FromUnit field.
	`BaseVolume`	`decimal(19, 6)`	Volume	-
Description:The volume of the item. Given in the default Volume Unit of the Inventory module.
	`BaseWeight`	`decimal(19, 6)`		-
Description:The weight of the Base Unit of the item. Given in the default Weight Unit of the Inventory module.
	`Body`	`nvarchar(MAX)`	Content	-
Description:Rich text description of the item.
	`COGSAcctID`Default Navigation	`int`	COGS Account	Account
Description:The expense Account used to record the cost of goods sold for this item when a sales order for it is released. Applicable only for Stock Items (see StkItem). Defaults to the COGS Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`COGSSubID`Default Navigation	`int`	COGS Sub.	Sub
Description:The Subaccount used to record the cost of goods sold for this item when a sales order for it is released. Applicable only for Stock Items (see StkItem). Defaults to the COGS Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`ColumnAttributeValue`	`nvarchar(255)`		-
Description:Value of column matrix attribute of template item.
	`Commisionable`	`bit`	Subject to Commission	-
Description:When set to "true", indicates that the system must calculate commission on the sale of this item. Defaults to "false".
	`CommodityCodeType`	`nvarchar(30)`	Commodity Code Type	-
Description:No description available
	`CompletePOLine`	`char(1)`	Close PO Line	-
Description:No description available
	`CostBasis`	`char(1)`	Cost Based On	-
Description:No description available
	`CountryOfOrigin` API Default Navigation	`nvarchar(2)`	Country Of Origin	Country
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CycleID`Default Navigation	`nvarchar(10)`	PI Cycle	INPICycle
Description:The Physical Inventory Cycle assigned to the item. The cycle defines how often the physical inventory counts will be performed for the item. The field is relevant only for Stock Items (see StkItem). Corresponds to the INPICycle.CycleID field.
	`DecimalBaseUnit`	`bit`	Divisible Unit	-
Description:When set to "false", indicates that the system will prevent enter of non-integer values into the quantity field for choosed Base Unit value. Defaults to "true" Defaults to "true"
	`DecimalPurchaseUnit`	`bit`	Divisible Unit	-
Description:When set to "false", indicates that the system will prevent enter of non-integer values into the quantity field for choosed Purchase Unit value. Defaults to "true" Defaults to "true"
	`DecimalSalesUnit`	`bit`	Divisible Unit	-
Description:When set to "false", indicates that the system will prevent enter of non-integer values into the quantity field for choosed Sales Unit value. Defaults to "true" Defaults to "true"
	`DefaultColumnMatrixAttributeID`Default Navigation	`nvarchar(10)`	Default Column Attribute ID	CSAnswers
Description:No description available
	`DefaultCostCodeID`Default Navigation	`int`	Default Cost Code	PMCostCode
Description:No description available
	`DefaultInventorySourceForProjects`	`char(1)`	Default Inventory Source for Projects	-
Description:The default inventory source for projects.
	`DefaultRowMatrixAttributeID`Default Navigation	`nvarchar(10)`	Default Row Attribute ID	CSAnswers
Description:No description available
	`DefaultSubItemID`Default Navigation	`int`	Default Subitem	INSubItem
Description:The default Subitem for this item, which is used when there are no subitems or when specifying subitems is not important. This field is relevant only if the Inventory Subitems feature is enabled. Corresponds to the INSubItem.SubItemID field.
	`DefaultSubItemOnEntry`	`bit`	Use On Entry	-
Description:When set to "true", indicates that the system must set the Default Subitem for the lines involving this item by default on data entry forms. This field is relevant only if the Inventory Subitems feature is enabled. Defaults to "false".
	`DefaultTerm`	`decimal(9, 4)`	Default Term	-
Description:No description available
	`DefaultTermUOM`	`char(1)`	Default Term UOM	-
Description:No description available
	`DeferralAcctID`Default Navigation	`int`	Deferral Account	Account
Description:No description available
	`DeferralSubID`Default Navigation	`int`	Deferral Sub.	Sub
Description:No description available
	`DeferredCode`Default Navigation	`nvarchar(10)`	Deferral Code	DRDeferredCode
Description:The deferral code used to perform deferrals on sale of the item. Defaults to the Deferral Code selected for the Item Class. Corresponds to the DRDeferredCode.DeferredCodeID field.
	`Descr`	`nvarchar(256)`	Description	-
Description:The description of the Inventory Item.
	`DfltReceiptLocationID`Default NavigationObsolete	`int`	Default Receipt To	INLocation
Description:The Location of warehouse used by default to receive items of this kind. Applicable only for Stock Items (see StkItem) when the Warehouse Locations feature is enabled. Corresponds to the INLocation.LocationID field.
	`DfltShipLocationID`Default NavigationObsolete	`int`	Default Issue From	INLocation
Description:The Location of warehouse used by default to issue items of this kind. Applicable only for Stock Items (see StkItem) when the Warehouse Locations feature is enabled. Corresponds to the INLocation.LocationID field.
	`DfltSiteID`Default NavigationObsolete	`int`	Default Warehouse	INSite
Description:The default Warehouse used to store the items of this kind. Applicable only for Stock Items (see StkItem) and when the Warehouses feature is enabled. Corresponds to the INSite.SiteID field. Defaults to the Default Warehouse specified for the Class of the item.
	`DiscAcctID`Nonexistent in DBObsolete	`int`		-
Description:No description available
	`DiscSubID`Nonexistent in DBObsolete	`int`		-
Description:No description available
	`ExpenseAccrualAcctID`Nonexistent in DB	`int`		-
Description:The asset Account used to keep the Expense Accrual Account, resulting from the transactions with this item. Applicable only for Non-Stock Items (see StkItem). Defaults to the Inventory Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`ExpenseAccrualSubID`Nonexistent in DB	`int`		-
Description:The Subaccount used to keep the Expense Accrual Account, resulting from the transactions with this item. Applicable only for Non-Stock Items (see StkItem). Defaults to the Inventory Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`ExpenseAcctID`Nonexistent in DB	`int`		-
Description:The expense Account used to record the cost of goods sold for this item when a sales order for it is released. Applicable only for Non-Stock Items (see StkItem). Defaults to the COGS Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`ExpenseSubID`Nonexistent in DB	`int`		-
Description:The Subaccount used to record the cost of goods sold for this item when a sales order for it is released. Applicable only for Non-Stock Items (see StkItem). Defaults to the COGS Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`ExportToExternal` API	`bit`	Export to External System	-
Description:No description available
	`GenerationRuleCntr`	`int`		-
Description:No description available
	`GroupMask`	`varbinary(32)`		-
Description:The group mask showing which restriction groups the item belongs to.
	`HasChild`Nonexistent in DB	`bit`		-
Description:The flag is true if there is Inventory Item which has TemplateItemId equals current InventoryID value.
	`HSTariffCode`	`nvarchar(30)`	Commodity Code	-
Description:No description available
	`ImageUrl` API	`nvarchar(255)`	Image	-
Description:The URL of the image associated with the item.
	`Included`Nonexistent in DB	`bit`	Included	-
Description:An unbound field used in the User Interface to include the item into a restriction group.
	`InventoryID` API	`int`	Inventory ID	-
Description:Database identity. The unique identifier of the Inventory Item.
	`InvtAcctID`Default Navigation	`int`	Inventory Account	Account
Description:The asset Account used to keep the inventory balance, resulting from the transactions with this item. Applicable only for Stock Items (see StkItem). Defaults to the Inventory Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`InvtSubID`Default Navigation	`int`	Inventory Sub.	Sub
Description:The Subaccount used to keep the inventory balance, resulting from the transactions with this item. Applicable only for Stock Items (see StkItem). Defaults to the Inventory Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`IsConversionMode`Nonexistent in DB	`bit`		-
Description:No description available
	`IsConverted`	`bit`	Is Converted	-
Description:No description available
	`IsSpecialOrderItem`	`bit`	Special-Order Item	-
Description:No description available
	`IsSplitted`	`bit`	Split into Components	-
Description:When set to "true", indicates that the system should split the revenue from sale of the item among its components. Defaults to "false".
	`IsTemplate`	`bit`		-
Description:When set to "true", indicates that the item is a template for other matrix items. Defaults to "false".
	`ItemClassID`Default Navigation	`int`	Item Class	INItemClass
Description:No description available
	`ItemStatus` API	`char(2)`	Item Status	-
Description:The status of the Inventory Item. Possible values are: ""AC"" - Active (can be used in inventory operations, such as issues and receipts), ""NS"" - No Sales (cannot be sold), ""NP"" - No Purchases (cannot be purchased), ""NR"" - No Request (cannot be used on requisition requests), ""IN"" - Inactive, ""DE"" - Marked for Deletion. Defaults to Active (""AC"").
	`ItemType` API	`char(1)`	Type	-
Description:The type of the Inventory Item. Possible values are: ""F"" - Finished Good (Stock Items only), ""M"" - Component Part (Stock Items only), ""A"" - Subassembly (Stock Items only), ""N"" - Non-Stock Item (a general type of Non-Stock Item), ""L"" - Labor (Non-Stock Items only), ""S"" - Service (Non-Stock Items only), ""C"" - Charge (Non-Stock Items only), ""E"" - Expense (Non-Stock Items only). Defaults to the Type associated with the Item Class of the item if it's specified, or to Finished Good (""F"") otherwise.
	`KitItem`	`bit`	Is a Kit	-
Description:When set to "true", indicates that the item is a kit. Kits are stock or non-stock items that consist of other items and are sold as a whole. Defaults to "false".
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime` API	`datetime`	Last Modified On	-
Description:No description available
	`LastSiteID`	`int`		INSite
Description:Reserved for internal use.
	`LastStdCost` API Obsolete	`decimal(19, 6)`	Last Cost	-
Description:The standard cost assigned to the item before the current standard cost was set.
	`LCVarianceAcctID`Default Navigation	`int`	Landed Cost Variance Account	Account
Description:The expense Account used to record differences between the landed cost amounts specified on purchase receipts and the amounts on inventory receipts. Applicable only for Stock Items (see StkItem). Defaults to the Landed Cost Variance Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`LCVarianceSubID`Default Navigation	`int`	Landed Cost Variance Sub.	Sub
Description:The Subaccount used to record differences between the landed cost amounts specified on purchase receipts and the amounts on inventory receipts. Applicable only for Stock Items (see StkItem). Defaults to the Landed Cost Variance Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`LotSerClassID`Default Navigation	`nvarchar(10)`	Lot/Serial Class	INLotSerClass
Description:The lot/serial class, to which the item is assigned. This field is relevant only if the Lot/Serial Tracking feature is enabled. Corresponds to the INLotSerClass.LotSerClassID field.
	`MarkupPct`	`decimal(19, 6)`	Markup %	-
Description:The percentage that is added to the item cost to get the selling price for it. Defaults to the Markup % specified for the Item Class.
	`MinGrossProfitPct`	`decimal(19, 6)`	Min. Markup %	-
Description:The minimum markup percentage for the item. See the MarkupPct field. Defaults to the Min. Margup % defined for the Item Class.
	`MovementClassID`Default Navigation	`char(1)`	Movement Class	INMovementClass
Description:The Movement Class, to which the item is assigned for the purpose of physical inventories. The field is relevant only for Stock Items (see StkItem). Corresponds to the INMovementClass.MovementClassID field.
	`MovementClassIsFixed`	`bit`	Fixed Movement Class	-
Description:When set to "true", indicates that the system must not change the Movement Class assigned to the item when movement class assignments are updated. The field is relevant only for Stock Items (see StkItem). Defaults to "false".
	`NegQty`Nonexistent in DB	`bit`		-
Description:An unbound field that, when equal to "true", indicates that negative quantities are allowed for this item. The value of this field is taken from the INItemClass.NegQty field of the Class, to which the item belongs.
	`NonStockReceipt`	`bit`	Require Receipt	-
Description:Reserved for internal use. Indicates whether the item (assumed Non-Stock) requires receipt.
	`NonStockReceiptAsService`	`bit`	Process Item via Receipt	-
Description:Indicates whether the item (assumed Non-Stock) should be receipted as service.
	`NonStockShip`	`bit`	Require Shipment	-
Description:Reserved for internal use. Indicates whether the item (assumed Non-Stock) requires shipment.
	`NotAvailMode`	`char(1)`	When Qty Unavailable	-
Description:No description available
	`NoteID` API	`uniqueidentifier`		-
Description:No description available
	`OrigLotSerClassID`	`nvarchar(MAX)`		-
Description:No description available
	`OvershipThreshold`	`decimal(9, 6)`	Overship Threshold (%)	-
Description:No description available
	`PackageOption`	`char(1)`	Packaging Option	-
Description:The option that governs the system in the process of determining the optimal set of boxes for the item on each sales order. Applicable only for Stock Items (see StkItem). Allowed values are: ""N"" - Manual, ""W"" - By Weight (the system will take into account the Max. Weight allowed for each box specififed for the item), ""Q"" - By Quantity (the system will take into account the Max. Quantity allowed for each box specififed for the item. With this option items of this kind are always packages separately from other items), ""V"" - By Weight and Volume (the system will take into account the Max. Weight and Max. Volume allowed for each box specififed for the item). Defaults to Manual (""M"").
	`PackSeparately` API	`bit`	Pack Separately	-
Description:When set to "true", indicates that the item must be packaged separately from other items. This field is automatically set to "true" if By Quantity is selected as the PackageOption. Applicable only for Stock Items (see StkItem). Defaults to "false".
	`ParentItemClassID`	`int`		-
Description:No description available
	`PendingStdCost` API Obsolete	`decimal(19, 6)`	Pending Cost	-
Description:The standard cost to be assigned to the item when the costs are updated.
	`PendingStdCostDate`Obsolete	`datetime2`	Pending Cost Date	-
Description:The date when the Pending Cost becomes effective.
	`PercentOfSalesPrice`	`decimal(19, 6)`	Percent of Sales Price	-
Description:No description available
	`PlanningMethod`	`char(1)`	Planning Method	-
Description:Planning method - Decide which planning method applicable for the stock item.
	`POAccrualAcctID`Default Navigation	`int`	PO Accrual Account	Account
Description:The liability Account used to accrue amounts on purchase orders related to this item. Applicable for all Stock Items (see StkItem) and for Non-Stock Items, for which a receipt is required. Defaults to the PO Accrual Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`POAccrualSubID`Default Navigation	`int`	PO Accrual Sub.	Sub
Description:The Subaccount used to accrue amounts on purchase orders related to this item. Applicable for all Stock Items (see StkItem) and for Non-Stock Items, for which a receipt is required. Defaults to the PO Accrual Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`PostClassID`	`nvarchar(10)`	Posting Class	INPostClass
Description:Identifier of the Posting Class associated with the item. Defaults to the Posting Class selected for the item class. Corresponds to the INPostClass.PostClassID field.
	`PostToExpenseAccount`	`char(1)`	Post Cost to Expenses On	-
Description:When set to Sales, indicates that cost will be processed using expense accrual account.
	`PPVAcctID`Default Navigation	`int`	Purchase Price Variance Account	Account
Description:The expense Account used to record the differences between the extended price on the purchase receipt and the extended price on the Accounts Payable bill for this item. Applicable only for Stock Items (see StkItem) under any Valuation Method except Standard. Defaults to the Purchase Price Variance Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`PPVSubID`Default Navigation	`int`	Purchase Price Variance Sub.	Sub
Description:The Subaccount used to record the differences between the extended price on the purchase receipt and the extended price on the Accounts Payable bill for this item. Applicable only for Stock Items (see StkItem) under any Valuation Method except Standard. Defaults to the Purchase Price Variance Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`PreferredItemClasses`	`char(1)`	Preferred Item Classes	-
Description:No description available
	`PreferredVendorID`Default NavigationObsolete	`int`	Preferred Vendor	BAccount
Description:Preferred (default) Vendor for purchases of this item. Corresponds to the BAccount.BAccountID field.
	`PreferredVendorLocationID`Default NavigationObsolete	`int`	Preferred Location	Location
Description:The Location of the Preferred (default) Vendor. Corresponds to the Location.LocationID field.
	`PriceClassID`Default Navigation	`nvarchar(10)`	Price Class	INPriceClass
Description:The Item Price Class associated with the item. Defaults to the Price Class selected for the Item Class. Corresponds to the INPriceClass.PriceClassID field.
	`PriceManagerID`Default Navigation	`int`	Price Manager	Contact
Description:The manager responsible for the pricing of this item. Corresponds to the Contact.ContactID field.
	`PriceOfSuggestedItems`	`char(1)`	Price Of Suggested Items	-
Description:No description available
	`PriceWorkgroupID`Default Navigation	`int`	Price Workgroup	EPCompanyTree
Description:The workgroup that is responsible for the pricing of this item. Corresponds to the EPCompanyTree.WorkGroupID field.
	`ProductManagerID`Default Navigation	`int`	Product Manager	Contact
Description:The product manager responsible for this item. Corresponds to the Contact.ContactID field.
	`ProductWorkgroupID`Default Navigation	`int`	Product Workgroup	EPCompanyTree
Description:The workgroup that is responsible for the item. Corresponds to the EPCompanyTree.WorkGroupID field.
	`PurchaseUnit`Default Navigation	`nvarchar(6)`	Purchase Unit	INUnit
Description:The Unit of Measure used as the purchase unit for the Inventory Item. This field can be changed only if the Multiple Units of Measure feature is enabled. Otherwise, the purchase unit is assumed to be the same as the Base Unit. Defaults to the Purchase Unit associated with the Item Class. Corresponds to the INUnit.FromUnit field.
	`ReasonCodeSubID`Default Navigation	`int`	Reason Code Sub.	Sub
Description:The identifier of the Suabaccount defined by the Reason Code, associated with this item. Defaults to the Reason Code Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`RecPrice`Obsolete	`decimal(19, 6)`	MSRP	-
Description:The manufacturer's suggested retail price of the item.
	`ReplenishmentSource`	`char(1)`	Source	-
Description:Replenishment source
	`RowAttributeValue`	`nvarchar(255)`		-
Description:Value of row matrix attribute of template item.
	`SalesAcctID`Default Navigation	`int`	Sales Account	Account
Description:The income Account used to record sales of the item. Defaults to the Sales Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`SalesSubID`Default Navigation	`int`	Sales Sub.	Sub
Description:The Subaccount used to record sales of the item. Defaults to the Sales Account set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`SalesUnit`Default Navigation	`nvarchar(6)`	Sales Unit	INUnit
Description:The Unit of Measure used as the sales unit for the Inventory Item. This field can be changed only if the Multiple Units of Measure feature is enabled. Otherwise, the sales unit is assumed to be the same as the Base Unit. Defaults to the Sales Unit associated with the Item Class. Corresponds to the INUnit.FromUnit field.
	`SampleDescription`Nonexistent in DB	`nvarchar(MAX)`		-
Description:Contains Inventory Description Example Projections.DescriptionGenerationRule
	`SampleID`Nonexistent in DB	`nvarchar(MAX)`		-
Description:Contains Inventory ID Example Projections.IDGenerationRule
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:Indicates whether the record is selected for mass processing.
	`StdCost`Obsolete	`decimal(19, 6)`	Current Cost	-
Description:The current standard cost of the item.
	`StdCostDate`Obsolete	`datetime2`	Effective Date	-
Description:The date when the Current Cost became effective.
	`StdCstRevAcctID`Default Navigation	`int`	Standard Cost Revaluation Account	Account
Description:The expense Account used to record the differences in inventory value of this item estimated by using the pending standard cost and the currently effective standard cost for the quantities on hand. Applicable only for Stock Items (see StkItem) under Standard Valuation Method. Defaults to the Standard Cost Revaluation Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`StdCstRevSubID`Default Navigation	`int`	Standard Cost Revaluation Sub.	Sub
Description:The Subaccount used to record the differences in inventory value of this item estimated by using the pending standard cost and the currently effective standard cost for the quantities on hand. Applicable only for Stock Items (see StkItem) under Standard Valuation Method. Defaults to the Standard Cost Revaluation Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`StdCstVarAcctID`Default Navigation	`int`	Standard Cost Variance Account	Account
Description:The expense Account used to record the differences between the currently effective standard cost and the cost on the inventory receipt of the item. Applicable only for Stock Items (see StkItem) under Standard Valuation Method. Defaults to the Standard Cost Variance Account set on the Posting Class of the item. Corresponds to the Account.AccountID field.
	`StdCstVarSubID`Default Navigation	`int`	Standard Cost Variance Sub.	Sub
Description:The Subaccount used to record the differences between the currently effective standard cost and the cost on the inventory receipt of the item. Applicable only for Stock Items (see StkItem) under Standard Valuation Method. Defaults to the Standard Cost Variance Sub. set on the Posting Class of the item. Corresponds to the Sub.SubID field.
	`StkItem`	`bit`	Stock Item	-
Description:When set to "true", indicates that this item is a Stock Item.
	`TaxCalcMode`	`char(1)`	Tax Calculation Mode	-
Description:No description available
	`TaxCategoryID`Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:Identifier of the TaxCategory associated with the item. Defaults to the Tax Category associated with the Item Class. Corresponds to the TaxCategory.TaxCategoryID field.
	`TemplateItemID` API Default Navigation	`int`	Template ID	InventoryItem
Description:References to parent Inventory Item, its database identifier, if this item was created from template.
	`TotalPercentage`Nonexistent in DB	`decimal`	Total Percentage	-
Description:The total percentage of the item price as split among components. The value is calculated automatically from the percentages of the components associated with the item. Set to "100" if the item is not a package.
	`tstamp`	`timestamp`		-
Description:No description available
	`UndershipThreshold`	`decimal(9, 6)`	Undership Threshold (%)	-
Description:No description available
	`UpdateOnlySelected`Nonexistent in DB	`bit`	Update Only Selected Items with Template Changes	-
Description:If true, only items selected in the Matrix Items list will be updated with the template changes on Update Matrix Items action.
	`UseParentSubID`	`bit`	Use Component Subaccounts	-
Description:When set to "true", indicates that the system should use the component subaccounts in the component-associated deferrals. Defaults to "false".
	`ValMethod`	`char(1)`	Valuation Method	-
Description:The method used for inventory valuation of the item (Stock Items only). Allowed values are: ""T"" - Standard, ""A"" - Average, ""F"" - FIFO, ""S"" - Specific. Defaults to the Valuation Method associated with the Item Class of the item if it's specified, or to Standard (""T"") otherwise.
	`Visibility` API	`char(1)`	Visibility	-
Description:No description available
	`VolumeUOM` API Default Navigation	`nvarchar(6)`	Volume UOM	INUnit
Description:The Unit of Measure used for the Volume of the item. Corresponds to the INUnit.FromUnit field.
	`WeightItem`	`bit`	Weight Item	-
Description:When set to "true", indicates that this item is a Weight Item.
	`WeightUOM` API Default Navigation	`nvarchar(6)`	Weight UOM	INUnit
Description:The Unit of Measure used for the Weight of the item. Corresponds to the INUnit.FromUnit field.