CDR_RECEIPT (SQL Table)	Index Back
Cash Drawer Receipts Cash Drawer Receipts

CDR_RECEIPT

(SQL Table)

Cash Drawer Receipts

# 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 RECEIPT_STATUS Character(3) VARCHAR2(3) NOT NULL Receipt Status
CAN=Canceled
HLD=Hold
NEW=New
PRT=Printed
REC=Reconciled
Default Value: NEW

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_BU_CDR_NONVW

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

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

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

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

10 NON_CASH_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Non-Cash Received

11 CASH_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cash Received

12 TOTAL_TEND_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Amount

13 CHANGE_AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Change in Resource Amount

14 COMMENTS Long Character CLOB Comment

15 PAYMENT_PURPOSE Character(50) VARCHAR2(50) NOT NULL Payment Purpose

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

17 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

18 ORIG_OPRID Character(30) VARCHAR2(30) NOT NULL User ID

19 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

20 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added

21 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	RECEIPT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Receipt Status CAN=Canceled HLD=Hold NEW=New PRT=Printed REC=Reconciled Default Value: NEW
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_BU_CDR_NONVW
6	DRAWER_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawer Identificaion Prompt Table: %EDITTABLE2
7	BILL_TO_CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer Prompt Table: CDR_BILLTO_VW
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
9	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
10	NON_CASH_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Non-Cash Received
11	CASH_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Cash Received
12	TOTAL_TEND_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Total Amount
13	CHANGE_AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Change in Resource Amount
14	COMMENTS	Long Character	CLOB	Comment
15	PAYMENT_PURPOSE	Character(50)	VARCHAR2(50) NOT NULL	Payment Purpose
16	RECON_ID	Character(15)	VARCHAR2(15) NOT NULL	Reconciliation ID
17	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
18	ORIG_OPRID	Character(30)	VARCHAR2(30) NOT NULL	User ID
19	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
21	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.