PC_INV_INV_VW

(SQL View)
 Index Back

PC INV Invoice View

The Invoice view will display a unique set of invoices from Proj_Resource where the Invoice Number isn't Null

SELECT DISTINCT A.BUSINESS_UNIT, A.PROJECT_ID, A.INVOICE FROM PS_PROJ_RESOURCE A WHERE A.INVOICE <> ' '

  • Parent record: PROJ_ACTIVITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    3 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice