Table 220 "Business Unit"
Base Application · Microsoft.Finance.Consolidation
Across versions
- BC23present
- BC241 fields added, 1 procedures added
- BC25unchanged
- BC261 fields changed
- BC27unchanged
- BC284 fields changed
- BC2928 fields changed
- BC30unchanged
Neighbourhood 30 connected objects and pages
Base Application · Microsoft.Finance.Consolidation · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 240 “Business Unit List” (2 Learn pages).
Properties
| Property | Value |
|---|---|
| Caption | Business Unit |
| 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 | Code Δ BC29 | Code[20] | Specifies the code of the business unit. | NotBlank |
| 2 | Consolidate Δ BC29 | Boolean | Specifies whether to include the business unit in the Consolidation report. | |
| 3 | Consolidation % Δ BC28 Δ BC29 | Decimal | Specifies the percentage of each transaction for the business unit to include in the consolidation. For example, if a sales invoice is for $1000, and you specify 70%, consolidation will include $700 for the invoice. This is useful when you own only a percentage of a business unit. | |
| 4 | Starting Date Δ BC29 | Date | Specifies the starting date of the fiscal year that the business unit uses. Enter a date only if the business unit and consolidated company have different fiscal years. | |
| 5 | Ending Date Δ BC29 | Date | Specifies the ending date of the business unit’s fiscal year. Enter a date only if the business unit and the consolidated company have different fiscal years. | |
| 6 | Income Currency Factor Δ BC28 Δ BC29 | Decimal | Specifies the exchange rate to use for balance sheet accounts. | not editable |
| 7 | Balance Currency Factor Δ BC28 Δ BC29 | Decimal | Specifies the exchange rate to use for income statement accounts. | not editable |
| 8 | Exch. Rate Losses Acc. Δ BC29 | Code[20] | Specifies the general ledger account that revenue losses due to exchange rates during consolidation are posted. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 9 | Exch. Rate Gains Acc. Δ BC29 | Code[20] | Specifies the general ledger account that revenue gained from exchange rates during consolidation is posted to. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 10 | Residual Account Δ BC29 | Code[20] | Specifies the general ledger account for residual amounts that occur during consolidation. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 11 | Last Balance Currency Factor Δ BC28 Δ BC29 | Decimal | Specifies the last closing currency factor used in the previous reconciliation. This will be used to adjust the balance entries. | not editable |
| 12 | Name Δ BC29 | Text[100] | Specifies the name of the business unit in the consolidated company. | |
| 13 | Company Name Δ BC29 | Text[30] | Specifies the company that will become a business unit in the consolidated company. | TableRelation Company.Name |
| 14 | Currency Code Δ BC29 | Code[10] | Specifies the currency to use for this business unit during consolidation. | TableRelation Table 4 “Currency” |
| 15 | Comp. Exch. Rate Gains Acc. Δ BC29 | Code[20] | Specifies the general ledger account where gains from exchange rates during consolidation are posted for accounts that use the Composite Rate in the Consol. Translation Method field. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 16 | Comp. Exch. Rate Losses Acc. Δ BC29 | Code[20] | Specifies the general ledger account where losses due to exchange rates during consolidation are posted for accounts that use the Composite Rate in the Consol. Translation Method field. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 17 | Equity Exch. Rate Gains Acc. Δ BC29 | Code[20] | Specifies the general ledger account for gains from exchange rates during consolidation are posted to for accounts that use the Equity Rate. If this field is blank, the account in the Exch. Rate Gains Acc. field is used. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 18 | Equity Exch. Rate Losses Acc. Δ BC29 | Code[20] | Specifies the general ledger account where losses due to exchange rates during consolidation are posted for accounts that use the Equity Rate. If this field is blank, the account in the Exch. Rate Losses Acc. field is used. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 19 | Minority Exch. Rate Gains Acc. Δ BC29 | Code[20] | Specifies the general ledger account where gains from exchange rates during consolidation are posted for business units that you do not own 100%. If this field is blank, the account in the Exch. Rate Gains Acc. field is used. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 20 | Minority Exch. Rate Losses Acc Δ BC29 | Code[20] | Specifies the general ledger account that losses due to exchange rates during consolidation are posted to for business units that you do not own 100%. If this field is blank, the account in the Exch. Rate Losses Acc. field is used. | TableRelation Table 15 “G/L Account” (G/L Account) |
| 21 | Currency Exchange Rate Table Δ BC29 | Option | Specifies where to get currency exchange rates from when importing consolidation data. If you choose Local, the currency exchange rate table in the current (local) company is used. If you choose Business Unit, the currency exchange rate table in the business unit is used. | OptionCaption: Local,Business Unit |
| 22 | Data Source Δ BC29 | Option | Specifies whether data is retrieved in the local currency (LCY) or the additional reporting currency (ACY) from the business unit. | OptionCaption: Local Curr. (LCY),Add. Rep. Curr. (ACY) |
| 23 | File Format Δ BC26 Δ BC29 | Enum “Business Unit File Format” | Specifies the file format to use for the business unit data. If the business unit has version 3.70 or earlier, it must submit a .txt file. If the version is 4.00 or later, it must use an XML file. | enum Enum 220 “Business Unit File Format” |
| 24 | Last Run Δ BC29 | Date | Specifies the last date on which consolidation was run. | |
| 25 | Default Data Import Method Δ BC29 | Option | Specifies the data import method to use when importing data from the business unit. Database is for companies within the same environment and API is for companies in different environments. | OptionCaption: Database,API; DataClassification SystemMetadata |
| 26 | BC API URL Δ BC29 | Text[2048] | Specifies the URL for the API of the Business Central company from which data will be imported. You can get this value from the page “Consolidation Setup” in the Business Central company for this business unit. | DataClassification OrganizationIdentifiableInformation |
| 27 | AAD Tenant ID | Guid | Microsoft Entra tenant ID caption | DataClassification OrganizationIdentifiableInformation |
| 28 | External Company Id | Guid | — | DataClassification OrganizationIdentifiableInformation |
| 29 | External Company Name Δ BC29 | Text[1024] | Specifies the company name of the Business Central company from which data will be imported. | DataClassification OrganizationIdentifiableInformation |
| 30 | Log Requests + BC24 Δ BC29 | Boolean | Specifies if requests should be logged for this Business Unit on the “Consolidation Log Entry” table. This is useful for troubleshooting. | DataClassification SystemMetadata |
Keys
- Key1: Code (clustered)
- Key2: Company Name
Procedures
CheckGLAcc(AccNo: Code[20]): Validates that the specified G/L Account exists and is properly configured for consolidation use.
Plus 3 local procedures.
Relations
- lookup page Page 240 “Business Unit List”
- Comp. Exch. Rate Gains Acc.: TableRelation Table 15 “G/L Account”
- Comp. Exch. Rate Losses Acc.: TableRelation Table 15 “G/L Account”
- Equity Exch. Rate Gains Acc.: TableRelation Table 15 “G/L Account”
- Equity Exch. Rate Losses Acc.: TableRelation Table 15 “G/L Account”
- Exch. Rate Gains Acc.: TableRelation Table 15 “G/L Account”
- Exch. Rate Losses Acc.: TableRelation Table 15 “G/L Account”
- Minority Exch. Rate Gains Acc.: TableRelation Table 15 “G/L Account”
- Minority Exch. Rate Losses Acc: TableRelation Table 15 “G/L Account”
- Residual Account: TableRelation Table 15 “G/L Account”
- Currency Code: TableRelation Table 4 “Currency”
Referenced by
21 fields in 19 objects relate to this table (TableRelation or CalcFormula).
- Table 1831 “Bus. Unit In Cons. Process”: Default Data Import Method, Business Unit Code
- Table 368 “Dimension Selection Buffer”: Dimension Value Filter, New Dimension Value Code
- Table 15 “G/L Account”: Business Unit Filter
- Table 1570 “G/L Entry Posting Preview”: Business Unit Code
- Table 17 “G/L Entry”: Business Unit Code
- Table 181 “Posted Gen. Journal Line”: Business Unit Code
- Table 334 “Column Layout”: Business Unit Totaling
- Table 363 “Analysis View”: Business Unit Filter
- Table 365 “Analysis View Entry”: Business Unit Code
- Table 366 “Analysis View Budget Entry”: Business Unit Code
- Table 374 “G/L Acc. Budget Buffer”: Business Unit Filter
- Table 376 “G/L Account (Analysis View)”: Business Unit Filter
- Table 4402 “EXR Trial Balance Buffer”: Business Unit Code
- Table 6225 “Sust. Account (Analysis View)”: Business Unit Filter
- Table 751 “Standard General Journal Line”: Business Unit Code
- Table 81 “Gen. Journal Line”: Business Unit Code
- Table 8364 “Dimension Perspective Line”: Business Unit Totaling
- Table 85 “Acc. Schedule Line”: Business Unit Filter
- Table 96 “G/L Budget Entry”: Business Unit Code
Pages and codeunits on this table
- Page 150 “Setup Business Unit Currency” (source table)
- Page 240 “Business Unit List” (source table)
- Page 241 “Business Unit Card” (source table)
- Page 242 “Consolidate Wizard” (source table)
- Page 30301 “API Finance - Business Unit” (source table)
- Codeunit 432 “Consolidate” (codeunit runs on it)
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 102 “Import Consolidation from API” (1 call:
GetCurrencyFactorFromBusinessUnit → GetCurrencyFactorFromBusinessUnit)
Countries that replace it
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: "Business Unit"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.