Mini Customer Template – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables MMini 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

   [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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Mini Customer Template].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
      ON
         [Mini Customer Template].[Document Sending Profile] = [Document Sending Profile].[Code]
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_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Mini Customer Template].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Mini Customer Template].[Post Code] = [Post Code].[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].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Mini Customer Template].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Mini Customer Template].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Mini Customer Template table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Key	Key	Normal	Integer	4	Key	int
2	Code	Code	Normal	Code	10	Code	nvarchar(20)
3	Template Name	Template Name	Normal	Text	100	Template Name	nvarchar(200)
7	City	City	Normal	Text	30	City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Mini Customer Template].[City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Mini Customer Template].[City] = [Post Code].[City]
11	Document Sending Profile	Document Sending Profile	Normal	Code	20	Document Sending Profile	nvarchar(40)
	Key to join to the Document Sending Profile table. Show/hide example query SELECT [Mini Customer Template].[Document Sending Profile] ,[Document Sending Profile].[Code] FROM [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template] LEFT JOIN [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile] ON [Mini Customer Template].[Document Sending Profile] = [Document Sending Profile].[Code]
20	Credit Limit (LCY)	Credit Limit (LCY)	Normal	Decimal	12	Credit Limit (LCY)	decimal(38,38)
21	Customer Posting Group	Customer Posting Group	Normal	Code	20	Customer Posting Group	nvarchar(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]
22	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
23	Customer Price Group	Customer Price Group	Normal	Code	10	Customer Price Group	nvarchar(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]
24	Language Code	Language Code	Normal	Code	10	Language Code	nvarchar(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]
27	Payment Terms Code	Payment Terms Code	Normal	Code	10	Payment Terms Code	nvarchar(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]
28	Fin. Charge Terms Code	Fin. Charge Terms Code	Normal	Code	10	Fin_ Charge Terms Code	nvarchar(20)
	Key to join to the Finance Charge Terms table. Show/hide example query SELECT [Mini Customer Template].[Fin_ Charge Terms Code] ,[Finance Charge Terms].[Code] FROM [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template] LEFT JOIN [CRONUS UK Ltd_$Finance Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Terms] ON [Mini Customer Template].[Fin_ Charge Terms Code] = [Finance Charge Terms].[Code]
34	Customer Disc. Group	Customer Disc. Group	Normal	Code	20	Customer Disc_ Group	nvarchar(40)
	Key to join to the Customer Discount Group table. Show/hide example query SELECT [Mini Customer Template].[Customer Disc_ Group] ,[Customer Discount Group].[Code] 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].[Code]
35	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(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]
42	Print Statements	Print Statements	Normal	Boolean	4	Print Statements	tinyint
47	Payment Method Code	Payment Method Code	Normal	Code	10	Payment Method Code	nvarchar(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$ext] AS [Payment Method] ON [Mini Customer Template].[Payment Method Code] = [Payment Method].[Code]
80	Application Method	Application Method	Normal	Option	4	Application Method	int
	Available options are: “Manual” “Apply to Oldest”
82	Prices Including VAT	Prices Including VAT	Normal	Boolean	4	Prices Including VAT	tinyint
88	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(40)
	Key to join to the Gen. Business Posting Group table. Show/hide example query SELECT [Mini Customer Template].[Gen_ Bus_ Posting Group] ,[Gen. Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template] LEFT JOIN [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group] ON [Mini Customer Template].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
91	Post Code	Post Code	Normal	Code	20	Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Mini Customer Template].[Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Mini Customer Template].[Post Code] = [Post Code].[Code]
92	County	County	Normal	Text	30	County	nvarchar(60)
104	Reminder Terms Code	Reminder Terms Code	Normal	Code	10	Reminder Terms Code	nvarchar(20)
	Key to join to the Reminder Terms table. Show/hide example query SELECT [Mini Customer Template].[Reminder Terms Code] ,[Reminder Terms].[Code] 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].[Code]
109	Tax Liable	Tax Liable	Normal	Boolean	4
110	VAT Bus. Posting Group	VAT Bus. Posting Group	Normal	Code	20	VAT Bus_ Posting Group	nvarchar(40)
	Key to join to the VAT Business Posting Group table. Show/hide example query SELECT [Mini Customer Template].[VAT Bus_ Posting Group] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Mini Customer Template].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
116	Block Payment Tolerance	Block Payment Tolerance	Normal	Boolean	4	Block Payment Tolerance	tinyint
7001	Allow Line Disc.	Allow Line Disc.	Normal	Boolean	4	Allow Line Disc_	tinyint
7602	Validate EU Vat Reg. No.	Validate EU VAT Reg. No.	Normal	Boolean	4	Validate EU Vat Reg_ No_	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Mini Customer Template].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template] LEFT JOIN [User] AS [User] ON [Mini Customer Template].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Mini Customer Template].[$systemModifiedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Mini Customer Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Customer Template] LEFT JOIN [User] AS [User] ON [Mini Customer Template].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Mini Customer Template table

Currency Customer Posting Group Customer Price Group Language Payment Method Payment Terms Post Code Reminder Terms

Dynamics 365 BC Table Reference Tables Company Tables MMini Customer Template

Leave a Reply Cancel reply