IT_SFTWR_SKU(SQL Table) |
Index Back |
---|---|
Software Title/ SKU Associaton |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SKU | Character(50) | VARCHAR2(50) NOT NULL |
Stock Keeping Unit
Prompt Table: IT_SKU_ITEM_ALL |
2 | SFTWR_TITLE | Character(50) | VARCHAR2(50) NOT NULL |
Software Title
Prompt Table: IT_SFTWR |
3 | IT_INVENTORY_QTY | Number(10,0) | DECIMAL(10) NOT NULL |
Inventory
Default Value: 1 |
4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |