BO_ID_PARTNER1=Active
2=Approved
3=Rejected
4=Pending Approval
5=Inactive
RD_PTNR_VW2(SQL View) |
Index Back |
|---|---|
Partner ViewPartner View to prompt for BO_ID_PARTNER |
| SELECT A.BO_ID , A.SETID , B.BO_NAME , B.BO_NAME_UPPER , B.BO_NAME_AC , A.DUNS_NUMBER , C.PARTNER_STATUS , A.COMPANYID , A.SYNCID , D.PARTNER_PGM_ID , E.PARTNER_PGM_NAME FROM PS_RD_COMPANY A , PS_BO_NAME B , PS_RD_PARTNER C , PS_RD_PR_PGM D , PS_RD_PR_PROG E WHERE A.BO_ID = B.BO_ID AND A.BO_ID = C.BO_ID AND A.BO_ID = D.BO_ID AND B.PRIMARY_IND = 'Y' AND D.PRIMARY_IND = 'Y' AND D.PARTNER_PGM_ID = E.PARTNER_PGM_ID AND D.SETID = E.SETID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_PARTNER |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Partner Company. |
| 2 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 3 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 4 | BO_NAME_UPPER | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | DUNS_NUMBER | Character(20) | VARCHAR2(20) NOT NULL | DUNS Number |
| 7 | PARTNER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Parnter Status
1=Active 2=Approved 3=Rejected 4=Pending Approval 5=Inactive |
| 8 | COMPANYID | Character(15) | VARCHAR2(15) NOT NULL | Company ID |
| 9 | 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. |
| 10 | PARTNER_PGM_ID | Character(15) | VARCHAR2(15) NOT NULL | Partner Program ID |
| 11 | PARTNER_PGM_NAME | Character(50) | VARCHAR2(50) NOT NULL | Partner Program name |