Vendor

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Name]
   ,[Search Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Contact]
   ,[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]
   ,[Last Modified Date Time]
   ,[Last Date Modified]
   ,[Application Method]
   ,[Prices Including VAT]
   ,[Fax No_]
   ,[Telex Answer Back]
   ,[VAT Registration No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Picture]
   ,[GLN]
   ,[Post Code]
   ,[County]
   ,[EORI Number]
   ,[E-Mail]
   ,[Home Page]
   ,[No_ Series]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[Block Payment Tolerance]
   ,[IC Partner Code]
   ,[Prepayment _]
   ,[Partner Type]
   ,[Image]
   ,[Privacy Blocked]
   ,[Disable Search by Name]
   ,[Creditor No_]
   ,[Preferred Bank Account Code]
   ,[Coupled to CRM]
   ,[Cash Flow Payment Terms Code]
   ,[Primary Contact No_]
   ,[Mobile Phone No_]
   ,[Responsibility Center]
   ,[Location Code]
   ,[Lead Time Calculation]
   ,[Price Calculation Method]
   ,[Base Calendar Code]
   ,[Document Sending Profile]
   ,[Validate EU Vat Reg_ No_]
   ,[Id]
   ,[Currency Id]
   ,[Payment Terms Id]
   ,[Payment Method Id]
   ,[Over-Receipt Code]
   ,[Type of Supply Code]
   ,[Exclude from Pmt_ Pract_ Rep_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Vendor$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$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Vendor].[Territory Code] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Vendor].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Vendor].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Vendor].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Vendor].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Vendor].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Vendor].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Vendor].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Vendor].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Vendor].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Vendor].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Vendor].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
      ON
         [Vendor].[Type of Supply Code] = [Type of Supply].[Code]

Show/hide columns in Vendor table

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Vendor].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Vendor].[Tax Area Code] = [Tax Area].[Code]
49Tax Liable Searchtinyint
50VAT Bus_ Posting Group Searchnvarchar(40)
51Block Payment Tolerance Searchtinyint
52IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Vendor].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Vendor].[IC Partner Code] = [IC Partner].[Code]
53Prepayment _ Searchdecimal(38,38)
54Partner Type Searchint
55Image Searchuniqueidentifier
56Privacy Blocked Searchtinyint
57Disable Search by Name Searchtinyint
58Creditor No_ Searchnvarchar(40)
59Preferred Bank Account Code Searchnvarchar(40)
60Coupled to CRM Searchtinyint
61Cash Flow Payment Terms Code Searchnvarchar(20)
62Primary Contact No_ Searchnvarchar(40)
63Mobile Phone No_ Searchnvarchar(60)
64Responsibility Center Searchnvarchar(20)
65Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Vendor].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Vendor].[Location Code] = [Location].[Code]
66Lead Time Calculation Searchvarchar(32)
67Price Calculation Method Searchint
68Base Calendar Code Searchnvarchar(20)
69Document Sending Profile Searchnvarchar(40)
70Validate EU Vat Reg_ No_ Searchtinyint
71Id Searchuniqueidentifier
72Currency Id Searchuniqueidentifier
73Payment Terms Id Searchuniqueidentifier
74Payment Method Id Searchuniqueidentifier
75Over-Receipt Code Searchnvarchar(40)
76Type of Supply Code Searchnvarchar(20)
Key to join to the Type of Supply table.

Show/hide example query

SELECT
       [Vendor].[Type of Supply Code]
       ,[Type of Supply].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
              ON
                     [Vendor].[Type of Supply Code] = [Type of Supply].[Code]
77Exclude from Pmt_ Pract_ Rep_ Searchtinyint
78$systemId Searchuniqueidentifier
79$systemCreatedAt Searchdatetime
80$systemCreatedBy Searchuniqueidentifier
81$systemModifiedAt Searchdatetime
82$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Vendor table

Show/hide tables related to Vendor table

Leave a Reply

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