USP_DATAFORMTEMPLATE_ADDLOAD_PDACCOUNTCODEMAPTREASURYPAYMENT
The load procedure used by the edit dataform template "Map Treasury Payments Add Form"
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@SUBTYPEONE | xml | INOUT | Credit card subtypes |
@SUBTYPETWO | xml | INOUT | Other subtypes |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADDLOAD_PDACCOUNTCODEMAPTREASURYPAYMENT
(
@SUBTYPEONE xml = null output,
@SUBTYPETWO xml = null output
)
as
set nocount on;
set @SUBTYPEONE = (
select '99999999-9999-9999-9999-999999999999' as SUBTYPEONEID
for xml raw('ITEM'), type, elements, root('SUBTYPEONE'), BINARY BASE64
);
set @SUBTYPETWO = (
select '99999999-9999-9999-9999-999999999999' as SUBTYPETWOID
for xml raw('ITEM'), type, elements, root('SUBTYPETWO'), BINARY BASE64
);
return 0;