VIEW: PA.PA_PWP_CUSTOMER_SUMM_ALL#

Source

View Text - Preformatted

select ORG_ID ORG_ID, PROJECT_ID PROJECT_ID, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM, RA_INVOICE_NUMBER RA_INVOICE_NUMBER, DRAFT_INVOICE_NUM_CREDITED DRAFT_INVOICE_NUM_CREDITED, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_NAME CUSTOMER_NAME, CUSTOMER_NUMBER CUSTOMER_NUMBER, SYSTEM_REFERENCE SYSTEM_REFERENCE, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE, INVOICE_DATE INVOICE_DATE, INVOICE_STATUS INVOICE_STATUS, INVOICE_CLASS INVOICE_CLASS, AGREEMENT_NUM AGREEMENT_NUM, LAST_RA_INVOICE_NUMBER LAST_RA_INVOICE_NUMBER, BILL_THROUGH_DATE BILL_THROUGH_DATE, PROJFUNC_INVTRANS_RATE_TYPE PROJFUNC_INVTRANS_RATE_TYPE, PROJFUNC_INVTRANS_RATE_DATE PROJFUNC_INVTRANS_RATE_DATE, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE, INV_CURRENCY_CODE INV_CURRENCY_CODE, PFC_BILL_AMOUNT PFC_BILL_AMOUNT, PFC_CP_BILL_AMOUNT PFC_CP_BILL_AMOUNT, PFC_RECIEPT_AMOUNT PFC_RECIEPT_AMOUNT, PFC_CP_RECIEPT_AMOUNT PFC_CP_RECIEPT_AMOUNT, PFC_OUTSTANDING_AMOUNT PFC_OUTSTANDING_AMOUNT, PFC_ADJUSTMENT_AMOUNT PFC_ADJUSTMENT_AMOUNT, PFC_TAX_AMOUNT PFC_TAX_AMOUNT, PFC_LINE_AMOUNT PFC_LINE_AMOUNT, PC_BILL_AMOUNT PC_BILL_AMOUNT, PC_CP_BILL_AMOUNT PC_CP_BILL_AMOUNT, PC_RECIEPT_AMOUNT PC_RECIEPT_AMOUNT, PC_CP_RECIEPT_AMOUNT PC_CP_RECIEPT_AMOUNT, PC_OUTSTANDING_AMOUNT PC_OUTSTANDING_AMOUNT, PC_ADJUSTMENT_AMOUNT PC_ADJUSTMENT_AMOUNT, PC_TAX_AMOUNT PC_TAX_AMOUNT, PC_LINE_AMOUNT PC_LINE_AMOUNT, INV_BILL_AMOUNT INV_BILL_AMOUNT, INV_CP_BILL_AMOUNT INV_CP_BILL_AMOUNT, INV_RECIEPT_AMOUNT INV_RECIEPT_AMOUNT, INV_CP_RECIEPT_AMOUNT INV_CP_RECIEPT_AMOUNT, INV_OUTSTANDING_AMOUNT INV_OUTSTANDING_AMOUNT, INV_ADJUSTMENT_AMOUNT INV_ADJUSTMENT_AMOUNT, INV_TAX_AMOUNT INV_TAX_AMOUNT, INV_LINE_AMOUNT INV_LINE_AMOUNT, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, APPROVED_DATE APPROVED_DATE, GL_DATE GL_DATE, RELEASED_DATE RELEASED_DATE, BILL_TO_CUST_NUMBER BILL_TO_CUST_NUMBER, BILL_TO_CUST_NAME BILL_TO_CUST_NAME, SHIP_TO_CUST_NUMBER SHIP_TO_CUST_NUMBER, SHIP_TO_CUST_NAME SHIP_TO_CUST_NAME, BILL_TO_ADDRESS BILL_TO_ADDRESS, SHIP_TO_ADDRESS SHIP_TO_ADDRESS from "PA"."PA_PWP_CUSTOMER_SUMM_ALL"

View Text - HTML Formatted

SELECT ORG_ID ORG_ID
, PROJECT_ID PROJECT_ID
, DRAFT_INVOICE_NUM DRAFT_INVOICE_NUM
, RA_INVOICE_NUMBER RA_INVOICE_NUMBER
, DRAFT_INVOICE_NUM_CREDITED DRAFT_INVOICE_NUM_CREDITED
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_NAME CUSTOMER_NAME
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, SYSTEM_REFERENCE SYSTEM_REFERENCE
, TRANSFER_STATUS_CODE TRANSFER_STATUS_CODE
, INVOICE_DATE INVOICE_DATE
, INVOICE_STATUS INVOICE_STATUS
, INVOICE_CLASS INVOICE_CLASS
, AGREEMENT_NUM AGREEMENT_NUM
, LAST_RA_INVOICE_NUMBER LAST_RA_INVOICE_NUMBER
, BILL_THROUGH_DATE BILL_THROUGH_DATE
, PROJFUNC_INVTRANS_RATE_TYPE PROJFUNC_INVTRANS_RATE_TYPE
, PROJFUNC_INVTRANS_RATE_DATE PROJFUNC_INVTRANS_RATE_DATE
, PROJFUNC_CURRENCY_CODE PROJFUNC_CURRENCY_CODE
, PROJECT_CURRENCY_CODE PROJECT_CURRENCY_CODE
, INV_CURRENCY_CODE INV_CURRENCY_CODE
, PFC_BILL_AMOUNT PFC_BILL_AMOUNT
, PFC_CP_BILL_AMOUNT PFC_CP_BILL_AMOUNT
, PFC_RECIEPT_AMOUNT PFC_RECIEPT_AMOUNT
, PFC_CP_RECIEPT_AMOUNT PFC_CP_RECIEPT_AMOUNT
, PFC_OUTSTANDING_AMOUNT PFC_OUTSTANDING_AMOUNT
, PFC_ADJUSTMENT_AMOUNT PFC_ADJUSTMENT_AMOUNT
, PFC_TAX_AMOUNT PFC_TAX_AMOUNT
, PFC_LINE_AMOUNT PFC_LINE_AMOUNT
, PC_BILL_AMOUNT PC_BILL_AMOUNT
, PC_CP_BILL_AMOUNT PC_CP_BILL_AMOUNT
, PC_RECIEPT_AMOUNT PC_RECIEPT_AMOUNT
, PC_CP_RECIEPT_AMOUNT PC_CP_RECIEPT_AMOUNT
, PC_OUTSTANDING_AMOUNT PC_OUTSTANDING_AMOUNT
, PC_ADJUSTMENT_AMOUNT PC_ADJUSTMENT_AMOUNT
, PC_TAX_AMOUNT PC_TAX_AMOUNT
, PC_LINE_AMOUNT PC_LINE_AMOUNT
, INV_BILL_AMOUNT INV_BILL_AMOUNT
, INV_CP_BILL_AMOUNT INV_CP_BILL_AMOUNT
, INV_RECIEPT_AMOUNT INV_RECIEPT_AMOUNT
, INV_CP_RECIEPT_AMOUNT INV_CP_RECIEPT_AMOUNT
, INV_OUTSTANDING_AMOUNT INV_OUTSTANDING_AMOUNT
, INV_ADJUSTMENT_AMOUNT INV_ADJUSTMENT_AMOUNT
, INV_TAX_AMOUNT INV_TAX_AMOUNT
, INV_LINE_AMOUNT INV_LINE_AMOUNT
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, APPROVED_DATE APPROVED_DATE
, GL_DATE GL_DATE
, RELEASED_DATE RELEASED_DATE
, BILL_TO_CUST_NUMBER BILL_TO_CUST_NUMBER
, BILL_TO_CUST_NAME BILL_TO_CUST_NAME
, SHIP_TO_CUST_NUMBER SHIP_TO_CUST_NUMBER
, SHIP_TO_CUST_NAME SHIP_TO_CUST_NAME
, BILL_TO_ADDRESS BILL_TO_ADDRESS
, SHIP_TO_ADDRESS SHIP_TO_ADDRESS
FROM "PA"."PA_PWP_CUSTOMER_SUMM_ALL"