GPRMHist – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPRMHist

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

Table Type: Company

Table Name: GPRMHist
Database Table Name:

Table Number: 4065

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

Show/hide columns in GPRMHist table

Field No.	Field Name	Field Caption	Class	Type	Length
1	CUSTNMBR	Customer Number	Normal	Text	16
	Key to join to the Customer table. Show/hide example query SELECT [GPRMHist].[] ,[Customer].[No_] FROM [] AS [GPRMHist] LEFT JOIN [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer] ON [GPRMHist].[] = [Customer].[No_]
2	CPRCSTNM	Corporate Customer Number	Normal	Text	16
3	DOCNUMBR	Document Number	Normal	Text	22
4	CHEKNMBR	Check Number	Normal	Text	22
5	BACHNUMB	Batch Number	Normal	Text	16
6	BCHSOURC	Batch Source	Normal	Text	16
7	TRXSORCE	TRX Source	Normal	Text	14
8	RMDTYPAL	RM Document Type-All	Normal	Option	4
9	DUEDATE	Due Date	Normal	Date	4
10	DOCDATE	Document Date	Normal	Date	4
11	POSTDATE	Post Date	Normal	Date	4
12	PSTUSRID	Post User ID	Normal	Text	16
13	GLPOSTDT	GL Posting Date	Normal	Date	4
14	LSTEDTDT	Last Edit Date	Normal	Date	4
15	LSTUSRED	Last User to Edit	Normal	Text	16
16	ORTRXAMT	Original Trx Amount	Normal	Decimal	12
17	CURTRXAM	Current Trx Amount	Normal	Decimal	12
18	SLSAMNT	Sales Amount	Normal	Decimal	12
19	COSTAMNT	Cost Amount	Normal	Decimal	12
20	FRTAMNT	Freight Amount	Normal	Decimal	12
21	MISCAMNT	Misc Amount	Normal	Decimal	12
22	TAXAMNT	Tax Amount	Normal	Decimal	12
23	COMDLRAM	Commission Dollar Amount	Normal	Decimal	12
24	CASHAMNT	Cash Amount	Normal	Decimal	12
25	DISTKNAM	Discount Taken Amount	Normal	Decimal	12
26	DISAVAMT	Discount Available Amount	Normal	Decimal	12
27	DISCRTND	Discount Returned	Normal	Decimal	12
28	DISCDATE	Discount Date	Normal	Date	4
29	DSCDLRAM	Discount Dollar Amount	Normal	Decimal	12
30	DSCPCTAM	Discount Percent Amount	Normal	Integer	4
31	WROFAMNT	Write Off Amount	Normal	Decimal	12
32	TRXDSCRN	Transaction Description	Normal	Text	32
33	CSPORNBR	Customer Purchase Order Number	Normal	Text	22
34	SLPRSNID	Salesperson ID	Normal	Text	16
35	SLSTERCD	Sales Territory Code	Normal	Text	16
36	DINVPDOF	Date Invoice Paid Off	Normal	Date	4
37	PPSAMDED	PPS Amount Deducted	Normal	Decimal	12
38	GSTDSAMT	GST Discount Amount	Normal	Decimal	12
39	DELETE1	Delete	Normal	Boolean	4
40	TAXSCHID	Tax Schedule ID	Normal	Text	16
41	SLSCHDID	Sales Schedule ID	Normal	Text	16
42	FRTSCHID	Freight Schedule ID	Normal	Text	16
43	MSCSCHID	Misc Schedule ID	Normal	Text	16
44	CURNCYID	Currency ID	Normal	Text	16
45	SHIPMTHD	Shipping Method	Normal	Text	16
46	PYMTRMID	Payment Terms ID	Normal	Text	22
47	TRDISAMT	Trade Discount Amount	Normal	Decimal	12
48	NOTEINDX	Note Index	Normal	Decimal	12
49	VOIDSTTS	Void Status	Normal	Option	4
50	VOIDDATE	Void Date	Normal	Date	4
51	BALFWDNM	Balance Forward Number	Normal	Text	22
52	CSHRCTYP	Cash Receipt Type	Normal	Option	4
53	Tax_Date	Tax Date	Normal	Date	4
54	APLYWITH	Apply Withholding	Normal	Boolean	4
55	SALEDATE	Sale Date	Normal	Date	4
56	CORRCTN	Correction	Normal	Boolean	4
57	SIMPLIFD	Simplified	Normal	Boolean	4
58	Electronic	Electronic	Normal	Boolean	4
59	ECTRX	EC Transaction	Normal	Boolean	4
60	BKTSLSAM	Backout Sales Amount	Normal	Decimal	12
61	BackoutTradeDisc	Backout Trade Discount Amount	Normal	Decimal	12
62	BKTFRTAM	Backout Freight Amount	Normal	Decimal	12
63	BKTMSCAM	Backout Misc Amount	Normal	Decimal	12
64	Factoring	Factoring	Normal	Boolean	4
65	DIRECTDEBIT	Direct Debit	Normal	Boolean	4
66	ADRSCODE	Address Code	Normal	Text	16
67	EFTFLAG	EFT Flag	Normal	Boolean	4
68	DEX_ROW_TS	DEX_ROW_TS	Normal	DateTime	8
69	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 [GPRMHist].[] ,[User].[User Security ID] FROM [] AS [GPRMHist] LEFT JOIN [User] AS [User] ON [GPRMHist].[] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16