USP_CREATEINITIALADJUSTMENTHISTORY

CREATE proc USP_CREATEINITIALADJUSTMENTHISTORY(@FINANCIALTRANSACTIONID uniqueidentifier, @CHANGEAGENTID uniqueidentifier)
as    
if exists (select 1 from dbo.FINANCIALTRANSACTIONLINEITEM where FINANCIALTRANSACTIONID = @FINANCIALTRANSACTIONID and FINANCIALTRANSACTIONLINEITEMADJUSTMENTID is null and TYPECODE = 0 and POSTSTATUSCODE = 2)
    begin
    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    declare @INITIALDATETIME datetime = (select DATEADDED from dbo.FINANCIALTRANSACTION where ID = @FINANCIALTRANSACTIONID)

    declare @AdjustmentID uniqueidentifier = newid()
    insert into dbo.FINANCIALTRANSACTIONLINEITEMADJUSTMENT(ID, DATE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED, CONSTITUENTID)
    select @AdjustmentID, @INITIALDATETIME, @CHANGEAGENTID, @CHANGEAGENTID, @INITIALDATETIME, getdate(), CONSTITUENTID
    from dbo.FINANCIALTRANSACTION 
    where ID = @FINANCIALTRANSACTIONID

    update dbo.FINANCIALTRANSACTIONLINEITEM
    set FINANCIALTRANSACTIONLINEITEMADJUSTMENTID = @AdjustmentID,
    CHANGEDBYID = @CHANGEAGENTID,
    DATECHANGED = getdate()
    where FINANCIALTRANSACTIONID = @FINANCIALTRANSACTIONID
    and FINANCIALTRANSACTIONLINEITEMADJUSTMENTID is null
    and TYPECODE != 1 
    and TYPECODE != 99
    and POSTSTATUSCODE = 2

    end