View: IGS_FI_UNPOSTED_TRANSACTIONS

View Text

SELECT GL_DATE
, REC_ACCOUNT_CD
, REC_GL_CCID
, AMOUNT
, 'DR'
FROM IGS_FI_INVLN_INT
WHERE ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL))
AND IGS_FI_GEN_005.FINP_GET_ACCT_METH = 'ACCRUAL'
AND GL_DATE IS NOT NULL
AND ERROR_ACCOUNT <> 'Y' UNION ALL SELECT GL_DATE
, REV_ACCOUNT_CD
, REV_GL_CCID
, AMOUNT
, 'CR'
FROM IGS_FI_INVLN_INT
WHERE ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL))
AND IGS_FI_GEN_005.FINP_GET_ACCT_METH = 'ACCRUAL'
AND GL_DATE IS NOT NULL
AND ERROR_ACCOUNT <> 'Y' UNION ALL SELECT GL_DATE
, DR_ACCOUNT_CD
, DR_GL_CCID
, AMOUNT
, 'DR'
FROM IGS_FI_CR_ACTIVITIES
WHERE GL_DATE IS NOT NULL
AND ((DR_GL_CCID IS NOT NULL) OR (DR_ACCOUNT_CD IS NOT NULL))
AND ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL)) UNION ALL SELECT GL_DATE
, CR_ACCOUNT_CD
, CR_GL_CCID
, AMOUNT
, 'CR'
FROM IGS_FI_CR_ACTIVITIES
WHERE GL_DATE IS NOT NULL
AND ((CR_GL_CCID IS NOT NULL) OR (CR_ACCOUNT_CD IS NOT NULL))
AND ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL)) UNION ALL SELECT GL_DATE
, DR_ACCOUNT_CD
, DR_GL_CODE_CCID
, AMOUNT_APPLIED
, 'DR'
FROM IGS_FI_APPLICATIONS
WHERE ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL))
AND GL_DATE IS NOT NULL UNION ALL SELECT GL_DATE
, CR_ACCOUNT_CD
, CR_GL_CODE_CCID
, AMOUNT_APPLIED
, 'CR'
FROM IGS_FI_APPLICATIONS
WHERE ((POSTING_ID IS NULL)
AND (POSTING_CONTROL_ID IS NULL))
AND GL_DATE IS NOT NULL UNION ALL SELECT GL_DATE
, CASH_ACCOUNT_CD
, CASH_GL_CCID
, FEE_AMOUNT
, 'DR'
FROM IGS_AD_APP_REQ
WHERE ((POSTING_CONTROL_ID IS NULL)
AND (GL_POSTED_DATE IS NULL))
AND GL_DATE IS NOT NULL UNION ALL SELECT GL_DATE
, REV_ACCOUNT_CD
, REV_GL_CCID
, FEE_AMOUNT
, 'CR'
FROM IGS_AD_APP_REQ
WHERE ((POSTING_CONTROL_ID IS NULL)
AND (GL_POSTED_DATE IS NULL))
AND GL_DATE IS NOT NULL

Columns