FUS_SETIDLED_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.SETID , A.LEDGER_GROUP FROM PS_LED_GRP_FLD_TBL A , PS_LED_GRP_TBL B ,PS_FUS_CF_SEGMAP C WHERE A.SETID=B.SETID AND A.LEDGER_GROUP=B.LEDGER_GROUP AND B.LEDGER_TEMPLATE IN ( SELECT LEDGER_TEMPLATE FROM PS_LED_TMPLT_TBL WHERE LEDGER_TYPE='D' AND DEFAULT_LEDGER='G') AND A.CHARTFIELD=C.CHARTFIELD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |