SFTWR_TITLEIT_SFTWR_PNDSMV(SQL View) |
Index Back |
|---|
| SELECT SFTWR_TITLE , IT_INVENTORY_QTY , IT_INSTALLED_QTY + IT_DEVICE_QTY , IT_DEVICE_QTY , IT_INSTALLED_QTY + IT_DEVICE_QTY - IT_INVENTORY_QTY , DTTM_STAMP , PROCESS_INSTANCE FROM %Table(IT_SFTWR_PNDSUM) WHERE IT_INSTALLED_QTY <> 0 OR IT_INVENTORY_QTY <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFTWR_TITLE |
Character(50) | VARCHAR2(50) NOT NULL | Software Title |
| 2 | IT_INVENTORY_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Inventory |
| 3 | IT_INSTALLED_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Installed |
| 4 | IT_DEVICE_QTY | Number(10,0) | DECIMAL(10) NOT NULL | Installed |
| 5 | PENDING_QUANTITY | Number(10,0) | DECIMAL(10) NOT NULL | Pending Requisitions |
| 6 | 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. |
| 7 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |