Vendor Templ. – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVendor 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	20	Code	nvarchar(40)
2	Description	Description	Normal	Text	100	Description	nvarchar(200)
5	Address	Address	Normal	Text	100	Address	nvarchar(200)
6	Address 2	Address 2	Normal	Text	50	Address 2	nvarchar(100)
7	City	City	Normal	Text	30	City	nvarchar(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]
9	Phone No.	Phone No.	Normal	Text	30	Phone No_	nvarchar(60)
10	Telex No.	Telex No.	Normal	Text	20	Telex No_	nvarchar(40)
14	Our Account No.	Our Account No.	Normal	Text	20	Our Account No_	nvarchar(40)
15	Territory Code	Territory Code	Normal	Code	10	Territory Code	nvarchar(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]
16	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(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]
17	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(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]
19	Budgeted Amount	Budgeted Amount	Normal	Decimal	12	Budgeted Amount	decimal(38,38)
21	Vendor Posting Group	Vendor Posting Group	Normal	Code	20	Vendor Posting Group	nvarchar(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]
22	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
24	Language Code	Language Code	Normal	Code	10	Language Code	nvarchar(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]
26	Statistics Group	Statistics Group	Normal	Integer	4	Statistics Group	int
27	Payment Terms Code	Payment Terms Code	Normal	Code	10	Payment Terms Code	nvarchar(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]
28	Fin. Charge Terms Code	Fin. Charge Terms Code	Normal	Code	10	Fin_ Charge Terms Code	nvarchar(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]
29	Purchaser Code	Purchaser Code	Normal	Code	20	Purchaser Code	nvarchar(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]
30	Shipment Method Code	Shipment Method Code	Normal	Code	10	Shipment Method Code	nvarchar(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]
31	Shipping Agent Code	Shipping Agent Code	Normal	Code	10	Shipping Agent Code	nvarchar(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]
33	Invoice Disc. Code	Invoice Disc. Code	Normal	Code	20	Invoice Disc_ Code	nvarchar(40)
35	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
39	Blocked	Blocked	Normal	Option	4	Blocked	int
	Available options are: ” “ “Payment” “All”
45	Pay-to Vendor No.	Pay-to Vendor No.	Normal	Code	20	Pay-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_]
46	Priority	Priority	Normal	Integer	4	Priority	int
47	Payment Method Code	Payment Method Code	Normal	Code	10	Payment Method Code	nvarchar(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]
80	Application Method	Application Method	Normal	Option	4	Application Method	int
	Available options are: “Manual” “Apply to Oldest”
82	Prices Including VAT	Prices Including Tax	Normal	Boolean	4	Prices Including VAT	tinyint
84	Fax No.	Fax No.	Normal	Text	30	Fax No_	nvarchar(60)
85	Telex Answer Back	Telex Answer Back	Normal	Text	20	Telex Answer Back	nvarchar(40)
86	VAT Registration No.	VAT Registration No.	Normal	Text	20	VAT Registration No_	nvarchar(40)
88	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(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]
90	GLN	GLN	Normal	Code	13	GLN	nvarchar(26)
91	Post Code	ZIP Code	Normal	Code	20	Post Code	nvarchar(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]
92	County	State	Normal	Text	30	County	nvarchar(60)
93	EORI Number	EORI Number	Normal	Text	40	EORI Number	nvarchar(80)
102	E-Mail	Email	Normal	Text	80	E-Mail	nvarchar(160)
103	Home Page	Home Page	Normal	Text	80	Home Page	nvarchar(160)
107	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(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]
108	Tax Area Code	Tax Area Code	Normal	Code	20	Tax Area Code	nvarchar(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]
109	Tax Liable	Tax Liable	Normal	Boolean	4	Tax Liable	tinyint
110	VAT Bus. Posting Group	VAT Bus. Posting Group	Normal	Code	20	VAT Bus_ Posting Group	nvarchar(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]
116	Block Payment Tolerance	Block Payment Tolerance	Normal	Boolean	4	Block Payment Tolerance	tinyint
124	Prepayment %	Prepayment %	Normal	Decimal	12	Prepayment _	decimal(38,38)
132	Partner Type	Partner Type	Normal	Option	4	Partner Type	int
	Available options are: ” “ “Company” “Person”
133	Intrastat Partner Type	Intrastat Partner Type	Normal	Option	4	Intrastat Partner Type	int
	Available options are: ” “ “Company” “Person”
150	Privacy Blocked	Privacy Blocked	Normal	Boolean	4	Privacy Blocked	tinyint
160	Disable Search by Name	Disable Search by Name	Normal	Boolean	4	Disable Search by Name	tinyint
170	Creditor No.	Creditor No.	Normal	Code	20	Creditor No_	nvarchar(40)
840	Cash Flow Payment Terms Code	Cash Flow Payment Terms Code	Normal	Code	10	Cash Flow Payment Terms Code	nvarchar(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]
5050	Contact Type	Contact Type	Normal	Option	4	Contact Type	int
	Available options are: “Company” “Person”
5061	Mobile Phone No.	Mobile Phone No.	Normal	Text	30	Mobile Phone No_	nvarchar(60)
5700	Responsibility Center	Responsibility Center	Normal	Code	10	Responsibility Center	nvarchar(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]
5701	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(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]
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
7600	Base Calendar Code	Base Calendar Code	Normal	Code	10	Base Calendar Code	nvarchar(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]
7601	Document Sending Profile	Document Sending Profile	Normal	Code	20	Document Sending Profile	nvarchar(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]
7602	Validate EU Vat Reg. No.	Validate EU VAT Reg. No.	Normal	Boolean	4	Validate EU Vat Reg_ No_	tinyint
8510	Over-Receipt Code	Over-Receipt Code	Normal	Code	20	Over-Receipt Code	nvarchar(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]
10004	UPS Zone	UPS Zone	Normal	Code	2
10016	Federal ID No.	Federal ID No.	Normal	Text	30
10017	Bank Communication	Bank Communication	Normal	Option	4
10018	Check Date Format	Check Date Format	Normal	Option	4
10019	Check Date Separator	Check Date Separator	Normal	Option	4
10020	IRS 1099 Code	IRS 1099 Code	Normal	Code	10
10023	RFC No.	RFC No.	Normal	Code	13
10024	CURP No.	CURP No.	Normal	Code	18
10025	State Inscription	State Inscription	Normal	Text	30
10026	FATCA filing requirement	FATCA filing requirement	Normal	Boolean	4
14020	Tax Identification Type	Tax Identification Type	Normal	Option	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Vendor Templ. table

Currency Language Location Payment Method Payment Terms Post Code Responsibility Center Salesperson/Purchaser Salesperson/Purchaser Shipment Method Shipping Agent Tax Area Territory Vendor Posting Group

Dynamics 365 BC Table Reference Tables Company Tables VVendor Templ.

Leave a Reply Cancel reply