SCP_PUB_GRP_VW(SQL View) |
Index Back |
|---|---|
Public Group View |
| SELECT LF.BUSINESS_UNIT ,LF.AUC_ID ,LF.AUC_ROUND ,LF.AUC_VERSION ,LF.LINE_NBR ,LF.BID_FACTOR_NBR ,LF.GRP_LINE_NBR ,LF.GRP_LN_SEQ_NBR ,LF.GRP_LN_BF_NBR ,LF.SETID ,LF.BID_FACTOR_CD ,LF.BID_FACTOR_TYPE ,LF.SEQ_NBR ,LF.MIN_QTY ,LF.WEIGHTING ,LF.AUC_GRP_QTY ,LF.UNIT_OF_MEASURE ,LF.QTY_AUC ,LF.AUC_PRICE ,LF.DESCR254_MIXED ,LF.ITM_ID_VNDR FROM PS_RESP_GRPLNSA_VW LF |
| # | 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 | BID_FACTOR_NBR |
Number(10,0) | DECIMAL(10) NOT NULL | Bid Factor Number |
| 7 | GRP_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Group Line Number |
| 8 | GRP_LN_SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Line Display Seq# |
| 9 | GRP_LN_BF_NBR | Number(10,0) | DECIMAL(10) NOT NULL | Bid Factor Number for group line member |
| 10 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 11 | BID_FACTOR_CD | Character(18) | VARCHAR2(18) NOT NULL |
Bid Factor Code
Prompt Table: BID_FACTOR_VW |
| 12 | BID_FACTOR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Bid Factor Type for the Auction Services product. Will be used to describe units of measurements for the different BID_FACTOR_CD's.
A=Attachment C=Monetary D=Date L=List N=Numeric S=Separator T=Text Y=Yes/No |
| 13 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 14 | MIN_QTY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Minimum Quantity |
| 15 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 16 | AUC_GRP_QTY | Number(16,4) | DECIMAL(15,4) NOT NULL |
Group Qty
Default Value: 1 |
| 17 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDIT_UOM |
| 18 | QTY_AUC | Number(16,4) | DECIMAL(15,4) NOT NULL | Event Quantity |
| 19 | AUC_PRICE | Number(17,5) | DECIMAL(16,5) NOT NULL | Event Start price |
| 20 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 21 | ITM_ID_VNDR | Character(50) | VARCHAR2(50) NOT NULL | Vendor Item ID |