USP_STANDINGORDERSIMPORTPROCESS_PRELOAD

Pre-load for Standing orders process.

Parameters

Parameter	Parameter Type	Mode
@CURRENTAPPUSERID	uniqueidentifier	IN
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT
@SHOWACCOUNTSYSTEM	bit	INOUT

Definition

Copy



create procedure dbo.USP_STANDINGORDERSIMPORTPROCESS_PRELOAD
(                
@CURRENTAPPUSERID uniqueidentifier = null,
@PDACCOUNTSYSTEMID uniqueidentifier = null output,
@SHOWACCOUNTSYSTEM bit = null output                
)
as
begin
  if dbo.UFN_VALID_BASICGL_INSTALLED() != 0
  begin
      if dbo.UFN_PDACCOUNTSYSTEM_GETNUMBEROFSYSTEMSFORUSER(@CURRENTAPPUSERID) = 1
          begin
              set @SHOWACCOUNTSYSTEM = 0
              select @PDACCOUNTSYSTEMID =  T1.ID from dbo.UFN_PDACCOUNTSYSTEM_GETSYSTEMIDSFORUSER(@CURRENTAPPUSERID) as T1
          end 
      else
          begin
              set @SHOWACCOUNTSYSTEM = 1        
              set @PDACCOUNTSYSTEMID = dbo.UFN_PDACCOUNTSYSTEM_GETDEFAULTSYSTEMIDSFORUSER(@CURRENTAPPUSERID)
          end 
  end
  else
  begin
      set @SHOWACCOUNTSYSTEM = 0
      set @PDACCOUNTSYSTEMID = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B'
  end
end