USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPFOREIGNCURRENCY_PRELOAD
The load procedure used by the edit dataform template "Map Development Realized Gains And Losses Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CONTEXTID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @PDACCOUNTSYSTEMID | uniqueidentifier | INOUT | Account System |
| @SUBTYPEONE | xml | INOUT | Currency |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPFOREIGNCURRENCY_PRELOAD
(
@CONTEXTID uniqueidentifier,
@PDACCOUNTSYSTEMID uniqueidentifier = null output,
@SUBTYPEONE xml = null output
)
as
set nocount on;
set @PDACCOUNTSYSTEMID = @CONTEXTID
set @SUBTYPEONE =
(select '99999999-9999-9999-9999-999999999999' as SUBTYPEONEID
for xml raw('ITEM'), type, elements, root('SUBTYPEONE'), BINARY BASE64);
return 0;