BI_CUSTH_NIV_VW (SQL View)	Index Back
BillCust Header Not Invoice Vw

BI_CUSTH_NIV_VW

(SQL View)

BillCust Header Not Invoice Vw

select business_unit, bill_to_cust_id, invoice, template_ivc_flg from PS_BI_HDR where bill_status <> 'INV'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 KEY_QRY_VALUE Character(30) VARCHAR2(30) NOT NULL Key Query Value

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

4 TEMPLATE_IVC_FLG Character(1) VARCHAR2(1) NOT NULL Template Invoice Flag
I=Installment Bill
N=No
R=Recurring Bill

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	KEY_QRY_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Key Query Value
3	INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Invoice
4	TEMPLATE_IVC_FLG	Character(1)	VARCHAR2(1) NOT NULL	Template Invoice Flag I=Installment Bill N=No R=Recurring Bill