RESP_LN_PCMP_VW(SQL View) |
Index Back |
|---|---|
Response Line FactorsResponse Line Factors |
| SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.LINE_NBR , A.BID_FACTOR_NBR , A.AUC_PRC_COMP_NBR , A.AUC_PRICE_COMP , A.MIN_QTY , A.UNIT_OF_MEASURE , A.WEIGHTING , B.SETID , B.BID_FACTOR_CD , B.BID_FACTOR_TYPE , B.SEQ_NBR , B.UNIT_OF_MEASURE , B.WEIGHTING , B.PRICE_FLG , B.AUC_MULTI_SEL_FLG , C.QTY_AUC , B.COMMENTS_2000 FROM PS_AUC_LN_FCTR_PRC A ,PS_AUC_LN_BID_FCTR B ,PS_AUC_LINE C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.AUC_ID = B.AUC_ID AND A.AUC_ROUND = B.AUC_ROUND AND A.AUC_VERSION = B.AUC_VERSION AND A.LINE_NBR = B.LINE_NBR AND A.BID_FACTOR_NBR = B.BID_FACTOR_NBR AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.AUC_ID = C.AUC_ID AND A.AUC_ROUND = C.AUC_ROUND AND A.AUC_VERSION = C.AUC_VERSION AND A.LINE_NBR = C.LINE_NBR AND B.PRICE_FLG = 'Y' AND GRP_LINE_NBR = 0 |
| # | 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 | AUC_PRC_COMP_NBR |
Number(5,0) | INTEGER NOT NULL | Sourcing Price Components |
| 8 | AUC_PRICE_COMP | Character(40) | VARCHAR2(40) NOT NULL | Sourcing Price Components |
| 9 | MIN_QTY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Minimum Quantity |
| 10 | 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: UNITS_TBL |
| 11 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 12 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 13 | BID_FACTOR_CD | Character(18) | VARCHAR2(18) NOT NULL |
Bid Factor Code
Prompt Table: BID_FACTOR_VW |
| 14 | 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 |
| 15 | SEQ_NBR | Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 16 | BID_FCTR_UOM | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 17 | BF_PRICE_WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilization totals |
| 18 | PRICE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Price Flag
N=No Y=Yes Y/N Table Edit Default Value: N |
| 19 | AUC_MULTI_SEL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Multiple Selections
Y/N Table Edit Default Value: N |
| 20 | QTY_AUC | Number(16,4) | DECIMAL(15,4) NOT NULL | Event Quantity |
| 21 | COMMENTS_2000 | Long Character | CLOB | Comment Text |