[Home] [Help] [Dependency Information]
Object Name: | PA_PWP_CUSTOMER_SUMM_ALL# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Yes | |
PROJECT_ID | NUMBER | (15) | Yes | |
DRAFT_INVOICE_NUM | NUMBER | (15) | Yes | |
RA_INVOICE_NUMBER | VARCHAR2 | (20) | ||
DRAFT_INVOICE_NUM_CREDITED | NUMBER | (15) | ||
CUSTOMER_ID | NUMBER | (15) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
SYSTEM_REFERENCE | NUMBER | (15) | ||
TRANSFER_STATUS_CODE | VARCHAR2 | (1) | Yes | |
INVOICE_DATE | DATE | |||
INVOICE_STATUS | VARCHAR2 | (80) | ||
INVOICE_CLASS | VARCHAR2 | (80) | ||
AGREEMENT_NUM | VARCHAR2 | (50) | ||
LAST_RA_INVOICE_NUMBER | NUMBER | |||
BILL_THROUGH_DATE | DATE | |||
PROJFUNC_INVTRANS_RATE_TYPE | VARCHAR2 | (30) | ||
PROJFUNC_INVTRANS_RATE_DATE | DATE | |||
PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | ||
PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | ||
INV_CURRENCY_CODE | VARCHAR2 | (15) | ||
PFC_BILL_AMOUNT | NUMBER | |||
PFC_CP_BILL_AMOUNT | NUMBER | |||
PFC_RECIEPT_AMOUNT | NUMBER | |||
PFC_CP_RECIEPT_AMOUNT | NUMBER | |||
PFC_OUTSTANDING_AMOUNT | NUMBER | |||
PFC_ADJUSTMENT_AMOUNT | NUMBER | |||
PFC_TAX_AMOUNT | NUMBER | |||
PFC_LINE_AMOUNT | NUMBER | |||
PC_BILL_AMOUNT | NUMBER | |||
PC_CP_BILL_AMOUNT | NUMBER | |||
PC_RECIEPT_AMOUNT | NUMBER | |||
PC_CP_RECIEPT_AMOUNT | NUMBER | |||
PC_OUTSTANDING_AMOUNT | NUMBER | |||
PC_ADJUSTMENT_AMOUNT | NUMBER | |||
PC_TAX_AMOUNT | NUMBER | |||
PC_LINE_AMOUNT | NUMBER | |||
INV_BILL_AMOUNT | NUMBER | |||
INV_CP_BILL_AMOUNT | NUMBER | |||
INV_RECIEPT_AMOUNT | NUMBER | |||
INV_CP_RECIEPT_AMOUNT | NUMBER | |||
INV_OUTSTANDING_AMOUNT | NUMBER | |||
INV_ADJUSTMENT_AMOUNT | NUMBER | |||
INV_TAX_AMOUNT | NUMBER | |||
INV_LINE_AMOUNT | NUMBER | |||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE | |||
APPROVED_DATE | DATE | |||
GL_DATE | DATE | |||
RELEASED_DATE | DATE | |||
BILL_TO_CUST_NUMBER | VARCHAR2 | (30) | ||
BILL_TO_CUST_NAME | VARCHAR2 | (100) | ||
SHIP_TO_CUST_NUMBER | VARCHAR2 | (30) | ||
SHIP_TO_CUST_NAME | VARCHAR2 | (100) | ||
BILL_TO_ADDRESS | VARCHAR2 | (400) | ||
SHIP_TO_ADDRESS | VARCHAR2 | (400) |
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#;
|
|
|