G/L Entry Posting Preview #1570

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

70
Fields
0
Records
1
Primary key
8
FlowFields
21
Relations
Open in Data Explorer →

Primary key

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

All fields (70)

G/L Entry Posting Preview — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
3 G/L Account No. Code Normal → G/L Account #15
4 Posting Date Date Normal
5 Document Type Option Normal
6 Document No. Code Normal
7 Description Text Normal
10 Bal. Account No. Code Normal
17 Amount Decimal Normal
23 Global Dimension 1 Code Code Normal → Dimension Value #349
24 Global Dimension 2 Code Code Normal → Dimension Value #349
27 User ID Code Normal
28 Source Code Code Normal → Source Code #230
29 System-Created Entry Boolean Normal
30 Prior-Year Entry Boolean Normal
41 Project No. Code Normal → Job #167
42 Quantity Decimal Normal
43 VAT Amount Decimal Normal
45 Business Unit Code Code Normal → Business Unit #220
46 Journal Batch Name Code Normal
47 Reason Code Code Normal → Reason Code #231
48 Gen. Posting Type Option Normal
49 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
50 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
51 Bal. Account Type Option Normal
52 Transaction No. Integer Normal
53 Debit Amount Decimal Normal
54 Credit Amount Decimal Normal
55 Document Date Date Normal
56 External Document No. Code Normal
57 Source Type Option Normal
58 Source No. Code Normal
59 No. Series Code Normal → No. Series #308
60 Tax Area Code Code Normal → Tax Area #318
61 Tax Liable Boolean Normal
62 Tax Group Code Code Normal → Tax Group #321
63 Use Tax Boolean Normal
64 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
65 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
68 Additional-Currency Amount Decimal Normal
69 Add.-Currency Debit Amount Decimal Normal
70 Add.-Currency Credit Amount Decimal Normal
71 Close Income Statement Dim. ID Integer Normal
72 IC Partner Code Code Normal → IC Partner #413
73 Reversed Boolean Normal
74 Reversed by Entry No. Integer Normal → G/L Entry #17
75 Reversed Entry No. Integer Normal → G/L Entry #17
76 G/L Account Name ⚡ FLOW Text FlowField
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
481 Shortcut Dimension 3 Code ⚡ FLOW Code FlowField
482 Shortcut Dimension 4 Code ⚡ FLOW Code FlowField
483 Shortcut Dimension 5 Code ⚡ FLOW Code FlowField
484 Shortcut Dimension 6 Code ⚡ FLOW Code FlowField
485 Shortcut Dimension 7 Code ⚡ FLOW Code FlowField
486 Shortcut Dimension 8 Code ⚡ FLOW Code FlowField
495 Last Dim. Correction Entry No. Integer Normal
496 Last Dim. Correction Node Integer Normal
497 Count of Dimension Changes Integer Normal
1570 Indentation Integer Normal
1571 G/L Entry No. Integer Normal
5400 Prod. Order No. Code Normal
5600 FA Entry Type Option Normal
5601 FA Entry No. Integer Normal
5618 Comment Text Normal
8001 Account Id ⚡ FLOW GUID FlowField → G/L Account #15
8005 Last Modified DateTime DateTime 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

Related tables (17)

Tables referenced by fields on the G/L Entry Posting Preview table through TableRelation properties.

G/L Account
#15 · General Ledger · via G/L Account No., Account Id
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Source Code
#230 · Other · via Source Code
Job
#167 · Other · via Project No.
Business Unit
#220 · Other · via Business Unit Code
Reason Code
#231 · Other · via Reason Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
No. Series
#308 · Other · via No. Series
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
IC Partner
#413 · Other · via IC Partner Code
G/L Entry
#17 · Ledger Entries · via Reversed by Entry No., Reversed Entry No.
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID