GP POP10100 – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP POP10100

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

Table Type: Company

Table Name: GP POP10100
Database Table Name:

Table Number: 40137

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

Show/hide columns in GP POP10100 table

Field No.	Field Name	Field Caption	Class	Type	Length
1	PONUMBER	PONUMBER	Normal	Text	18
2	POSTATUS	POSTATUS	Normal	Option	4
3	STATGRP	STATGRP	Normal	Integer	4
4	POTYPE	POTYPE	Normal	Option	4
7	DOCDATE	DOCDATE	Normal	Date	4
10	PRMDATE	PRMDATE	Normal	Date	4
14	SHIPMTHD	SHIPMTHD	Normal	Text	16
22	VENDORID	VENDORID	Normal	Text	16
	Key to join to the Vendor table. Show/hide example query SELECT [GP POP10100].[] ,[Vendor].[No_] FROM [] AS [GP POP10100] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GP POP10100].[] = [Vendor].[No_]
28	PRSTADCD	PRSTADCD	Normal	Text	16
29	CMPNYNAM	CMPNYNAM	Normal	Text	66
30	CONTACT	CONTACT	Normal	Text	62
31	ADDRESS1	ADDRESS1	Normal	Text	62
32	ADDRESS2	ADDRESS2	Normal	Text	62
34	CITY	CITY	Normal	Text	36
	Key to join to the Post Code table. Show/hide example query SELECT [GP POP10100].[] ,[Post Code].[City] FROM [] AS [GP POP10100] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GP POP10100].[] = [Post Code].[City]
35	STATE	STATE	Normal	Text	30
36	ZIPCODE	ZIPCODE	Normal	Text	12
38	COUNTRY	COUNTRY	Normal	Text	62
43	PYMTRMID	PYMTRMID	Normal	Text	22
71	CURNCYID	CURNCYID	Normal	Text	16
72	CURRNIDX	CURRNIDX	Normal	Integer	4
73	RATETPID	RATETPID	Normal	Text	16
74	EXGTBLID	EXGTBLID	Normal	Text	16
75	XCHGRATE	XCHGRATE	Normal	Decimal	12
76	EXCHDATE	EXCHDATE	Normal	Date	4
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 POP10100].[] ,[User].[User Security ID] FROM [] AS [GP POP10100] LEFT JOIN [User] AS [User] ON [GP POP10100].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16