EM_PYCY_DATA_LN

(SQL View)
 Index Back

Approved payments - lang vw

EBPP-Added 2000/10/09-Last Mod 2000/10/09 by Matthias Davet View used on the level 1 of the EM_PAY_PAGE page.

SELECT DISTINCT a.pay_cycle , a.pay_cycle_seq_num , a.source_txn , a.business_unit , a.pay_doc_id , a.pay_doc_seq , a.pycycl_key_field1 , a.pycycl_key_field2 , a.pycycl_key_field3 , LN.LANGUAGE_CD , a.remit_setid , a.remit_vendor , a.vendor_name_short , b.vendor_setid , b.vendor_id , LN.vendor_name_short FROM ps_pycycl_data a , PS_VOUCHER b , ps_pymnt_vchr_xref c , ps_vendor e , PS_VENDOR_LANG LN WHERE a.PYMNT_SELCT_STATUS IN ('R','D') AND a.business_unit = b.business_unit AND a.pay_doc_id = b.voucher_id AND a.pay_cycle = c.pay_cycle AND a.pay_cycle_seq_num = c.pay_cycle_seq_num AND a.business_unit = c.business_unit AND a.pay_doc_id = c.voucher_id AND a.PAY_DOC_SEQ = c.pymnt_cnt AND e.setid = b.vendor_setid AND e.vendor_id = b.vendor_id AND e.setid = LN.setid AND e.vendor_id = LN.vendor_id

  • Related Language Record for EM_PYCY_DATA_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle
    2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    3 SOURCE_TXN Character(4) VARCHAR2(4) NOT NULL Source Transaction
    4 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    5 PAY_DOC_ID Character(20) VARCHAR2(20) NOT NULL Advice ID
    6 PAY_DOC_SEQ Number(5,0) INTEGER NOT NULL Advice Sequence
    7 PYCYCL_KEY_FIELD1 Character(20) VARCHAR2(20) NOT NULL Pay Cycle Mapping Key Field 1
    8 PYCYCL_KEY_FIELD2 Date(10) DATE Pay Cycle Mapping Key Field 2
    9 PYCYCL_KEY_FIELD3 Number(15,0) DECIMAL(15) NOT NULL Pay Cycle Mapping Key Field 3
    10 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    11 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
    12 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    13 PV_VNDR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Supplier Name
    14 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    15 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    16 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name