BUSINESS_UNITASSET_IDCURRENCY_CDASSETMAN_TTL_VW(SQL View) |
Index Back |
|---|---|
Asset Maintenance Cost TotalsView created to calculate the Individual Totals of different Costs incurred for an Asset Maintenance. |
| SELECT BUSINESS_UNIT ,ASSET_ID ,CURRENCY_CD ,SUM(MATERIALS_COST) MATERIALS_COST ,SUM(LABOR_COST) LABOR_COST , SUM(PURCH_COST) PURCH_COST , SUM(TOOLS_COST) TOOLS_COST , SUM(OTHER_COST) OTHER_COST , SUM(MATERIALS_COST+LABOR_COST+PURCH_COST+TOOLS_COST+OTHER_COST) FROM PS_ASSET_MAINT GROUP BY BUSINESS_UNIT ,ASSET_ID , CURRENCY_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSET_ID |
Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 3 | CURRENCY_CD |
Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 4 | MATERIALS_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Material Cost |
| 5 | LABOR_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Labor Cost |
| 6 | PURCH_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Purchase Cost |
| 7 | TOOLS_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Tools Cost |
| 8 | OTHER_COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Other Cost |
| 9 | ACTL_COST_TTL | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Actual Cost |