GP POPPOHeader – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGP POPPOHeader

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

Table Type: Company

Table Name: GP POPPOHeader
Database Table Name:

Table Number: 40102

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

Show/hide columns in GP POPPOHeader 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
5	USER2ENT	USER2ENT	Normal	Text	16
6	CONFIRM1	CONFIRM1	Normal	Text	22
7	DOCDATE	DOCDATE	Normal	Date	4
8	LSTEDTDT	LSTEDTDT	Normal	Date	4
9	LSTPRTDT	LSTPRTDT	Normal	Date	4
10	PRMDATE	PRMDATE	Normal	Date	4
11	PRMSHPDTE	PRMSHPDTE	Normal	Date	4
12	REQDATE	REQDATE	Normal	Date	4
13	REQTNDT	REQTNDT	Normal	Date	4
14	SHIPMTHD	SHIPMTHD	Normal	Text	16
15	TXRGNNUM	TXRGNNUM	Normal	Text	26
16	REMSUBTO	REMSUBTO	Normal	Decimal	12
17	SUBTOTAL	SUBTOTAL	Normal	Decimal	12
18	TRDISAMT	TRDISAMT	Normal	Decimal	12
19	FRTAMNT	FRTAMNT	Normal	Decimal	12
20	MSCCHAMT	MSCCHAMT	Normal	Decimal	12
21	TAXAMNT	TAXAMNT	Normal	Decimal	12
22	VENDORID	VENDORID	Normal	Text	16
	Key to join to the Vendor table. Show/hide example query SELECT [GP POPPOHeader].[] ,[Vendor].[No_] FROM [] AS [GP POPPOHeader] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GP POPPOHeader].[] = [Vendor].[No_]
23	VENDNAME	VENDNAME	Normal	Text	66
24	MINORDER	MINORDER	Normal	Decimal	12
25	VADCDPAD	VADCDPAD	Normal	Text	16
26	CMPANYID	CMPANYID	Normal	Integer	4
27	PRBTADCD	PRBTADCD	Normal	Text	16
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
33	ADDRESS3	ADDRESS3	Normal	Text	62
34	CITY	CITY	Normal	Text	36
	Key to join to the Post Code table. Show/hide example query SELECT [GP POPPOHeader].[] ,[Post Code].[City] FROM [] AS [GP POPPOHeader] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GP POPPOHeader].[] = [Post Code].[City]
35	STATE	STATE	Normal	Text	30
36	ZIPCODE	ZIPCODE	Normal	Text	12
37	CCode	CCode	Normal	Text	8
38	COUNTRY	COUNTRY	Normal	Text	62
39	PHONE1	PHONE1	Normal	Text	22
40	PHONE2	PHONE2	Normal	Text	22
41	PHONE3	PHONE3	Normal	Text	22
42	FAX	FAX	Normal	Text	22
43	PYMTRMID	PYMTRMID	Normal	Text	22
44	DSCDLRAM	DSCDLRAM	Normal	Decimal	12
45	DSCPCTAM	DSCPCTAM	Normal	Integer	4
46	DISAMTAV	DISAMTAV	Normal	Decimal	12
47	DISCDATE	DISCDATE	Normal	Date	4
48	DUEDATE	DUEDATE	Normal	Date	4
49	TRDPCTPR	TRDPCTPR	Normal	Text	25
50	CUSTNMBR	CUSTNMBR	Normal	Text	16
	Key to join to the Customer table. Show/hide example query SELECT [GP POPPOHeader].[] ,[Customer].[No_] FROM [] AS [GP POPPOHeader] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [GP POPPOHeader].[] = [Customer].[No_]
51	TIMESPRT	TIMESPRT	Normal	Integer	4
52	CREATDDT	CREATDDT	Normal	Date	4
53	MODIFDT	MODIFDT	Normal	Date	4
54	PONOTIDS_1	PONOTIDS_1	Normal	Decimal	12
55	PONOTIDS_2	PONOTIDS_2	Normal	Decimal	12
56	PONOTIDS_3	PONOTIDS_3	Normal	Decimal	12
57	PONOTIDS_4	PONOTIDS_4	Normal	Decimal	12
58	PONOTIDS_5	PONOTIDS_5	Normal	Decimal	12
59	PONOTIDS_6	PONOTIDS_6	Normal	Decimal	12
60	PONOTIDS_7	PONOTIDS_7	Normal	Decimal	12
61	PONOTIDS_8	PONOTIDS_8	Normal	Decimal	12
62	PONOTIDS_9	PONOTIDS_9	Normal	Decimal	12
63	PONOTIDS_10	PONOTIDS_10	Normal	Decimal	12
64	PONOTIDS_11	PONOTIDS_11	Normal	Decimal	12
65	PONOTIDS_12	PONOTIDS_12	Normal	Decimal	12
66	PONOTIDS_13	PONOTIDS_13	Normal	Decimal	12
67	PONOTIDS_14	PONOTIDS_14	Normal	Decimal	12
68	PONOTIDS_15	PONOTIDS_15	Normal	Decimal	12
69	COMMNTID	COMMNTID	Normal	Text	16
70	CANCSUB	CANCSUB	Normal	Decimal	12
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
77	TIME1	TIME1	Normal	Date	4
78	RATECALC	RATECALC	Normal	Integer	4
79	DENXRATE	DENXRATE	Normal	Decimal	12
80	MCTRXSTT	MCTRXSTT	Normal	Integer	4
81	OREMSUBT	OREMSUBT	Normal	Decimal	12
82	ORSUBTOT	ORSUBTOT	Normal	Decimal	12
83	Originating_Canceled_Sub	Originating_Canceled_Sub	Normal	Decimal	12
84	ORTDISAM	ORTDISAM	Normal	Decimal	12
85	ORFRTAMT	ORFRTAMT	Normal	Decimal	12
86	OMISCAMT	OMISCAMT	Normal	Decimal	12
87	ORTAXAMT	ORTAXAMT	Normal	Decimal	12
88	ORDDLRAT	ORDDLRAT	Normal	Decimal	12
89	ODISAMTAV	ODISAMTAV	Normal	Decimal	12
90	BUYERID	BUYERID	Normal	Text	16
91	ONORDAMT	ONORDAMT	Normal	Decimal	12
92	ORORDAMT	ORORDAMT	Normal	Decimal	12
93	HOLD	HOLD	Normal	Boolean	4
94	ONHOLDDATE	ONHOLDDATE	Normal	Date	4
95	ONHOLDBY	ONHOLDBY	Normal	Text	16
96	HOLDREMOVEDATE	HOLDREMOVEDATE	Normal	Date	4
97	HOLDREMOVEBY	HOLDREMOVEBY	Normal	Text	16
98	ALLOWSOCMTS	ALLOWSOCMTS	Normal	Boolean	4
99	DISGRPER	DISGRPER	Normal	Integer	4
100	DUEGRPER	DUEGRPER	Normal	Integer	4
101	Revision_Number	Revision_Number	Normal	Integer	4
102	Change_Order_Flag	Change_Order_Flag	Normal	Integer	4
103	PO_Field_Changes	PO_Field_Changes	Normal	BLOB	8
104	PO_Status_Orig	PO_Status_Orig	Normal	Option	4
105	TAXSCHID	TAXSCHID	Normal	Text	16
106	TXSCHSRC	TXSCHSRC	Normal	Integer	4
107	TXENGCLD	TXENGCLD	Normal	Boolean	4
108	BSIVCTTL	BSIVCTTL	Normal	Boolean	4
109	Purchase_Freight_Taxable	Purchase_Freight_Taxable	Normal	Option	4
110	Purchase_Misc_Taxable	Purchase_Misc_Taxable	Normal	Option	4
111	FRTSCHID	FRTSCHID	Normal	Text	16
112	MSCSCHID	MSCSCHID	Normal	Text	16
113	FRTTXAMT	FRTTXAMT	Normal	Decimal	12
114	ORFRTTAX	ORFRTTAX	Normal	Decimal	12
115	MSCTXAMT	MSCTXAMT	Normal	Decimal	12
116	ORMSCTAX	ORMSCTAX	Normal	Decimal	12
117	BCKTXAMT	BCKTXAMT	Normal	Decimal	12
118	OBTAXAMT	OBTAXAMT	Normal	Decimal	12
119	BackoutFreightTaxAmt	BackoutFreightTaxAmt	Normal	Decimal	12
120	OrigBackoutFreightTaxAmt	OrigBackoutFreightTaxAmt	Normal	Decimal	12
121	BackoutMiscTaxAmt	BackoutMiscTaxAmt	Normal	Decimal	12
122	OrigBackoutMiscTaxAmt	OrigBackoutMiscTaxAmt	Normal	Decimal	12
123	Flags	Flags	Normal	Integer	4
124	BackoutTradeDiscTax	BackoutTradeDiscTax	Normal	Decimal	12
125	OrigBackoutTradeDiscTax	OrigBackoutTradeDiscTax	Normal	Decimal	12
126	POPCONTNUM	POPCONTNUM	Normal	Text	22
127	CONTENDDTE	CONTENDDTE	Normal	Date	4
128	CNTRLBLKTBY	CNTRLBLKTBY	Normal	Integer	4
129	PURCHCMPNYNAM	PURCHCMPNYNAM	Normal	Text	66
130	PURCHCONTACT	PURCHCONTACT	Normal	Text	62
131	PURCHADDRESS1	PURCHADDRESS1	Normal	Text	62
132	PURCHADDRESS2	PURCHADDRESS2	Normal	Text	62
133	PURCHADDRESS3	PURCHADDRESS3	Normal	Text	62
134	PURCHCITY	PURCHCITY	Normal	Text	36
135	PURCHSTATE	PURCHSTATE	Normal	Text	30
136	PURCHZIPCODE	PURCHZIPCODE	Normal	Text	12
137	PURCHCCode	PURCHCCode	Normal	Text	8
138	PURCHCOUNTRY	PURCHCOUNTRY	Normal	Text	62
139	PURCHPHONE1	PURCHPHONE1	Normal	Text	22
140	PURCHPHONE2	PURCHPHONE2	Normal	Text	22
141	PURCHPHONE3	PURCHPHONE3	Normal	Text	22
142	PURCHFAX	PURCHFAX	Normal	Text	22
143	BLNKTLINEEXTQTYSUM	BLNKTLINEEXTQTYSUM	Normal	Decimal	12
144	CBVAT	CBVAT	Normal	Boolean	4
145	Workflow_Approval_Status	Workflow_Approval_Status	Normal	Option	4
146	Workflow_Priority	Workflow_Priority	Normal	Option	4
147	Workflow_Status	Workflow_Status	Normal	Option	4
148	Print_Phone_NumberGB	Print_Phone_NumberGB	Normal	Integer	4
149	PrepaymentAmount	PrepaymentAmount	Normal	Decimal	12
150	OriginatingPrepaymentAmt	OriginatingPrepaymentAmt	Normal	Decimal	12
151	DEX_ROW_TS	DEX_ROW_TS	Normal	DateTime	8
152	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 POPPOHeader].[] ,[User].[User Security ID] FROM [] AS [GP POPPOHeader] LEFT JOIN [User] AS [User] ON [GP POPPOHeader].[] = [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 POPPOHeader

Leave a Reply Cancel reply