SPF_WO_SRCH_VW

(SQL View)
Index Back

Invoice Work Order Search View

Search view to return a list of Work Orders that have been invoiced.

SELECT DISTINCT BUSINESS_UNIT , INVOICE_ID , WORK_ORDER_ID FROM PS_SPF_INVOICE_DTL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Default Value: BUS_UNIT_TBL_FS.BUSINESS_UNIT

Prompt Table: SP_BU_SP_NONVW

2 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
3 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID