XPT / Schema / GPRMOpen

GPRMOpen #4066

Other table in Microsoft Dynamics 365 Business Central. 78 fields, 0 records in Cronus demo.

78
Fields
0
Records
3
Primary key
0
FlowFields
2
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Customer Number, Document Number, RM Document Type-All.

All fields (78)

GPRMOpen — FIELDS
NO.FIELDTYPECLASSRELATION
1 Customer Number PK Text Normal
2 Corporate Customer Number Text Normal
3 Document Number PK Text Normal
4 Check Number Text Normal
5 Batch Number Text Normal
6 Batch Source Text Normal
7 TRX Source Text Normal
8 RM Document Type-All PK Option Normal
9 Cash Receipt Type Option Normal
10 Checkbook ID Credit Card Text Normal
11 Checkbook ID Cash Text Normal
12 Checkbook ID Check Text Normal
13 Due Date Date Normal
14 Document Date Date Normal
15 Post Date Date Normal
16 Post User ID Text Normal
17 GL Posting Date Date Normal
18 Last Edit Date Date Normal
19 Last User to Edit Text Normal
20 Original Trx Amount Decimal Normal
21 Current Trx Amount Decimal Normal
22 Sales Amount Decimal Normal
23 Cost Amount Decimal Normal
24 Freight Amount Decimal Normal
25 Misc Amount Decimal Normal
26 Tax Amount Decimal Normal
27 Commission Dollar Amount Decimal Normal
28 Cash Amount Decimal Normal
29 Discount Taken Amount Decimal Normal
30 Discount Available Amount Decimal Normal
31 Discount Available Taken Decimal Normal
32 Discount Returned Decimal Normal
33 Discount Date Date Normal
34 Discount Dollar Amount Decimal Normal
35 Discount Percent Amount Integer Normal
36 Write Off Amount Decimal Normal
37 Transaction Description Text Normal
38 Customer Purchase Order Number Text Normal
39 Salesperson ID Text Normal
40 Sales Territory Code Text Normal
41 Date Invoice Paid Off Date Normal
42 PPS Amount Deducted Decimal Normal
43 GST Discount Amount Decimal Normal
44 Delete Boolean Normal
45 Aging Bucket Integer Normal
46 Void Status Option Normal
47 Void Date Date Normal
48 Tax Schedule ID Text Normal
49 Currency ID Text Normal
50 Payment Terms ID Text Normal
51 Shipping Method Text Normal
52 Trade Discount Amount Decimal Normal
53 Sales Schedule ID Text Normal
54 Freight Schedule ID Text Normal
55 Misc Schedule ID Text Normal
56 Note Index Decimal Normal
57 Tax Date Date Normal
58 Apply Withholding Boolean Normal
59 Sale Date Date Normal
60 Correction Boolean Normal
61 Simplified Boolean Normal
62 Electronic Boolean Normal
63 EC Transaction Boolean Normal
64 Backout Sales Amount Decimal Normal
65 Backout Freight Amount Decimal Normal
66 Backout Misc Amount Decimal Normal
67 Backout Trade Discount Amount Decimal Normal
68 Factoring Boolean Normal
69 Direct Debit Boolean Normal
70 Address Code Text Normal
71 EFT Flag Boolean Normal
72 DEX_ROW_TS DateTime Normal
73 DEX_ROW_ID Integer Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms