Created by Corina C Larsen, last modified by Cori Schneider on Sep 24, 2019
This is a view of journal data and approval steps. The UM_JOURNAL_VW can be used if queries used this view create issues.
| Key | Record.Fieldname | Format | XLAT | Heading Text | Source table(s) |
|---|---|---|---|---|---|
| ACCOUNT - Account | Char10 | ACCOUNT | |||
| ACCOUNTING_PERIOD - Accounting Period | Num3.0 | Period | |||
| ACTIVITY_ID - Activity | Char15 | Activity | JRNL_LN | ||
| ADB_DATE - Average Daily Balance Date | Date | ADB Date | JRNL_HEADER | ||
| ADJUSTING_ENTRY - Adjusting Entry | Char1 | Adj Entry | JRNL_HEADER | ||
| APPR_INST_STATUS - Approval Instance Status | Char1 | N | Appr Stat | APPR_INST_VW | |
| BUDGET_DT - Budget Date | Date | Budg Dt | JRNL_LN | ||
| BUDGET_HDR_STATUS - Budget Checking Header Status | Char1 | N | Budget Status | JRNL_HEADER | |
| BUDGET_LINE_STATUS - Budget Checking Line Status | Char1 | N | Budget Status | JRNL_LN | |
| BUDGET_PERIOD - Budget Period | Char8 | Budget Period | JRNL_LN | ||
| BUDGET_REF - Budget Reference | Char8 | Bud Ref | JRNL_LN | ||
| BUSINESS_UNIT - Business Unit | Char5 | BUSINESS_UNIT | JRNL_HEADER | ||
| BUSINESS_UNIT_IU - Business Unit | Char5 | BUSINESS_UNIT_IU | JRNL_HEADER | ||
| BUSINESS_UNIT_PC - PC Business Unit | Char5 | PC Bus Unit | JRNL_LN | ||
| CLASS_FLD - Class Field | Char5 | CLASS_FLD | JRNL_LN | ||
| CLOSING_STATUS - Closing Status | Char1 | N | Closing Status | JRNL_LN | |
| CONTROL_TOTAL_STAT - Control Total Status | Char1 | N | Controls | JRNL_HEADER | |
| DEPTID - Department | Char10 | DEPTID | JRNL_LN | ||
| DESCR - Description | Char30 | Descr | JRNL_HEADER | ||
| DESCR_DEPTID - (Department Name) | Char30 | Department | DEPT_TBL | ||
| DESCR_OP_UNIT - Descr Operating Unit | Char30 | Descr Op Unit | OPER_UNIT_TBL | ||
| DESCR_PROGRAM - Descr Program Code | Char30 | Descr Program C | |||
| DESCR_PROJECT - Descr Project Id | Char30 | Descr Proj Id | PROJECT | ||
| DESCR1 - Descr | Char30 | Description | GL_ACCOUNT_TBL | ||
| DESCR254 - Long Description | Char254 | DESCR254 | JRNL_HEADER | ||
| DOC_SEQ_DATE - Document Sequence Date | Date | Doc Seq Date | JRNL_LN | ||
| DOC_SEQ_NBR - Document Sequence Number | Char12 | Doc Sequence # | JRNL_LN | ||
| DOC_SEQ_STATUS - Document Sequencing Status | Char1 | N | Status | JRNL_LN | |
| DOC_TYPE - Document Type | Char8 | Document Type | JRNL_LN | ||
| DTTM_STAMP - Date/Time Stamp | DateTm | Date/Time | APPR_INST_VW | ||
| DTTM_STAMP_SEC - Last Update DateTime | DateTm | DateTime | JRNL_HEADER | ||
| EE_HDR_STATUS - Entry Event Header Status | Char1 | Header Status | JRNL_HEADER | ||
| EE_PROC_STATUS - Entry Event Line Status | Char1 | EE Line Status | JRNL_LN | ||
| ENTRY_EVENT - Entry Event | Char10 | Event | JRNL_LN | ||
| FISCAL_YEAR - Fiscal Year | Num4.0 | Year | JRNL_HEADER | ||
| FOREIGN_AMOUNT - Foreign Amount | SNm25.3 | Amount | JRNL_LN | ||
| FUND_CODE - Fund Code | Char5 | FUND_CODE | JRNL_LN | ||
| GL_ADJUST_TYPE - Adjustment Type | Char4 | Adjustment | JRNL_LN | ||
| IU_SYS_TRAN_CD - System Transaction | Char8 | Transaction | JRNL_HEADER | ||
| IU_TRAN_CD - Transaction Code | Char8 | Code | JRNL_HEADER | ||
| JOURNAL_CLASS - Journal Class | Char10 | Class | JRNL_HEADER | ||
| JOURNAL_DATE - Journal Date | Date | JOURNAL_DATE | JRNL_HEADER | ||
| JOURNAL_DATE_ORIG - Orignial Journal Date | Date | Original Date | JRNL_HEADER | ||
| JOURNAL_ID - Journal ID | Char10 | JOURNAL_ID | JRNL_HEADER | ||
| JOURNAL_LINE - GL Journal Line Number | Num9.0 | JOURNAL_LINE | JRNL_LN | ||
| JOURNAL_LINE_DATE - Journal Line Date | Date | Line Date | JRNL_LN | ||
| JOURNAL_LOCKED - Journal Locked for Change | Char1 | Journal Locked | JRNL_HEADER | ||
| JRNL_BALANCE_STAT - Journal Balance Status | Char1 | N | Balanced | JRNL_HEADER | |
| JRNL_EDIT_ERR_STAT - Journal Edit Error Status | Char1 | N | Errors | JRNL_HEADER | |
| JRNL_HDR_STATUS - Journal Header Status | Char1 | N | Status | JRNL_HEADER | |
| JRNL_LINE_SOURCE - Journal Line Source | Char3 | N | JRNL_LINE_SOURCE | JRNL_LN | |
| JRNL_LINE_STATUS - Journal Line Status | Char1 | N | Status | JRNL_LN | |
| JRNL_LN_REF - Journal Line Reference | Char10 | JRNL_LN_REF | JRNL_LN | ||
| JRNL_PROCESS_REQST - Journal Processing Request | Char1 | N | Process | JRNL_HEADER | |
| JRNL_SUMLED_REQST - Post to Summary Ledger | Char1 | SL Post | JRNL_HEADER | ||
| JRNL_TOT_CREDITS - Journal Total Credits | SNm25.3 | Credits | JRNL_HEADER | ||
| JRNL_TOTAL_DEBITS - Journal Total Debits | SNm25.3 | Debits | JRNL_HEADER | ||
| JRNL_TOTAL_LINES - Journal Total Lines | Num9.0 | Lines | JRNL_HEADER | ||
| KK_AMOUNT_TYPE - Commitment Control Amount Type | Char1 | N | Amount Type | JRNL_HEADER | |
| KK_TRAN_BYPAS_FLAG - Bypass Budget Checking | Char1 | Bypass | JRNL_HEADER | ||
| LEDGER - Ledger | Char10 | Ledger | JRNL_HEADER | ||
| LEDGER_2 - Ledger | Char10 | Ledger | JRNL_LN | ||
| LEDGER_GROUP - Ledger Group | Char10 | Ledger Grp | JRNL_HEADER | ||
| LINE_DESCR - Journal Line Description | Char30 | LINE_DESCR | JRNL_LN | ||
| MONETARY_AMOUNT - Monetary Amount | SNm25.3 | Sum Amount | JRNL_LN | ||
| MOVEMENT_FLAG - Movement Flag | Char1 | N | N/R | JRNL_LN | |
| NAME - Name | Char50 | NAME | |||
| NAME50 - Name | Char50 | NAME50 | PERSONAL_DATA | ||
| OPERATING_UNIT - Operating Unit | Char8 | Oper Unit | JRNL_LN | ||
| OPRID - User ID | Char30 | OPRID | JRNL_HEADER | ||
| PC_DISTRIB_STATUS - PC Distribution Status | Char1 | N | PC Status | JRNL_LN | |
| POSTED_DATE - Date Posted | Date | POSTED_DATE | JRNL_HEADER | ||
| PROCESS_INSTANCE - Process Instance | Num10.0 | Instance | JRNL_HEADER | ||
| PROCESS_INSTANCE2 - Process Instance | Num10.0 | Instance | JRNL_LN | ||
| PROGRAM_CODE - Program Code | Char5 | PROGRAM_CODE | JRNL_LN | ||
| PROJECT_ID - Project | Char15 | PROJECT_ID | JRNL_LN | ||
| REVERSAL_ADJ_PER - Adjustment Period | Num3.0 | Period | JRNL_HEADER | ||
| REVERSAL_CD - Reversal Code | Char1 | N | Reversal | JRNL_HEADER | |
| REVERSAL_CD_ADB - ADB Reversal Code | Char1 | N | ADB Reversal | JRNL_HEADER | |
| REVERSAL_DATE - Reversal Date | Date | Date | JRNL_HEADER | ||
| REVERSAL_DATE_ADB - ADB Reversal Date | Date | ADB Reversal | JRNL_HEADER | ||
| ROLEUSER - User ID | Char30 | User ID | |||
| SCENARIO - Scenario | Char10 | Scenario | JRNL_LN | ||
| SOURCE - Source | Char3 | SOURCE | JRNL_HEADER | ||
| SOURCE_INSTANCE - Source Instance | Num11.4 | Instance | JRNL_HEADER | ||
| STATISTIC_AMOUNT - Statistic Amount | SNm15.2 | Stat Amt | JRNL_LN | ||
| STATISTICS_CODE - Statistics Code | Char3 | Stat | JRNL_LN | ||
| SUSP_RECON_STATUS - Suspense Reconciliation Status | Char1 | N | Suspense Status | JRNL_HEADER | |
| SUSPENDED_LINE - Suspended Journal Line Number | Num9.0 | Suspended Line | JRNL_LN | ||
| SYSTEM_SOURCE - System Source | Char3 | N | Sys Source | JRNL_HEADER | |
| TRANS_REF_NUM - Reference Number | Char8 | Ref No | JRNL_HEADER | ||
| TRANSACTION_DATE - Transaction Date | Date | Trans Date | JRNL_HEADER | ||
| UNPOST_JRNL_DATE - Unpost Date | Date | Unpost Date | JRNL_HEADER | ||
| UNPOST_SEQ - UnPost Sequence | Num2.0 | Seq | JRNL_HEADER |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.
