GP PM00200 – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP PM00200

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

Table Type: Company

Table Name: GP PM00200
Database Table Name:

Table Number: 40113

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

Show/hide columns in GP PM00200 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 PM00200].[] ,[Vendor].[No_] FROM [] AS [GP PM00200] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GP PM00200].[] = [Vendor].[No_]
2	VENDNAME	VENDNAME	Normal	Text	65
3	VNDCHKNM	VNDCHKNM	Normal	Text	65
4	VENDSHNM	VENDSHNM	Normal	Text	15
5	VADDCDPR	VADDCDPR	Normal	Text	15
6	VADCDPAD	VADCDPAD	Normal	Text	15
7	VADCDSFR	VADCDSFR	Normal	Text	15
8	VADCDTRO	VADCDTRO	Normal	Text	15
9	VNDCLSID	VNDCLSID	Normal	Text	11
10	VNDCNTCT	VNDCNTCT	Normal	Text	61
11	ADDRESS1	ADDRESS1	Normal	Text	61
12	ADDRESS2	ADDRESS2	Normal	Text	61
13	ADDRESS3	ADDRESS3	Normal	Text	61
14	CITY	CITY	Normal	Text	35
	Key to join to the Post Code table. Show/hide example query SELECT [GP PM00200].[] ,[Post Code].[City] FROM [] AS [GP PM00200] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GP PM00200].[] = [Post Code].[City]
15	STATE	STATE	Normal	Text	29
16	ZIPCODE	ZIPCODE	Normal	Text	11
17	COUNTRY	COUNTRY	Normal	Text	61
18	PHNUMBR1	PHNUMBR1	Normal	Text	21
19	PHNUMBR2	PHNUMBR2	Normal	Text	21
20	PHONE3	PHONE3	Normal	Text	21
21	FAXNUMBR	FAXNUMBR	Normal	Text	21
22	UPSZONE	UPSZONE	Normal	Text	3
23	SHIPMTHD	SHIPMTHD	Normal	Text	15
24	TAXSCHID	TAXSCHID	Normal	Text	15
25	ACNMVNDR	ACNMVNDR	Normal	Text	21
26	TXIDNMBR	TXIDNMBR	Normal	Text	11
27	VENDSTTS	VENDSTTS	Normal	Integer	4
28	CURNCYID	CURNCYID	Normal	Text	15
29	TXRGNNUM	TXRGNNUM	Normal	Text	25
30	PARVENID	PARVENID	Normal	Text	15
31	TRDDISCT	TRDDISCT	Normal	Integer	4
32	TEN99TYPE	TEN99TYPE	Normal	Integer	4
33	TEN99BOXNUMBER	TEN99BOXNUMBER	Normal	Integer	4
34	MINORDER	MINORDER	Normal	Decimal	12
35	PYMTRMID	PYMTRMID	Normal	Text	21
36	MINPYTYP	MINPYTYP	Normal	Integer	4
37	MINPYPCT	MINPYPCT	Normal	Integer	4
38	MINPYDLR	MINPYDLR	Normal	Decimal	12
39	MXIAFVND	MXIAFVND	Normal	Integer	4
40	MAXINDLR	MAXINDLR	Normal	Decimal	12
41	COMMENT1	COMMENT1	Normal	Text	31
42	COMMENT2	COMMENT2	Normal	Text	31
43	USERDEF1	USERDEF1	Normal	Text	21
44	USERDEF2	USERDEF2	Normal	Text	21
45	CRLMTDLR	CRLMTDLR	Normal	Decimal	12
46	PYMNTPRI	PYMNTPRI	Normal	Text	3
47	KPCALHST	KPCALHST	Normal	Boolean	4
48	KGLDSTHS	KGLDSTHS	Normal	Boolean	4
49	KPERHIST	KPERHIST	Normal	Boolean	4
50	KPTRXHST	KPTRXHST	Normal	Boolean	4
51	HOLD	HOLD	Normal	Boolean	4
52	PTCSHACF	PTCSHACF	Normal	Integer	4
53	CREDTLMT	CREDTLMT	Normal	Integer	4
54	WRITEOFF	WRITEOFF	Normal	Integer	4
55	MXWOFAMT	MXWOFAMT	Normal	Decimal	12
56	SBPPSDED	SBPPSDED	Normal	Boolean	4
57	PPSTAXRT	PPSTAXRT	Normal	Integer	4
58	DXVARNUM	DXVARNUM	Normal	Text	25
59	CRTCOMDT	CRTCOMDT	Normal	DateTime	8
60	CRTEXPDT	CRTEXPDT	Normal	DateTime	8
61	RTOBUTKN	RTOBUTKN	Normal	Boolean	4
62	XPDTOBLG	XPDTOBLG	Normal	Boolean	4
63	PRSPAYEE	PRSPAYEE	Normal	Boolean	4
64	PMAPINDX	PMAPINDX	Normal	Integer	4
65	PMCSHIDX	PMCSHIDX	Normal	Integer	4
66	PMDAVIDX	PMDAVIDX	Normal	Integer	4
67	PMDTKIDX	PMDTKIDX	Normal	Integer	4
68	PMFINIDX	PMFINIDX	Normal	Integer	4
69	PMMSCHIX	PMMSCHIX	Normal	Integer	4
70	PMFRTIDX	PMFRTIDX	Normal	Integer	4
71	PMTAXIDX	PMTAXIDX	Normal	Integer	4
72	PMWRTIDX	PMWRTIDX	Normal	Integer	4
73	PMPRCHIX	PMPRCHIX	Normal	Integer	4
74	PMRTNGIX	PMRTNGIX	Normal	Integer	4
75	PMTDSCIX	PMTDSCIX	Normal	Integer	4
76	ACPURIDX	ACPURIDX	Normal	Integer	4
77	PURPVIDX	PURPVIDX	Normal	Integer	4
78	NOTEINDX	NOTEINDX	Normal	Decimal	12
79	CHEKBKID	CHEKBKID	Normal	Text	15
80	MODIFDT	MODIFDT	Normal	DateTime	8
81	CREATDDT	CREATDDT	Normal	DateTime	8
82	RATETPID	RATETPID	Normal	Text	15
83	Revalue_Vendor	Revalue_Vendor	Normal	Boolean	4
84	Post_Results_To	Post_Results_To	Normal	Integer	4
85	FREEONBOARD	FREEONBOARD	Normal	Integer	4
86	GOVCRPID	GOVCRPID	Normal	Text	31
87	GOVINDID	GOVINDID	Normal	Text	31
88	DISGRPER	DISGRPER	Normal	Integer	4
89	DUEGRPER	DUEGRPER	Normal	Integer	4
90	DOCFMTID	DOCFMTID	Normal	Text	15
91	TaxInvRecvd	TaxInvRecvd	Normal	Boolean	4
92	USERLANG	USERLANG	Normal	Integer	4
93	WithholdingType	WithholdingType	Normal	Integer	4
94	WithholdingFormType	WithholdingFormType	Normal	Integer	4
95	WithholdingEntityType	WithholdingEntityType	Normal	Integer	4
96	TaxFileNumMode	TaxFileNumMode	Normal	Integer	4
97	BRTHDATE	BRTHDATE	Normal	DateTime	8
98	LaborPmtType	LaborPmtType	Normal	Integer	4
99	CCode	CCode	Normal	Text	7
100	DECLID	DECLID	Normal	Text	15
101	CBVAT	CBVAT	Normal	Boolean	4
102	Workflow_Approval_Status	Workflow_Approval_Status	Normal	Integer	4
103	Workflow_Priority	Workflow_Priority	Normal	Integer	4
104	Workflow_Status	Workflow_Status	Normal	Integer	4
105	VADCD1099	VADCD1099	Normal	Text	15
106	ONEPAYPERVENDINV	ONEPAYPERVENDINV	Normal	Integer	4
107	DEX_ROW_TS	DEX_ROW_TS	Normal	DateTime	8
108	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 PM00200].[] ,[User].[User Security ID] FROM [] AS [GP PM00200] LEFT JOIN [User] AS [User] ON [GP PM00200].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16