BI_CONTC_CNI_VW (SQL View)	Index Back
BillCont Consol Inv Consol Vw

BI_CONTC_CNI_VW

(SQL View)

BillCont Consol Inv Consol Vw

select distinct contract_num, 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.