PYCYCL_NV_VWLG

(SQL View)
 Index Back

Neg Balances by Vndr Lg


SELECT DISTINCT a.pay_cycle , a.pay_cycle_seq_num , a.remit_setid , a.remit_vendor , b.remit_addr_seq_num , a.pymnt_method , c.language_cd , c.name1 FROM PS_PYCYCL_DATA a , ps_vendor b , ps_vendor_lang c WHERE a.pymnt_selct_status='D' AND a.pay_cycle <> ' ' AND a.pay_cycle_seq_num > 0 AND a.pymnt_separate IN ('N','C') AND b.setid=a.remit_setid AND b.vendor_id=a.remit_vendor AND b.setid = c.setid AND b.vendor_id = c.vendor_id

  • Related Language Record for PYCYCL_NGVND_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PAY_CYCLE Character(6) VARCHAR2(6) NOT NULL Pay Cycle

    Prompt Table: SP_PYCYCL_NONVW

    2 PAY_CYCLE_SEQ_NUM Number(6,0) INTEGER NOT NULL Pay Cycle Sequence Number
    3 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID

    Default Value: OPR_VNDR_VW_AP.VENDOR_SETID

    Prompt Table: SP_SETRMT_NONVW

    4 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    5 REMIT_ADDR_SEQ_NUM Number(5,0) INTEGER NOT NULL Remitting Location
    6 PYMNT_METHOD Character(3) VARCHAR2(3) NOT NULL Payment Method
    ACH=Automated Clearing House
    BEF=Draft - Customer EFT
    BOO=Draft - Customer Initiated
    CHK=System Check
    D=Deposit
    DD=Direct Debit
    DFT=Draft - Supplier Initiated
    DRA=Draft
    EFT=Electronic Funds Transfer
    GE=Giro - EFT
    GM=Giro - Manual
    LC=Letter of Credit
    MAN=Manual Check
    TRW=Treasury Wire
    WIR=Wire Transfer
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1