Table 1382 Item Templ.

Base Application, Microsoft.Inventory.Item

104 fields

IdNameTypeVersions
1CodeCode[20]17-29
2DescriptionText[100]17-29
8Base Unit of MeasureCode[10]17-29
9Price Unit ConversionIntegernew in 18
10TypeEnum "Item Type"17-29
11Inventory Posting GroupCode[20]17-29
12Shelf No.Code[10]new in 18
14Item Disc. GroupCode[20]17-29
15Allow Invoice Disc.Boolean17-29
16Statistics GroupIntegernew in 18
17Commission GroupIntegernew in 18
18Unit PriceDecimalnew in 18
19Price/Profit CalculationEnum "Item Price Profit Calculation"17-29changed in 19
20Profit %Decimal17-29
21Costing MethodEnum "Costing Method"17-29
22Unit CostDecimalnew in 18
24Standard CostDecimalnew in 18
28Indirect Cost %Decimal17-29
31Vendor No.Code[20]new in 18
32Vendor Item No.Text[50]new in 18
33Lead Time CalculationDateFormulanew in 18
34Reorder PointDecimalnew in 18
35Maximum InventoryDecimalnew in 18
36Reorder QuantityDecimalnew in 18
37Alternative Item No.Code[20]new in 18
38Unit List PriceDecimalnew in 18
39Duty Due %Decimalnew in 18
40Duty CodeCode[10]new in 18
41Gross WeightDecimalnew in 18
42Net WeightDecimalnew in 18
43Units per ParcelDecimalnew in 18
44Unit VolumeDecimalnew in 18
45DurabilityCode[10]new in 18
46Freight TypeCode[10]new in 18
47Tariff No.Code[20]new in 18
48Duty Unit ConversionDecimalnew in 18
49Country/Region Purchased CodeCode[10]new in 18
50Budget QuantityDecimalnew in 18
51Budgeted AmountDecimalnew in 18
52Budget ProfitDecimalnew in 18
54BlockedBoolean17-29
56Block ReasonText[250]new in 18
87Price Includes VATBoolean17-29
90VAT Bus. Posting Gr. (Price)Code[20]new in 18
91Gen. Prod. Posting GroupCode[20]17-29
95Country/Region of Origin CodeCode[10]new in 18
96Automatic Ext. TextsBoolean17-29
97No. SeriesCode[20]new in 18
98Tax Group CodeCode[20]17-29
99VAT Prod. Posting GroupCode[20]17-29
100ReserveEnum "Reserve Method"new in 18
105Global Dimension 1 CodeCode[20]17-29
106Global Dimension 2 CodeCode[20]17-29
120Stockout WarningOptionnew in 18
121Prevent Negative InventoryOptionnew in 18
122Variant Mandatory if ExistsOptionnew in 22
910Assembly PolicyEnum "Assembly Policy"new in 18
1217GTINCode[14]new in 18
1700Default Deferral Template CodeCode[10]new in 18
5401Lot SizeDecimalnew in 18
5402Serial Nos.Code[20]new in 18
5407Scrap %Decimalnew in 18
5408Rolled-up Mat. Non-Invt. CostDecimalnew in 26
5409Inventory Value ZeroBooleannew in 21
5410Discrete Order QuantityIntegernew in 18
5411Minimum Order QuantityDecimalnew in 18
5412Maximum Order QuantityDecimalnew in 18
5413Safety Stock QuantityDecimalnew in 18
5414Order MultipleDecimalnew in 18
5415Safety Lead TimeDateFormulanew in 18
5417Flushing MethodEnum "Flushing Method"18-25, 27-29
5419Replenishment SystemEnum "Replenishment System"new in 18
5422Rounding PrecisionDecimalnew in 19
5428Time BucketDateFormulanew in 18
5440Reordering PolicyEnum "Reordering Policy"new in 18
5441Include InventoryBooleannew in 18
5442Manufacturing PolicyEnum "Manufacturing Policy"new in 18
5443Rescheduling PeriodDateFormulanew in 18
5444Lot Accumulation PeriodDateFormulanew in 18
5445Dampener PeriodDateFormulanew in 18
5446Dampener QuantityDecimalnew in 18
5447Overflow LevelDecimalnew in 18
5701Manufacturer CodeCode[10]new in 18
5702Item Category CodeCode[20]17-29
5711Purchasing CodeCode[10]new in 18
5900Service Item GroupCode[10]gone after 24
6500Item Tracking CodeCode[10]new in 18
6501Lot Nos.Code[20]new in 18
6502Expiration CalculationDateFormulanew in 18
7300Warehouse Class CodeCode[10]17-29
7301Special Equipment CodeCode[10]new in 18
7302Put-away Template CodeCode[10]new in 18
7380Phys Invt Counting Period CodeCode[10]new in 18
7384Use Cross-DockingBooleannew in 18
8003Sales BlockedBoolean17-29
8004Purchasing BlockedBoolean17-29
8010Service BlockedBooleannew in 24
8510Over-Receipt CodeCode[20]new in 18
99000750Routing No.Code[20]18 to 25
99000751Production BOM No.Code[20]18 to 25
99000757Overhead RateDecimalnew in 18
99000773Order Tracking PolicyEnum "Order Tracking Policy"18-25, 27-29
99000875CriticalBoolean18-25, 27-29
99008500Common Item No.Code[20]18-25, 27-29