SYNCID1=Active
2=Approved
3=Rejected
4=Pending Approval
5=Inactive
Prompt Table:
SP_SETID_NONVW
Set Control Field: SETID
RB_TSK_PTNR_PR(SQL View) |
Index Back |
|---|---|
Partner Company PromptPartner Company prompt for Task. used to link Task to a company. |
| SELECT SYNCID ,BO_NAME ,BO_NAME_UPPER ,PARTNER_STATUS ,COMPANYID ,SETID FROM PS_RD_PTNR_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | 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. |
| 2 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 3 | BO_NAME_SRCH | Character(50) | VARCHAR2(50) NOT NULL | BO_NAME_SRCH |
| 4 | PARTNER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Parnter Status
1=Active 2=Approved 3=Rejected 4=Pending Approval 5=Inactive |
| 5 | COMPANYID | Character(15) | VARCHAR2(15) NOT NULL | Company ID |
| 6 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Prompt Table:
SP_SETID_NONVW
|