with data as (
select
ACCTID AccountId
,FSCSYR FiscalYear
,FSCSCURN CurrencyCode
,FSCSDSG Designator
,Period
,Amount
from [HF-FINANCE].[SMLDAT].[dbo].GLAFS
unpivot (Amount for Period in (NETPERD1, NETPERD2, NETPERD3, NETPERD4, NETPERD5, NETPERD6,
NETPERD7, NETPERD8, NETPERD9, NETPERD10, NETPERD11, NETPERD12,
NETPERD13, NETPERD14, NETPERD15)) sub
)