SPF_INV_HDR_VW

(SQL View)
 Index Back

Invoices for WO

This view fetches invoices for a given WO

SELECT DISTINCT A.BUSINESS_UNIT , A.INVOICE_ID , A.VENDOR_ID , B.WORK_ORDER_ID , W.MRSC_PARENT_WOID , W.SUB_LINE FROM PS_SPF_INVOICE_HDR A , PS_SPF_INVOICE_DTL B , PS_SPF_WORDERREC W WHERE A.INVOICE_ID = B.INVOICE_ID AND B.BUSINESS_UNIT = W.BUSINESS_UNIT AND B.WORK_ORDER_ID = W.WORK_ORDER_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INVOICE_ID Character(30) VARCHAR2(30) NOT NULL Invoice Number
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
5 MRSC_PARENT_WOID Character(15) VARCHAR2(15) NOT NULL Multi Resource Parent WOID
6 SUB_LINE Character(1) VARCHAR2(1) NOT NULL Sub Line
N=No
Y=Yes