View: dbo.GL_Account_Hash_View
View definition
create view dbo.GL_Account_Hash_View
as
select
gla.gl_account_KEY,
dbo.sf_SimpleNumericParse(gla.segment1) as segment1_hash,
dbo.sf_SimpleNumericParse(gla.segment2) as segment2_hash,
dbo.sf_SimpleNumericParse(gla.segment3) as segment3_hash,
dbo.sf_SimpleNumericParse(gla.segment4) as segment4_hash,
dbo.sf_SimpleNumericParse(gla.segment5) as segment5_hash,
dbo.sf_SimpleNumericParse(gla.segment6) as segment6_hash,
dbo.sf_SimpleNumericParse(gla.segment7) as segment7_hash,
dbo.sf_SimpleNumericParse(gla.segment8) as segment8_hash,
dbo.sf_SimpleNumericParse(gla.segment9) as segment9_hash,
dbo.sf_SimpleNumericParse(gla.segment10) as segment10_hash,
dbo.sf_SimpleNumericParse(gla.segment11) as segment11_hash,
dbo.sf_SimpleNumericParse(gla.segment12) as segment12_hash,
dbo.sf_SimpleNumericParse(gla.segment13) as segment13_hash,
dbo.sf_SimpleNumericParse(gla.segment14) as segment14_hash,
dbo.sf_SimpleNumericParse(gla.segment15) as segment15_hash,
dbo.sf_SimpleNumericParse(gla.segment16) as segment16_hash,
dbo.sf_SimpleNumericParse(gla.segment17) as segment17_hash,
dbo.sf_SimpleNumericParse(gla.segment18) as segment18_hash,
dbo.sf_SimpleNumericParse(gla.segment19) as segment19_hash,
dbo.sf_SimpleNumericParse(gla.segment20) as segment20_hash,
dbo.sf_SimpleNumericParse(gla.segment1) as up_to_segment1_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2) as up_to_segment2_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3) as up_to_segment3_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4) as up_to_segment4_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5) as up_to_segment5_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6) as up_to_segment6_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7) as up_to_segment7_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8) as up_to_segment8_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9) as up_to_segment9_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10) as up_to_segment10_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11) as up_to_segment11_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12) as up_to_segment12_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13) as up_to_segment13_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14) as up_to_segment14_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15) as up_to_segment15_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16) as up_to_segment16_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17) as up_to_segment17_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17 + gla.segment18) as up_to_segment18_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17 + gla.segment18 + gla.segment19) as up_to_segment19_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17 + gla.segment18 + gla.segment19 + gla.segment20) as up_to_segment20_hash,
dbo.sf_SimpleNumericParse(gla.segment1 + gla.segment2 + gla.segment3 + gla.segment4 + gla.segment5 + gla.segment6 + gla.segment7 + gla.segment8 + gla.segment9 + gla.segment10 + gla.segment11 + gla.segment12 + gla.segment13 + gla.segment14 + gla.segment15 + gla.segment16 + gla.segment17 + gla.segment18 + gla.segment19 + gla.segment20) as full_account_hash
from
dbo.GL_Account as gla