Measures
This table shows the service depot repair item line fact measures:
| Measure | Mapping |
|---|---|
| Average Delivery Days | Actual delivery date - Actual receive date / Service Depot Repair Item Line Count where Line Procedure= ‘part maintenance’. |
| Delivered Quantity | tsmsc110.dqty |
| Delivery Days | Actual delivery date - Actual receive date where Line Procedure = ‘part maintenance’. |
| Estimated Sales Price | tsmsc110.espr |
| Part Delivered Loan Lines | Service Depot Repair Item Line Count when Line Procedure = 'tsmsc.lpro.part.loan'. |
| Part Delivery Lines | Service Depot Repair Item Line Count when Line Procedure = 'tsmsc.lpro.part.delv'. |
| Part Maintenance Depot Repair Item Line Count | Count of part maintenance lines tsmsc110.lpro= 'tsmsc.lpro.part.main'. |
| Part Maintenance Lines | Service Depot Repair Item Line Count when Line Procedure ='tsmsc.lpro.part.main'. |
| Part Receipt Lines | Service Depot Repair Item Line Count when Line Procedure = 'tsmsc.lpro.part.recp'. |
| Part Received Loan Lines | Service Depot Repair Item Line Count when Line Procedure = 'tsmsc.lpro.part.loan'. |
| Quantity | tsmsc110.quan |
| Received Quantity | tsmsc110.rqty |
| Sales Price | tsmsc110.pris |
| Service Depot Repair Count Distinct | Distinct count of Service Depot Repair |
| Service Depot Repair Item Line Count | Always 1 |
| deleted | 1 if deleted in LN, else 0 |