RE_BILLING_CHG (SQL View)	Index Back
Billing Charge Prompt This view returns all the DISTINCT Charge IDs to be used as the Charge ID prompt for the Transaction Routing Code Setup.

RE_BILLING_CHG

(SQL View)

Billing Charge Prompt

This view returns all the DISTINCT Charge IDs to be used as the Charge ID prompt for the Transaction Routing Code Setup.

SELECT A.SETID , A.CHARGE_ID , MAX(DESCR ) FROM PS_BI_CHARGE A WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_BI_CHARGE A1 WHERE A1.SETID= A.SETID AND A1.CHARGE_ID = A.CHARGE_ID AND A1.EFFDT <= %CurrentDateIn AND A1.EFF_STATUS='A') GROUP BY A.SETID, A.CHARGE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

2 CHARGE_ID Character(18) VARCHAR2(18) NOT NULL Billing Charge ID

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CHARGE_ID	Character(18)	VARCHAR2(18) NOT NULL	Billing Charge ID
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description