CHARTFIELDCFS_CLOSING_VW(SQL View) |
Index Back |
|---|---|
Closing Rule Chartfields |
| SELECT DISTINCT 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' AND B.CHARTFIELD<>'BUSINESS_UNIT' AND NOT EXISTS ( SELECT 'X' FROM PS_FS_CF_TEMPLATE C WHERE B.CHARTFIELD = C.FIELDNAME AND C.CF_TYPE IN ('A', 'I', 'C', 'S')) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHARTFIELD |
Character(18) | VARCHAR2(18) NOT NULL | ChartField |