EXR Top Vendor Report Buffer #4404

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: Vendor No., Amount ($), Period Start Date.

All fields (16)

EXR Top Vendor Report Buffer — FIELDS
NO.FIELDTYPECLASSRELATION
1 Vendor No. PK Code Normal → Vendor #23
2 Name Text Normal
10 Amount ($) PK Decimal Normal
12 Amount 2 ($) Decimal Normal
13 Ranking Based On Option Normal
44 Vendor Posting Group Code FlowFilter → Vendor Posting Group #93
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 Vendor Report Buffer table through TableRelation properties.

Vendor
#23 · Purchasing · via Vendor No.
Vendor Posting Group
#93 · Other · via Vendor Posting Group
Currency
#4 · General Ledger · via Currency Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Filter, Global Dimension 2 Filter