BUSINESS_UNITAUC_IDAUC_ROUNDAUC_VERSIONLINE_NBRG=Group Line
L=Line Item
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
GRP_LINE_NBRAUC_SSO_LNGR_CT(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.AUC_ID , A.AUC_ROUND , A.AUC_VERSION , A.LINE_NBR , A.AUC_GROUP_ID , A.AUC_LINE_TYPE , A.DESCR254_MIXED , A.WEIGHTING , A.QTY_AUC , A.UNIT_OF_MEASURE , COUNT(*) FROM PS_AUC_LINE A , PS_AUC_LINE_GROUP B 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.AUC_LINE_TYPE = 'G' GROUP BY A.BUSINESS_UNIT, A.AUC_ID, A.AUC_ROUND, A.AUC_VERSION, A.LINE_NBR, A.AUC_GROUP_ID , A.AUC_LINE_TYPE, A.DESCR254_MIXED, A.WEIGHTING, A.QTY_AUC, A.UNIT_OF_MEASURE |
| # | 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 | AUC_GROUP_ID | Character(18) | VARCHAR2(18) NOT NULL | GroupID |
| 7 | AUC_LINE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Event Line Type
G=Group Line L=Line Item |
| 8 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |
| 9 | WEIGHTING | Signed Number(10,5) | DECIMAL(8,5) NOT NULL | Used for applying a weighting to totals. e.g. Limit Utilisation totals |
| 10 | QTY_AUC | Number(16,4) | DECIMAL(15,4) NOT NULL | Event Quantity |
| 11 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage |
| 12 | GRP_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Group Line Number |