IT_SFTWR_PNDSUM(SQL Table) |
Index Back |
---|
# | 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 | 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. |
6 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |