Queries

DAILY
________

UMF_GA_SYS_USED_CASH_DT_NBR
Confirms if the CashNet Receipt number is a duplicate.

UMF_GA_SYS_CASH_JRNL_VERIFY
Credit NOT on 990,991.

UMF_GA_SYS_CASH_JRNL_VERIFY2
Line has account 1101015. Please check account.

UMF_GA_SYS_CASH_JRNL_VERIFY_LE
Confirms if the CashNet Receipt number is too short.

 

RESEARCH
___________
UMF_COMBO_SEQ_SEARCH_DD
Enter Project ID — query shows all the rules that this project lives including account number.

UM_DD_COMBORULE_PROMPT_PRJ92
Enter Project ID — query shows all the rules that this project lives. No account number.

UM_DD_ACCT_CODE_VERIFY92_ACCT
Enter Fund and Account number — query lists all the departments with that combination.

UM_DD_ACCT_CODE_VERIFY92_DEPT
Enter Department id.