USP_REVENUEBATCHCONSTITUENTACCOUNT_ADD

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CONSTITUENTID	uniqueidentifier	IN
@FINANCIALINSTITUTIONID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ACCOUNTNUMBER	nvarchar(50)	IN
@ACCOUNTTYPE	tinyint	IN
@EFTSTATUSCODE	tinyint	IN
@ACCOUNTNAME	nvarchar(100)	IN
@BATCHID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_REVENUEBATCHCONSTITUENTACCOUNT_ADD
(
    @ID uniqueidentifier = null output,
    @CONSTITUENTID uniqueidentifier,
    @FINANCIALINSTITUTIONID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,    
    @ACCOUNTNUMBER nvarchar(50) = '',
    @ACCOUNTTYPE tinyint = null,
    @EFTSTATUSCODE tinyint = 0,
    @ACCOUNTNAME nvarchar(100) = '',
    @BATCHID uniqueidentifier = null
)
as
begin

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

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

  declare @CURRENTDATE datetime = getdate();

  -- Open the symmetric key for decryption  

  exec dbo.USP_GET_KEY_ACCESS;

  insert into dbo.BATCHREVENUECONSTITUENTACCOUNT
  (
    ID,
    CONSTITUENTID,
    FINANCIALINSTITUTIONID,
    ACCOUNTNUMBER,
    ACCOUNTNUMBERINDEX,
    ACCOUNTTYPECODE,
    EFTSTATUSCODE,
    ACCOUNTNAME,
    ADDEDBYID,
    CHANGEDBYID,
    DATEADDED,
    DATECHANGED,
    BATCHID
  )
  values
  (
    @ID,
    @CONSTITUENTID,
    @FINANCIALINSTITUTIONID,
    encryptbykey(key_guid('sym_BBInfinity'), @ACCOUNTNUMBER),
    dbo.UFN_GET_MAC_FOR_TEXT(@ACCOUNTNUMBER, 'dbo.BATCHREVENUECONSTITUENTACCOUNT'),
    @ACCOUNTTYPE,
    @EFTSTATUSCODE,
    @ACCOUNTNAME,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE,
    @BATCHID
  );

  close symmetric key sym_BBInfinity;
end