Item Templ. #1382

Other table in Microsoft Dynamics 365 Business Central. 116 fields, 3 records in Cronus demo.

116

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Code.

All fields (116)

Item Templ. — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Code PK	Code	Normal
2	Description	Text	Normal
8	Base Unit of Measure	Code	Normal	→ Unit of Measure #204
9	Price Unit Conversion	Integer	Normal
10	Type	Option	Normal
11	Inventory Posting Group	Code	Normal	→ Inventory Posting Group #94
12	Shelf No.	Code	Normal
14	Item Disc. Group	Code	Normal	→ Item Discount Group #341
15	Allow Invoice Disc.	Boolean	Normal
16	Statistics Group	Integer	Normal
17	Commission Group	Integer	Normal
18	Unit Price	Decimal	Normal
19	Price/Profit Calculation	Option	Normal
20	Profit %	Decimal	Normal
21	Costing Method	Option	Normal
22	Unit Cost	Decimal	Normal
24	Standard Cost	Decimal	Normal
28	Indirect Cost %	Decimal	Normal
31	Vendor No.	Code	Normal	→ Vendor #23
32	Vendor Item No.	Text	Normal
33	Lead Time Calculation	DateFormula	Normal
34	Reorder Point	Decimal	Normal
35	Maximum Inventory	Decimal	Normal
36	Reorder Quantity	Decimal	Normal
37	Alternative Item No.	Code	Normal	→ Item #27
38	Unit List Price	Decimal	Normal
39	Duty Due %	Decimal	Normal
40	Duty Code	Code	Normal
41	Gross Weight	Decimal	Normal
42	Net Weight	Decimal	Normal
43	Units per Parcel	Decimal	Normal
44	Unit Volume	Decimal	Normal
45	Durability	Code	Normal
46	Freight Type	Code	Normal
47	Tariff No.	Code	Normal	→ Tariff Number #260
48	Duty Unit Conversion	Decimal	Normal
49	Country/Region Purchased Code	Code	Normal	→ Country/Region #9
50	Budget Quantity	Decimal	Normal
51	Budgeted Amount	Decimal	Normal
52	Budget Profit	Decimal	Normal
54	Blocked	Boolean	Normal
56	Block Reason	Text	Normal
87	Price Includes VAT	Boolean	Normal
90	VAT Bus. Posting Gr. (Price)	Code	Normal	→ VAT Business Posting Group #323
91	Gen. Prod. Posting Group	Code	Normal	→ Gen. Product Posting Group #251
95	Country/Region of Origin Code	Code	Normal	→ Country/Region #9
96	Automatic Ext. Texts	Boolean	Normal
97	No. Series	Code	Normal	→ No. Series #308
98	Tax Group Code	Code	Normal	→ Tax Group #321
99	VAT Prod. Posting Group	Code	Normal	→ VAT Product Posting Group #324
100	Reserve	Option	Normal
105	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
106	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
120	Stockout Warning	Option	Normal
121	Prevent Negative Inventory	Option	Normal
122	Variant Mandatory if Exists	Option	Normal
910	Assembly Policy	Option	Normal
1217	GTIN	Code	Normal
1700	Default Deferral Template Code	Code	Normal	→ Deferral Template #1700
4810	Exclude from Intrastat Report	Boolean	Normal
5401	Lot Size	Decimal	Normal
5402	Serial Nos.	Code	Normal	→ No. Series #308
5407	Scrap %	Decimal	Normal
5408	Rolled-up Material Non-Inventory Cost	Decimal	Normal
5409	Inventory Value Zero	Boolean	Normal
5410	Discrete Order Quantity	Integer	Normal
5411	Minimum Order Quantity	Decimal	Normal
5412	Maximum Order Quantity	Decimal	Normal
5413	Safety Stock Quantity	Decimal	Normal
5414	Order Multiple	Decimal	Normal
5415	Safety Lead Time	DateFormula	Normal
5417	Flushing Method	Option	Normal
5419	Replenishment System	Option	Normal
5422	Rounding Precision	Decimal	Normal
5428	Time Bucket	DateFormula	Normal
5440	Reordering Policy	Option	Normal
5441	Include Inventory	Boolean	Normal
5442	Manufacturing Policy	Option	Normal
5443	Rescheduling Period	DateFormula	Normal
5444	Lot Accumulation Period	DateFormula	Normal
5445	Dampener Period	DateFormula	Normal
5446	Dampener Quantity	Decimal	Normal
5447	Overflow Level	Decimal	Normal
5701	Manufacturer Code	Code	Normal	→ Manufacturer #5720
5702	Item Category Code	Code	Normal	→ Item Category #5722
5711	Purchasing Code	Code	Normal	→ Purchasing #5721
5900	Service Item Group	Code	Normal	→ Service Item Group #5904
6500	Item Tracking Code	Code	Normal	→ Item Tracking Code #6502
6501	Lot Nos.	Code	Normal	→ No. Series #308
6502	Expiration Calculation	DateFormula	Normal
7300	Warehouse Class Code	Code	Normal	→ Warehouse Class #7304
7301	Special Equipment Code	Code	Normal	→ Special Equipment #7305
7302	Put-away Template Code	Code	Normal	→ Put-away Template Header #7307
7380	Phys Invt Counting Period Code	Code	Normal	→ Phys. Invt. Counting Period #7381
7384	Use Cross-Docking	Boolean	Normal
8003	Sales Blocked	Boolean	Normal
8004	Purchasing Blocked	Boolean	Normal
8010	Service Blocked	Boolean	Normal
8011	Production Blocked	Option	Normal
8052	Subscription Option	Option	Normal
8510	Over-Receipt Code	Code	Normal	→ Over-Receipt Code #8510
10500	Reverse Charge Applies	Boolean	Normal
10507	Reverse Charge Applies	Boolean	Normal
99000750	Routing No.	Code	Normal	→ Routing Header #99000763
99000751	Production BOM No.	Code	Normal	→ Production BOM Header #99000771
99000757	Overhead Rate	Decimal	Normal
99000773	Order Tracking Policy	Option	Normal
99000779	Single-Level Material Non-Inventory Cost	Decimal	Normal
99000780	Allow Whse. Overpick	Boolean	Normal
99000875	Critical	Boolean	Normal
99008500	Common Item No.	Code	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal