SHEET_IDEXPENSE_TYPETRANS_DTEX_SHT_ANLY_VW4(SQL View) |
Index Back |
|---|---|
EX Expense By DayThis view is used for EX Expense By Day |
| SELECT SHEET_ID , EXPENSE_TYPE , TRANS_DT , SUM(MONETARY_AMOUNT) , CURRENCY_CD FROM %Table(EX_SHEET_LINE) GROUP BY SHEET_ID , EXPENSE_TYPE , TRANS_DT , CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SHEET_ID |
Character(10) | VARCHAR2(10) NOT NULL | Report ID |
| 2 | EXPENSE_TYPE |
Character(7) | VARCHAR2(7) NOT NULL | Expense Type |
| 3 | TRANS_DT |
Date(10) | DATE | Transaction Date |
| 4 | 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. |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |