Finance S Internal Documentidentifying Journal Entry Transactions

Finance S Internal Documentidentifying Journal Entry Transactions

Finance Services’s Internal document to Identify Journal Entry Transactions (8.9)

JE Prefix / Type of transaction / USERID:Process name / Freq. / Prerequisites / Table
00 / Journal Entry / Manual / None / Daily / None / JRNL_HEADER & JRNL_LN
ADD / Asset Additions / Manual / FS_JGEN / Periodic / FSPRD: FIN_RPTNG jgen
(dates may reflect date depending on open GL Period) / DIST_LN_JG_VW
ADJ / Asset Adjust. &Transfers / Manual / FS_JGEN / Periodic / FSPRD: FIN_RPTNG jgen, (AM_AMAEDIST) / DIST_LN_JG_VW
AP / Accounts Payable
(Pcard trx, Manual closures, Cancelled Payments) / 1:30pm / TKUONEN:FS_JGEN / Daily / FSPRD:UM_PCARD
Margo creates vouchers from load
Other vouchers/payment requests
(dates may reflect date of voucher not sysdat) / VCHR_ACCTG_LINE
AR / Accounts Receivable (this is typically a credit on the report) / 6:00am / UMCMN01:FS_JGEN / Daily / ITEM_DST_CC_VW
ARDJ / AR Direct Cash Journal / 2:10 pm / RSTRUCK: FS_JGEN / Daily / FSPRD:UMCNETIN @ 3am afinn
Budget Check 2pm: Receivable > Receivables Update > Revenue Estimates > Budget Check Transaction / 3rd Lightning Bolt
2ndPAY_MISC_DST 1st UM_CNET_STG
BI / Billing Journals / 6:00am / UMCMN01:FS_JGEN / Daily / JALRUB: 12am UMBIJ03K has BILDGL01 as a multi level process. This populates BI_ACCT_ENTRY / BI_ACCT_ENTRY
GDR
replaced CADFR / Deferred Revenue / 5:30am / UMCMN01: FS_JGEN / Daily / PC__TO_PC Pricing or UMGMFACR / CA_ACCTG_LN_PC
Inherit Acct Date
CAGM / CA Grants / 4:00am / JALRUB:UMGMJ009 includes JGEN / Daily / PSA_ACCTGGL runs as part of UMGMJ009
(dates may reflect date from original transaction depending on open GL Period) / CA_ACCTG_LN_PC
Inherit Acct Date
DEPR / Depreciation Expense / Manual / FS_JGEN / Periodic / (dates may reflect date depending on open GL Period) / DIST_LN_JG_VW
EM / E-Market (Cashnet/Higher1) / 11:30am / TKUONEN: FS_JGEN / Daily / FSPRD: UM_CNET_GL from afinn @ 6:00am / JGEN_ACCT_ENTRY
GM / F&A Calculation / 5:00am / TKUONEN: FS_JGEN / Daily / UMGMFACR @ 1:00am jalrub. / CA_ACCTG_LN_PC
Date is from PC, controlled on Run Control JALRUB
PAY / Payroll Journals / Manual / PACECA,RSTRUCK,
TKUONEN / Bi-weekly / CSPRD: UMPYGL02 creates HR rows, but UM_HRACT_PST pulls the data in, run from within FSPRD / HR_ACCTG_LINE
PK / Parking JE (Cashnet) / 1:30pm / TKUONEN:FS_JGEN / Daily / FSPRD: UM_T2_GL_IN @11:30am tkuonen / JGEN_ACCT_ENTRY
RET / Asset Retirements / Manual / FS_JGEN / Periodic / FSPRD: FIN_RPTNG jgen / DIST_LN_JG_VW
SHR / Shriver EMarket / 6:15am / TKUONEN:FS_JGEN / Daily / FSPRD:
SF / Student Finance / 7:30am / RSTRUCK:UMSAJGEN / Daily / CSPRD: SFPGLINTGSABA creates sf rows, EOP_PUBLISHM GSABA actually sends the data to FSPRD. / SF_ACCTG_LN

Confirm at YEAR-END that pre-requisite processes are restarted PLUS Run Controls !