Service Reason

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

Table	Description
tcmcs005	Reasons

This table shows the attribute mapping for the dimension:

Attribute	Mapping
Approval	tcmcs005.appr
Approval Filter	tcmcs005.appr
Approval Sort	tcmcs005.appr
Billable	tcmcs005.bilb
Billable Filter	tcmcs005.bilb
Billable Sort	tcmcs005.bilb
Company	tcmcs005.compnr
Direct Pay Indicator	tcmcs005.drpi
Direct Pay Indicator Filter	tcmcs005.drpi
Direct Pay Indicator Sort	tcmcs005.drpi
Effective Date	tcmcs005.efdt
Excess Transportation Reason	tcmcs005.etrt
Excess Transportation Reason Filter	tcmcs005.etrt
Excess Transportation Reason Sort	tcmcs005.etrt
Expiry Date	tcmcs005.exdt
Service Reason	tcmcs005.cdis
Service Reason Desc	tcmcs005.dsca
Service Reason ID Desc	tcmcs005.cdis + tcmcs005.dsca
Service Reason Type	tcmcs005.rstp
Service Reason Type Filter	tcmcs005.rstp
Service Reason Type Sort	tcmcs005.rstp
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields