USP_FINANCIALTRANSACTIONLINEITEM_ADD

Adds a row in to the Financial Transaction Line Item Table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@FINANCIALTRANSACTIONID	uniqueidentifier	IN
@AMOUNT	money	IN
@VISIBLE	bit	IN
@DESCRIPTION	nvarchar(100)	IN
@SEQUENCE	int	IN
@POSTDATE	date	IN
@POSTSTATUSCODE	tinyint	IN
@BASEAMOUNT	money	IN
@ORGAMOUNT	money	IN

Definition

Copy



CREATE procedure dbo.USP_FINANCIALTRANSACTIONLINEITEM_ADD
(
    @ID uniqueidentifier = null output,
    @CHANGEAGENTID uniqueidentifier = null,
    @FINANCIALTRANSACTIONID uniqueidentifier,
    @AMOUNT money = 0,
    @VISIBLE bit = 1
        ,@DESCRIPTION nvarchar(100) = ''
        ,@SEQUENCE int = 1
    ,@POSTDATE date = null
    ,@POSTSTATUSCODE tinyint = 1
    ,@BASEAMOUNT money = null
    ,@ORGAMOUNT money = null
)
as

set nocount on;

if @ID is null
    set @ID = newid()

if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()

if @BASEAMOUNT is null and @ORGAMOUNT is null
begin
  set @BASEAMOUNT = @AMOUNT;
  set @ORGAMOUNT = @AMOUNT;
end;

begin try
    -- handle inserting the data

    insert into dbo.FINANCIALTRANSACTIONLINEITEM 
  (
    ID
    ,FINANCIALTRANSACTIONID
    ,TRANSACTIONAMOUNT
    ,BASEAMOUNT
    ,ORGAMOUNT
    ,VISIBLE
        ,DESCRIPTION
        ,SEQUENCE
    ,POSTDATE
    ,POSTSTATUSCODE
    ,ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED
  )
  values 
  (
    @ID
    ,@FINANCIALTRANSACTIONID
    ,@AMOUNT
    ,@BASEAMOUNT
    ,@ORGAMOUNT
    ,@VISIBLE
        ,@DESCRIPTION
        ,@SEQUENCE
    ,@POSTDATE
    ,@POSTSTATUSCODE
    ,@CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE
  )
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0