Mini 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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Key SearchKeyNormalInteger4Keyint
2Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
3Template Name SearchTemplate NameNormalText100Template Namenvarchar(200)
7City SearchCityNormalText30Citynvarchar(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]
11Document Sending Profile SearchDocument Sending ProfileNormalCode20Document Sending Profilenvarchar(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]
20Credit Limit (LCY) SearchCredit Limit (LCY)NormalDecimal12Credit Limit (LCY)decimal(38,38)
21Customer Posting Group SearchCustomer Posting GroupNormalCode20Customer Posting Groupnvarchar(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]
22Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
23Customer Price Group SearchCustomer Price GroupNormalCode10Customer Price Groupnvarchar(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]
24Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(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]
27Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(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]
28Fin. Charge Terms Code SearchFin. Charge Terms CodeNormalCode10Fin_ Charge Terms Codenvarchar(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]
34Customer Disc. Group SearchCustomer Disc. GroupNormalCode20Customer Disc_ Groupnvarchar(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]
35Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
42Print Statements SearchPrint StatementsNormalBoolean4Print Statementstinyint
47Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(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]
80Application Method SearchApplication MethodNormalOption4Application Methodint
Available options are:
  • “Manual”
  • “Apply to Oldest”
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
	       [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]
91Post Code SearchPost CodeNormalCode20Post Codenvarchar(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]
92County SearchCountyNormalText30Countynvarchar(60)
104Reminder Terms Code SearchReminder Terms CodeNormalCode10Reminder Terms Codenvarchar(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]
109Tax Liable SearchTax LiableNormalBoolean4
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
	       [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]
116Block Payment Tolerance SearchBlock Payment ToleranceNormalBoolean4Block Payment Tolerancetinyint
7001Allow Line Disc. SearchAllow Line Disc.NormalBoolean4Allow Line Disc_tinyint
7602Validate EU Vat Reg. No. SearchValidate EU VAT Reg. No.NormalBoolean4Validate EU Vat Reg_ No_tinyint
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
	       [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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Mini Customer Template table

Leave a Reply

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