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

BC_VW

(SQL View)

Business Contact

Business Contact defines the various business contacts.

SELECT A.BO_ID , 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 , A.DO_NOT_CONTACT FROM PS_BC 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 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID

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

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

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

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

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

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

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

10 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

#	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	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
3	CUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Customer Status Indicator. BC.CUST_STATUS A=Active I=Inactive
4	CUST_STATUS_DT	Date(10)	DATE	The date that the status of a customer takes effect.
5	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
7	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.
8	SINCE_DT	Date(10)	DATE	The customer has been a customer since this date.
9	SEGMENT	Character(4)	VARCHAR2(4) NOT NULL	Segment code for customer data
10	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