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

BC_CM_FLAGS_AVW

(SQL View)

Business Contact

Business Contact defines the various business contacts.

SELECT A.BO_ID , BC.SETID , BC.CUST_ID , A.BO_CM_START_DT , A.BO_CM_END_DT , A.CM_ID , A.PROFILE_CM_SEQ , CASE WHEN 0 < ( SELECT COUNT(*) FROM PS_BO_CM_USE X1 WHERE X1.BO_ID = A.BO_ID AND X1.PROFILE_CM_SEQ = A.PROFILE_CM_SEQ AND X1.ROLE_TYPE_ID IN(41 , 45)) THEN 'Y' ELSE 'N' END, CASE WHEN 0 < ( SELECT COUNT(*) FROM PS_BO_CM_USE X2 WHERE X2.BO_ID = A.BO_ID AND X2.PROFILE_CM_SEQ = A.PROFILE_CM_SEQ AND X2.ROLE_TYPE_ID IN(41 , 45) AND X2.PRIMARY_IND = 'Y') THEN 'Y' ELSE 'N' END, CASE WHEN 0 < ( SELECT COUNT(*) FROM PS_BO_CM_USE X3 WHERE X3.BO_ID = A.BO_ID AND X3.PROFILE_CM_SEQ = A.PROFILE_CM_SEQ AND X3.ROLE_TYPE_ID IN(42 , 46)) THEN 'Y' ELSE 'N' END, CASE WHEN 0 < ( SELECT COUNT(*) FROM PS_BO_CM_USE X4 WHERE X4.BO_ID = A.BO_ID AND X4.PROFILE_CM_SEQ = A.PROFILE_CM_SEQ AND X4.ROLE_TYPE_ID IN(42 , 46) AND X4.PRIMARY_IND = 'Y') THEN 'Y' ELSE 'N' END, CASE WHEN 0 < ( SELECT COUNT(*) FROM PS_BO_CM_USE X5 WHERE X5.BO_ID = A.BO_ID AND X5.PROFILE_CM_SEQ = A.PROFILE_CM_SEQ AND X5.ROLE_TYPE_ID IN(43 , 47)) THEN 'Y' ELSE 'N' END, CASE WHEN 0 < ( SELECT COUNT(*) FROM PS_BO_CM_USE X6 WHERE X6.BO_ID = A.BO_ID AND X6.PROFILE_CM_SEQ = A.PROFILE_CM_SEQ AND X6.ROLE_TYPE_ID IN(43 , 47) AND X6.PRIMARY_IND = 'Y') THEN 'Y' ELSE 'N' END, %subrec(RB_AUDIT_SBR, A) FROM PS_BO_CM A, PS_BC BC WHERE A.BO_ID = BC.BO_ID

# 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 BO_CM_START_DT Date(10) DATE The date that a Contact Method of a Business Object takes effect.

5 BO_CM_END_DT Date(10) DATE End date of a Contact Method of a Business Object

6 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

7 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

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.
Y/N Table Edit
Default Value: N

9 PRIMARY_SHIP_TO Character(1) VARCHAR2(1) NOT NULL Primary Ship To

10 SOLD_TO_FLG Character(1) VARCHAR2(1) NOT NULL A boolean that flags whether or not the customer is a valid Sold To customer.
Y/N Table Edit
Default Value: N

11 PRIMARY_SOLD_TO Character(1) VARCHAR2(1) NOT NULL Primary Sold To

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.
Y/N Table Edit
Default Value: N

13 PRIMARY_BILL_TO Character(1) VARCHAR2(1) NOT NULL Primary Bill To

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

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

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

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

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

19 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	BO_CM_START_DT	Date(10)	DATE	The date that a Contact Method of a Business Object takes effect.
5	BO_CM_END_DT	Date(10)	DATE	End date of a Contact Method of a Business Object
6	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
7	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
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. Y/N Table Edit Default Value: N
9	PRIMARY_SHIP_TO	Character(1)	VARCHAR2(1) NOT NULL	Primary Ship To
10	SOLD_TO_FLG	Character(1)	VARCHAR2(1) NOT NULL	A boolean that flags whether or not the customer is a valid Sold To customer. Y/N Table Edit Default Value: N
11	PRIMARY_SOLD_TO	Character(1)	VARCHAR2(1) NOT NULL	Primary Sold To
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. Y/N Table Edit Default Value: N
13	PRIMARY_BILL_TO	Character(1)	VARCHAR2(1) NOT NULL	Primary Bill To
14	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
15	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
16	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
17	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
18	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.
19	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time