CFS_LED_VW2

(SQL View)
Index Back

Detail Ledger CF View


SELECT DISTINCT b.setid , a.ledger , b.chartfield FROM ps_led_grp_led_tbl a , PS_LED_GRP_FLD_TBL b WHERE a.setid=b.setid AND a.ledger_group=b.ledger_group AND b.chartfield <> 'BUSINESS_UNIT' AND b.chartfield <> 'CURRENCY_CD'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 LEDGER Character(10) VARCHAR2(10) NOT NULL Ledger
3 CHARTFIELD Character(18) VARCHAR2(18) NOT NULL ChartField