Table 27 Item

Base Application, Microsoft.Inventory.Item

213 fields

IdNameTypeVersions
1No.Code[20]17-29
2No. 2Code[20]17-29
3DescriptionText[100]17-29
4Search DescriptionCode[100]17-29
5Description 2Text[50]17-29
6Assembly BOMBoolean17-29
8Base Unit of MeasureCode[10]17-29
9Price Unit ConversionInteger17-29
10TypeEnum "Item Type"17-29
11Inventory Posting GroupCode[20]17-29
12Shelf No.Code[10]17-29
14Item Disc. GroupCode[20]17-29
15Allow Invoice Disc.Boolean17-29
16Statistics GroupInteger17-29
17Commission GroupInteger17-29
18Unit PriceDecimal17-29
19Price/Profit CalculationEnum "Item Price Profit Calculation"17-29changed in 19
20Profit %Decimal17-29
21Costing MethodEnum "Costing Method"17-29
22Unit CostDecimal17-29
24Standard CostDecimal17-29
25Last Direct CostDecimal17-29
28Indirect Cost %Decimal17-29
29Cost is AdjustedBoolean17-29
30Allow Online AdjustmentBoolean17-29
31Vendor No.Code[20]17-29
32Vendor Item No.Text[50]17-29
33Lead Time CalculationDateFormula17-29
34Reorder PointDecimal17-29
35Maximum InventoryDecimal17-29
36Reorder QuantityDecimal17-29
37Alternative Item No.Code[20]17-29
38Unit List PriceDecimal17-29
39Duty Due %Decimal17-29
40Duty CodeCode[10]17-29
41Gross WeightDecimal17-29
42Net WeightDecimal17-29
43Units per ParcelDecimal17-29
44Unit VolumeDecimal17-29
45DurabilityCode[10]17-29
46Freight TypeCode[10]17-29
47Tariff No.Code[20]17-29
48Duty Unit ConversionDecimal17-29
49Country/Region Purchased CodeCode[10]17-29
50Budget QuantityDecimal17-29
51Budgeted AmountDecimal17-29
52Budget ProfitDecimal17-29
53CommentBoolean17-29
54BlockedBoolean17-29
55Cost is Posted to G/LBoolean17-29
56Block ReasonText[250]17-29
61Last DateTime ModifiedDateTime17-29
62Last Date ModifiedDate17-29
63Last Time ModifiedTime17-29
64Date FilterDate17-29
65Global Dimension 1 FilterCode[20]17-29
66Global Dimension 2 FilterCode[20]17-29
67Location FilterCode[10]17-29
68InventoryDecimal17-29
69Net Invoiced Qty.Decimal17-29
70Net ChangeDecimal17-29
71Purchases (Qty.)Decimal17-29
72Sales (Qty.)Decimal17-29
73Positive Adjmt. (Qty.)Decimal17-29
74Negative Adjmt. (Qty.)Decimal17-29
77Purchases (LCY)Decimal17-29
78Sales (LCY)Decimal17-29
79Positive Adjmt. (LCY)Decimal17-29
80Negative Adjmt. (LCY)Decimal17-29
83COGS (LCY)Decimal17-29
84Qty. on Purch. OrderDecimal17-29
85Qty. on Sales OrderDecimal17-29
87Price Includes VATBoolean17-29
89Drop Shipment FilterBoolean17-29
90VAT Bus. Posting Gr. (Price)Code[20]17-29
91Gen. Prod. Posting GroupCode[20]17-29
92PictureMediaSet17-29
93Transferred (Qty.)Decimal17-29
94Transferred (LCY)Decimal17-29
95Country/Region of Origin CodeCode[10]17-29
96Automatic Ext. TextsBoolean17-29
97No. SeriesCode[20]17-29
98Tax Group CodeCode[20]17-29
99VAT Prod. Posting GroupCode[20]17-29
100ReserveEnum "Reserve Method"17-29
101Reserved Qty. on InventoryDecimal17-29
102Reserved Qty. on Purch. OrdersDecimal17-29
103Reserved Qty. on Sales OrdersDecimal17-29
105Global Dimension 1 CodeCode[20]17-29
106Global Dimension 2 CodeCode[20]17-29
107Res. Qty. on Outbound TransferDecimal17-29
108Res. Qty. on Inbound TransferDecimal17-29
109Res. Qty. on Sales ReturnsDecimal17-29
110Res. Qty. on Purch. ReturnsDecimal17-29
120Stockout WarningOption17-29
121Prevent Negative InventoryOption17-29
122Variant Mandatory if ExistsOptionnew in 21
521Application Wksh. User IDCode[128]17-29
720Coupled to CRMBooleannew in 19
Removed, tag 26.0, obsolete since 22.1: Replaced by flow field Coupled to Dataverse
721Coupled to DataverseBooleannew in 22
910Assembly PolicyEnum "Assembly Policy"17-29
1001Qty. on Job OrderDecimal17-29
1002Res. Qty. on Job OrderDecimal17-29
1217GTINCode[14]17-29
1700Default Deferral Template CodeCode[10]17-29
5400Low-Level CodeInteger17-29
5401Lot SizeDecimal17-29
5402Serial Nos.Code[20]17-29
5403Last Unit Cost Calc. DateDate17-29
5404Rolled-up Material CostDecimal17-29
5405Rolled-up Capacity CostDecimal17-29
5407Scrap %Decimal17-29
5408Rolled-up Mat. Non-Invt. CostDecimalnew in 26
5409Inventory Value ZeroBoolean17-29
5410Discrete Order QuantityInteger17-29
5411Minimum Order QuantityDecimal17-29
5412Maximum Order QuantityDecimal17-29
5413Safety Stock QuantityDecimal17-29
5414Order MultipleDecimal17-29
5415Safety Lead TimeDateFormula17-29
5417Flushing MethodEnum "Flushing Method"17-25, 27-29
5419Replenishment SystemEnum "Replenishment System"17-29
5422Rounding PrecisionDecimal17-29
5423Bin FilterCode[20]17-29
5424Variant FilterCode[10]17-29
5425Sales Unit of MeasureCode[10]17-29
5426Purch. Unit of MeasureCode[10]17-29
5427Unit of Measure FilterCode[10]17-29
5428Time BucketDateFormula17-29
5431Res. Qty. on Req. LineDecimal17-29
5440Reordering PolicyEnum "Reordering Policy"17-29
5441Include InventoryBoolean17-29
5442Manufacturing PolicyEnum "Manufacturing Policy"17-29
5443Rescheduling PeriodDateFormula17-29
5444Lot Accumulation PeriodDateFormula17-29
5445Dampener PeriodDateFormula17-29
5446Dampener QuantityDecimal17-29
5447Overflow LevelDecimal17-29
5449Planning Transfer Ship. (Qty).Decimal17-29
5450Planning Worksheet (Qty.)Decimal17-29
5700Stockkeeping Unit ExistsBoolean17-29
5701Manufacturer CodeCode[10]17-29
5702Item Category CodeCode[20]17-29
5703Created From Nonstock ItemBoolean17-29
5706Substitutes ExistBoolean17-29
5707Qty. in TransitDecimal17-29
5708Trans. Ord. Receipt (Qty.)Decimal17-29
5709Trans. Ord. Shipment (Qty.)Decimal17-29
5711Purchasing CodeCode[10]17-29
5776Qty. Assigned to shipDecimal17-29
5777Qty. PickedDecimal17-29
5801Excluded from Cost AdjustmentBooleannew in 24
6500Item Tracking CodeCode[10]17-29
6501Lot Nos.Code[20]17-29
6502Expiration CalculationDateFormula17-29
6503Lot No. FilterCode[50]17-29
6504Serial No. FilterCode[50]17-29
6515Package No. FilterCode[50]new in 18changed in 19
6650Qty. on Purch. ReturnDecimal17-29
6660Qty. on Sales ReturnDecimal17-29
7171No. of SubstitutesInteger17-29
7300Warehouse Class CodeCode[10]17-29
7301Special Equipment CodeCode[10]17-29
7302Put-away Template CodeCode[10]17-29
7307Put-away Unit of Measure CodeCode[10]17-29
7380Phys Invt Counting Period CodeCode[10]17-29
7381Last Counting Period UpdateDate17-29
7383Last Phys. Invt. DateDate17-29
7384Use Cross-DockingBoolean17-29
7385Next Counting Start DateDate17-29
7386Next Counting End DateDate17-29
7387Unit Group ExistsBooleannew in 21
7700Identifier CodeCode[20]17-29
8001Unit of Measure IdGuid17-29
8002Tax Group IdGuid17-29
8003Sales BlockedBoolean17-29
8004Purchasing BlockedBoolean17-29
8005Item Category IdGuid17-29
8006Inventory Posting Group IdGuidnew in 19
8007Gen. Prod. Posting Group IdGuidnew in 19
8010Service BlockedBooleannew in 24
8510Over-Receipt CodeCode[20]17-29
9110Qty. on Blanket Sales OrderDecimalnew in 28
9210Qty. on Blanket Purch. OrderDecimalnew in 28
10004Duty ClassCode[10]17-29
10011Consumptions (Qty.)Decimal17-29
10012Outputs (Qty.)Decimal17-29
27000SAT Item ClassificationCode[10]17-29
27024SAT Hazardous MaterialCode[10]new in 19
27025SAT Packaging TypeCode[10]new in 19
27026SAT Material TypeCode[10]new in 23
99000752Single-Level Material CostDecimal17-25, 27-29
99000753Single-Level Capacity CostDecimal17-25, 27-29
99000754Single-Level Subcontrd. CostDecimal17-25, 27-29
99000755Single-Level Cap. Ovhd CostDecimal17-25, 27-29
99000756Single-Level Mfg. Ovhd CostDecimal17-25, 27-29
99000757Overhead RateDecimal17-29
99000758Rolled-up Subcontracted CostDecimal17-25, 27-29
99000759Rolled-up Mfg. Ovhd CostDecimal17-25, 27-29
99000760Rolled-up Cap. Overhead CostDecimal17-25, 27-29
99000761Planning Issues (Qty.)Decimal17-29
99000762Planning Receipt (Qty.)Decimal17-29
99000768Planning Release (Qty.)Decimal17-29
99000770Purch. Req. Receipt (Qty.)Decimal17-29
99000771Purch. Req. Release (Qty.)Decimal17-29
99000773Order Tracking PolicyEnum "Order Tracking Policy"17-29
99000774Prod. Forecast Quantity (Base)Decimal17-25, 27-29
99000775Production Forecast NameCode[10]17-25, 27-29
99000776Component ForecastBoolean17-25, 27-29
99000779Single-Lvl Mat. Non-Invt. CostDecimalnew in 27
99000780Allow Whse. OverpickBooleannew in 27
99000875CriticalBoolean17-29
99008500Common Item No.Code[20]17-29