CDR_RCPT_AD2_VW (SQL View)	Index Back
Cash Drawer Receipts Cash Drawer Receipts

CDR_RCPT_AD2_VW

(SQL View)

Cash Drawer Receipts

SELECT DEPOSIT_BU , RECEIPT_NBR , BILL_TO_CUST_ID , DRAWER_ID , RECEIPT_STATUS , LASTUPDDTTM FROM PS_CDR_RECEIPT WHERE RECEIPT_STATUS IN ('NEW','HLD','CAN')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.
Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU
Prompt Table: SP_BUARDE_NONVW

2 RECEIPT_NBR Character(15) VARCHAR2(15) NOT NULL Receipt Number
Default Value: NEXT

3 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
Prompt Table: CDR_BILLTO_VW

4 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion
Prompt Table: CDR_CSH_DRWR_VW

5 RECEIPT_STATUS Character(3) VARCHAR2(3) NOT NULL Receipt Status
CAN=Canceled
HLD=Hold
NEW=New
PRT=Printed
REC=Reconciled

6 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted. Default Value: OPR_DEF_TBL_AR.DEPOSIT_BU Prompt Table: SP_BUARDE_NONVW
2	RECEIPT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Receipt Number Default Value: NEXT
3	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CDR_BILLTO_VW
4	DRAWER_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawer Identificaion Prompt Table: CDR_CSH_DRWR_VW
5	RECEIPT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Receipt Status CAN=Canceled HLD=Hold NEW=New PRT=Printed REC=Reconciled
6	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.