tableFinanceofficial - Microsoftderived - from the source, no model text

Table 220 "Business Unit"

Base Application · Microsoft.Finance.Consolidation

Across versions

  1. BC23present
  2. BC241 fields added, 1 procedures added
  3. BC25unchanged
  4. BC261 fields changed
  5. BC27unchanged
  6. BC284 fields changed
  7. BC2928 fields changed
  8. BC30unchanged

Neighbourhood 30 connected objects and pages

Table 15 "G/L Account" (relates to, 9 links)G/L AccountTable 4 "Currency" (relates to)Page 240 "Business Unit List" (pages and codeunits on it, 2 links)Business Unit ListCodeunit 432 "Consolidate" (pages and codeunits on it)ConsolidatePage 150 "Setup Business Unit Currency" (pages and codeunits on it)Setup Business Unit CurrencyPage 241 "Business Unit Card" (pages and codeunits on it)Business Unit CardPage 242 "Consolidate Wizard" (pages and codeunits on it)Consolidate WizardPage 30301 "API Finance - Business Unit" (pages and codeunits on it)API Finance - Business UnitCodeunit 102 "Import Consolidation from API" (calls)Import Consolidation from APITable 1831 "Bus. Unit In Cons. Process" (referenced by, 2 links)Bus. Unit In Cons. ProcessTable 368 "Dimension Selection Buffer" (referenced by, 2 links)Dimension Selection BufferTable 15 "G/L Account" (referenced by)G/L AccountTable 1570 "G/L Entry Posting Preview" (referenced by)Table 17 "G/L Entry" (referenced by)G/L EntryTable 181 "Posted Gen. Journal Line" (referenced by)Posted Gen. Journal LineTable 334 "Column Layout" (referenced by)Column LayoutTable 363 "Analysis View" (referenced by)Table 365 "Analysis View Entry" (referenced by)Table 366 "Analysis View Budget Entry" (referenced by)Table 374 "G/L Acc. Budget Buffer" (referenced by)Table 376 "G/L Account (Analysis View)" (referenced by)Table 4402 "EXR Trial Balance Buffer" (referenced by)Table 6225 "Sust. Account (Analysis View)" (referenced by)Table 751 "Standard General Journal Line" (referenced by)Table 81 "Gen. Journal Line" (referenced by)Table 8364 "Dimension Perspective Line" (referenced by)Table 85 "Acc. Schedule Line" (referenced by)Table 96 "G/L Budget Entry" (referenced by)Consolidate data from multiple companies (Learn pages)Set up company consolidation (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

Referenced by

21 fields in 19 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this 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.

Countries that replace it

ES

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.

Evidence 1 sources