OM_BI_IVC_VW

(SQL View)
 Index Back

Bill Hdr Search vw

Bill Hdr Search Source from "OM"

SELECT DISTINCT H.BUSINESS_UNIT , H.INVOICE , H.INVOICE_TYPE , H.BILL_TYPE_ID , H.BILL_STATUS , H.BILL_SOURCE_ID , H.BILL_TO_CUST_ID FROM PS_BI_HDR H , PS_BI_LINE L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.INVOICE = L.INVOICE AND H.BILL_STATUS NOT IN ('CAN','TMP','TMR') AND L.SYSTEM_SOURCE = 'OBI'

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

Prompt Table: SP_BU_BI_NONVW

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

Default Value: NEXT

Prompt Table: BI_HDR

3 INVOICE_TYPE Character(3) VARCHAR2(3) NOT NULL Invoice Type
ACR=Credit Bill
ADJ=Adjustment Only bill
ARB=Rebill Bill
PRF=Pro Forma Invoice
RAD=Regular bill with adjustments
REG=Regular Bill

Default Value: REG

4 BILL_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Bill Type Identifier

Prompt Table: BI_TYPE

5 BILL_STATUS Character(3) VARCHAR2(3) NOT NULL Bill Status
CAN=Canceled
FNL=Finalized Bill
HLD=Hold Bill
INV=Invoiced Bill
NEW=New Bill
PND=Pending Approval
RDY=Ready to Invoice
TMP=Temporary Bill
TMR=Temporary Ready Bill

Default Value: NEW

6 BILL_SOURCE_ID Character(10) VARCHAR2(10) NOT NULL Bill Source

Prompt Table: BI_SRC

7 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer

Prompt Table: CUST_BI_A2_VW