NAME1B=Bidder
C=Customer
P=Public
U=Uploaded
V=Supplier
CS_BIDPRMPT_VW2(SQL View) |
Index Back |
|---|---|
Bidder PromptsBidder prompt view which collects bidder id/name from various sources for use on Contract Workbench |
| SELECT NAME1 ,BIDDER_ID , BIDDER_TYPE FROM PS_CS_BID_PRMPT_VW |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | NAME1 |
Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 2 | BIDDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 3 | BIDDER_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Bidder C=Customer P=Public U=Uploaded V=Supplier |