RO_EMAIL_CHG_VW (SQL View)	Index Back
Order Capture Search VW Used to search for Capture Records

RO_EMAIL_CHG_VW

(SQL View)

Order Capture Search VW

Used to search for Capture Records

SELECT CAPTURE_ID , CHARGE_TYPE , SUM(CHARGE_AMT) , SUM(CHARGE_PERCENT) FROM PS_RO_CHARGE GROUP BY CAPTURE_ID , CHARGE_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_ID Character(20) VARCHAR2(20) NOT NULL Field use to store the capture ID in order capture.

2 CHARGE_TYPE Character(4) VARCHAR2(4) NOT NULL This field is used as edit box to show the charge type used in Total subpage and other places

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

4 CHARGE_PERCENT Signed Number(7,2) DECIMAL(5,2) NOT NULL Charge Percent

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	CHARGE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is used as edit box to show the charge type used in Total subpage and other places
3	CHARGE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Specifies the amount of a customer payment.
4	CHARGE_PERCENT	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Charge Percent