Mini Vendor Template

Dynamics 365 BC Table ReferenceTablesCompany TablesMMini Vendor Template

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

Table Type: Company

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

Table Number: 1303

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Key]
   ,[Code]
   ,[Template Name]
   ,[City]
   ,[Vendor Posting Group]
   ,[Currency Code]
   ,[Language Code]
   ,[Payment Terms Code]
   ,[Fin_ Charge Terms Code]
   ,[Invoice Disc_ Code]
   ,[Country_Region Code]
   ,[Payment Method Code]
   ,[Application Method]
   ,[Prices Including VAT]
   ,[Gen_ Bus_ Posting Group]
   ,[Post Code]
   ,[County]
   ,[VAT Bus_ Posting Group]
   ,[Block Payment Tolerance]
   ,[Validate EU Vat Reg_ No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Mini Vendor 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 Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Mini Vendor Template].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
      ON
         [Mini Vendor Template].[Vendor Posting Group] = [Vendor Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Mini Vendor Template].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Mini Vendor Template].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Mini Vendor 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 Vendor Template].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Mini Vendor Template].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Mini Vendor Template].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Mini Vendor Template].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Mini Vendor 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 Vendor Template].[City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Mini Vendor Template].[City] = [Post Code].[City]
21Vendor Posting Group SearchVendor Posting GroupNormalCode20Vendor Posting Groupnvarchar(40)
Key to join to the Vendor Posting Group table.

Show/hide example query

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

Show/hide example query

SELECT
	       [Mini Vendor Template].[Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Mini Vendor Template].[Currency Code] = [Currency].[Code]
24Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
	       [Mini Vendor Template].[Language Code]
	       ,[Language].[Code]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
	              ON
	                     [Mini Vendor 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 Vendor Template].[Payment Terms Code]
	       ,[Payment Terms].[Code]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Mini Vendor 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 Vendor Template].[Fin_ Charge Terms Code]
	       ,[Finance Charge Terms].[Code]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Finance Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Terms]
	              ON
	                     [Mini Vendor Template].[Fin_ Charge Terms Code] = [Finance Charge Terms].[Code]
33Invoice Disc. Code SearchInvoice Disc. CodeNormalCode20Invoice Disc_ Codenvarchar(40)
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
	       [Mini Vendor Template].[Payment Method Code]
	       ,[Payment Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
	              ON
	                     [Mini Vendor 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 Vendor Template].[Gen_ Bus_ Posting Group]
	       ,[Gen. Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
	              ON
	                     [Mini Vendor 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 Vendor Template].[Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Mini Vendor Template].[Post Code] = [Post Code].[Code]
92County SearchCountyNormalText30Countynvarchar(60)
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 Vendor Template].[VAT Bus_ Posting Group]
	       ,[VAT Business Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
	              ON
	                     [Mini Vendor Template].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
116Block Payment Tolerance SearchBlock Payment ToleranceNormalBoolean4Block Payment Tolerancetinyint
7602Validate EU Vat Reg. No. SearchValidate EU VAT Reg. No.NormalBoolean4Validate EU Vat Reg_ No_tinyint
10018Check Date Format SearchCheck Date FormatNormalOption4
10019Check Date Separator SearchCheck Date SeparatorNormalOption4
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 Vendor Template].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Mini Vendor Template].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Mini Vendor Template table

CurrencyLanguagePayment MethodPayment TermsPost CodeVendor Posting Group
Dynamics 365 BC Table ReferenceTablesCompany TablesMMini Vendor Template

Leave a Reply

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