EXR Top Customer Report Buffer #4405

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

16
Fields
0
Records
3
Primary key
0
FlowFields
7
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Customer No., Amount ($), Period Start Date.

All fields (16)

EXR Top Customer Report Buffer — FIELDS
NO.FIELDTYPECLASSRELATION
1 Customer No. PK Code Normal → Customer #18
2 Name Text Normal
10 Amount ($) PK Decimal Normal
12 Amount 2 ($) Decimal Normal
13 Ranking Based On Option Normal
44 Customer Posting Group Code FlowFilter → Customer Posting Group #92
45 Currency Code Code FlowFilter → Currency #4
46 Period Start Date PK Date Normal
100 Date Filter Date FlowFilter
101 Global Dimension 1 Filter Code FlowFilter → Dimension Value #349
102 Global Dimension 2 Filter Code FlowFilter → Dimension Value #349
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

Related tables (5)

Tables referenced by fields on the EXR Top Customer Report Buffer table through TableRelation properties.

Customer
#18 · Sales · via Customer No.
Customer Posting Group
#92 · Other · via Customer Posting Group
Currency
#4 · General Ledger · via Currency Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Filter, Global Dimension 2 Filter