DARTS : UM_GLINQ_AP_VW

This view is based on JRNL_HEADER, JRNL_LN, vchr_acctg_line, voucher, voucher_line, and vchr_vndr_info tables in FNPRD.

Key	Record.Fieldname	Format	Heading Text	Notes
	ACCOUNT - Account	Char10	Account
	ACCOUNTING_PERIOD - Accounting Period	Num3.0	Period
	APPL_JRNL_ID - Journal Template	Char10	Template
→	BUSINESS_UNIT - Business Unit	Char5	Unit
	CLASS_FLD - Class Field	Char5	Class
	DEPTID - Department	Char10	Dept
	DESCR - Description	Char30	Descr
	DESCR254_MIXED - More Information	Char254	More Info
	FISCAL_YEAR - Fiscal Year	Num4.0	Year
	FUND_CODE - Fund Code	Char5	Fund
	INVOICE_DT - Invoice Date	Date	Date
	INVOICE_ID - Invoice Number	Char30	Invoice
→	JOURNAL_DATE - Journal Date	Date	Date
→	JOURNAL_ID - Journal ID	Char10	Journal ID
→	JOURNAL_LINE - GL Journal Line Number	Num9.0	Line #
→	LEDGER - Ledger	Char10	Ledger	Use LEDGER_GROUP from UM_JOURNAL_VW when you join
	NAME1 - Name 1	Char40	Name
	OPERATING_UNIT - Operating Unit	Char8	Oper Unit
	PO_ID - PO Number	Char10	PO No.
	PROGRAM_CODE - Program Code	Char5	Program
	PROJECT_ID - Project	Char15	Project
	UM_MONETARY_AMOUNT - Monetary Amount	SNm25.2	Amount
→	UNPOST_SEQ - UnPost Sequence	Num2.0	Seq
	VENDOR_ID - Supplier ID	Char10	Supplier
	VOUCHER_ID - Voucher ID	Char8	Voucher

SQL for PS_UM_GLINQ_AP_VW

SELECT
 C.business_unit_gl,
 C.journal_id,
 C.journal_date,
 C.unpost_seq,
 C.journal_line,
 C.ledger,
 C.fiscal_year,
 C.accounting_period,
 C.deptid,
 C.project_id,
 C.program_code,
 C.fund_code,
 C.operating_unit,
 C.account,
 C.class_fld,
 C.appl_jrnl_id,
 C.foreign_amount,
 C.po_id,
 C.voucher_id,
 F.descr254_mixed,
 F.descr,
 D.invoice_id,
 D.invoice_dt,
 D.vendor_id,
 (CASE
   WHEN D.Voucher_style = 'SGLP' THEN
    h.name1
   ELSE
    b.line_descr
 END) line_descr
  FROM ps_jrnl_header     A,
       ps_jrnl_ln         B,
       ps_vchr_acctg_line C,
       ps_voucher         D,
       ps_voucher_line    F,
       ps_vchr_vndr_info  h
 WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT
   AND A.JOURNAL_ID = B.JOURNAL_ID
   AND A.JOURNAL_DATE = B.JOURNAL_DATE
   AND A.UNPOST_SEQ = B.UNPOST_SEQ
   AND C.journal_id = B.journal_id
   AND C.business_unit_gl = B.business_unit
   AND C.journal_date = B.journal_date
   AND C.journal_line = B.journal_line
   AND C.ledger = B.ledger
   AND D.voucher_id = C.voucher_id
   AND c.voucher_id = h.voucher_id(+)
   AND D.business_unit = C.business_unit
   AND F.voucher_id = D.voucher_id
   AND F.voucher_line_num = C.voucher_line_num
   AND F.business_unit = C.business_unit
   AND A.JRNL_HDR_STATUS = 'P'
   AND A.system_source = 'GAP'
   AND C.DST_ACCT_TYPE IN ('DST', 'DSE', 'DSL')
   AND C.TAX_AUTHORITY_CD = ' '
   AND D.VENDOR_setid = 'UMSYS';