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

CDR_RFND_SRCHVW

(SQL View)

Cash Drawer Receipts

SELECT DEPOSIT_BU , RECEIPT_NBR , BILL_TO_CUST_ID , DRAWER_ID , RECEIPT_STATUS , PAYMENT_AMT , CURRENCY_CD , LASTUPDDTTM FROM PS_CDR_RECEIPT

# 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
Prompt Table: CDR_RECEIPT

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 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.

7 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

8 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 Prompt Table: CDR_RECEIPT
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	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
7	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
8	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.