Table 2671 "Alloc. Account Distribution"
Base Application · Microsoft.Finance.AllocationAccount
Across versions
- BC23present
- BC241 fields changed
- BC25-27unchanged
- BC282 fields changed
- BC2916 fields changed
- BC30unchanged
Neighbourhood 13 connected objects and pages
Base Application · Microsoft.Finance.AllocationAccount · BC23-30 · source at ea08af5e · 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” (“Allocation Account”.“No.”) |
| 2 | Line No. | Integer | — | |
| 4 | Account Type | Option | Account type caption | |
| 6 | Share Δ BC28 Δ BC29 | Decimal | Specifies the Share that is used for the variable account distributions. | |
| 7 | Percent Δ BC28 Δ BC29 | Decimal | Specifies the Percent that is used for the variable account distributions. | not editable |
| 8 | Share Updated at | DateTime | Shared Updated at caption | |
| 9 | Destination Account Type Δ BC29 | Enum “Destination Account Type” | Specifies the account type the amount will be posted to. | enum Enum 2670 “Destination Account Type” |
| 10 | Destination Account Number Δ BC24 Δ BC29 | 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 270 “Bank Account” (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 Δ BC29 | Enum “Breakdown Account Type” | Specifies the account type the that is used to calculate percentage for the distributions. | enum Enum 2671 “Breakdown Account Type” |
| 20 | Breakdown Account Number Δ BC29 | Code[20] | Specifies the code of the Account that is used to calculate percentage for the distributions. | |
| 21 | Calculation Period Δ BC29 | 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” |
| 23 | Dimension 1 Filter Δ BC29 | Text[1024] | Specifies the code for Global Dimension 1, that will be used to filter Ledger Entries when cacluating balance. | |
| 24 | Dimension 2 Filter Δ BC29 | Text[1024] | Specifies the code for Global Dimension 2, that will be used to filter Ledger Entries when cacluating balance. | |
| 25 | Dimension 3 Filter Δ BC29 | Text[1024] | Specifies the code for Shortcut Dimension 3, that will be used to filter Ledger Entries when cacluating balance. | |
| 26 | Dimension 4 Filter Δ BC29 | Text[1024] | Specifies the code for Shortcut Dimension 4, that will be used to filter Ledger Entries when cacluating balance. | |
| 27 | Dimension 5 Filter Δ BC29 | Text[1024] | Specifies the code for Shortcut Dimension 5, that will be used to filter Ledger Entries when cacluating balance. | |
| 28 | Dimension 6 Filter Δ BC29 | Text[1024] | Specifies the code for Shortcut Dimension 6, that will be used to filter Ledger Entries when cacluating balance. | |
| 29 | Dimension 7 Filter Δ BC29 | Text[1024] | Specifies the code for Shortcut Dimension 7, that will be used to filter Ledger Entries when cacluating balance. | |
| 30 | Dimension 8 Filter Δ BC29 | 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 Δ BC29 | 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” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 38 | Global Dimension 2 Code | Code[20] | — | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (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” 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” 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” (conditional)
- Allocation Account No.: TableRelation Table 2670 “Allocation Account”
- Destination Account Number: TableRelation Table 270 “Bank Account” (conditional)
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Pages and codeunits on this table
- Page 2671 “Variable Account Distribution” (source table)
- Page 2672 “Fixed Account Distribution” (source table)
- Page 2677 “Alloc. Acc. Dist. Filters” (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” (3 calls:
ShowDimensions → EditDimensionSet,ShowDimensions → UpdateGlobalDimFromDimSetID,ValidateShortcutDimCode → ValidateShortcutDimValues) - Codeunit 2676 “Alloc. Acc. Telemetry” (1 call:
OnInsert → GetFeatureTelemetryName) - Codeunit 46 “SelectionFilterManagement” (1 call:
LookupBusinessUnitFilter → GetSelectionFilter) - Codeunit 8703 “Feature Telemetry” (1 call:
OnInsert → LogUptake)
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.