Table 374 "G/L Acc. Budget Buffer"

Base Application · Microsoft.Finance.Analysis · BC23-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	G/L Acc. Budget Buffer
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	Code[20]	—	NotBlank; DataClassification SystemMetadata
3	Budget Filter	Code[10]	—	TableRelation Table 95 “G/L Budget Name” (G/L Budget Name); FlowFilter
4	G/L Account Filter	Code[20]	—	TableRelation Table 15 “G/L Account” (G/L Account); FlowFilter
5	Business Unit Filter	Code[20]	—	TableRelation Table 220 “Business Unit” (Business Unit); FlowFilter
6	Global Dimension 1 Filter	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter
7	Global Dimension 2 Filter	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); FlowFilter
8	Budget Dimension 1 Filter	Code[20]	—	FlowFilter
9	Budget Dimension 2 Filter	Code[20]	—	FlowFilter
10	Budget Dimension 3 Filter	Code[20]	—	FlowFilter
11	Budget Dimension 4 Filter	Code[20]	—	FlowFilter
12	Date Filter	Date	—	FlowFilter
13	Budgeted Amount Δ BC28	Decimal	—	FlowField: sum(“G/L Budget Entry”.Amount where(“Budget Name” = field(“Budget Filter”), “G/L Account No.” = field(“G/L Account Filter”), “Business Unit Code” = field(“Business Unit Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dimension 2 Fil…
14	Income/Balance	Enum “G/L Account Income/Balance”	—	enum Enum 18 “G/L Account Income/Balance”; DataClassification SystemMetadata
15	Account Category	Enum “G/L Account Category”	—	enum Enum 15 “G/L Account Category”; DataClassification SystemMetadata

Keys

Key1: Code (clustered)

Procedures

GetCaptionClass(BudgetDimType: Integer): Text[250]: Retrieves caption class text for budget dimension filter fields based on budget dimension configuration. Returns appropriate caption class string for dynamic dimension field captioning.

Relations

drill-down page Page 16 “Chart of Accounts”
lookup page Page 18 “G/L Account List”
G/L Account Filter: TableRelation Table 15 “G/L Account”
Business Unit Filter: TableRelation Table 220 “Business Unit”
Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
Budget Filter: TableRelation Table 95 “G/L Budget Name”
Budgeted Amount: CalcFormula Table 96 “G/L Budget Entry”

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: "G/L Acc. Budget Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.