Table 1831 "Bus. Unit In Cons. Process"

Base Application · Microsoft.Finance.Consolidation · captioned “Business Unit in Consolidation Process” · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Business Unit in Consolidation Process
Extensible	false
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	Consolidation Process Id	Integer	—	TableRelation Table 1830 “Consolidation Process” (Consolidation Process); DataClassification SystemMetadata
2	Business Unit Code Δ BC29	Code[20]	Specifies the code of the business unit.	TableRelation Table 220 “Business Unit” (Business Unit)
3	Default Data Import Method	Option	—	FlowField: lookup(“Business Unit”.“Default Data Import Method” where(Code = field(“Business Unit Code”))); OptionCaption: Database,API
4	Status Δ BC29	Option	Specifies the status of the business unit in the consolidation process.	OptionCaption: Not started,Importing data,Consolidating,Finished,Error; DataClassification SystemMetadata
5	Average Exchange Rate + BC24 Δ BC28 Δ BC29	Decimal	Specifies the average exchange rate of the business unit.
6	Closing Exchange Rate + BC24 Δ BC28 Δ BC29	Decimal	Specifies the closing exchange rate of the business unit.
7	Last Closing Exchange Rate + BC24 Δ BC28 Δ BC29	Decimal	Specifies the last closing exchange rate considered when adjusting balances in re-runs for this business unit.
8	Currency Exchange Rate Table + BC24 Δ BC29	Option	Specifies the currency exchange rate table of the business unit.	OptionCaption: Local,Business Unit
9	Starting Date + BC24 Δ BC29	Date	Specifies the starting date of the consolidation.	FlowField: lookup(“Consolidation Process”.“Starting Date” where(Id = field(“Consolidation Process Id”)))
10	Ending Date + BC24 Δ BC29	Date	Specifies the ending date of the consolidation.	FlowField: lookup(“Consolidation Process”.“Ending Date” where(Id = field(“Consolidation Process Id”)))
11	Currency Code + BC24 Δ BC29	Code[10]	Specifies the currency code of the business unit.

Keys

Key1: Consolidation Process Id, Business Unit Code (clustered)

Relations

Ending Date: CalcFormula Table 1830 “Consolidation Process”
Starting Date: CalcFormula Table 1830 “Consolidation Process”
Consolidation Process Id: TableRelation Table 1830 “Consolidation Process”
Default Data Import Method: CalcFormula Table 220 “Business Unit”
Business Unit Code: TableRelation Table 220 “Business Unit”

Pages and codeunits on this table

Page 164 “Previous Exchange Rates” (source table)
Page 252 “Cons. Process Details” (source table)
Page 258 “Cons. for Business Units” (source table)

Ask your agent

Procedure bodies are not stored here (D10). 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: "Bus. Unit In Cons. Process"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.