RO_ORD_MBUCG_VW (SQL View)	Index Back
Order Capture Metric Charge Input view for Order Capture Metric Charge ACE report for single BU

RO_ORD_MBUCG_VW

(SQL View)

Order Capture Metric Charge

Input view for Order Capture Metric Charge ACE report for single BU

SELECT K.PROBINST , A.CAPTURE_ID , A.CHARGE_AMT , A.CHARGE_PERCENT , A.CHARGE_TYPE FROM PS_RO_HEADER B , PS_RO_BAM_CHARGE A , PS_RO_BAM_RUN_CTL D , PS_RO_BAM_OM_INST K WHERE D.OPRID=K.OPRID AND D.RUN_CNTL_ID=K.RUN_CNTL_ID AND %DateOut(B.CAPTURE_DATE) >= %DateOut(D.START_DATE) AND %DateOut(B.CAPTURE_DATE) <= %DateOut(D.END_DATE) AND B.CAPTURE_TYPE_CD IN ('SO','QUO') AND B.CAPTURE_ID = A.CAPTURE_ID AND B.BULK_ORDER_FLAG <> 'Y' AND B.BUSINESS_UNIT = D.BUSINESS_UNIT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance

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

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

5 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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROBINST	Character(20)	VARCHAR2(20) NOT NULL	Optimization Problem Instance
2	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
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
5	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