Mini 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
   [timestamp]
   ,[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_$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_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Mini Vendor Template].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Mini Vendor Template].[Payment Method Code] = [Payment Method].[Code]

Show/hide columns in Mini Vendor Template table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Key Primary Key Searchint
3Code Searchnvarchar(20)
4Template Name Searchnvarchar(200)
5City Searchnvarchar(60)
6Vendor Posting Group Searchnvarchar(40)
7Currency Code Searchnvarchar(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]
8Language Code Searchnvarchar(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]
9Payment Terms Code Searchnvarchar(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]
10Fin_ Charge Terms Code Searchnvarchar(20)
11Invoice Disc_ Code Searchnvarchar(40)
12Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Mini Vendor Template].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Mini Vendor Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Mini Vendor Template]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Mini Vendor Template].[Country_Region Code] = [Country_Region].[Code]
13Payment Method Code Searchnvarchar(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] AS [Payment Method]
              ON
                     [Mini Vendor Template].[Payment Method Code] = [Payment Method].[Code]
14Application Method Searchint
15Prices Including VAT Searchtinyint
16Gen_ Bus_ Posting Group Searchnvarchar(40)
17Post Code Searchnvarchar(40)
18County Searchnvarchar(60)
19VAT Bus_ Posting Group Searchnvarchar(40)
20Block Payment Tolerance Searchtinyint
21Validate EU Vat Reg_ No_ Searchtinyint
22$systemId Searchuniqueidentifier
23$systemCreatedAt Searchdatetime
24$systemCreatedBy Searchuniqueidentifier
25$systemModifiedAt Searchdatetime
26$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Mini Vendor Template table

Leave a Reply

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