SETIDCHARTFIELDCFS_DETAIL_VW(SQL View) |
Index Back |
|---|---|
Detail Ledg CFs w/ Bus Unit |
| SELECT DISTINCT B.SETID , B.CHARTFIELD , D.LONGNAME FROM PS_LED_DEFN_TBL A , PS_LED_GRP_FLD_VW2 B , PS_LED_GRP_LED_TBL C , PSDBFLDLABL_VW D WHERE A.SETID=C.SETID AND A.LEDGER=C.LEDGER AND A.LEDGER_TYPE='D' AND B.SETID=C.SETID AND B.LEDGER_GROUP=C.LEDGER_GROUP AND B.CHARTFIELD<>'BUSINESS_UNIT' AND B.CHARTFIELD<>'CURRENCY_CD' AND B.CHARTFIELD<>'STATISTICS_CODE' AND B.CHARTFIELD<>'BOOK_CODE' AND B.CHARTFIELD<>'GL_ADJUST_TYPE' AND B.CHARTFIELD=D.FIELDNAME |
| # | 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 |