---
id: object/table/2671
type: object
title: Table 2671 "Alloc. Account Distribution"
summary: Table 2671 "Alloc. Account Distribution" in Base Application (Microsoft.Finance.AllocationAccount). 23 fields, 7 public procedures, 2 events. Present since at least BC23, still in BC30, changed in BC24, BC28-29.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "29"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: d73cb93939a2a8fc654523f9f330f0fcc8127fae40131a8b3fcb560fc981cf05
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/AllocationAccount/AllocAccountDistribution.Table.al
    title: src/Layers/W1/BaseApp/Finance/AllocationAccount/AllocAccountDistribution.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 2671
name: Alloc. Account Distribution
namespace: Microsoft.Finance.AllocationAccount
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "28"
  - "29"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 23
  procedures: 12
  events: 2
  subscribers: 0
relations:
  out: 6
  referenced_by: 0
  pages: 3
  extended_by: 0
  event_subscribers: 2
  calls: 4
  called_by: 0
  implements: 0
---

# Table 2671 "Alloc. Account Distribution"

> Table 2671 "Alloc. Account Distribution" in Base Application (Microsoft.Finance.AllocationAccount). 23 fields, 7 public procedures, 2 events. Present since at least BC23, still in BC30, changed in BC24, BC28-29.

Base Application · Microsoft.Finance.AllocationAccount · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Finance/AllocationAccount/AllocAccountDistribution.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| DataClassification | CustomerContent |

## Fields

Explanation: the field's ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Allocation Account No. | Code[20] | — | TableRelation [Table 2670 "Allocation Account"](../table/2670.md) ("Allocation Account"."No.") |
| 2 | Line No. | Integer | — |  |
| 4 | Account Type | Option | Account type <small>caption</small> |  |
| 6 | Share | Decimal | Specifies the Share that is used for the variable account distributions. |  |
| 7 | Percent | Decimal | Specifies the Percent that is used for the variable account distributions. | not editable |
| 8 | Share Updated at | DateTime | Shared Updated at <small>caption</small> |  |
| 9 | Destination Account Type | Enum "Destination Account Type" | Specifies the account type the amount will be posted to. | enum [Enum 2670 "Destination Account Type"](../enum/2670.md) |
| 10 | Destination Account Number | Code[20] | Specifies the account number that the amount will be posted to. You can select Destination Account Number if Destination Account Type field is G/L Account or Bank Account. If Destination Account Type field is Inherit from Parent, Destination Account Number and Destination Account Type will be taken ... | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 270 "Bank Account"](../table/270.md) (if ("Destination Account Type" = const("G/L Account")) "G/L Account" where("Account Type" = const(Posting), "Direct Posting" = const(true)) else if ("Destination Account Type" = const("Bank Account")) "Bank Account") |
| 19 | Breakdown Account Type | Enum "Breakdown Account Type" | Specifies the account type the that is used to calculate percentage for the distributions. | enum [Enum 2671 "Breakdown Account Type"](../enum/2671.md) |
| 20 | Breakdown Account Number | Code[20] | Specifies the code of the Account that is used to calculate percentage for the distributions. |  |
| 21 | Calculation Period | Enum "Allocation Account Period" | Specifies the period to use to calculate the account balance that is used as a percentage for the distributions. | enum [Enum 2674 "Allocation Account Period"](../enum/2674.md) |
| 23 | Dimension 1 Filter | Text[1024] | Specifies the code for Global Dimension 1, that will be used to filter Ledger Entries when cacluating balance. |  |
| 24 | Dimension 2 Filter | Text[1024] | Specifies the code for Global Dimension 2, that will be used to filter Ledger Entries when cacluating balance. |  |
| 25 | Dimension 3 Filter | Text[1024] | Specifies the code for Shortcut Dimension 3, that will be used to filter Ledger Entries when cacluating balance. |  |
| 26 | Dimension 4 Filter | Text[1024] | Specifies the code for Shortcut Dimension 4, that will be used to filter Ledger Entries when cacluating balance. |  |
| 27 | Dimension 5 Filter | Text[1024] | Specifies the code for Shortcut Dimension 5, that will be used to filter Ledger Entries when cacluating balance. |  |
| 28 | Dimension 6 Filter | Text[1024] | Specifies the code for Shortcut Dimension 6, that will be used to filter Ledger Entries when cacluating balance. |  |
| 29 | Dimension 7 Filter | Text[1024] | Specifies the code for Shortcut Dimension 7, that will be used to filter Ledger Entries when cacluating balance. |  |
| 30 | Dimension 8 Filter | Text[1024] | Specifies the code for Shortcut Dimension 8, that will be used to filter Ledger Entries when cacluating balance. |  |
| 35 | Business Unit Code Filter | Text[1024] | Specifies the filter for the Business Unit Code, that will be used to filter Ledger Entries when calculating balance. |  |
| 37 | Global Dimension 1 Code | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false))) |
| 38 | Global Dimension 2 Code | Code[20] | — | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false))) |
| 480 | Dimension Set ID | Integer | — | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |

## Keys

- Key1: Allocation Account No., Line No. (clustered)

## Events published

- `OnLookupBreakdownAccountNumber(var AllocAccountDistribution: Record "Alloc. Account Distribution"; var Handled: Boolean)` (integration): Integration event raised when looking up breakdown account numbers for extensibility.
  - subscribers: [Codeunit 2632 "Stat. Acc. Allocation Account"](../codeunit/2632.md) HandleLookupBreakdownAccountNumber
- `OnLookupBreakdownAccountName(var AllocAccountDistribution: Record "Alloc. Account Distribution"; var AccountName: Text[2048]; var Handled: Boolean)` (integration): Integration event raised when looking up breakdown account names for extensibility.
  - subscribers: [Codeunit 2632 "Stat. Acc. Allocation Account"](../codeunit/2632.md) HandleLookupBreakdownAccountName

## Procedures

- `LookupDistributionAccountName(): Text[2048]` (internal)
- `LookupDistributionAccountName(DestinationAccountType: Enum "Destination Account Type"; DestinationAccountNumber: Code[20]): Text[2048]` (internal)
- `LookupBreakdownAccountName(): Text[2048]` (internal)
- `LookupBusinessUnitFilter(var NewBusinessUnitFilter: Text): Boolean` (internal)
- `ShowDimensions()` (internal)
- `ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])`: Validates shortcut dimension codes and updates the dimension set ID accordingly.
- `GetDimensionCaption(DimensionID: Integer): Text` (internal)

Plus 3 local procedures.

## Triggers

OnInsert, OnDelete

## Relations

- Destination Account Number: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional)
- Allocation Account No.: TableRelation [Table 2670 "Allocation Account"](../table/2670.md)
- Destination Account Number: TableRelation [Table 270 "Bank Account"](../table/270.md) (conditional)
- Global Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)

## Pages and codeunits on this table

- [Page 2671 "Variable Account Distribution"](../page/2671.md) (source table)
- [Page 2672 "Fixed Account Distribution"](../page/2672.md) (source table)
- [Page 2677 "Alloc. Acc. Dist. Filters"](../page/2677.md) (source table)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 408 "DimensionManagement"](../codeunit/408.md) (3 calls: `ShowDimensions → EditDimensionSet`, `ShowDimensions → UpdateGlobalDimFromDimSetID`, `ValidateShortcutDimCode → ValidateShortcutDimValues`)
- [Codeunit 2676 "Alloc. Acc. Telemetry"](../codeunit/2676.md) (1 call: `OnInsert → GetFeatureTelemetryName`)
- [Codeunit 46 "SelectionFilterManagement"](../codeunit/46.md) (1 call: `LookupBusinessUnitFilter → GetSelectionFilter`)
- [Codeunit 8703 "Feature Telemetry"](../codeunit/8703.md) (1 call: `OnInsert → LogUptake`)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC28-29

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "table", object_name: "Alloc. Account Distribution")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.