GL_SHORT_CODES

GL Short Codes

tableFINGL

GL_SHORT_CODES — GL Short Codes. FIN table in the standard Ross ERP 8.0 schema: 23 columns, used by 195 programs. Columns, data types, keys, foreign keys and relationships.

Open GL_SHORT_CODES 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	COMPANY_CODE	varchar(10)	PK	Company Code
3	GL_SHORT_CODE	varchar(6)	PK	General Ledger Short Code
4	SHORT_GL_DESCRIPTION	varchar(30)		Short Code Description
5	PATCHING_FLAG	varchar(1)		GL Account Patched
6	ACCOUNT_NUMBER	varchar(50)	FK→GL_ACCOUNTS	GL Account Number
7	GL_ELEMENT_01	varchar(10)
8	GL_ELEMENT_02	varchar(10)
9	GL_ELEMENT_03	varchar(10)
10	GL_ELEMENT_04	varchar(10)
11	GL_ELEMENT_05	varchar(10)
12	GL_ELEMENT_06	varchar(10)
13	GL_ELEMENT_07	varchar(10)
14	GL_ELEMENT_08	varchar(10)
15	GL_ELEMENT_09	varchar(10)
16	GL_ELEMENT_10	varchar(10)
17	GL_ELEMENT_11	varchar(10)
18	GL_ELEMENT_12	varchar(10)
19	GL_ELEMENT_13	varchar(10)
20	GL_ELEMENT_14	varchar(10)
21	GL_ELEMENT_15	varchar(10)
22	GL_ALLOW_ANALYSIS_CODES	varchar(1)		Allow GL Postings Analysis Codes
23	PA_WBS_REQUIRED	smallint		PA Required

Referenced by · 110 foreign keys