CFS_TARGETBU_VW

(SQL View)
Index Back

Alloc Target Ledg w/BU CF View


select distinct b.setid, b.ledger, b.chartfield from ps_led_defn_tbl a, PS_LED_FLDS_TBL b where a.setid=b.setid and a.ledger=b.ledger and a.ledger_type = 'D'

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