GPRMOpen – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables GGPRMOpen

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

Table Type: Company

Table Name: GPRMOpen
Database Table Name:

Table Number: 4066

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

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