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
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 ID | Column Name | Data Type | ||||
|---|---|---|---|---|---|---|
| 1 | timestamp  | timestamp | ||||
| 2 | Code  | nvarchar(40) | ||||
| 3 | Description | nvarchar(200) | ||||
| 4 | Address | nvarchar(200) | ||||
| 5 | Address 2 | nvarchar(100) | ||||
| 6 | City | nvarchar(60) | ||||
| 7 | Phone No_ | nvarchar(60) | ||||
| 8 | Telex No_ | nvarchar(40) | ||||
| 9 | Our Account No_ | nvarchar(40) | ||||
| 10 | Territory Code | nvarchar(20) | ||||
Key to join to the Territory table.Show/hide example querySELECT
[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] | ||||||
| 11 | Global Dimension 1 Code | nvarchar(40) | ||||
| 12 | Global Dimension 2 Code | nvarchar(40) | ||||
| 13 | Budgeted Amount | decimal(38,38) | ||||
| 14 | Vendor Posting Group | nvarchar(40) | ||||
| 15 | Currency Code | nvarchar(20) | ||||
Key to join to the Currency table.Show/hide example querySELECT
[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] | ||||||
| 16 | Language Code | nvarchar(20) | ||||
Key to join to the Language table.Show/hide example querySELECT
[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] | ||||||
| 17 | Statistics Group | int | ||||
| 18 | Payment Terms Code | nvarchar(20) | ||||
Key to join to the Payment Terms table.Show/hide example querySELECT
[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] | ||||||
| 19 | Fin_ Charge Terms Code | nvarchar(20) | ||||
| 20 | Purchaser Code | nvarchar(40) | ||||
| 21 | Shipment Method Code | nvarchar(20) | ||||
Key to join to the Shipment Method table.Show/hide example querySELECT
[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] | ||||||
| 22 | Shipping Agent Code | nvarchar(20) | ||||
Key to join to the Shipping Agent table.Show/hide example querySELECT
[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] | ||||||
| 23 | Invoice Disc_ Code | nvarchar(40) | ||||
| 24 | Country_Region Code | nvarchar(20) | ||||
Key to join to the Country_Region table.Show/hide example querySELECT
[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] | ||||||
| 25 | Blocked | int | ||||
| 26 | Pay-to Vendor No_ | nvarchar(40) | ||||
Key to join to the Vendor table.Show/hide example querySELECT
[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_] | ||||||
| 27 | Priority | int | ||||
| 28 | Payment Method Code | nvarchar(20) | ||||
Key to join to the Payment Method table.Show/hide example querySELECT
[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] | ||||||
| 29 | Application Method | int | ||||
| 30 | Prices Including VAT | tinyint | ||||
| 31 | Fax No_ | nvarchar(60) | ||||
| 32 | Telex Answer Back | nvarchar(40) | ||||
| 33 | VAT Registration No_ | nvarchar(40) | ||||
| 34 | Gen_ Bus_ Posting Group | nvarchar(40) | ||||
| 35 | GLN | nvarchar(26) | ||||
| 36 | Post Code | nvarchar(40) | ||||
| 37 | County | nvarchar(60) | ||||
| 38 | EORI Number | nvarchar(80) | ||||
| 39 | E-Mail | nvarchar(160) | ||||
| 40 | Home Page | nvarchar(160) | ||||
| 41 | No_ Series | nvarchar(40) | ||||
| 42 | Tax Area Code | nvarchar(40) | ||||
Key to join to the Tax Area table.Show/hide example querySELECT
[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] | ||||||
| 43 | Tax Liable | tinyint | ||||
| 44 | VAT Bus_ Posting Group | nvarchar(40) | ||||
| 45 | Block Payment Tolerance | tinyint | ||||
| 46 | Prepayment _ | decimal(38,38) | ||||
| 47 | Privacy Blocked | tinyint | ||||
| 48 | Disable Search by Name | tinyint | ||||
| 49 | Creditor No_ | nvarchar(40) | ||||
| 50 | Cash Flow Payment Terms Code | nvarchar(20) | ||||
| 51 | Partner Type | int | ||||
| 52 | Contact Type | int | ||||
| 53 | Mobile Phone No_ | nvarchar(60) | ||||
| 54 | Responsibility Center | nvarchar(20) | ||||
| 55 | Location Code | nvarchar(20) | ||||
Key to join to the Location table.Show/hide example querySELECT
[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] | ||||||
| 56 | Price Calculation Method | int | ||||
| 57 | Base Calendar Code | nvarchar(20) | ||||
| 58 | Document Sending Profile | nvarchar(40) | ||||
| 59 | Validate EU Vat Reg_ No_ | tinyint | ||||
| 60 | Over-Receipt Code | nvarchar(40) | ||||
| 61 | Exclude from Pmt_ Pract_ Rep_ | tinyint | ||||
| 62 | $systemId | uniqueidentifier | ||||
| 63 | $systemCreatedAt | datetime | ||||
| 64 | $systemCreatedBy | uniqueidentifier | ||||
| 65 | $systemModifiedAt | datetime | ||||
| 66 | $systemModifiedBy | uniqueidentifier | ||||