SFTWR_TITLEBUSINESS_UNITASSET_IDIT_SFTWR_ASTQTY(SQL View) |
Index Back |
|---|
| SELECT SKU.SFTWR_TITLE , AST.BUSINESS_UNIT ,AST.ASSET_ID ,%Truncate(%DecMult(AST.QUANTITY,SKU.IT_INVENTORY_QTY ), 0) FROM %Table(IT_SFTWR_ASSET) AST , %Table(IT_SFTWR_SKU) SKU WHERE AST.SKU = SKU.SKU |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SFTWR_TITLE |
Character(50) | VARCHAR2(50) NOT NULL | Software Title |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 4 | QTY_ASSIGNED | Number(11,0) | DECIMAL(11) NOT NULL | Resources Assigned |