GP Customer – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP Customer

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

Table Type: Company

Table Name: GP Customer
Database Table Name:

Table Number: 4093

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 Customer 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 Customer]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [GP Customer].[CUSTNMBR] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [GP Customer].[City] = [Post Code].[City]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Customer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP Customer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP Customer table

Field No.	Field Name	Field Caption	Class	Type	Length
1	CUSTNMBR	Customer Number	Normal	Text	75
	Key to join to the Customer table. Show/hide example query SELECT [GP Customer].[] ,[Customer].[No_] FROM [] AS [GP Customer] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [GP Customer].[] = [Customer].[No_]
2	CUSTNAME	Customer Name	Normal	Text	65
3	STMTNAME		Normal	Text	65
4	ADDRESS1	Address	Normal	Text	61
5	ADDRESS2	Address 2	Normal	Text	61
6	CITY	City	Normal	Text	35
	Key to join to the Post Code table. Show/hide example query SELECT [GP Customer].[] ,[Post Code].[City] FROM [] AS [GP Customer] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GP Customer].[] = [Post Code].[City]
7	CNTCPRSN	Contact	Normal	Text	61
8	PHONE1	Phone No.	Normal	Text	21
9	SALSTERR	Sales Territory	Normal	Text	15
10	CRLMTAMT	Credit Limit Amount	Normal	Decimal	12
11	PYMTRMID	Payment Terms ID	Normal	Text	21
12	SLPRSNID	Salesperson Code	Normal	Text	15
13	SHIPMTHD	Shipment Method Code	Normal	Text	15
14	COUNTRY	Country	Normal	Text	61
15	AMOUNT	Amount	Normal	Decimal	12
16	STMTCYCL	Statement Cycle	Normal	Boolean	4
17	FAX	Fax Number	Normal	Text	30
18	ZIPCODE	ZIP Code	Normal	Text	11
19	STATE	State	Normal	Text	29
20	INET1	Internet Information 1	Normal	Text	80
21	INET2	Internet Information 2	Normal	Text	80
22	TAXSCHID	Tax Schedule ID	Normal	Text	15
23	UPSZONE	UPS Zone	Normal	Text	3
24	TAXEXMT1	Tax Exempt 1	Normal	Text	25
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 Customer].[] ,[User].[User Security ID] FROM [] AS [GP Customer] LEFT JOIN [User] AS [User] ON [GP Customer].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16