SETIDCHARTFIELDCFS_POS_ACT_VW(SQL View) |
Index Back |
|---|---|
Detail Ledg CFs w/ Bus Unit |
| SELECT DISTINCT b.setid , b.chartfield ,C.LONGNAME FROM ps_led_grp_tbl a , ps_led_grp_fld_tbl b , PSDBFLDLABL_VW C , PSDBFIELD D WHERE a.setid=b.setid AND a.ledger_group=b.ledger_group AND b.chartfield <> 'BUSINESS_UNIT' AND b.chartfield <> 'CURRENCY_CD' AND b.chartfield <> 'STATISTICS_CODE' AND b.chartfield <> 'ACCOUNT' AND b.chartfield <> 'ALTACCT' AND B.CHARTFIELD=C.FIELDNAME AND C.FIELDNAME=D.FIELDNAME AND D.FLDNOTUSED=0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CHARTFIELD |
Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 3 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |