GL_PREVIOUS_TRANSLATIONS

Previous Translation Account Balances

tableFINGL

GL_PREVIOUS_TRANSLATIONS — Previous Translation Account Balances. FIN table in the standard Ross ERP 8.0 schema: 21 columns, used by 4 programs. Columns, data types, keys, foreign keys and relationships.

Open GL_PREVIOUS_TRANSLATIONS in the interactive Data Dictionary →

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

Columns

#ColumnTypeKeyDescription
1GEM_DBKEYintGEMBASE internal surrogate primary key: a system-generated unique row identifier (the database key). Not a business field; every table carries one.
2CURRENT_YEARsmallintPKCurrent Year
3TO_CURRENCYvarchar(6)PK
4TO_ACCOUNT_IDENTvarchar(6)PK
5FROM_ACCOUNT_IDENTvarchar(6)PK
6FROM_CURRENCYvarchar(6)PK
7ACCOUNT_NUMBERvarchar(50)PKGL Account Number
8GL_PREVIOUS_BALANCE_01numeric(20,2)
9GL_PREVIOUS_BALANCE_02numeric(20,2)
10GL_PREVIOUS_BALANCE_03numeric(20,2)
11GL_PREVIOUS_BALANCE_04numeric(20,2)
12GL_PREVIOUS_BALANCE_05numeric(20,2)
13GL_PREVIOUS_BALANCE_06numeric(20,2)
14GL_PREVIOUS_BALANCE_07numeric(20,2)
15GL_PREVIOUS_BALANCE_08numeric(20,2)
16GL_PREVIOUS_BALANCE_09numeric(20,2)
17GL_PREVIOUS_BALANCE_10numeric(20,2)
18GL_PREVIOUS_BALANCE_11numeric(20,2)
19GL_PREVIOUS_BALANCE_12numeric(20,2)
20GL_PREVIOUS_BALANCE_13numeric(20,2)
21LAST_PD_MODIFIEDsmallintLast Period Modified