Table 27 Item in 28

App
Base Application
Namespace
Microsoft.Inventory.Item

Fields, 206Keys, 15Procedures, 59Events, 70

Versions171819202122232425262728latest

Source29

Fields, 206

IdNameTypeObsolete
1No.Code[20]-
2No. 2Code[20]-
3DescriptionText[100]-
4Search DescriptionCode[100]-
5Description 2Text[50]-
6Assembly BOMBoolean-
8Base Unit of MeasureCode[10]-
9Price Unit ConversionInteger-
10TypeEnum Item Type-
11Inventory Posting GroupCode[20]-
12Shelf No.Code[10]-
14Item Disc. GroupCode[20]-
15Allow Invoice Disc.Boolean-
16Statistics GroupInteger-
17Commission GroupInteger-
18Unit PriceDecimal-
19Price/Profit CalculationEnum Item Price Profit Calculation-
20Profit %Decimal-
21Costing MethodEnum Costing Method-
22Unit CostDecimal-
24Standard CostDecimal-
25Last Direct CostDecimal-
28Indirect Cost %Decimal-
29Cost is AdjustedBoolean-
30Allow Online AdjustmentBoolean-
31Vendor No.Code[20]-
32Vendor Item No.Text[50]-
33Lead Time CalculationDateFormula-
34Reorder PointDecimal-
35Maximum InventoryDecimal-
36Reorder QuantityDecimal-
37Alternative Item No.Code[20]-
38Unit List PriceDecimal-
39Duty Due %Decimal-
40Duty CodeCode[10]-
41Gross WeightDecimal-
42Net WeightDecimal-
43Units per ParcelDecimal-
44Unit VolumeDecimal-
45DurabilityCode[10]-
46Freight TypeCode[10]-
47Tariff No.Code[20]-
48Duty Unit ConversionDecimal-
49Country/Region Purchased CodeCode[10]-
50Budget QuantityDecimal-
51Budgeted AmountDecimal-
52Budget ProfitDecimal-
53CommentBoolean-
54BlockedBoolean-
55Cost is Posted to G/LBoolean-
56Block ReasonText[250]-
61Last DateTime ModifiedDateTime-
62Last Date ModifiedDate-
63Last Time ModifiedTime-
64Date FilterDate-
65Global Dimension 1 FilterCode[20]-
66Global Dimension 2 FilterCode[20]-
67Location FilterCode[10]-
68InventoryDecimal-
69Net Invoiced Qty.Decimal-
70Net ChangeDecimal-
71Purchases (Qty.)Decimal-
72Sales (Qty.)Decimal-
73Positive Adjmt. (Qty.)Decimal-
74Negative Adjmt. (Qty.)Decimal-
77Purchases (LCY)Decimal-
78Sales (LCY)Decimal-
79Positive Adjmt. (LCY)Decimal-
80Negative Adjmt. (LCY)Decimal-
83COGS (LCY)Decimal-
84Qty. on Purch. OrderDecimal-
85Qty. on Sales OrderDecimal-
87Price Includes VATBoolean-
89Drop Shipment FilterBoolean-
90VAT Bus. Posting Gr. (Price)Code[20]-
91Gen. Prod. Posting GroupCode[20]-
92PictureMediaSet-
93Transferred (Qty.)Decimal-
94Transferred (LCY)Decimal-
95Country/Region of Origin CodeCode[10]-
96Automatic Ext. TextsBoolean-
97No. SeriesCode[20]-
98Tax Group CodeCode[20]-
99VAT Prod. Posting GroupCode[20]-
100ReserveEnum Reserve Method-
101Reserved Qty. on InventoryDecimal-
102Reserved Qty. on Purch. OrdersDecimal-
103Reserved Qty. on Sales OrdersDecimal-
105Global Dimension 1 CodeCode[20]-
106Global Dimension 2 CodeCode[20]-
107Res. Qty. on Outbound TransferDecimal-
108Res. Qty. on Inbound TransferDecimal-
109Res. Qty. on Sales ReturnsDecimal-
110Res. Qty. on Purch. ReturnsDecimal-
120Stockout WarningOption-
121Prevent Negative InventoryOption-
122Variant Mandatory if ExistsOption-
521Application Wksh. User IDCode[128]-
720Coupled to CRMBooleanRemoved 26.0
Replaced by flow field Coupled to Dataverse
721Coupled to DataverseBoolean-
910Assembly PolicyEnum Assembly Policy-
1001Qty. on Job OrderDecimal-
1002Res. Qty. on Job OrderDecimal-
1217GTINCode[14]-
1700Default Deferral Template CodeCode[10]-
5400Low-Level CodeInteger-
5401Lot SizeDecimal-
5402Serial Nos.Code[20]-
5403Last Unit Cost Calc. DateDate-
5404Rolled-up Material CostDecimal-
5405Rolled-up Capacity CostDecimal-
5407Scrap %Decimal-
5408Rolled-up Mat. Non-Invt. CostDecimal-
5409Inventory Value ZeroBoolean-
5410Discrete Order QuantityInteger-
5411Minimum Order QuantityDecimal-
5412Maximum Order QuantityDecimal-
5413Safety Stock QuantityDecimal-
5414Order MultipleDecimal-
5415Safety Lead TimeDateFormula-
5417Flushing MethodEnum Flushing Method-
5419Replenishment SystemEnum Replenishment System-
5422Rounding PrecisionDecimal-
5423Bin FilterCode[20]-
5424Variant FilterCode[10]-
5425Sales Unit of MeasureCode[10]-
5426Purch. Unit of MeasureCode[10]-
5427Unit of Measure FilterCode[10]-
5428Time BucketDateFormula-
5431Res. Qty. on Req. LineDecimal-
5440Reordering PolicyEnum Reordering Policy-
5441Include InventoryBoolean-
5442Manufacturing PolicyEnum Manufacturing Policy-
5443Rescheduling PeriodDateFormula-
5444Lot Accumulation PeriodDateFormula-
5445Dampener PeriodDateFormula-
5446Dampener QuantityDecimal-
5447Overflow LevelDecimal-
5449Planning Transfer Ship. (Qty).Decimal-
5450Planning Worksheet (Qty.)Decimal-
5700Stockkeeping Unit ExistsBoolean-
5701Manufacturer CodeCode[10]-
5702Item Category CodeCode[20]-
5703Created From Nonstock ItemBoolean-
5706Substitutes ExistBoolean-
5707Qty. in TransitDecimal-
5708Trans. Ord. Receipt (Qty.)Decimal-
5709Trans. Ord. Shipment (Qty.)Decimal-
5711Purchasing CodeCode[10]-
5776Qty. Assigned to shipDecimal-
5777Qty. PickedDecimal-
5801Excluded from Cost AdjustmentBoolean-
6500Item Tracking CodeCode[10]-
6501Lot Nos.Code[20]-
6502Expiration CalculationDateFormula-
6503Lot No. FilterCode[50]-
6504Serial No. FilterCode[50]-
6515Package No. FilterCode[50]-
6650Qty. on Purch. ReturnDecimal-
6660Qty. on Sales ReturnDecimal-
7171No. of SubstitutesInteger-
7300Warehouse Class CodeCode[10]-
7301Special Equipment CodeCode[10]-
7302Put-away Template CodeCode[10]-
7307Put-away Unit of Measure CodeCode[10]-
7380Phys Invt Counting Period CodeCode[10]-
7381Last Counting Period UpdateDate-
7383Last Phys. Invt. DateDate-
7384Use Cross-DockingBoolean-
7385Next Counting Start DateDate-
7386Next Counting End DateDate-
7387Unit Group ExistsBoolean-
7700Identifier CodeCode[20]-
8001Unit of Measure IdGuid-
8002Tax Group IdGuid-
8003Sales BlockedBoolean-
8004Purchasing BlockedBoolean-
8005Item Category IdGuid-
8006Inventory Posting Group IdGuid-
8007Gen. Prod. Posting Group IdGuid-
8010Service BlockedBoolean-
8510Over-Receipt CodeCode[20]-
9110Qty. on Blanket Sales OrderDecimal-
9210Qty. on Blanket Purch. OrderDecimal-
99000752Single-Level Material CostDecimal-
99000753Single-Level Capacity CostDecimal-
99000754Single-Level Subcontrd. CostDecimal-
99000755Single-Level Cap. Ovhd CostDecimal-
99000756Single-Level Mfg. Ovhd CostDecimal-
99000757Overhead RateDecimal-
99000758Rolled-up Subcontracted CostDecimal-
99000759Rolled-up Mfg. Ovhd CostDecimal-
99000760Rolled-up Cap. Overhead CostDecimal-
99000761Planning Issues (Qty.)Decimal-
99000762Planning Receipt (Qty.)Decimal-
99000768Planning Release (Qty.)Decimal-
99000770Purch. Req. Receipt (Qty.)Decimal-
99000771Purch. Req. Release (Qty.)Decimal-
99000773Order Tracking PolicyEnum Order Tracking Policy-
99000774Prod. Forecast Quantity (Base)Decimal-
99000775Production Forecast NameCode[10]-
99000776Component ForecastBoolean-
99000779Single-Lvl Mat. Non-Invt. CostDecimal-
99000780Allow Whse. OverpickBoolean-
99000875CriticalBoolean-
99008500Common Item No.Code[20]-

Keys, 15

NameFieldsObsolete
Key1, clusteredNo.-
Key2Search Description-
Key3Inventory Posting Group-
Key4Shelf No.-
Key5Vendor No.-
Key6Gen. Prod. Posting Group-
Key7Low-Level Code-
Key10Vendor Item No., Vendor No.-
Key11Common Item No.-
Key13Cost is Adjusted, Allow Online Adjustment-
Key14Description-
Key15Base Unit of Measure-
Key16Type-
Key17SystemModifiedAt-
Key18GTIN-

Procedures, 59

NameParametersReturnsAccessObsolete
AssistEdit()Booleanpublic-
FindItemVend(var Record Item Vendor, Code[10])public-
ValidateShortcutDimCode(Integer, var Code[20])public-
TestNoEntriesExist(Text[100])public-
TestNoOpenEntriesExist(Text[100])public-
ItemSKUGet(var Record Item, Code[10], Code[10])public-
IsMfgItem()Booleanpublic-
IsAssemblyItem()Booleanpublic-
HasBOM()Booleanpublic-
CheckSerialNoQty(Code[20], Text[30], Decimal)public-
CheckBlockedByApplWorksheet()public-
CheckJournalsAndWorksheets(Integer)public-
CheckDocuments(Integer)public-
PreventNegativeInventory()Booleanpublic-
CalcUnitPriceExclVAT()Decimalpublic-
GetItemNo(Text)Code[20]public-
ShowPriceListLines(Enum Price Type, Enum Price Amount Type)public-
TryGetItemNo(var Text[50], Text, Boolean)Booleanpublic-
TryGetItemNoOpenCard(var Text, Text, Boolean, Boolean, Boolean)Booleanpublic-
TryGetItemNoOpenCardWithView(var Text, Text, Boolean, Boolean, Boolean, Text)Booleaninternal-
PickItem(var Record Item)Code[20]public-
SetLastDateTimeFilter(DateTime)public-
UpdateReplenishmentSystem()Booleanpublic-
UpdateUnitOfMeasureId()public-
UpdateItemCategoryId()public-
UpdateTaxGroupId()public-
UpdateReferencedIds()public-
GetReferencedIds(var Record Field)public-
IsServiceType()Booleanpublic-
IsNonInventoriableType()Booleanpublic-
IsInventoriableType()Booleanpublic-
ExistsItemLedgerEntry()Booleanpublic-
ItemTrackingCodeUseExpirationDates()Booleanpublic-
SetLastDateTimeModified()public-
GetSKU(Code[10], Code[10])Record Stockkeeping Unitpublic-
IsVariantMandatory(Boolean, Code[20])Booleanpublic-
IsVariantMandatory()Booleanpublic-
IsVariantMandatory(Boolean)Booleaninternal-
CheckTransLine(Integer, Integer, Text)public-
TestNoWhseEntriesExist(Text)public-
CheckUpdateFieldsForNonInventoriableItem()public-
CalcVAT()Decimalpublic-
GetCannotChangeItemWithExistingDocumentLinesErr()Textpublic-
GetCannotDeleteItemWithExistingDocumentLinesErr()Textpublic-
UpdateCostIsAdjusted()public-
IsProductionBOM()Booleanpublic-
HasRoutingNo()Booleanpublic-
CheckDocuments(Integer, Integer, Text)public-
GetFirstItemNoFromLookup(Text)Code[20]public-
ShouldTryCostFromSKU()Booleanpublic-
CalcScheduledReceiptQty()Decimalpublic-
CalcQtyOnComponentLines()Decimalpublic-
CalcQtyOnProdOrder()Decimalpublic-
CalcResQtyonProdOrderComp()Decimalpublic-
CalcReservedQtyOnProdOrder()Decimalpublic-
CalcPlannedOrderReceiptQty()Decimalpublic-
CalcFPOrderReceiptQty()Decimalpublic-
CalcRelOrderReceiptQty()Decimalpublic-
CalcQtyOnServiceOrder()Decimalpublic-

Events, 70

KindNameParametersObsolete
Integration eventOnAfterDeleteRelatedData(Record Item)-
Integration eventOnAfterValidateShortcutDimCode(var Record Item, Record Item, Integer, var Code[20])-
Integration eventOnBeforeAssistEdit(var Record Item, var Record Item, var Boolean, var Boolean)-
Integration eventOnBeforeCheckSNSpecificTrackingInteger(var Record Item, var Boolean)-
Integration eventOnBeforeCheckUpdateFieldsForNonInventoriableItem(var Record Item, Record Item, Integer, var Boolean)-
Integration eventOnBeforeCreateItemUnitOfMeasure(var Record Item, var Record Item Unit of Measure, var Boolean)-
Integration eventOnBeforeCreateNewItem(var Record Item, var Text[100])-
Integration eventOnBeforeTestNoPurchLinesExist(Record Item, Text[100], var Boolean)-
Integration eventOnBeforeValidateShortcutDimCode(var Record Item, Record Item, Integer, var Code[20])-
Integration eventOnBeforeValidateStandardCost(var Record Item, Record Item, Integer, var Boolean)-
Integration eventOnBeforeValidateBaseUnitOfMeasure(var Record Item, Record Item, Integer, var Boolean)-
Integration eventOnValidateReplenishmentSystemCaseElse(var Record Item)-
Integration eventOnValidateReplenishmentSystemCaseTransfer(var Record Item, var Boolean)-
Integration eventOnFindItemVendOnAfterSetFilters(var Record Item Vendor, Record Item)-
Integration eventOnTryGetItemNoOpenCardOnAfterSetItemFilters(var Record Item, var Text)-
Integration eventOnAfterIsMfgItem(Record Item, var Boolean)-
Integration eventOnBeforeOnDelete(var Record Item, var Boolean)-
Integration eventOnValidatePhysInvtCountingPeriodCodeOnBeforeConfirmUpdate(var Record Item, Record Item, Record Phys. Invt. Counting Period, var Boolean)-
Integration eventOnBeforeTestNoWhseEntriesExist(Record Item, Text, var Boolean)-
Integration eventOnAfterOnInsert(var Record Item, var Record Item)-
Integration eventOnBeforeTestNoOpenDocumentsWithTrackingExist(Record Item, Record Item Tracking Code, var Boolean)-
Integration eventOnBeforeUpdateQtyRoundingPrecisionForBaseUoM(var Record Item, Record Item, var Boolean)-
Integration eventOnValidateReplenishmentSystemCaseAssemblyr(var Record Item, var Boolean)-
Integration eventOnBeforeValidateUnitCost(var Record Item, Record Item, Integer, var Boolean)-
Integration eventOnTryGetItemNoOpenCardWithViewOnBeforeShowCreateItemOption(var Record Item)-
Integration eventOnAfterIsAssemblyItem(Record Item, var Boolean)-
Integration eventOnAfterSetLastDateTimeModified(var Record Item)-
Integration eventOnBeforeTestNoOpenEntriesExist(Record Item, var Record Item Ledger Entry, Text[100], var Boolean)-
Integration eventOnValidateBaseUnitOfMeasure(var Boolean)-
Integration eventOnBeforeUpdateReplenishmentSystem(var Record Item, var Boolean, var Boolean)-
Integration eventOnAfterValidateItemCategoryCode(var Record Item, Record Item)-
Integration eventOnBeforeOnInsert(var Record Item, var Boolean, Record Item)-
Integration eventOnValidateOrderTrackingPolicyOnBeforeUpdateReservation(var Record Item, var Boolean)-
Integration eventOnCalcVATOnAfterVATPostingSetupGet(var Record VAT Posting Setup)-
Integration eventOnBeforeCheckReqLine(Record Item, Integer, Integer, Text, var Boolean)-
Integration eventOnBeforeCheckItemJnlLine(Record Item, Integer, Integer, Text, var Boolean)-
Integration eventOnBeforeIsVariantMandatory(Code[20], var Boolean, var Boolean)-
Integration eventOnModifyOnBeforePlanningAssignmentItemChange(var Record Item, Record Item, Record Planning Assignment, var Boolean)-
Integration eventOnBeforeTestNoItemLedgEntiesExist(var Record Item, Text[100], var Boolean)-
Integration eventOnBeforeFindItemVend(var Record Item, var Record Item Vendor, Code[10], var Boolean)-
Integration eventOnAfterFindItemVend(var Record Item Vendor, Record Item, Record Stockkeeping Unit, Code[10])-
Integration eventOnValidateTypeOnBeforeCheckExistsItemLedgerEntry(var Record Item, Record Item, Integer, var Boolean)-
Integration eventOnBeforeCheckStdCostWksh(var Record Item, Integer, var Boolean)-
Integration eventOnValidateItemTrackingCodeOnBeforeTestNoEntriesExist(var Record Item, Record Item, Integer, var Boolean)-
Integration eventOnAfterUpdateItemCategoryId(var Record Item, var Record Item Category)-
Integration eventOnBeforeCheckDocuments(Record Item, Integer, var Boolean)-
Integration eventOnFindItemVendOnAfterFindItemVend(var Record Item Vendor, Record Item, var Record Stockkeeping Unit, Code[10])-
Integration eventOnAfterHasBOM(var Record Item, var Boolean)-
Integration eventOnAfterCheckUpdateFieldsForNonInventoriableItem(var Record Item)-
Integration eventOnValidateGenProdPostingGroupOnConfirmChange(var Record Item, Code[20], var Boolean)-
Integration eventOnInsertOnAfterAssignNo(var Record Item, Record Item)-
Integration eventOnAssistEditOnAfterAssignNo(var Record Item, Record Item)-
Integration eventOnAfterCheckDocuments(var Record Item, var Record Item, var Integer, Integer, Text)-
Integration eventOnIsAssemblyItem(Record Item, var Boolean)-
Integration eventOnIsMfgItem(Record Item, var Boolean)-
Internal eventOnIsProductionBOM(Record Item, var Boolean)-
Integration eventOnBeforeValidateNo(var Boolean, var Record Item, Record Item, Record Inventory Setup)-
Integration eventOnAfterHasRoutingNo(var Record Item, var Boolean)-
Integration eventOnCalcScheduledReceiptQty(var Record Item, var Decimal)-
Integration eventOnCalcQtyOnComponentLines(var Record Item, var Decimal)-
Integration eventOnCalcQtyOnProdOrder(var Record Item, var Decimal)-
Integration eventOnCalcResQtyonProdOrderComp(var Record Item, var Decimal)-
Integration eventOnCalcReservedQtyOnProdOrder(var Record Item, var Decimal)-
Integration eventOnCalcPlannedOrderReceiptQty(var Record Item, var Decimal)-
Integration eventOnCalcFPOrderReceiptQty(var Record Item, var Decimal)-
Integration eventOnCalcRelOrderReceiptQty(var Record Item, var Decimal)-
Internal eventOnShouldTryCostFromSKUOnCheckSKUCostOnMfg(var Boolean)-
Integration eventOnPickItemOnBeforeFindFirstItem(var Record Item)-
Integration eventOnCalcQtyOnServiceOrder(var Record Item, var Decimal)-
Integration eventOnBeforeGetFirstItemNoFromLookup(Text, var Code[20], var Boolean, var Boolean)-