CDR_RECN_SRCHVW

(SQL View)
Index Back

Cash Drawer Search View

Cash Drawer Component Search View

SELECT BUS_UNIT_TYPE , BUSINESS_UNIT , DRAWER_ID , RECON_ID , RECON_DTTM , CURRENCY_CD , RECONCILE_STATUS FROM PS_CDR_RECON_HDR

# 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

Default Value: OM

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_CDR_NONVW

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

Prompt Table: CASH_DRAWER_TBL

4 RECON_ID Character(15) VARCHAR2(15) NOT NULL Reconciliation ID

Prompt Table: CDR_RECON_HDR

5 RECON_DTTM DateTime(26) TIMESTAMP Date Cash Drawer Reconciled Datetime
6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
7 RECONCILE_STATUS Character(3) VARCHAR2(3) NOT NULL Cash Drawer Reconciliation Status
CAN=Canceled
PND=Pending
REC=Reconciled