PYMT_TRMS_DM_VW

(SQL View)
 Index Back

Payment Terms Effective View


SELECT A.SETID , A.PYMNT_TERMS_CD , B.EFFDT , B.EFF_STATUS , 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 = 'S' AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_PYMT_TRMS_CNTL B_ED WHERE B.SETID = B_ED.SETID AND B.PYMNT_TERMS_CD = B_ED.PYMNT_TERMS_CD AND B_ED.EFFDT <= %CurrentDateIn) AND EXISTS ( SELECT 1 FROM PS_PYMT_TRMS_NET WHERE SETID = B.SETID AND PYMNT_TERMS_CD = B.PYMNT_TERMS_CD AND EFFDT = B.EFFDT AND DSC_TRMS_AVAIL_FLG = 'N' )

  • 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 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 PYMNT_TERMS_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Terms Type
    M=Multi-Payment Terms
    S=Single-Payment Terms
    8 PYMNT_TERMS_APPLIC Character(1) VARCHAR2(1) NOT NULL Terms Applicability
    A=All (Unrestricted)
    C=Customer-Only Terms
    V=Supplier-Only Terms
    9 NBR_OF_TERMS Number(2,0) SMALLINT NOT NULL Number of Terms