FV_BE_TRANSACTION_LINES_V

Details

• Schema: FUSION

• Object owner: FV

• Object type: VIEW

Columns

Name

EVENT_ID LINE_NUMBER DATA_SET_ID DOCUMENT_ID TRANSACTION_LINE_ID LINE_REVISION_NUMBER TRANSACTION_TYPE_ID LINE_ACCOUNT LINE_DESCRIPTION LINE_AMOUNT FUND_VALUE GL_DATE DEBIT_ACCOUNT CREDIT_ACCOUNT BE_LINES_ATTRIBUTE1 BE_LINES_ATTRIBUTE2 BE_LINES_ATTRIBUTE3 BE_LINES_ATTRIBUTE4 BE_LINES_ATTRIBUTE5 BE_LINES_ATTRIBUTE6 BE_LINES_ATTRIBUTE7 BE_LINES_ATTRIBUTE8 BE_LINES_ATTRIBUTE9 BE_LINES_ATTRIBUTE10 BE_LINES_ATTRIBUTE11 BE_LINES_ATTRIBUTE12 BE_LINES_ATTRIBUTE13 BE_LINES_ATTRIBUTE14 BE_LINES_ATTRIBUTE15 BE_LINES_ATTRIBUTE_NUMBER1 BE_LINES_ATTRIBUTE_NUMBER2 BE_LINES_ATTRIBUTE_NUMBER3 BE_LINES_ATTRIBUTE_NUMBER4 BE_LINES_ATTRIBUTE_NUMBER5 BE_LINES_ATTRIBUTE_DATE1 BE_LINES_ATTRIBUTE_DATE2 BE_LINES_ATTRIBUTE_DATE3 BE_LINES_ATTRIBUTE_DATE4 BE_LINES_ATTRIBUTE_DATE5 BE_LINES_ATTRIBUTE_CATEGORY BE_TRANSACTION_TYPE

Query

SQL_Statement

SELECT L.ACCOUNTING_EVENT_ID EVENT_ID, L.TRANSACTION_LINE_NUM LINE_NUMBER, L.DATA_SET_ID DATA_SET_ID, L.DOCUMENT_ID DOCUMENT_ID, L.TRANSACTION_LINE_ID, L.REVISION_NUMBER LINE_REVISION_NUMBER, L.TRANSACTION_TYPE_ID, L.GL_CODE_COMBINATION_ID LINE_ACCOUNT, L.LINE_DESCRIPTION, L.AMOUNT LINE_AMOUNT, L.FUND_VALUE, L.ACCOUNTING_DATE GL_DATE, A.DEBIT_ACCOUNT, A.CREDIT_ACCOUNT, L.ATTRIBUTE1 BE_LINES_ATTRIBUTE1, L.ATTRIBUTE2 BE_LINES_ATTRIBUTE2, L.ATTRIBUTE3 BE_LINES_ATTRIBUTE3, L.ATTRIBUTE4 BE_LINES_ATTRIBUTE4, L.ATTRIBUTE5 BE_LINES_ATTRIBUTE5, L.ATTRIBUTE6 BE_LINES_ATTRIBUTE6, L.ATTRIBUTE7 BE_LINES_ATTRIBUTE7, L.ATTRIBUTE8 BE_LINES_ATTRIBUTE8, L.ATTRIBUTE9 BE_LINES_ATTRIBUTE9, L.ATTRIBUTE10 BE_LINES_ATTRIBUTE10, L.ATTRIBUTE11 BE_LINES_ATTRIBUTE11, L.ATTRIBUTE12 BE_LINES_ATTRIBUTE12, L.ATTRIBUTE13 BE_LINES_ATTRIBUTE13, L.ATTRIBUTE14 BE_LINES_ATTRIBUTE14, L.ATTRIBUTE15 BE_LINES_ATTRIBUTE15, L.ATTRIBUTE_NUMBER1 BE_LINES_ATTRIBUTE_NUMBER1, L.ATTRIBUTE_NUMBER2 BE_LINES_ATTRIBUTE_NUMBER2, L.ATTRIBUTE_NUMBER3 BE_LINES_ATTRIBUTE_NUMBER3, L.ATTRIBUTE_NUMBER4 BE_LINES_ATTRIBUTE_NUMBER4, L.ATTRIBUTE_NUMBER5 BE_LINES_ATTRIBUTE_NUMBER5, L.ATTRIBUTE_DATE1 BE_LINES_ATTRIBUTE_DATE1, L.ATTRIBUTE_DATE2 BE_LINES_ATTRIBUTE_DATE2, L.ATTRIBUTE_DATE3 BE_LINES_ATTRIBUTE_DATE3, L.ATTRIBUTE_DATE4 BE_LINES_ATTRIBUTE_DATE4, L.ATTRIBUTE_DATE5 BE_LINES_ATTRIBUTE_DATE5, L.ATTRIBUTE_CATEGORY BE_LINES_ATTRIBUTE_CATEGORY, T.NAME BE_TRANSACTION_TYPE FROM FV_BE_TRANSACTION_LINES L, FV_BE_TRANSACTION_ACCOUNTS A, FV_BE_TRANSACTION_TYPES T WHERE A.TRANSACTION_TYPE_ID = L.TRANSACTION_TYPE_ID AND L.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID