AUC_SWL_INV_VW(SQL View) |
Index Back |
|---|
| SELECT business_unit , bidder_id ,COUNT(*) ,SUM(auc_ext_price) ,'' FROM PS_AUC_IN_BI_VW GROUP BY business_unit , bidder_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | BIDDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Bidder ID |
| 3 | COUNT1 | Number(10,0) | DECIMAL(10) NOT NULL | Counter |
| 4 | PRICED_RATE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Rate used by Pricing engine to calculate amount on transactions for billing. Rate is quantity related. |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |