CASH_DR_USR_VW

(SQL View)
 Index Back

Cash Drawer User View

Cash drawer user view.

SELECT B.OPRID , A.BUSINESS_UNIT ,A.DRAWER_ID ,A.LOCATION ,A.DESCR ,A.CURRENCY_CD 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

# 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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: %EDITTABLE

3 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion
4 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: AR_PAY_CUR_VW