GL_POSTINGS_HISTORY
GL Postings History
tableFINGL
GL_POSTINGS_HISTORY — GL Postings History. FIN table in the standard Ross ERP 8.0 schema: 34 columns, used by 2 programs. Columns, data types, keys, foreign keys and relationships.
Open GL_POSTINGS_HISTORY 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) | Company Code | |
| 3 | SOURCE_MODULE | varchar(2) | Source Module Reference | |
| 4 | DIVISION | varchar(2) | Division | |
| 5 | POSTING_REFERENCE | varchar(20) | Postings Reference | |
| 6 | GL_SHORT_CODE | varchar(6) | General Ledger Short Code | |
| 7 | ACCOUNT_NUMBER | varchar(50) | GL Account Number | |
| 8 | COST_CENTER | varchar(3) | Cost Center Code | |
| 9 | WAREHOUSE | varchar(2) | Warehouse Code | |
| 10 | FACTORY | varchar(2) | Factory Code | |
| 11 | POSTING_DATE | datetime | Posting Date | |
| 12 | PERIOD | smallint | Period Number | |
| 13 | YEAR | smallint | Year Number | |
| 14 | SOURCE_REFERENCE | varchar(20) | Source Reference | |
| 15 | POSTING_DESCRIPTION | varchar(30) | Posting Description | |
| 16 | SUMMARIZATION_FLAG | varchar(1) | Summarization/Non-summarization flag | |
| 17 | BATCH_NUMBER | int | Run Number | |
| 18 | M_BATCH_NUMBER | int | Multiple Trans Batch Number | |
| 19 | JOURNAL_NUMBER | int | Journal Number | |
| 20 | JOURNAL_LINE | smallint | Journal Line | |
| 21 | ACCOUNT_IDENT | varchar(6) | Balance Type Identifier | |
| 22 | FIFO_DOC | varchar(10) | FIFO Originating Doc | |
| 23 | POSTING_RUN | int | Posting Run Number | |
| 24 | MODULE_TRANSACTION_TYPE | varchar(6) | Transaction Type | |
| 25 | GL_POSTING_BASE | numeric(20,2) | GL Posting Value in Base Currency | |
| 26 | GL_POSTING_CURRENCY | numeric(20,2) | GL Posting Value in entered currency | |
| 27 | SYS_CURRENCY_CODE | varchar(6) | Currency Code | |
| 28 | SYS_CURRENCY_RATE | numeric(20,12) | Currency Rate | |
| 29 | SYS_BASE_CURRENCY_CODE | varchar(6) | ||
| 30 | SYS_CURRENCY_METHOD | varchar(1) | Currency Method | |
| 31 | SYS_CURRENCY_RATIO_INDIC | varchar(1) | Ratio Indicator | |
| 32 | GL_ANALYSIS_CODE_1 | varchar(15) | GL Analysis Code | |
| 33 | GL_ANALYSIS_CODE_2 | varchar(15) | GL Analysis Code | |
| 34 | GL_ANALYSIS_CODE_3 | varchar(18) | GL Analysis Code |