PO_BU_GL_RT_VW (SQL View)	Index Back
BU GL Ledger Group View FOR PO BU GL LEDGER VIEW FOR PURCHASING.

PO_BU_GL_RT_VW

(SQL View)

BU GL Ledger Group View FOR PO

BU GL LEDGER VIEW FOR PURCHASING.

select a.business_unit, a.ledger_group, b.cur_rt_type_dflt from PS_BU_LED_GRP_TBL a, ps_led_grp_led_tbl b where a.ledger_group = b.ledger_group and b.primary_ledger = 'Y' and b.setid = (select setid from ps_set_cntrl_rec c where c.setcntrlvalue = a.business_unit and c.recname = 'LED_GRP_TBL')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit

2 LEDGER_GROUP Character(10) VARCHAR2(10) NOT NULL Ledger Group

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.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT_GL	Character(5)	VARCHAR2(5) NOT NULL	GL Business Unit
2	LEDGER_GROUP	Character(10)	VARCHAR2(10) NOT NULL	Ledger Group
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.