Describes the data models available in Texada Analytics for services report use.
Type
Conceptual
Audience
All
Products
Texada Analytics, SRM
In This Article
Business Context
Use Texada Analytics to monitor service data and spot trends in constituents of work orders.
Data Sources
The following points of data are all available in the Texada Analytics report.
|
Table |
Column |
Type |
|
Calendar |
Date |
DateTime |
|
Calendar |
Year Month |
String |
|
Calendar |
Month |
String |
|
Calendar |
Year Month Number |
Int64 |
|
Calendar |
Month Number |
Int64 |
|
Calendar |
Year |
Int64 |
|
Class |
Class Desc |
String |
|
Class |
Class Num |
String |
|
Group |
Group Desc |
String |
|
Group |
Group Num |
String |
|
Internal Use |
Internal Use |
String |
|
Invoice |
Invoice Num |
String |
|
Invoice |
Customer Num |
String |
|
Invoice |
Total Revenue |
Double |
|
Invoice |
Date |
DateTime |
|
Invoice Detail |
Invoice Num |
String |
|
Invoice Detail |
Product Num |
String |
|
Invoice Detail |
Extended |
Double |
|
Invoice Detail |
Orig Extended |
Double |
|
Invoice Detail |
Std Extended |
Double |
|
Invoice Detail |
Type |
String |
|
Invoice Detail |
Quantity |
Double |
|
Product |
Product Num |
String |
|
Product |
Group Desc |
String |
|
Product |
Class Desc |
String |
|
Product |
Group Num |
String |
Refresh Rate
Refresh begins at 12 a.m. EST.
Access and Security
Not applicable, no approval process
Out-of-the-Box Visualizations
The following visualizations are all available out-out-the-box.
|
Table |
Column |
Type |
|
Calendar |
Date |
DateTime |
|
Calendar |
Year Month |
String |
|
Calendar |
Month |
String |
|
Calendar |
Year Month Number |
Int64 |
|
Calendar |
Month Number |
Int64 |
|
Calendar |
Year |
Int64 |
|
Class |
Class Desc |
String |
|
Class |
Class Num |
String |
|
Group |
Group Desc |
String |
|
Group |
Group Num |
String |
|
Internal Use |
Internal Use |
String |
|
Invoice |
Invoice Num |
String |
|
Invoice |
Customer Num |
String |
|
Invoice |
Total Revenue |
Double |
|
Invoice |
Date |
DateTime |
|
Invoice Detail |
Invoice Num |
String |
|
Invoice Detail |
Product Num |
String |
|
Invoice Detail |
Extended |
Double |
|
Invoice Detail |
Orig Extended |
Double |
|
Invoice Detail |
Std Extended |
Double |
|
Invoice Detail |
Type |
String |
|
Invoice Detail |
Quantity |
Double |
|
Product |
Product Num |
String |
|
Product |
Group Desc |
String |
|
Product |
Class Desc |
String |
|
Product |
Group Num |
String |