BC_ROLE_VW (SQL View)	Index Back
Business Contact Business Contact defines the various business contacts.

BC_ROLE_VW

(SQL View)

Business Contact

Business Contact defines the various business contacts.

SELECT BO.BO_ID , C.BO_NAME , C.BO_NAME_DISPLAY , A.CUST_ID , A.CUST_STATUS , A.CUST_STATUS_DT , A.CUR_RT_TYPE , A.CURRENCY_CD , A.VAT_TXN_TYPE_CD , A.SINCE_DT , A.SEGMENT , D.DESCR , A.DO_NOT_CONTACT , A.ASSESS_ID , A.ASSESS_DESCR , B.ROLE_TYPE_ID , CASE WHEN %DateDiff(A.SINCE_DT, %CurrentDateIn) < 365 THEN 'N' ELSE 'Y' END FROM PS_BO BO JOIN PS_BO_ROLE B ON BO.BO_ID = B.BO_ID JOIN PS_BO_NAME C ON BO.BO_ID = C.BO_ID LEFT JOIN PS_BC A ON A.bo_id = BO.bo_id LEFT JOIN PS_RD_SEGMENT D ON D.SEGMENT = A.SEGMENT AND D.SETID = A.SETID

# 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 BO_NAME Character(50) VARCHAR2(50) NOT NULL Name Description of Business Object

3 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object

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

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

6 CUST_STATUS_DT Date(10) DATE The date that the status of a customer takes effect.

7 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type

8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

9 VAT_TXN_TYPE_CD Character(4) VARCHAR2(4) NOT NULL Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.

10 SINCE_DT Date(10) DATE The customer has been a customer since this date.

11 SEGMENT Character(4) VARCHAR2(4) NOT NULL Segment code for customer data

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

13 DO_NOT_CONTACT Character(1) VARCHAR2(1) NOT NULL DO_NOT_CONTACT is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994.
N=Contact Permitted
Y=Do not contact

14 ASSESS_ID Character(10) VARCHAR2(10) NOT NULL Assessment ID

15 ASSESS_DESCR Character(30) VARCHAR2(30) NOT NULL ASSESS_DESCR

16 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

17 SINCE_YEAR Character(1) VARCHAR2(1) NOT NULL Field used by BC_ROLE_VW Record - View used by 'Customer Since More Than 1 Year' Term

#	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	BO_NAME	Character(50)	VARCHAR2(50) NOT NULL	Name Description of Business Object
3	BO_NAME_DISPLAY	Character(80)	VARCHAR2(80) NOT NULL	Full name of the Business Object
4	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
5	CUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Customer Status Indicator. BC.CUST_STATUS A=Active I=Inactive
6	CUST_STATUS_DT	Date(10)	DATE	The date that the status of a customer takes effect.
7	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
9	VAT_TXN_TYPE_CD	Character(4)	VARCHAR2(4) NOT NULL	Specifies a user-defined category of business transaction that is subject to VAT accounting and reporting. The VAT code and the VAT transaction type are used in conjunction with the VAT account type to obtain the ChartFields for accounting entries. Some examples of VAT Transaction Types are Exempt Sales Exempt Purchases Triangulation EU Sales and Domestic Sales.
10	SINCE_DT	Date(10)	DATE	The customer has been a customer since this date.
11	SEGMENT	Character(4)	VARCHAR2(4) NOT NULL	Segment code for customer data
12	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
13	DO_NOT_CONTACT	Character(1)	VARCHAR2(1) NOT NULL	DO_NOT_CONTACT is used to comply with the Telemarketing and Consumer Fraud and Abuse Prevention Act, 15 USC 6101, enacted in 1994. N=Contact Permitted Y=Do not contact
14	ASSESS_ID	Character(10)	VARCHAR2(10) NOT NULL	Assessment ID
15	ASSESS_DESCR	Character(30)	VARCHAR2(30) NOT NULL	ASSESS_DESCR
16	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
17	SINCE_YEAR	Character(1)	VARCHAR2(1) NOT NULL	Field used by BC_ROLE_VW Record - View used by 'Customer Since More Than 1 Year' Term