RUN_DTTMOPRIDSP_BID_FLAGDefault Value: NEXT
Default Value: 1
A=Approved
C=Complete
D=Denied
F=Filled
O=Open
P=Pending
R=On Hold
S=Sourced
X=Canceled
N=No
Y=Yes
A=All
N=Not Routed
R=Routed
SPF_BID_AET(SQL Table) |
Index Back |
|---|---|
bid temp tabletemp table used for the incoming and outgoing bid pages |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_DT | Date(10) | DATE | Run Date |
| 2 | RUN_DTTM |
DateTime(26) | TIMESTAMP | Run Date and Time |
| 3 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 4 | SP_BID_FLAG |
Character(2) | VARCHAR2(2) NOT NULL | flag field used for the bidding AE |
| 5 | JOB_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Job Instance |
| 6 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 7 | PERSON_ID | Character(15) | VARCHAR2(15) NOT NULL | Person ID |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 9 | SP_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Request ID
Default Value: NEXT |
| 10 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 11 | BID_ID | Number(10,0) | DECIMAL(10) NOT NULL |
Bid Id
Default Value: 1 |
| 12 | LINE_ROW | Number(5,0) | INTEGER NOT NULL | Line Row |
| 13 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 14 | BID_ACTION_TYPE | Character(5) | VARCHAR2(5) NOT NULL | Bid Action Type |
| 15 | SP_REQ_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Requisition Status for Service Procurement
A=Approved C=Complete D=Denied F=Filled O=Open P=Pending R=On Hold S=Sourced X=Canceled |
| 16 | SRVC_PROVIDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider |
| 17 | FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Flag
N=No Y=Yes |
| 18 | SP_MSP_FLAG | Character(1) | VARCHAR2(1) NOT NULL | MSP installation flag is used on the INSTALLATION_SP table to determine if this is an MSP installation of sPro |
| 19 | SP_DATE_FROM | Date(10) | DATE | Date From |
| 20 | SP_DATE_THROUGH | Date(10) | DATE | Through Date |
| 21 | SP_VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Id field for the search pages |
| 22 | RECRUITER | Character(15) | VARCHAR2(15) NOT NULL | Service Coordinator |
| 23 | TEAM_ID | Character(15) | VARCHAR2(15) NOT NULL | Team ID |
| 24 | CONTACT | Character(15) | VARCHAR2(15) NOT NULL | Provider Contact |
| 25 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 26 | WHERE_CLAUSE_LONG | Long Character(4000) | CLOB | Where Clause |
| 27 | SP_BID_T_SEL | Character(1) | VARCHAR2(1) NOT NULL |
Bid Type
A=All N=Not Routed R=Routed |