Vendor Templ_

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

Table Type: Company

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

Table Number: 1383

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Description]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Phone No_]
   ,[Telex No_]
   ,[Our Account No_]
   ,[Territory Code]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Budgeted Amount]
   ,[Vendor Posting Group]
   ,[Currency Code]
   ,[Language Code]
   ,[Statistics Group]
   ,[Payment Terms Code]
   ,[Fin_ Charge Terms Code]
   ,[Purchaser Code]
   ,[Shipment Method Code]
   ,[Shipping Agent Code]
   ,[Invoice Disc_ Code]
   ,[Country_Region Code]
   ,[Blocked]
   ,[Pay-to Vendor No_]
   ,[Priority]
   ,[Payment Method Code]
   ,[Application Method]
   ,[Prices Including VAT]
   ,[Fax No_]
   ,[Telex Answer Back]
   ,[VAT Registration No_]
   ,[Gen_ Bus_ Posting Group]
   ,[GLN]
   ,[Post Code]
   ,[County]
   ,[EORI Number]
   ,[E-Mail]
   ,[Home Page]
   ,[No_ Series]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[Block Payment Tolerance]
   ,[Prepayment _]
   ,[Privacy Blocked]
   ,[Disable Search by Name]
   ,[Creditor No_]
   ,[Cash Flow Payment Terms Code]
   ,[Partner Type]
   ,[Contact Type]
   ,[Mobile Phone No_]
   ,[Responsibility Center]
   ,[Location Code]
   ,[Price Calculation Method]
   ,[Base Calendar Code]
   ,[Document Sending Profile]
   ,[Validate EU Vat Reg_ No_]
   ,[Over-Receipt Code]
   ,[Exclude from Pmt_ Pract_ Rep_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Vendor Templ_].[Territory Code] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Vendor Templ_].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Vendor Templ_].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Vendor Templ_].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Vendor Templ_].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Vendor Templ_].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Vendor Templ_].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Vendor Templ_].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Vendor Templ_].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Vendor Templ_].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Vendor Templ_].[Location Code] = [Location].[Code]

Show/hide columns in Vendor Templ_ table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(40)
3Description Searchnvarchar(200)
4Address Searchnvarchar(200)
5Address 2 Searchnvarchar(100)
6City Searchnvarchar(60)
7Phone No_ Searchnvarchar(60)
8Telex No_ Searchnvarchar(40)
9Our Account No_ Searchnvarchar(40)
10Territory Code Searchnvarchar(20)
Key to join to the Territory table.

Show/hide example query

SELECT
       [Vendor Templ_].[Territory Code]
       ,[Territory].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
              ON
                     [Vendor Templ_].[Territory Code] = [Territory].[Code]
11Global Dimension 1 Code Searchnvarchar(40)
12Global Dimension 2 Code Searchnvarchar(40)
13Budgeted Amount Searchdecimal(38,38)
14Vendor Posting Group Searchnvarchar(40)
15Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Vendor Templ_].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Vendor Templ_].[Payment Terms Code] = [Payment Terms].[Code]
19Fin_ Charge Terms Code Searchnvarchar(20)
20Purchaser Code Searchnvarchar(40)
21Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Vendor Templ_].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Vendor Templ_].[Shipment Method Code] = [Shipment Method].[Code]
22Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Vendor Templ_].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Vendor Templ_].[Shipping Agent Code] = [Shipping Agent].[Code]
23Invoice Disc_ Code Searchnvarchar(40)
24Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Vendor Templ_].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Vendor Templ_].[Country_Region Code] = [Country_Region].[Code]
25Blocked Searchint
26Pay-to Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Vendor Templ_].[Pay-to Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Vendor Templ_].[Pay-to Vendor No_] = [Vendor].[No_]
27Priority Searchint
28Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Vendor Templ_].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Vendor Templ_].[Payment Method Code] = [Payment Method].[Code]
29Application Method Searchint
30Prices Including VAT Searchtinyint
31Fax No_ Searchnvarchar(60)
32Telex Answer Back Searchnvarchar(40)
33VAT Registration No_ Searchnvarchar(40)
34Gen_ Bus_ Posting Group Searchnvarchar(40)
35GLN Searchnvarchar(26)
36Post Code Searchnvarchar(40)
37County Searchnvarchar(60)
38EORI Number Searchnvarchar(80)
39E-Mail Searchnvarchar(160)
40Home Page Searchnvarchar(160)
41No_ Series Searchnvarchar(40)
42Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Vendor Templ_].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Vendor Templ_].[Tax Area Code] = [Tax Area].[Code]
43Tax Liable Searchtinyint
44VAT Bus_ Posting Group Searchnvarchar(40)
45Block Payment Tolerance Searchtinyint
46Prepayment _ Searchdecimal(38,38)
47Privacy Blocked Searchtinyint
48Disable Search by Name Searchtinyint
49Creditor No_ Searchnvarchar(40)
50Cash Flow Payment Terms Code Searchnvarchar(20)
51Partner Type Searchint
52Contact Type Searchint
53Mobile Phone No_ Searchnvarchar(60)
54Responsibility Center Searchnvarchar(20)
55Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Vendor Templ_].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ_]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Vendor Templ_].[Location Code] = [Location].[Code]
56Price Calculation Method Searchint
57Base Calendar Code Searchnvarchar(20)
58Document Sending Profile Searchnvarchar(40)
59Validate EU Vat Reg_ No_ Searchtinyint
60Over-Receipt Code Searchnvarchar(40)
61Exclude from Pmt_ Pract_ Rep_ Searchtinyint
62$systemId Searchuniqueidentifier
63$systemCreatedAt Searchdatetime
64$systemCreatedBy Searchuniqueidentifier
65$systemModifiedAt Searchdatetime
66$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Vendor Templ_ table

Leave a Reply

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