[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.PA_PWP_SUPPLIER_INVOICE_V is not referenced by any database object
|
|
|