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

TABLE: PA.PA_PWP_CUSTOMER_SUMM_ALL

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


Table used to generate summary data for display in subcontractor workbench.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
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 VARCHAR2 (30)
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 invoice the project.
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
APPROVED_DATE DATE

This column stores the date of approval for Customer Invoice
GL_DATE DATE

This column stores the gl date of the Customer Invoice
RELEASED_DATE DATE

This column stores the date when the customer invoice was released.
BILL_TO_CUST_NUMBER VARCHAR2 (30)
This column stores the customer number, as per the customer invoice, against whom the bill will be generated.
BILL_TO_CUST_NAME VARCHAR2 (100)
The column stores the name of the customer, as per the customer invoice, against whom the bill will be generated.
SHIP_TO_CUST_NUMBER VARCHAR2 (30)
This column stores the identifying number of the customer, as per the customer invoice, to whom the shipment will be sent.
SHIP_TO_CUST_NAME VARCHAR2 (100)
This column stores the name of the customer, as per the customer invoice, to whom the shipment will be sent.
BILL_TO_ADDRESS VARCHAR2 (400)
This column stores the address, as per the customer invoice, where the bill will be sent.
SHIP_TO_ADDRESS VARCHAR2 (400)
This column stores the address, as per the customer invoice, where the shipment will be sent.
Query Text

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
,      APPROVED_DATE
,      GL_DATE
,      RELEASED_DATE
,      BILL_TO_CUST_NUMBER
,      BILL_TO_CUST_NAME
,      SHIP_TO_CUST_NUMBER
,      SHIP_TO_CUST_NAME
,      BILL_TO_ADDRESS
,      SHIP_TO_ADDRESS
FROM PA.PA_PWP_CUSTOMER_SUMM_ALL;

Dependencies

[top of page]

PA.PA_PWP_CUSTOMER_SUMM_ALL does not reference any database object

PA.PA_PWP_CUSTOMER_SUMM_ALL is referenced by following:

SchemaPA
ViewPA_PWP_CUSTOMER_SUMM_ALL#