Non-supported ReleaseNon-supported Release
ECI no longer supports this version of e-automate, and this version of the online help is no longer being updated. ECI recommends upgrading to the current release. Contact your account manager for more information.

Column Abbreviations

The Customer Transaction Detail Distributed and Customer Transaction Details topics list additional columns that you can add to these two views. This topic identifies columns you can add to the rest of the Analytics views. These columns have been assigned abbreviated labels due to the limited column header display options of these list views. These abbreviations apply mostly to pre-determined dates or period ranges. The Customers, Inventory Models, Service Contract Equipments, Service Contracts, and Service Equipments Analytics views are assigned the abbreviated columns. The following tables list the different Analytics column heading formats and provide a description of each.

Column abbreviations with CY-M-##: Current Fiscal Year 1st Month, Current Fiscal Year 2nd Month, etc.

Column Name	Description
CY	Current Fiscal Year
CY-M-01	Current Fiscal Year, 1st Month
CY-M-02	Current Fiscal Year, 2nd Month
CY-M-03	Current Fiscal Year, 3rd Month
CY-M-04	Current Fiscal Year, 4th Month
CY-M-05	Current Fiscal Year, 5th Month
CY-M-06	Current Fiscal Year, 6th Month
CY-M-07	Current Fiscal Year, 7th Month
CY-M-08	Current Fiscal Year, 8th Month
CY-M-09	Current Fiscal Year, 9th Month
CY-M-10	Current Fiscal Year, 10th Month
CY-M-11	Current Fiscal Year, 11th Month
CY-M-12	Current Fiscal Year, 12th Month

Column abbreviations with LY-M-##: Last Fiscal Year 1st Month, Last Fiscal Year 2nd Month, etc.

Column Name	Description
LY	Last Fiscal Year (Previous Fiscal Year)
LY-M-01	Last Fiscal Year, 1st Month
LY-M-02	Last Fiscal Year, 2nd Month
LY-M-03	Last Fiscal Year, 3rd Month
LY-M-04	Last Fiscal Year, 4th Month
LY-M-05	Last Fiscal Year, 5th Month
LY-M-06	Last Fiscal Year, 6th Month
LY-M-07	Last Fiscal Year, 7th Month
LY-M-08	Last Fiscal Year, 8th Month
LY-M-09	Last Fiscal Year, 9th Month
LY-M-10	Last Fiscal Year, 10th Month
LY-M-11	Last Fiscal Year, 11th Month
LY-M-12	Last Fiscal Year, 12th Month

Column abbreviations with LY-Q-##: Last Fiscal Year 1st Quarter, Last Fiscal Year 2nd Quarter, etc.

Column Name	Description
LY-Q-01	Last Fiscal Year, 1st Quarter
LY-Q-02	Last Fiscal Year, 2nd Quarter
LY-Q-03	Last Fiscal Year, 3rd Quarter
LY-Q-04	Last Fiscal Year, 4th Quarter

Column abbreviations with LY-TD: Last Fiscal Year to date.

Column Name	Description
LY-TD	Last Fiscal Year, 1st Quarter

Column abbreviations with RHY-##: Rolling Half Year (6 months) starting from 1 month back from today, Rolling Half Year starting from 7 months from today, etc.

Column Name	Description
RHY-01	Rolling Half Year starting 1 month back from today
RHY-02	Rolling Half Year starting 7 months back from today
RHY-03	Rolling Half Year starting 13 months back from today
RHY-04	Rolling Half Year starting 19 months back from today
RHY-05	Rolling Half Year starting 25 months back from today
RHY-06	Rolling Half Year starting 31 months back from today

Column abbreviations with RM-##: Rolling Month Current Month, Rolling Month Previous Month, etc.

Column Name	Description
RM-00	Rolling Month, Current month
RM-01	Rolling Month, Previous month
RM-02	Rolling Month, 2 months back from current month
RM-03	Rolling Month, 3 months back from current month
RM-04	Rolling Month, 4 months back from current month
RM-05	Rolling Month, 5 months back from current month
RM-06	Rolling Month, 6 months back from current month
RM-07	Rolling Month, 7 months back from current month
RM-08	Rolling Month, 8 months back from current month
RM-09	Rolling Month, 9 months back from current month
RM-10	Rolling Month, 10 months back from current month
RM-11	Rolling Month, 11 months back from current month
RM-12	Rolling Month, 12 months back from current month
RM-13	Rolling Month, 13 months back from current month
RM-14	Rolling Month, 14 months back from current month
RM-15	Rolling Month, 15 months back from current month
RM-16	Rolling Month, 16 months back from current month
RM-17	Rolling Month, 17 months back from current month
RM-18	Rolling Month, 18 months back from current month
RM-19	Rolling Month, 19 months back from current month
RM-20	Rolling Month, 20 months back from current month
RM-21	Rolling Month, 21 months back from current month
RM-22	Rolling Month, 22 months back from current month
RM-23	Rolling Month, 23 months back from current month
RM-24	Rolling Month, 24 months back from current month
RM-25	Rolling Month, 25 months back from current month

Column abbreviations with RQ-##: Rolling Quarter (3 months) duration between 1 and 3 months back from current month, Rolling Quarter duration between 4 and 6 months back from the current month , etc.

Column Name	Description
RQ-01	Rolling Quarter, duration between 1 and 3 months back from current month.
RQ-02	Rolling Quarter, duration between 4 and 6 months back from current month.
RQ-03	Rolling Quarter, duration between 7 and 9 months back from current month.
RQ-04	Rolling Quarter, duration between 10 and 12 months back from current month.
RQ-05	Rolling Quarter, duration between 13 and 15 months back from current month.
RQ-06	Rolling Quarter, duration between 16 and 18 months back from current month.
RQ-07	Rolling Quarter, duration between 19 and 21 months back from current month.
RQ-08	Rolling Quarter, duration between 22 and 24 months back from current month.
RQ-09	Rolling Quarter, duration between 25 and 27 months back from current month.
RQ-10	Rolling Quarter, duration between 28 and 30 months back from current month.
RQ-11	Rolling Quarter, duration between 31 and 33 months back from current month.
RQ-12	Rolling Quarter, duration between 34 and 36 months back from current month.

Column abbreviations with RY-##: Rolling Year (12 months) duration between 1 and 12 months back from current month, Rolling Year duration between 13 and 24 months back from current month, etc.

Column Name	Description
RY-01	Rolling Year, duration between 1 and 12 months back from current month.
RY-02	Rolling Year, duration between 13 and 24 months back from current month.
RY-03	Rolling Year, duration between 25 and 36 months back from current month.