DARTS : UM_GLINQ_EX_VW

This view is a combination of EX_ACCTG_LINE, EX_SHEET_HDR, and PERSONAL_DATA tables in FNPRD.

EX stands for expense.

Key	Record.Fieldname	Format	XLAT	Heading Text	Source Table
	ACCOUNT - Account	Char10		Account	EX_ACCTG_LINE
	ACCOUNTING_PERIOD - Accounting Period	Num3.0		Period	EX_ACCTG_LINE
	BUSINESS_PURPOSE - Business Purpose	Char5		Purpose	EX_SHEET_HDR
→	BUSINESS_UNIT - Business Unit	Char5		Unit	EX_ACCTG_LINE
	CLASS_FLD - Class Field	Char5		Class	EX_ACCTG_LINE
	DEPTID - Department	Char10		Dept	EX_ACCTG_LINE
	EX_DOC_ID - Expenses Document ID	Char10		ID	EX_ACCTG_LINE
	EX_DOC_TYPE - Expenses Document Type	Char1	N	Doc Type	EX_ACCTG_LINE
	FISCAL_YEAR - Fiscal Year	Num4.0		Year	EX_ACCTG_LINE
	FUND_CODE - Fund Code	Char5		Fund	EX_ACCTG_LINE
	IU_SYS_TRAN_CD - System Transaction	Char8		Transaction	EX_ACCTG_LINE
→	JOURNAL_DATE - Journal Date	Date		Date	EX_ACCTG_LINE
→	JOURNAL_ID - Journal ID	Char10		Journal ID	EX_ACCTG_LINE
→	JOURNAL_LINE - GL Journal Line Number	Num9.0		Line #	EX_ACCTG_LINE
→	LEDGER - Ledger	Char10		Ledger	EX_ACCTG_LINE
	NAME - Name	Char50		Name	PERSONAL_DATA
	OPERATING_UNIT - Operating Unit	Char8		Oper Unit	EX_ACCTG_LINE
	PROGRAM_CODE - Program Code	Char5		Program	EX_ACCTG_LINE
	PROJECT_ID - Project	Char15		Project	EX_ACCTG_LINE
	REFERENCE_ID - Reference Number	Char10		Reference	EX_SHEET_HDR
	SHEET_NAME - Report Description	Char30		Report Descr	EX_SHEET_HDR
	UM_MONETARY_AMOUNT - Monetary Amount	SNm25.2		Amount	EX_ACCTG_LINE
→	UNPOST_SEQ - UnPost Sequence	Num2.0		Seq	EX_ACCTG_LINE

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_EX_VW

SELECT c.fiscal_year,
       c.accounting_period,
       c.business_unit_gl,
       c.deptid,
       c.program_code,
       c.project_id,
       c.fund_code,
       c.operating_unit,
       c.journal_id,
       c.journal_date,
       c.unpost_seq,
       c.journal_line,
       c.ledger,
       c.account,
       c.class_fld,
       c.ex_doc_type,
       c.ex_doc_id,
       d.name,
       c.monetary_amount,
       c.iu_sys_tran_cd,
       e.sheet_name,
       e.business_purpose,
       e.reference_id
  FROM ps_ex_acctg_line c, ps_personal_data d, ps_ex_sheet_hdr e
 WHERE d.emplid(+) = c.emplid
   AND e.sheet_id(+) = c.ex_doc_id
   AND e.emplid(+) = c.emplid;