The following tables can be found in the Financials database, however should NOT be used for reporting as they serve different functions:
- UM_GLINQ_SRCH - Ledger Data
- UM_GLINQ_SRCHVW - View for GL Inq search
- UM_GLQ_BALN2_VW - Ledger Data
- UM_GLQ_BAL_N_VW - Ledger Data
- UM_GLQ_ENCUMRPT - Tmp EXCEL Journal Detail Data
- UM_GLQ_ENCUM_VW - temporay table
- UM_GLQ_EXCL_TBL - Ledger Data
- UM_GLQ_QRY_CNTL
- UM_GLQ_RPT_TBL - Ledger Data
UM_GLQ_SUMMARY - Ledger Data - This table is used primarily to support the on-line functions of the GL Inqury tool, and not recommend it be used for reports outside the GL Inquiry tool.
- UM_GLQ_XL_J_TBL - Tmp EXCEL Journal Detail Data
- UM_GLQ_XL_P_TBL - Tmp EXCELPayroll Detail Data
- UM_GL_JRNLRPT1 - GL Inquiry Journal Detail
List of tables and views:
(This list does NOT include all tables and views in MaineStreet.)
- APPR_INST_VW - Approval Instance Log View
- BUS_UNIT_TBL_FS - PS/Financials Business Units
- CAL_DETP_TBL - Detail Calendar Periods
- CF_ATTRIB_TBL - CFs and Attribute values
- CF_ATTRIB_VALUE - Valid CF Attrib values
- CLASS_CF_TBL - Class of Trade Table
- DEPT_TBL - Departments
- EX_TAUTH_HDR - Travel Authorization Header
- FUND_TBL - Fund Table
- GL_ACCOUNT_TBL - Accounts
- JRNL_APPR_WL - Journal Approval Worklist Rec
- JRNL_HEADER - Journal Header Data
- JRNL_LN - Journal Line Data
- KK_ACTIVITY_LOG - KK budget activity record
- KK_LIQUIDATION - Comm. Cntrl. Liquidation Table
- KK_SOURCE_HDR - Comm. Cntrl. Source Hdr Table
- LEDGER_BUDG - Budget Ledger Data
- LEDGER_KK - Ledger Data
- LEDGER - Ledger Data
- OPER_UNIT_TBL - Operating Unit
- PERSONAL_DATA - EE Personal Data
- PO_HDR - Purchase Order Header
- PROGRAM_TBL - Program Table
- PROJECT_MGR - Project Manager
- PROJECT_STATUS - Project Status
- PROJECT_VW - Operational Projects View
- PROJECT - Projects
- PSTREELEAF - Tree Leaf
- PSTREENODE - Tree Node
- TREE_NODE_TBL - Tree Nodes
- UM_AIM_ACCTG_LN - AiM Work Order Accounting Line
- UM_CC_ACCTG_LN - UM ProCard Accounting Line
- UM_DIST_CAT - UM Work Study Distrib Category
- UM_DIST_RULES - UM Work Study Distrib Rules
- UM_FAST_XLAT_VW
- UM_FGLALLJOB_VW (FIN)
- UM_FGLEMPLOY_VW
- UM_GLINQ_AP_VW
- UM_GLINQ_EX_VW
- UM_GLINQ_HR_VW
- UM_GLQ_ACCTA - GL reporting account attribute
- UM_GLQ_REPRT_VW - Ledger Data
- UM_GLQ_REPRTING - Ledger Data
- UM_HR_ACCTG_LN - Payroll Accounting Line
- UM_HR_ACCTG_VW - HR Acctg Line with cf descr
- UM_HR_XREF - HR Dept Reference
- UM_JOURNAL_VW - Journal header - line details
- UM_JRNL_APPR_VW - Journal, approval, cf descr
- UM_OBJ_XLAT
- UM_PROJECT_STAT - UM Project Status
- UM_SF_ACCTG_VW
- VENDOR - Supplier Header Table
