Item Templ.

Dynamics 365 BC Table ReferenceTablesCompany TablesIItem 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8Base Unit of Measure SearchBase Unit of MeasureNormalCode10Base Unit of Measurenvarchar(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]
9Price Unit Conversion SearchPrice Unit ConversionNormalInteger4Price Unit Conversionint
10Type SearchTypeNormalOption4Typeint
Available options are:
  • “Inventory”
  • “Service”
  • “Non-Inventory”
11Inventory Posting Group SearchInventory Posting GroupNormalCode20Inventory Posting Groupnvarchar(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]
12Shelf No. SearchShelf No.NormalCode10Shelf No_nvarchar(20)
14Item Disc. Group SearchItem Disc. GroupNormalCode20Item Disc_ Groupnvarchar(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]
15Allow Invoice Disc. SearchAllow Invoice Disc.NormalBoolean4Allow Invoice Disc_tinyint
16Statistics Group SearchStatistics GroupNormalInteger4Statistics Groupint
17Commission Group SearchCommission GroupNormalInteger4Commission Groupint
18Unit Price SearchUnit PriceNormalDecimal12Unit Pricedecimal(38,38)
19Price/Profit Calculation SearchPrice/Profit CalculationNormalOption4Price_Profit Calculationint
Available options are:
  • “Profit=Price-Cost”
  • “Price=Cost+Profit”
  • “No Relationship”
20Profit % SearchProfit %NormalDecimal12Profit _decimal(38,38)
21Costing Method SearchCosting MethodNormalOption4Costing Methodint
Available options are:
  • “FIFO”
  • “LIFO”
  • “Specific”
  • “Average”
  • “Standard”
22Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
24Standard Cost SearchStandard CostNormalDecimal12Standard Costdecimal(38,38)
28Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
31Vendor No. SearchVendor No.NormalCode20Vendor 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_]
32Vendor Item No. SearchVendor Item No.NormalText50Vendor Item No_nvarchar(100)
33Lead Time Calculation SearchLead Time CalculationNormalDateFormula32Lead Time Calculationvarchar(32)
34Reorder Point SearchReorder PointNormalDecimal12Reorder Pointdecimal(38,38)
35Maximum Inventory SearchMaximum InventoryNormalDecimal12Maximum Inventorydecimal(38,38)
36Reorder Quantity SearchReorder QuantityNormalDecimal12Reorder Quantitydecimal(38,38)
37Alternative Item No. SearchAlternative Item No.NormalCode20Alternative 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_]
38Unit List Price SearchUnit List PriceNormalDecimal12Unit List Pricedecimal(38,38)
39Duty Due % SearchDuty Due %NormalDecimal12Duty Due _decimal(38,38)
40Duty Code SearchDuty CodeNormalCode10Duty Codenvarchar(20)
41Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
42Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
43Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
44Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
45Durability SearchDurabilityNormalCode10Durabilitynvarchar(20)
46Freight Type SearchFreight TypeNormalCode10Freight Typenvarchar(20)
47Tariff No. SearchTariff No.NormalCode20Tariff 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_]
48Duty Unit Conversion SearchDuty Unit ConversionNormalDecimal12Duty Unit Conversiondecimal(38,38)
49Country/Region Purchased Code SearchCountry/Region Purchased CodeNormalCode10Country_Region Purchased Codenvarchar(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]
50Budget Quantity SearchBudget QuantityNormalDecimal12Budget Quantitydecimal(38,38)
51Budgeted Amount SearchBudgeted AmountNormalDecimal12Budgeted Amountdecimal(38,38)
52Budget Profit SearchBudget ProfitNormalDecimal12Budget Profitdecimal(38,38)
54Blocked SearchBlockedNormalBoolean4Blockedtinyint
56Block Reason SearchBlock ReasonNormalText250Block Reasonnvarchar(500)
87Price Includes VAT SearchPrice Includes TaxNormalBoolean4Price Includes VATtinyint
90VAT Bus. Posting Gr. (Price) SearchVAT Bus. Posting Gr. (Price)NormalCode20VAT 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]
91Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(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]
95Country/Region of Origin Code SearchCountry/Region of Origin CodeNormalCode10Country_Region of Origin Codenvarchar(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]
96Automatic Ext. Texts SearchAutomatic Ext. TextNormalBoolean4Automatic Ext_ Textstinyint
97No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(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]
98Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
99VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(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]
100Reserve SearchReserveNormalOption4Reserveint
Available options are:
  • “Never”
  • “Optional”
  • “Always”
105Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(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]
106Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(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]
120Stockout Warning SearchStockout WarningNormalOption4Stockout Warningint
Available options are:
  • “Default”
  • “No”
  • “Yes”
121Prevent Negative Inventory SearchPrevent Negative InventoryNormalOption4Prevent Negative Inventoryint
Available options are:
  • “Default”
  • “No”
  • “Yes”
122Variant Mandatory if Exists SearchVariant Mandatory if ExistsNormalOption4Variant Mandatory if Existsint
Available options are:
  • “Default”
  • “No”
  • “Yes”
910Assembly Policy SearchAssembly PolicyNormalOption4Assembly Policyint
Available options are:
  • “Assemble-to-Stock”
  • “Assemble-to-Order”
1217GTIN SearchGTINNormalCode14GTINnvarchar(28)
1700Default Deferral Template Code SearchDefault Deferral Template CodeNormalCode10Default Deferral Template Codenvarchar(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]
5401Lot Size SearchLot SizeNormalDecimal12Lot Sizedecimal(38,38)
5402Serial Nos. SearchSerial Nos.NormalCode20Serial 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]
5407Scrap % SearchScrap %NormalDecimal12Scrap _decimal(38,38)
5409Inventory Value Zero SearchInventory Value ZeroNormalBoolean4Inventory Value Zerotinyint
5410Discrete Order Quantity SearchDiscrete Order QuantityNormalInteger4Discrete Order Quantityint
5411Minimum Order Quantity SearchMinimum Order QuantityNormalDecimal12Minimum Order Quantitydecimal(38,38)
5412Maximum Order Quantity SearchMaximum Order QuantityNormalDecimal12Maximum Order Quantitydecimal(38,38)
5413Safety Stock Quantity SearchSafety Stock QuantityNormalDecimal12Safety Stock Quantitydecimal(38,38)
5414Order Multiple SearchOrder MultipleNormalDecimal12Order Multipledecimal(38,38)
5415Safety Lead Time SearchSafety Lead TimeNormalDateFormula32Safety Lead Timevarchar(32)
5417Flushing Method SearchFlushing MethodNormalOption4Flushing Methodint
Available options are:
  • “Manual”
  • “Forward”
  • “Backward”
  • “Pick + Forward”
  • “Pick + Backward”
5419Replenishment System SearchReplenishment SystemNormalOption4
5422Rounding Precision SearchRounding PrecisionNormalDecimal12Rounding Precisiondecimal(38,38)
5428Time Bucket SearchTime BucketNormalDateFormula32Time Bucketvarchar(32)
5440Reordering Policy SearchReordering PolicyNormalOption4Reordering Policyint
Available options are:
  • ” “
  • “Fixed Reorder Qty.”
  • “Maximum Qty.”
  • “Order”
  • “Lot-for-Lot”
5441Include Inventory SearchInclude InventoryNormalBoolean4Include Inventorytinyint
5442Manufacturing Policy SearchManufacturing PolicyNormalOption4Manufacturing Policyint
Available options are:
  • “Make-to-Stock”
  • “Make-to-Order”
5443Rescheduling Period SearchRescheduling PeriodNormalDateFormula32Rescheduling Periodvarchar(32)
5444Lot Accumulation Period SearchLot Accumulation PeriodNormalDateFormula32Lot Accumulation Periodvarchar(32)
5445Dampener Period SearchDampener PeriodNormalDateFormula32Dampener Periodvarchar(32)
5446Dampener Quantity SearchDampener QuantityNormalDecimal12Dampener Quantitydecimal(38,38)
5447Overflow Level SearchOverflow LevelNormalDecimal12Overflow Leveldecimal(38,38)
5701Manufacturer Code SearchManufacturer CodeNormalCode10Manufacturer Codenvarchar(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]
5702Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(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]
5711Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(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]
5900Service Item Group SearchService Item GroupNormalCode10Service Item Groupnvarchar(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]
6500Item Tracking Code SearchItem Tracking CodeNormalCode10Item Tracking Codenvarchar(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]
6501Lot Nos. SearchLot Nos.NormalCode20Lot 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]
6502Expiration Calculation SearchExpiration CalculationNormalDateFormula32Expiration Calculationvarchar(32)
7300Warehouse Class Code SearchWarehouse Class CodeNormalCode10Warehouse Class Codenvarchar(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]
7301Special Equipment Code SearchSpecial Equipment CodeNormalCode10Special Equipment Codenvarchar(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]
7302Put-away Template Code SearchPut-away Template CodeNormalCode10Put-away Template Codenvarchar(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]
7380Phys Invt Counting Period Code SearchPhys Invt Counting Period CodeNormalCode10Phys Invt Counting Period Codenvarchar(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]
7384Use Cross-Docking SearchUse Cross-DockingNormalBoolean4Use Cross-Dockingtinyint
8003Sales Blocked SearchSales BlockedNormalBoolean4Sales Blockedtinyint
8004Purchasing Blocked SearchPurchasing BlockedNormalBoolean4Purchasing Blockedtinyint
8510Over-Receipt Code SearchOver-Receipt CodeNormalCode20Over-Receipt Codenvarchar(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]
10004Duty Class SearchDuty ClassNormalCode10
27000SAT Item Classification SearchSAT Item ClassificationNormalCode10
27024SAT Hazardous Material SearchSAT Hazardous MaterialNormalCode10
27025SAT Packaging Type SearchSAT Packaging TypeNormalCode10
99000750Routing No. SearchRouting No.NormalCode20Routing 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_]
99000751Production BOM No. SearchProduction BOM No.NormalCode20Production 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].[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_]
99000757Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
99000773Order Tracking Policy SearchOrder Tracking PolicyNormalOption4Order Tracking Policyint
Available options are:
  • “None”
  • “Tracking Only”
  • “Tracking & Action Msg.”
99000875Critical SearchCriticalNormalBoolean4Criticaltinyint
99008500Common Item No. SearchCommon Item No.NormalCode20Common Item No_nvarchar(40)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Item Templ.].[$systemModifiedBy]
       ,[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.].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Item Templ. table

Item CategoryItem Tracking CodePut-away Template HeaderService Item GroupSpecial EquipmentTax GroupWarehouse Class
Dynamics 365 BC Table ReferenceTablesCompany TablesIItem Templ.

Leave a Reply

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