DARTS : UMS06 (USM) UO Monthly Transaction

Report Purpose

This query shows monthly transaction details for University of Southern Maine, Auxiliary Services (formerly University Outreach) or Library.

Report Location

MyCampus > MaineStreet > Enterprise Applications > Financials > Main Menu > Reporting Tools > Query > Query Manager or Query Viewer

Report Name

• UMS_DTS_USM_UO_MON_TRANS
• UMS_DTS_USM_UO_MON_TRANS_LIB   (For library accounts only)

Report Type

Query

Prompts Required

For information on field values to enter, click the name of the prompt.

• Fiscal Year
• Accounting Period (Leave blank to get all of the periods)

Data Fields Generated

Tables Used

• A. UM_GLQ_REPRTING - Ledger Data
• B. UM_JRNL_APPR_VW - Journal, approval, cf descr
  

Criteria Used

UMS_DTS_USM_UO_MON_TRANS:

• A.DEPTID in ('6807000', '6808000', '6809000', '6813010', '6813014', '6813015', '6813016', '6813030', '6815001', '6816000', '6817000', '6812000', '6817004', '6817002', '6703000', '6702000', '6601008', '6609000', '6711000')
• A.ACCOUNT BETWEEN 30000 AND 89999
• A.FUND_CODE in ('00','03','16','20','50')
• B.LEDGER_GROUP = ACTUALS
• UPPER(B.LINE_DESCR) NOT in ('PAYROLL ENTRY - ENCUMBRANCES', 'CALCULATE YTD BEN ENCUMBRANCE', 'CALC YTD BEN ENCUMBRANCE', 'SET BENEFIT ENCUMBR TO ZERO')

UMS_DTS_USM_UO_MON_TRANS_LIB:

• A.DEPTID in ('6153000','6153003','6153004','6153011','6153016')
• A.ACCOUNT BETWEEN 30000 AND 89999

• A.FUND_CODE in ('00','20','11','10')

• B.LEDGER_GROUP = ACTUALS
• UPPER(B.LINE_DESCR) NOT in ('PAYROLL ENTRY - ENCUMBRANCES', 'CALCULATE YTD BEN ENCUMBRANCE', 'CALC YTD BEN ENCUMBRANCE', 'SET BENEFIT ENCUMBR TO ZERO')