GL_PE_JOURNALS
General Ledger Period End Journals
tableFINGL
GL_PE_JOURNALS — General Ledger Period End Journals. FIN table in the standard Ross ERP 8.0 schema: 44 columns, used by 12 programs. Columns, data types, keys, foreign keys and relationships.
Open GL_PE_JOURNALS 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 | PE_JOURNAL_CODE | varchar(6) | PK | Period End Journal Code |
| 4 | PE_JOURNAL_CREATION_DATE | datetime | Period End Journal Creation Date | |
| 5 | BALANCE_TO_ZERO | numeric(20,2) | Voucher Balances to Zero | |
| 6 | CODE_DESCRIPTION | varchar(30) | Code Description | |
| 7 | TRANSACTION_TYPE | varchar(2) | Transaction Type | |
| 8 | PE_UPDATE_01 | varchar(2) | Journal Flag for Period 01 | |
| 9 | PE_UPDATE_02 | varchar(2) | ||
| 10 | PE_UPDATE_03 | varchar(2) | ||
| 11 | PE_UPDATE_04 | varchar(2) | ||
| 12 | PE_UPDATE_05 | varchar(2) | ||
| 13 | PE_UPDATE_06 | varchar(2) | ||
| 14 | PE_UPDATE_07 | varchar(2) | ||
| 15 | PE_UPDATE_08 | varchar(2) | ||
| 16 | PE_UPDATE_09 | varchar(2) | ||
| 17 | PE_UPDATE_10 | varchar(2) | ||
| 18 | PE_UPDATE_11 | varchar(2) | ||
| 19 | PE_UPDATE_12 | varchar(2) | ||
| 20 | PE_UPDATE_13 | varchar(2) | ||
| 21 | PE_JOURNAL_TYPE | varchar(1) | PE Journal Type | |
| 22 | UPDATE_STATUS | varchar(1) | Status of this record | |
| 23 | STATUS_FLAG | varchar(1) | Status Flag | |
| 24 | PE_STATUS_01 | varchar(2) | ||
| 25 | PE_STATUS_02 | varchar(2) | ||
| 26 | PE_STATUS_03 | varchar(2) | ||
| 27 | PE_STATUS_04 | varchar(2) | ||
| 28 | PE_STATUS_05 | varchar(2) | ||
| 29 | PE_STATUS_06 | varchar(2) | ||
| 30 | PE_STATUS_07 | varchar(2) | ||
| 31 | PE_STATUS_08 | varchar(2) | ||
| 32 | PE_STATUS_09 | varchar(2) | ||
| 33 | PE_STATUS_10 | varchar(2) | ||
| 34 | PE_STATUS_11 | varchar(2) | ||
| 35 | PE_STATUS_12 | varchar(2) | ||
| 36 | PE_STATUS_13 | varchar(2) | ||
| 37 | INTERCOMPANY_POSTINGS | varchar(1) | Intercompany Postings | |
| 38 | JOURNAL_DETAIL_DESCRIPTION | text | Journal Detail Description | |
| 39 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 40 | SYS_RATE_AUTHORITY | varchar(6) | Currency Rate Authority | |
| 41 | SYS_RATE_TYPE | varchar(6) | Currency Rate Type | |
| 42 | GL_JOURNAL_CODE | varchar(8) | FK→GL_JOURNAL_CODES | GL Journal Code |
| 43 | MODULE_TRANSACTION_TYPE | varchar(6) | Transaction Type | |
| 44 | SYS_BASE_CURRENCY_CODE | varchar(6) |