USP_DATAFORMTEMPLATE_ADD_VATTAXRATE
The save procedure used by the add dataform template "VAT Tax Rate Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @DESCRIPTION | nvarchar(50) | IN | Description |
| @TAXRATE | decimal(7, 3) | IN | Tax rate |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_VATTAXRATE(
@ID uniqueidentifier = null output,
@DESCRIPTION nvarchar(50) = null,
@TAXRATE decimal(7,3) = null,
@CHANGEAGENTID uniqueidentifier
) as
set nocount on
if @ID is null
set @ID = newid()
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()
begin try
insert into dbo.VATTAXRATE(
ID,
DESCRIPTION,
TAXRATE,
DATEADDED,
DATECHANGED,
ADDEDBYID,
CHANGEDBYID
)values(
@ID,
@DESCRIPTION,
@TAXRATE,
@CURRENTDATE,
@CURRENTDATE,
@CHANGEAGENTID,
@CHANGEAGENTID
)
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch