Vendor

Dynamics 365 BC Table ReferenceTablesCompany TablesVVendor

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: 23

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

   [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]
   ,[Registration Number]
   ,[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]
   ,[Format Region]
   ,[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]
   ,[Intrastat Partner Type]
   ,[Exclude from Pmt_ Practices]
   ,[Company Size Code]
   ,[Image]
   ,[Privacy Blocked]
   ,[Disable Search by Name]
   ,[Creditor No_]
   ,[Allow Multiple Posting Groups]
   ,[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]
   ,[$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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Vendor].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Territory$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Territory]
      ON
         [Vendor].[Territory Code] = [Territory].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
      ON
         [Vendor].[Vendor Posting Group] = [Vendor Posting Group].[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_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Vendor].[Purchaser Code] = [Salesperson/Purchaser].[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$ext] AS [Shipping Agent]
      ON
         [Vendor].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Vendor].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Vendor].[Post Code] = [Post Code].[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_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Vendor].[Currency Filter] = [Currency].[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_$Company Size$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Size]
      ON
         [Vendor].[Company Size Code] = [Company Size].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Vendor].[Cash Flow Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Vendor].[Responsibility Center] = [Responsibility Center].[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_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
      ON
         [Vendor].[Base Calendar Code] = [Base Calendar].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
      ON
         [Vendor].[Document Sending Profile] = [Document Sending Profile].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Vendor].[Currency Id] = [Currency].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Vendor].[Payment Terms Id] = [Payment Terms].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Vendor].[Payment Method Id] = [Payment Method].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code]
      ON
         [Vendor].[Over-Receipt Code] = [Over-Receipt Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Vendor].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Vendor].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Vendor table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
2Name SearchNameNormalText100Namenvarchar(200)
3Search Name SearchSearch NameNormalCode100Search Namenvarchar(200)
4Name 2 SearchName 2NormalText50Name 2nvarchar(100)
5Address SearchAddressNormalText100Addressnvarchar(200)
6Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
7City SearchCityNormalText30Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Vendor].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Vendor].[City] = [Post Code].[City]
8Contact SearchContactNormalText100Contactnvarchar(200)
9Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
10Telex No. SearchTelex No.NormalText20Telex No_nvarchar(40)
14Our Account No. SearchOur Account No.NormalText20Our Account No_nvarchar(40)
15Territory Code SearchTerritory CodeNormalCode10Territory Codenvarchar(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]
16Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Vendor].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Vendor].[Global Dimension 1 Code] = [Dimension].[Code]
17Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Vendor].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Vendor].[Global Dimension 2 Code] = [Dimension].[Code]
19Budgeted Amount SearchBudgeted AmountNormalDecimal12Budgeted Amountdecimal(38,38)
21Vendor Posting Group SearchVendor Posting GroupNormalCode20Vendor Posting Groupnvarchar(40)
Key to join to the Vendor Posting Group table.

Show/hide example query

SELECT
       [Vendor].[Vendor Posting Group]
       ,[Vendor Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
              ON
                     [Vendor].[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
       [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]
24Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(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]
25Registration Number SearchRegistration No.NormalText50Registration Numbernvarchar(100)
26Statistics Group SearchStatistics GroupNormalInteger4Statistics Groupint
27Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(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]
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
       [Vendor].[Fin_ Charge Terms Code]
       ,[Finance Charge Terms].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Finance Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Terms]
              ON
                     [Vendor].[Fin_ Charge Terms Code] = [Finance Charge Terms].[Code]
29Purchaser Code SearchPurchaser CodeNormalCode20Purchaser Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Vendor].[Purchaser Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Vendor].[Purchaser Code] = [Salesperson/Purchaser].[Code]
30Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(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]
31Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(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$ext] AS [Shipping Agent]
              ON
                     [Vendor].[Shipping Agent Code] = [Shipping Agent].[Code]
33Invoice Disc. Code SearchInvoice Disc. CodeNormalCode20Invoice Disc_ Codenvarchar(40)
Key to join to the Vendor Invoice Disc. table.

Show/hide example query

SELECT
       [Vendor].[Invoice Disc_ Code]
       ,[Vendor Invoice Disc.].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor Invoice Disc_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Invoice Disc.]
              ON
                     [Vendor].[Invoice Disc_ Code] = [Vendor Invoice Disc.].[Code]
35Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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]
38Comment SearchCommentFlowFieldBoolean4
39Blocked SearchBlockedNormalOption4Blockedint
Available options are:
  • ” “
  • “Payment”
  • “All”
45Pay-to Vendor No. SearchVendor No.NormalCode20Pay-to Vendor No_nvarchar(40)
46Priority SearchPriorityNormalInteger4Priorityint
47Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(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$ext] AS [Payment Method]
              ON
                     [Vendor].[Payment Method Code] = [Payment Method].[Code]
48Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
53Last Modified Date Time SearchLast Modified Date TimeNormalDateTime8Last Modified Date Timedatetime
54Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
55Date Filter SearchDate FilterFlowFilterDate4
56Global Dimension 1 Filter SearchGlobal Dimension 1 FilterFlowFilterCode20
57Global Dimension 2 Filter SearchGlobal Dimension 2 FilterFlowFilterCode20
58Balance SearchBalanceFlowFieldDecimal12
59Balance (LCY) SearchBalance ($)FlowFieldDecimal12
60Net Change SearchNet ChangeFlowFieldDecimal12
61Net Change (LCY) SearchNet Change ($)FlowFieldDecimal12
62Purchases (LCY) SearchPurchases ($)FlowFieldDecimal12
64Inv. Discounts (LCY) SearchInv. Discounts ($)FlowFieldDecimal12
65Pmt. Discounts (LCY) SearchPmt. Discounts ($)FlowFieldDecimal12
66Balance Due SearchBalance DueFlowFieldDecimal12
67Balance Due (LCY) SearchBalance Due ($)FlowFieldDecimal12
69Payments SearchPaymentsFlowFieldDecimal12
70Invoice Amounts SearchInvoice AmountsFlowFieldDecimal12
71Cr. Memo Amounts SearchCr. Memo AmountsFlowFieldDecimal12
72Finance Charge Memo Amounts SearchFinance Charge Memo AmountsFlowFieldDecimal12
74Payments (LCY) SearchPayments ($)FlowFieldDecimal12
75Inv. Amounts (LCY) SearchInv. Amounts ($)FlowFieldDecimal12
76Cr. Memo Amounts (LCY) SearchCr. Memo Amounts ($)FlowFieldDecimal12
77Fin. Charge Memo Amounts (LCY) SearchFin. Charge Memo Amounts ($)FlowFieldDecimal12
78Outstanding Orders SearchOutstanding OrdersFlowFieldDecimal12
79Amt. Rcd. Not Invoiced SearchAmt. Rcd. Not InvoicedFlowFieldDecimal12
80Application Method SearchApplication MethodNormalOption4Application Methodint
Available options are:
  • “Manual”
  • “Apply to Oldest”
82Prices Including VAT SearchPrices Including TaxNormalBoolean4Prices Including VATtinyint
84Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
85Telex Answer Back SearchTelex Answer BackNormalText20Telex Answer Backnvarchar(40)
86VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
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
       [Vendor].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Vendor].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
89Picture SearchPictureNormalBLOB8Pictureimage
90GLN SearchGLNNormalCode13GLNnvarchar(26)
91Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Vendor].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Vendor].[Post Code] = [Post Code].[Code]
92County SearchStateNormalText30Countynvarchar(60)
93EORI Number SearchEORI NumberNormalText40EORI Numbernvarchar(80)
97Debit Amount SearchDebit AmountFlowFieldDecimal12
98Credit Amount SearchCredit AmountFlowFieldDecimal12
99Debit Amount (LCY) SearchDebit Amount ($)FlowFieldDecimal12
100Credit Amount (LCY) SearchCredit Amount ($)FlowFieldDecimal12
102E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
103Home Page SearchHome PageNormalText80Home Pagenvarchar(160)
104Reminder Amounts SearchReminder AmountsFlowFieldDecimal12
105Reminder Amounts (LCY) SearchReminder Amounts ($)FlowFieldDecimal12
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Vendor].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Vendor].[No_ Series] = [No. Series].[Code]
108Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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]
109Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
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
       [Vendor].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Vendor].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
111Currency Filter SearchCurrency FilterFlowFilterCode10
113Outstanding Orders (LCY) SearchOutstanding Orders ($)FlowFieldDecimal12
114Amt. Rcd. Not Invoiced (LCY) SearchAmt. Rcd. Not Invoiced ($)FlowFieldDecimal12
116Block Payment Tolerance SearchBlock Payment ToleranceNormalBoolean4Block Payment Tolerancetinyint
117Pmt. Disc. Tolerance (LCY) SearchPmt. Disc. Tolerance ($)FlowFieldDecimal12
118Pmt. Tolerance (LCY) SearchPmt. Tolerance ($)FlowFieldDecimal12
119IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(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]
120Refunds SearchRefundsFlowFieldDecimal12
121Refunds (LCY) SearchRefunds ($)FlowFieldDecimal12
122Other Amounts SearchOther AmountsFlowFieldDecimal12
123Other Amounts (LCY) SearchOther Amounts ($)FlowFieldDecimal12
124Prepayment % SearchPrepayment %NormalDecimal12Prepayment _decimal(38,38)
125Outstanding Invoices SearchOutstanding InvoicesFlowFieldDecimal12
126Outstanding Invoices (LCY) SearchOutstanding Invoices ($)FlowFieldDecimal12
130Pay-to No. Of Archived Doc. SearchPay-to No. Of Archived Doc.FlowFieldInteger4
131Buy-from No. Of Archived Doc. SearchBuy-from No. Of Archived Doc.FlowFieldInteger4
132Partner Type SearchPartner TypeNormalOption4Partner Typeint
Available options are:
  • ” “
  • “Company”
  • “Person”
133Intrastat Partner Type SearchIntrastat Partner TypeNormalOption4Intrastat Partner Typeint
Available options are:
  • ” “
  • “Company”
  • “Person”
134Exclude from Pmt. Practices SearchExclude from Payment PracticesNormalBoolean4Exclude from Pmt_ Practicestinyint
135Company Size Code SearchCompany Size CodeNormalCode20Company Size Codenvarchar(40)
Key to join to the Company Size table.

Show/hide example query

SELECT
       [Vendor].[Company Size Code]
       ,[Company Size].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Company Size$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Company Size]
              ON
                     [Vendor].[Company Size Code] = [Company Size].[Code]
140Image SearchImageNormalMedia16Imageuniqueidentifier
150Privacy Blocked SearchPrivacy BlockedNormalBoolean4Privacy Blockedtinyint
160Disable Search by Name SearchDisable Search by NameNormalBoolean4Disable Search by Nametinyint
170Creditor No. SearchCreditor No.NormalCode20Creditor No_nvarchar(40)
175Allow Multiple Posting Groups SearchAllow Multiple Posting GroupsNormalBoolean4Allow Multiple Posting Groupstinyint
288Preferred Bank Account Code SearchPreferred Bank Account CodeNormalCode20Preferred Bank Account Codenvarchar(40)
720Coupled to CRM SearchCoupled to DataverseNormalBoolean4Coupled to CRMtinyint
721Coupled to Dataverse SearchCoupled to DataverseFlowFieldBoolean4
840Cash Flow Payment Terms Code SearchCash Flow Payment Terms CodeNormalCode10Cash Flow Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Vendor].[Cash Flow 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].[Cash Flow Payment Terms Code] = [Payment Terms].[Code]
5049Primary Contact No. SearchPrimary Contact No.NormalCode20Primary Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Vendor].[Primary Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Vendor].[Primary Contact No_] = [Contact].[No_]
5061Mobile Phone No. SearchMobile Phone No.NormalText30Mobile Phone No_nvarchar(60)
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Vendor].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Vendor].[Responsibility Center] = [Responsibility Center].[Code]
5701Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
5790Lead Time Calculation SearchLead Time CalculationNormalDateFormula32Lead Time Calculationvarchar(32)
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7177No. of Pstd. Receipts SearchNo. of Pstd. ReceiptsFlowFieldInteger4
7178No. of Pstd. Invoices SearchNo. of Pstd. InvoicesFlowFieldInteger4
7179No. of Pstd. Return Shipments SearchNo. of Pstd. Return ShipmentsFlowFieldInteger4
7180No. of Pstd. Credit Memos SearchNo. of Pstd. Credit MemosFlowFieldInteger4
7181Pay-to No. of Orders SearchPay-to No. of OrdersFlowFieldInteger4
7182Pay-to No. of Invoices SearchPay-to No. of InvoicesFlowFieldInteger4
7183Pay-to No. of Return Orders SearchPay-to No. of Return OrdersFlowFieldInteger4
7184Pay-to No. of Credit Memos SearchPay-to No. of Credit MemosFlowFieldInteger4
7185Pay-to No. of Pstd. Receipts SearchPay-to No. of Pstd. ReceiptsFlowFieldInteger4
7186Pay-to No. of Pstd. Invoices SearchPay-to No. of Pstd. InvoicesFlowFieldInteger4
7187Pay-to No. of Pstd. Return S. SearchNo. of Pstd. Return S.FlowFieldInteger4
7188Pay-to No. of Pstd. Cr. Memos SearchNo. of Pstd. Cr. MemosFlowFieldInteger4
7189No. of Quotes SearchNo. of QuotesFlowFieldInteger4
7190No. of Blanket Orders SearchNo. of Blanket OrdersFlowFieldInteger4
7191No. of Orders SearchNo. of OrdersFlowFieldInteger4
7192No. of Invoices SearchNo. of InvoicesFlowFieldInteger4
7193No. of Return Orders SearchNo. of Return OrdersFlowFieldInteger4
7194No. of Credit Memos SearchNo. of Credit MemosFlowFieldInteger4
7195No. of Order Addresses SearchNo. of Order AddressesFlowFieldInteger4
7196Pay-to No. of Quotes SearchPay-to No. of QuotesFlowFieldInteger4
7197Pay-to No. of Blanket Orders SearchPay-to No. of Blanket OrdersFlowFieldInteger4
7198No. of Incoming Documents SearchNo. of Incoming DocumentsFlowFieldInteger4
7600Base Calendar Code SearchBase Calendar CodeNormalCode10Base Calendar Codenvarchar(20)
Key to join to the Base Calendar table.

Show/hide example query

SELECT
       [Vendor].[Base Calendar Code]
       ,[Base Calendar].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
              ON
                     [Vendor].[Base Calendar Code] = [Base Calendar].[Code]
7601Document Sending Profile SearchDocument Sending ProfileNormalCode20Document Sending Profilenvarchar(40)
Key to join to the Document Sending Profile table.

Show/hide example query

SELECT
       [Vendor].[Document Sending Profile]
       ,[Document Sending Profile].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
              ON
                     [Vendor].[Document Sending Profile] = [Document Sending Profile].[Code]
7602Validate EU Vat Reg. No. SearchValidate EU VAT Reg. No.NormalBoolean4Validate EU Vat Reg_ No_tinyint
8000Id SearchIdNormalGUID16Iduniqueidentifier
8001Currency Id SearchCurrency IdNormalGUID16Currency Iduniqueidentifier
Key to join to the Currency table.

Show/hide example query

SELECT
       [Vendor].[Currency Id]
       ,[Currency].[$systemId]
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 Id] = [Currency].[$systemId]
8002Payment Terms Id SearchPayment Terms IdNormalGUID16Payment Terms Iduniqueidentifier
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Vendor].[Payment Terms Id]
       ,[Payment Terms].[$systemId]
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 Id] = [Payment Terms].[$systemId]
8003Payment Method Id SearchPayment Method IdNormalGUID16Payment Method Iduniqueidentifier
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Vendor].[Payment Method Id]
       ,[Payment Method].[$systemId]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Vendor].[Payment Method Id] = [Payment Method].[$systemId]
8510Over-Receipt Code SearchOver-Receipt CodeNormalCode20Over-Receipt Codenvarchar(40)
Key to join to the Over-Receipt Code table.

Show/hide example query

SELECT
       [Vendor].[Over-Receipt Code]
       ,[Over-Receipt Code].[Code]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code]
              ON
                     [Vendor].[Over-Receipt Code] = [Over-Receipt Code].[Code]
10004UPS Zone SearchUPS ZoneNormalCode2
10016Federal ID No. SearchFederal ID No.NormalText30
10017Bank Communication SearchBank CommunicationNormalOption4
10018Check Date Format SearchCheck Date FormatNormalOption4
10019Check Date Separator SearchCheck Date SeparatorNormalOption4
10020IRS 1099 Code SearchIRS 1099 CodeNormalCode10
10021Balance on Date SearchBalance on DateFlowFieldDecimal12
10022Balance on Date (LCY) SearchBalance on Date ($)FlowFieldDecimal12
10023RFC No. SearchRFC No.NormalCode13
10024CURP No. SearchCURP No.NormalCode18
10025State Inscription SearchState InscriptionNormalText30
10026FATCA filing requirement SearchFATCA filing requirementNormalBoolean4
14020Tax Identification Type SearchTax Identification TypeNormalOption4
27030DIOT Type of Operation SearchDIOT Type of OperationNormalOption4
27040DIOT-Type of Operation SearchDIOT Type of OperationNormalOption4
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
       [Vendor].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [User] AS [User]
              ON
                     [Vendor].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Vendor].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
LEFT JOIN
       [User] AS [User]
              ON
                     [Vendor].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Vendor table

CurrencyIC PartnerLanguageLocationPayment MethodPayment TermsPost CodeResponsibility CenterSalesperson/PurchaserSalesperson/PurchaserShipment MethodShipping AgentTax AreaTerritoryVendor Posting Group
Dynamics 365 BC Table ReferenceTablesCompany TablesVVendor

Leave a Reply

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