Customer Template

Dynamics 365 BC Table ReferenceTablesCompany TablesCCustomer Template

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

Table Type: Company

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

Table Number: 5105

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Code]
   ,[Description]
   ,[Territory Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Customer Posting Group]
   ,[Currency Code]
   ,[Customer Price Group]
   ,[Payment Terms Code]
   ,[Shipment Method Code]
   ,[Invoice Disc_ Code]
   ,[Customer Disc_ Group]
   ,[Country_Region Code]
   ,[Payment Method Code]
   ,[Prices Including VAT]
   ,[Gen_ Bus_ Posting Group]
   ,[VAT Bus_ Posting Group]
   ,[Contact Type]
   ,[Allow Line Disc_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Customer 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_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Customer Template].[Territory Code] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Customer Template].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Customer Template].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Customer Template].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Customer Template].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Customer Template].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Customer Template].[Customer Disc_ Group] = [Customer Discount Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Customer Template].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Customer Template].[Payment Method Code] = [Payment Method].[Code]

Show/hide columns in Customer Template table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Description Searchnvarchar(200)
4Territory Code Searchnvarchar(20)
Key to join to the Territory table.

Show/hide example query

SELECT
       [Customer Template].[Territory Code]
       ,[Territory].[Code]
FROM
       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
       [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
              ON
                     [Customer Template].[Territory Code] = [Territory].[Code]
5Global Dimension 1 Code Searchnvarchar(40)
6Global Dimension 2 Code Searchnvarchar(40)
7Customer Posting Group Searchnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Customer Template].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Customer Template].[Payment Terms Code] = [Payment Terms].[Code]
11Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Customer Template].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Customer Template].[Shipment Method Code] = [Shipment Method].[Code]
12Invoice Disc_ Code Searchnvarchar(40)
13Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Customer Template].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Customer Template].[Payment Method Code] = [Payment Method].[Code]
16Prices Including VAT Searchtinyint
17Gen_ Bus_ Posting Group Searchnvarchar(40)
18VAT Bus_ Posting Group Searchnvarchar(40)
19Contact Type Searchint
20Allow Line Disc_ Searchtinyint
21$systemId Searchuniqueidentifier
22$systemCreatedAt Searchdatetime
23$systemCreatedBy Searchuniqueidentifier
24$systemModifiedAt Searchdatetime
25$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Customer Template table

Country_RegionCurrencyCustomer Discount GroupCustomer Posting GroupCustomer Price GroupPayment MethodPayment TermsShipment MethodTerritory
Dynamics 365 BC Table ReferenceTablesCompany TablesCCustomer Template

Leave a Reply

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