[Home] [Help] [Dependency Information]
Object Name: | PA_PWP_CUSTOMER_SUMM_ALL |
---|---|
Object Type: | TABLE |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Table used to generate summary data for display in subcontractor workbench.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | Project Id |
DRAFT_INVOICE_NUM | NUMBER | (15) | Yes | Draft invoice number |
RA_INVOICE_NUMBER | VARCHAR2 | (20) | AR invoice number | |
DRAFT_INVOICE_NUM_CREDITED | NUMBER | (15) | The draft invoice number that is credited by this draft invoice. The crediting invoice may be a credit memo or a write-off | |
CUSTOMER_ID | NUMBER | (15) | Customer Id | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer name | |
CUSTOMER_NUMBER | NUMBER | (15) | Customer number | |
SYSTEM_REFERENCE | NUMBER | (15) | The reference to the invoice created in Oracle Receivables from the draft invoice. The column is populated only for tied back invoices and holds the RA_CUSTOMER_TRX.CUSTOMER_TRX_ID | |
TRANSFER_STATUS_CODE | VARCHAR2 | (1) | Yes | The status of the invoice as it is transferred to Oracle Receivables |
INVOICE_DATE | DATE | The invoice date is passed to Oracle Receivables and is used to calculate the invoice due date | ||
INVOICE_STATUS | VARCHAR2 | (80) | Invoice status | |
INVOICE_CLASS | VARCHAR2 | (80) | Invoice class | |
AGREEMENT_NUM | VARCHAR2 | (50) | Agreement number | |
LAST_RA_INVOICE_NUMBER | 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 on an invoice | ||
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 | ||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Project functional currency code | |
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Project currency code | |
INV_CURRENCY_CODE | VARCHAR2 | (15) | Invoice currency code | |
PFC_BILL_AMOUNT | NUMBER | Invoice amount in project functional currency | ||
PFC_CP_BILL_AMOUNT | NUMBER | Invoice amount for the current period in project functional currency | ||
PFC_RECIEPT_AMOUNT | NUMBER | Reciept amount in project functional currency | ||
PFC_CP_RECIEPT_AMOUNT | NUMBER | Reciept amount for the current period in project functional currency | ||
PFC_OUTSTANDING_AMOUNT | NUMBER | Outstanding amount in project functional currency | ||
PFC_ADJUSTMENT_AMOUNT | NUMBER | Adjustment amount in project functional currency | ||
PFC_TAX_AMOUNT | NUMBER | Tax amount in project functional currency | ||
PFC_LINE_AMOUNT | NUMBER | Line amount in project functional currency | ||
PC_BILL_AMOUNT | NUMBER | Invoice amount in project currency | ||
PC_CP_BILL_AMOUNT | NUMBER | Invoice amount for the current period in project currency | ||
PC_RECIEPT_AMOUNT | NUMBER | Reciept amount in project currency | ||
PC_CP_RECIEPT_AMOUNT | NUMBER | Reciept amount for the current period in project currency | ||
PC_OUTSTANDING_AMOUNT | NUMBER | Outstanding amount in project currency | ||
PC_ADJUSTMENT_AMOUNT | NUMBER | Adjutment amount in project currency | ||
PC_TAX_AMOUNT | NUMBER | Tax amount in project currency | ||
PC_LINE_AMOUNT | NUMBER | Line amount in Project Currency | ||
INV_BILL_AMOUNT | NUMBER | Invoice amount in invoice currency | ||
INV_CP_BILL_AMOUNT | NUMBER | Invoice amount for the current period in invoice currency | ||
INV_RECIEPT_AMOUNT | NUMBER | Reciept amount in invoice currency | ||
INV_CP_RECIEPT_AMOUNT | NUMBER | Reciept amount for the current period in invoice currency | ||
INV_OUTSTANDING_AMOUNT | NUMBER | Outstanding amount in invoice currency | ||
INV_ADJUSTMENT_AMOUNT | NUMBER | Adjustment amount in invoice currency | ||
INV_TAX_AMOUNT | NUMBER | Tax amount in invoice currency | ||
INV_LINE_AMOUNT | NUMBER | Line amount in invoice currency | ||
CREATED_BY | NUMBER | (15) | Standard who column | |
CREATION_DATE | DATE | Standard who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
LAST_UPDATE_DATE | DATE | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, PROJECT_ID
, DRAFT_INVOICE_NUM
, RA_INVOICE_NUMBER
, DRAFT_INVOICE_NUM_CREDITED
, CUSTOMER_ID
, CUSTOMER_NAME
, CUSTOMER_NUMBER
, SYSTEM_REFERENCE
, TRANSFER_STATUS_CODE
, INVOICE_DATE
, INVOICE_STATUS
, INVOICE_CLASS
, AGREEMENT_NUM
, LAST_RA_INVOICE_NUMBER
, BILL_THROUGH_DATE
, PROJFUNC_INVTRANS_RATE_TYPE
, PROJFUNC_INVTRANS_RATE_DATE
, PROJFUNC_CURRENCY_CODE
, PROJECT_CURRENCY_CODE
, INV_CURRENCY_CODE
, PFC_BILL_AMOUNT
, PFC_CP_BILL_AMOUNT
, PFC_RECIEPT_AMOUNT
, PFC_CP_RECIEPT_AMOUNT
, PFC_OUTSTANDING_AMOUNT
, PFC_ADJUSTMENT_AMOUNT
, PFC_TAX_AMOUNT
, PFC_LINE_AMOUNT
, PC_BILL_AMOUNT
, PC_CP_BILL_AMOUNT
, PC_RECIEPT_AMOUNT
, PC_CP_RECIEPT_AMOUNT
, PC_OUTSTANDING_AMOUNT
, PC_ADJUSTMENT_AMOUNT
, PC_TAX_AMOUNT
, PC_LINE_AMOUNT
, INV_BILL_AMOUNT
, INV_CP_BILL_AMOUNT
, INV_RECIEPT_AMOUNT
, INV_CP_RECIEPT_AMOUNT
, INV_OUTSTANDING_AMOUNT
, INV_ADJUSTMENT_AMOUNT
, INV_TAX_AMOUNT
, INV_LINE_AMOUNT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM PA.PA_PWP_CUSTOMER_SUMM_ALL;
PA.PA_PWP_CUSTOMER_SUMM_ALL does not reference any database object
PA.PA_PWP_CUSTOMER_SUMM_ALL is referenced by following:
|
|
|