XPT / Schema / GPRMHist

GPRMHist #4065

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

74
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 (74)

GPRMHist — 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 Due Date Date Normal
10 Document Date Date Normal
11 Post Date Date Normal
12 Post User ID Text Normal
13 GL Posting Date Date Normal
14 Last Edit Date Date Normal
15 Last User to Edit Text Normal
16 Original Trx Amount Decimal Normal
17 Current Trx Amount Decimal Normal
18 Sales Amount Decimal Normal
19 Cost Amount Decimal Normal
20 Freight Amount Decimal Normal
21 Misc Amount Decimal Normal
22 Tax Amount Decimal Normal
23 Commission Dollar Amount Decimal Normal
24 Cash Amount Decimal Normal
25 Discount Taken Amount Decimal Normal
26 Discount Available Amount Decimal Normal
27 Discount Returned Decimal Normal
28 Discount Date Date Normal
29 Discount Dollar Amount Decimal Normal
30 Discount Percent Amount Integer Normal
31 Write Off Amount Decimal Normal
32 Transaction Description Text Normal
33 Customer Purchase Order Number Text Normal
34 Salesperson ID Text Normal
35 Sales Territory Code Text Normal
36 Date Invoice Paid Off Date Normal
37 PPS Amount Deducted Decimal Normal
38 GST Discount Amount Decimal Normal
39 Delete Boolean Normal
40 Tax Schedule ID Text Normal
41 Sales Schedule ID Text Normal
42 Freight Schedule ID Text Normal
43 Misc Schedule ID Text Normal
44 Currency ID Text Normal
45 Shipping Method Text Normal
46 Payment Terms ID Text Normal
47 Trade Discount Amount Decimal Normal
48 Note Index Decimal Normal
49 Void Status Option Normal
50 Void Date Date Normal
51 Balance Forward Number Text Normal
52 Cash Receipt Type Option Normal
53 Tax Date Date Normal
54 Apply Withholding Boolean Normal
55 Sale Date Date Normal
56 Correction Boolean Normal
57 Simplified Boolean Normal
58 Electronic Boolean Normal
59 EC Transaction Boolean Normal
60 Backout Sales Amount Decimal Normal
61 Backout Trade Discount Amount Decimal Normal
62 Backout Freight Amount Decimal Normal
63 Backout Misc Amount Decimal Normal
64 Factoring Boolean Normal
65 Direct Debit Boolean Normal
66 Address Code Text Normal
67 EFT Flag Boolean Normal
68 DEX_ROW_TS DateTime Normal
69 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