Service Order
This table shows the table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tssoc200 | Service Orders |
This table shows the attribute mapping for the dimension:
| Attribute | Mapping |
|---|---|
| Acceptance Date | tssoc200.acdt |
| Actual Finish Time | tssoc200.aftm |
| Actual Start Time | tssoc200.astm |
| Actual Travel Start Time | tssoc200.tstm |
| Appointment | tssoc200.appo |
| Appointment Filter | tssoc200.appo |
| Appointment Sort | tssoc200.appo |
| Area | tssoc200.creg |
| Blocked | tssoc200.blyn |
| Blocked Filter | tssoc200.blyn |
| Blocked Sort | tssoc200.blyn |
| Cancel Date | tssoc200.cadt |
| Cancel Reason | tssoc200.cdis |
| Company | tssoc200_compnr |
| Conformance Reporting | tssoc200.cncd |
| Coverage Time | tssoc200.cvtm |
| Coverage Type | tssoc200.cctp |
| Earliest Start Time | tssoc200.estm |
| Installation Group | tssoc200.clst |
| Interrupted | tssoc200.ityn |
| Interrupted Filter | tssoc200.ityn |
| Interrupted Sort | tssoc200.ityn |
| Interruption Reason | tssoc200.crit |
| Invoicing by | tssoc200.inby |
| Invoicing by Filter | tssoc200.inby |
| Invoicing by Sort | tssoc200.inby |
| Latest Finish Time | tssoc200.lftm |
| Line of Business | tssoc200.cbrn |
| 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 |
| Order Accepted | tssoc200.orac |
| Order Accepted Filter | tssoc200.orac |
| Order Accepted Sort | tssoc200.orac |
| Order Date | tssoc200.ordt |
| Order Release Time | tssoc200.orrt |
| Order Status | tssoc200.osta |
| Order Status Filter | tssoc200.osta |
| Order Status Sort | tssoc200.osta |
| Overtime | tssoc200.otim |
| Overtime Filter | tssoc200.otim |
| Overtime Sort | tssoc200.otim |
| Planned Finish Time | tssoc200.pftm |
| Planned Start Time | tssoc200.pstm |
| Planned Travel Finish Time | tssoc200.ptft |
| Planned Travel Start Time | tssoc200.ptst |
| Pricing Contract | tssoc200.pcon |
| Pricing Contract Change | tssoc200.pcch |
| Pricing Contract Line | tssoc200.pcln |
| Project Activity | tssoc200.pcac |
| Project Element | tssoc200.cspa |
| Project Peg Origin | tssoc200.cpor |
| Project Peg Origin Filter | tssoc200.cpor |
| Project Peg Origin Sort | tssoc200.cpor |
| Project Pegged | tssoc200.ppeg |
| Project Pegged Filter | tssoc200.ppeg |
| Project Pegged Sort | tssoc200.ppeg |
| Quote | tssoc200.qtno |
| Quote Revision | tssoc200.revn |
| Reaction Time | tssoc200.ract |
| Sales Type | tssoc200.styp |
| Service Order | tssoc200.orno |
| Service Order Quote | tssoc200.csqu |
| Service Type | tssoc200.cstp |
| Total Invoice | tssoc200.tinv |
| Total Invoice Filter | tssoc200.tinv |
| Total Invoice Sort | tssoc200.tinv |
| Unknown | 1 for null records, else 0 |
| Warranty Type | tssoc200.wrtp |
| Warranty Type Filter | tssoc200.wrtp |
| Warranty Type Sort | tssoc200.wrtp |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |