UFN_BANKACCOUNTTRANSACTION_GETGLDISTRIBUTION

CREATE function dbo.UFN_BANKACCOUNTTRANSACTION_GETGLDISTRIBUTION
(
  @BANKACCOUNTTRANSACTIONID uniqueidentifier
)
returns @BANKACCOUNTTRANSACTIONGLDISTRIBUTION table
(
  ID uniqueidentifier null,
  TRANSACTIONTYPECODE tinyint not null,
  ACCOUNT nvarchar(100) not null,
  GLACCOUNTID nvarchar(100) not null,
  PROJECT nvarchar(100) null,
  AMOUNT money not null,
  REFERENCE nvarchar(100) not null,
  ORGANIZATIONAMOUNT money not null,
    BASECURRENCYID uniqueidentifier,
    TRANSACTIONAMOUNT money,
    TRANSACTIONCURRENCYID uniqueidentifier,
    BASEEXCHANGERATEID uniqueidentifier,
    ORGANIZATIONEXCHANGERATEID uniqueidentifier,
  GLTRANSACTIONID uniqueidentifier
)
as begin
    insert into @BANKACCOUNTTRANSACTIONGLDISTRIBUTION 
  (
   ID, 
   TRANSACTIONTYPECODE, 
   ACCOUNT, 
   GLACCOUNTID, 
   PROJECT, 
   AMOUNT, 
   REFERENCE,
   ORGANIZATIONAMOUNT, 
   BASECURRENCYID, 
   TRANSACTIONAMOUNT, 
   TRANSACTIONCURRENCYID, 
   BASEEXCHANGERATEID, 
   ORGANIZATIONEXCHANGERATEID, 
   GLTRANSACTIONID
  )
  select
    B.ID,
    B.TRANSACTIONTYPECODE,
    B.ACCOUNT,
    GLTRANSACTION.GLACCOUNTID,
    B.PROJECT,
    B.AMOUNT,
    B.REFERENCE
    ,B.ORGANIZATIONAMOUNT
    ,B.BASECURRENCYID
    ,B.TRANSACTIONAMOUNT
    ,B.TRANSACTIONCURRENCYID
    ,B.BASEEXCHANGERATEID
    ,B.ORGANIZATIONEXCHANGERATEID
    ,B.GLTRANSACTIONID
  from dbo.BANKACCOUNTTRANSACTIONGLDISTRIBUTION B
  inner join dbo.GLTRANSACTION on GLTRANSACTION.ID = B.GLTRANSACTIONID
  where B.BANKACCOUNTTRANSACTIONID = @BANKACCOUNTTRANSACTIONID
  order by B.TRANSACTIONTYPE desc;

  return;
end