[Home] [Help] [Dependency Information]
Object Name: | PA_PWP_AP_INV_DTL# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PA_PWP_AP_HDR_ID | NUMBER | (15) | Yes | |
INVOICE_ID | NUMBER | (15) | ||
PROJECT_ID | NUMBER | (15) | ||
TASK_ID | NUMBER | (15) | ||
EXPENDITURE_ITEM_DATE | DATE | |||
PO_HEADER_ID | NUMBER | (15) | ||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJFUNC_INVOICE_AMOUNT | NUMBER | |||
PROJFUNC_INV_PAID_AMOUNT | NUMBER | |||
PROJFUNC_INV_UNPAID_AMOUNT | NUMBER | |||
PROJFUNC_RETAINED_AMOUNT | NUMBER | |||
PROJFUNC_DISCOUNT_AMOUNT | NUMBER | |||
PROJ_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJ_INVOICE_AMOUNT | NUMBER | |||
PROJ_INV_PAID_AMOUNT | NUMBER | |||
PROJ_INV_UNPAID_AMOUNT | NUMBER | |||
PROJ_RETAINED_AMOUNT | NUMBER | |||
PROJ_DISCOUNT_AMOUNT | NUMBER | |||
ACCT_CURRENCY_CODE | VARCHAR2 | (15) | ||
ACCT_INVOICE_AMOUNT | NUMBER | |||
ACCT_INV_PAID_AMOUNT | NUMBER | |||
ACCT_INV_UNPAID_AMOUNT | NUMBER | |||
ACCT_RETAINED_AMOUNT | NUMBER | |||
ACCT_DISCOUNT_AMOUNT | NUMBER | |||
INVOICE_CURRENCY | VARCHAR2 | (15) | ||
PROJINV_TOT_AMOUNT | NUMBER | |||
AMOUNT_PAID | NUMBER | |||
AMOUNT_UNPAID | NUMBER | |||
RETAINED_AMOUNT | NUMBER | |||
DISCOUNT_AMOUNT | NUMBER | |||
PROJFUNC_CUR_PER_INV_PAID | NUMBER | |||
PROJ_CUR_PER_INV_PAID | NUMBER | |||
PROJFUNC_RTAX_AMOUNT | NUMBER | |||
PROJ_RTAX_AMOUNT | NUMBER | |||
ACCT_RTAX_AMOUNT | NUMBER | |||
RTAX_AMOUNT | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PA_PWP_AP_HDR_ID
, INVOICE_ID
, PROJECT_ID
, TASK_ID
, EXPENDITURE_ITEM_DATE
, PO_HEADER_ID
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_INVOICE_AMOUNT
, PROJFUNC_INV_PAID_AMOUNT
, PROJFUNC_INV_UNPAID_AMOUNT
, PROJFUNC_RETAINED_AMOUNT
, PROJFUNC_DISCOUNT_AMOUNT
, PROJ_CURRENCY_CODE
, PROJ_INVOICE_AMOUNT
, PROJ_INV_PAID_AMOUNT
, PROJ_INV_UNPAID_AMOUNT
, PROJ_RETAINED_AMOUNT
, PROJ_DISCOUNT_AMOUNT
, ACCT_CURRENCY_CODE
, ACCT_INVOICE_AMOUNT
, ACCT_INV_PAID_AMOUNT
, ACCT_INV_UNPAID_AMOUNT
, ACCT_RETAINED_AMOUNT
, ACCT_DISCOUNT_AMOUNT
, INVOICE_CURRENCY
, PROJINV_TOT_AMOUNT
, AMOUNT_PAID
, AMOUNT_UNPAID
, RETAINED_AMOUNT
, DISCOUNT_AMOUNT
, PROJFUNC_CUR_PER_INV_PAID
, PROJ_CUR_PER_INV_PAID
, PROJFUNC_RTAX_AMOUNT
, PROJ_RTAX_AMOUNT
, ACCT_RTAX_AMOUNT
, RTAX_AMOUNT
FROM PA.PA_PWP_AP_INV_DTL#;
|
|
|