TR_LIQ_BNK_C_VW(SQL View) |
Index Back |
---|
SELECT OPRID ,SUM(POS_IMPCT_ORIG) ,value_dt ,BANK_CD ,CASE WHEN SUM(POS_IMPCT_ORIG) < 0 THEN 10 ELSE 1 END ,' ' FROM PS_TR_LIQ_BNKPC_VW GROUP BY OPRID ,value_dt ,BANK_CD |
# | 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 | BANK_CD | Character(5) | VARCHAR2(5) NOT NULL | Bank Code |
5 | TR_CHART_COLOR | Number(3,0) | SMALLINT NOT NULL | Chart Color |
6 | DESCR100A | Character(100) | VARCHAR2(100) NOT NULL | Description |