GL_JOURNAL_CODES

GL Journal Codes

tableFINGL

GL_JOURNAL_CODES — GL Journal Codes. FIN table in the standard Ross ERP 8.0 schema: 7 columns, used by 38 programs. Columns, data types, keys, foreign keys and relationships.

Open GL_JOURNAL_CODES 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.
2GL_JOURNAL_CODEvarchar(8)PKGL Journal Code
3CODE_DESCRIPTIONvarchar(30)Code Description
4MANUAL_DOC_NUMBERvarchar(1)Manual Document Number
5TRANSACTION_NUMBERintTransaction Number
6SYS_ALLOW_NEGATIVE_POSTINGSvarchar(1)Allow Negative Postings
7COMPANY_CODEvarchar(10)PKCompany Code

Referenced by · 8 foreign keys

AP_TRANSACTION_TYPESAR_TRANSACTION_TYPESGL_PE_JOURNALSGL_TRANSACTIONSGL_TRAN_LINESIC_TRANSACTION_TYPESINVENTORY_MOVEMENTS_CONTROLTM_TRANSACTION_TYPES