BO_CI_PHONE_VW1 (SQL View)	Index Back
BO_CI_PHONE_VW1 -- For CI This view is used as a prompt in BO_CI_ADDR_VW.

BO_CI_PHONE_VW1

(SQL View)

BO_CI_PHONE_VW1 -- For CI

This view is used as a prompt in BO_CI_ADDR_VW.

SELECT A.BO_ID , A.CM_ID , A.PHONE FROM PS_BO_CI_PHONE_VW A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 CM_ID_PHONE Number(31,0) DECIMAL(31) NOT NULL CM_ID_PHONE

3 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	CM_ID_PHONE	Number(31,0)	DECIMAL(31) NOT NULL	CM_ID_PHONE
3	PHONE	Character(24)	VARCHAR2(24) NOT NULL	This field stores the Telephone number.