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: GMS.GMS_EVENT_ATTRIBUTE#

Source

View Text - Preformatted


select PROJECT_ID PROJECT_ID, EVENT_NUM EVENT_NUM, INSTALLMENT_ID INSTALLMENT_ID, ACTUAL_PROJECT_ID ACTUAL_PROJECT_ID, ACTUAL_TASK_ID ACTUAL_TASK_ID, BURDEN_COST_CODE BURDEN_COST_CODE, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, BILL_AMOUNT BILL_AMOUNT, REVENUE_AMOUNT REVENUE_AMOUNT, WRITE_OFF_AMOUNT WRITE_OFF_AMOUNT, CREATED_BY CREATED_BY, CREATED_DATE CREATED_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REVENUE_ACCUMULATED REVENUE_ACCUMULATED, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, REQUEST_ID REQUEST_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EVENT_CALLING_PROCESS EVENT_CALLING_PROCESS from "GMS"."GMS_EVENT_ATTRIBUTE"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, EVENT_NUM EVENT_NUM
, INSTALLMENT_ID INSTALLMENT_ID
, ACTUAL_PROJECT_ID ACTUAL_PROJECT_ID
, ACTUAL_TASK_ID ACTUAL_TASK_ID
, BURDEN_COST_CODE BURDEN_COST_CODE
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, BILL_AMOUNT BILL_AMOUNT
, REVENUE_AMOUNT REVENUE_AMOUNT
, WRITE_OFF_AMOUNT WRITE_OFF_AMOUNT
, CREATED_BY CREATED_BY
, CREATED_DATE CREATED_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REVENUE_ACCUMULATED REVENUE_ACCUMULATED
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, REQUEST_ID REQUEST_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EVENT_CALLING_PROCESS EVENT_CALLING_PROCESS
FROM "GMS"."GMS_EVENT_ATTRIBUTE"