Statistical Acc. Journal Line #2631

Other table in Microsoft Dynamics 365 Business Central. 18 fields, 6 records in Cronus demo.

18
Fields
6
Records
3
Primary key
2
FlowFields
6
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Journal Template Name, Journal batch name, Line No..

All fields (18)

Statistical Acc. Journal Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Journal Template Name PK Code Normal
2 Journal batch name PK Code Normal
3 Line No. PK Integer Normal
7 Document No. Code Normal
10 Statistical Account No. Code Normal → Statistical Account #2632
11 Posting Date Date Normal
12 Description Text Normal
13 Amount Decimal Normal
14 Allocated Amt. ($) ⚡ FLOW Decimal FlowField
24 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
25 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
50 Statistical Account Name ⚡ FLOW Text FlowField
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
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 (4)

Tables referenced by fields on the Statistical Acc. Journal Line table through TableRelation properties.

Statistical Account
#2632 · Other · via Statistical Account No.
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID