Vendor Templ.

Dynamics 365 BC Table ReferenceTablesCompany TablesVVendor 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

   [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 _]
   ,[Partner Type]
   ,[Intrastat Partner Type]
   ,[Privacy Blocked]
   ,[Disable Search by Name]
   ,[Creditor No_]
   ,[Cash Flow Payment Terms Code]
   ,[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]
   ,[$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_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Vendor Templ.].[City] = [Post Code].[City]
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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Templ.].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Vendor Templ.].[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 Templ.].[Vendor Posting Group] = [Vendor Posting Group].[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_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Vendor Templ.].[Purchaser Code] = [Salesperson/Purchaser].[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$ext] AS [Shipping Agent]
      ON
         [Vendor Templ.].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Vendor Templ.].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Vendor Templ.].[Post Code] = [Post Code].[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_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Vendor Templ.].[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 Templ.].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Vendor Templ.].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
      ON
         [Vendor Templ.].[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 Templ.].[Document Sending Profile] = [Document Sending Profile].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code]
      ON
         [Vendor Templ.].[Over-Receipt Code] = [Over-Receipt Code].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Vendor Templ.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Vendor Templ.].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Vendor Templ. table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode20Codenvarchar(40)
2Description SearchDescriptionNormalText100Descriptionnvarchar(200)
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 Templ.].[City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Vendor Templ.].[City] = [Post Code].[City]
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 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]
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 Templ.].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Vendor Templ.].[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 Templ.].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Vendor Templ.].[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 Templ.].[Vendor Posting Group]
       ,[Vendor Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
              ON
                     [Vendor Templ.].[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 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]
24Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(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]
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 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]
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 Templ.].[Fin_ Charge Terms Code]
       ,[Finance Charge Terms].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Finance Charge Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Finance Charge Terms]
              ON
                     [Vendor Templ.].[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 Templ.].[Purchaser Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Vendor Templ.].[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 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]
31Shipping Agent Code SearchShipping Agent CodeNormalCode10Shipping Agent Codenvarchar(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$ext] AS [Shipping Agent]
              ON
                     [Vendor Templ.].[Shipping Agent Code] = [Shipping Agent].[Code]
33Invoice Disc. Code SearchInvoice Disc. CodeNormalCode20Invoice Disc_ Codenvarchar(40)
35Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(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]
39Blocked SearchBlockedNormalOption4Blockedint
Available options are:
  • ” “
  • “Payment”
  • “All”
45Pay-to Vendor No. SearchPay-to Vendor No.NormalCode20Pay-to Vendor No_nvarchar(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_]
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 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$ext] AS [Payment Method]
              ON
                     [Vendor Templ.].[Payment Method Code] = [Payment Method].[Code]
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. SearchVAT 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 Templ.].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Vendor Templ.].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
90GLN SearchGLNNormalCode13GLNnvarchar(26)
91Post Code SearchZIP CodeNormalCode20Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Vendor Templ.].[Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Vendor Templ.].[Post Code] = [Post Code].[Code]
92County SearchStateNormalText30Countynvarchar(60)
93EORI Number SearchEORI NumberNormalText40EORI Numbernvarchar(80)
102E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
103Home Page SearchHome PageNormalText80Home Pagenvarchar(160)
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Vendor Templ.].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Vendor Templ.].[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 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]
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 Templ.].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Vendor Templ.].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
116Block Payment Tolerance SearchBlock Payment ToleranceNormalBoolean4Block Payment Tolerancetinyint
124Prepayment % SearchPrepayment %NormalDecimal12Prepayment _decimal(38,38)
132Partner Type SearchPartner TypeNormalOption4Partner Typeint
Available options are:
  • ” “
  • “Company”
  • “Person”
133Intrastat Partner Type SearchIntrastat Partner TypeNormalOption4Intrastat Partner Typeint
Available options are:
  • ” “
  • “Company”
  • “Person”
150Privacy Blocked SearchPrivacy BlockedNormalBoolean4Privacy Blockedtinyint
160Disable Search by Name SearchDisable Search by NameNormalBoolean4Disable Search by Nametinyint
170Creditor No. SearchCreditor No.NormalCode20Creditor No_nvarchar(40)
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 Templ.].[Cash Flow 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.].[Cash Flow Payment Terms Code] = [Payment Terms].[Code]
5050Contact Type SearchContact TypeNormalOption4Contact Typeint
Available options are:
  • “Company”
  • “Person”
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 Templ.].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Vendor Templ.].[Responsibility Center] = [Responsibility Center].[Code]
5701Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7600Base Calendar Code SearchBase Calendar CodeNormalCode10Base Calendar Codenvarchar(20)
Key to join to the Base Calendar table.

Show/hide example query

SELECT
       [Vendor Templ.].[Base Calendar Code]
       ,[Base Calendar].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
              ON
                     [Vendor Templ.].[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 Templ.].[Document Sending Profile]
       ,[Document Sending Profile].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Document Sending Profile$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Document Sending Profile]
              ON
                     [Vendor Templ.].[Document Sending Profile] = [Document Sending Profile].[Code]
7602Validate EU Vat Reg. No. SearchValidate EU VAT Reg. No.NormalBoolean4Validate EU Vat Reg_ No_tinyint
8510Over-Receipt Code SearchOver-Receipt CodeNormalCode20Over-Receipt Codenvarchar(40)
Key to join to the Over-Receipt Code table.

Show/hide example query

SELECT
       [Vendor Templ.].[Over-Receipt Code]
       ,[Over-Receipt Code].[Code]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [CRONUS UK Ltd_$Over-Receipt Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Over-Receipt Code]
              ON
                     [Vendor Templ.].[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
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
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 Templ.].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [User] AS [User]
              ON
                     [Vendor Templ.].[$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 Templ.].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Vendor Templ_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Templ.]
LEFT JOIN
       [User] AS [User]
              ON
                     [Vendor Templ.].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Vendor Templ. table

CurrencyLanguageLocationPayment MethodPayment TermsPost CodeResponsibility CenterSalesperson/PurchaserSalesperson/PurchaserShipment MethodShipping AgentTax AreaTerritoryVendor Posting Group
Dynamics 365 BC Table ReferenceTablesCompany TablesVVendor Templ.

Leave a Reply

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