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
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
[timestamp]
,[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]
,[Assembly Policy]
,[GTIN]
,[Default Deferral Template Code]
,[Lot Size]
,[Serial Nos_]
,[Scrap _]
,[Discrete Order Quantity]
,[Minimum Order Quantity]
,[Maximum Order Quantity]
,[Safety Stock Quantity]
,[Order Multiple]
,[Safety Lead Time]
,[Flushing Method]
,[Replenishment System]
,[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]
,[Expiration Calculation]
,[Item Tracking Code]
,[Lot Nos_]
,[Special Equipment Code]
,[Put-away Template Code]
,[Warehouse Class 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_]
,[Reverse Charge Applies]
,[$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_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
ON
[Item Templ_].[Vendor No_] = [Vendor].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Item Templ_].[Country_Region Purchased Code] = [Country_Region].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Item Templ_].[Country_Region of Origin Code] = [Country_Region].[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_$Manufacturer] AS [Manufactuer]
ON
[Item Templ_].[Manufacturer Code] = [Manufactuer].[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_$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_$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_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
ON
[Item Templ_].[Warehouse Class Code] = [Warehouse Class].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
ON
[Item Templ_].[BOM Line No_] = [Production BOM Line].[Line No_]
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_]
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_]Show/hide columns in Item Templ_ table
| Column ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Code  | nvarchar(40) | ||||
| 3 | Description | nvarchar(200) | ||||
| 4 | Base Unit of Measure | nvarchar(20) | ||||
| 5 | Price Unit Conversion | int | ||||
| 6 | Type | int | ||||
| 7 | Inventory Posting Group | nvarchar(40) | ||||
| 8 | Shelf No_ | nvarchar(20) | ||||
| 9 | Item Disc_ Group | nvarchar(40) | ||||
| 10 | Allow Invoice Disc_ | tinyint | ||||
| 11 | Statistics Group | int | ||||
| 12 | Commission Group | int | ||||
| 13 | Unit Price | decimal(38,38) | ||||
| 14 | Price_Profit Calculation | int | ||||
| 15 | Profit _ | decimal(38,38) | ||||
| 16 | Costing Method | int | ||||
| 17 | Unit Cost | decimal(38,38) | ||||
| 18 | Standard Cost | decimal(38,38) | ||||
| 19 | Indirect Cost _ | decimal(38,38) | ||||
| 20 | Vendor No_ | nvarchar(40) | ||||
Key to join to the Vendor table.Show/hide example querySELECT
[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_] | ||||||
| 21 | Vendor Item No_ | nvarchar(100) | ||||
| 22 | Lead Time Calculation | varchar(32) | ||||
| 23 | Reorder Point | decimal(38,38) | ||||
| 24 | Maximum Inventory | decimal(38,38) | ||||
| 25 | Reorder Quantity | decimal(38,38) | ||||
| 26 | Alternative Item No_ | nvarchar(40) | ||||
| 27 | Unit List Price | decimal(38,38) | ||||
| 28 | Duty Due _ | decimal(38,38) | ||||
| 29 | Duty Code | nvarchar(20) | ||||
| 30 | Gross Weight | decimal(38,38) | ||||
| 31 | Net Weight | decimal(38,38) | ||||
| 32 | Units per Parcel | decimal(38,38) | ||||
| 33 | Unit Volume | decimal(38,38) | ||||
| 34 | Durability | nvarchar(20) | ||||
| 35 | Freight Type | nvarchar(20) | ||||
| 36 | Tariff No_ | nvarchar(40) | ||||
| 37 | Duty Unit Conversion | decimal(38,38) | ||||
| 38 | Country_Region Purchased Code | nvarchar(20) | ||||
Key to join to the Country_Region table.Show/hide example querySELECT
[Item Templ_].[Country_Region Purchased Code]
,[Country_Region].[Code]
FROM
[CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ_]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Item Templ_].[Country_Region Purchased Code] = [Country_Region].[Code] | ||||||
| 39 | Budget Quantity | decimal(38,38) | ||||
| 40 | Budgeted Amount | decimal(38,38) | ||||
| 41 | Budget Profit | decimal(38,38) | ||||
| 42 | Blocked | tinyint | ||||
| 43 | Block Reason | nvarchar(500) | ||||
| 44 | Price Includes VAT | tinyint | ||||
| 45 | VAT Bus_ Posting Gr_ (Price) | nvarchar(40) | ||||
| 46 | Gen_ Prod_ Posting Group | nvarchar(40) | ||||
| 47 | Country_Region of Origin Code | nvarchar(20) | ||||
Key to join to the Country_Region table.Show/hide example querySELECT
[Item Templ_].[Country_Region of Origin Code]
,[Country_Region].[Code]
FROM
[CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ_]
LEFT JOIN
[CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
ON
[Item Templ_].[Country_Region of Origin Code] = [Country_Region].[Code] | ||||||
| 48 | Automatic Ext_ Texts | tinyint | ||||
| 49 | No_ Series | nvarchar(40) | ||||
| 50 | Tax Group Code | nvarchar(40) | ||||
Key to join to the Tax Group table.Show/hide example querySELECT
[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] | ||||||
| 51 | VAT Prod_ Posting Group | nvarchar(40) | ||||
| 52 | Reserve | int | ||||
| 53 | Global Dimension 1 Code | nvarchar(40) | ||||
| 54 | Global Dimension 2 Code | nvarchar(40) | ||||
| 55 | Stockout Warning | int | ||||
| 56 | Prevent Negative Inventory | int | ||||
| 57 | Assembly Policy | int | ||||
| 58 | GTIN | nvarchar(28) | ||||
| 59 | Default Deferral Template Code | nvarchar(20) | ||||
| 60 | Lot Size | decimal(38,38) | ||||
| 61 | Serial Nos_ | nvarchar(40) | ||||
| 62 | Scrap _ | decimal(38,38) | ||||
| 63 | Discrete Order Quantity | int | ||||
| 64 | Minimum Order Quantity | decimal(38,38) | ||||
| 65 | Maximum Order Quantity | decimal(38,38) | ||||
| 66 | Safety Stock Quantity | decimal(38,38) | ||||
| 67 | Order Multiple | decimal(38,38) | ||||
| 68 | Safety Lead Time | varchar(32) | ||||
| 69 | Flushing Method | int | ||||
| 70 | Replenishment System | int | ||||
| 71 | Rounding Precision | decimal(38,38) | ||||
| 72 | Time Bucket | varchar(32) | ||||
| 73 | Reordering Policy | int | ||||
| 74 | Include Inventory | tinyint | ||||
| 75 | Manufacturing Policy | int | ||||
| 76 | Rescheduling Period | varchar(32) | ||||
| 77 | Lot Accumulation Period | varchar(32) | ||||
| 78 | Dampener Period | varchar(32) | ||||
| 79 | Dampener Quantity | decimal(38,38) | ||||
| 80 | Overflow Level | decimal(38,38) | ||||
| 81 | Manufacturer Code | nvarchar(20) | ||||
Key to join to the Manufactuer table.Show/hide example querySELECT
[Item Templ_].[Manufacturer Code]
,[Manufactuer].[Code]
FROM
[CRONUS UK Ltd_$Item Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Templ_]
LEFT JOIN
[CRONUS UK Ltd_$Manufacturer] AS [Manufactuer]
ON
[Item Templ_].[Manufacturer Code] = [Manufactuer].[Code] | ||||||
| 82 | Item Category Code | nvarchar(40) | ||||
Key to join to the Item Category table.Show/hide example querySELECT
[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] | ||||||
| 83 | Purchasing Code | nvarchar(20) | ||||
| 84 | Service Item Group | nvarchar(20) | ||||
Key to join to the Service Item Group table.Show/hide example querySELECT
[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] | ||||||
| 85 | Expiration Calculation | varchar(32) | ||||
| 86 | Item Tracking Code | nvarchar(20) | ||||
Key to join to the Item Tracking Code table.Show/hide example querySELECT
[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] | ||||||
| 87 | Lot Nos_ | nvarchar(40) | ||||
| 88 | Special Equipment Code | nvarchar(20) | ||||
Key to join to the Special Equipment table.Show/hide example querySELECT
[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] | ||||||
| 89 | Put-away Template Code | nvarchar(20) | ||||
Key to join to the Put-away Template Header table.Show/hide example querySELECT
[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] | ||||||
| 90 | Warehouse Class Code | nvarchar(20) | ||||
Key to join to the Warehouse Class table.Show/hide example querySELECT
[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] | ||||||
| 91 | Phys Invt Counting Period Code | nvarchar(20) | ||||
| 92 | Use Cross-Docking | tinyint | ||||
| 93 | Sales Blocked | tinyint | ||||
| 94 | Purchasing Blocked | tinyint | ||||
| 95 | Over-Receipt Code | nvarchar(40) | ||||
| 96 | Routing No_ | nvarchar(40) | ||||
| 97 | Production BOM No_ | nvarchar(40) | ||||
Key to join to the Production BOM Header table.Show/hide example querySELECT
[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_]Show/hide example querySELECT
[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_]
AND
[Item Templ_].[BOM Line No_] = [Production BOM Line].[Line No_] | ||||||
| 98 | Overhead Rate | decimal(38,38) | ||||
| 99 | Order Tracking Policy | int | ||||
| 100 | Critical | tinyint | ||||
| 101 | Common Item No_ | nvarchar(40) | ||||
| 102 | Reverse Charge Applies | tinyint | ||||
| 103 | $systemId | uniqueidentifier | ||||
| 104 | $systemCreatedAt | datetime | ||||
| 105 | $systemCreatedBy | uniqueidentifier | ||||
| 106 | $systemModifiedAt | datetime | ||||
| 107 | $systemModifiedBy | uniqueidentifier | ||||