BC_CI_VW (SQL View)	Index Back
BC_CI_VW -- For CI This view: BC_CI_VW has the same structure as the record: BC. As delivered, this view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly.

BC_CI_VW

(SQL View)

BC_CI_VW -- For CI

This view: BC_CI_VW has the same structure as the record: BC. As delivered, this view does not contain any PeopleCode and is used in Component Interface (CI) components only. Whenever the structure of the underlying record changes, this view must be modified accordingly.

SELECT A.BO_ID , A.SETID , A.CUST_ID , A.CUSTOMER_IND , A.CUST_STATUS , A.CUST_STATUS_DT , A.CUR_RT_TYPE , A.CURRENCY_CD , A.VAT_TXN_TYPE_CD , A.CR_RATING , A.SINCE_DT , A.ADD_DT , A.SEGMENT , A.DO_NOT_CONTACT , A.DO_NOT_EMAIL , A.DO_NOT_MAIL , A.DO_NOT_CALL , %subrec(BC_KPI_SBR,A) , %subrec(RB_AUDIT_SBR, A) 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 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

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

4 CUSTOMER_IND Character(1) VARCHAR2(1) NOT NULL Customer Indicator for Business Contacts.
N=No
Y=Yes

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

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

7 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
Default Value: INSTALLATION.DEF_CUR_RT_TYPE
Prompt Table: RT_TYPE_TBL

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

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.
Prompt Table: VAT_TXN_CD

10 CR_RATING Number(5,0) INTEGER NOT NULL Credit Rating Field. Used to store Credit Rating of a Company Or Consumer. It is used in BC (Business Contact) Record

11 SINCE_DT Date(10) DATE The customer has been a customer since this date.
Default Value: %date

12 ADD_DT Date(10) DATE The date the customer was added to the system.
Default Value: %date

13 SEGMENT Character(4) VARCHAR2(4) NOT NULL Segment code for customer data
Prompt Table: RD_SEGMENT

14 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
Default Value: N

15 DO_NOT_EMAIL Character(1) VARCHAR2(1) NOT NULL Do Not Email
N=No
Y=Yes

16 DO_NOT_MAIL Character(1) VARCHAR2(1) NOT NULL Do Not Mail
N=No
Y=Yes

17 DO_NOT_CALL Character(1) VARCHAR2(1) NOT NULL channel flag of privacy preference
N=No
Y=Yes

18 KPI_ID Character(10) VARCHAR2(10) NOT NULL KPI ID

19 OBJ_ID Character(20) VARCHAR2(20) NOT NULL Dimension

20 PF_OBJ_TYPE Character(4) VARCHAR2(4) NOT NULL Object type. Also used for Chunking.

21 RESOLVED_VALUE Signed Number(26,6) DECIMAL(24,6) NOT NULL Contains a number which is the value for the KPI/Object for the current Scenario, Fiscal Year and Accounting Period.

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

23 PCT_OF_TARGET Signed Number(8,2) DECIMAL(6,2) NOT NULL is the Percent that the Actual Value of the KPI/Object is of it's Target Value.

24 CURRENT_TARGET Signed Number(26,6) DECIMAL(24,6) NOT NULL Current Target

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

26 ASSESS_IMAGE_ID Character(30) VARCHAR2(30) NOT NULL ASSESS_IMAGE_ID

27 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

28 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

29 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

30 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

31 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

32 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
3	CUST_ID	Character(15)	VARCHAR2(15) NOT NULL	Customer ID
4	CUSTOMER_IND	Character(1)	VARCHAR2(1) NOT NULL	Customer Indicator for Business Contacts. N=No Y=Yes
5	CUST_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Customer Status Indicator. BC.CUST_STATUS A=Active I=Inactive Default Value: A
6	CUST_STATUS_DT	Date(10)	DATE	The date that the status of a customer takes effect. Default Value: %date
7	CUR_RT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Currency Rate Type Default Value: INSTALLATION.DEF_CUR_RT_TYPE Prompt Table: RT_TYPE_TBL
8	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value. Prompt Table: CURRENCY_CD_TBL
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. Prompt Table: VAT_TXN_CD
10	CR_RATING	Number(5,0)	INTEGER NOT NULL	Credit Rating Field. Used to store Credit Rating of a Company Or Consumer. It is used in BC (Business Contact) Record
11	SINCE_DT	Date(10)	DATE	The customer has been a customer since this date. Default Value: %date
12	ADD_DT	Date(10)	DATE	The date the customer was added to the system. Default Value: %date
13	SEGMENT	Character(4)	VARCHAR2(4) NOT NULL	Segment code for customer data Prompt Table: RD_SEGMENT
14	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 Default Value: N
15	DO_NOT_EMAIL	Character(1)	VARCHAR2(1) NOT NULL	Do Not Email N=No Y=Yes
16	DO_NOT_MAIL	Character(1)	VARCHAR2(1) NOT NULL	Do Not Mail N=No Y=Yes
17	DO_NOT_CALL	Character(1)	VARCHAR2(1) NOT NULL	channel flag of privacy preference N=No Y=Yes
18	KPI_ID	Character(10)	VARCHAR2(10) NOT NULL	KPI ID
19	OBJ_ID	Character(20)	VARCHAR2(20) NOT NULL	Dimension
20	PF_OBJ_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Object type. Also used for Chunking.
21	RESOLVED_VALUE	Signed Number(26,6)	DECIMAL(24,6) NOT NULL	Contains a number which is the value for the KPI/Object for the current Scenario, Fiscal Year and Accounting Period.
22	ASSESS_ID	Character(10)	VARCHAR2(10) NOT NULL	Assessment ID
23	PCT_OF_TARGET	Signed Number(8,2)	DECIMAL(6,2) NOT NULL	is the Percent that the Actual Value of the KPI/Object is of it's Target Value.
24	CURRENT_TARGET	Signed Number(26,6)	DECIMAL(24,6) NOT NULL	Current Target
25	ASSESS_DESCR	Character(30)	VARCHAR2(30) NOT NULL	ASSESS_DESCR
26	ASSESS_IMAGE_ID	Character(30)	VARCHAR2(30) NOT NULL	ASSESS_IMAGE_ID
27	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
28	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
29	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
30	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
31	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
32	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time