GP PM00204 – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP PM00204

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

Table Type: Company

Table Name: GP PM00204
Database Table Name:

Table Number: 40139

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

Show/hide columns in GP PM00204 table

Field No.	Field Name	Field Caption	Class	Type	Length
1	VENDORID	VENDORID	Normal	Text	15
	Key to join to the Vendor table. Show/hide example query SELECT [GP PM00204].[] ,[Vendor].[No_] FROM [] AS [GP PM00204] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GP PM00204].[] = [Vendor].[No_]
2	TEN99TYPE	TEN99TYPE	Normal	Integer	4
3	YEAR1	YEAR1	Normal	Integer	4
4	PERIODID	PERIODID	Normal	Integer	4
5	TEN99BOXNUMBER	TEN99BOXNUMBER	Normal	Integer	4
6	TEN99AMNT	TEN99AMNT	Normal	Decimal	12
7	TEN99FRNORUSDTL	TEN99FRNORUSDTL	Normal	Text	41
8	TEN99STATECD	TEN99STATECD	Normal	Text	3
9	TEN99STATIDNUM	TEN99STATIDNUM	Normal	Text	21
10	TEN99TAXEXMTCUSIPNUM	TEN99TAXEXMTCUSIPNUM	Normal	Text	13
11	TEN99DIRSALECB	TEN99DIRSALECB	Normal	Boolean	4
12	TEN99STATNMBR	TEN99STATNMBR	Normal	Text	21
13	TEN99FATCAFILEREQ	TEN99FATCAFILEREQ	Normal	Boolean	4
14	DEX_ROW_ID	DEX_ROW_ID	Normal	Integer	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 PM00204].[] ,[User].[User Security ID] FROM [] AS [GP PM00204] LEFT JOIN [User] AS [User] ON [GP PM00204].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16