BICONSOLINV_VW

(SQL View)
 Index Back

SELECT DISTINCT HDR.BUSINESS_UNIT , HDR.CONSOL_INVOICE FROM PS_BI_HDR HDR , PS_BI_HDR_EC EC WHERE HDR.BUSINESS_UNIT = EC.BUSINESS_UNIT AND HDR.INVOICE = EC.INVOICE AND HDR.CONSOL_INVOICE <> ' '

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