Measures
This table shows the supplier claim line measures:
| Measure | Mapping |
|---|---|
| Approved Amount | tscmm210.acam |
| Approved Quantity | tscmm210.qaac |
| Average Wait Time Days | Average of Wait time (approved or rejected date – creation date) in days |
| Claimed Amount | tscmm210.clam |
| Claimed Quantity | tscmm210.qccl |
| Claimed and Approved Amount Ratio | Claimed Amount / (Claimed amount + approved amount) |
| Claims Linked to a Reference | Supplier Claim Count Distinct when Supplier Claim Line.Purchase Reference System <> 'tscmm.sup.oosy.not.applicable' |
| Claims Linked to a Reference Ratio | Supplier Claim Count Distinct when Supplier Claim Line.Purchase Reference System <> 'tscmm.sup.oosy.not.applicable'/ Supplier Claim Count Distinct when Supplier Claim Line.Purchase Reference System <> 'tscmm.sup.oosy.not.applicable' |
| Claims not Linked to a Reference | Supplier Claim Count Distinct when Supplier Claim Line.Purchase Reference System= 'tscmm.sup.oosy.not.applicable' |
| Claims not linked to a Reference Ratio | Supplier Claim Count Distinct when Supplier Claim Line.Purchase Reference System= 'tscmm.sup.oosy.not.applicable'/ Supplier Claim Count Distinct |
| Percentage Approved Amount | Approved Amount / Claimed Amount *100 |
| Percentage Claims Linked to a Reference | Claims Linked to a Reference/ Supplier Claim Count Distinct *100 |
| Percentage Claims not Linked to a Reference | Claims Not Linked to a Reference/ Supplier Claim Count Distinct *100 |
| Supplier Claim Amount Linked to a Reference | tscmm210.clam when Supplier Claim Line.Purchase Reference System<> 'tscmm.sup.oosy.not.applicable' |
| Supplier Claim Amount not Linked to a Reference | tscmm210.clam when Supplier Claim Line.Purchase Reference System= 'tscmm.sup.oosy.not.applicable' |
| Supplier Claim Count Distinct | Distinct count of Supplier Claim header |
| Supplier Claim Line Count | Count of Supplier Claim Line |
| Supplier Claim Line Linked to a Reference Count | Count of claim lines when Supplier Claim Line.Purchase Reference System<> 'tscmm.sup.oosy.not.applicable' |
| Supplier Claim Line Previous Year Count | Count of claim lines for the previous year when Supplier Claim Line.Purchase Reference System<> 'tscmm.sup.oosy.not.applicable' |
| Supplier Claim Line not Linked to a Reference Count | Count of claim lines when Supplier Claim Line.Purchase Reference System= 'tscmm.sup.oosy.not.applicable' |
| Supplier Claim Lines Claim Method Ratio | Count of Supplier Claim line/ Count of Supplier Claim line where Claim Method<>’*’ |
| Supplier Claim Lines Tagged to Ratio | Count of Supplier Claim line/ Count of Supplier Claim line where Tagged To<>’*’ |
| Supplier Claim Quantity Linked to a Reference | Count of claim lines when Supplier Claim Line.Purchase Reference System<> 'tscmm.sup.oosy.not.applicable' |
| Supplier Claim Quantity not Linked to a Reference | Tscmm210.qccl when Supplier Claim Line.Purchase Reference System<> 'tscmm.sup.oosy.not.applicable' |
| Supplier Reimburse Costs Claim Line Count | Count of Supplier Claim line where Claim Method = ‘tscmm.clmt.costs’ |
| Supplier Reimburse Materials Claim Line Count | Count of Supplier Claim line where Claim Method = ‘tscmm.clmt.material’ |
| Wait Time Days | If Line Status = 'rejected', Days difference between Rejection Date, Creation
Date If Line Status = 'approved', Days difference between Approval Date, Creation Date |
| deleted | 1 if deleted in LN, else 0 |