CARMINA SII

Actualització de NIF, numero de residencia i tipus de factura a factures i abonaments de clients E-Commerce i iBoutique d’acord amb els requeriments validats pel Bernat i la Maria Velasco:

-- Actualització de les factures i abonaments E-Commerce i iBoutique
-- 17/5/2019 David Marti

select CardCode,LicTradNum,DocDate,DocEntry,DocNum,U_B1SYS_INV_TYPE,ResidenNum from ORIN 
where SUBSTRING(CardCode,1,1) in ('E','B')
order by DocDate Desc

-- Abonaments

update F Set U_B1SYS_INV_TYPE='F2',F.LicTradNum=P.Code+F.CardCode,ResidenNum=6
from ORIN F
join RIN12 L on L.DocEntry=F.DocEntry
left join OCRY P on P.Code=UPPER(L.CountryB)
where SUBSTRING(CardCode,1,1) in ('E','B')
and (F.LicTradNum is null or F.LicTradNum='' or F.LicTradNum=P.Code+F.CardCode)

update F Set U_B1SYS_INV_TYPE='F1'
from ORIN F
join RIN12 L on L.DocEntry=F.DocEntry
left join OCRY P on P.Code=UPPER(L.CountryB)
where SUBSTRING(CardCode,1,1) in ('E','B')
and (not F.LicTradNum is null and not F.LicTradNum='' and not F.LicTradNum=P.Code+F.CardCode)

-- Factures 

update F Set U_B1SYS_INV_TYPE='F2',F.LicTradNum=P.Code+F.CardCode,ResidenNum=6
from OINV F
join INV12 L on L.DocEntry=F.DocEntry
left join OCRY P on P.Code=UPPER(L.CountryB)
where SUBSTRING(CardCode,1,1) in ('E','B')
and (F.LicTradNum is null or F.LicTradNum='' or F.LicTradNum=P.Code+F.CardCode)

update F Set U_B1SYS_INV_TYPE='F1'
from OINV F
join INV12 L on L.DocEntry=F.DocEntry
left join OCRY P on P.Code=UPPER(L.CountryB)
where SUBSTRING(CardCode,1,1) in ('E','B')
and (not F.LicTradNum is null and not F.LicTradNum='' and not F.LicTradNum=P.Code+F.CardCode)