SETID_TOSETID_FROMCHARTFIELD_VALUEACCT_TOMAP_T_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT M.SETID_TO , M.SETID_FROM ,A.ACCOUNT FROM PS_GL_ACCOUNT_TBL A , PS_CF_VAL_MAPPING M WHERE M.SETID_TO = A.SETID AND NOT EXISTS ( SELECT 'X' FROM PS_CF_VAL_MAPPING WHERE CHARTFIELD = 'ACCOUNT' AND SETID_TO = M.SETID_TO AND SETID_FROM = M.SETID_FROM AND CHARTFIELD_VALUE = A.ACCOUNT ) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID_TO |
Character(5) | VARCHAR2(5) NOT NULL | Target SetID |
| 2 | SETID_FROM |
Character(5) | VARCHAR2(5) NOT NULL | SetID From |
| 3 | CHARTFIELD_VALUE |
Character(30) | VARCHAR2(30) NOT NULL | ChartField Value |