GPPMHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPPMHist

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

Table Type: Company

Table Name: GPPMHist
Database Table Name:

Table Number: 4053

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

Show/hide columns in GPPMHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	VCHRNMBR	Voucher Number	Normal	Text	22
2	VENDORID	Vendor ID	Normal	Text	16
	Key to join to the Vendor table. Show/hide example query SELECT [GPPMHist].[] ,[Vendor].[No_] FROM [] AS [GPPMHist] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [GPPMHist].[] = [Vendor].[No_]
3	DOCTYPE	Document Type	Normal	Option	4
4	DOCDATE	Document Date	Normal	Date	4
5	DOCNUMBR	Document Number	Normal	Text	22
6	DOCAMNT	Document Amount	Normal	Decimal	12
7	CURTRXAM	Current Trx Amount	Normal	Decimal	12
8	DISTKNAM	Discount Taken Amount	Normal	Decimal	12
9	DISCAMNT	Discount Amount	Normal	Decimal	12
10	DSCDLRAM	Discount Dollar Amount	Normal	Decimal	12
11	BACHNUMB	Batch Number	Normal	Text	16
12	TRXSORCE	TRX Source	Normal	Text	14
13	BCHSOURC	Batch Source	Normal	Text	16
14	DISCDATE	Discount Date	Normal	Date	4
15	DUEDATE	Due Date	Normal	Date	4
16	PORDNMBR	Purchase Order Number	Normal	Text	22
17	TEN99AMNT	1099 Amount	Normal	Decimal	12
18	WROFAMNT	Write Off Amount	Normal	Decimal	12
19	DISAMTAV	Discount Amount Available	Normal	Decimal	12
20	TRXDSCRN	Transaction Description	Normal	Text	32
21	UN1099AM	Unapplied 1099 Amount	Normal	Decimal	12
22	BKTPURAM	Backout Purchases Amount	Normal	Decimal	12
23	BKTFRTAM	Backout Freight Amount	Normal	Decimal	12
24	BKTMSCAM	Backout Misc Amount	Normal	Decimal	12
25	VOIDED	Voided	Normal	Boolean	4
26	HOLD	Hold	Normal	Boolean	4
27	CHEKBKID	Checkbook ID	Normal	Text	16
28	DINVPDOF	Date Invoice Paid Off	Normal	Date	4
29	PPSAMDED	PPS Amount Deducted	Normal	Decimal	12
30	PPSTAXRT	PPS Tax Rate	Normal	Integer	4
31	PGRAMSBJ	Percent Of Gross Amount Subject	Normal	Integer	4
32	GSTDSAMT	GST Discount Amount	Normal	Decimal	12
33	POSTEDDT	Posted Date	Normal	Date	4
34	PTDUSRID	Posted User ID	Normal	Text	16
35	MODIFDT	Modified Date	Normal	Date	4
36	MDFUSRID	Modified User ID	Normal	Text	16
37	PYENTTYP	Payment Entry Type	Normal	Option	4
38	CARDNAME	Card Name	Normal	Text	16
39	PRCHAMNT	Purchases Amount	Normal	Decimal	12
40	TRDISAMT	Trade Discount Amount	Normal	Decimal	12
41	MSCCHAMT	Misc Charges Amount	Normal	Decimal	12
42	FRTAMNT	Freight Amount	Normal	Decimal	12
43	TAXAMNT	Tax Amount	Normal	Decimal	12
44	TTLPYMTS	Total Payments	Normal	Decimal	12
45	CURNCYID	Currency ID	Normal	Text	16
46	PYMTRMID	Payment Terms ID	Normal	Text	22
47	SHIPMTHD	Shipping Method	Normal	Text	16
48	TAXSCHID	Tax Schedule ID	Normal	Text	16
49	PCHSCHID	Purchase Schedule ID	Normal	Text	16
50	FRTSCHID	Freight Schedule ID	Normal	Text	16
51	MSCSCHID	Misc Schedule ID	Normal	Text	16
52	PSTGDATE	Posting Date	Normal	Date	4
53	DISAVTKN	Discount Available Taken	Normal	Decimal	12
54	CNTRLTYP	Control Type	Normal	Integer	4
55	NOTEINDX	Note Index	Normal	Decimal	12
56	PRCTDISC	Percent Discount	Normal	Integer	4
57	RETNAGAM	Retainage Amount	Normal	Decimal	12
58	VOIDPDATE	Void GL Posting Date	Normal	Date	4
59	ICTRX	IC TRX	Normal	Boolean	4
60	Tax_Date	Tax Date	Normal	Date	4
61	PRCHDATE	Purchase Date	Normal	Date	4
62	CORRCTN	Correction	Normal	Boolean	4
63	SIMPLIFD	Simplified	Normal	Boolean	4
64	APLYWITH	Apply Withholding	Normal	Boolean	4
65	Electronic	Electronic	Normal	Boolean	4
66	ECTRX	EC Transaction	Normal	Boolean	4
67	DocPrinted	DocPrinted	Normal	Boolean	4
68	TaxInvReqd	Tax Invoice Required	Normal	Boolean	4
69	VNDCHKNM	Vendor Check Name	Normal	Text	66
70	BackoutTradeDisc	Backout Trade Discount Amount	Normal	Decimal	12
71	CBVAT	Cash Based Tax	Normal	Boolean	4
72	VADCDTRO	Vendor Address Code – Remit To	Normal	Text	16
73	TEN99TYPE	1099 Type	Normal	Option	4
74	TEN99BOXNUMBER	1099 Box Number	Normal	Integer	4
75	PONUMBER	PO Number	Normal	Text	18
76	Workflow_Status	Workflow Status	Normal	Option	4
77	InvoiceReceiptDate	Invoice Receipt Date	Normal	Date	4
78	DEX_ROW_TS	DEX_ROW_TS	Normal	DateTime	8
79	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 [GPPMHist].[] ,[User].[User Security ID] FROM [] AS [GPPMHist] LEFT JOIN [User] AS [User] ON [GPPMHist].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16