CSHRCPTVWLNG

(SQL View)
 Index Back

Cashier Receipt View

SF Cashiering Receipt view.

SELECT A.BUSINESS_UNIT , A.CASHIER_OFFICE , A.RECEIPT_NBR ,C.LANGUAGE_CD , B.DESCR , C.DESCR , D.DESCRFORMAL ,E.XLATLONGNAME FROM PS_CSH_OFF_RECEIPT A , PS_BUS_UNIT_LNG B ,PS_BUS_UNIT_TBL_SF Y , PS_CSH_OFF_LNG C , PS_INSTITUTION_LNG D , PSXLATITEM E , PSOPTIONS F WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.CASHIER_OFFICE = A.CASHIER_OFFICE AND D.INSTITUTION = Y.INSTITUTION AND B.BUSINESS_UNIT=Y.BUSINESS_UNIT AND D.EFFDT = ( SELECT MAX(D2.EFFDT) FROM PS_INSTITUTION_LNG D2 WHERE D2.INSTITUTION = D.INSTITUTION AND D2.EFFDT <= %CurrentDateIn ) AND E.FIELDNAME = 'SSF_APPR_STATUS' AND E.FIELDVALUE = A.SSF_APPR_STATUS AND E.EFFDT = ( SELECT MAX(E2.EFFDT) FROM PSXLATITEM E2 WHERE E2.FIELDNAME = E.FIELDNAME AND E2.FIELDVALUE = E.FIELDVALUE AND E2.EFFDT <= %CurrentDateIn )

  • Related Language Record for CSH_RCPT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
    3 RECEIPT_NBR Number(12,0) DECIMAL(12) NOT NULL Receipt Number
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    6 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    7 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field
    8 DESCR3 Character(30) VARCHAR2(30) NOT NULL Descr 3