Alloc. Account Distribution #2671

Other table in Microsoft Dynamics 365 Business Central. 28 fields, 2 records in Cronus demo.

The Alloc. Account Distribution table (ID 2671) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 28 fields, with a primary key of Allocation Account No., Line No.. Use the reference below to explore every field, data type, and table relation.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (28)

Alloc. Account Distribution — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	Allocation Account No. PK	Code	Normal	→ Allocation Account #2670
2	Line No. PK	Integer	Normal
4	Account type	Option	Normal
6	Share	Decimal	Normal
7	Percent	Decimal	Normal
8	Shared Updated at	DateTime	Normal
9	Destination Account Type	Option	Normal
10	Destination Account Number	Code	Normal
19	Breakdown Account Type	Option	Normal
20	Breakdown Account Number	Code	Normal
21	Calculation Period	Option	Normal
23	Dimension 1 Filter	Text	Normal
24	Dimension 2 Filter	Text	Normal
25	Dimension 3 Filter	Text	Normal
26	Dimension 4 Filter	Text	Normal
27	Dimension 5 Filter	Text	Normal
28	Dimension 6 Filter	Text	Normal
29	Dimension 7 Filter	Text	Normal
30	Dimension 8 Filter	Text	Normal
35	Business Unit Code Filter	Text	Normal
37	Global Dimension 1 Code	Code	Normal	→ Dimension Value #349
38	Global Dimension 2 Code	Code	Normal	→ Dimension Value #349
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 Alloc. Account Distribution table through TableRelation properties.

Allocation Account

#2670 · Other · via Allocation Account No.

Dimension Value

#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code

Dimension Set Entry

#480 · Dimensions · via Dimension Set ID