GPPOPPOHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPPOPPOHist

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

Table Type: Company

Table Name: GPPOPPOHist
Database Table Name:

Table Number: 4057

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

Show/hide columns in GPPOPPOHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	PONUMBER	PO Number	Normal	Text	18
2	POSTATUS	PO Status	Normal	Option	4
3	STATGRP	Status Group	Normal	Option	4
4	POTYPE	PO Type	Normal	Option	4
5	USER2ENT	User To Enter	Normal	Text	16
6	CONFIRM1	Confirm With	Normal	Text	22
7	DOCDATE	Document Date	Normal	Date	4
8	LSTEDTDT	Last Edit Date	Normal	Date	4
9	LSTPRTDT	Last Printed Date	Normal	Date	4
10	PRMDATE	Promised Date	Normal	Date	4
11	PRMSHPDTE	Promised Ship Date	Normal	Date	4
12	REQDATE	Required Date	Normal	Date	4
13	REQTNDT	Requisition Date	Normal	Date	4
14	SHIPMTHD	Shipping Method	Normal	Text	16
15	TXRGNNUM	Tax Registration Number	Normal	Text	26
16	REMSUBTO	Remaining Subtotal	Normal	Decimal	12
17	SUBTOTAL	Subtotal	Normal	Decimal	12
18	TRDISAMT	Trade Discount Amount	Normal	Decimal	12
20	FRTAMNT	Freight Amount	Normal	Decimal	12
21	MSCCHAMT	Misc Charges Amount	Normal	Decimal	12
22	TAXAMNT	Tax Amount	Normal	Decimal	12
23	VENDORID	Vendor ID	Normal	Text	16
	Key to join to the Vendor table. Show/hide example query SELECT [GPPOPPOHist].[] ,[Vendor].[No_] FROM [] AS [GPPOPPOHist] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GPPOPPOHist].[] = [Vendor].[No_]
24	VENDNAME	Vendor Name	Normal	Text	66
25	MINORDER	Minimum Order	Normal	Decimal	12
26	VADCDPAD	Vendor Address Code – Purchase Address	Normal	Text	16
27	CMPANYID	Company ID	Normal	Integer	4
28	PRBTADCD	Primary Billto Address Code	Normal	Text	16
29	PRSTADCD	Primary Shipto Address Code	Normal	Text	16
30	CMPNYNAM	Company Name	Normal	Text	66
31	CONTACT	Contact	Normal	Text	62
32	ADDRESS1	Address 1	Normal	Text	62
33	ADDRESS2	Address 2	Normal	Text	62
34	ADDRESS3	Address 3	Normal	Text	62
35	CITY	City	Normal	Text	36
	Key to join to the Post Code table. Show/hide example query SELECT [GPPOPPOHist].[] ,[Post Code].[City] FROM [] AS [GPPOPPOHist] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [GPPOPPOHist].[] = [Post Code].[City]
36	STATE	State	Normal	Text	30
37	ZIPCODE	Zip Code	Normal	Text	12
38	CCode	Country Code	Normal	Text	8
39	COUNTRY	Country	Normal	Text	62
40	PHONE1	Phone 1	Normal	Text	22
41	PHONE2	Phone 2	Normal	Text	22
42	PHONE3	Phone 3	Normal	Text	22
43	FAX	Fax	Normal	Text	22
44	PYMTRMID	Payment Terms ID	Normal	Text	22
45	DSCDLRAM	Discount Dollar Amount	Normal	Decimal	12
46	DSCPCTAM	Discount Percent Amount	Normal	Integer	4
47	DISAMTAV	Discount Amount Available	Normal	Decimal	12
48	DISCDATE	Discount Date	Normal	Date	4
49	DUEDATE	Due Date	Normal	Date	4
50	CUSTNMBR	Customer Number	Normal	Text	16
	Key to join to the Customer table. Show/hide example query SELECT [GPPOPPOHist].[] ,[Customer].[No_] FROM [] AS [GPPOPPOHist] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [GPPOPPOHist].[] = [Customer].[No_]
51	TIMESPRT	Times Printed	Normal	Integer	4
52	CREATDDT	Created Date	Normal	Date	4
53	MODIFDT	Modified Date	Normal	Date	4
54	PONOTIDS_1	PO Note ID Array	Normal	Decimal	12
55	PONOTIDS_2	PO Note ID Array	Normal	Decimal	12
56	PONOTIDS_3	PO Note ID Array	Normal	Decimal	12
57	PONOTIDS_4	PO Note ID Array	Normal	Decimal	12
58	PONOTIDS_5	PO Note ID Array	Normal	Decimal	12
59	PONOTIDS_6	PO Note ID Array	Normal	Decimal	12
60	PONOTIDS_7	PO Note ID Array	Normal	Decimal	12
61	PONOTIDS_8	PO Note ID Array	Normal	Decimal	12
62	PONOTIDS_9	PO Note ID Array	Normal	Decimal	12
63	PONOTIDS_10	PO Note ID Array	Normal	Decimal	12
64	PONOTIDS_11	PO Note ID Array	Normal	Decimal	12
65	PONOTIDS_12	PO Note ID Array	Normal	Decimal	12
66	PONOTIDS_13	PO Note ID Array	Normal	Decimal	12
67	PONOTIDS_14	PO Note ID Array	Normal	Decimal	12
68	PONOTIDS_15	PO Note ID Array	Normal	Decimal	12
69	TRXSORCE	TRX Source	Normal	Text	14
70	COMMNTID	Comment ID	Normal	Text	16
71	CANCSUB	Canceled Subtotal	Normal	Decimal	12
72	CURNCYID	Currency ID	Normal	Text	16
73	CURRNIDX	Currency Index	Normal	Integer	4
74	RATETPID	Rate Type ID	Normal	Text	16
75	EXGTBLID	Exchange Table ID	Normal	Text	16
76	XCHGRATE	Exchange Rate	Normal	Decimal	12
77	EXCHDATE	Exchange Date	Normal	Date	4
78	TIME1	Time	Normal	DateTime	8
79	RATECALC	Rate Calc Method	Normal	Option	4
80	DENXRATE	Denomination Exchange Rate	Normal	Decimal	12
81	MCTRXSTT	MC Transaction State	Normal	Option	4
82	OREMSUBT	Originating Remaining Subtotal	Normal	Decimal	12
83	ORSUBTOT	Originating Subtotal	Normal	Decimal	12
84	Originating_Canceled_Sub	Originating Canceled Subtotal	Normal	Decimal	12
85	ORTDISAM	Originating Trade Discount Amount	Normal	Decimal	12
86	ORFRTAMT	Originating Freight Amount	Normal	Decimal	12
87	OMISCAMT	Originating Misc Charges Amount	Normal	Decimal	12
88	ORTAXAMT	Originating Tax Amount	Normal	Decimal	12
89	ORDDLRAT	Originating Discount Dollar Amount	Normal	Decimal	12
90	ODISAMTAV	Originating Discount Amount Available	Normal	Decimal	12
91	BUYERID	Buyer ID	Normal	Text	16
92	ALLOWSOCMTS	Allow SO Commitments	Normal	Boolean	4
93	DISGRPER	Discount Grace Period	Normal	Integer	4
94	DUEGRPER	Due Date Grace Period	Normal	Integer	4
95	Revision_Number	Revision Number	Normal	Integer	4
96	TAXSCHID	Tax Schedule ID	Normal	Text	16
97	TXSCHSRC	Tax Schedule Source	Normal	Option	4
98	BSIVCTTL	Based On Invoice Total	Normal	Boolean	4
99	Purchase_Freight_Taxable	Purchase Freight Taxable	Normal	Option	4
100	Purchase_Misc_Taxable	Purchase Misc Taxable	Normal	Option	4
101	FRTSCHID	Freight Schedule ID	Normal	Text	16
102	MSCSCHID	Misc Schedule ID	Normal	Text	16
103	FRTTXAMT	Freight Tax Amount	Normal	Decimal	12
104	ORFRTTAX	Originating Freight Tax Amount	Normal	Decimal	12
105	MSCTXAMT	Misc Tax Amount	Normal	Decimal	12
106	ORMSCTAX	Originating Misc Tax Amount	Normal	Decimal	12
107	BCKTXAMT	Backout Tax Amount	Normal	Decimal	12
108	OBTAXAMT	Originating Backout Tax Amount	Normal	Decimal	12
109	BackoutFreightTaxAmt	Backout Freight Tax Amount	Normal	Decimal	12
110	OrigBackoutFreightTaxAmt	Originating Backout Freight Tax Amount	Normal	Decimal	12
111	BackoutMiscTaxAmt	Backout Misc Tax Amount	Normal	Decimal	12
112	OrigBackoutMiscTaxAmt	Originating Backout Misc Tax Amount	Normal	Decimal	12
113	Flags	Flags	Normal	Integer	4
114	POPCONTNUM	POP Contract Number	Normal	Text	22
115	CONTENDDTE	Contract End Date	Normal	Date	4
116	CNTRLBLKTBY	Control Blanket By	Normal	Option	4
117	PURCHCMPNYNAM	Purchase Company Name	Normal	Text	66
118	PURCHCONTACT	Purchase Contact	Normal	Text	62
119	PURCHADDRESS1	Purchase Address 1	Normal	Text	62
120	PURCHADDRESS2	Purchase Address 2	Normal	Text	62
121	PURCHADDRESS3	Purchase Address 3	Normal	Text	62
122	PURCHCITY	Purchase City	Normal	Text	36
123	PURCHSTATE	Purchase State	Normal	Text	30
124	PURCHZIPCODE	Purchase Zip Code	Normal	Text	12
125	PURCHCCode	Purchase Country Code	Normal	Text	8
126	PURCHCOUNTRY	Purchase Country	Normal	Text	62
127	PURCHPHONE1	Purchase Phone 1	Normal	Text	22
128	PURCHPHONE2	Purchase Phone 2	Normal	Text	22
129	PURCHPHONE3	Purchase Phone 3	Normal	Text	22
130	PURCHFAX	Purchase Fax	Normal	Text	22
131	BLNKTLINEEXTQTYSUM	Total Blanket Line Ext Qty	Normal	Decimal	12
132	Workflow_Approval_Status	Workflow Approval Status	Normal	Option	4
133	Workflow_Priority	Workflow Priority	Normal	Option	4
134	Workflow_Status	Workflow Status	Normal	Option	4
135	Print_Phone_NumberGB	Print Phone Number GB	Normal	Option	4
136	PrepaymentAmount	Prepayment Amount	Normal	Decimal	12
137	OriginatingPrepaymentAmt	Originating Prepayment Amount	Normal	Decimal	12
138	DEX_ROW_TS	DEX_ROW_TS	Normal	DateTime	8
139	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 [GPPOPPOHist].[] ,[User].[User Security ID] FROM [] AS [GPPOPPOHist] LEFT JOIN [User] AS [User] ON [GPPOPPOHist].[] = [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 GGPPOPPOHist

Leave a Reply Cancel reply