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

CDR_RCPT_SRCHVW

(SQL View)

Cash Drawer Receipts

SELECT DEPOSIT_BU , RECEIPT_NBR , BILL_TO_CUST_ID , BUS_UNIT_TYPE , BUSINESS_UNIT , DRAWER_ID , RECEIPT_STATUS , PAYMENT_AMT , CURRENCY_CD , 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
Prompt Table: CDR_RCPT_SRCHVW

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

4 BUS_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL Business Unit Type
AR=Accounts Receivable
OM=Order Management
Default Value: OM

5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BUARDE_NONVW

6 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion
Prompt Table: %EDITTABLE2

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

8 PAYMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Specifies the amount of a customer payment.

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

10 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_RCPT_SRCHVW
3	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CDR_BILLTO_VW
4	BUS_UNIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Business Unit Type AR=Accounts Receivable OM=Order Management Default Value: OM
5	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BUARDE_NONVW
6	DRAWER_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawer Identificaion Prompt Table: %EDITTABLE2
7	RECEIPT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Receipt Status CAN=Canceled HLD=Hold NEW=New PRT=Printed REC=Reconciled
8	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
9	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
10	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.