DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_PWP_AP_INV_DTL

Object Details
Object Name: PA_PWP_AP_INV_DTL
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_PWP_AP_INV_DTL
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PA_PWP_AP_HDR_ID NUMBER (15) Yes A sequence number to map to the header table
INVOICE_ID NUMBER (15)
Vendor invoice Id
PROJECT_ID NUMBER (15)
Project Id
TASK_ID NUMBER (15)
Task Id
EXPENDITURE_ITEM_DATE DATE

Expenditure item date
PO_HEADER_ID NUMBER (15)
PO header Id
PROJFUNC_CURRENCY_CODE VARCHAR2 (15)
Project functional currency code
PROJFUNC_INVOICE_AMOUNT NUMBER

Invoice amount in project functional currency
PROJFUNC_INV_PAID_AMOUNT NUMBER

Paid invoice amount in project functional currency
PROJFUNC_INV_UNPAID_AMOUNT NUMBER

Unpaid invoice amount in project functional currency
PROJFUNC_RETAINED_AMOUNT NUMBER

Retained amount in project functional currency
PROJFUNC_DISCOUNT_AMOUNT NUMBER

Discount amount in project functional currency
PROJ_CURRENCY_CODE VARCHAR2 (15)
Project currency code
PROJ_INVOICE_AMOUNT NUMBER

Project currency invoice amount
PROJ_INV_PAID_AMOUNT NUMBER

Paid invoice amount in project currency
PROJ_INV_UNPAID_AMOUNT NUMBER

Unpaid invoice amount in project currency
PROJ_RETAINED_AMOUNT NUMBER

Retained amount in project currency
PROJ_DISCOUNT_AMOUNT NUMBER

Discount amount in project currency
ACCT_CURRENCY_CODE VARCHAR2 (15)
Functional currency code
ACCT_INVOICE_AMOUNT NUMBER

Invoice amount in functional currency
ACCT_INV_PAID_AMOUNT NUMBER

Paid invoice amount in functional currency
ACCT_INV_UNPAID_AMOUNT NUMBER

Unpaid invoice amount in functional currency
ACCT_RETAINED_AMOUNT NUMBER

Retained amount in functional currency
ACCT_DISCOUNT_AMOUNT NUMBER

Discount amount in functional currency
INVOICE_CURRENCY VARCHAR2 (15)
Denom currency
PROJINV_TOT_AMOUNT NUMBER

Invoice amount in denom currency
AMOUNT_PAID NUMBER

Paid invoice amount in denom currency
AMOUNT_UNPAID NUMBER

Unpaid invoice amount in denom currency
RETAINED_AMOUNT NUMBER

Retained amount in denom currency
DISCOUNT_AMOUNT NUMBER

Discount amount in denom currency
PROJFUNC_CUR_PER_INV_PAID NUMBER

Invoice paid amount for the current period in project functional currency
PROJ_CUR_PER_INV_PAID NUMBER

Invoice paid amount for current period in project currency
PROJFUNC_RTAX_AMOUNT NUMBER

Recoverable tax amount in project functional currency
PROJ_RTAX_AMOUNT NUMBER

Recoverable tax amount in project currency
ACCT_RTAX_AMOUNT NUMBER

Recoverable tax amount in functional currency
RTAX_AMOUNT NUMBER

Recoverable tax amount in invoice currency
Query Text

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;

Dependencies

[top of page]

PA.PA_PWP_AP_INV_DTL does not reference any database object

PA.PA_PWP_AP_INV_DTL is referenced by following:

SchemaPA
ViewPA_PWP_AP_INV_DTL#