[Home] [Help] [Dependency Information]
Object Name: | PA_PWP_CUSTOMER_INVOICE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DRAFT_INVOICE_NUM | NUMBER | (15) | Yes | Draft invoice number |
RA_INVOICE_NUMBER | VARCHAR2 | (20) | AR invoice number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer name | |
CUSTOMER_NUMBER | NUMBER | (15) | Customer number | |
AGREEMENT_NUM | VARCHAR2 | (50) | Agreement number | |
BILL_THROUGH_DATE | DATE | The date through which to include expenditure items and events in the invoice. Expenditure items with the expenditure item date on or before the bill through date and events with completion dates on or before the bill through date may be included in an invoice | ||
INVOICE_CLASS | VARCHAR2 | (80) | Invoice class | |
CREDIT_OF | NUMBER | (15) | The draft invoice number that is credited by this draft invoice | |
INVOICE_DATE | DATE | The invoice date is passed to Oracle Receivables and is used to calculate the invoice due date | ||
INVOICE_STATUS_M | VARCHAR2 | (80) | Invoice status | |
PROJFUNC_INVTRANS_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type is used for converting project functional currency to invoice transaction currency | |
PROJFUNC_INVTRANS_RATE_DATE | DATE | Exchange rate date is used for converting project functional currency to invoice transaction currency | ||
PROJECT_ID | NUMBER | (15) | Yes | Project Id |
INVOICE_COUNT | NUMBER | Number of supplier invoices linked to the draft invoice | ||
PFC_LINK_AP_AMOUNT | NUMBER | Invoice amount of the linked supplier in project functional currency | ||
PC_LINK_AP_AMOUNT | NUMBER | Invoice amount of the linked supplier in project currency | ||
INV_CURRENCY_CODE | VARCHAR2 | (15) | Invoice currency code | |
INVOICE_INV_AMOUNT | NUMBER | Line amount in invoice currency | ||
INVOICE_CURR_PER_INV_AMOUNT | NUMBER | Invoice amount for the current period in invoice currency | ||
AR_INV_RECIEPT_AMOUNT | NUMBER | Reciept amount in invoice currency | ||
AR_INV_CURR_PER_RECIEPT_AMOUNT | NUMBER | Reciept amount for the current period in invoice currency | ||
AR_OUTSTANDING_AMOUNT | NUMBER | Outstanding amount in invoice currency | ||
AR_INV_ADJUSTMENT_AMOUNT | NUMBER | Adjustment amount in invoice currency | ||
INV_LINE_AMOUNT | NUMBER | Line amount in invoice currency | ||
AR_INV_TAX_AMOUNT | NUMBER | Tax amount in invoice currency | ||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Line amount in invoice currency | |
PFC_RATE | NUMBER | |||
PROJFUNC_BILL_AMOUNT | NUMBER | Invoice amount in project functional currency | ||
PROJFUNC_CURR_PER_BILL_AMOUNT | NUMBER | Invoice amount for the current period in project functional currency | ||
AR_PFC_RECIEPT_AMOUNT | NUMBER | Reciept amount in project functional currency | ||
AR_PFC_CURR_PER_RECIEPT_AMOUNT | NUMBER | Reciept amount for the current period in project functional currency | ||
AR_PFC_OUTSTANDING_AMOUNT | NUMBER | Outstanding amount in project functional currency | ||
AR_PFC_ADJUSTMENT_AMOUNT | NUMBER | Adjustment amount in project functional currency | ||
PFC_LINE_AMOUNT | NUMBER | Line amount in project functional currency | ||
AR_PFC_TAX_AMOUNT | NUMBER | Tax amount in project functional currency | ||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Project currency code | |
PROJ_BILL_AMOUNT | NUMBER | Invoice amount in project currency | ||
PROJ_CURR_PER_BILL_AMOUNT | NUMBER | Invoice amount for the current period in project currency | ||
AR_PC_RECIEPT_AMOUNT | NUMBER | Receipt amount in the project currency | ||
AR_PC_CURR_PER_RECIEPT_AMOUNT | NUMBER | Reciept amount for the current period in project currency | ||
AR_PC_OUTSTANDING_AMOUNT | NUMBER | Outstanding amount in project currency | ||
AR_PC_ADJUSTMENT_AMOUNT | NUMBER | Adjutment amount in project currency | ||
PC_LINE_AMOUNT | NUMBER | Line amount in project currency | ||
AR_PC_TAX_AMOUNT | NUMBER | Tax amount in project currency |
Cut, paste (and edit) the following text to query this object:
SELECT DRAFT_INVOICE_NUM
, RA_INVOICE_NUMBER
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, AGREEMENT_NUM
, BILL_THROUGH_DATE
, INVOICE_CLASS
, CREDIT_OF
, INVOICE_DATE
, INVOICE_STATUS_M
, PROJFUNC_INVTRANS_RATE_TYPE
, PROJFUNC_INVTRANS_RATE_DATE
, PROJECT_ID
, INVOICE_COUNT
, PFC_LINK_AP_AMOUNT
, PC_LINK_AP_AMOUNT
, INV_CURRENCY_CODE
, INVOICE_INV_AMOUNT
, INVOICE_CURR_PER_INV_AMOUNT
, AR_INV_RECIEPT_AMOUNT
, AR_INV_CURR_PER_RECIEPT_AMOUNT
, AR_OUTSTANDING_AMOUNT
, AR_INV_ADJUSTMENT_AMOUNT
, INV_LINE_AMOUNT
, AR_INV_TAX_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PFC_RATE
, PROJFUNC_BILL_AMOUNT
, PROJFUNC_CURR_PER_BILL_AMOUNT
, AR_PFC_RECIEPT_AMOUNT
, AR_PFC_CURR_PER_RECIEPT_AMOUNT
, AR_PFC_OUTSTANDING_AMOUNT
, AR_PFC_ADJUSTMENT_AMOUNT
, PFC_LINE_AMOUNT
, AR_PFC_TAX_AMOUNT
, PROJECT_CURRENCY_CODE
, PROJ_BILL_AMOUNT
, PROJ_CURR_PER_BILL_AMOUNT
, AR_PC_RECIEPT_AMOUNT
, AR_PC_CURR_PER_RECIEPT_AMOUNT
, AR_PC_OUTSTANDING_AMOUNT
, AR_PC_ADJUSTMENT_AMOUNT
, PC_LINE_AMOUNT
, AR_PC_TAX_AMOUNT
FROM APPS.PA_PWP_CUSTOMER_INVOICE_V;
APPS.PA_PWP_CUSTOMER_INVOICE_V is not referenced by any database object
|
|
|