Gen. Jnl. Allocation #221

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

30
Fields
0
Records
4
Primary key
1
FlowFields
15
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, Journal Line No., Line No..

All fields (30)

Gen. Jnl. Allocation — FIELDS
NO.FIELDTYPECLASSRELATION
1 Journal Template Name PK Code Normal → Gen. Journal Template #80
2 Journal Batch Name PK Code Normal → Gen. Journal Batch #232
3 Journal Line No. PK Integer Normal → Gen. Journal Line #81
4 Line No. PK Integer Normal
5 Account No. Code Normal → G/L Account #15
6 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
7 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
8 Allocation Quantity Decimal Normal
9 Allocation % Decimal Normal
10 Amount Decimal Normal
11 Gen. Posting Type Option Normal
12 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
13 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
14 VAT Calculation Type Option Normal
15 VAT Amount Decimal Normal
16 VAT % Decimal Normal
17 Account Name ⚡ FLOW Text FlowField
18 Tax Area Code Code Normal → Tax Area #318
19 Tax Liable Boolean Normal
20 Tax Group Code Code Normal → Tax Group #321
21 Use Tax Boolean Normal
22 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
23 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
24 Additional-Currency Amount Decimal Normal
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 (13)

Tables referenced by fields on the Gen. Jnl. Allocation table through TableRelation properties.

Gen. Journal Template
#80 · Other · via Journal Template Name
Gen. Journal Batch
#232 · Other · via Journal Batch Name
Gen. Journal Line
#81 · Other · via Journal Line No.
G/L Account
#15 · General Ledger · via Account No.
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
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
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID