SPCSHOFFCLSVWLN

(SQL View)
 Index Back

Reld Lng BU Cashier - Op Class

SPCSHOFFCLSVWLN is the language record related to SP_CSHOFF_CLSVW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT DISTINCT a.business_unit ,b.oprclass ,a.cashier_office ,c.LANGUAGE_CD ,c.descr FROM ps_sec_cshoff_cls a ,PSOPRDEFN b ,ps_CSH_OFF_LNG c WHERE a.access_cd = 'Y' AND a.business_unit = c.business_unit AND a.cashier_office = c.cashier_office AND a.oprclass = b.oprclass

  • Related Language Record for SP_CSHOFF_CLSVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: SP_BU_SF_NONVW

    2 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    3 CASHIER_OFFICE Character(8) VARCHAR2(8) NOT NULL Cashier's Office
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description