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 |