Service Depot Repair

This table shows the table from which fields are retrieved for the dimension:

Table	Description
tsmsc100	Maintenance Sales Order

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Acceptance Date	tsmsc100.acdt
Appointment	tsmsc100.apyn
Appointment Filter	tsmsc100.apyn
Appointment Sort	tsmsc100.apyn
Area	tsmsc100.creg
Blocked	tsmsc100.blyn
Blocked Filter	tsmsc100.blyn
Blocked Sort	tsmsc100.blyn
Company	tsmsc100.compnr
Conformance Reporting	tsmsc100.cncd
Customer Order	tsmsc100.corn
Customer Order Number	tsmsc100.cuno
DrillBack to LN	Column used for drillback setup
Finish Time	tsmsc100.fntm
First Reference	tsmsc100.refa
Invoicing by	tsmsc100.inby
Invoicing by Filter	tsmsc100.inby
Invoicing by Sort	tsmsc100.inby
Line of Business	tsmsc100.cbrn
Order Currency	tsmsc100.ccur
Order Date	tsmsc100.ordt
Order Status	tsmsc100.osta
Order Status Filter	tsmsc100.osta
Order Status Sort	tsmsc100.osta
Problem Solving Method	tsmsc100.pbsm
Problem Solving Method Filter	tsmsc100.pbsm
Problem Solving Method Sort	tsmsc100.pbsm
Sales Representative	tsmsc100.srep
Second Reference	tsmsc100.refb_1
Service Depot Repair	tsmsc100.cmso
Service Depot Repair Desc	tsmsc100.desc
Service Depot Repair ID Desc	tsmsc100.cmso + tsmsc100.desc
Service Type	tsmsc100.cstp
Start Time	tsmsc100.sttm
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields