00020 - Show As

Print
Details
Category: Header Formatting Settings
Hits: 4624

 

Setting description

 
ID 00020
Name Show as
Available values
Calendar Year: Different formats are available - see table below
Financial Year: Different formats are available - see table below
Default value  
Description Defines the format to show the values. Depending on 00040 - Show Calendar Type you have different settings. This setting is resettet and has to be redefined if 00040 - Show Calendar Type has been changed.
Prerequisite  

 

The Following formats are available:

Year 1 & 2        
Calendar Year Example         Financial Year Example
as [yy] 16   as [FY yy] FY 17
as [yyyy] 2016   as [FY yyyy] FY 2017
      as [Financial Year yy] Financial Year 17
      as [Financial Year yyyy] Financial Year 2017
         
Halfyear 1 & 2        
Calendar Year Example   Financial Year Example
as [hy] 02   as [FH 0hy] FH 001
as [hy.yy] 02.16   as [FH 0hy.yy] FH 001.17
as [hy / yy] 02 / 16   as [FH 0hy / yy] FH 001 / 17
as [hy.yyyy] 02.2016   as [FH 0hy.yyyy] FH 001.2017
as [hy / yyyy] 02 / 2016   as [FH 0hy / yyyy] FH 001 / 2017
as [Halfyear hy] Halfyear 02   as [Financial Halfyear 0hy] Financial Halfyear 001
as [Halfyear hy.yy] Halfyear 02.16   as [Financial Halfyear 0hy.yy] Financial Halfyear 001.17
as [Halfyear hy / yy] Halfyear 02 / 16   as [Financial Halfyear 0hy / yy] Financial Halfyear 001 / 17
as [Halfyear hy.yyyy] Halfyear 02.2016   as [Financial Halfyear 0hy.yyyy] Financial Halfyear 001.2017
as [Halfyear hy / yyyy] Halfyear 02 / 2016   as [Financial Halfyear 0hy / yyyy] Financial Halfyear 001 / 2017
         
Quarter 1 & 2        
Calendar Year Example   Financial Year Example
as [qq] 03   as [FQ 0qq] FQ 002
as [qq.yy] 03.16   as [FQ 0qq.yy] FQ 002.17
as [qq / yy] 03 / 16   as [FQ 0qq / yy] FQ 002 / 17
as [qq.yyyy] 03.2016   as [FQ 0qq.yyyy] FQ 002.2017
as [qq / yyyy] 03 / 2016   as [FQ 0qq / yyyy] FQ 002 / 2017
as [Quarter qq] Quarter 03   as [Financial Quarter 0qq] Financial Quarter 002
as [Quarter qq.yy] Quarter 03.16   as [Financial Quarter 0qq.yy] Financial Quarter 002.17
as [Quarter qq / yy] Quarter 03 / 16   as [Financial Quarter 0qq / yy] Financial Quarter 002 / 17
as [Quarter qq.yyyy] Quarter 03.2016   as [Financial Quarter 0qq.yyyy] Financial Quarter 002.2017
as [Quarter qq / yyyy] Quarter 03 / 2016   as [Financial Quarter 0qq / yyyy] Financial Quarter 002 / 2017
         
Halfyear 1 & 2        
Calendar Year Example   Financial Year Example
as [mm] 08   as [FP ppp] FP 005
as [mmm] Aug   as [FP ppp.yy] FP 005.17
as [mmmm] August   as [FP ppp.yyy] FP 005.2107
as [mmm yy] Aug 16   as [Financial Period ppp] Financial Period 005
as [mmmm yyyy] August 2016   as [Financial Period ppp.yy] Financial Period 005.17
as [mm.yyyy] 08.2016   as [Financial Period ppp.yyy] Financial Period 005.2017
as [Month mm] Month 08   as [FP ppp.yyyy (MMMM)] FP 005.2017 (August)
as [Month mm.yy] Month 08.16   as [Financial Period ppp.yyyy (MMMM)] Financial Period 005.2017 (August)
as [Month mm.yyyy]  Month 08.2016    as [Financial Period ppp.yyyy (MMMM YY)]  Financial Period 005.2017 (August 16) 
      as [Financial Period ppp.yyyy (MMMM YYYY)] Financial Period 005.2017 (August 2016)
         
Week        
Calendar Year Example      
as [ww] 34      
as [ww.yyyy] 34.2016      
as [ww / yyyy] 34 / 2016      
as [Week ww] Week 34      
as [Week ww.yyyy] Week 34.2016      
as [Week ww / yyyy] Week 34 / 2016      
         
Day 1 to 6        
Calendar Year Example      
as [dd] 28      
as [ddd] Su      
as [dddd] Sunday      
as [dd.mm.] 28.08.      
as [dd.mm.yyyy] 28.08.2016      
as day of year 241      
as day of halfyear 59      
as day of quarter 60      
as day of week 07      
as day of range (with weekends) 27      
as day of range (without weekends) 19      
as day of financial year 241      
as day of financial halfyear 059      
as day of financial quarter 060      
as day of financial period 028