Created by Miki Yanagi, last modified on Mar 02, 2022

The detail journal data is based on the source. Here are some examples of the views that contain journal data.

AP (Account Payable):

When the source is "AP", the detail data can be found in UM_GLINQ_AP_VW.

screenshot of GL inquiry- Account Payable

screenshot of GL Inquiry for AP detail


EX (Expense):

When the source is "EX", the detail data can be found in UM_GLINQ_EX_VW.

screenshot of GL inquiry - Expense

screenshot of GL Inquiry for EX detail

PAY:

When the source is "PAY", the detail data can be found in UM_GLINQ_HR_VW. For more information, go to GL Inquiry & UM_HR_ACCTG_LN page.

screenshot of GL inquiry- PAY

screenshot of GL inquiry for PAY detail

Related table and views


Reporting Tips

  • LEDGER field on these view may not be the same as the LEDGER field on JRNL_HEADER or JRNL_LN
  • SUM(MONETARY_AMOUNT) on JRNL_LN cannot be used when these views are joined and have multiple entries on the same journal line. Use SUM(UM_MONETARY_AMOUNT) field from these views.

Attachments:

image2019-11-19_15-6-28.png (image/png)
image2019-11-19_15-7-27.png (image/png)
image2019-11-19_15-10-26.png (image/png)
image2019-11-19_15-11-55.png (image/png)
image2019-11-19_15-15-25.png (image/png)
image2019-11-19_15-16-16.png (image/png)