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