A_GL_ACCOUNT_BALANCES

Name: A_GL_ACCOUNT_BALANCES
Creator: Ryan Brents
License: https://creativecommons.org/licenses/by/4.0/

Archive Account Master Balances

tableFINGL

A_GL_ACCOUNT_BALANCES — Archive Account Master Balances. FIN table in the standard Ross ERP 8.0 schema: 129 columns, used by 10 programs. Columns, data types, keys, foreign keys and relationships.

Open A_GL_ACCOUNT_BALANCES in the interactive Data Dictionary →

Part of GL tables & objects · all tables, views & procedures

Columns

#	Column	Type	Key	Description
1	GEM_DBKEY	int		GEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2	ARCHIVE_ID	varchar(1)	PK	Prefix Fields for Archive Tables
3	ACCOUNT_NUMBER	varchar(50)	PK FK→GL_ACCOUNTS	GL Account Number
4	ACCOUNT_IDENT	varchar(6)	PK	Balance Type Identifier
5	CURRENT_YEAR	smallint	PK	Current Year
6	SUBCLASS_01	varchar(8)		Account Code Subclass 1
7	SUBCLASS_02	varchar(8)		Account Code Subclass 2
8	SUBCLASS_03	varchar(8)		Account Code Subclass 3
9	SUBCLASS_04	varchar(8)		Account Code Subclass 4
10	SUBCLASS_05	varchar(8)		Account Code Subclass 5
11	SUBCLASS_06	varchar(8)		Account Code Subclass 6
12	SUBCLASS_07	varchar(8)		Account Code Subclass 7
13	SUBCLASS_08	varchar(8)		Account Code Subclass 8
14	SUBCLASS_09	varchar(8)		Account Code Subclass 9
15	DELETE_FLAG	varchar(1)
16	BALANCE_00	numeric(20,2)		Opening Balance
17	BALANCE_01	numeric(20,2)		Period 01 Balance
18	BALANCE_02	numeric(20,2)		Period 02 Balance
19	BALANCE_03	numeric(20,2)		Period 03 Balance
20	BALANCE_04	numeric(20,2)		Period 04 Balance
21	BALANCE_05	numeric(20,2)		Period 05 Balance
22	BALANCE_06	numeric(20,2)		Period 06 Balance
23	BALANCE_07	numeric(20,2)		Period 07 Balance
24	BALANCE_08	numeric(20,2)		Period 08 Balance
25	BALANCE_09	numeric(20,2)		Period 09 Balance
26	BALANCE_10	numeric(20,2)		Period 10 Balance
27	BALANCE_11	numeric(20,2)		Period 11 Balance
28	BALANCE_12	numeric(20,2)		Period 12 Balance
29	BALANCE_13	numeric(20,2)		Period 13 Balance
30	BALANCE_YEAR_TO_DATE	numeric(20,2)		Year to Date Balance
31	FULL_YEAR_TOTAL	numeric(20,2)		Full Year Total
32	BALANCE_ADJUSTMENT	numeric(20,2)		Year-End Balance Adjustment
33	ARCHIVE_DATE	datetime		Archive Date
34	ARCHIVE_USERNAME	varchar(20)		Username recorded when the row was moved to the archive.
35	SYS_CURRENCY_CODE	varchar(6)	PK	Currency Code
36	GL_ELEMENT_01	varchar(10)
37	GL_ELEMENT_02	varchar(10)
38	GL_ELEMENT_03	varchar(10)
39	GL_ELEMENT_04	varchar(10)
40	GL_ELEMENT_05	varchar(10)
41	GL_ELEMENT_06	varchar(10)
42	GL_ELEMENT_07	varchar(10)
43	GL_ELEMENT_08	varchar(10)
44	GL_ELEMENT_09	varchar(10)
45	GL_ELEMENT_10	varchar(10)
46	GL_ELEMENT_11	varchar(10)
47	GL_ELEMENT_12	varchar(10)
48	GL_ELEMENT_13	varchar(10)
49	GL_ELEMENT_14	varchar(10)
50	GL_ELEMENT_15	varchar(10)
51	GL_DR_YEAR_TO_DATE	numeric(20,2)
52	GL_CR_YEAR_TO_DATE	numeric(20,2)
53	GL_DR_BALANCE_00	numeric(20,2)
54	GL_CR_BALANCE_00	numeric(20,2)
55	GL_DR_BALANCE_01	numeric(20,2)
56	GL_CR_BALANCE_01	numeric(20,2)
57	GL_DR_BALANCE_02	numeric(20,2)
58	GL_CR_BALANCE_02	numeric(20,2)
59	GL_DR_BALANCE_03	numeric(20,2)
60	GL_CR_BALANCE_03	numeric(20,2)
61	GL_DR_BALANCE_04	numeric(20,2)
62	GL_CR_BALANCE_04	numeric(20,2)
63	GL_DR_BALANCE_05	numeric(20,2)
64	GL_CR_BALANCE_05	numeric(20,2)
65	GL_DR_BALANCE_06	numeric(20,2)
66	GL_CR_BALANCE_06	numeric(20,2)
67	GL_DR_BALANCE_07	numeric(20,2)
68	GL_CR_BALANCE_07	numeric(20,2)
69	GL_DR_BALANCE_08	numeric(20,2)
70	GL_CR_BALANCE_08	numeric(20,2)
71	GL_DR_BALANCE_09	numeric(20,2)
72	GL_CR_BALANCE_09	numeric(20,2)
73	GL_DR_BALANCE_10	numeric(20,2)
74	GL_CR_BALANCE_10	numeric(20,2)
75	GL_DR_BALANCE_11	numeric(20,2)
76	GL_CR_BALANCE_11	numeric(20,2)
77	GL_DR_BALANCE_12	numeric(20,2)
78	GL_CR_BALANCE_12	numeric(20,2)
79	GL_DR_BALANCE_13	numeric(20,2)
80	GL_CR_BALANCE_13	numeric(20,2)
81	GL_DR_YEAR_TOTAL	numeric(20,2)
82	GL_CR_YEAR_TOTAL	numeric(20,2)
83	GL_DR_LIFE_TO_DATE	numeric(20,2)
84	GL_CR_LIFE_TO_DATE	numeric(20,2)
85	RCS_CONVERSION_STATUS	varchar(1)		Ren/CS Data Conversion Status
86	GL_BALANCE_00	computed
87	GL_BALANCE_01	computed
88	GL_BALANCE_02	computed
89	GL_BALANCE_03	computed
90	GL_BALANCE_04	computed
91	GL_BALANCE_05	computed
92	GL_BALANCE_06	computed
93	GL_BALANCE_07	computed
94	GL_BALANCE_08	computed
95	GL_BALANCE_09	computed
96	GL_BALANCE_10	computed
97	GL_BALANCE_11	computed
98	GL_BALANCE_12	computed
99	GL_BALANCE_13	computed
100	GL_BALANCE_YEAR_TO_DATE	computed
101	GL_BALANCE_LIFE_TO_DATE	computed
102	GL_BALANCE_YEAR_TOTAL	computed
103	GL_CLOSE_BALANCE_01	computed
104	GL_CLOSE_BALANCE_02	computed
105	GL_CLOSE_BALANCE_03	computed
106	GL_CLOSE_BALANCE_04	computed
107	GL_CLOSE_BALANCE_05	computed
108	GL_CLOSE_BALANCE_06	computed
109	GL_CLOSE_BALANCE_07	computed
110	GL_CLOSE_BALANCE_08	computed
111	GL_CLOSE_BALANCE_09	computed
112	GL_CLOSE_BALANCE_10	computed
113	GL_CLOSE_BALANCE_11	computed
114	GL_CLOSE_BALANCE_12	computed
115	GL_CLOSE_BALANCE_13	computed
116	CLOSE_BALANCE_01	computed
117	CLOSE_BALANCE_02	computed
118	CLOSE_BALANCE_03	computed
119	CLOSE_BALANCE_04	computed
120	CLOSE_BALANCE_05	computed
121	CLOSE_BALANCE_06	computed
122	CLOSE_BALANCE_07	computed
123	CLOSE_BALANCE_08	computed
124	CLOSE_BALANCE_09	computed
125	CLOSE_BALANCE_10	computed
126	CLOSE_BALANCE_11	computed
127	CLOSE_BALANCE_12	computed
128	CLOSE_BALANCE_13	computed
129	GEM_ARCHIVE_FLAG	varchar(20)		System flag indicating whether the row has been archived by the GEMBASE archive process.