ALTER TABLE NOTAFISCAL
ADD USR_DTEXPXML_ACA DATE
/

ALTER TABLE CLASFISCAL
ADD USR_CODCLF VARCHAR2(5)
/

CREATE TABLE ACA_EXPORTA
(
  XML XMLTYPE,
  CDFILIAL VARCHAR2(4),
  NRLANCTONF VARCHAR2(10)
)
/

UPDATE CLASFISCAL SET USR_CODCLF = '1' WHERE CDCLASFISC   = '09090909';
UPDATE CLASFISCAL SET USR_CODCLF = '2' WHERE CDCLASFISC   = '10061092';
UPDATE CLASFISCAL SET USR_CODCLF = '3' WHERE CDCLASFISC   = '44079960';
UPDATE CLASFISCAL SET USR_CODCLF = '4' WHERE CDCLASFISC   = '07081000';
UPDATE CLASFISCAL SET USR_CODCLF = '5' WHERE CDCLASFISC   = '07133399';
UPDATE CLASFISCAL SET USR_CODCLF = '6' WHERE CDCLASFISC   = '07133329';
UPDATE CLASFISCAL SET USR_CODCLF = '7' WHERE CDCLASFISC   = '12074090';
UPDATE CLASFISCAL SET USR_CODCLF = '8' WHERE CDCLASFISC   = '11042300';
UPDATE CLASFISCAL SET USR_CODCLF = '9' WHERE CDCLASFISC   = '07133319';
UPDATE CLASFISCAL SET USR_CODCLF = '10' WHERE CDCLASFISC  = '07132090';
UPDATE CLASFISCAL SET USR_CODCLF = '100' WHERE CDCLASFISC = '22021000';
UPDATE CLASFISCAL SET USR_CODCLF = '101' WHERE CDCLASFISC = '22029000';
UPDATE CLASFISCAL SET USR_CODCLF = '102' WHERE CDCLASFISC = '22089000';
UPDATE CLASFISCAL SET USR_CODCLF = '103' WHERE CDCLASFISC = '19059020';
UPDATE CLASFISCAL SET USR_CODCLF = '104' WHERE CDCLASFISC = '19053200';
UPDATE CLASFISCAL SET USR_CODCLF = '105' WHERE CDCLASFISC = '20099000';
UPDATE CLASFISCAL SET USR_CODCLF = '106' WHERE CDCLASFISC = '20079910';
UPDATE CLASFISCAL SET USR_CODCLF = '107' WHERE CDCLASFISC = '18069000';
UPDATE CLASFISCAL SET USR_CODCLF = '108' WHERE CDCLASFISC = '19041000';
UPDATE CLASFISCAL SET USR_CODCLF = '109' WHERE CDCLASFISC = '19059090';
UPDATE CLASFISCAL SET USR_CODCLF = '11' WHERE CDCLASFISC  = '08025200';
UPDATE CLASFISCAL SET USR_CODCLF = '110' WHERE CDCLASFISC = '20086010';
UPDATE CLASFISCAL SET USR_CODCLF = '111' WHERE CDCLASFISC = '21069029';
UPDATE CLASFISCAL SET USR_CODCLF = '112' WHERE CDCLASFISC = '18063210';
UPDATE CLASFISCAL SET USR_CODCLF = '113' WHERE CDCLASFISC = '18063110';
UPDATE CLASFISCAL SET USR_CODCLF = '114' WHERE CDCLASFISC = '19053100';
UPDATE CLASFISCAL SET USR_CODCLF = '115' WHERE CDCLASFISC = '04031000';
UPDATE CLASFISCAL SET USR_CODCLF = '116' WHERE CDCLASFISC = '15179090';
UPDATE CLASFISCAL SET USR_CODCLF = '117' WHERE CDCLASFISC = '19019090';
UPDATE CLASFISCAL SET USR_CODCLF = '118' WHERE CDCLASFISC = '33021000';
UPDATE CLASFISCAL SET USR_CODCLF = '119' WHERE CDCLASFISC = '28363000';
UPDATE CLASFISCAL SET USR_CODCLF = '12' WHERE CDCLASFISC  = '10063029';
UPDATE CLASFISCAL SET USR_CODCLF = '120' WHERE CDCLASFISC = '09061100';
UPDATE CLASFISCAL SET USR_CODCLF = '121' WHERE CDCLASFISC = '09062000';
UPDATE CLASFISCAL SET USR_CODCLF = '122' WHERE CDCLASFISC = '21039099';
UPDATE CLASFISCAL SET USR_CODCLF = '123' WHERE CDCLASFISC = '09071000';
UPDATE CLASFISCAL SET USR_CODCLF = '124' WHERE CDCLASFISC = '09081100';
UPDATE CLASFISCAL SET USR_CODCLF = '125' WHERE CDCLASFISC = '21041011';
UPDATE CLASFISCAL SET USR_CODCLF = '126' WHERE CDCLASFISC = '09109900';
UPDATE CLASFISCAL SET USR_CODCLF = '127' WHERE CDCLASFISC = '21033021';
UPDATE CLASFISCAL SET USR_CODCLF = '128' WHERE CDCLASFISC = '12119010';
UPDATE CLASFISCAL SET USR_CODCLF = '129' WHERE CDCLASFISC = '09041200';
UPDATE CLASFISCAL SET USR_CODCLF = '13' WHERE CDCLASFISC  = '12071090';
UPDATE CLASFISCAL SET USR_CODCLF = '130' WHERE CDCLASFISC = '25010020';
UPDATE CLASFISCAL SET USR_CODCLF = '131' WHERE CDCLASFISC = '09093200';
UPDATE CLASFISCAL SET USR_CODCLF = '132' WHERE CDCLASFISC = '21032010';
UPDATE CLASFISCAL SET USR_CODCLF = '133' WHERE CDCLASFISC = '21021090';
UPDATE CLASFISCAL SET USR_CODCLF = '134' WHERE CDCLASFISC = '17011300';
UPDATE CLASFISCAL SET USR_CODCLF = '135' WHERE CDCLASFISC = '09011190';
UPDATE CLASFISCAL SET USR_CODCLF = '136' WHERE CDCLASFISC = '09030010';
UPDATE CLASFISCAL SET USR_CODCLF = '137' WHERE CDCLASFISC = '08011100';
UPDATE CLASFISCAL SET USR_CODCLF = '138' WHERE CDCLASFISC = '20098990';
UPDATE CLASFISCAL SET USR_CODCLF = '139' WHERE CDCLASFISC = '21039011';
UPDATE CLASFISCAL SET USR_CODCLF = '14' WHERE CDCLASFISC  = '07134090';
UPDATE CLASFISCAL SET USR_CODCLF = '140' WHERE CDCLASFISC = '11081200';
UPDATE CLASFISCAL SET USR_CODCLF = '141' WHERE CDCLASFISC = '22090000';
UPDATE CLASFISCAL SET USR_CODCLF = '142' WHERE CDCLASFISC = '08062000';
UPDATE CLASFISCAL SET USR_CODCLF = '143' WHERE CDCLASFISC = '04022110';
UPDATE CLASFISCAL SET USR_CODCLF = '144' WHERE CDCLASFISC = '09023000';
UPDATE CLASFISCAL SET USR_CODCLF = '145' WHERE CDCLASFISC = '11081400';
UPDATE CLASFISCAL SET USR_CODCLF = '146' WHERE CDCLASFISC = '20060000';
UPDATE CLASFISCAL SET USR_CODCLF = '147' WHERE CDCLASFISC = '04064000';
UPDATE CLASFISCAL SET USR_CODCLF = '148' WHERE CDCLASFISC = '19021900';
UPDATE CLASFISCAL SET USR_CODCLF = '149' WHERE CDCLASFISC = '19023000';
UPDATE CLASFISCAL SET USR_CODCLF = '15' WHERE CDCLASFISC  = '07104000';
UPDATE CLASFISCAL SET USR_CODCLF = '150' WHERE CDCLASFISC = '11031100';
UPDATE CLASFISCAL SET USR_CODCLF = '151' WHERE CDCLASFISC = '11031900';
UPDATE CLASFISCAL SET USR_CODCLF = '152' WHERE CDCLASFISC = '11010010';
UPDATE CLASFISCAL SET USR_CODCLF = '153' WHERE CDCLASFISC = '11022000';
UPDATE CLASFISCAL SET USR_CODCLF = '154' WHERE CDCLASFISC = '11029000';
UPDATE CLASFISCAL SET USR_CODCLF = '155' WHERE CDCLASFISC = '19059010';
UPDATE CLASFISCAL SET USR_CODCLF = '156' WHERE CDCLASFISC = '15079011';
UPDATE CLASFISCAL SET USR_CODCLF = '157' WHERE CDCLASFISC = '15099010';
UPDATE CLASFISCAL SET USR_CODCLF = '158' WHERE CDCLASFISC = '15171000';
UPDATE CLASFISCAL SET USR_CODCLF = '159' WHERE CDCLASFISC = '15180010';
UPDATE CLASFISCAL SET USR_CODCLF = '16' WHERE CDCLASFISC  = '10062020';
UPDATE CLASFISCAL SET USR_CODCLF = '160' WHERE CDCLASFISC = '04051000';
UPDATE CLASFISCAL SET USR_CODCLF = '161' WHERE CDCLASFISC = '15155000';
UPDATE CLASFISCAL SET USR_CODCLF = '162' WHERE CDCLASFISC = '22072019';
UPDATE CLASFISCAL SET USR_CODCLF = '163' WHERE CDCLASFISC = '28289011';
UPDATE CLASFISCAL SET USR_CODCLF = '164' WHERE CDCLASFISC = '34059000';
UPDATE CLASFISCAL SET USR_CODCLF = '165' WHERE CDCLASFISC = '34012090';
UPDATE CLASFISCAL SET USR_CODCLF = '166' WHERE CDCLASFISC = '12122100';
UPDATE CLASFISCAL SET USR_CODCLF = '167' WHERE CDCLASFISC = '22060090';
UPDATE CLASFISCAL SET USR_CODCLF = '168' WHERE CDCLASFISC = '08119000';
UPDATE CLASFISCAL SET USR_CODCLF = '169' WHERE CDCLASFISC = '19012000';
UPDATE CLASFISCAL SET USR_CODCLF = '17' WHERE CDCLASFISC  = '20081900';
UPDATE CLASFISCAL SET USR_CODCLF = '170' WHERE CDCLASFISC = '27101919';
UPDATE CLASFISCAL SET USR_CODCLF = '171' WHERE CDCLASFISC = '34054000';
UPDATE CLASFISCAL SET USR_CODCLF = '172' WHERE CDCLASFISC = '33074900';
UPDATE CLASFISCAL SET USR_CODCLF = '173' WHERE CDCLASFISC = '34052000';
UPDATE CLASFISCAL SET USR_CODCLF = '174' WHERE CDCLASFISC = '38099190';
UPDATE CLASFISCAL SET USR_CODCLF = '175' WHERE CDCLASFISC = '63071000';
UPDATE CLASFISCAL SET USR_CODCLF = '176' WHERE CDCLASFISC = '39232190';
UPDATE CLASFISCAL SET USR_CODCLF = '177' WHERE CDCLASFISC = '34029039';
UPDATE CLASFISCAL SET USR_CODCLF = '178' WHERE CDCLASFISC = '38089119';
UPDATE CLASFISCAL SET USR_CODCLF = '179' WHERE CDCLASFISC = '34011190';
UPDATE CLASFISCAL SET USR_CODCLF = '18' WHERE CDCLASFISC  = '11031300';
UPDATE CLASFISCAL SET USR_CODCLF = '180' WHERE CDCLASFISC = '34022000';
UPDATE CLASFISCAL SET USR_CODCLF = '181' WHERE CDCLASFISC = '63079010';
UPDATE CLASFISCAL SET USR_CODCLF = '182' WHERE CDCLASFISC = '40151900';
UPDATE CLASFISCAL SET USR_CODCLF = '183' WHERE CDCLASFISC = '28289019';
UPDATE CLASFISCAL SET USR_CODCLF = '184' WHERE CDCLASFISC = '38089429';
UPDATE CLASFISCAL SET USR_CODCLF = '185' WHERE CDCLASFISC = '38089197';
UPDATE CLASFISCAL SET USR_CODCLF = '186' WHERE CDCLASFISC = '29239090';
UPDATE CLASFISCAL SET USR_CODCLF = '187' WHERE CDCLASFISC = '96039000';
UPDATE CLASFISCAL SET USR_CODCLF = '188' WHERE CDCLASFISC = '96031000';
UPDATE CLASFISCAL SET USR_CODCLF = '189' WHERE CDCLASFISC = '96032900';
UPDATE CLASFISCAL SET USR_CODCLF = '19' WHERE CDCLASFISC  = '07133590';
UPDATE CLASFISCAL SET USR_CODCLF = '190' WHERE CDCLASFISC = '68053090';
UPDATE CLASFISCAL SET USR_CODCLF = '191' WHERE CDCLASFISC = '73231000';
UPDATE CLASFISCAL SET USR_CODCLF = '192' WHERE CDCLASFISC = '48232099';
UPDATE CLASFISCAL SET USR_CODCLF = '193' WHERE CDCLASFISC = '39241000';
UPDATE CLASFISCAL SET USR_CODCLF = '194' WHERE CDCLASFISC = '48195000';
UPDATE CLASFISCAL SET USR_CODCLF = '195' WHERE CDCLASFISC = '36050000';
UPDATE CLASFISCAL SET USR_CODCLF = '196' WHERE CDCLASFISC = '14019000';
UPDATE CLASFISCAL SET USR_CODCLF = '197' WHERE CDCLASFISC = '44219000';
UPDATE CLASFISCAL SET USR_CODCLF = '198' WHERE CDCLASFISC = '48183000';
UPDATE CLASFISCAL SET USR_CODCLF = '199' WHERE CDCLASFISC = '76071190';
UPDATE CLASFISCAL SET USR_CODCLF = '20' WHERE CDCLASFISC  = '02013000';
UPDATE CLASFISCAL SET USR_CODCLF = '200' WHERE CDCLASFISC = '48181000';
UPDATE CLASFISCAL SET USR_CODCLF = '201' WHERE CDCLASFISC = '48189090';
UPDATE CLASFISCAL SET USR_CODCLF = '202' WHERE CDCLASFISC = '34060000';
UPDATE CLASFISCAL SET USR_CODCLF = '203' WHERE CDCLASFISC = '39201010';
UPDATE CLASFISCAL SET USR_CODCLF = '205' WHERE CDCLASFISC = '39234000';
UPDATE CLASFISCAL SET USR_CODCLF = '206' WHERE CDCLASFISC = '48063000';
UPDATE CLASFISCAL SET USR_CODCLF = '207' WHERE CDCLASFISC = '63079090';
UPDATE CLASFISCAL SET USR_CODCLF = '208' WHERE CDCLASFISC = '44029000';
UPDATE CLASFISCAL SET USR_CODCLF = '209' WHERE CDCLASFISC = '29336911';
UPDATE CLASFISCAL SET USR_CODCLF = '21' WHERE CDCLASFISC  = '02071300';
UPDATE CLASFISCAL SET USR_CODCLF = '210' WHERE CDCLASFISC = '29239050';
UPDATE CLASFISCAL SET USR_CODCLF = '211' WHERE CDCLASFISC = '38085010';
UPDATE CLASFISCAL SET USR_CODCLF = '212' WHERE CDCLASFISC = '34029090';
UPDATE CLASFISCAL SET USR_CODCLF = '214' WHERE CDCLASFISC = '34029031';
UPDATE CLASFISCAL SET USR_CODCLF = '215' WHERE CDCLASFISC = '84821010';
UPDATE CLASFISCAL SET USR_CODCLF = '216' WHERE CDCLASFISC = '48237000';
UPDATE CLASFISCAL SET USR_CODCLF = '217' WHERE CDCLASFISC = '39222000';
UPDATE CLASFISCAL SET USR_CODCLF = '218' WHERE CDCLASFISC = '85362000';
UPDATE CLASFISCAL SET USR_CODCLF = '219' WHERE CDCLASFISC = '40069000';
UPDATE CLASFISCAL SET USR_CODCLF = '22' WHERE CDCLASFISC  = '02101900';
UPDATE CLASFISCAL SET USR_CODCLF = '220' WHERE CDCLASFISC = '56072900';
UPDATE CLASFISCAL SET USR_CODCLF = '221' WHERE CDCLASFISC = '35061090';
UPDATE CLASFISCAL SET USR_CODCLF = '222' WHERE CDCLASFISC = '85171891';
UPDATE CLASFISCAL SET USR_CODCLF = '223' WHERE CDCLASFISC = '27101932';
UPDATE CLASFISCAL SET USR_CODCLF = '224' WHERE CDCLASFISC = '83016000';
UPDATE CLASFISCAL SET USR_CODCLF = '225' WHERE CDCLASFISC = '82055900';
UPDATE CLASFISCAL SET USR_CODCLF = '226' WHERE CDCLASFISC = '39269090';
UPDATE CLASFISCAL SET USR_CODCLF = '227' WHERE CDCLASFISC = '39259090';
UPDATE CLASFISCAL SET USR_CODCLF = '228' WHERE CDCLASFISC = '85444900';
UPDATE CLASFISCAL SET USR_CODCLF = '229' WHERE CDCLASFISC = '85365090';
UPDATE CLASFISCAL SET USR_CODCLF = '23' WHERE CDCLASFISC  = '16041390';
UPDATE CLASFISCAL SET USR_CODCLF = '230' WHERE CDCLASFISC = '85366910';
UPDATE CLASFISCAL SET USR_CODCLF = '231' WHERE CDCLASFISC = '85381000';
UPDATE CLASFISCAL SET USR_CODCLF = '232' WHERE CDCLASFISC = '85041000';
UPDATE CLASFISCAL SET USR_CODCLF = '233' WHERE CDCLASFISC = '84818095';
UPDATE CLASFISCAL SET USR_CODCLF = '234' WHERE CDCLASFISC = '84818019';
UPDATE CLASFISCAL SET USR_CODCLF = '235' WHERE CDCLASFISC = '39174090';
UPDATE CLASFISCAL SET USR_CODCLF = '236' WHERE CDCLASFISC = '96034010';
UPDATE CLASFISCAL SET USR_CODCLF = '237' WHERE CDCLASFISC = '68052000';
UPDATE CLASFISCAL SET USR_CODCLF = '238' WHERE CDCLASFISC = '82011000';
UPDATE CLASFISCAL SET USR_CODCLF = '239' WHERE CDCLASFISC = '82013000';
UPDATE CLASFISCAL SET USR_CODCLF = '24' WHERE CDCLASFISC  = '04061010';
UPDATE CLASFISCAL SET USR_CODCLF = '240' WHERE CDCLASFISC = '82054000';
UPDATE CLASFISCAL SET USR_CODCLF = '241' WHERE CDCLASFISC = '95069100';
UPDATE CLASFISCAL SET USR_CODCLF = '242' WHERE CDCLASFISC = '84248129';
UPDATE CLASFISCAL SET USR_CODCLF = '243' WHERE CDCLASFISC = '83011000';
UPDATE CLASFISCAL SET USR_CODCLF = '244' WHERE CDCLASFISC = '32082011';
UPDATE CLASFISCAL SET USR_CODCLF = '245' WHERE CDCLASFISC = '84819010';
UPDATE CLASFISCAL SET USR_CODCLF = '246' WHERE CDCLASFISC = '85359000';
UPDATE CLASFISCAL SET USR_CODCLF = '247' WHERE CDCLASFISC = '83014000';
UPDATE CLASFISCAL SET USR_CODCLF = '248' WHERE CDCLASFISC = '39172300';
UPDATE CLASFISCAL SET USR_CODCLF = '249' WHERE CDCLASFISC = '85369090';
UPDATE CLASFISCAL SET USR_CODCLF = '25' WHERE CDCLASFISC  = '04061090';
UPDATE CLASFISCAL SET USR_CODCLF = '250' WHERE CDCLASFISC = '32082019';
UPDATE CLASFISCAL SET USR_CODCLF = '251' WHERE CDCLASFISC = '84831090';
UPDATE CLASFISCAL SET USR_CODCLF = '252' WHERE CDCLASFISC = '84811000';
UPDATE CLASFISCAL SET USR_CODCLF = '253' WHERE CDCLASFISC = '83082000';
UPDATE CLASFISCAL SET USR_CODCLF = '254' WHERE CDCLASFISC = '73269090';
UPDATE CLASFISCAL SET USR_CODCLF = '255' WHERE CDCLASFISC = '73261900';
UPDATE CLASFISCAL SET USR_CODCLF = '256' WHERE CDCLASFISC = '85366990';
UPDATE CLASFISCAL SET USR_CODCLF = '257' WHERE CDCLASFISC = '17022000';
UPDATE CLASFISCAL SET USR_CODCLF = '258' WHERE CDCLASFISC = '27101230';
UPDATE CLASFISCAL SET USR_CODCLF = '259' WHERE CDCLASFISC = '95066200';
UPDATE CLASFISCAL SET USR_CODCLF = '26' WHERE CDCLASFISC  = '04069020';
UPDATE CLASFISCAL SET USR_CODCLF = '260' WHERE CDCLASFISC = '32089010';
UPDATE CLASFISCAL SET USR_CODCLF = '261' WHERE CDCLASFISC = '40103200';
UPDATE CLASFISCAL SET USR_CODCLF = '262' WHERE CDCLASFISC = '84143011';
UPDATE CLASFISCAL SET USR_CODCLF = '263' WHERE CDCLASFISC = '48182000';
UPDATE CLASFISCAL SET USR_CODCLF = '264' WHERE CDCLASFISC = '27101249';
UPDATE CLASFISCAL SET USR_CODCLF = '265' WHERE CDCLASFISC = '20081100';
UPDATE CLASFISCAL SET USR_CODCLF = '266' WHERE CDCLASFISC = '03021100';
UPDATE CLASFISCAL SET USR_CODCLF = '267' WHERE CDCLASFISC = '84819090';
UPDATE CLASFISCAL SET USR_CODCLF = '268' WHERE CDCLASFISC = '32091010';
UPDATE CLASFISCAL SET USR_CODCLF = '269' WHERE CDCLASFISC = '32041700';
UPDATE CLASFISCAL SET USR_CODCLF = '27' WHERE CDCLASFISC  = '16023210';
UPDATE CLASFISCAL SET USR_CODCLF = '270' WHERE CDCLASFISC = '83024900';
UPDATE CLASFISCAL SET USR_CODCLF = '271' WHERE CDCLASFISC = '90153000';
UPDATE CLASFISCAL SET USR_CODCLF = '272' WHERE CDCLASFISC = '82021000';
UPDATE CLASFISCAL SET USR_CODCLF = '273' WHERE CDCLASFISC = '73181300';
UPDATE CLASFISCAL SET USR_CODCLF = '274' WHERE CDCLASFISC = '84142000';
UPDATE CLASFISCAL SET USR_CODCLF = '275' WHERE CDCLASFISC = '39031900';
UPDATE CLASFISCAL SET USR_CODCLF = '276' WHERE CDCLASFISC = '74122000';
UPDATE CLASFISCAL SET USR_CODCLF = '277' WHERE CDCLASFISC = '27101991';
UPDATE CLASFISCAL SET USR_CODCLF = '278' WHERE CDCLASFISC = '32081020';
UPDATE CLASFISCAL SET USR_CODCLF = '279' WHERE CDCLASFISC = '72169100';
UPDATE CLASFISCAL SET USR_CODCLF = '28' WHERE CDCLASFISC  = '16023100';
UPDATE CLASFISCAL SET USR_CODCLF = '280' WHERE CDCLASFISC = '32019090';
UPDATE CLASFISCAL SET USR_CODCLF = '281' WHERE CDCLASFISC = '35069120';
UPDATE CLASFISCAL SET USR_CODCLF = '282' WHERE CDCLASFISC = '39204900';
UPDATE CLASFISCAL SET USR_CODCLF = '283' WHERE CDCLASFISC = '85061010';
UPDATE CLASFISCAL SET USR_CODCLF = '284' WHERE CDCLASFISC = '42029200';
UPDATE CLASFISCAL SET USR_CODCLF = '285' WHERE CDCLASFISC = '84242000';
UPDATE CLASFISCAL SET USR_CODCLF = '286' WHERE CDCLASFISC = '68053020';
UPDATE CLASFISCAL SET USR_CODCLF = '287' WHERE CDCLASFISC = '32081010';
UPDATE CLASFISCAL SET USR_CODCLF = '288' WHERE CDCLASFISC = '39173900';
UPDATE CLASFISCAL SET USR_CODCLF = '29' WHERE CDCLASFISC  = '16010000';
UPDATE CLASFISCAL SET USR_CODCLF = '298' WHERE CDCLASFISC = '90291010';
UPDATE CLASFISCAL SET USR_CODCLF = '299' WHERE CDCLASFISC = '39191000';
UPDATE CLASFISCAL SET USR_CODCLF = '30' WHERE CDCLASFISC  = '21069090';
UPDATE CLASFISCAL SET USR_CODCLF = '300' WHERE CDCLASFISC = '73181200';
UPDATE CLASFISCAL SET USR_CODCLF = '301' WHERE CDCLASFISC = '94051099';
UPDATE CLASFISCAL SET USR_CODCLF = '302' WHERE CDCLASFISC = '39229000';
UPDATE CLASFISCAL SET USR_CODCLF = '303' WHERE CDCLASFISC = '90321090';
UPDATE CLASFISCAL SET USR_CODCLF = '304' WHERE CDCLASFISC = '34029029';
UPDATE CLASFISCAL SET USR_CODCLF = '305' WHERE CDCLASFISC = '34021290';
UPDATE CLASFISCAL SET USR_CODCLF = '306' WHERE CDCLASFISC = '34021300';
UPDATE CLASFISCAL SET USR_CODCLF = '307' WHERE CDCLASFISC = '07129010';
UPDATE CLASFISCAL SET USR_CODCLF = '308' WHERE CDCLASFISC = '83013000';
UPDATE CLASFISCAL SET USR_CODCLF = '309' WHERE CDCLASFISC = '02071400';
UPDATE CLASFISCAL SET USR_CODCLF = '31' WHERE CDCLASFISC  = '16025000';
UPDATE CLASFISCAL SET USR_CODCLF = '310' WHERE CDCLASFISC = '32149000';
UPDATE CLASFISCAL SET USR_CODCLF = '311' WHERE CDCLASFISC = '38101010';
UPDATE CLASFISCAL SET USR_CODCLF = '312' WHERE CDCLASFISC = '32041220';
UPDATE CLASFISCAL SET USR_CODCLF = '313' WHERE CDCLASFISC = '32082020';
UPDATE CLASFISCAL SET USR_CODCLF = '314' WHERE CDCLASFISC = '74199990';
UPDATE CLASFISCAL SET USR_CODCLF = '315' WHERE CDCLASFISC = '74182000';
UPDATE CLASFISCAL SET USR_CODCLF = '316' WHERE CDCLASFISC = '68042119';
UPDATE CLASFISCAL SET USR_CODCLF = '317' WHERE CDCLASFISC = '34011110';
UPDATE CLASFISCAL SET USR_CODCLF = '318' WHERE CDCLASFISC = '15151100';
UPDATE CLASFISCAL SET USR_CODCLF = '319' WHERE CDCLASFISC = '84139190';
UPDATE CLASFISCAL SET USR_CODCLF = '32' WHERE CDCLASFISC  = '20019000';
UPDATE CLASFISCAL SET USR_CODCLF = '320' WHERE CDCLASFISC = '38089324';
UPDATE CLASFISCAL SET USR_CODCLF = '321' WHERE CDCLASFISC = '34021190';
UPDATE CLASFISCAL SET USR_CODCLF = '322' WHERE CDCLASFISC = '85437099';
UPDATE CLASFISCAL SET USR_CODCLF = '323' WHERE CDCLASFISC = '73181500';
UPDATE CLASFISCAL SET USR_CODCLF = '324' WHERE CDCLASFISC = '32030029';
UPDATE CLASFISCAL SET USR_CODCLF = '325' WHERE CDCLASFISC = '83079000';
UPDATE CLASFISCAL SET USR_CODCLF = '326' WHERE CDCLASFISC = '85392200';
UPDATE CLASFISCAL SET USR_CODCLF = '327' WHERE CDCLASFISC = '91070010';
UPDATE CLASFISCAL SET USR_CODCLF = '328' WHERE CDCLASFISC = '84818091';
UPDATE CLASFISCAL SET USR_CODCLF = '329' WHERE CDCLASFISC = '85364900';
UPDATE CLASFISCAL SET USR_CODCLF = '33' WHERE CDCLASFISC  = '02023000';
UPDATE CLASFISCAL SET USR_CODCLF = '330' WHERE CDCLASFISC = '34013000';
UPDATE CLASFISCAL SET USR_CODCLF = '331' WHERE CDCLASFISC = '38249989';
UPDATE CLASFISCAL SET USR_CODCLF = '34' WHERE CDCLASFISC  = '08043000';
UPDATE CLASFISCAL SET USR_CODCLF = '35' WHERE CDCLASFISC  = '08039000';
UPDATE CLASFISCAL SET USR_CODCLF = '356' WHERE CDCLASFISC = '92089000';
UPDATE CLASFISCAL SET USR_CODCLF = '357' WHERE CDCLASFISC = '56081900';
UPDATE CLASFISCAL SET USR_CODCLF = '358' WHERE CDCLASFISC = '09096110';
UPDATE CLASFISCAL SET USR_CODCLF = '359' WHERE CDCLASFISC = '39206299';
UPDATE CLASFISCAL SET USR_CODCLF = '36' WHERE CDCLASFISC  = '08051000';
UPDATE CLASFISCAL SET USR_CODCLF = '360' WHERE CDCLASFISC = '84149010';
UPDATE CLASFISCAL SET USR_CODCLF = '361' WHERE CDCLASFISC = '39173229';
UPDATE CLASFISCAL SET USR_CODCLF = '362' WHERE CDCLASFISC = '61103000';
UPDATE CLASFISCAL SET USR_CODCLF = '363' WHERE CDCLASFISC = '15200020';
UPDATE CLASFISCAL SET USR_CODCLF = '364' WHERE CDCLASFISC = '39100019';
UPDATE CLASFISCAL SET USR_CODCLF = '365' WHERE CDCLASFISC = '42022900';
UPDATE CLASFISCAL SET USR_CODCLF = '366' WHERE CDCLASFISC = '90275020';
UPDATE CLASFISCAL SET USR_CODCLF = '367' WHERE CDCLASFISC = '64021900';
UPDATE CLASFISCAL SET USR_CODCLF = '368' WHERE CDCLASFISC = '96081000';
UPDATE CLASFISCAL SET USR_CODCLF = '369' WHERE CDCLASFISC = '61091000';
UPDATE CLASFISCAL SET USR_CODCLF = '37' WHERE CDCLASFISC  = '08072000';
UPDATE CLASFISCAL SET USR_CODCLF = '370' WHERE CDCLASFISC = '49119900';
UPDATE CLASFISCAL SET USR_CODCLF = '371' WHERE CDCLASFISC = '96091000';
UPDATE CLASFISCAL SET USR_CODCLF = '372' WHERE CDCLASFISC = '71132000';
UPDATE CLASFISCAL SET USR_CODCLF = '373' WHERE CDCLASFISC = '35069190';
UPDATE CLASFISCAL SET USR_CODCLF = '374' WHERE CDCLASFISC = '48171000';
UPDATE CLASFISCAL SET USR_CODCLF = '375' WHERE CDCLASFISC = '85232911';
UPDATE CLASFISCAL SET USR_CODCLF = '376' WHERE CDCLASFISC = '56061000';
UPDATE CLASFISCAL SET USR_CODCLF = '377' WHERE CDCLASFISC = '32100010';
UPDATE CLASFISCAL SET USR_CODCLF = '378' WHERE CDCLASFISC = '73170090';
UPDATE CLASFISCAL SET USR_CODCLF = '379' WHERE CDCLASFISC = '73182100';
UPDATE CLASFISCAL SET USR_CODCLF = '38' WHERE CDCLASFISC  = '08071100';
UPDATE CLASFISCAL SET USR_CODCLF = '380' WHERE CDCLASFISC = '40103100';
UPDATE CLASFISCAL SET USR_CODCLF = '381' WHERE CDCLASFISC = '85393900';
UPDATE CLASFISCAL SET USR_CODCLF = '382' WHERE CDCLASFISC = '85392190';
UPDATE CLASFISCAL SET USR_CODCLF = '383' WHERE CDCLASFISC = '85351000';
UPDATE CLASFISCAL SET USR_CODCLF = '384' WHERE CDCLASFISC = '85366100';
UPDATE CLASFISCAL SET USR_CODCLF = '385' WHERE CDCLASFISC = '85393100';
UPDATE CLASFISCAL SET USR_CODCLF = '386' WHERE CDCLASFISC = '85369010';
UPDATE CLASFISCAL SET USR_CODCLF = '387' WHERE CDCLASFISC = '28011000';
UPDATE CLASFISCAL SET USR_CODCLF = '388' WHERE CDCLASFISC = '63014000';
UPDATE CLASFISCAL SET USR_CODCLF = '389' WHERE CDCLASFISC = '27101931';
UPDATE CLASFISCAL SET USR_CODCLF = '39' WHERE CDCLASFISC  = '08071900';
UPDATE CLASFISCAL SET USR_CODCLF = '390' WHERE CDCLASFISC = '56074900';
UPDATE CLASFISCAL SET USR_CODCLF = '391' WHERE CDCLASFISC = '38140090';
UPDATE CLASFISCAL SET USR_CODCLF = '392' WHERE CDCLASFISC = '52021000';
UPDATE CLASFISCAL SET USR_CODCLF = '393' WHERE CDCLASFISC = '83071090';
UPDATE CLASFISCAL SET USR_CODCLF = '394' WHERE CDCLASFISC = '73079100';
UPDATE CLASFISCAL SET USR_CODCLF = '395' WHERE CDCLASFISC = '90178010';
UPDATE CLASFISCAL SET USR_CODCLF = '396' WHERE CDCLASFISC = '32141010';
UPDATE CLASFISCAL SET USR_CODCLF = '397' WHERE CDCLASFISC = '42021210';
UPDATE CLASFISCAL SET USR_CODCLF = '398' WHERE CDCLASFISC = '90172000';
UPDATE CLASFISCAL SET USR_CODCLF = '399' WHERE CDCLASFISC = '04063000';
UPDATE CLASFISCAL SET USR_CODCLF = '40' WHERE CDCLASFISC  = '08109000';
UPDATE CLASFISCAL SET USR_CODCLF = '400' WHERE CDCLASFISC = '82029100';
UPDATE CLASFISCAL SET USR_CODCLF = '401' WHERE CDCLASFISC = '39209990';
UPDATE CLASFISCAL SET USR_CODCLF = '402' WHERE CDCLASFISC = '84818011';
UPDATE CLASFISCAL SET USR_CODCLF = '403' WHERE CDCLASFISC = '48114110';
UPDATE CLASFISCAL SET USR_CODCLF = '404' WHERE CDCLASFISC = '84133030';
UPDATE CLASFISCAL SET USR_CODCLF = '405' WHERE CDCLASFISC = '76169900';
UPDATE CLASFISCAL SET USR_CODCLF = '406' WHERE CDCLASFISC = '46034090';
UPDATE CLASFISCAL SET USR_CODCLF = '407' WHERE CDCLASFISC = '39100012';
UPDATE CLASFISCAL SET USR_CODCLF = '408' WHERE CDCLASFISC = '82159990';
UPDATE CLASFISCAL SET USR_CODCLF = '409' WHERE CDCLASFISC = '39011092';
UPDATE CLASFISCAL SET USR_CODCLF = '41' WHERE CDCLASFISC  = '08133000';
UPDATE CLASFISCAL SET USR_CODCLF = '410' WHERE CDCLASFISC = '73158200';
UPDATE CLASFISCAL SET USR_CODCLF = '411' WHERE CDCLASFISC = '85111000';
UPDATE CLASFISCAL SET USR_CODCLF = '412' WHERE CDCLASFISC = '82031010';
UPDATE CLASFISCAL SET USR_CODCLF = '413' WHERE CDCLASFISC = '96034090';
UPDATE CLASFISCAL SET USR_CODCLF = '414' WHERE CDCLASFISC = '82023900';
UPDATE CLASFISCAL SET USR_CODCLF = '415' WHERE CDCLASFISC = '68042211';
UPDATE CLASFISCAL SET USR_CODCLF = '416' WHERE CDCLASFISC = '82141000';
UPDATE CLASFISCAL SET USR_CODCLF = '417' WHERE CDCLASFISC = '84828000';
UPDATE CLASFISCAL SET USR_CODCLF = '418' WHERE CDCLASFISC = '84842000';
UPDATE CLASFISCAL SET USR_CODCLF = '419' WHERE CDCLASFISC = '39249000';
UPDATE CLASFISCAL SET USR_CODCLF = '42' WHERE CDCLASFISC  = '08134010';
UPDATE CLASFISCAL SET USR_CODCLF = '420' WHERE CDCLASFISC = '76161000';
UPDATE CLASFISCAL SET USR_CODCLF = '421' WHERE CDCLASFISC = '73181600';
UPDATE CLASFISCAL SET USR_CODCLF = '422' WHERE CDCLASFISC = '28249010';
UPDATE CLASFISCAL SET USR_CODCLF = '423' WHERE CDCLASFISC = '27111910';
UPDATE CLASFISCAL SET USR_CODCLF = '424' WHERE CDCLASFISC = '72171090';
UPDATE CLASFISCAL SET USR_CODCLF = '425' WHERE CDCLASFISC = '84339010';
UPDATE CLASFISCAL SET USR_CODCLF = '426' WHERE CDCLASFISC = '44170090';
UPDATE CLASFISCAL SET USR_CODCLF = '427' WHERE CDCLASFISC = '84818099';
UPDATE CLASFISCAL SET USR_CODCLF = '428' WHERE CDCLASFISC = '73182300';
UPDATE CLASFISCAL SET USR_CODCLF = '429' WHERE CDCLASFISC = '84212100';
UPDATE CLASFISCAL SET USR_CODCLF = '43' WHERE CDCLASFISC  = '08101000';
UPDATE CLASFISCAL SET USR_CODCLF = '430' WHERE CDCLASFISC = '27101921';
UPDATE CLASFISCAL SET USR_CODCLF = '431' WHERE CDCLASFISC = '39261000';
UPDATE CLASFISCAL SET USR_CODCLF = '432' WHERE CDCLASFISC = '96082000';
UPDATE CLASFISCAL SET USR_CODCLF = '433' WHERE CDCLASFISC = '84729040';
UPDATE CLASFISCAL SET USR_CODCLF = '434' WHERE CDCLASFISC = '59061000';
UPDATE CLASFISCAL SET USR_CODCLF = '435' WHERE CDCLASFISC = '39233000';
UPDATE CLASFISCAL SET USR_CODCLF = '436' WHERE CDCLASFISC = '85423190';
UPDATE CLASFISCAL SET USR_CODCLF = '437' WHERE CDCLASFISC = '85151100';
UPDATE CLASFISCAL SET USR_CODCLF = '438' WHERE CDCLASFISC = '27150000';
UPDATE CLASFISCAL SET USR_CODCLF = '439' WHERE CDCLASFISC = '32100020';
UPDATE CLASFISCAL SET USR_CODCLF = '44' WHERE CDCLASFISC  = '08044000';
UPDATE CLASFISCAL SET USR_CODCLF = '440' WHERE CDCLASFISC = '84812090';
UPDATE CLASFISCAL SET USR_CODCLF = '441' WHERE CDCLASFISC = '83021000';
UPDATE CLASFISCAL SET USR_CODCLF = '442' WHERE CDCLASFISC = '73121010';
UPDATE CLASFISCAL SET USR_CODCLF = '443' WHERE CDCLASFISC = '85171232';
UPDATE CLASFISCAL SET USR_CODCLF = '444' WHERE CDCLASFISC = '38244000';
UPDATE CLASFISCAL SET USR_CODCLF = '445' WHERE CDCLASFISC = '53041000';
UPDATE CLASFISCAL SET USR_CODCLF = '446' WHERE CDCLASFISC = '38101020';
UPDATE CLASFISCAL SET USR_CODCLF = '447' WHERE CDCLASFISC = '95065100';
UPDATE CLASFISCAL SET USR_CODCLF = '448' WHERE CDCLASFISC = '73181900';
UPDATE CLASFISCAL SET USR_CODCLF = '449' WHERE CDCLASFISC = '85061030';
UPDATE CLASFISCAL SET USR_CODCLF = '45' WHERE CDCLASFISC  = '07041000';
UPDATE CLASFISCAL SET USR_CODCLF = '450' WHERE CDCLASFISC = '08013200';
UPDATE CLASFISCAL SET USR_CODCLF = '451' WHERE CDCLASFISC = '40169300';
UPDATE CLASFISCAL SET USR_CODCLF = '452' WHERE CDCLASFISC = '90178090';
UPDATE CLASFISCAL SET USR_CODCLF = '453' WHERE CDCLASFISC = '36041000';
UPDATE CLASFISCAL SET USR_CODCLF = '454' WHERE CDCLASFISC = '73079200';
UPDATE CLASFISCAL SET USR_CODCLF = '455' WHERE CDCLASFISC = '48202000';
UPDATE CLASFISCAL SET USR_CODCLF = '456' WHERE CDCLASFISC = '48119090';
UPDATE CLASFISCAL SET USR_CODCLF = '457' WHERE CDCLASFISC = '48191000';
UPDATE CLASFISCAL SET USR_CODCLF = '458' WHERE CDCLASFISC = '42023200';
UPDATE CLASFISCAL SET USR_CODCLF = '459' WHERE CDCLASFISC = '40169990';
UPDATE CLASFISCAL SET USR_CODCLF = '46' WHERE CDCLASFISC  = '07099990';
UPDATE CLASFISCAL SET USR_CODCLF = '460' WHERE CDCLASFISC = '83040000';
UPDATE CLASFISCAL SET USR_CODCLF = '461' WHERE CDCLASFISC = '48209000';
UPDATE CLASFISCAL SET USR_CODCLF = '462' WHERE CDCLASFISC = '82119390';
UPDATE CLASFISCAL SET USR_CODCLF = '463' WHERE CDCLASFISC = '48053000';
UPDATE CLASFISCAL SET USR_CODCLF = '464' WHERE CDCLASFISC = '48211000';
UPDATE CLASFISCAL SET USR_CODCLF = '465' WHERE CDCLASFISC = '38089199';
UPDATE CLASFISCAL SET USR_CODCLF = '466' WHERE CDCLASFISC = '32141020';
UPDATE CLASFISCAL SET USR_CODCLF = '467' WHERE CDCLASFISC = '39095029';
UPDATE CLASFISCAL SET USR_CODCLF = '468' WHERE CDCLASFISC = '84251100';
UPDATE CLASFISCAL SET USR_CODCLF = '469' WHERE CDCLASFISC = '21061000';
UPDATE CLASFISCAL SET USR_CODCLF = '47' WHERE CDCLASFISC  = '07051900';
UPDATE CLASFISCAL SET USR_CODCLF = '470' WHERE CDCLASFISC = '18062000';
UPDATE CLASFISCAL SET USR_CODCLF = '471' WHERE CDCLASFISC = '87089910';
UPDATE CLASFISCAL SET USR_CODCLF = '472' WHERE CDCLASFISC = '82041200';
UPDATE CLASFISCAL SET USR_CODCLF = '473' WHERE CDCLASFISC = '12081000';
UPDATE CLASFISCAL SET USR_CODCLF = '474' WHERE CDCLASFISC = '19042000';
UPDATE CLASFISCAL SET USR_CODCLF = '475' WHERE CDCLASFISC = '32091020';
UPDATE CLASFISCAL SET USR_CODCLF = '476' WHERE CDCLASFISC = '19049000';
UPDATE CLASFISCAL SET USR_CODCLF = '477' WHERE CDCLASFISC = '11041900';
UPDATE CLASFISCAL SET USR_CODCLF = '478' WHERE CDCLASFISC = '11042200';
UPDATE CLASFISCAL SET USR_CODCLF = '479' WHERE CDCLASFISC = '12040090';
UPDATE CLASFISCAL SET USR_CODCLF = '48' WHERE CDCLASFISC  = '07099300';
UPDATE CLASFISCAL SET USR_CODCLF = '480' WHERE CDCLASFISC = '84679900';
UPDATE CLASFISCAL SET USR_CODCLF = '481' WHERE CDCLASFISC = '34029019';
UPDATE CLASFISCAL SET USR_CODCLF = '482' WHERE CDCLASFISC = '28321090';
UPDATE CLASFISCAL SET USR_CODCLF = '483' WHERE CDCLASFISC = '83063000';
UPDATE CLASFISCAL SET USR_CODCLF = '484' WHERE CDCLASFISC = '84836090';
UPDATE CLASFISCAL SET USR_CODCLF = '485' WHERE CDCLASFISC = '38220090';
UPDATE CLASFISCAL SET USR_CODCLF = '486' WHERE CDCLASFISC = '73181100';
UPDATE CLASFISCAL SET USR_CODCLF = '487' WHERE CDCLASFISC = '23021000';
UPDATE CLASFISCAL SET USR_CODCLF = '488' WHERE CDCLASFISC = '34053000';
UPDATE CLASFISCAL SET USR_CODCLF = '489' WHERE CDCLASFISC = '19011090';
UPDATE CLASFISCAL SET USR_CODCLF = '49' WHERE CDCLASFISC  = '07019000';
UPDATE CLASFISCAL SET USR_CODCLF = '490' WHERE CDCLASFISC = '17023020';
UPDATE CLASFISCAL SET USR_CODCLF = '491' WHERE CDCLASFISC = '15162000';
UPDATE CLASFISCAL SET USR_CODCLF = '492' WHERE CDCLASFISC = '48010090';
UPDATE CLASFISCAL SET USR_CODCLF = '493' WHERE CDCLASFISC = '17023019';
UPDATE CLASFISCAL SET USR_CODCLF = '494' WHERE CDCLASFISC = '64039990';
UPDATE CLASFISCAL SET USR_CODCLF = '495' WHERE CDCLASFISC = '64034000';
UPDATE CLASFISCAL SET USR_CODCLF = '496' WHERE CDCLASFISC = '64019200';
UPDATE CLASFISCAL SET USR_CODCLF = '497' WHERE CDCLASFISC = '62011300';
UPDATE CLASFISCAL SET USR_CODCLF = '498' WHERE CDCLASFISC = '90211099';
UPDATE CLASFISCAL SET USR_CODCLF = '499' WHERE CDCLASFISC = '27101992';
UPDATE CLASFISCAL SET USR_CODCLF = '50' WHERE CDCLASFISC  = '07093000';
UPDATE CLASFISCAL SET USR_CODCLF = '500' WHERE CDCLASFISC = '38190000';
UPDATE CLASFISCAL SET USR_CODCLF = '501' WHERE CDCLASFISC = '22060010';
UPDATE CLASFISCAL SET USR_CODCLF = '502' WHERE CDCLASFISC = '61161000';
UPDATE CLASFISCAL SET USR_CODCLF = '503' WHERE CDCLASFISC = '42032900';
UPDATE CLASFISCAL SET USR_CODCLF = '504' WHERE CDCLASFISC = '62160000';
UPDATE CLASFISCAL SET USR_CODCLF = '505' WHERE CDCLASFISC = '42034000';
UPDATE CLASFISCAL SET USR_CODCLF = '506' WHERE CDCLASFISC = '62019300';
UPDATE CLASFISCAL SET USR_CODCLF = '507' WHERE CDCLASFISC = '85322590';
UPDATE CLASFISCAL SET USR_CODCLF = '508' WHERE CDCLASFISC = '15122910';
UPDATE CLASFISCAL SET USR_CODCLF = '509' WHERE CDCLASFISC = '18061000';
UPDATE CLASFISCAL SET USR_CODCLF = '51' WHERE CDCLASFISC  = '07069000';
UPDATE CLASFISCAL SET USR_CODCLF = '510' WHERE CDCLASFISC = '08135000';
UPDATE CLASFISCAL SET USR_CODCLF = '511' WHERE CDCLASFISC = '19052090';
UPDATE CLASFISCAL SET USR_CODCLF = '512' WHERE CDCLASFISC = '18063120';
UPDATE CLASFISCAL SET USR_CODCLF = '513' WHERE CDCLASFISC = '20089790';
UPDATE CLASFISCAL SET USR_CODCLF = '514' WHERE CDCLASFISC = '19030000';
UPDATE CLASFISCAL SET USR_CODCLF = '515' WHERE CDCLASFISC = '90318099';
UPDATE CLASFISCAL SET USR_CODCLF = '516' WHERE CDCLASFISC = '22029900';
UPDATE CLASFISCAL SET USR_CODCLF = '517' WHERE CDCLASFISC = '29094100';
UPDATE CLASFISCAL SET USR_CODCLF = '518' WHERE CDCLASFISC = '85044010';
UPDATE CLASFISCAL SET USR_CODCLF = '519' WHERE CDCLASFISC = '94051093';
UPDATE CLASFISCAL SET USR_CODCLF = '52' WHERE CDCLASFISC  = '07061000';
UPDATE CLASFISCAL SET USR_CODCLF = '520' WHERE CDCLASFISC = '83025000';
UPDATE CLASFISCAL SET USR_CODCLF = '521' WHERE CDCLASFISC = '85131010';
UPDATE CLASFISCAL SET USR_CODCLF = '522' WHERE CDCLASFISC = '64019990';
UPDATE CLASFISCAL SET USR_CODCLF = '523' WHERE CDCLASFISC = '21069030';
UPDATE CLASFISCAL SET USR_CODCLF = '524' WHERE CDCLASFISC = '83024100';
UPDATE CLASFISCAL SET USR_CODCLF = '525' WHERE CDCLASFISC = '39169010';
UPDATE CLASFISCAL SET USR_CODCLF = '526' WHERE CDCLASFISC = '29155020';
UPDATE CLASFISCAL SET USR_CODCLF = '527' WHERE CDCLASFISC = '84191100';
UPDATE CLASFISCAL SET USR_CODCLF = '528' WHERE CDCLASFISC = '83022000';
UPDATE CLASFISCAL SET USR_CODCLF = '529' WHERE CDCLASFISC = '72230000';
UPDATE CLASFISCAL SET USR_CODCLF = '53' WHERE CDCLASFISC  = '07108000';
UPDATE CLASFISCAL SET USR_CODCLF = '530' WHERE CDCLASFISC = '27101999';
UPDATE CLASFISCAL SET USR_CODCLF = '531' WHERE CDCLASFISC = '39232990';
UPDATE CLASFISCAL SET USR_CODCLF = '532' WHERE CDCLASFISC = '85161000';
UPDATE CLASFISCAL SET USR_CODCLF = '533' WHERE CDCLASFISC = '84145990';
UPDATE CLASFISCAL SET USR_CODCLF = '534' WHERE CDCLASFISC = '84813000';
UPDATE CLASFISCAL SET USR_CODCLF = '535' WHERE CDCLASFISC = '09019000';
UPDATE CLASFISCAL SET USR_CODCLF = '536' WHERE CDCLASFISC = '20071000';
UPDATE CLASFISCAL SET USR_CODCLF = '537' WHERE CDCLASFISC = '21069060';
UPDATE CLASFISCAL SET USR_CODCLF = '538' WHERE CDCLASFISC = '17026020';
UPDATE CLASFISCAL SET USR_CODCLF = '539' WHERE CDCLASFISC = '19019020';
UPDATE CLASFISCAL SET USR_CODCLF = '54' WHERE CDCLASFISC  = '08055000';
UPDATE CLASFISCAL SET USR_CODCLF = '540' WHERE CDCLASFISC = '11041200';
UPDATE CLASFISCAL SET USR_CODCLF = '541' WHERE CDCLASFISC = '10085090';
UPDATE CLASFISCAL SET USR_CODCLF = '542' WHERE CDCLASFISC = '84681000';
UPDATE CLASFISCAL SET USR_CODCLF = '543' WHERE CDCLASFISC = '72112300';
UPDATE CLASFISCAL SET USR_CODCLF = '544' WHERE CDCLASFISC = '19021100';
UPDATE CLASFISCAL SET USR_CODCLF = '545' WHERE CDCLASFISC = '20096100';
UPDATE CLASFISCAL SET USR_CODCLF = '546' WHERE CDCLASFISC = '20094100';
UPDATE CLASFISCAL SET USR_CODCLF = '547' WHERE CDCLASFISC = '20091200';
UPDATE CLASFISCAL SET USR_CODCLF = '548' WHERE CDCLASFISC = '29181400';
UPDATE CLASFISCAL SET USR_CODCLF = '549' WHERE CDCLASFISC = '18050000';
UPDATE CLASFISCAL SET USR_CODCLF = '55' WHERE CDCLASFISC  = '07141000';
UPDATE CLASFISCAL SET USR_CODCLF = '550' WHERE CDCLASFISC = '17023011';
UPDATE CLASFISCAL SET USR_CODCLF = '551' WHERE CDCLASFISC = '17029000';
UPDATE CLASFISCAL SET USR_CODCLF = '552' WHERE CDCLASFISC = '39235000';
UPDATE CLASFISCAL SET USR_CODCLF = '553' WHERE CDCLASFISC = '69109000';
UPDATE CLASFISCAL SET USR_CODCLF = '554' WHERE CDCLASFISC = '12119090';
UPDATE CLASFISCAL SET USR_CODCLF = '555' WHERE CDCLASFISC = '21039091';
UPDATE CLASFISCAL SET USR_CODCLF = '556' WHERE CDCLASFISC = '17019900';
UPDATE CLASFISCAL SET USR_CODCLF = '557' WHERE CDCLASFISC = '39073022';
UPDATE CLASFISCAL SET USR_CODCLF = '558' WHERE CDCLASFISC = '10063021';
UPDATE CLASFISCAL SET USR_CODCLF = '559' WHERE CDCLASFISC = '85432000';
UPDATE CLASFISCAL SET USR_CODCLF = '56' WHERE CDCLASFISC  = '04079000';
UPDATE CLASFISCAL SET USR_CODCLF = '560' WHERE CDCLASFISC = '12079990';
UPDATE CLASFISCAL SET USR_CODCLF = '561' WHERE CDCLASFISC = '74112990';
UPDATE CLASFISCAL SET USR_CODCLF = '562' WHERE CDCLASFISC = '84199010';
UPDATE CLASFISCAL SET USR_CODCLF = '563' WHERE CDCLASFISC = '04089900';
UPDATE CLASFISCAL SET USR_CODCLF = '564' WHERE CDCLASFISC = '32041990';
UPDATE CLASFISCAL SET USR_CODCLF = '565' WHERE CDCLASFISC = '07142000';
UPDATE CLASFISCAL SET USR_CODCLF = '566' WHERE CDCLASFISC = '90189029';
UPDATE CLASFISCAL SET USR_CODCLF = '567' WHERE CDCLASFISC = '22030000';
UPDATE CLASFISCAL SET USR_CODCLF = '568' WHERE CDCLASFISC = '21012020';
UPDATE CLASFISCAL SET USR_CODCLF = '569' WHERE CDCLASFISC = '39239000';
UPDATE CLASFISCAL SET USR_CODCLF = '57' WHERE CDCLASFISC  = '07070000';
UPDATE CLASFISCAL SET USR_CODCLF = '570' WHERE CDCLASFISC = '07103000';
UPDATE CLASFISCAL SET USR_CODCLF = '571' WHERE CDCLASFISC = '48239099';
UPDATE CLASFISCAL SET USR_CODCLF = '572' WHERE CDCLASFISC = '82121020';
UPDATE CLASFISCAL SET USR_CODCLF = '573' WHERE CDCLASFISC = '48194000';
UPDATE CLASFISCAL SET USR_CODCLF = '574' WHERE CDCLASFISC = '07143000';
UPDATE CLASFISCAL SET USR_CODCLF = '575' WHERE CDCLASFISC = '04012010';
UPDATE CLASFISCAL SET USR_CODCLF = '576' WHERE CDCLASFISC = '63072000';
UPDATE CLASFISCAL SET USR_CODCLF = '577' WHERE CDCLASFISC = '33049990';
UPDATE CLASFISCAL SET USR_CODCLF = '578' WHERE CDCLASFISC = '62171000';
UPDATE CLASFISCAL SET USR_CODCLF = '579' WHERE CDCLASFISC = '38249939';
UPDATE CLASFISCAL SET USR_CODCLF = '58' WHERE CDCLASFISC  = '07096000';
UPDATE CLASFISCAL SET USR_CODCLF = '580' WHERE CDCLASFISC = '15119000';
UPDATE CLASFISCAL SET USR_CODCLF = '581' WHERE CDCLASFISC = '11061000';
UPDATE CLASFISCAL SET USR_CODCLF = '582' WHERE CDCLASFISC = '09012100';
UPDATE CLASFISCAL SET USR_CODCLF = '583' WHERE CDCLASFISC = '29096020';
UPDATE CLASFISCAL SET USR_CODCLF = '584' WHERE CDCLASFISC = '39079100';
UPDATE CLASFISCAL SET USR_CODCLF = '585' WHERE CDCLASFISC = '04069090';
UPDATE CLASFISCAL SET USR_CODCLF = '586' WHERE CDCLASFISC = '21039021';
UPDATE CLASFISCAL SET USR_CODCLF = '587' WHERE CDCLASFISC = '82075011';
UPDATE CLASFISCAL SET USR_CODCLF = '588' WHERE CDCLASFISC = '21031010';
UPDATE CLASFISCAL SET USR_CODCLF = '589' WHERE CDCLASFISC = '20089900';
UPDATE CLASFISCAL SET USR_CODCLF = '59' WHERE CDCLASFISC  = '07020000';
UPDATE CLASFISCAL SET USR_CODCLF = '590' WHERE CDCLASFISC = '08132020';
UPDATE CLASFISCAL SET USR_CODCLF = '591' WHERE CDCLASFISC = '61051000';
UPDATE CLASFISCAL SET USR_CODCLF = '592' WHERE CDCLASFISC = '39263000';
UPDATE CLASFISCAL SET USR_CODCLF = '593' WHERE CDCLASFISC = '39191010';
UPDATE CLASFISCAL SET USR_CODCLF = '594' WHERE CDCLASFISC = '11081900';
UPDATE CLASFISCAL SET USR_CODCLF = '595' WHERE CDCLASFISC = '82019000';
UPDATE CLASFISCAL SET USR_CODCLF = '596' WHERE CDCLASFISC = '85392110';
UPDATE CLASFISCAL SET USR_CODCLF = '597' WHERE CDCLASFISC = '21011110';
UPDATE CLASFISCAL SET USR_CODCLF = '598' WHERE CDCLASFISC = '17049020';
UPDATE CLASFISCAL SET USR_CODCLF = '599' WHERE CDCLASFISC = '21011200';
UPDATE CLASFISCAL SET USR_CODCLF = '60' WHERE CDCLASFISC  = '07089000';
UPDATE CLASFISCAL SET USR_CODCLF = '600' WHERE CDCLASFISC = '28092019';
UPDATE CLASFISCAL SET USR_CODCLF = '601' WHERE CDCLASFISC = '20094900';
UPDATE CLASFISCAL SET USR_CODCLF = '602' WHERE CDCLASFISC = '20091100';
UPDATE CLASFISCAL SET USR_CODCLF = '603' WHERE CDCLASFISC = '20098100';
UPDATE CLASFISCAL SET USR_CODCLF = '604' WHERE CDCLASFISC = '87169090';
UPDATE CLASFISCAL SET USR_CODCLF = '605' WHERE CDCLASFISC = '38109000';
UPDATE CLASFISCAL SET USR_CODCLF = '606' WHERE CDCLASFISC = '73071990';
UPDATE CLASFISCAL SET USR_CODCLF = '607' WHERE CDCLASFISC = '82119400';
UPDATE CLASFISCAL SET USR_CODCLF = '608' WHERE CDCLASFISC = '84818093';
UPDATE CLASFISCAL SET USR_CODCLF = '609' WHERE CDCLASFISC = '73079900';
UPDATE CLASFISCAL SET USR_CODCLF = '61' WHERE CDCLASFISC  = '07032090';
UPDATE CLASFISCAL SET USR_CODCLF = '610' WHERE CDCLASFISC = '34039900';
UPDATE CLASFISCAL SET USR_CODCLF = '611' WHERE CDCLASFISC = '34031900';
UPDATE CLASFISCAL SET USR_CODCLF = '612' WHERE CDCLASFISC = '32089039';
UPDATE CLASFISCAL SET USR_CODCLF = '613' WHERE CDCLASFISC = '42031000';
UPDATE CLASFISCAL SET USR_CODCLF = '614' WHERE CDCLASFISC = '38089299';
UPDATE CLASFISCAL SET USR_CODCLF = '615' WHERE CDCLASFISC = '83017000';
UPDATE CLASFISCAL SET USR_CODCLF = '616' WHERE CDCLASFISC = '39162000';
UPDATE CLASFISCAL SET USR_CODCLF = '617' WHERE CDCLASFISC = '85044029';
UPDATE CLASFISCAL SET USR_CODCLF = '618' WHERE CDCLASFISC = '39191090';
UPDATE CLASFISCAL SET USR_CODCLF = '619' WHERE CDCLASFISC = '96033000';
UPDATE CLASFISCAL SET USR_CODCLF = '62' WHERE CDCLASFISC  = '07031019';
UPDATE CLASFISCAL SET USR_CODCLF = '620' WHERE CDCLASFISC = '84824000';
UPDATE CLASFISCAL SET USR_CODCLF = '621' WHERE CDCLASFISC = '39173290';
UPDATE CLASFISCAL SET USR_CODCLF = '622' WHERE CDCLASFISC = '27109100';
UPDATE CLASFISCAL SET USR_CODCLF = '623' WHERE CDCLASFISC = '34021900';
UPDATE CLASFISCAL SET USR_CODCLF = '624' WHERE CDCLASFISC = '76090000';
UPDATE CLASFISCAL SET USR_CODCLF = '625' WHERE CDCLASFISC = '65061000';
UPDATE CLASFISCAL SET USR_CODCLF = '626' WHERE CDCLASFISC = '82023100';
UPDATE CLASFISCAL SET USR_CODCLF = '627' WHERE CDCLASFISC = '39269040';
UPDATE CLASFISCAL SET USR_CODCLF = '628' WHERE CDCLASFISC = '11072020';
UPDATE CLASFISCAL SET USR_CODCLF = '629' WHERE CDCLASFISC = '39232110';
UPDATE CLASFISCAL SET USR_CODCLF = '63' WHERE CDCLASFISC  = '07059990';
UPDATE CLASFISCAL SET USR_CODCLF = '630' WHERE CDCLASFISC = '96170010';
UPDATE CLASFISCAL SET USR_CODCLF = '631' WHERE CDCLASFISC = '96170020';
UPDATE CLASFISCAL SET USR_CODCLF = '632' WHERE CDCLASFISC = '40159000';
UPDATE CLASFISCAL SET USR_CODCLF = '633' WHERE CDCLASFISC = '11090000';
UPDATE CLASFISCAL SET USR_CODCLF = '634' WHERE CDCLASFISC = '85361000';
UPDATE CLASFISCAL SET USR_CODCLF = '635' WHERE CDCLASFISC = '48234000';
UPDATE CLASFISCAL SET USR_CODCLF = '636' WHERE CDCLASFISC = '62034300';
UPDATE CLASFISCAL SET USR_CODCLF = '637' WHERE CDCLASFISC = '61151092';
UPDATE CLASFISCAL SET USR_CODCLF = '638' WHERE CDCLASFISC = '73262000';
UPDATE CLASFISCAL SET USR_CODCLF = '639' WHERE CDCLASFISC = '85392910';
UPDATE CLASFISCAL SET USR_CODCLF = '64' WHERE CDCLASFISC  = '04090000';
UPDATE CLASFISCAL SET USR_CODCLF = '640' WHERE CDCLASFISC = '85392990';
UPDATE CLASFISCAL SET USR_CODCLF = '641' WHERE CDCLASFISC = '39172200';
UPDATE CLASFISCAL SET USR_CODCLF = '642' WHERE CDCLASFISC = '20093900';
UPDATE CLASFISCAL SET USR_CODCLF = '643' WHERE CDCLASFISC = '62101000';
UPDATE CLASFISCAL SET USR_CODCLF = '644' WHERE CDCLASFISC = '39262000';
UPDATE CLASFISCAL SET USR_CODCLF = '645' WHERE CDCLASFISC = '38089419';
UPDATE CLASFISCAL SET USR_CODCLF = '646' WHERE CDCLASFISC = '90211091';
UPDATE CLASFISCAL SET USR_CODCLF = '647' WHERE CDCLASFISC = '11052000';
UPDATE CLASFISCAL SET USR_CODCLF = '648' WHERE CDCLASFISC = '38089919';
UPDATE CLASFISCAL SET USR_CODCLF = '649' WHERE CDCLASFISC = '70132800';
UPDATE CLASFISCAL SET USR_CODCLF = '65' WHERE CDCLASFISC  = '07049000';
UPDATE CLASFISCAL SET USR_CODCLF = '650' WHERE CDCLASFISC = '61142000';
UPDATE CLASFISCAL SET USR_CODCLF = '651' WHERE CDCLASFISC = '44209000';
UPDATE CLASFISCAL SET USR_CODCLF = '652' WHERE CDCLASFISC = '84248221';
UPDATE CLASFISCAL SET USR_CODCLF = '653' WHERE CDCLASFISC = '73051200';
UPDATE CLASFISCAL SET USR_CODCLF = '654' WHERE CDCLASFISC = '64029990';
UPDATE CLASFISCAL SET USR_CODCLF = '655' WHERE CDCLASFISC = '25232100';
UPDATE CLASFISCAL SET USR_CODCLF = '656' WHERE CDCLASFISC = '69074000';
UPDATE CLASFISCAL SET USR_CODCLF = '657' WHERE CDCLASFISC = '25232910';
UPDATE CLASFISCAL SET USR_CODCLF = '658' WHERE CDCLASFISC = '69041000';
UPDATE CLASFISCAL SET USR_CODCLF = '659' WHERE CDCLASFISC = '90200010';
UPDATE CLASFISCAL SET USR_CODCLF = '66' WHERE CDCLASFISC  = '08105000';
UPDATE CLASFISCAL SET USR_CODCLF = '660' WHERE CDCLASFISC = '09021000';
UPDATE CLASFISCAL SET USR_CODCLF = '661' WHERE CDCLASFISC = '44079990';
UPDATE CLASFISCAL SET USR_CODCLF = '662' WHERE CDCLASFISC = '69072200';
UPDATE CLASFISCAL SET USR_CODCLF = '663' WHERE CDCLASFISC = '32041300';
UPDATE CLASFISCAL SET USR_CODCLF = '664' WHERE CDCLASFISC = '31052000';
UPDATE CLASFISCAL SET USR_CODCLF = '665' WHERE CDCLASFISC = '68042190';
UPDATE CLASFISCAL SET USR_CODCLF = '666' WHERE CDCLASFISC = '68118200';
UPDATE CLASFISCAL SET USR_CODCLF = '667' WHERE CDCLASFISC = '85065010';
UPDATE CLASFISCAL SET USR_CODCLF = '668' WHERE CDCLASFISC = '79070090';
UPDATE CLASFISCAL SET USR_CODCLF = '669' WHERE CDCLASFISC = '90283011';
UPDATE CLASFISCAL SET USR_CODCLF = '67' WHERE CDCLASFISC  = '07052900';
UPDATE CLASFISCAL SET USR_CODCLF = '670' WHERE CDCLASFISC = '90282010';
UPDATE CLASFISCAL SET USR_CODCLF = '671' WHERE CDCLASFISC = '06029029';
UPDATE CLASFISCAL SET USR_CODCLF = '672' WHERE CDCLASFISC = '68051000';
UPDATE CLASFISCAL SET USR_CODCLF = '673' WHERE CDCLASFISC = '72103010';
UPDATE CLASFISCAL SET USR_CODCLF = '674' WHERE CDCLASFISC = '73079300';
UPDATE CLASFISCAL SET USR_CODCLF = '675' WHERE CDCLASFISC = '73071920';
UPDATE CLASFISCAL SET USR_CODCLF = '676' WHERE CDCLASFISC = '73041900';
UPDATE CLASFISCAL SET USR_CODCLF = '677' WHERE CDCLASFISC = '73063000';
UPDATE CLASFISCAL SET USR_CODCLF = '678' WHERE CDCLASFISC = '54071019';
UPDATE CLASFISCAL SET USR_CODCLF = '679' WHERE CDCLASFISC = '76151000';
UPDATE CLASFISCAL SET USR_CODCLF = '68' WHERE CDCLASFISC  = '08093020';
UPDATE CLASFISCAL SET USR_CODCLF = '680' WHERE CDCLASFISC = '96035000';
UPDATE CLASFISCAL SET USR_CODCLF = '681' WHERE CDCLASFISC = '82059000';
UPDATE CLASFISCAL SET USR_CODCLF = '682' WHERE CDCLASFISC = '83024200';
UPDATE CLASFISCAL SET USR_CODCLF = '683' WHERE CDCLASFISC = '73239900';
UPDATE CLASFISCAL SET USR_CODCLF = '684' WHERE CDCLASFISC = '73142000';
UPDATE CLASFISCAL SET USR_CODCLF = '685' WHERE CDCLASFISC = '84818092';
UPDATE CLASFISCAL SET USR_CODCLF = '686' WHERE CDCLASFISC = '25309090';
UPDATE CLASFISCAL SET USR_CODCLF = '687' WHERE CDCLASFISC = '72142000';
UPDATE CLASFISCAL SET USR_CODCLF = '688' WHERE CDCLASFISC = '73084000';
UPDATE CLASFISCAL SET USR_CODCLF = '689' WHERE CDCLASFISC = '25051000';
UPDATE CLASFISCAL SET USR_CODCLF = '69' WHERE CDCLASFISC  = '08094000';
UPDATE CLASFISCAL SET USR_CODCLF = '690' WHERE CDCLASFISC = '25171000';
UPDATE CLASFISCAL SET USR_CODCLF = '691' WHERE CDCLASFISC = '82052000';
UPDATE CLASFISCAL SET USR_CODCLF = '70' WHERE CDCLASFISC  = '08045020';
UPDATE CLASFISCAL SET USR_CODCLF = '71' WHERE CDCLASFISC  = '08061000';
UPDATE CLASFISCAL SET USR_CODCLF = '72' WHERE CDCLASFISC  = '07099919';
UPDATE CLASFISCAL SET USR_CODCLF = '73' WHERE CDCLASFISC  = '08045010';
UPDATE CLASFISCAL SET USR_CODCLF = '74' WHERE CDCLASFISC  = '20021000';
UPDATE CLASFISCAL SET USR_CODCLF = '75' WHERE CDCLASFISC  = '20059900';
UPDATE CLASFISCAL SET USR_CODCLF = '76' WHERE CDCLASFISC  = '07039090';
UPDATE CLASFISCAL SET USR_CODCLF = '77' WHERE CDCLASFISC  = '20052000';
UPDATE CLASFISCAL SET USR_CODCLF = '78' WHERE CDCLASFISC  = '08093010';
UPDATE CLASFISCAL SET USR_CODCLF = '79' WHERE CDCLASFISC  = '20041000';
UPDATE CLASFISCAL SET USR_CODCLF = '80' WHERE CDCLASFISC  = '16041410';
UPDATE CLASFISCAL SET USR_CODCLF = '81' WHERE CDCLASFISC  = '20054000';
UPDATE CLASFISCAL SET USR_CODCLF = '82' WHERE CDCLASFISC  = '04022130';
UPDATE CLASFISCAL SET USR_CODCLF = '83' WHERE CDCLASFISC  = '20058000';
UPDATE CLASFISCAL SET USR_CODCLF = '84' WHERE CDCLASFISC  = '20029090';
UPDATE CLASFISCAL SET USR_CODCLF = '85' WHERE CDCLASFISC  = '04029900';
UPDATE CLASFISCAL SET USR_CODCLF = '86' WHERE CDCLASFISC  = '20089300';
UPDATE CLASFISCAL SET USR_CODCLF = '87' WHERE CDCLASFISC  = '20079990';
UPDATE CLASFISCAL SET USR_CODCLF = '88' WHERE CDCLASFISC  = '20031000';
UPDATE CLASFISCAL SET USR_CODCLF = '89' WHERE CDCLASFISC  = '07112020';
UPDATE CLASFISCAL SET USR_CODCLF = '90' WHERE CDCLASFISC  = '04011010';
UPDATE CLASFISCAL SET USR_CODCLF = '91' WHERE CDCLASFISC  = '04014021';
UPDATE CLASFISCAL SET USR_CODCLF = '92' WHERE CDCLASFISC  = '07114000';
UPDATE CLASFISCAL SET USR_CODCLF = '93' WHERE CDCLASFISC  = '17049090';
UPDATE CLASFISCAL SET USR_CODCLF = '94' WHERE CDCLASFISC  = '15091000';
UPDATE CLASFISCAL SET USR_CODCLF = '95' WHERE CDCLASFISC  = '35040020';
UPDATE CLASFISCAL SET USR_CODCLF = '96' WHERE CDCLASFISC  = '22072020';
UPDATE CLASFISCAL SET USR_CODCLF = '97' WHERE CDCLASFISC  = '22042100';
UPDATE CLASFISCAL SET USR_CODCLF = '98' WHERE CDCLASFISC  = '22086000';
UPDATE CLASFISCAL SET USR_CODCLF = '99' WHERE CDCLASFISC  = '21069010';

COMMIT
/

ALTER TABLE NOTAFISCAL
ADD USR_OBSEXPXML VARCHAR2(4000);
/

DROP TRIGGER TRG_NOTAFISCAL
/

CREATE OR REPLACE
TRIGGER USR_EXP_NF AFTER UPDATE ON ITEMPRODUTO
FOR EACH ROW
DECLARE
   V_IDENTRSAIDOP    VARCHAR2(01);
BEGIN
   BEGIN
      SELECT IDENTRSAIDOP
        INTO V_IDENTRSAIDOP
        FROM NOTAFISCAL
       WHERE CDFILIAL   = :OLD.CDFILIAL
         AND NRLANCTONF = :OLD.NRLANCTONF;
   EXCEPTION
      WHEN NO_DATA_FOUND THEN BEGIN
          V_IDENTRSAIDOP := 'N';
      END;
   END;

   IF V_IDENTRSAIDOP = 'E' THEN

      UPDATE NOTAFISCAL
         SET USR_DTEXPXML_ACA = NULL,
             USR_OBSEXPXML    = NULL
       WHERE CDFILIAL   = :OLD.CDFILIAL
         AND NRLANCTONF = :OLD.NRLANCTONF;
   END IF;
END;
/

-- VERSAO --
BEGIN ATUVEROBJ('ATUALIZACAO_ESTRUTURA_BD','6.45.003'); END;
/
