Mini Customer Template

Dynamics 365 BC Table ReferenceTablesCompany TablesMMini Customer Template

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

Table Type: Company

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

Table Number: 1300

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [timestamp]
   ,[Key]
   ,[Code]
   ,[Template Name]
   ,[City]
   ,[Document Sending Profile]
   ,[Credit Limit (LCY)]
   ,[Customer Posting Group]
   ,[Currency Code]
   ,[Customer Price Group]
   ,[Language Code]
   ,[Payment Terms Code]
   ,[Fin_ Charge Terms Code]
   ,[Customer Disc_ Group]
   ,[Country_Region Code]
   ,[Print Statements]
   ,[Payment Method Code]
   ,[Application Method]
   ,[Prices Including VAT]
   ,[Gen_ Bus_ Posting Group]
   ,[Post Code]
   ,[County]
   ,[Reminder Terms Code]
   ,[VAT Bus_ Posting Group]
   ,[Block Payment Tolerance]
   ,[Allow Line Disc_]
   ,[Validate EU Vat Reg_ No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Mini 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_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Mini Customer Template].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Mini Customer Template].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Mini Customer Template].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Mini Customer Template].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Mini Customer Template].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Mini 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
         [Mini Customer Template].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Mini Customer Template].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
      ON
         [Mini Customer Template].[Reminder Terms Code] = [Reminder Terms].[No_]

Show/hide columns in Mini Customer Template table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Key Primary Key Searchint
3Code Searchnvarchar(20)
4Template Name Searchnvarchar(200)
5City Searchnvarchar(60)
6Document Sending Profile Searchnvarchar(40)
7Credit Limit (LCY) Searchdecimal(38,38)
8Customer Posting Group Searchnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Mini Customer Template].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Mini Customer Template].[Language Code] = [Language].[Code]
12Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Mini Customer Template].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Mini Customer Template].[Payment Method Code] = [Payment Method].[Code]
18Application Method Searchint
19Prices Including VAT Searchtinyint
20Gen_ Bus_ Posting Group Searchnvarchar(40)
21Post Code Searchnvarchar(40)
22County Searchnvarchar(60)
23Reminder Terms Code Searchnvarchar(20)
Key to join to the Reminder Terms table.

Show/hide example query

SELECT
       [Mini Customer Template].[Reminder Terms Code]
       ,[Reminder Terms].[No_]
FROM
       [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template]
LEFT JOIN
       [CRONUS UK Ltd_$Reminder Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reminder Terms]
              ON
                     [Mini Customer Template].[Reminder Terms Code] = [Reminder Terms].[No_]
24VAT Bus_ Posting Group Searchnvarchar(40)
25Block Payment Tolerance Searchtinyint
26Allow Line Disc_ Searchtinyint
27Validate EU Vat Reg_ No_ Searchtinyint
28$systemId Searchuniqueidentifier
29$systemCreatedAt Searchdatetime
30$systemCreatedBy Searchuniqueidentifier
31$systemModifiedAt Searchdatetime
32$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Mini Customer Template table

Country_RegionCurrencyCustomer Discount GroupCustomer Posting GroupCustomer Price GroupLanguagePayment MethodPayment TermsReminder Terms
Dynamics 365 BC Table ReferenceTablesCompany TablesMMini Customer Template

Leave a Reply

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