select
    struct(
        displayNumber
        ,accountidType
        ,accountId
        ,alias
        ,type
        ,description
        ,status
        ,customerId
        ,mainItem
        ,costCenter) as accountDataDetails
    ,struct(
        amount
        ,currencyCode
        ,lastUpdate) as mainBalance
    ,struct(
         amount
        ,currencyCode
        ,lastUpdate) as availableBalance
    ,struct(
         amount
        ,currencyCode
        ,lastUpdate) as pendingBalance
    ,struct(
         amount
        ,currencyCode
        ,lastUpdate) as withholdingBalance
    ,struct(
         amount
        ,currencyCode
        ,lastUpdate) as overdraftLimit
    ,struct(
         amount
        ,currencyCode
        ,lastUpdate) as overdraftUsed
    ,struct(
        closingBalanceAmount as amount
        ,closingBalanceCurrencyCode as currencyCode
        ,closingBalanceLastUpdate as lastUpdate) as closingBalance
    ,struct(
        closingAvailableBalanceAmount as amount
        ,closingAvailableBalanceCurrencyCode as currencyCode
        ,closingAvailableBalanceLastUpdate as lastUpdate) as closingAvailableBalance