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