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

Source

View Text - Preformatted


select PA_PWP_AP_HDR_ID PA_PWP_AP_HDR_ID, INVOICE_ID INVOICE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, PO_HEADER_ID PO_HEADER_ID, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJFUNC_INVOICE_AMOUNT PROJFUNC_INVOICE_AMOUNT, PROJFUNC_INV_PAID_AMOUNT PROJFUNC_INV_PAID_AMOUNT, PROJFUNC_INV_UNPAID_AMOUNT PROJFUNC_INV_UNPAID_AMOUNT, PROJFUNC_RETAINED_AMOUNT PROJFUNC_RETAINED_AMOUNT, PROJFUNC_DISCOUNT_AMOUNT PROJFUNC_DISCOUNT_AMOUNT, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE, PROJ_INVOICE_AMOUNT PROJ_INVOICE_AMOUNT, PROJ_INV_PAID_AMOUNT PROJ_INV_PAID_AMOUNT, PROJ_INV_UNPAID_AMOUNT PROJ_INV_UNPAID_AMOUNT, PROJ_RETAINED_AMOUNT PROJ_RETAINED_AMOUNT, PROJ_DISCOUNT_AMOUNT PROJ_DISCOUNT_AMOUNT, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE, ACCT_INVOICE_AMOUNT ACCT_INVOICE_AMOUNT, ACCT_INV_PAID_AMOUNT ACCT_INV_PAID_AMOUNT, ACCT_INV_UNPAID_AMOUNT ACCT_INV_UNPAID_AMOUNT, ACCT_RETAINED_AMOUNT ACCT_RETAINED_AMOUNT, ACCT_DISCOUNT_AMOUNT ACCT_DISCOUNT_AMOUNT, INVOICE_CURRENCY INVOICE_CURRENCY, PROJINV_TOT_AMOUNT PROJINV_TOT_AMOUNT, AMOUNT_PAID AMOUNT_PAID, AMOUNT_UNPAID AMOUNT_UNPAID, RETAINED_AMOUNT RETAINED_AMOUNT, DISCOUNT_AMOUNT DISCOUNT_AMOUNT, PROJFUNC_CUR_PER_INV_PAID PROJFUNC_CUR_PER_INV_PAID, PROJ_CUR_PER_INV_PAID PROJ_CUR_PER_INV_PAID, PROJFUNC_RTAX_AMOUNT PROJFUNC_RTAX_AMOUNT, PROJ_RTAX_AMOUNT PROJ_RTAX_AMOUNT, ACCT_RTAX_AMOUNT ACCT_RTAX_AMOUNT, RTAX_AMOUNT RTAX_AMOUNT from "PA"."PA_PWP_AP_INV_DTL"

View Text - HTML Formatted

SELECT PA_PWP_AP_HDR_ID PA_PWP_AP_HDR_ID
, INVOICE_ID INVOICE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PO_HEADER_ID PO_HEADER_ID
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJFUNC_INVOICE_AMOUNT PROJFUNC_INVOICE_AMOUNT
, PROJFUNC_INV_PAID_AMOUNT PROJFUNC_INV_PAID_AMOUNT
, PROJFUNC_INV_UNPAID_AMOUNT PROJFUNC_INV_UNPAID_AMOUNT
, PROJFUNC_RETAINED_AMOUNT PROJFUNC_RETAINED_AMOUNT
, PROJFUNC_DISCOUNT_AMOUNT PROJFUNC_DISCOUNT_AMOUNT
, PROJ_CURRENCY_CODE PROJ_CURRENCY_CODE
, PROJ_INVOICE_AMOUNT PROJ_INVOICE_AMOUNT
, PROJ_INV_PAID_AMOUNT PROJ_INV_PAID_AMOUNT
, PROJ_INV_UNPAID_AMOUNT PROJ_INV_UNPAID_AMOUNT
, PROJ_RETAINED_AMOUNT PROJ_RETAINED_AMOUNT
, PROJ_DISCOUNT_AMOUNT PROJ_DISCOUNT_AMOUNT
, ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, ACCT_INVOICE_AMOUNT ACCT_INVOICE_AMOUNT
, ACCT_INV_PAID_AMOUNT ACCT_INV_PAID_AMOUNT
, ACCT_INV_UNPAID_AMOUNT ACCT_INV_UNPAID_AMOUNT
, ACCT_RETAINED_AMOUNT ACCT_RETAINED_AMOUNT
, ACCT_DISCOUNT_AMOUNT ACCT_DISCOUNT_AMOUNT
, INVOICE_CURRENCY INVOICE_CURRENCY
, PROJINV_TOT_AMOUNT PROJINV_TOT_AMOUNT
, AMOUNT_PAID AMOUNT_PAID
, AMOUNT_UNPAID AMOUNT_UNPAID
, RETAINED_AMOUNT RETAINED_AMOUNT
, DISCOUNT_AMOUNT DISCOUNT_AMOUNT
, PROJFUNC_CUR_PER_INV_PAID PROJFUNC_CUR_PER_INV_PAID
, PROJ_CUR_PER_INV_PAID PROJ_CUR_PER_INV_PAID
, PROJFUNC_RTAX_AMOUNT PROJFUNC_RTAX_AMOUNT
, PROJ_RTAX_AMOUNT PROJ_RTAX_AMOUNT
, ACCT_RTAX_AMOUNT ACCT_RTAX_AMOUNT
, RTAX_AMOUNT RTAX_AMOUNT
FROM "PA"."PA_PWP_AP_INV_DTL"