GP Vendor – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP Vendor

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

Table Type: Company

Table Name: GP Vendor
Database Table Name:

Table Number: 4096

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

Show/hide an example select of all columns

SELECT

   *

FROM

   []

Show/hide an example select of all columns by name

SELECT



FROM

   []

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [] AS [GP Vendor]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [GP Vendor].[VENDORID] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [GP Vendor].[City] = [Post Code].[City]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Vendor].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Vendor].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP Vendor table

Field No.	Field Name	Field Caption	Class	Type	Length
1	VENDORID	Vendor ID	Normal	Text	75
	Key to join to the Vendor table. Show/hide example query SELECT [GP Vendor].[] ,[Vendor].[No_] FROM [] AS [GP Vendor] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GP Vendor].[] = [Vendor].[No_]
2	VENDNAME	Vendor Name	Normal	Text	65
3	SEARCHNAME	Search Name	Normal	Text	65
4	VNDCHKNM	Vendor Check Name	Normal	Text	65
5	ADDRESS1	Address	Normal	Text	61
6	ADDRESS2	Address 2	Normal	Text	61
7	CITY	City	Normal	Text	35
	Key to join to the Post Code table. Show/hide example query SELECT [GP Vendor].[] ,[Post Code].[City] FROM [] AS [GP Vendor] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GP Vendor].[] = [Post Code].[City]
8	VNDCNTCT	Vendor Contact	Normal	Text	61
9	PHNUMBR1	Phone Number	Normal	Text	21
10	PYMTRMID	Payment Terms ID	Normal	Text	21
11	SHIPMTHD	Shipment Method Code	Normal	Text	15
12	COUNTRY	Country	Normal	Text	61
13	PYMNTPRI	Payment Priority	Normal	Text	3
14	AMOUNT	Amount	Normal	Decimal	12
15	FAXNUMBR	Fax Number	Normal	Text	30
16	ZIPCODE	ZIP Code	Normal	Text	11
17	STATE	State	Normal	Text	29
18	INET1	Internet Information 1	Normal	Text	200
19	INET2	Internet Information 2	Normal	Text	200
20	TAXSCHID	Tax Schedule ID	Normal	Text	15
21	UPSZONE	UPS Zone	Normal	Text	3
22	TXIDNMBR	Tax ID Number	Normal	Text	11
2000000000	$systemId	System ID	Normal	GUID	16
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8
2000000002	SystemCreatedBy	Created By	Normal	GUID	16
	Key to join to the User table. Show/hide example query SELECT [GP Vendor].[] ,[User].[User Security ID] FROM [] AS [GP Vendor] LEFT JOIN [User] AS [User] ON [GP Vendor].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16