Item Template

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

Table Type: Company

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

Table Number: 1301

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 Template can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Item Template$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Key]
   ,[Code]
   ,[Template Name]
   ,[Base Unit of Measure]
   ,[Type]
   ,[Inventory Posting Group]
   ,[Item Disc_ Group]
   ,[Allow Invoice Disc_]
   ,[Price_Profit Calculation]
   ,[Profit _]
   ,[Costing Method]
   ,[Indirect Cost _]
   ,[Price Includes VAT]
   ,[Gen_ Prod_ Posting Group]
   ,[Automatic Ext_ Texts]
   ,[Tax Group Code]
   ,[VAT Prod_ Posting Group]
   ,[Item Category Code]
   ,[Service Item Group]
   ,[Warehouse Class Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Item Template$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 Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Template]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Item Template].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Item Template].[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 Template].[Service Item Group] = [Service Item Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
      ON
         [Item Template].[Warehouse Class Code] = [Warehouse Class].[Code]

Show/hide columns in Item Template table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Key Primary Key Searchint
3Code Searchnvarchar(20)
4Template Name Searchnvarchar(200)
5Base Unit of Measure Searchnvarchar(20)
6Type Searchint
7Inventory Posting Group Searchnvarchar(40)
8Item Disc_ Group Searchnvarchar(40)
9Allow Invoice Disc_ Searchtinyint
10Price_Profit Calculation Searchint
11Profit _ Searchdecimal(38,38)
12Costing Method Searchint
13Indirect Cost _ Searchdecimal(38,38)
14Price Includes VAT Searchtinyint
15Gen_ Prod_ Posting Group Searchnvarchar(40)
16Automatic Ext_ Texts Searchtinyint
17Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Item Template].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Item Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Template]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Item Template].[Tax Group Code] = [Tax Group].[Code]
18VAT Prod_ Posting Group Searchnvarchar(40)
19Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Item Template].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Item Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Template]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Item Template].[Item Category Code] = [Item Category].[Code]
20Service Item Group Searchnvarchar(20)
Key to join to the Service Item Group table.

Show/hide example query

SELECT
       [Item Template].[Service Item Group]
       ,[Service Item Group].[Code]
FROM
       [CRONUS UK Ltd_$Item Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Template]
LEFT JOIN
       [CRONUS UK Ltd_$Service Item Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Item Group]
              ON
                     [Item Template].[Service Item Group] = [Service Item Group].[Code]
21Warehouse Class Code Searchnvarchar(20)
Key to join to the Warehouse Class table.

Show/hide example query

SELECT
       [Item Template].[Warehouse Class Code]
       ,[Warehouse Class].[Code]
FROM
       [CRONUS UK Ltd_$Item Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Template]
LEFT JOIN
       [CRONUS UK Ltd_$Warehouse Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Warehouse Class]
              ON
                     [Item Template].[Warehouse Class Code] = [Warehouse Class].[Code]
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Item Template table

Leave a Reply

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