RO_BAM_CHARGE (SQL View)	Index Back
Related Charges Charges that are related to quotes & orders such as Freight, Taxes, etc.

RO_BAM_CHARGE

(SQL View)

Related Charges

Charges that are related to quotes & orders such as Freight, Taxes, etc.

SELECT CAPTURE_ID ,UID20 ,CHARGE_AMT ,CHARGE_PERCENT ,CHARGE_TYPE FROM PS_RO_CHARGE WHERE CHARGE_TYPE IN ('DISC','SHIP','SRCG') AND (CHARGE_AMT <> 0 OR CHARGE_PERCENT <> 0)

# 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 UID20 Character(20) VARCHAR2(20) NOT NULL This field is for UID of 20 characters long.

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	CAPTURE_ID	Character(20)	VARCHAR2(20) NOT NULL	Field use to store the capture ID in order capture.
2	UID20	Character(20)	VARCHAR2(20) NOT NULL	This field is for UID of 20 characters long.
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