DATE_SUBMITTEDDTTM_STAMPORIGINATOR_IDAM_DISP_FL_SVW(SQL View) |
Index Back |
|---|---|
Asset disposal fluid sum vwAsset disposal AF summary view - fluid |
| SELECT DISTINCT DATE_SUBMITTED , DTTM_STAMP , ORIGINATOR_ID , COUNT(*) , SUM(COST) , MAX(CURRENCY_CD) , SUM(QUANTITY) FROM PS_AM_RETIRE_APPR GROUP BY DATE_SUBMITTED , DTTM_STAMP , ORIGINATOR_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DATE_SUBMITTED |
Date(10) | DATE | Date Submitted |
| 2 | DTTM_STAMP |
DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |
| 3 | ORIGINATOR_ID |
Character(30) | VARCHAR2(30) NOT NULL | Originator |
| 4 | NUM_OF_ASSETS | Number(5,0) | INTEGER NOT NULL | Count Work Field |
| 5 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 7 | QUANTITY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Qty Interface |