The journal data on GL Inquiry page in Finance MaineStreet comes from multiple sources. One of the table is UM_HR_ACCTG_LN.
To get GL Inquiry page, log in MaineStreet then go to Enterprise Applications > Financials > University of Maine System > General Ledger > Lookup Items > GL Inquiry
Enter Fiscal Year, Accounting Period, and search for your department, program or project.
Then, click the amount with underline.
Click one more time on the amount.
Finally this journal data can be found.
Here is the relationships between these fields and UM_HR_ACCTG_LN.
| Field in GL Inquiry | Field in UM_HR_ACCTG_LN |
|---|---|
| Account | ACCOUNT |
| Class | CLASS_FLD |
| Journal ID | JOURNAL_ID |
| Journal Date | JOURNAL_DATE |
| Pay Group | PAYGROUP |
| Pay End Date | PAY_END_DT |
| Off Cycle | OFF_CYCLE |
| Pay Run ID | RUN_ID |
| Position Nbr | POSITION_NBR |
| HR Dept | UM_DEPTID_HR |
| Emplid | JRNL_LN_REF |
| Name | MAX(LINE_DESCR) |
| Amount* | SUM(MONETARY_AMOUNT) |
*Need to be cautious about the amount when joining the journal table. The amount from the journal table is SUM and may not be one-to-one join.
UM_HR_ACCTG_LN table may have more lines than what's on the journal table.
UM_GLINQ_HR_VW, which is a view of UM_HR_ACCTG_LN, can be used to pull the journal data as well.
Attachments:
image2019-10-28_15-14-25.png (image/png)
image2019-10-25_15-52-52.png (image/png)
image2019-10-25_15-38-2.png (image/png)
image2019-10-25_15-34-50.png (image/png)
image2019-10-30_15-48-9.png (image/png)
image2019-10-30_15-49-45.png (image/png)
image2019-10-30_15-52-15.png (image/png)