UFN_POSTTOGLPROCESS_GETUNPOSTEDADJUSTMENTTRANSACTIONS

create function dbo.UFN_POSTTOGLPROCESS_GETUNPOSTEDADJUSTMENTTRANSACTIONS()
returns
    @GLDISTRIBUTION table (
        ADJUSTMENTID uniqueidentifier,
        GLTRANSACTIONID uniqueidentifier,
        TRANSACTIONTYPE nvarchar(100),
        ACCOUNTSTRING  nvarchar(255),
        PROJECT  nvarchar(100),
        AMOUNT  money,
        REFERENCE  nvarchar(100)
    )
as
begin
    insert into @GLDISTRIBUTION(
        ADJUSTMENTID, 
        GLTRANSACTIONID,
        TRANSACTIONTYPE,
        ACCOUNTSTRING,
        PROJECT,
        AMOUNT,
        REFERENCE
    )
    select
        BANKACCOUNTTRANSACTION.ID as ADJUSTMENTID,
        GLTRANSACTION.ID as GLTRANSACTIONID,
        GLTRANSACTION.TRANSACTIONTYPE,
        GLTRANSACTION.ACCOUNT,
        GLTRANSACTION.PROJECT,
        GLTRANSACTION.AMOUNT,
        GLTRANSACTION.REFERENCE
    from
        dbo.BANKACCOUNTTRANSACTION
    inner join
        dbo.BANKACCOUNTTRANSACTIONGLDISTRIBUTION on BANKACCOUNTTRANSACTIONGLDISTRIBUTION.BANKACCOUNTTRANSACTIONID = BANKACCOUNTTRANSACTION.ID
    inner join
        dbo.GLTRANSACTION on GLTRANSACTION.ID = BANKACCOUNTTRANSACTIONGLDISTRIBUTION.GLTRANSACTIONID
    where
        GLTRANSACTION.POSTSTATUSCODE = 1
    and
        BANKACCOUNTTRANSACTION.POSTSTATUSCODE = 1;

    return;
end