CSH_TND_DESC_VW

(SQL View)
 Index Back

Payment Tender View


SELECT A.BUSINESS_UNIT ,A.TENDER_KEY ,A.DESCR FROM PS_TENDER_KEY_TBL A WHERE A.EFFDT = (SELECT MAX (B.EFFDT) FROM PS_TENDER_KEY_TBL B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.TENDER_KEY = A.TENDER_KEY AND B.EFFDT <= %CURRENTDATEIN)

  • Related Language Record: CSHTNDDESCVWLNG

  • Parent record: CSH_BD_CSH_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 TENDER_KEY Character(10) VARCHAR2(10) NOT NULL Tender Key
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description