EX_SHT_ANLY_VW5(SQL View) |
Index Back |
---|
SELECT SHEET_ID , trans_dt , SUM(monetary_amount) FROM %Table(EX_SHT_ANLY_VW4) GROUP BY sheet_id , trans_dt |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Report ID |
2 | TRANS_DT | Date(10) | DATE | Transaction Date |
3 | MONETARY_AMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Specifies the monetary amount of a debit or credit in the business unit base currency. Debit entries are positive and credit entries are negative. This amount is only zero if associated with a statistical account. |