Work Order
This table shows the table from which fields are retrieved for the dimension:
Table | Description |
---|---|
tswcs200 | Work Order |
This table shows the attribute mapping for the dimension:
Attribute | Mapping |
---|---|
Actual Finish Date | tswcs200.aftm |
Actual Item Receipt Date | tswcs200.artm |
Actual Problem | tswcs200.cprl |
Actual Solution | tswcs200.cstn |
Actual Start Date | tswcs200.astm |
Cancel Date | tswcs200.cadt |
Company | tswcs200.compnr |
Conformance Reporting | tswcs200.cncd |
Coverage Type | tswcs200.cctp |
Drillback to LN | “LN” |
Earliest Start Date | tswcs200.estm |
Initiating Work Order | tswcs200.iorn |
Installation Group | tswcs200.clst |
Interruption Reason | tswcs200.crit |
Item Revision | tswcs200.revi |
Latest Finish Date | tswcs200.lftm |
Order Origin | tswcs200.orig |
Order Origin Filter | tswcs200.orig |
Order Origin Sort | tswcs200.orig |
Planned Finish Date | tswcs200.pftm |
Planned Start Date | tswcs200.pstm |
Project Activity | tswcs200.pcac |
Project Element | tswcs200.cspa |
Project Peg Origin | tswcs200.cpor |
Project Peg Origin Filter | tswcs200.cpor |
Project Peg Origin Sort | tswcs200.cpor |
Service Type | tswcs200.cstp |
Set Number | tswcs200.snum |
Top Work Order | tswcs200.torn |
Transfer Actual Delivery Date | tswcs200.adtm |
Transfer Planned Delivery Date | tswcs200.pdtm |
Unknown | 1 for null records, else 0 |
Warehouse Delivery Date | tswcs200.wdtm |
Warehouse Receipt Date | tswcs200.wrtm |
Work Order | tswcs200.orno |
Work Order Status | tswcs200.stat |
Work Order Status Filter | tswcs200.stat_kw |
Work Order Status Sort | tswcs200.stat |
deleted | 1 if deleted in LN, else 0 |
Customer Defined Fields | Standard list of fields |