BO_CNTCT_BC_VW (SQL View)	Index Back
Contact - Business Contact This view returns all the Business Contact - Contacts. The Contact will be returned to the BO_ID_CONTACT field and the Business Contact will be returned to the BO_ID field.

BO_CNTCT_BC_VW

(SQL View)

Contact - Business Contact

This view returns all the Business Contact - Contacts. The Contact will be returned to the BO_ID_CONTACT field and the Business Contact will be returned to the BO_ID field.

SELECT A.REL_TYPE_ID , A.BO_ID_1 , A.ROLE_TYPE_ID_1 , A.BO_ID_2 , A.ROLE_TYPE_ID_2 , A.BO_REL_ID , B.SETID , B.CUST_ID , B.CUST_STATUS , B.SHIP_TO_FLG , B.SOLD_TO_FLG , B.BILL_TO_FLG FROM PS_BO_REL_CUR_VW A , PS_BC_FLAGS_VW B , PS_BO_REL_CAT_ITEM C WHERE C.REL_TYPE_ID = A.REL_TYPE_ID AND C.BO_REL_CATEGORY_ID = 1 AND A.BO_ID_2 = B.BO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

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

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

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

6 BO_REL_ID Signed Number(32,0) DECIMAL(31) NOT NULL Relationship ID of a Business Object

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

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

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

10 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.

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

12 BILL_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Bill To customer.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	REL_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Relationship Type ID
2	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
3	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
4	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
5	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
6	BO_REL_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Relationship ID of a Business Object
7	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
8	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
9	CUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Customer Status Indicator. BC.CUST_STATUS A=Active I=Inactive
10	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.
11	SOLD_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A boolean that flags whether or not the customer is a valid Sold To customer.
12	BILL_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A boolean that flags whether or not the customer is a valid Bill To customer.