Service Order Activity
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tssoc210 | Service Order Activities |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Activity Line Number | tssoc210.acln |
| Activity Status | tssoc210.asta |
| Activity Status Filter | tssoc210.asta |
| Activity Status Sort | tssoc210.asta |
| Actual Finish Time | tssoc210.aftm |
| Actual Problem | tssoc210.cprl |
| Actual Problem Desc | tsclm335.desc |
| Actual Solution | tssoc210.cstn |
| Actual Solution Desc | tsclm335.desc |
| Actual Start Time | tssoc210.astm |
| Appointment | tssoc210.appo |
| Appointment Filter | tssoc210.appo |
| Appointment Sort | tssoc210.appo |
| Cancel Date | tssoc210.cadt |
| Company | tssoc210_compnr |
| Conformance Reporting | tssoc210.cncd |
| Coverage Time | tssoc210.cvtm |
| Coverage Type | tssoc210.cctp |
| Customer Priority | tssoc210.cupr |
| Derived from Planned Activity | tssoc210.orac |
| Derived from Planned Activity Sequence Number | tssoc210.oras |
| Earliest Start Time | tssoc210.estm |
| Expected Problem | Expected Problem from Call (tssoc210.ccll). If Call is empty, Expected Problem from Service Resolution - Probability Analysis (tsclm350.expr). |
| Expected Problem Desc | tsclm335.desc |
| Expected Solution | Expected Solution from Call (tssoc210.ccll). If Call is empty, Expected Solution from Service Resolution - Probability Analysis (tsclm350.expr). |
| Expected Solution Desc | tsclm335.desc |
| Field Change Order | tssoc210.fcon |
| Installation Group | tssoc210.clst |
| Invoicing by | tssoc210.inby |
| Invoicing by Filter | tssoc210.inby |
| Invoicing by Sort | tssoc210.inby |
| Item Subcontracting | tssoc210.sbit |
| Latest Finish Time | tssoc210.lftm |
| Main Counter | tssoc210.come |
| Measurement Type | tssoc210.cmea |
| On Time Finish Indicator | 1 if Actual Finish Time <= Planned Finish Time, else 0 |
| On Time Start Indicator | 1 if Actual Start Time <= Planned Start Time, else 0 |
| Original Planned Finish Time | tssoc210.oftm |
| Original Planned Start Time | tssoc210.ostm |
| Planned Finish Time | tssoc210.pftm |
| Planned Start Time | tssoc210.pstm |
| Planned Travel Finish Time | tssoc210.ptft |
| Planned Travel Start Time | tssoc210.ptst |
| Pricing Contract | tssoc210.pcon |
| Pricing Contract Change | tssoc210.pcch |
| Pricing Contract Line | tssoc210.pcln |
| Problem Priority | tssoc210.prpr |
| Project Activity | tssoc210.pcac |
| Project Element | tssoc210.cspa |
| Project Peg Origin | tssoc210.cpor |
| Project Peg Origin Filter | tssoc210.cpor |
| Project Peg Origin Sort | tssoc210.cpor |
| Reference Activity | tssoc210.crac |
| Rental | tssoc210.rnyn |
| Rental Filter | tssoc210.rnyn |
| Rental Sort | tssoc210.rnyn |
| Reported Problem | Reported Problem from Call (tssoc210.ccll). If Call is empty, Reported Problem from Service Resolution - Probability Analysis (tsclm350.expr). |
| Reported Problem Desc | tsclm335.desc |
| Response Type | tssoc210.crtc |
| Serial Number | tssoc210.sern |
| Serial Status | tssoc210.ssta |
| Serial Status Filter | tssoc210.ssta |
| Serial Status Sort | tssoc210.ssta |
| Serialized Item Priority | tssoc210.obpr |
| Service Area | tssoc210.csar |
| Service Order Activity Desc | tssoc210.desc |
| Service Order Activity ID Desc | tssoc210.acln + tssoc210.desc |
| Service Type | tssoc210.cstp |
| Ship Materials To | tssoc210.smto |
| Ship Materials To Filter | tssoc210.smto |
| Ship Materials To Sort | tssoc210.smto |
| Subcontracted | tssoc210.subc |
| Subcontracted Filter | tssoc210.subc |
| Subcontracted Sort | tssoc210.subc |
| Travel Distance Unit | tsmdm000.undi |
| Unexpected Problem Indicator | Expected Problem <> Actual Problem |
| Unexpected Solution Indicator | Expected Solution <> Actual Solution |
| Unknown | 1 for null records, else 0 |
| Warranty Type | tssoc210.wrtp |
| Warranty Type Filter | tssoc210.wrtp |
| Warranty Type Sort | tssoc210.wrtp |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |