USERIDSETIDBID_CONTACT_TYPEB=Business
I=Individual
BID_FACTOR_NBRAUC_BF_LIST_LINEAUC_REG_FCT_LVW(SQL View) |
Index Back |
|---|---|
Profile Factor List |
| SELECT USERID , SETID , BID_CONTACT_TYPE , BID_FACTOR_NBR , AUC_BF_LIST_LINE , BID_LIST_ITEM FROM PS_AUC_REG_FCT_LST |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 3 | BID_CONTACT_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Bidder Type
B=Business I=Individual |
| 4 | BID_FACTOR_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Bid Factor Number |
| 5 | AUC_BF_LIST_LINE |
Signed Number(6,0) | DECIMAL(5) NOT NULL | List Line number |
| 6 | BID_LIST_ITEM | Character(60) | VARCHAR2(60) NOT NULL | List Item |