UFN_BANKACCOUNTDEPOSITCORRECTION_GETGLDISTRIBUTION

CREATE function dbo.UFN_BANKACCOUNTDEPOSITCORRECTION_GETGLDISTRIBUTION
(
  @BANKACCOUNTDEPOSITCORRECTIONID uniqueidentifier
)
returns @GLDISTRIBUTION table
(
  ID uniqueidentifier null,
  TRANSACTIONTYPECODE tinyint not null,
  DEBITCREDIT nvarchar(50) 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 @GLDISTRIBUTION (ID, TRANSACTIONTYPECODE, DEBITCREDIT, GLACCOUNTID, PROJECT, AMOUNT, REFERENCE,
    ORGANIZATIONAMOUNT, BASECURRENCYID, TRANSACTIONAMOUNT, TRANSACTIONCURRENCYID, BASEEXCHANGERATEID, ORGANIZATIONEXCHANGERATEID, GLTRANSACTIONID)
  select
    B.ID,
    B.TRANSACTIONTYPECODE,
    B.TRANSACTIONTYPE as DEBITCREDIT,
    GLTRANSACTION.GLACCOUNTID,
    B.PROJECT,
    B.AMOUNT,
    B.REFERENCE
    ,B.ORGANIZATIONAMOUNT
    ,B.BASECURRENCYID
    ,B.TRANSACTIONAMOUNT
    ,B.TRANSACTIONCURRENCYID
    ,B.BASEEXCHANGERATEID
    ,B.ORGANIZATIONEXCHANGERATEID
    ,B.GLTRANSACTIONID
  from dbo.BANKACCOUNTDEPOSITCORRECTIONGLDISTRIBUTION B
  inner join DBO.GLTRANSACTION ON GLTRANSACTION.ID = B.GLTRANSACTIONID
  where B.BANKACCOUNTDEPOSITCORRECTIONID = @BANKACCOUNTDEPOSITCORRECTIONID;

  return;
end