Thursday, November 17, 2011

GL SUMMARY TEMPLATE DEFINITIONS

/* GL SUMMARY TEMPLATE DEFINITIONS
Small script showing summary template configuration across multiple books, 
(Tested on Vision 11.5.10.2 Jul-2007 ) */
select sob.name
,    st.template_name
,    st.concatenated_description
,    st.account_category_code"Cat"
,    st.START_ACTUALS_PERIOD_NAME "From"
,    st.segment1_type||'-'||st.segment2_type||'-'||st.segment3_type||'-'||st.segment4_type||'-'||st.segment5_type||'-'||
    st.segment6_type||'-'||st.segment7_type||'-'||st.segment8_type||'-'||st.segment9_type||'-'||st.segment10_type "Segment Type"
from GL_SUMMARY_TEMPLATES st, GL_SETS_OF_BOOKS sob
where st.SET_OF_BOOKS_ID = sob.SET_OF_BOOKS_ID
--and substr(sob.name,1,2) in ('ES','BE','LU')

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect