BC_CM_FLAGS_VW

(SQL View)
 Index Back

Business Contact

Business Contact defines the various business contacts.

SELECT A.BO_ID , A.BO_CM_START_DT , A.PROFILE_CM_SEQ , BC.SETID , BC.CUST_ID , A.BO_CM_END_DT , A.CM_ID , 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.CM_USE_START_DT <= %CurrentDateIn AND X1.CM_USE_END_DT > %CurrentDateIn 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.CM_USE_START_DT <= %CurrentDateIn AND X2.CM_USE_END_DT > %CurrentDateIn 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.CM_USE_START_DT <= %CurrentDateIn AND X3.CM_USE_END_DT > %CurrentDateIn 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.CM_USE_START_DT <= %CurrentDateIn AND X4.CM_USE_END_DT > %CurrentDateIn 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.CM_USE_START_DT <= %CurrentDateIn AND X5.CM_USE_END_DT > %CurrentDateIn 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.CM_USE_START_DT <= %CurrentDateIn AND X6.CM_USE_END_DT > %CurrentDateIn 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 AND A.BO_CM_START_DT <= %CurrentDateIn AND A.BO_CM_END_DT > %CurrentDateIn

# 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_CM_START_DT Date(10) DATE The date that a Contact Method of a Business Object takes effect.
3 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.
4 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
5 CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer ID
6 BO_CM_END_DT Date(10) DATE End date of a Contact Method of a Business Object
7 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID
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