RSF_LE_ACCT_VW(SQL View) |
Index Back |
---|---|
Leads accessible by AccountRepA Customer account rep should be able to view the leads which are created for that customer, even though that account rep may not be on the lead team. This view joins with the Customer flat table to establish the lead and account rep relationship. |
SELECT DISTINCT A.LEAD_ID , DESCR50 , A.BUSINESS_UNIT , A.BO_ID_CUST , E.PERSON_ID , %subrec(RB_AUDIT_SBR, A) FROM PS_RSF_LEAD A , PS_RB_CUST_FLAT B , PS_BO_REL C , PS_RD_PERSON E WHERE A.BO_ID_CUST = B.BO_ID_PARENT AND B.BO_ID_PARENT = C.BO_ID_2 AND C.BO_ID_1 = E.BO_ID AND C.REL_TYPE_ID IN (31,32) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | LEAD_ID | Character(15) | VARCHAR2(15) NOT NULL | Used by Sales Force Automation, this field uniquely identifies a Sales Lead. |
2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: RSF_OPR_DEF_VW.BUSINESS_UNIT Prompt Table: SP_BU_RSF_NONVW |
4 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
5 | PERSON_ID_ACCT | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Person ID of the account team owner or account team member. |
6 | ROW_ADDED_DTTM | DateTime(26) | TIMESTAMP | This is a datetime field for record creation. |
7 | ROW_ADDED_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who added the row. |
8 | ROW_LASTMANT_DTTM | DateTime(26) | TIMESTAMP | The date and time that the row was last updated. |
9 | ROW_LASTMANT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | ID of user who last modified the row. |
10 | 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. |
11 | SYNCDTTM | DateTime(26) | TIMESTAMP | Synchronization Last Update Date Time |