Item 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
   [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 IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Base Unit of Measure Searchnvarchar(20)
5Price Unit Conversion Searchint
6Type Searchint
7Inventory Posting Group Searchnvarchar(40)
8Shelf No_ Searchnvarchar(20)
9Item Disc_ Group Searchnvarchar(40)
10Allow Invoice Disc_ Searchtinyint
11Statistics Group Searchint
12Commission Group Searchint
13Unit Price Searchdecimal(38,38)
14Price_Profit Calculation Searchint
15Profit _ Searchdecimal(38,38)
16Costing Method Searchint
17Unit Cost Searchdecimal(38,38)
18Standard Cost Searchdecimal(38,38)
19Indirect Cost _ Searchdecimal(38,38)
20Vendor No_ Searchnvarchar(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_]
21Vendor Item No_ Searchnvarchar(100)
22Lead Time Calculation Searchvarchar(32)
23Reorder Point Searchdecimal(38,38)
24Maximum Inventory Searchdecimal(38,38)
25Reorder Quantity Searchdecimal(38,38)
26Alternative Item No_ Searchnvarchar(40)
27Unit List Price Searchdecimal(38,38)
28Duty Due _ Searchdecimal(38,38)
29Duty Code Searchnvarchar(20)
30Gross Weight Searchdecimal(38,38)
31Net Weight Searchdecimal(38,38)
32Units per Parcel Searchdecimal(38,38)
33Unit Volume Searchdecimal(38,38)
34Durability Searchnvarchar(20)
35Freight Type Searchnvarchar(20)
36Tariff No_ Searchnvarchar(40)
37Duty Unit Conversion Searchdecimal(38,38)
38Country_Region Purchased Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [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]
39Budget Quantity Searchdecimal(38,38)
40Budgeted Amount Searchdecimal(38,38)
41Budget Profit Searchdecimal(38,38)
42Blocked Searchtinyint
43Block Reason Searchnvarchar(500)
44Price Includes VAT Searchtinyint
45VAT Bus_ Posting Gr_ (Price) Searchnvarchar(40)
46Gen_ Prod_ Posting Group Searchnvarchar(40)
47Country_Region of Origin Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [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]
48Automatic Ext_ Texts Searchtinyint
49No_ Series Searchnvarchar(40)
50Tax Group Code Searchnvarchar(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]
51VAT Prod_ Posting Group Searchnvarchar(40)
52Reserve Searchint
53Global Dimension 1 Code Searchnvarchar(40)
54Global Dimension 2 Code Searchnvarchar(40)
55Stockout Warning Searchint
56Prevent Negative Inventory Searchint
57Assembly Policy Searchint
58GTIN Searchnvarchar(28)
59Default Deferral Template Code Searchnvarchar(20)
60Lot Size Searchdecimal(38,38)
61Serial Nos_ Searchnvarchar(40)
62Scrap _ Searchdecimal(38,38)
63Discrete Order Quantity Searchint
64Minimum Order Quantity Searchdecimal(38,38)
65Maximum Order Quantity Searchdecimal(38,38)
66Safety Stock Quantity Searchdecimal(38,38)
67Order Multiple Searchdecimal(38,38)
68Safety Lead Time Searchvarchar(32)
69Flushing Method Searchint
70Replenishment System Searchint
71Rounding Precision Searchdecimal(38,38)
72Time Bucket Searchvarchar(32)
73Reordering Policy Searchint
74Include Inventory Searchtinyint
75Manufacturing Policy Searchint
76Rescheduling Period Searchvarchar(32)
77Lot Accumulation Period Searchvarchar(32)
78Dampener Period Searchvarchar(32)
79Dampener Quantity Searchdecimal(38,38)
80Overflow Level Searchdecimal(38,38)
81Manufacturer Code Searchnvarchar(20)
Key to join to the Manufactuer table.

Show/hide example query

SELECT
       [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]
82Item Category Code Searchnvarchar(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]
83Purchasing Code Searchnvarchar(20)
84Service Item Group Searchnvarchar(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]
85Expiration Calculation Searchvarchar(32)
86Item Tracking Code Searchnvarchar(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]
87Lot Nos_ Searchnvarchar(40)
88Special Equipment Code Searchnvarchar(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]
89Put-away Template Code Searchnvarchar(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]
90Warehouse Class Code Searchnvarchar(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]
91Phys Invt Counting Period Code Searchnvarchar(20)
92Use Cross-Docking Searchtinyint
93Sales Blocked Searchtinyint
94Purchasing Blocked Searchtinyint
95Over-Receipt Code Searchnvarchar(40)
96Routing No_ Searchnvarchar(40)
97Production BOM No_ Searchnvarchar(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_]
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_]
              AND
                     [Item Templ_].[BOM Line No_] = [Production BOM Line].[Line No_]
98Overhead Rate Searchdecimal(38,38)
99Order Tracking Policy Searchint
100Critical Searchtinyint
101Common Item No_ Searchnvarchar(40)
102Reverse Charge Applies Searchtinyint
103$systemId Searchuniqueidentifier
104$systemCreatedAt Searchdatetime
105$systemCreatedBy Searchuniqueidentifier
106$systemModifiedAt Searchdatetime
107$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Templ_ table

Leave a Reply

Your email address will not be published. Required fields are marked *