VIEW: FV.FV_PYA_TRANSACTIONS#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, AMOUNT AMOUNT, FUND_VALUE FUND_VALUE, ACCOUNT_VALUE ACCOUNT_VALUE, TRANSACTION_DATE TRANSACTION_DATE, FUND_STATUS FUND_STATUS, FUND_CLASS FUND_CLASS, EXPENDED_UNEXPENDED EXPENDED_UNEXPENDED, PAID_UNPAID PAID_UNPAID, UPWARD_DOWNWARD UPWARD_DOWNWARD, OFFSET_ACCT_NUMBER OFFSET_ACCT_NUMBER, TRANSACTION_CODE TRANSACTION_CODE, PERIOD PERIOD, SOURCE_MODULE SOURCE_MODULE, SOURCE_DOCUMENT_NUMBER SOURCE_DOCUMENT_NUMBER, REFERENCE_2 REFERENCE_2, REFERENCE_3 REFERENCE_3, REFERENCE_5 REFERENCE_5, INCLUDE_FLAG INCLUDE_FLAG, NEVER_PROCESS_FLAG NEVER_PROCESS_FLAG, JE_BATCH_ID JE_BATCH_ID, JE_HEADER_ID JE_HEADER_ID, JE_LINE_NUM JE_LINE_NUM, RECORD_TYPE RECORD_TYPE, RECORD_CATEGORY RECORD_CATEGORY, ORG_ID ORG_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, REVERSAL_FLAG REVERSAL_FLAG, PARENT_REVERSAL_ID PARENT_REVERSAL_ID, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID, APPORTIONED_FLAG APPORTIONED_FLAG from "FV"."FV_PYA_TRANSACTIONS"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, AMOUNT AMOUNT
, FUND_VALUE FUND_VALUE
, ACCOUNT_VALUE ACCOUNT_VALUE
, TRANSACTION_DATE TRANSACTION_DATE
, FUND_STATUS FUND_STATUS
, FUND_CLASS FUND_CLASS
, EXPENDED_UNEXPENDED EXPENDED_UNEXPENDED
, PAID_UNPAID PAID_UNPAID
, UPWARD_DOWNWARD UPWARD_DOWNWARD
, OFFSET_ACCT_NUMBER OFFSET_ACCT_NUMBER
, TRANSACTION_CODE TRANSACTION_CODE
, PERIOD PERIOD
, SOURCE_MODULE SOURCE_MODULE
, SOURCE_DOCUMENT_NUMBER SOURCE_DOCUMENT_NUMBER
, REFERENCE_2 REFERENCE_2
, REFERENCE_3 REFERENCE_3
, REFERENCE_5 REFERENCE_5
, INCLUDE_FLAG INCLUDE_FLAG
, NEVER_PROCESS_FLAG NEVER_PROCESS_FLAG
, JE_BATCH_ID JE_BATCH_ID
, JE_HEADER_ID JE_HEADER_ID
, JE_LINE_NUM JE_LINE_NUM
, RECORD_TYPE RECORD_TYPE
, RECORD_CATEGORY RECORD_CATEGORY
, ORG_ID ORG_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, REVERSAL_FLAG REVERSAL_FLAG
, PARENT_REVERSAL_ID PARENT_REVERSAL_ID
, INVOICE_DISTRIBUTION_ID INVOICE_DISTRIBUTION_ID
, APPORTIONED_FLAG APPORTIONED_FLAG
FROM "FV"."FV_PYA_TRANSACTIONS"