SETIDDefault Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW
BIDDER_GRP_IDB=Bidder
V=Supplier
AUC_BIDSUPGID_V(SQL View) |
Index Back |
|---|---|
Bidder & Supplier GroupId View |
| SELECT SETID , BIDDER_GRP_ID , BIDDER_GRP_NAME , 'B' FROM PS_BIDDER_GROUP WHERE (BIDDER_GRP_TYPE = 'P' AND OPRID = %OperatorId) OR (BIDDER_GRP_TYPE = 'D' AND EXISTS ( SELECT 'X' FROM PS_OPR_DEF_TBL_SS WHERE OPRID = PS_BIDDER_GROUP.OPRID AND DEPTID = PS_BIDDER_GROUP.DEPTID)) UNION SELECT SETID , RFQ_VNDR_GROUP , DESCR , 'V' FROM PS_RFQ_VNDR_GROUP |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | BIDDER_GRP_ID |
Character(15) | VARCHAR2(15) NOT NULL | Bidder Group ID |
| 3 | BIDDER_GRP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Bidder Group Name |
| 4 | AUC_BID_SUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bidder Supplier Type
B=Bidder V=Supplier |