Table 27 Item in 26

App
Base Application
Namespace
Microsoft.Inventory.Item

Fields, 190Keys, 15Procedures, 66Events, 68

Versions171819202122232425262728latest

Source29

Fields, 190

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-
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]-
99000757Overhead RateDecimal-
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-
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, 66

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-
CheckBOM(Integer, Integer, Text)publicPending 25.0
Replaced by procedure CheckBOMComponents() in codeunit CheckBOMComponent
CheckPurchLine(Integer, Integer, Text)publicPending 25.0
Replaced by procedure CheckPurchLine() in codeunit CheckPurchDocumentLine
CheckSalesLine(Integer, Integer, Text)publicPending 25.0
Replaced by procedure CheckSalesLine() in codeunit CheckSalesDocumentLine
CheckPlanningCompLine(Integer, Integer, Text)publicPending 25.0
Replaced by procedure CheckPlanningCompLine() in codeunit CheckPlanningComponent
CheckTransLine(Integer, Integer, Text)public-
CheckServLine(Integer, Integer, Text)publicPending 25.0
Replaced by procedure CheckServiceLine() in codeunit CheckServiceDocument
CheckServContractLine(Integer, Integer, Text)publicPending 25.0
Replaced by procedure CheckServiceContractLine() in codeunit CheckServiceDocument
CheckJobPlanningLine(Integer, Integer, Text)publicPending 25.0
Replaced by procedure CheckJobPlanningLines() in codeunit CheckJobPlanningLine
TestNoWhseEntriesExist(Text)public-
CheckUpdateFieldsForNonInventoriableItem()public-
CalcVAT()Decimalpublic-
GetCannotChangeItemWithExistingDocumentLinesErr()Textpublic-
GetCannotDeleteItemWithExistingDocumentLinesErr()Textpublic-
RunOnBeforeCheckPurchLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckSalesLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckServLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckServContractLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckProdOrderLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckProdOrderCompLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckBOM(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckProdBOMLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckPlanningCompLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckJobPlanningLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckAsmHeader(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckAsmLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnBeforeCheckTransLine(Record Item, Integer, Integer, Text, var Boolean)internal-
RunOnCheckPurchLineOnAfterPurchLineSetFilters(Record Item, var Record Purchase Line, Integer, Integer, Text)internal-
UpdateCostIsAdjusted()public-

Events, 68

KindNameParametersObsolete
Integration eventOnAfterCheckDocuments(var Record Item, var Record Item, var Integer)-
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 eventOnBeforeCheckPurchLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Replace by same event in codeunit CheckPurchDocumentLine
Integration eventOnBeforeCheckSalesLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Replace by same event in codeunit CheckSalesDocumentLine
Integration eventOnBeforeCheckServLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckServiceDocument
Integration eventOnBeforeCheckServContractLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckServiceDocument
Integration eventOnBeforeCheckProdOrderLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckProdOrderDocument
Integration eventOnBeforeCheckProdOrderCompLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckProdOrderDocument
Integration eventOnBeforeCheckBOM(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckBOMComponent
Integration eventOnBeforeCheckProdBOMLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckProdOrderDocument
Integration eventOnBeforeCheckPlanningCompLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckPlanningComponent
Integration eventOnBeforeCheckJobPlanningLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckJobPlanningLine
Integration eventOnBeforeCheckAsmHeader(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckAssemblyDocument
Integration eventOnBeforeCheckAsmLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckAssemblyDocument
Integration eventOnBeforeCheckTransLine(Record Item, Integer, Integer, Text, var Boolean)Pending 25.0
Moved to codeunit CheckTransferDocument
Integration eventOnBeforeCheckReqLine(Record Item, Integer, Integer, Text, var Boolean)-
Integration eventOnBeforeCheckItemJnlLine(Record Item, Integer, Integer, Text, var Boolean)-
Integration eventOnCheckPurchLineOnAfterPurchLineSetFilters(Record Item, var Record Purchase Line, Integer, Integer, Text)Pending 25.0
Moved to codeunit CheckPurchaseDocument
Integration eventOnBeforeIsVariantMandatory(Code[20], var Boolean, var Boolean)-
Integration eventOnBeforeValidateNo(var Boolean, var Record Item, Record Item, Record Inventory Setup, var Codeunit NoSeriesManagement)Pending 24.0
Parameter NoSeriesMgt is obsolete and will be removed, update your subscriber accordingly.
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)-