eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BIM.BIM_R_FDSP_DAILY_FACTS#

Source

View Text - Preformatted


select SPEND_TRANSACTION_ID SPEND_TRANSACTION_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, FUND_ID FUND_ID, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, STANDARD_DISCOUNT STANDARD_DISCOUNT, ACCRUAL ACCRUAL, MARKET_EXPENSE MARKET_EXPENSE, COMMITED_AMT COMMITED_AMT, PLANNED_AMT PLANNED_AMT, PAID_AMT PAID_AMT, DELETE_FLAG DELETE_FLAG, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, LOAD_DATE LOAD_DATE, UTIL_ORG_ID UTIL_ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, METRIC1 METRIC1, METRIC2 METRIC2, METRIC3 METRIC3, METRIC4 METRIC4, METRIC5 METRIC5, METRIC6 METRIC6, METRIC7 METRIC7, METRIC8 METRIC8, METRIC9 METRIC9, METRIC10 METRIC10, METRIC11 METRIC11, METRIC12 METRIC12, METRIC13 METRIC13, METRIC14 METRIC14, METRIC15 METRIC15, FIS_MONTH FIS_MONTH, FIS_QTR FIS_QTR, FIS_YEAR FIS_YEAR from "BIM"."BIM_R_FDSP_DAILY_FACTS"

View Text - HTML Formatted

SELECT SPEND_TRANSACTION_ID SPEND_TRANSACTION_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
, FUND_ID FUND_ID
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, STANDARD_DISCOUNT STANDARD_DISCOUNT
, ACCRUAL ACCRUAL
, MARKET_EXPENSE MARKET_EXPENSE
, COMMITED_AMT COMMITED_AMT
, PLANNED_AMT PLANNED_AMT
, PAID_AMT PAID_AMT
, DELETE_FLAG DELETE_FLAG
, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, LOAD_DATE LOAD_DATE
, UTIL_ORG_ID UTIL_ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, METRIC1 METRIC1
, METRIC2 METRIC2
, METRIC3 METRIC3
, METRIC4 METRIC4
, METRIC5 METRIC5
, METRIC6 METRIC6
, METRIC7 METRIC7
, METRIC8 METRIC8
, METRIC9 METRIC9
, METRIC10 METRIC10
, METRIC11 METRIC11
, METRIC12 METRIC12
, METRIC13 METRIC13
, METRIC14 METRIC14
, METRIC15 METRIC15
, FIS_MONTH FIS_MONTH
, FIS_QTR FIS_QTR
, FIS_YEAR FIS_YEAR
FROM "BIM"."BIM_R_FDSP_DAILY_FACTS"