/*PRzygotowanie wersji na prezentacje */

update firm.firm set firmname= cast(fulltextid as varchar) + ' ' + ' Firma' ,
firmNameShort=cast(fulltextid as varchar) + ' ' + ' Firma Krotki' ,
phoneNumber ='+48 000 000 000' ,fulltextcat=0

update document.orderLine set itemOrderName = 'Urzadzenie ' + left(orderLineID,6)

update wms.item set itemname = cast(fulltextid as varchar) + ' ' + ' Indeks Mag.', itemnameshort = cast(fulltextid as varchar) + ' ' + ' Indeks',
itemNameCommercial ='Urzadzenie ' + left(itemID,6)
,fulltextcat=0

update [wms].[commision] set  commisionName = cast(fulltextid as varchar) + ' ' + ' zlecenie',fulltextcat=0

update product.product set  productName  = cast(fulltextid as varchar) + ' ' + ' produkt',fulltextcat=0

update document.invoice set
[accPayerName]=''
,[accPayerNameShort]=''
,[accPayerTaxCode]=''
,[accPayerStreetName]=''
,[accPayerHouseNumber]=''
,[accPayerFlatNumber]=''
,[accPayerPostCode]=''
,[accPayerCity]=''
,[accPayerCountryCode]=''
,[accrecipientName]=''
,[accrecipientNameShort]=''
,[accrecipientTaxCode]=''
,[accrecipientStreetName]=''
,[accrecipientHouseNumber]=''
,[accrecipientFlatNumber]=''
,[accrecipientPostCode]=''
,[accrecipientCity]=''
,[accrecipientCountryCode]=''
,fulltextcat=0

update document.invoiceLine set [itemNameCommercial]='nazwa handlowa ' + left(invoiceLineID,4),
[itemNameCommercialForeign]= 'nazwa zagraniczna '  + left(invoiceLineID,4)
