BI_CUSTC_CNI_VW (SQL View)	Index Back
BillCust Consol Inv Consol Vw

BI_CUSTC_CNI_VW

(SQL View)

BillCust Consol Inv Consol Vw

select distinct bill_to_cust_id, consol_invoice from PS_BI_HDR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 CONSOL_INVOICE Character(22) VARCHAR2(22) NOT NULL Specifies the invoice identifier associated with a consolidated bill.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	KEY_QRY_VALUE	Character(30)	VARCHAR2(30) NOT NULL	Key Query Value
2	CONSOL_INVOICE	Character(22)	VARCHAR2(22) NOT NULL	Specifies the invoice identifier associated with a consolidated bill.