C360_BI_HDR1_VW

(SQL View)
 Index Back

Bill Header View

Filter View

SELECT A.BUSINESS_UNIT ,A.INVOICE FROM PS_BI_HDR A , PS_SET_CNTRL_REC S WHERE S.SETCNTRLVALUE = A.BUSINESS_UNIT AND S.RECNAME = 'CUSTOMER' AND A.TEMPLATE_IVC_FLG = 'N' AND A.CONSOL_HDR <> 'Y' AND A.CONSOL_INVOICE = ' ' AND (A.BILL_STATUS NOT IN ('TMP','TMR') OR (A.BILL_STATUS IN ('TMP','TMR') AND A.PC_DISTRIB_STATUS <> 'I'))

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

Prompt Table: SP_BU_BI_NONVW

2 INVOICE Character(22) VARCHAR2(22) NOT NULL Invoice