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: PA.PA_PROJ_RETN_BILL_RULES#

Source

View Text - Preformatted


select RETN_BILLING_RULE_ID RETN_BILLING_RULE_ID, BILLING_METHOD_CODE BILLING_METHOD_CODE, PROJECT_ID PROJECT_ID, CUSTOMER_ID CUSTOMER_ID, TASK_ID TASK_ID, COMPLETED_PERCENTAGE COMPLETED_PERCENTAGE, TOTAL_RETENTION_AMOUNT TOTAL_RETENTION_AMOUNT, RETN_BILLING_CYCLE_ID RETN_BILLING_CYCLE_ID, CLIENT_EXTENSION_FLAG CLIENT_EXTENSION_FLAG, RETN_BILLING_PERCENTAGE RETN_BILLING_PERCENTAGE, RETN_BILLING_AMOUNT RETN_BILLING_AMOUNT, 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 from "PA"."PA_PROJ_RETN_BILL_RULES"

View Text - HTML Formatted

SELECT RETN_BILLING_RULE_ID RETN_BILLING_RULE_ID
, BILLING_METHOD_CODE BILLING_METHOD_CODE
, PROJECT_ID PROJECT_ID
, CUSTOMER_ID CUSTOMER_ID
, TASK_ID TASK_ID
, COMPLETED_PERCENTAGE COMPLETED_PERCENTAGE
, TOTAL_RETENTION_AMOUNT TOTAL_RETENTION_AMOUNT
, RETN_BILLING_CYCLE_ID RETN_BILLING_CYCLE_ID
, CLIENT_EXTENSION_FLAG CLIENT_EXTENSION_FLAG
, RETN_BILLING_PERCENTAGE RETN_BILLING_PERCENTAGE
, RETN_BILLING_AMOUNT RETN_BILLING_AMOUNT
, 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
FROM "PA"."PA_PROJ_RETN_BILL_RULES"