CDRW_PRN2_VW

(SQL View)
 Index Back

Cash Drawer Printer by User


SELECT DISTINCT B.OPRID , A.BUS_UNIT_TYPE , A.BUSINESS_UNIT , A.CURRENCY_CD , A.OM_PRINTER_PATH , A.DRAWER_ID , A.DESCR FROM PS_CASH_DRAWER_TBL A , PS_CDR_USER_DRAWER 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: CDRW_PRN2_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 BUS_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL Business Unit Type
    AR=Accounts Receivable
    OM=Order Management
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: AR_PAY_CUR_VW

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

    Prompt Table: %EDITTABLE3

    6 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion

    Prompt Table: %EDITTABLE2

    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description