CS_PO_RATE_VW (SQL View)	Index Back
Rate Type Details - Header View used in Contracts Bind Mapping to get the rate type details FOR PURCHASE ORDERS

CS_PO_RATE_VW

(SQL View)

Rate Type Details - Header

View used in Contracts Bind Mapping to get the rate type details FOR PURCHASE ORDERS

SELECT A.BUSINESS_UNIT , A.PO_ID , A.rt_type , B.DESCR FROM PS_PO_HDR A , PS_RT_TYPE_TBL B WHERE A.RT_TYPE = B.RT_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

3 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order
3	RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description