PYMT_TR_PPAY_VW

(SQL View)
 Index Back

Pymnt Trms Eff Vw for PPAY


SELECT A.SETID , A.PYMNT_TERMS_CD , B.EFFDT , A.DESCRSHORT , A.DESCR , A.PYMNT_TERMS_TYPE , B.PYMNT_TERMS_APPLIC , B.NBR_OF_TERMS FROM PS_PYMT_TRMS_HDR A , PS_PYMT_TRMS_CNTL B WHERE B.SETID = A.SETID AND B.PYMNT_TERMS_CD = A.PYMNT_TERMS_CD AND A.PYMNT_TERMS_TYPE <> 'M' AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_PYMT_TRMS_CNTL B1 WHERE B1.SETID = B.SETID AND B1.PYMNT_TERMS_CD = B.PYMNT_TERMS_CD AND B1.EFFDT <= %CurrentDateIn) AND B.EFF_STATUS = 'A' AND NOT EXISTS( SELECT 'X' FROM PS_PYMT_TRMS_DSCNT D WHERE D.SETID = B.SETID AND D.PYMNT_TERMS_CD = B.PYMNT_TERMS_CD) AND NOT EXISTS( SELECT 'X' FROM PS_PYMT_TRMS_NET E WHERE E.SETID = B.SETID AND E.PYMNT_TERMS_CD = B.PYMNT_TERMS_CD AND E.REBATE_TERM_FLG = 'Y')

  • Related Language Record: PYMT_TR_VW_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETID_NONVW

    2 PYMNT_TERMS_CD Character(5) VARCHAR2(5) NOT NULL Specifies how the payment due date and discount due date are calculated. A payment terms code is associated with various business units bill-to customers vendors as well as sales orders purchase orders and vouchers.
    3 EFFDT Date(10) DATE NOT NULL Effective Date
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 PYMNT_TERMS_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Terms Type
    M=Multi-Payment Terms
    S=Single-Payment Terms
    7 PYMNT_TERMS_APPLIC Character(1) VARCHAR2(1) NOT NULL Terms Applicability
    A=All (Unrestricted)
    C=Customer-Only Terms
    V=Supplier-Only Terms
    8 NBR_OF_TERMS Number(2,0) SMALLINT NOT NULL Number of Terms