Table 4402 "EXR Trial Balance Buffer"

ExcelReports · Microsoft.Finance.ExcelReports · captioned “Trial Balance Buffer” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Trial Balance Buffer
TableType	Temporary
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	G/L Account No.	Code[20]	—
2	Dimension 1 Code	Code[20]	—
3	Dimension 2 Code	Code[20]	—
4	Period Start	Date	—
5	Period End	Date	—
10	Net Change	Decimal	—
11	Net Change (Debit)	Decimal	—
12	Net Change (Credit)	Decimal	—
13	Balance	Decimal	—
14	Balance (Debit)	Decimal	—
15	Balance (Credit)	Decimal	—
16	Starting Balance	Decimal	—
17	Starting Balance (Debit)	Decimal	—
18	Starting Balance (Credit)	Decimal	—
20	Budget (Net)	Decimal	Budget caption
21	% of Budget Net	Decimal	—
22	Budget (Bal. at Date)	Decimal	—
23	% of Budget Bal.	Decimal	—
50	Last Period Net	Decimal	—
51	Last Period Net (Debit)	Decimal	—
52	Last Period Net (Credit)	Decimal	—
60	Last Period Bal.	Decimal	—
61	Last Period Bal. (Debit)	Decimal	—
62	Last Period Bal. (Credit)	Decimal	—
70	Net Variance	Decimal	—
71	% of Net Variance	Decimal	—
80	Bal. Variance	Decimal	—
81	% of Bal. Variance	Decimal	—
110	Net Change (ACY)	Decimal	Net Change caption
111	Net Change (Debit) (ACY)	Decimal	Net Change (Debit) caption
112	Net Change (Credit) (ACY)	Decimal	Net Change (Credit) caption
113	Balance (ACY)	Decimal	Balance caption
114	Balance (Debit) (ACY)	Decimal	Balance (Debit) caption
115	Balance (Credit) (ACY)	Decimal	Balance (Credit) caption
116	Starting Balance (ACY)	Decimal	Starting Balance caption
117	Starting Balance (Debit) (ACY)	Decimal	Starting Balance (Debit) caption
118	Starting Balance (Credit)(ACY)	Decimal	Starting Balance (Credit) caption
150	Last Period Net (ACY)	Decimal	Last Period Net caption
151	Last Period Net (Debit) (ACY)	Decimal	Last Period Net (Debit) caption
152	Last Period Net (Credit) (ACY)	Decimal	Last Period Net (Credit) caption
160	Last Period Bal. (ACY)	Decimal	Last Period Bal. caption
161	Last Period Bal. (Debit) (ACY)	Decimal	Last Period Bal. (Debit) caption
162	Last Period Bal. (Cred.) (ACY)	Decimal	Last Period Bal. (Credit) caption
170	Net Variance (ACY)	Decimal	Net Variance caption
171	% of Net Variance (ACY)	Decimal	% of Net Variance caption
180	Bal. Variance (ACY)	Decimal	Bal. Variance caption
181	% of Bal. Variance (ACY)	Decimal	% of Bal. Variance caption
200	All Zero	Boolean	—
201	Business Unit Code	Code[20]	—	TableRelation Table 220 “Business Unit” (Business Unit)
1000	Account Type	Enum “G/L Account Type”	—	FlowField: lookup(“G/L Account”.“Account Type” where(“No.” = field(“G/L Account No.”))); enum Enum 16 “G/L Account Type”; not editable

Keys

PK: G/L Account No., Dimension 1 Code, Dimension 2 Code, Business Unit Code, Period Start (clustered)

Procedures

CalculateVariances() (internal)
CalculateBudgetComparisons() (internal)
CalculatePriorComparisons() (internal)
CheckAllZero() (internal)

Plus 1 local procedures.

Triggers

OnInsert, OnModify

Relations

Account Type: CalcFormula Table 15 “G/L Account”
Business Unit Code: TableRelation Table 220 “Business Unit”

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: "EXR Trial Balance Buffer"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.