USP_DATAFORMTEMPLATE_EDIT_SALESDEPOSITTEMPLATE_PRELOAD_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@NAME	nvarchar(100)	INOUT
@BANKACCOUNTID	uniqueidentifier	INOUT
@REFERENCECODE	tinyint	INOUT
@SALESCHANNELOPTIONCODE	tinyint	INOUT
@SALESCHANNEL	xml	INOUT
@PAYMENTMETHODOPTIONCODE	tinyint	INOUT
@PAYMENTTYPE	xml	INOUT
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT
@CURRENCYOPTIONCODE	tinyint	INOUT
@CURRENCY	xml	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SALESDEPOSITTEMPLATE_PRELOAD_2
(

    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @NAME nvarchar(100) = null output,
    @BANKACCOUNTID uniqueidentifier = null output,
    @REFERENCECODE tinyint = null output,
    @SALESCHANNELOPTIONCODE tinyint = null output,
    @SALESCHANNEL xml = null output,
    @PAYMENTMETHODOPTIONCODE tinyint = null output,
    @PAYMENTTYPE xml = null output,
  @PDACCOUNTSYSTEMID uniqueidentifier = null output,
  @CURRENCYOPTIONCODE tinyint = null output,
  @CURRENCY xml = null output
)
as
set nocount on;

select 
    @DATALOADED = 1,
    @NAME = SDT.[NAME],
    @BANKACCOUNTID = [BANKACCOUNTID],
    @REFERENCECODE = [REFERENCECODE],
    @SALESCHANNELOPTIONCODE = [SALESCHANNELOPTIONCODE],
    @PAYMENTMETHODOPTIONCODE = [PAYMENTMETHODOPTIONCODE],
  @CURRENCYOPTIONCODE = [CURRENCYOPTIONCODE],
    @TSLONG = SDT.[TSLONG],
  @PDACCOUNTSYSTEMID = PDACCOUNTSYSTEMID
from dbo.[SALESDEPOSITTEMPLATE] SDT
left join dbo.SALESDEPOSITPROCESS SDP on SDP.ID = SDT.SALESDEPOSITPROCESSID
where SDT.[ID] = @ID;

set @PAYMENTTYPE = dbo.UFN_SALESDEPOSITTEMPLATE_PAYMENTMETHODS_TOITEMLISTXML(@ID);
set @SALESCHANNEL = dbo.UFN_SALESDEPOSITTEMPLATE_SALESCHANNELS_TOITEMLISTXML(@ID);
set @CURRENCY = dbo.UFN_SALESDEPOSITTEMPLATE_CURRENCY_TOITEMLISTXML(@ID, @PDACCOUNTSYSTEMID);

return 0;