| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP90CE: CRM Solution Advisor |
1 | F90CE01 | Solution Table | 1 | ST | SLTNID | Solution ID | Numeric | Generic Edit | 9 | 0 |
2 | F90CE01A | Solution/ Work Order Intersection | 1 | WO | SLTNID | Solution ID | Numeric | Generic Edit | 9 | 0 |
3 | F90CE01B | Solution/ Case Intersection | 1 | SC | SLTNID | Solution ID | Numeric | Generic Edit | 9 | 0 |
4 | F90CE01D | Solution/ Item Intersection | 1 | SP | SLTNID | Solution ID | Numeric | Generic Edit | 9 | 0 |
5 | F90CE03 | Frequently Used Solutions Per Product | 2 | FU | SLTNID | Solution ID | Numeric | Generic Edit | 9 | 0 |
6 | F90CE03A | Number of Cases with product 'X' solved by Solution | 1 | CS | SLTNID | Solution ID | Numeric | Generic Edit | 9 | 0 |
7 | F90CE03C | Number of Work Orders with product 'X' solved by Solution | 1 | WS | SLTNID | Solution ID | Numeric | Generic Edit | 9 | 0 |
8 | F90CE999 | Test Audit Table | 1 | AU | SLTNID | Solution ID | Numeric | Generic Edit | 9 | 0 |