GP PM00100 – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP PM00100

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

Table Type: Company

Table Name: GP PM00100
Database Table Name:

Table Number: 40112

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 PM00100 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 PM00100]
LEFT JOIN
   [User] AS [User]
      ON
         [GP PM00100].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [GP PM00100].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in GP PM00100 table

Field No.	Field Name	Field Caption	Class	Type	Length
1	VNDCLSID	VNDCLSID	Normal	Text	11
2	VNDCLDSC	VNDCLDSC	Normal	Text	31
3	DEFLTCLS	DEFLTCLS	Normal	Boolean	4
4	MXIAFVND	MXIAFVND	Normal	Integer	4
5	MXINVAMT	MXINVAMT	Normal	Decimal	12
6	WRITEOFF	WRITEOFF	Normal	Integer	4
7	CREDTLMT	CREDTLMT	Normal	Integer	4
8	TEN99TYPE	TEN99TYPE	Normal	Integer	4
9	PTCSHACF	PTCSHACF	Normal	Integer	4
10	MXWOFAMT	MXWOFAMT	Normal	Decimal	12
11	MINORDER	MINORDER	Normal	Decimal	12
12	CRLMTDLR	CRLMTDLR	Normal	Decimal	12
13	PYMNTPRI	PYMNTPRI	Normal	Text	3
14	SHIPMTHD	SHIPMTHD	Normal	Text	15
15	PYMTRMID	PYMTRMID	Normal	Text	21
16	MINPYTYP	MINPYTYP	Normal	Integer	4
17	MINPYDLR	MINPYDLR	Normal	Decimal	12
18	MINPYPCT	MINPYPCT	Normal	Integer	4
19	CURNCYID	CURNCYID	Normal	Text	15
20	TAXSCHID	TAXSCHID	Normal	Text	15
21	KPCALHST	KPCALHST	Normal	Boolean	4
22	KGLDSTHS	KGLDSTHS	Normal	Boolean	4
23	KPERHIST	KPERHIST	Normal	Boolean	4
24	KPTRXHST	KPTRXHST	Normal	Boolean	4
25	TRDDISCT	TRDDISCT	Normal	Integer	4
26	USERDEF1	USERDEF1	Normal	Text	21
27	USERDEF2	USERDEF2	Normal	Text	21
28	PMAPINDX	PMAPINDX	Normal	Integer	4
29	PMCSHIDX	PMCSHIDX	Normal	Integer	4
30	PMDAVIDX	PMDAVIDX	Normal	Integer	4
31	PMDTKIDX	PMDTKIDX	Normal	Integer	4
32	PMFINIDX	PMFINIDX	Normal	Integer	4
33	PMMSCHIX	PMMSCHIX	Normal	Integer	4
34	PMFRTIDX	PMFRTIDX	Normal	Integer	4
35	PMTAXIDX	PMTAXIDX	Normal	Integer	4
36	PMWRTIDX	PMWRTIDX	Normal	Integer	4
37	PMPRCHIX	PMPRCHIX	Normal	Integer	4
38	PMRTNGIX	PMRTNGIX	Normal	Integer	4
39	PMTDSCIX	PMTDSCIX	Normal	Integer	4
40	ACPURIDX	ACPURIDX	Normal	Integer	4
41	PURPVIDX	PURPVIDX	Normal	Integer	4
42	CHEKBKID	CHEKBKID	Normal	Text	15
43	MODIFDT	MODIFDT	Normal	DateTime	8
44	CREATDDT	CREATDDT	Normal	DateTime	8
45	RATETPID	RATETPID	Normal	Text	15
46	Revalue_Vendor	Revalue_Vendor	Normal	Boolean	4
47	Post_Results_To	Post_Results_To	Normal	Integer	4
48	FREEONBOARD	FREEONBOARD	Normal	Integer	4
49	DISGRPER	DISGRPER	Normal	Integer	4
50	DUEGRPER	DUEGRPER	Normal	Integer	4
51	TaxInvRecvd	TaxInvRecvd	Normal	Boolean	4
52	CBVAT	CBVAT	Normal	Boolean	4
53	ONEPAYPERVENDINV	ONEPAYPERVENDINV	Normal	Integer	4
54	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 PM00100].[] ,[User].[User Security ID] FROM [] AS [GP PM00100] LEFT JOIN [User] AS [User] ON [GP PM00100].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16

Dynamics 365 BC Table Reference Tables Company Tables GGP PM00100

Show/hide an example select of all columns

Show/hide an example select of all columns by name

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

Show/hide columns in GP PM00100 table

Show/hide example query

Leave a Reply Cancel reply