USP_FINANCIALTRANSACTIONSCHEDULE_ADD

Adds a financial transaction schedule

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@FINANCIALTRANSACTIONID	uniqueidentifier	IN
@DUEDATE	datetime	IN
@AMOUNT	money	IN

Definition

Copy



CREATE procedure dbo.USP_FINANCIALTRANSACTIONSCHEDULE_ADD ( 
  @ID uniqueidentifier = null output
  ,@CHANGEAGENTID uniqueidentifier = null
  ,@FINANCIALTRANSACTIONID uniqueidentifier = null 
  ,@DUEDATE datetime = null
  ,@AMOUNT money = 0
)
as
begin
    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();

  insert into dbo.FINANCIALTRANSACTIONSCHEDULE ( 
    ID
    ,FINANCIALTRANSACTIONID
    ,AMOUNT
    ,DUEDATE
    ,ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
   VALUES ( 
    @ID
    ,@FINANCIALTRANSACTIONID
    ,@AMOUNT
    ,@DUEDATE
    ,@CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE );

end