BUSINESS_UNITAUC_IDAUC_ROUNDAUC_VERSIONLINE_NBRGRP_LINE_NBRBID_FACTOR_NBRRESP_PXY_BSP_VW(SQL View) |
Index Back |
|---|
| SELECT BUSINESS_UNIT , AUC_ID , AUC_ROUND , AUC_VERSION , LINE_NBR , GRP_LINE_NBR , BID_FACTOR_NBR , BID_FACTOR_CD , MAX(PXY_NEW_PRICE) AS MAX_RESP_QTY , MIN(PXY_NEW_PRICE) AS MIN_RESP_QTY , MAX(PXY_BEST_PRICE) AS PXY_MAX_PRICE , MIN(PXY_BEST_PRICE) AS PXY_MIN_PRICE FROM PS_RESP_LN_PROXY WHERE PXY_STATUS = 'A' GROUP BY BUSINESS_UNIT , AUC_ID , AUC_ROUND , AUC_VERSION,LINE_NBR ,GRP_LINE_NBR, BID_FACTOR_NBR , BID_FACTOR_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | AUC_ID |
Character(10) | VARCHAR2(10) NOT NULL | Event ID |
| 3 | AUC_ROUND |
Number(5,0) | INTEGER NOT NULL | Event Round |
| 4 | AUC_VERSION |
Number(5,0) | INTEGER NOT NULL | Event Version |
| 5 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | GRP_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Group Line Number |
| 7 | BID_FACTOR_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Bid Factor Number |
| 8 | BID_FACTOR_CD | Character(18) | VARCHAR2(18) NOT NULL | Bid Factor Code |
| 9 | MAX_RESP_QTY | Number(19,6) | DECIMAL(18,6) NOT NULL | Highest Bid |
| 10 | MIN_RESP_QTY | Number(19,6) | DECIMAL(18,6) NOT NULL | Lowest Bid |
| 11 | PXY_MAX_PRICE | Number(19,6) | DECIMAL(18,6) NOT NULL | Bid Response Price |
| 12 | PXY_MIN_PRICE | Number(19,6) | DECIMAL(18,6) NOT NULL | Bid Response Price |