USP_RESERVATIONRATESCALE_UPDATETAXES
Updates tax sales order items that point to flat rate items to use flat rate pricing.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @CURRENTDATE | datetime | IN |
Definition
Copy
CREATE procedure dbo.USP_RESERVATIONRATESCALE_UPDATETAXES
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@CURRENTDATE datetime = null
)
as
begin
set nocount on;
declare @ISFLATRATE bit = 0
select
@ISFLATRATE = 1
from dbo.RESERVATIONRATESCALE
where ID = @ID
if @ISFLATRATE = 1
begin
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
if @CURRENTDATE is null
set @CURRENTDATE = getdate()
update dbo.SALESORDERITEM set
PRICINGSTRUCTURECODE = case
when exists
(
select 1 from dbo.SALESORDERITEMTAX
inner join dbo.SALESORDERITEM SOIINNER on
SALESORDERITEMTAX.SALESORDERITEMID = SOIINNER.ID
where
SALESORDERITEMTAX.TAXITEMID = SALESORDERITEM.ID and
SOIINNER.PRICINGSTRUCTURECODE in (0,2)
) then 0
else 1 end,
CHANGEDBYID = @CHANGEAGENTID,
DATECHANGED = @CURRENTDATE
where
SALESORDERITEM.SALESORDERID = @ID and
SALESORDERITEM.TYPECODE = 4
end
end