OPRIDTR_LIQ_ACR_C_VW(SQL View) |
Index Back |
|---|
| SELECT oprid ,SUM(POS_IMPCT_ORIG) ,value_dt ,setid ,bnk_acctgrp_id ,CASE WHEN SUM(POS_IMPCT_ORIG) < 0 THEN 10 ELSE 1 END ,' ' FROM PS_TR_LIQ_ACGRP_VW GROUP BY oprid ,value_dt ,setid ,bnk_acctgrp_id |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amount |
| 3 | VALUE_DT | Date(10) | DATE | Equivalent to a deal transaction's settlement date. |
| 4 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | BNK_ACCTGRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Account Group ID |
| 6 | TR_CHART_COLOR | Number(3,0) | SMALLINT NOT NULL | Chart Color |
| 7 | DESCR100A | Character(100) | VARCHAR2(100) NOT NULL | Description |