DARTS : UM_GLINQ_HR_VW

This is a view of the UM_HR_ACCTG_LN - Payroll Accounting Line table in FNPRD.

MAX of line_descr and SUM of monetary_amount are calculated in this view. See SQL code at right.

Key	Record.Fieldname	Format	XLAT	Heading Text
	ACCOUNT - Account	Char10		Account
	ACCOUNTING_PERIOD - Accounting Period	Num3.0		Period
→	BUSINESS_UNIT - Business Unit	Char5		Unit
	CLASS_FLD - Class Field	Char5		Class
	DEPTID - Department	Char10		Dept
	FISCAL_YEAR - Fiscal Year	Num4.0		Year
	FUND_CODE - Fund Code	Char5		Fund
→	JOURNAL_DATE - Journal Date	Date		Date
→	JOURNAL_ID - Journal ID	Char10		Journal ID
→	JOURNAL_LINE - GL Journal Line Number	Num9.0		Line #
	JRNL_LN_REF - Journal Line Reference	Char10		Ref
	KK_AMOUNT_TYPE - Commitment Control Amount Type	Char1	N	Amount Type
→	LEDGER - Ledger	Char10		Ledger
	LEDGER_GROUP - Ledger Group	Char10		Ledger Grp
	LINE_DESCR - Journal Line Description	Char30		Line Descr
	OFF_CYCLE - Off Cycle ?	Char1		Off Cycle
	OPERATING_UNIT - Operating Unit	Char8		Oper Unit
	PAY_END_DT - Pay Period End Date	Date		End Date
	PAYGROUP - Pay Group	Char3		Group
	POSITION_NBR - Position Number	Char8		Position
	PROGRAM_CODE - Program Code	Char5		Program
	PROJECT_ID - Project	Char15		Project
	RUN_ID - Run ID	Char25		Run ID
	UM_DEPTID_HR - HR Department	Char10		HE Dept
	UM_MONETARY_AMOUNT - Monetary Amount	SNm25.2		Amount

Data Dictionary Links

Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.

SQL code for UM_GLINQ_HR_VW

SELECT c.fiscal_year,
       c.accounting_period,
       c.business_unit_gl,
       c.deptid,
       c.program_code,
       c.fund_code,
       c.project_id,
       c.operating_unit,
       c.journal_id,
       c.journal_date,
       c.journal_line,
       c.ledger,
       c.ledger_group,
       c.account,
       c.class_fld,
       c.paygroup,
       c.pay_end_dt,
       c.off_cycle,
       c.run_id,
       c.jrnl_ln_ref,
       MAX(c.line_descr),
       SUM(c.monetary_amount),
       c.position_nbr,
       c.um_deptid_hr,
       c.kk_amount_type
  FROM ps_um_hr_acctg_ln C
 GROUP BY c.fiscal_year,
          c.accounting_period,
          c.business_unit_gl,
          c.deptid,
          c.program_code,
          c.fund_code,
          c.project_id,
          c.operating_unit,
          c.journal_id,
          c.journal_date,
          c.journal_line,
          c.ledger,
          c.ledger_group,
          c.account,
          c.class_fld,
          c.paygroup,
          c.pay_end_dt,
          c.off_cycle,
          c.run_id,
          c.jrnl_ln_ref,
          c.position_nbr,
          c.um_deptid_hr,
          c.kk_amount_type;