Vendor – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables VVendor

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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	No.	No.	Normal	Code	20	No_	nvarchar(40)
2	Name	Name	Normal	Text	100	Name	nvarchar(200)
3	Search Name	Search Name	Normal	Code	100	Search Name	nvarchar(200)
4	Name 2	Name 2	Normal	Text	50	Name 2	nvarchar(100)
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].[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]
8	Contact	Contact	Normal	Text	100	Contact	nvarchar(200)
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].[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]
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].[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]
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].[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]
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].[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]
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].[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]
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].[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]
25	Registration Number	Registration No.	Normal	Text	50	Registration Number	nvarchar(100)
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].[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]
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].[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]
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].[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]
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].[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]
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].[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]
33	Invoice Disc. Code	Invoice Disc. Code	Normal	Code	20	Invoice Disc_ Code	nvarchar(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]
35	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
38	Comment	Comment	FlowField	Boolean	4
39	Blocked	Blocked	Normal	Option	4	Blocked	int
	Available options are: ” “ “Payment” “All”
45	Pay-to Vendor No.	Vendor No.	Normal	Code	20	Pay-to Vendor No_	nvarchar(40)
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].[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]
48	Format Region	Format Region	Normal	Text	80	Format Region	nvarchar(160)
53	Last Modified Date Time	Last Modified Date Time	Normal	DateTime	8	Last Modified Date Time	datetime
54	Last Date Modified	Last Date Modified	Normal	Date	4	Last Date Modified	datetime
55	Date Filter	Date Filter	FlowFilter	Date	4
56	Global Dimension 1 Filter	Global Dimension 1 Filter	FlowFilter	Code	20
57	Global Dimension 2 Filter	Global Dimension 2 Filter	FlowFilter	Code	20
58	Balance	Balance	FlowField	Decimal	12
59	Balance (LCY)	Balance ($)	FlowField	Decimal	12
60	Net Change	Net Change	FlowField	Decimal	12
61	Net Change (LCY)	Net Change ($)	FlowField	Decimal	12
62	Purchases (LCY)	Purchases ($)	FlowField	Decimal	12
64	Inv. Discounts (LCY)	Inv. Discounts ($)	FlowField	Decimal	12
65	Pmt. Discounts (LCY)	Pmt. Discounts ($)	FlowField	Decimal	12
66	Balance Due	Balance Due	FlowField	Decimal	12
67	Balance Due (LCY)	Balance Due ($)	FlowField	Decimal	12
69	Payments	Payments	FlowField	Decimal	12
70	Invoice Amounts	Invoice Amounts	FlowField	Decimal	12
71	Cr. Memo Amounts	Cr. Memo Amounts	FlowField	Decimal	12
72	Finance Charge Memo Amounts	Finance Charge Memo Amounts	FlowField	Decimal	12
74	Payments (LCY)	Payments ($)	FlowField	Decimal	12
75	Inv. Amounts (LCY)	Inv. Amounts ($)	FlowField	Decimal	12
76	Cr. Memo Amounts (LCY)	Cr. Memo Amounts ($)	FlowField	Decimal	12
77	Fin. Charge Memo Amounts (LCY)	Fin. Charge Memo Amounts ($)	FlowField	Decimal	12
78	Outstanding Orders	Outstanding Orders	FlowField	Decimal	12
79	Amt. Rcd. Not Invoiced	Amt. Rcd. Not Invoiced	FlowField	Decimal	12
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.	Tax 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].[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]
89	Picture	Picture	Normal	BLOB	8	Picture	image
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].[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]
92	County	State	Normal	Text	30	County	nvarchar(60)
93	EORI Number	EORI Number	Normal	Text	40	EORI Number	nvarchar(80)
97	Debit Amount	Debit Amount	FlowField	Decimal	12
98	Credit Amount	Credit Amount	FlowField	Decimal	12
99	Debit Amount (LCY)	Debit Amount ($)	FlowField	Decimal	12
100	Credit Amount (LCY)	Credit Amount ($)	FlowField	Decimal	12
102	E-Mail	Email	Normal	Text	80	E-Mail	nvarchar(160)
103	Home Page	Home Page	Normal	Text	80	Home Page	nvarchar(160)
104	Reminder Amounts	Reminder Amounts	FlowField	Decimal	12
105	Reminder Amounts (LCY)	Reminder Amounts ($)	FlowField	Decimal	12
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].[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]
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].[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]
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].[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]
111	Currency Filter	Currency Filter	FlowFilter	Code	10
	Key to join to the Currency table. Show/hide example query SELECT [Vendor].[] ,[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]
113	Outstanding Orders (LCY)	Outstanding Orders ($)	FlowField	Decimal	12
114	Amt. Rcd. Not Invoiced (LCY)	Amt. Rcd. Not Invoiced ($)	FlowField	Decimal	12
116	Block Payment Tolerance	Block Payment Tolerance	Normal	Boolean	4	Block Payment Tolerance	tinyint
117	Pmt. Disc. Tolerance (LCY)	Pmt. Disc. Tolerance ($)	FlowField	Decimal	12
118	Pmt. Tolerance (LCY)	Pmt. Tolerance ($)	FlowField	Decimal	12
119	IC Partner Code	IC Partner Code	Normal	Code	20	IC Partner Code	nvarchar(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]
120	Refunds	Refunds	FlowField	Decimal	12
121	Refunds (LCY)	Refunds ($)	FlowField	Decimal	12
122	Other Amounts	Other Amounts	FlowField	Decimal	12
123	Other Amounts (LCY)	Other Amounts ($)	FlowField	Decimal	12
124	Prepayment %	Prepayment %	Normal	Decimal	12	Prepayment _	decimal(38,38)
125	Outstanding Invoices	Outstanding Invoices	FlowField	Decimal	12
126	Outstanding Invoices (LCY)	Outstanding Invoices ($)	FlowField	Decimal	12
130	Pay-to No. Of Archived Doc.	Pay-to No. Of Archived Doc.	FlowField	Integer	4
131	Buy-from No. Of Archived Doc.	Buy-from No. Of Archived Doc.	FlowField	Integer	4
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”
134	Exclude from Pmt. Practices	Exclude from Payment Practices	Normal	Boolean	4	Exclude from Pmt_ Practices	tinyint
135	Company Size Code	Company Size Code	Normal	Code	20	Company Size Code	nvarchar(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]
140	Image	Image	Normal	Media	16	Image	uniqueidentifier
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)
175	Allow Multiple Posting Groups	Allow Multiple Posting Groups	Normal	Boolean	4	Allow Multiple Posting Groups	tinyint
288	Preferred Bank Account Code	Preferred Bank Account Code	Normal	Code	20	Preferred Bank Account Code	nvarchar(40)
720	Coupled to CRM	Coupled to Dataverse	Normal	Boolean	4	Coupled to CRM	tinyint
721	Coupled to Dataverse	Coupled to Dataverse	FlowField	Boolean	4
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].[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]
5049	Primary Contact No.	Primary Contact No.	Normal	Code	20	Primary 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_]
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].[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]
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].[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]
5790	Lead Time Calculation	Lead Time Calculation	Normal	DateFormula	32	Lead Time Calculation	varchar(32)
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
7177	No. of Pstd. Receipts	No. of Pstd. Receipts	FlowField	Integer	4
7178	No. of Pstd. Invoices	No. of Pstd. Invoices	FlowField	Integer	4
7179	No. of Pstd. Return Shipments	No. of Pstd. Return Shipments	FlowField	Integer	4
7180	No. of Pstd. Credit Memos	No. of Pstd. Credit Memos	FlowField	Integer	4
7181	Pay-to No. of Orders	Pay-to No. of Orders	FlowField	Integer	4
7182	Pay-to No. of Invoices	Pay-to No. of Invoices	FlowField	Integer	4
7183	Pay-to No. of Return Orders	Pay-to No. of Return Orders	FlowField	Integer	4
7184	Pay-to No. of Credit Memos	Pay-to No. of Credit Memos	FlowField	Integer	4
7185	Pay-to No. of Pstd. Receipts	Pay-to No. of Pstd. Receipts	FlowField	Integer	4
7186	Pay-to No. of Pstd. Invoices	Pay-to No. of Pstd. Invoices	FlowField	Integer	4
7187	Pay-to No. of Pstd. Return S.	No. of Pstd. Return S.	FlowField	Integer	4
7188	Pay-to No. of Pstd. Cr. Memos	No. of Pstd. Cr. Memos	FlowField	Integer	4
7189	No. of Quotes	No. of Quotes	FlowField	Integer	4
7190	No. of Blanket Orders	No. of Blanket Orders	FlowField	Integer	4
7191	No. of Orders	No. of Orders	FlowField	Integer	4
7192	No. of Invoices	No. of Invoices	FlowField	Integer	4
7193	No. of Return Orders	No. of Return Orders	FlowField	Integer	4
7194	No. of Credit Memos	No. of Credit Memos	FlowField	Integer	4
7195	No. of Order Addresses	No. of Order Addresses	FlowField	Integer	4
7196	Pay-to No. of Quotes	Pay-to No. of Quotes	FlowField	Integer	4
7197	Pay-to No. of Blanket Orders	Pay-to No. of Blanket Orders	FlowField	Integer	4
7198	No. of Incoming Documents	No. of Incoming Documents	FlowField	Integer	4
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].[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]
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].[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]
7602	Validate EU Vat Reg. No.	Validate EU VAT Reg. No.	Normal	Boolean	4	Validate EU Vat Reg_ No_	tinyint
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
8001	Currency Id	Currency Id	Normal	GUID	16	Currency Id	uniqueidentifier
	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]
8002	Payment Terms Id	Payment Terms Id	Normal	GUID	16	Payment Terms Id	uniqueidentifier
	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]
8003	Payment Method Id	Payment Method Id	Normal	GUID	16	Payment Method Id	uniqueidentifier
	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]
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].[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]
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
10021	Balance on Date	Balance on Date	FlowField	Decimal	12
10022	Balance on Date (LCY)	Balance on Date ($)	FlowField	Decimal	12
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
27030	DIOT Type of Operation	DIOT Type of Operation	Normal	Option	4
27040	DIOT-Type of Operation	DIOT Type of Operation	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].[$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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Vendor table

Currency IC Partner 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

Leave a Reply Cancel reply