FUS_CFATRIB1_VW(SQL View) |
Index Back |
|---|
| SELECT A.CHARTFIELD , A.BALANCE_FLAG ,C.CF_ORDER ,B.SETID ,B.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 | CHARTFIELD | Character(18) | VARCHAR2(18) NOT NULL | ChartField |
| 2 | BALANCE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Balance by ChartField |
| 3 | CF_ORDER | Number(2,0) | SMALLINT NOT NULL | ChartField Sequence Order |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | LEDGER_GROUP | Character(10) | VARCHAR2(10) NOT NULL | Ledger Group |