CREATE TRIGGER enforcezonecharges ON dbo.PS_TKT_LIN
FOR INSERT, UPDATE
AS
set nocount on
/*declare local variables--*/
declare
@ZON varchar(2),
@ZIP varchar(15),
@SVCFLG varchsr(2),
@MSG varchar(255)

select
@ZON=(select svc_zone from im_item where im_item.item_no=i.item_no),
@ZIP=(select ship_zip_cod
from ps_tkt_hdr
where ps_tkt_hdr.tkt_no=i.tkt_no
and ps_tkt_hdr.str_id=i.str_id
and ps_tkt_hdr.sta_id=i.sta_id),
@SVCFLG=(select IS_SVC_CALL
from ps_tkt_hdr
where ps_tkt_hdr.tkt_no=i.tkt_no
and ps_tkt_hdr.str_id=i.str_id
and ps_tkt_hdr.sta_id=i.sta_id)
from inserted i
where (i.subcat_cod='LABOR' or i.subcat_cod='WALAB')

/*make sure zone charge has been set if service related */
if @SVCFLG='Y' and (@ZON<>'00' or @ZON<>'99') and @ZON<>(select svc_zone from zip_cod_zones where zip_cod_zones.zip_cod=@ZIP)
begin
set @MSG='Zone charge on ticket does not match Ship to zone!'
end
if @SVCFLG='Y' and (@ZON='88') and @ZON<>(select svc_zone from zip_cod_zones where zip_cod_zones.zip_cod=@ZIP) and @ZON>'03'
and not exists(select top 1 im_item.item_no from im_item join inserted i on  im_item.item_no=i.item_no where im_item.svc_zone='77')
begin
set @MSG='Out of Normal Service Area: No Travel Charge on on this warranty ticket!'
end
if @MSG is not null
begin
rollback tran
raiserror(@MSG,18,1)
end