BO_CR_PHON_VW

(SQL View)
 Index Back

Company Rep Phones

This is the customer contact phones view.

SELECT B.SETID , B.COMPANYID , A.BO_ID_CONTACT , A.ROLE_TYPE_ID_CNTCT , A.CM_TYPE_ID , A.CM_USE_START_DT , A.CM_USE_END_DT , A.CM_ID , A.PRIMARY_IND , A.PROFILE_CM_SEQ , A.CM_NICKNAME , A.CM_PURPOSE_TYPE_ID , A.PHYSICAL_LOCATION , A.COUNTRY_CODE , A.PHONE , A.EXTENSION FROM PS_RD_COMPANY B , PS_BO_REP_PHON_VW A WHERE B.BO_ID = A.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
2 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
3 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.
4 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact
5 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID
6 CM_USE_START_DT Date(10) DATE Contact Method Use Start Date
7 CM_USE_END_DT Date(10) DATE End date of a Contact Method Use
8 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
9 PRIMARY_IND Character(1) VARCHAR2(1) NOT NULL Flag that indicates whether or not it is Primary
N=No
Y=Yes
10 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
11 CM_NICKNAME Character(30) VARCHAR2(30) NOT NULL Nickname of a Contact Method
12 CM_PURPOSE_TYPE_ID Number(6,0) INTEGER NOT NULL Relationship Contact Method Purpose ID

Prompt Table: CM_PURP_TYPE

13 PHYSICAL_LOCATION Character(30) VARCHAR2(30) NOT NULL Physical Location (Free-Form)
14 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL This field stores the Country Code values.
15 PHONE Character(24) VARCHAR2(24) NOT NULL This field stores the Telephone number.
16 EXTENSION Character(6) VARCHAR2(6) NOT NULL This field stores the Phone extension.