CSHTNDDESCVWLNG

(SQL View)
 Index Back

Payment Tender View


SELECT A.BUSINESS_UNIT ,A.TENDER_KEY ,A.LANGUAGE_CD ,A.DESCR FROM PS_TENDER_KEY_LNG A WHERE A.EFFDT = ( SELECT MAX (B.EFFDT) FROM PS_TENDER_KEY_LNG B WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.TENDER_KEY = A.TENDER_KEY AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record for CSH_TND_DESC_VW

  • 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description