[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PWP_SUPPLIER_INVOICE_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  PA.PA_PWP_SUPPLIER_INVOICE_V
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| INVOICE_ID | NUMBER | (15) | Invoice Id. | |
| INVOICE_NUM | VARCHAR2 | (50) | Supplier invoice number. | |
| VENDOR_ID | NUMBER | (15) | Vendor Id. | |
| SUPPLIER_NAME | VARCHAR2 | (240) | Supplier name. | |
| INVOICE_DATE | DATE | Invoice date | ||
| SUPPLIER_SITE | VARCHAR2 | (15) | Supplier site code | |
| PAYMENT_STATUS | VARCHAR2 | (80) | Yes | Invoice payment status |
| PO_NUMBER | VARCHAR2 | (2000) | Concatinated PO numbers are the PO numbers matched to the invoice | |
| HOLD_REASON | VARCHAR2 | (4000) | Concatinated hold reason | |
| PROJECT_ID | NUMBER | (15) | Project Id. | |
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Project functional currency code. | |
| PROJ_CURRENCY_CODE | VARCHAR2 | (15) | Project currency code. | |
| INVOICE_CURRENCY | VARCHAR2 | (15) | Denom currency. | |
| PWP_HOLD_FLAG | VARCHAR2 | (1) | Pay when paid hold flag | |
| DLV_HOLD_FLAG | VARCHAR2 | (1) | Deliverable hold flag | |
| HOLD_FLAG | VARCHAR2 | (1) | Hold flag | |
| 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_INVOICE_AMOUNT | NUMBER | Invoice amount in project currency | ||
| 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 | ||
| INVOICE_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_CURR_PER_INV | NUMBER | Invoice amount for the current period in project functional currency | ||
| PROJFUNC_RECOVERABLE_TAX | NUMBER | Recoverable tax amount in project functional currency | ||
| PROJ_RECOVERABLE_TAX | NUMBER | Recoverable tax amount in project currency | ||
| ACCT_RECOVERABLE_TAX | NUMBER | Recoverable tax amount in functional currency | ||
| RECOVERABLE_TAX | NUMBER | Recoverable tax amount in invoice currency | ||
| INVOICE_TYPE | VARCHAR2 | (30) | Supplier invoice type | |
| EARLIEST_PAY_DUE_DATE | DATE | Earliest payment due date of the supplier invoice | ||
| GL_DATE | DATE | Gl date of the supplier invoice | ||
| DESCRIPTION | VARCHAR2 | (4000) | Description of the supplier invoice | |
| PREPAID_AMOUNT | NUMBER | Pre-payment amount of the supplier invoice | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (20) | Exchange rate type of Supplier Invoice | |
| EXCHANGE_RATE | NUMBER | Exchange rate of the supplier invoice | ||
| EXCHANGE_DATE | DATE | Exchange date of the supplier invoice |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, INVOICE_NUM
, VENDOR_ID
, SUPPLIER_NAME
, INVOICE_DATE
, SUPPLIER_SITE
, PAYMENT_STATUS
, PO_NUMBER
, HOLD_REASON
, PROJECT_ID
, PROJFUNC_CURRENCY_CODE
, PROJ_CURRENCY_CODE
, INVOICE_CURRENCY
, PWP_HOLD_FLAG
, DLV_HOLD_FLAG
, HOLD_FLAG
, PROJFUNC_INVOICE_AMOUNT
, PROJFUNC_INV_PAID_AMOUNT
, PROJFUNC_INV_UNPAID_AMOUNT
, PROJFUNC_RETAINED_AMOUNT
, PROJFUNC_DISCOUNT_AMOUNT
, PROJ_INVOICE_AMOUNT
, PROJ_INV_PAID_AMOUNT
, PROJ_INV_UNPAID_AMOUNT
, PROJ_RETAINED_AMOUNT
, PROJ_DISCOUNT_AMOUNT
, INVOICE_AMOUNT
, AMOUNT_PAID
, AMOUNT_UNPAID
, RETAINED_AMOUNT
, DISCOUNT_AMOUNT
, PROJFUNC_CURR_PER_INV
, PROJFUNC_RECOVERABLE_TAX
, PROJ_RECOVERABLE_TAX
, ACCT_RECOVERABLE_TAX
, RECOVERABLE_TAX
, INVOICE_TYPE
, EARLIEST_PAY_DUE_DATE
, GL_DATE
, DESCRIPTION
, PREPAID_AMOUNT
, EXCHANGE_RATE_TYPE
, EXCHANGE_RATE
, EXCHANGE_DATE
FROM APPS.PA_PWP_SUPPLIER_INVOICE_V;
APPS
GL_PERIOD_STATUSES
PA_IMPLEMENTATIONS_ALL
PA_LOOKUPS
PA_PROJECTS_ALL
PA_PWP_AP_INV_DTL
PA_PWP_AP_INV_HDR
APPS.PA_PWP_SUPPLIER_INVOICE_V is not referenced by any database object
|
|
|
|