SETIDPrompt Table: SP_SETID_NONVW
CNTRCT_IDPrompt Table: SCON_HDR
SUPPORT_TEAM_MBRPrompt Table: MEMBER_ACTIV_VW
SCON_TEAM_VW(SQL View) |
Index Back |
|---|---|
Sales Contract Team View |
| select a.setid, a.cntrct_id, a.support_team_mbr from PS_SCON_HDR_TEAM a |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Prompt Table: SP_SETID_NONVW |
| 2 | CNTRCT_ID |
Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table: SCON_HDR |
| 3 | SUPPORT_TEAM_MBR |
Character(8) | VARCHAR2(8) NOT NULL |
Team Member
Prompt Table: MEMBER_ACTIV_VW |