CDR_RECON_DS_VW

(SQL View)
Index Back

Drawer Reconciliation View

Drawer Reconciliation prompt view for a list of valid Batch Deposit ID used for Print Deposit Slip run control page.

SELECT DEPOSIT_BATCH_ID , BUS_UNIT_TYPE , BUSINESS_UNIT , DRAWER_ID , RECON_ID , RECON_DTTM FROM PS_CDR_RECON_HDR WHERE DEPOSIT_BATCH_ID <> 0 AND RECONCILE_STATUS = 'REC'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DEPOSIT_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Deposit Batch ID
2 BUS_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL Business Unit Type
AR=Accounts Receivable
OM=Order Management
3 BUSINESS_UNIT_CDR Character(5) VARCHAR2(5) NOT NULL Cash Drawer Receipt Business Unit
4 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion
5 RECON_ID Character(15) VARCHAR2(15) NOT NULL Reconciliation ID
6 RECON_DTTM DateTime(26) TIMESTAMP Date Cash Drawer Reconciled Datetime