G/L Account (Analysis View) #376

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

61
Fields
0
Records
2
Primary key
15
FlowFields
16
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: No., Account Source.

All fields (61)

G/L Account (Analysis View) — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
2 Name Text Normal
3 Search Name Code Normal
4 Account Type Option Normal
5 Account Source PK Option Normal
6 Global Dimension 1 Code Code Normal → Dimension Value #349
7 Global Dimension 2 Code Code Normal → Dimension Value #349
9 Income/Balance Option Normal
10 Debit/Credit Option Normal
11 No. 2 Code Normal
12 Comment ⚡ FLOW Boolean FlowField
13 Blocked Boolean Normal
14 Direct Posting Boolean Normal
16 Reconciliation Account Boolean Normal
17 New Page Boolean Normal
18 No. of Blank Lines Integer Normal
19 Indentation Integer Normal
26 Last Date Modified Date Normal
27 Cash Flow Forecast Filter Code FlowFilter → Cash Flow Forecast #840
28 Date Filter Date FlowFilter
29 Global Dimension 1 Filter Code FlowFilter → Dimension Value #349
30 Global Dimension 2 Filter Code FlowFilter → Dimension Value #349
31 Balance at Date ⚡ FLOW Decimal FlowField
32 Net Change ⚡ FLOW Decimal FlowField
33 Budgeted Amount ⚡ FLOW Decimal FlowField
34 Totaling Text Normal
35 Budget Filter Code FlowFilter → G/L Budget Name #95
36 Balance ⚡ FLOW Decimal FlowField
37 Budgeted at Date ⚡ FLOW Decimal FlowField
40 Consol. Debit Acc. Code Normal
41 Consol. Credit Acc. Code Normal
42 Business Unit Filter Code FlowFilter → Business Unit #220
43 Gen. Posting Type Option Normal
44 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
45 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
47 Debit Amount ⚡ FLOW Decimal FlowField
48 Credit Amount ⚡ FLOW Decimal FlowField
49 Automatic Ext. Texts Boolean Normal
52 Budgeted Debit Amount ⚡ FLOW Decimal FlowField
53 Budgeted Credit Amount ⚡ FLOW Decimal FlowField
54 Tax Area Code Code Normal → Tax Area #318
55 Tax Liable Boolean Normal
56 Tax Group Code Code Normal → Tax Group #321
57 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
58 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
60 Additional-Currency Net Change ⚡ FLOW Decimal FlowField
61 Add.-Currency Balance at Date ⚡ FLOW Decimal FlowField
62 Additional-Currency Balance ⚡ FLOW Decimal FlowField
63 Exchange Rate Adjustment Option Normal
64 Add.-Currency Debit Amount ⚡ FLOW Decimal FlowField
65 Add.-Currency Credit Amount ⚡ FLOW Decimal FlowField
66 Analysis View Filter Code FlowFilter → Analysis View #363
67 Dimension 1 Filter Code FlowFilter
68 Dimension 2 Filter Code FlowFilter
69 Dimension 3 Filter Code FlowFilter
70 Dimension 4 Filter Code FlowFilter
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 (12)

Tables referenced by fields on the G/L Account (Analysis View) table through TableRelation properties.

Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code, Global Dimension 1 Filter, Global Dimension 2 Filter
Cash Flow Forecast
#840 · Other · via Cash Flow Forecast Filter
G/L Budget Name
#95 · Other · via Budget Filter
Business Unit
#220 · Other · via Business Unit Filter
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Tax Area
#318 · Other · via Tax Area Code
Tax Group
#321 · Other · via Tax Group Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Analysis View
#363 · Other · via Analysis View Filter