Supplier Claim
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tscmm200 | Supplier Claims |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Approval Date | tscmm200.apdt |
| Approval Decision | tscmm200.apdc |
| Cancel Date | tscmm200.cndt |
| Claim Origin | tscmm200.corg |
| Claim Origin Filter | tscmm200.corg |
| Claim Origin Sort | tscmm200.corg |
| Company | tscmm200.compnr |
| Coverage Date | tscmm200.cvtm |
| Created By | tscmm200.user |
| Creation Date | tscmm200.crtm |
| Currency | tscmm200.ccur |
| Drillback to LN | ‘LN’ |
| Failure Date | tscmm200.fldt |
| First Invoice Reference | tscmm200.refa |
| Installation Group | tscmm200.clst |
| Internal Contract | tscmm200.irep |
| Item | tscmm200.item |
| Latest Finish Time | tscmm200.lftm |
| Line of Business | tscmm200.cbrn |
| Planned Receipt Time | tscmm200.prtm |
| Project | tscmm200.cprj |
| Project Activity | tscmm200.pcac |
| Project Element | tscmm200.cspa |
| Purchase Reference System | tscmm200.oosy |
| Purchase Reference System Filter | tscmm200.oosy |
| Purchase Reference System Sort | tscmm200.oosy |
| Rejection Date | tscmm200.rjdt |
| Sales Type | tscmm200.styp |
| Second Invoice Reference | tscmm200.refb |
| Serial Number | tscmm200.sern |
| Service Office | tscmm200.cwoc |
| Service Type | tscmm200.cstp |
| Status | tscmm200.stat |
| Status Filter | tscmm200.stat |
| Status Sort | tscmm200.stat |
| Supplier Claim | tscmm200.scno |
| Supplier Claim Desc | tscmm200.desc |
| Supplier Claim ID Desc | tscmm200.scno + tscmm200.desc |
| Supplier Order Number | tscmm200.sorn |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |