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

   [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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Customer Template].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Customer Template].[Global Dimension 2 Code] = [Dimension].[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_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Customer Template].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Customer Template].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Customer Template].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Customer Template].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Customer Template table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode10Codenvarchar(20)
2Description Primary Key SearchDescriptionNormalText100Descriptionnvarchar(200)
15Territory Code SearchTerritory CodeNormalCode10Territory Codenvarchar(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]
16Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Customer Template].[Global Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Customer Template].[Global Dimension 1 Code] = [Dimension].[Code]
17Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
	       [Customer Template].[Global Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Customer Template].[Global Dimension 2 Code] = [Dimension].[Code]
21Customer Posting Group SearchCustomer Posting GroupNormalCode20Customer Posting Groupnvarchar(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]
22Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
23Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(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]
27Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(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]
30Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(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]
33Invoice Disc. Code SearchInvoice Disc. CodeNormalCode20Invoice Disc_ Codenvarchar(40)
34Customer Disc. Group SearchCustomer Disc. GroupNormalCode20Customer Disc_ Groupnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
	       [Customer Template].[Customer Disc_ Group]
	       ,[Customer Discount Group].[Code]
	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].[Code]
35Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
47Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(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$ext] AS [Payment Method]
	              ON
	                     [Customer Template].[Payment Method Code] = [Payment Method].[Code]
82Prices Including VAT SearchPrices Including VATNormalBoolean4Prices Including VATtinyint
88Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
	       [Customer Template].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [Customer Template].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
110VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
	       [Customer Template].[VAT Bus_ Posting Group]
	       ,[VAT Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
	              ON
	                     [Customer Template].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
5050Contact Type SearchContact TypeNormalOption4Contact Typeint
Available options are:
  • “Company”
  • “Person”
7001Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
10020Credit Limit (LCY) SearchCredit Limit (LCY)NormalDecimal12
10092State SearchStateNormalText30
10108Tax Area Code SearchTax Area CodeNormalCode20
Key to join to the Tax Area table.

Show/hide example query

SELECT
	       [Customer Template].[]
	       ,[Tax Area].[Code]
	FROM
	       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
	              ON
	                     [Customer Template].[] = [Tax Area].[Code]
10109Tax Liable SearchTax LiableNormalBoolean4
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
	       [Customer Template].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Template]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Customer Template].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Customer Template table

CurrencyCustomer Posting GroupCustomer Price GroupPayment MethodPayment TermsShipment MethodTax AreaTerritory
Dynamics 365 BC Table ReferenceTablesCompany TablesCCustomer Template

Leave a Reply

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