USP_DATAFORMTEMPLATE_ADD_SALESDEPOSITTEMPLATE_PRELOAD_3
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SALESDEPOSITPROCESSID | uniqueidentifier | IN | |
| @PDACCOUNTSYSTEMID | uniqueidentifier | INOUT | |
| @PAYMENTTYPE | xml | INOUT | |
| @SALESCHANNEL | xml | INOUT | |
| @CURRENCY | xml | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SALESDEPOSITTEMPLATE_PRELOAD_3
(
@SALESDEPOSITPROCESSID uniqueidentifier,
@PDACCOUNTSYSTEMID uniqueidentifier = null output,
@PAYMENTTYPE xml = null output,
@SALESCHANNEL xml = null output,
@CURRENCY xml = null output
)
as
set nocount on;
select
@PDACCOUNTSYSTEMID = PDACCOUNTSYSTEMID
from
dbo.SALESDEPOSITPROCESS P
where
P.ID = @SALESDEPOSITPROCESSID
set @PAYMENTTYPE = dbo.UFN_SALESDEPOSITTEMPLATE_PAYMENTMETHODS_TOITEMLISTXML(null);
set @SALESCHANNEL = dbo.UFN_SALESDEPOSITTEMPLATE_SALESCHANNELS_TOITEMLISTXML(null);
set @CURRENCY = dbo.UFN_SALESDEPOSITTEMPLATE_CURRENCY_TOITEMLISTXML(null, @PDACCOUNTSYSTEMID);
return 0;