USP_DATAFORMTEMPLATE_ADD_PRELOAD_PDACCOUNTCODEMAPDEVELOPMENTMEMBERSHIPINSTALLMENTS
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SYSTEMID | uniqueidentifier | IN | |
| @WRITEOFFREASONCODESUBTYPECODE | xml | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PRELOAD_PDACCOUNTCODEMAPDEVELOPMENTMEMBERSHIPINSTALLMENTS
(
@SYSTEMID uniqueidentifier,
@WRITEOFFREASONCODESUBTYPECODE xml = null output
)
as
set nocount on;
declare @ALLCODES uniqueidentifier = '99999999-9999-9999-9999-999999999999'
set @WRITEOFFREASONCODESUBTYPECODE = (
select @ALLCODES as REASONCODESUBTYPECODEID
for xml raw('ITEM'), type, elements, root('WRITEOFFREASONCODESUBTYPECODE'), BINARY BASE64
)
return 0;