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_MC_DRAFT_INV_ITEMS#

Source

View Text - Preformatted


select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, PROJECT_ID PROJECT_ID, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM, LINE_NUM LINE_NUM, AMOUNT AMOUNT, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID, CURRENCY_CODE CURRENCY_CODE, EXCHANGE_RATE EXCHANGE_RATE, CONVERSION_DATE CONVERSION_DATE, RATE_TYPE RATE_TYPE from "PA"."PA_MC_DRAFT_INV_ITEMS"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PROJECT_ID PROJECT_ID
, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
, LINE_NUM LINE_NUM
, AMOUNT AMOUNT
, UNBILLED_RECEIVABLE_DR UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR UNEARNED_REVENUE_CR
, PRC_ASSIGNMENT_ID PRC_ASSIGNMENT_ID
, CURRENCY_CODE CURRENCY_CODE
, EXCHANGE_RATE EXCHANGE_RATE
, CONVERSION_DATE CONVERSION_DATE
, RATE_TYPE RATE_TYPE
FROM "PA"."PA_MC_DRAFT_INV_ITEMS"