ACCT_TOMAP_S_VW(SQL View) |
Index Back |
---|
SELECT DISTINCT M.SETID_TO ,M.SETID_FROM ,A.ACCOUNT FROM PS_CF_VAL_MAPPING M , PS_GL_ACCOUNT_TBL A WHERE A.SETID = M.SETID_FROM AND M.CHARTFIELD = 'ACCOUNT' AND NOT EXISTS ( SELECT 'X' FROM PS_GL_ACCOUNT_TBL B , PS_CF_VAL_MAPPING N WHERE N.CHARTFIELD = M.CHARTFIELD AND N.SETID_TO = M.SETID_TO AND B.SETID = N.SETID_FROM AND B.SETID = A.SETID AND B.ACCOUNT = A.ACCOUNT AND B.ACCOUNT >= N.RANGE_FROM AND B.ACCOUNT <= N.RANGE_TO) |
# | 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 |