CDRW_PRN1_LVW

(SQL View)
 Index Back

Cash Drawer Printer Lang View

Cash Drawer Printer Lang View for CDRW_PRNT1_VW

SELECT DISTINCT A.BUS_UNIT_TYPE , A.BUSINESS_UNIT , A.CURRENCY_CD , A.OM_PRINTER_PATH , B.LANGUAGE_CD , B.DESCR FROM PS_CASH_DRAWER_TBL A , PS_CASH_DRAWER_LNG B WHERE A.BUS_UNIT_TYPE = B.BUS_UNIT_TYPE AND A.BUSINESS_UNIT= B.BUSINESS_UNIT AND A.DRAWER_ID = B.DRAWER_ID AND A.OM_PRINTER_PATH <> ' '

  • Related Language Record for CDRW_PRN1_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUS_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL Business Unit Type
    AR=Accounts Receivable
    OM=Order Management
    2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: AR_PAY_CUR_VW

    4 OM_PRINTER_PATH Character(80) VARCHAR2(80) NOT NULL Printer Path

    Prompt Table: %EDITTABLE3

    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description