RO_BULK_CHARGES (SQL View)	Index Back
View to rollup charges View used to rollup charges whil in bulk order.

RO_BULK_CHARGES

(SQL View)

View to rollup charges

View used to rollup charges whil in bulk order.

SELECT A.CAPTURE_ID_REL , C.CHARGE_TYPE , SUM(C.CHARGE_AMT) FROM PS_RO_HEADER H , PS_RO_ASSOCIATION A , PS_RO_CHARGE C WHERE H.CAPTURE_ID = C.CAPTURE_ID AND H.CAPTURE_ID = A.CAPTURE_ID AND C.CHARGE_TYPE NOT IN ('DISC', 'SRCG') AND C.CHARGE_AMT <> 0 AND A.TYPE = 'BULK' GROUP BY A.CAPTURE_ID_REL, C.CHARGE_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CAPTURE_ID_REL Character(20) VARCHAR2(20) NOT NULL This field stores relative capture IDs.

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAPTURE_ID_REL	Character(20)	VARCHAR2(20) NOT NULL	This field stores relative capture IDs.
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.