BUSINESS_UNITAUC_IDAUC_ROUNDAUC_VERSIONPrompt Table:
CURRENCY_CD_TBL
Set Control Field: BUSINESS_UNIT
AUC_APPR_HD_VW1(SQL View) |
Index Back |
|---|---|
Fluid Approval View |
| SELECT H.BUSINESS_UNIT ,H.AUC_ID ,H.AUC_ROUND ,H.AUC_VERSION ,H.CURRENCY_CD ,SUM(L.AUC_EXT_PRICE) FROM PS_AUC_HDR H ,PS_AUC_LINE L WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.AUC_ID = L.AUC_ID AND H.AUC_ROUND = L.AUC_ROUND AND H.AUC_VERSION = L.AUC_VERSION GROUP BY H.BUSINESS_UNIT, H.AUC_ID, H.AUC_ROUND, H.AUC_VERSION,H.CURRENCY_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 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 6 | AUC_EXT_PRICE | Number(18,5) | DECIMAL(17,5) NOT NULL | Auction Extended Price |