BO_BC_CNTCT3_VW (SQL View)	Index Back
Contacts View This is the record for the view that shows the Contacts for a person.

BO_BC_CNTCT3_VW

(SQL View)

Contacts View

This is the record for the view that shows the Contacts for a person.

SELECT DISTINCT P.PERSON_ID , A.REL_TYPE_ID , A.BO_ID_2 , A.ROLE_TYPE_ID_2 , B.SETID , B.CUST_ID , B.CUST_STATUS , B.SHIP_TO_FLG , B.SOLD_TO_FLG , A.BO_ID_1 , A.ROLE_TYPE_ID_1 , P.CONTACT_FLAG , PN.NAME , R.DESCR , R.DESCRSHORT FROM PS_BO_REL A , PS_BC_FLAGS_VW B , PS_BO_REL_CAT_ITEM C , PS_BO_SRCH_GRP_TYP D , PS_RD_PERSON P , PS_RD_PERSON_NAME PN , PS_BO_ROLE_TYPE R WHERE A.BO_ID_1 = P.BO_ID AND P.PERSON_ID = PN.PERSON_ID AND PN.PRIMARY_IND = 'Y' AND A.ROLE_TYPE_ID_1 = R.ROLE_TYPE_ID AND C.REL_TYPE_ID = A.REL_TYPE_ID AND C.BO_REL_CATEGORY_ID = 5 AND A.ROLE_TYPE_ID_2 = D.ROLE_TYPE_ID AND D.SRCH_GROUP_ID IN (2, 23) AND A.BO_ID_2 = B.BO_ID AND A.START_DT <= %CurrentDateIn AND A.END_DT > %CurrentDateIn

Related Language Record: BO_BC_CNTCT3_VL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

2 REL_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Relationship Type ID

3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

4 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

5 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

6 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

7 CUST_STATUS Character(1) VARCHAR2(1) NOT NULL Customer Status Indicator. BC.CUST_STATUS
A=Active
I=Inactive

8 SHIP_TO_FLG Character(1) VARCHAR2(1) NOT NULL A flag indicating that the customer or address is a valid Ship To customer or address.

9 SOLD_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Sold To customer.

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

11 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

12 CONTACT_FLAG Character(1) VARCHAR2(1) NOT NULL An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role.
E=External Contact
I=Internal Corporate Contact

13 NAME Character(50) VARCHAR2(50) NOT NULL Name

14 DESCR Character(30) VARCHAR2(30) NOT NULL Description

15 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
2	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
4	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
6	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
7	CUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Customer Status Indicator. BC.CUST_STATUS A=Active I=Inactive
8	SHIP_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A flag indicating that the customer or address is a valid Ship To customer or address.
9	SOLD_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A boolean that flags whether or not the customer is a valid Sold To customer.
10	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
11	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
12	CONTACT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	An attribute that describes the specific purpose of a given bank/counterparty contact person. It is also used to indicate whether a person has a Contact role. E=External Contact I=Internal Corporate Contact
13	NAME	Character(50)	VARCHAR2(50) NOT NULL	Name
14	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
15	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description