USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTVENDOREXPENSE
The load procedure used by the edit dataform template "Marketing Vendor Marketing Expense Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @VENDORID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
| @SITEREQUIRED | bit | INOUT | Site required? |
| @SITEID | uniqueidentifier | INOUT | Site |
| @BASECURRENCYID | uniqueidentifier | INOUT | Currency |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_PRELOAD_ADD_MKTVENDOREXPENSE]
(
@VENDORID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier,
@SITEREQUIRED bit = null output,
@SITEID uniqueidentifier = null output,
@BASECURRENCYID uniqueidentifier = null output
)
as
set nocount on;
set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, '79C742CD-C22E-4B2C-B60A-42DDF404F7D2', 1);
set @SITEID = dbo.[UFN_APPUSER_DEFAULTSITEFORUSER](@CURRENTAPPUSERID);
set @BASECURRENCYID = dbo.[UFN_APPUSER_GETBASECURRENCY](@CURRENTAPPUSERID);
return 0;