EXR Trial Balance Buffer #4402

Other table in Microsoft Dynamics 365 Business Central. 55 fields, 0 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: G/L Account No., Dimension 1 Code, Dimension 2 Code, Period Start, Business Unit Code.

All fields (55)

EXR Trial Balance Buffer — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	G/L Account No. PK	Code	Normal
2	Dimension 1 Code PK	Code	Normal
3	Dimension 2 Code PK	Code	Normal
4	Period Start PK	Date	Normal
5	Period End	Date	Normal
10	Net Change	Decimal	Normal
11	Net Change (Debit)	Decimal	Normal
12	Net Change (Credit)	Decimal	Normal
13	Balance	Decimal	Normal
14	Balance (Debit)	Decimal	Normal
15	Balance (Credit)	Decimal	Normal
16	Starting Balance	Decimal	Normal
17	Starting Balance (Debit)	Decimal	Normal
18	Starting Balance (Credit)	Decimal	Normal
20	Budget	Decimal	Normal
21	% of Budget Net	Decimal	Normal
22	Budget (Bal. at Date)	Decimal	Normal
23	% of Budget Bal.	Decimal	Normal
50	Last Period Net	Decimal	Normal
51	Last Period Net (Debit)	Decimal	Normal
52	Last Period Net (Credit)	Decimal	Normal
60	Last Period Bal.	Decimal	Normal
61	Last Period Bal. (Debit)	Decimal	Normal
62	Last Period Bal. (Credit)	Decimal	Normal
70	Net Variance	Decimal	Normal
71	% of Net Variance	Decimal	Normal
80	Bal. Variance	Decimal	Normal
81	% of Bal. Variance	Decimal	Normal
110	Net Change	Decimal	Normal
111	Net Change (Debit)	Decimal	Normal
112	Net Change (Credit)	Decimal	Normal
113	Balance	Decimal	Normal
114	Balance (Debit)	Decimal	Normal
115	Balance (Credit)	Decimal	Normal
116	Starting Balance	Decimal	Normal
117	Starting Balance (Debit)	Decimal	Normal
118	Starting Balance (Credit)	Decimal	Normal
150	Last Period Net	Decimal	Normal
151	Last Period Net (Debit)	Decimal	Normal
152	Last Period Net (Credit)	Decimal	Normal
160	Last Period Bal.	Decimal	Normal
161	Last Period Bal. (Debit)	Decimal	Normal
162	Last Period Bal. (Credit)	Decimal	Normal
170	Net Variance	Decimal	Normal
171	% of Net Variance	Decimal	Normal
180	Bal. Variance	Decimal	Normal
181	% of Bal. Variance	Decimal	Normal
200	All Zero	Boolean	Normal
201	Business Unit Code PK	Code	Normal	→ Business Unit #220
1000	Account Type ⚡ FLOW	Option	FlowField
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (2)

Tables referenced by fields on the EXR Trial Balance Buffer table through TableRelation properties.

Business Unit

#220 · Other · via Business Unit Code