CDR_DSCRP_CHKVW (SQL View)	Index Back
Used to obtain totals Used to obtain totals such as total payments, total paid out, non-cash/check payments, non-cash/check paid bout

CDR_DSCRP_CHKVW

(SQL View)

Used to obtain totals

Used to obtain totals such as total payments, total paid out, non-cash/check payments, non-cash/check paid bout

SELECT CHK.BUS_UNIT_TYPE , CHK.BUSINESS_UNIT , CHK.DRAWER_ID , CHK.RECON_ID , CHK.CURRENCY_CD , RECPT.ADD_DTTM , RECPT.DEPOSIT_BU , RECPT.RECEIPT_NBR , PMT.RECEIPT_NBR_SEQ , PMT.PAYMENT_AMT , PMT.CHECK_NBR , CHK.PAYMENT_AMT FROM PS_CDR_RECON_CHK CHK , PS_CDR_RECEIPT RECPT , PS_CDR_RECEIPT_PMT PMT WHERE CHK.BUS_UNIT_TYPE = RECPT.BUS_UNIT_TYPE AND CHK.BUSINESS_UNIT = RECPT.BUSINESS_UNIT AND CHK.DRAWER_ID = RECPT.DRAWER_ID AND RECPT.DEPOSIT_BU = PMT.DEPOSIT_BU AND RECPT.RECEIPT_NBR = PMT.RECEIPT_NBR AND PMT.PAYMENT_METHOD_CDR = 'CHK' AND PMT.CHECK_NBR = CHK.CHECK_NBR AND PMT.PAYMENT_AMT <> CHK.PAYMENT_AMT AND RECPT.RECEIPT_STATUS = 'PRT' AND CHK.CHECK_NBR <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 DRAWER_ID Character(5) VARCHAR2(5) NOT NULL Drawer Identificaion

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

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

6 ADD_DTTM DateTime(26) TIMESTAMP Date Time Added

7 DEPOSIT_BU Character(5) VARCHAR2(5) NOT NULL Identifies the business unit to which a deposit is posted.

8 RECEIPT_NBR Character(15) VARCHAR2(15) NOT NULL Receipt Number

9 RECEIPT_NBR_SEQ Number(3,0) SMALLINT NOT NULL Receipt Number Sequence

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

11 CHECK_NBR Character(30) VARCHAR2(30) NOT NULL Check Number

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUS_UNIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Business Unit Type AR=Accounts Receivable OM=Order Management
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	DRAWER_ID	Character(5)	VARCHAR2(5) NOT NULL	Drawer Identificaion
4	RECON_ID	Character(15)	VARCHAR2(15) NOT NULL	Reconciliation ID
5	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
6	ADD_DTTM	DateTime(26)	TIMESTAMP	Date Time Added
7	DEPOSIT_BU	Character(5)	VARCHAR2(5) NOT NULL	Identifies the business unit to which a deposit is posted.
8	RECEIPT_NBR	Character(15)	VARCHAR2(15) NOT NULL	Receipt Number
9	RECEIPT_NBR_SEQ	Number(3,0)	SMALLINT NOT NULL	Receipt Number Sequence
10	PAYMENT_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
11	CHECK_NBR	Character(30)	VARCHAR2(30) NOT NULL	Check Number
12	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount