CN
SubcontractInventoryItem
This class is required as Acumatica use Filters with SELECTOR type across all system. We needed to override ViewName of the Data.FilterHeader to specific entity type.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ABCCodeID | 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". | ||||
AMBOMID | nvarchar(15) | Default BOM ID | AMBomItem | |
Description:Default BOM ID | ||||
AMCTPItem | bit | CTP Item | - | |
Description:Indicates item is a CTP calculated item | ||||
AMCheckSchdMatlAvailability | bit | Check for Material Availability | - | |
Description:APS Schedule option - Check for Material Availability. | ||||
AMConfigurationID | nvarchar(15) | Configuration ID | AMConfiguration | |
Description:Item configuration ID. If null, this item isn't configurable. | ||||
AMDefaultMarkFor | int | Dflt Mark For | - | |
Description:Default mark for | ||||
AMGroupWindow | int | Days of Supply | - | |
Description:Days of Supply | ||||
AMGroupWindowOverride | bit | Override | - | |
Description:Override of Days of Supply | ||||
AMLotSize | decimal | Lot Size | - | |
Description:Lot size | ||||
AMLowLevel | int | Low Level | - | |
Description:Non UI field - keeps items lowest bom level value used in calculations | ||||
AMMFGLeadTime | int | Manufacture Lead Time | - | |
Description:Manufacturing lead time | ||||
AMMakeToOrderItem | bit | Make to Order Item | - | |
Description:Make to Order Item | ||||
AMMaxOrdQty | decimal | Max Order Qty | - | |
Description:Max order qty | ||||
AMMinOrdQty | decimal | Min Order Qty | - | |
Description:Min order qty | ||||
AMMinQty | decimal | Reorder Point | - | |
Description:Min qty | ||||
AMPlanningBOMID | nvarchar(15) | Planning BOM ID | AMBomItem | |
Description:Planning BOM ID | ||||
AMQtyRoundUp | bit | Quantity Round Up | - | |
Description:Qty round up | ||||
AMSafetyStock | decimal | Safety Stock | - | |
Description:Safety stock | ||||
AMScrapLocationIDObsolete | int | Scrap Location | INLocation | |
Description:Scrap Location | ||||
AMScrapSiteIDObsolete | int | Scrap Warehouse | - | |
Description:Scrap Warehouse | ||||
AMSourceSiteIDObsolete | int | Source Warehouse | - | |
Description:Source Warehouse | ||||
AMWIPAcctID | int | Work In Process Account | Account | |
Description:Work In Process Account | ||||
AMWIPSubID | int | Work In Process Sub. | Sub | |
Description:Work In Process Sub. | ||||
AMWIPVarianceAcctID | int | WIP Variance Account | Account | |
Description:WIP Variance Account | ||||
AMWIPVarianceSubID | int | WIP Variance Sub. | Sub | |
Description:WIP Variance Sub. | ||||
ActionType | char(1) | Pickup/Delivery Action | - | |
Description:No description available | ||||
AttributeDescriptionGroupID | int | - | ||
Description:References to parent Group INAttributeDescriptionGroup.GroupID | ||||
AttributesNonexistent in DB | string | - | ||
Description:Reserved for internal use. Provides the values of attributes associated with the item. For more information see the CSAnswers class. | ||||
Availability | nvarchar(1) | Availability | - | |
Description:Indicates the availability setting for the inventory item. | ||||
AvailabilityAdjustment | decimal | Availability Adjustment | - | |
Description:Value to adjust availability when exporting availability to external eStores. | ||||
BaseItemVolume | decimal | Volume | - | |
Description:The volume of the Base Unit of the item. Given in the Volume Unit of this item. | ||||
BaseItemWeight | decimal | Weight | - | |
Description:The weight of the Base Unit of the item. Given in the Weight Unit of this item. | ||||
BasePriceObsolete | decimal | 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. | ||||
BasePriceDateNonexistent in DB | int? | Base Price Date | - | |
Description:No description available | ||||
BaseUnit | 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 | Volume | - | |
Description:The volume of the item. Given in the default Volume Unit of the Inventory module. | ||||
BaseWeight | decimal | - | ||
Description:The weight of the Base Unit of the item. Given in the default Weight Unit of the Inventory module. | ||||
BenefitExpenseAcctID | int | Benefit Expense Account | Account | |
Description:No description available | ||||
BenefitExpenseSubID | int | Benefit Expense Sub. | Sub | |
Description:No description available | ||||
BillingRule | char(4) | Billing Rule | - | |
Description:No description available | ||||
Body | nvarchar | Content | - | |
Description:Rich text description of the item. | ||||
COGSAcctID | 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 | 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 | - | ||
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 | nvarchar(100) | Country Of Origin | Country | |
Description:No description available | ||||
CpnyWarrantyType | char(1) | Company Warranty Type | - | |
Description:No description available | ||||
CpnyWarrantyValue | int | Company Warranty | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CustomURL | nvarchar(100) | Custom URL | - | |
Description:The URL to use for this inventory item. | ||||
CycleID | 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 | nvarchar(10) | Default Column Attribute ID | CSAnswers | |
Description:References to Attribute which will be put as Column Attribute in Inventory Matrix by default. | ||||
DefaultCostCodeID | int | Default Cost Code | PMCostCode | |
Description:The default cost code of the item. | ||||
DefaultInventorySourceForProjects | char(1) | Default Inventory Source for Projects | - | |
Description:The default inventory source for projects. | ||||
DefaultRowMatrixAttributeID | nvarchar(10) | Default Row Attribute ID | CSAnswers | |
Description:References to Attribute which will be put as Row Attribute in Inventory Matrix by default. | ||||
DefaultSubItemID | 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 | Default Term | - | |
Description:No description available | ||||
DefaultTermUOM | char(1) | Default Term UOM | - | |
Description:No description available | ||||
DeferralAcctID | int | Deferral Account | Account | |
Description:No description available | ||||
DeferralSubID | int | Deferral Sub. | Sub | |
Description:No description available | ||||
DeferredCode | 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. | ||||
DfltEarningType | nvarchar(15) | Earning Type | EPEarningType | |
Description:No description available | ||||
DfltReceiptLocationIDObsolete | 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. | ||||
DfltShipLocationIDObsolete | 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. | ||||
DfltSiteIDObsolete | 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. | ||||
DiscAcctIDNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
DiscSubIDNonexistent in DBObsolete | int? | - | ||
Description:No description available | ||||
EQEnabled | bit | Model Equipment | - | |
Description:No description available | ||||
EarningsAcctID | int | Earnings Account | Account | |
Description:No description available | ||||
EarningsSubID | int | Earnings Sub. | Sub | |
Description:No description available | ||||
EquipmentItemClass | char(2) | Equipment Class | - | |
Description:No description available | ||||
EquipmentTypeID | int | Equipment Type | FSEquipmentType | |
Description:No description available | ||||
EstimatedDuration | int | Estimated Duration | - | |
Description:No description available | ||||
ExpenseAccrualAcctIDNonexistent 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. | ||||
ExpenseAccrualSubIDNonexistent 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. | ||||
ExpenseAcctIDNonexistent 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. | ||||
ExpenseSubIDNonexistent 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 | bit | Export to External System | - | |
Description:No description available | ||||
GenerationRuleCntr | int | - | ||
Description:No description available | ||||
GroupMask | varbinary | - | ||
Description:The group mask showing which restriction groups the item belongs to. | ||||
HSTariffCode | nvarchar(30) | Commodity Code | - | |
Description:No description available | ||||
HasChildNonexistent in DB | bool? | - | ||
Description:The flag is true if there is Inventory Item which has TemplateItemId equals current InventoryID value. | ||||
ImageUrl | nvarchar(255) | Image | - | |
Description:The URL of the image associated with the item. | ||||
IncludedNonexistent in DB | bool? | Included | - | |
Description:An unbound field used in the User Interface to include the item into a restriction group. | ||||
InventoryCD | nvarchar | Inventory ID | InventoryItem | |
Description:Key field. The user-friendly unique identifier of the Inventory Item. The structure of the identifier is determined by the INVENTORY Segmented Key. | ||||
InventoryID | int | Inventory ID | - | |
Description:Database identity. The unique identifier of the Inventory Item. | ||||
InvtAcctID | 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 | 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. | ||||
IsConversionModeNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsConverted | bit | Is Converted | - | |
Description:No description available | ||||
IsProcessMFG | bit | Process Manufacturing | - | |
Description:Is the document linked to the Process Manufacturing feature. | ||||
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". | ||||
IsTravelItem | bit | Is a Travel Item | - | |
Description:No description available | ||||
ItemClassID | int | Item Class | INItemClass | |
Description:The identifier of the Item Class, to which the Inventory Item belongs. Item Classes provide default settings for items, which belong to them, and are used to group items. Corresponds to the INItemClass.ItemClassID field. | ||||
ItemStatus | 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 | 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". | ||||
LCVarianceAcctID | 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 | 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. | ||||
LastBasePriceNonexistent in DB | int? | Last Base Price | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LastSiteID | int | INSite | ||
Description:Reserved for internal use. | ||||
LastStdCostObsolete | decimal | Last Cost | - | |
Description:The standard cost assigned to the item before the current standard cost was set. | ||||
LotSerClassID | 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. | ||||
ManufacturerID | int | Manufacturer | FSManufacturer | |
Description:No description available | ||||
ManufacturerModelID | int | Manufacturer Model | FSManufacturerModel | |
Description:No description available | ||||
MarkupPct | decimal | 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. | ||||
Mem_ShowComponentNonexistent in DB | bool | - | ||
Description:No description available | ||||
MetaDescription | nvarchar(1024) | Meta Description | - | |
Description:The meta description for this item. | ||||
MetaKeywords | nvarchar(1024) | Meta Keywords | - | |
Description:A comma-separated list of meta keywords for this item. | ||||
MinGrossProfitPct | decimal | Min. Markup % | - | |
Description:The minimum markup percentage for the item. See the MarkupPct field. Defaults to the Min. Margup % defined for the Item Class. | ||||
ModelType | char(2) | Model Type | - | |
Description:No description available | ||||
MovementClassID | nvarchar(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". | ||||
NegQtyNonexistent in DB | bool? | - | ||
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 | nvarchar(1) | When Qty Unavailable | - | |
Description:Indicates the Not Available Setting to use when an item has no more quantity available. | ||||
NoteID | uniqueidentifier | - | ||
Description:Identifier of the Note object, associated with the item. Corresponds to the Note.NoteID field. | ||||
OrigLotSerClassIDNonexistent in DB | string | - | ||
Description:No description available | ||||
OvershipThreshold | decimal | Overship Threshold (%) | - | |
Description:No description available | ||||
POAccrualAcctID | 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 | 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. | ||||
PPVAcctID | 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 | 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. | ||||
PTOExpenseAcctID | int | PTO Expense Account | Account | |
Description:No description available | ||||
PTOExpenseSubID | int | PTO Expense Sub. | Sub | |
Description:No description available | ||||
PackSeparately | 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". | ||||
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""). | ||||
PageTitle | nvarchar(100) | Page Title | - | |
Description:The title to use on this item's page. | ||||
ParentItemClassIDNonexistent in DB | int? | - | ||
Description:The field is used to populate standard settings of Inventory Item from Item Class when it's created On-The-Fly and not yet persisted. Corresponds to the INItemClass.ItemClassID field. | ||||
PendingBasePriceNonexistent in DB | int? | Pending Base Price | - | |
Description:No description available | ||||
PendingBasePriceDateNonexistent in DB | int? | Pending Base Price Date | - | |
Description:No description available | ||||
PendingStdCostObsolete | decimal | Pending Cost | - | |
Description:The standard cost to be assigned to the item when the costs are updated. | ||||
PendingStdCostDateObsolete | datetime | Pending Cost Date | - | |
Description:The date when the Pending Cost becomes effective. | ||||
PercentOfSalesPrice | decimal | 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. | ||||
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 | nvarchar | Post Cost to Expenses On | - | |
Description:When set to Sales, indicates that cost will be processed using expense accrual account. | ||||
PreferredItemClasses | char(1) | Preferred Item Classes | - | |
Description:No description available | ||||
PreferredVendorIDObsolete | int | Preferred Vendor | - | |
Description:Preferred (default) Vendor for purchases of this item. Corresponds to the BAccount.BAccountID field. | ||||
PreferredVendorLocationIDObsolete | int | Preferred Location | - | |
Description:The Location of the Preferred (default) Vendor. Corresponds to the Location.LocationID field. | ||||
PriceClassID | 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 | int | Price Manager | EPEmployee | |
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 | int | Price Workgroup | EPCompanyTree | |
Description:The workgroup that is responsible for the pricing of this item. Corresponds to the EPCompanyTree.WorkGroupID field. | ||||
ProductManagerID | int | Product Manager | EPEmployee | |
Description:The product manager responsible for this item. Corresponds to the Contact.ContactID field. | ||||
ProductWorkgroupID | int | Product Workgroup | EPCompanyTree | |
Description:The workgroup that is responsible for the item. Corresponds to the EPCompanyTree.WorkGroupID field. | ||||
PurchaseUnit | 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 | 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. | ||||
RecPriceObsolete | decimal | MSRP | - | |
Description:The manufacturer's suggested retail price of the item. | ||||
ReplenishmentSource | char(1) | Source | - | |
Description:Replenishment source | ||||
RowAttributeValue | nvarchar | - | ||
Description:Value of row matrix attribute of template item. | ||||
SalesAcctID | 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 | 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 | 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. | ||||
SampleDescriptionNonexistent in DB | string | - | ||
Description:Contains Inventory Description Example Projections.DescriptionGenerationRule | ||||
SampleIDNonexistent in DB | string | - | ||
Description:Contains Inventory ID Example Projections.IDGenerationRule | ||||
SearchKeywords | nvarchar(1024) | Search Keywords | - | |
Description:A comma-separated list of search keywords for this item. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:Indicates whether the record is selected for mass processing. | ||||
ShortDescription | nvarchar(1024) | Short Description | - | |
Description:A short description for this item. | ||||
StdCostObsolete | decimal | Current Cost | - | |
Description:The current standard cost of the item. | ||||
StdCostDateObsolete | datetime | Effective Date | - | |
Description:The date when the Current Cost became effective. | ||||
StdCstRevAcctID | 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 | 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 | 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 | 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. | ||||
T5018Service | bit | T5018 Service | - | |
Description:Flag the indicates that this Item should be considered a construction service for the purpose of T5018 report generation. | ||||
TaxCalcMode | char(1) | Tax Calculation Mode | - | |
Description:The tax calculation mode, which defines which amounts (tax-inclusive or tax-exclusive) should be entered in the detail lines of a document. This field is displayed only if the FeaturesSet.NetGrossEntryMode field is set to "true". The field can have one of the following values: ""T"" (Tax Settings): The tax amount for the document is calculated according to the settings of the applicable tax or taxes. ""G"" (Gross): The amount in the document detail line includes a tax or taxes. ""N"" (Net): The amount in the document detail line does not include taxes. | ||||
TaxCategoryID | 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. | ||||
TaxExpenseAcctID | int | Tax Expense Account | Account | |
Description:No description available | ||||
TaxExpenseSubID | int | Tax Expense Sub. | Sub | |
Description:No description available | ||||
TemplateItemID | int | Template Item | InventoryItem | |
Description:References to parent Inventory Item, its database identifier, if this item was created from template. | ||||
TotalPercentageNonexistent 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. | ||||
UndershipThreshold | decimal | Undership Threshold (%) | - | |
Description:No description available | ||||
UpdateOnlySelectedNonexistent in DB | bool? | 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. | ||||
VendorWarrantyType | char(1) | Vendor Warranty Type | - | |
Description:No description available | ||||
VendorWarrantyValue | int | Vendor Warranty | - | |
Description:No description available | ||||
Visibility | nvarchar(1) | Visibility | - | |
Description:Indicates the visibility for this inventory item. | ||||
VolumeUOM | 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 | nvarchar(6) | Weight UOM | INUnit | |
Description:The Unit of Measure used for the Weight of the item. Corresponds to the INUnit.FromUnit field. | ||||
chkEquipmentManagementNonexistent in DB | bool? | - | ||
Description:No description available | ||||
chkServiceManagementNonexistent in DB | bool? | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||