Item Templ. – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IItem Templ.

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/1382

Table Type: Company

Table Name: Item Templ.
Database Table Name: CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 1382

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Item Templ. can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Description]
   ,[Base Unit of Measure]
   ,[Price Unit Conversion]
   ,[Type]
   ,[Inventory Posting Group]
   ,[Shelf No_]
   ,[Item Disc_ Group]
   ,[Allow Invoice Disc_]
   ,[Statistics Group]
   ,[Commission Group]
   ,[Unit Price]
   ,[Price_Profit Calculation]
   ,[Profit _]
   ,[Costing Method]
   ,[Unit Cost]
   ,[Standard Cost]
   ,[Indirect Cost _]
   ,[Vendor No_]
   ,[Vendor Item No_]
   ,[Lead Time Calculation]
   ,[Reorder Point]
   ,[Maximum Inventory]
   ,[Reorder Quantity]
   ,[Alternative Item No_]
   ,[Unit List Price]
   ,[Duty Due _]
   ,[Duty Code]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Durability]
   ,[Freight Type]
   ,[Tariff No_]
   ,[Duty Unit Conversion]
   ,[Country_Region Purchased Code]
   ,[Budget Quantity]
   ,[Budgeted Amount]
   ,[Budget Profit]
   ,[Blocked]
   ,[Block Reason]
   ,[Price Includes VAT]
   ,[VAT Bus_ Posting Gr_ (Price)]
   ,[Gen_ Prod_ Posting Group]
   ,[Country_Region of Origin Code]
   ,[Automatic Ext_ Texts]
   ,[No_ Series]
   ,[Tax Group Code]
   ,[VAT Prod_ Posting Group]
   ,[Reserve]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Stockout Warning]
   ,[Prevent Negative Inventory]
   ,[Variant Mandatory if Exists]
   ,[Assembly Policy]
   ,[GTIN]
   ,[Default Deferral Template Code]
   ,[Lot Size]
   ,[Serial Nos_]
   ,[Scrap _]
   ,[Inventory Value Zero]
   ,[Discrete Order Quantity]
   ,[Minimum Order Quantity]
   ,[Maximum Order Quantity]
   ,[Safety Stock Quantity]
   ,[Order Multiple]
   ,[Safety Lead Time]
   ,[Flushing Method]
   ,[Rounding Precision]
   ,[Time Bucket]
   ,[Reordering Policy]
   ,[Include Inventory]
   ,[Manufacturing Policy]
   ,[Rescheduling Period]
   ,[Lot Accumulation Period]
   ,[Dampener Period]
   ,[Dampener Quantity]
   ,[Overflow Level]
   ,[Manufacturer Code]
   ,[Item Category Code]
   ,[Purchasing Code]
   ,[Service Item Group]
   ,[Item Tracking Code]
   ,[Lot Nos_]
   ,[Expiration Calculation]
   ,[Warehouse Class Code]
   ,[Special Equipment Code]
   ,[Put-away Template Code]
   ,[Phys Invt Counting Period Code]
   ,[Use Cross-Docking]
   ,[Sales Blocked]
   ,[Purchasing Blocked]
   ,[Over-Receipt Code]
   ,[Routing No_]
   ,[Production BOM No_]
   ,[Overhead Rate]
   ,[Order Tracking Policy]
   ,[Critical]
   ,[Common Item No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Item Templ.].[Base Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group]
      ON
         [Item Templ.].[Inventory Posting Group] = [Inventory Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Item Templ.].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Templ.].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Item Templ.].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
      ON
         [Item Templ.].[Default Deferral Template Code] = [Deferral Template].[Deferral Code]
LEFT JOIN
   [CRONUS UK Ltd_$Manufacturer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturer]
      ON
         [Item Templ.].[Manufacturer Code] = [Manufacturer].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Item Templ.].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Item Templ.].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
      ON
         [Item Templ.].[Service Item Group] = [Service Item Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Tracking Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracking Code]
      ON
         [Item Templ.].[Item Tracking Code] = [Item Tracking Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
      ON
         [Item Templ.].[Warehouse Class Code] = [Warehouse Class].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment]
      ON
         [Item Templ.].[Special Equipment Code] = [Special Equipment].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Put-away Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Header]
      ON
         [Item Templ.].[Put-away Template Code] = [Put-away Template Header].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period]
      ON
         [Item Templ.].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code]
      ON
         [Item Templ.].[Over-Receipt Code] = [Over-Receipt Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Templ.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Item Templ.].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Item Templ. table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
2	Description	Description	Normal	Text	100	Description	nvarchar(200)
8	Base Unit of Measure	Base Unit of Measure	Normal	Code	10	Base Unit of Measure	nvarchar(20)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Item Templ.].[Base Unit of Measure] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Item Templ.].[Base Unit of Measure] = [Unit of Measure].[Code]
9	Price Unit Conversion	Price Unit Conversion	Normal	Integer	4	Price Unit Conversion	int
10	Type	Type	Normal	Option	4	Type	int
	Available options are: “Inventory” “Service” “Non-Inventory”
11	Inventory Posting Group	Inventory Posting Group	Normal	Code	20	Inventory Posting Group	nvarchar(40)
	Key to join to the Inventory Posting Group table. Show/hide example query SELECT [Item Templ.].[Inventory Posting Group] ,[Inventory Posting Group].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Inventory Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Posting Group] ON [Item Templ.].[Inventory Posting Group] = [Inventory Posting Group].[Code]
12	Shelf No.	Shelf No.	Normal	Code	10	Shelf No_	nvarchar(20)
14	Item Disc. Group	Item Disc. Group	Normal	Code	20	Item Disc_ Group	nvarchar(40)
	Key to join to the Item Discount Group table. Show/hide example query SELECT [Item Templ.].[Item Disc_ Group] ,[Item Discount Group].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Item Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Discount Group] ON [Item Templ.].[Item Disc_ Group] = [Item Discount Group].[Code]
15	Allow Invoice Disc.	Allow Invoice Disc.	Normal	Boolean	4	Allow Invoice Disc_	tinyint
16	Statistics Group	Statistics Group	Normal	Integer	4	Statistics Group	int
17	Commission Group	Commission Group	Normal	Integer	4	Commission Group	int
18	Unit Price	Unit Price	Normal	Decimal	12	Unit Price	decimal(38,38)
19	Price/Profit Calculation	Price/Profit Calculation	Normal	Option	4	Price_Profit Calculation	int
20	Profit %	Profit %	Normal	Decimal	12	Profit _	decimal(38,38)
21	Costing Method	Costing Method	Normal	Option	4	Costing Method	int
	Available options are: “FIFO” “LIFO” “Specific” “Average” “Standard”
22	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
24	Standard Cost	Standard Cost	Normal	Decimal	12	Standard Cost	decimal(38,38)
28	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
31	Vendor No.	Vendor No.	Normal	Code	20	Vendor No_	nvarchar(40)
	Key to join to the Vendor table. Show/hide example query SELECT [Item Templ.].[Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Item Templ.].[Vendor No_] = [Vendor].[No_]
32	Vendor Item No.	Vendor Item No.	Normal	Text	50	Vendor Item No_	nvarchar(100)
33	Lead Time Calculation	Lead Time Calculation	Normal	DateFormula	32	Lead Time Calculation	varchar(32)
34	Reorder Point	Reorder Point	Normal	Decimal	12	Reorder Point	decimal(38,38)
35	Maximum Inventory	Maximum Inventory	Normal	Decimal	12	Maximum Inventory	decimal(38,38)
36	Reorder Quantity	Reorder Quantity	Normal	Decimal	12	Reorder Quantity	decimal(38,38)
37	Alternative Item No.	Alternative Item No.	Normal	Code	20	Alternative Item No_	nvarchar(40)
	Key to join to the Item table. Show/hide example query SELECT [Item Templ.].[Alternative Item No_] ,[Item].[No_] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item] ON [Item Templ.].[Alternative Item No_] = [Item].[No_]
38	Unit List Price	Unit List Price	Normal	Decimal	12	Unit List Price	decimal(38,38)
39	Duty Due %	Duty Due %	Normal	Decimal	12	Duty Due _	decimal(38,38)
40	Duty Code	Duty Code	Normal	Code	10	Duty Code	nvarchar(20)
41	Gross Weight	Gross Weight	Normal	Decimal	12	Gross Weight	decimal(38,38)
42	Net Weight	Net Weight	Normal	Decimal	12	Net Weight	decimal(38,38)
43	Units per Parcel	Units per Parcel	Normal	Decimal	12	Units per Parcel	decimal(38,38)
44	Unit Volume	Unit Volume	Normal	Decimal	12	Unit Volume	decimal(38,38)
45	Durability	Durability	Normal	Code	10	Durability	nvarchar(20)
46	Freight Type	Freight Type	Normal	Code	10	Freight Type	nvarchar(20)
47	Tariff No.	Tariff No.	Normal	Code	20	Tariff No_	nvarchar(40)
	Key to join to the Tariff Number table. Show/hide example query SELECT [Item Templ.].[Tariff No_] ,[Tariff Number].[No_] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Tariff Number$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tariff Number] ON [Item Templ.].[Tariff No_] = [Tariff Number].[No_]
48	Duty Unit Conversion	Duty Unit Conversion	Normal	Decimal	12	Duty Unit Conversion	decimal(38,38)
49	Country/Region Purchased Code	Country/Region Purchased Code	Normal	Code	10	Country_Region Purchased Code	nvarchar(20)
50	Budget Quantity	Budget Quantity	Normal	Decimal	12	Budget Quantity	decimal(38,38)
51	Budgeted Amount	Budgeted Amount	Normal	Decimal	12	Budgeted Amount	decimal(38,38)
52	Budget Profit	Budget Profit	Normal	Decimal	12	Budget Profit	decimal(38,38)
54	Blocked	Blocked	Normal	Boolean	4	Blocked	tinyint
56	Block Reason	Block Reason	Normal	Text	250	Block Reason	nvarchar(500)
87	Price Includes VAT	Price Includes Tax	Normal	Boolean	4	Price Includes VAT	tinyint
90	VAT Bus. Posting Gr. (Price)	VAT Bus. Posting Gr. (Price)	Normal	Code	20	VAT Bus_ Posting Gr_ (Price)	nvarchar(40)
	Key to join to the VAT Business Posting Group table. Show/hide example query SELECT [Item Templ.].[VAT Bus_ Posting Gr_ (Price)] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Item Templ.].[VAT Bus_ Posting Gr_ (Price)] = [VAT Business Posting Group].[Code]
91	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(40)
	Key to join to the Gen. Product Posting Group table. Show/hide example query SELECT [Item Templ.].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Item Templ.].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
95	Country/Region of Origin Code	Country/Region of Origin Code	Normal	Code	10	Country_Region of Origin Code	nvarchar(20)
96	Automatic Ext. Texts	Automatic Ext. Text	Normal	Boolean	4	Automatic Ext_ Texts	tinyint
97	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Item Templ.].[No_ Series] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Item Templ.].[No_ Series] = [No. Series].[Code]
98	Tax Group Code	Tax Group Code	Normal	Code	20	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Item Templ.].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Item Templ.].[Tax Group Code] = [Tax Group].[Code]
99	VAT Prod. Posting Group	VAT Prod. Posting Group	Normal	Code	20	VAT Prod_ Posting Group	nvarchar(40)
	Key to join to the VAT Product Posting Group table. Show/hide example query SELECT [Item Templ.].[VAT Prod_ Posting Group] ,[VAT Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group] ON [Item Templ.].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
100	Reserve	Reserve	Normal	Option	4	Reserve	int
	Available options are: “Never” “Optional” “Always”
105	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Item Templ.].[Global Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Item Templ.].[Global Dimension 1 Code] = [Dimension].[Code]
106	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(40)
	Key to join to the Dimension table. Show/hide example query SELECT [Item Templ.].[Global Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Item Templ.].[Global Dimension 2 Code] = [Dimension].[Code]
120	Stockout Warning	Stockout Warning	Normal	Option	4	Stockout Warning	int
	Available options are: “Default” “No” “Yes”
121	Prevent Negative Inventory	Prevent Negative Inventory	Normal	Option	4	Prevent Negative Inventory	int
	Available options are: “Default” “No” “Yes”
122	Variant Mandatory if Exists	Variant Mandatory if Exists	Normal	Option	4	Variant Mandatory if Exists	int
	Available options are: “Default” “No” “Yes”
910	Assembly Policy	Assembly Policy	Normal	Option	4	Assembly Policy	int
	Available options are: “Assemble-to-Stock” “Assemble-to-Order”
1217	GTIN	GTIN	Normal	Code	14	GTIN	nvarchar(28)
1700	Default Deferral Template Code	Default Deferral Template Code	Normal	Code	10	Default Deferral Template Code	nvarchar(20)
	Key to join to the Deferral Template table. Show/hide example query SELECT [Item Templ.].[Default Deferral Template Code] ,[Deferral Template].[Deferral Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template] ON [Item Templ.].[Default Deferral Template Code] = [Deferral Template].[Deferral Code]
5401	Lot Size	Lot Size	Normal	Decimal	12	Lot Size	decimal(38,38)
5402	Serial Nos.	Serial Nos.	Normal	Code	20	Serial Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Item Templ.].[Serial Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Item Templ.].[Serial Nos_] = [No. Series].[Code]
5407	Scrap %	Scrap %	Normal	Decimal	12	Scrap _	decimal(38,38)
5409	Inventory Value Zero	Inventory Value Zero	Normal	Boolean	4	Inventory Value Zero	tinyint
5410	Discrete Order Quantity	Discrete Order Quantity	Normal	Integer	4	Discrete Order Quantity	int
5411	Minimum Order Quantity	Minimum Order Quantity	Normal	Decimal	12	Minimum Order Quantity	decimal(38,38)
5412	Maximum Order Quantity	Maximum Order Quantity	Normal	Decimal	12	Maximum Order Quantity	decimal(38,38)
5413	Safety Stock Quantity	Safety Stock Quantity	Normal	Decimal	12	Safety Stock Quantity	decimal(38,38)
5414	Order Multiple	Order Multiple	Normal	Decimal	12	Order Multiple	decimal(38,38)
5415	Safety Lead Time	Safety Lead Time	Normal	DateFormula	32	Safety Lead Time	varchar(32)
5417	Flushing Method	Flushing Method	Normal	Option	4	Flushing Method	int
	Available options are: “Manual” “Forward” “Backward” “Pick + Forward” “Pick + Backward”
5419	Replenishment System	Replenishment System	Normal	Option	4
5422	Rounding Precision	Rounding Precision	Normal	Decimal	12	Rounding Precision	decimal(38,38)
5428	Time Bucket	Time Bucket	Normal	DateFormula	32	Time Bucket	varchar(32)
5440	Reordering Policy	Reordering Policy	Normal	Option	4	Reordering Policy	int
	Available options are: ” “ “Fixed Reorder Qty.” “Maximum Qty.” “Order” “Lot-for-Lot”
5441	Include Inventory	Include Inventory	Normal	Boolean	4	Include Inventory	tinyint
5442	Manufacturing Policy	Manufacturing Policy	Normal	Option	4	Manufacturing Policy	int
	Available options are: “Make-to-Stock” “Make-to-Order”
5443	Rescheduling Period	Rescheduling Period	Normal	DateFormula	32	Rescheduling Period	varchar(32)
5444	Lot Accumulation Period	Lot Accumulation Period	Normal	DateFormula	32	Lot Accumulation Period	varchar(32)
5445	Dampener Period	Dampener Period	Normal	DateFormula	32	Dampener Period	varchar(32)
5446	Dampener Quantity	Dampener Quantity	Normal	Decimal	12	Dampener Quantity	decimal(38,38)
5447	Overflow Level	Overflow Level	Normal	Decimal	12	Overflow Level	decimal(38,38)
5701	Manufacturer Code	Manufacturer Code	Normal	Code	10	Manufacturer Code	nvarchar(20)
	Key to join to the Manufacturer table. Show/hide example query SELECT [Item Templ.].[Manufacturer Code] ,[Manufacturer].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Manufacturer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Manufacturer] ON [Item Templ.].[Manufacturer Code] = [Manufacturer].[Code]
5702	Item Category Code	Item Category Code	Normal	Code	20	Item Category Code	nvarchar(40)
	Key to join to the Item Category table. Show/hide example query SELECT [Item Templ.].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Item Templ.].[Item Category Code] = [Item Category].[Code]
5711	Purchasing Code	Purchasing Code	Normal	Code	10	Purchasing Code	nvarchar(20)
	Key to join to the Purchasing table. Show/hide example query SELECT [Item Templ.].[Purchasing Code] ,[Purchasing].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing] ON [Item Templ.].[Purchasing Code] = [Purchasing].[Code]
5900	Service Item Group	Service Item Group	Normal	Code	10	Service Item Group	nvarchar(20)
	Key to join to the Service Item Group table. Show/hide example query SELECT [Item Templ.].[Service Item Group] ,[Service Item Group].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group] ON [Item Templ.].[Service Item Group] = [Service Item Group].[Code]
6500	Item Tracking Code	Item Tracking Code	Normal	Code	10	Item Tracking Code	nvarchar(20)
	Key to join to the Item Tracking Code table. Show/hide example query SELECT [Item Templ.].[Item Tracking Code] ,[Item Tracking Code].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Item Tracking Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Tracking Code] ON [Item Templ.].[Item Tracking Code] = [Item Tracking Code].[Code]
6501	Lot Nos.	Lot Nos.	Normal	Code	20	Lot Nos_	nvarchar(40)
	Key to join to the No. Series table. Show/hide example query SELECT [Item Templ.].[Lot Nos_] ,[No. Series].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series] ON [Item Templ.].[Lot Nos_] = [No. Series].[Code]
6502	Expiration Calculation	Expiration Calculation	Normal	DateFormula	32	Expiration Calculation	varchar(32)
7300	Warehouse Class Code	Warehouse Class Code	Normal	Code	10	Warehouse Class Code	nvarchar(20)
	Key to join to the Warehouse Class table. Show/hide example query SELECT [Item Templ.].[Warehouse Class Code] ,[Warehouse Class].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class] ON [Item Templ.].[Warehouse Class Code] = [Warehouse Class].[Code]
7301	Special Equipment Code	Special Equipment Code	Normal	Code	10	Special Equipment Code	nvarchar(20)
	Key to join to the Special Equipment table. Show/hide example query SELECT [Item Templ.].[Special Equipment Code] ,[Special Equipment].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Special Equipment$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Special Equipment] ON [Item Templ.].[Special Equipment Code] = [Special Equipment].[Code]
7302	Put-away Template Code	Put-away Template Code	Normal	Code	10	Put-away Template Code	nvarchar(20)
	Key to join to the Put-away Template Header table. Show/hide example query SELECT [Item Templ.].[Put-away Template Code] ,[Put-away Template Header].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Put-away Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Header] ON [Item Templ.].[Put-away Template Code] = [Put-away Template Header].[Code]
7380	Phys Invt Counting Period Code	Phys Invt Counting Period Code	Normal	Code	10	Phys Invt Counting Period Code	nvarchar(20)
	Key to join to the Phys. Invt. Counting Period table. Show/hide example query SELECT [Item Templ.].[Phys Invt Counting Period Code] ,[Phys. Invt. Counting Period].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Phys_ Invt_ Counting Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Phys. Invt. Counting Period] ON [Item Templ.].[Phys Invt Counting Period Code] = [Phys. Invt. Counting Period].[Code]
7384	Use Cross-Docking	Use Cross-Docking	Normal	Boolean	4	Use Cross-Docking	tinyint
8003	Sales Blocked	Sales Blocked	Normal	Boolean	4	Sales Blocked	tinyint
8004	Purchasing Blocked	Purchasing Blocked	Normal	Boolean	4	Purchasing Blocked	tinyint
8510	Over-Receipt Code	Over-Receipt Code	Normal	Code	20	Over-Receipt Code	nvarchar(40)
	Key to join to the Over-Receipt Code table. Show/hide example query SELECT [Item Templ.].[Over-Receipt Code] ,[Over-Receipt Code].[Code] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code] ON [Item Templ.].[Over-Receipt Code] = [Over-Receipt Code].[Code]
10004	Duty Class	Duty Class	Normal	Code	10
27000	SAT Item Classification	SAT Item Classification	Normal	Code	10
27024	SAT Hazardous Material	SAT Hazardous Material	Normal	Code	10
27025	SAT Packaging Type	SAT Packaging Type	Normal	Code	10
99000750	Routing No.	Routing No.	Normal	Code	20	Routing No_	nvarchar(40)
	Key to join to the Routing Header table. Show/hide example query SELECT [Item Templ.].[Routing No_] ,[Routing Header].[No_] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header] ON [Item Templ.].[Routing No_] = [Routing Header].[No_]
99000751	Production BOM No.	Production BOM No.	Normal	Code	20	Production BOM No_	nvarchar(40)
	Key to join to the Production BOM Header table. Show/hide example query SELECT [Item Templ.].[Production BOM No_] ,[Production BOM Header].[No_] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header] ON [Item Templ.].[Production BOM No_] = [Production BOM Header].[No_] Part of multi-key to join to the Production BOM Line table. Show/hide example query SELECT [Item Templ.].[Production BOM No_] ,[Production BOM Line].[Line No_] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line] ON [Item Templ.].[Production BOM No_] = [Production BOM Line].[Line No_] Part of multi-key to join to the Production BOM Line table. Show/hide example query SELECT [Item Templ.].[Production BOM No_] ,[Production BOM Line].[Production BOM No_] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line] ON [Item Templ.].[Production BOM No_] = [Production BOM Line].[Production BOM No_]
99000757	Overhead Rate	Overhead Rate	Normal	Decimal	12	Overhead Rate	decimal(38,38)
99000773	Order Tracking Policy	Order Tracking Policy	Normal	Option	4	Order Tracking Policy	int
	Available options are: “None” “Tracking Only” “Tracking & Action Msg.”
99000875	Critical	Critical	Normal	Boolean	4	Critical	tinyint
99008500	Common Item No.	Common Item No.	Normal	Code	20	Common Item No_	nvarchar(40)
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Item Templ.].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ.] LEFT JOIN [User] AS [User] ON [Item Templ.].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Item Templ. table

Item Category Item Tracking Code Put-away Template Header Service Item Group Special Equipment Tax Group Warehouse Class

Dynamics 365 BC Table Reference Tables Company Tables IItem Templ.

Leave a Reply Cancel reply