UTIL limpacagada.sql

update rdr1 set 
RDR1.DocEntry = ADO1.DocEntry, 	RDR1.LineNum = ADO1.LineNum, 	RDR1.TargetType = ADO1.TargetType, 	RDR1.TrgetEntry = ADO1.TrgetEntry, 	RDR1.BaseRef = ADO1.BaseRef, 	RDR1.BaseType = ADO1.BaseType, 	RDR1.BaseEntry = ADO1.BaseEntry, 	RDR1.BaseLine = ADO1.BaseLine, 	RDR1.LineStatus = ADO1.LineStatus, 	RDR1.ItemCode = ADO1.ItemCode, 	RDR1.Dscription = ADO1.Dscription, 	RDR1.Quantity = ADO1.Quantity, 	RDR1.ShipDate = ADO1.ShipDate, 	RDR1.OpenQty = ADO1.OpenQty, 	RDR1.Price = ADO1.Price, 	RDR1.Currency = ADO1.Currency, 	RDR1.Rate = ADO1.Rate, 	RDR1.DiscPrcnt = ADO1.DiscPrcnt, 	RDR1.LineTotal = ADO1.LineTotal, 	RDR1.TotalFrgn = ADO1.TotalFrgn, 	RDR1.OpenSum = ADO1.OpenSum, 	RDR1.OpenSumFC = ADO1.OpenSumFC, 	RDR1.VendorNum = ADO1.VendorNum, 	RDR1.SerialNum = ADO1.SerialNum, 	RDR1.WhsCode = ADO1.WhsCode, 	RDR1.SlpCode = ADO1.SlpCode, 	RDR1.Commission = ADO1.Commission, 	RDR1.TreeType = ADO1.TreeType, 	RDR1.AcctCode = ADO1.AcctCode, 	RDR1.TaxStatus = ADO1.TaxStatus, 	RDR1.GrossBuyPr = ADO1.GrossBuyPr, 	RDR1.PriceBefDi = ADO1.PriceBefDi, 	RDR1.DocDate = ADO1.DocDate, 	RDR1.Flags = ADO1.Flags, 	RDR1.OpenCreQty = ADO1.OpenCreQty, 	RDR1.UseBaseUn = ADO1.UseBaseUn, 	RDR1.SubCatNum = ADO1.SubCatNum, 	RDR1.BaseCard = ADO1.BaseCard, 	RDR1.TotalSumSy = ADO1.TotalSumSy, 	RDR1.OpenSumSys = ADO1.OpenSumSys, 	RDR1.InvntSttus = ADO1.InvntSttus, 	RDR1.OcrCode = ADO1.OcrCode, 	RDR1.Project = ADO1.Project, 	RDR1.CodeBars = ADO1.CodeBars, 	RDR1.VatPrcnt = ADO1.VatPrcnt, 	RDR1.VatGroup = ADO1.VatGroup, 	RDR1.PriceAfVAT = ADO1.PriceAfVAT, 	RDR1.Height1 = ADO1.Height1, 	RDR1.Hght1Unit = ADO1.Hght1Unit, 	RDR1.Height2 = ADO1.Height2, 	RDR1.Hght2Unit = ADO1.Hght2Unit, 	RDR1.Width1 = ADO1.Width1, 	RDR1.Wdth1Unit = ADO1.Wdth1Unit, 	RDR1.Width2 = ADO1.Width2, 	RDR1.Wdth2Unit = ADO1.Wdth2Unit, 	RDR1.Length1 = ADO1.Length1, 	RDR1.Len1Unit = ADO1.Len1Unit, 	RDR1.length2 = ADO1.length2, 	RDR1.Len2Unit = ADO1.Len2Unit, 	RDR1.Volume = ADO1.Volume, 	RDR1.VolUnit = ADO1.VolUnit, 	RDR1.Weight1 = ADO1.Weight1, 	RDR1.Wght1Unit = ADO1.Wght1Unit, 	RDR1.Weight2 = ADO1.Weight2, 	RDR1.Wght2Unit = ADO1.Wght2Unit, 	RDR1.Factor1 = ADO1.Factor1, 	RDR1.Factor2 = ADO1.Factor2, 	RDR1.Factor3 = ADO1.Factor3, 	RDR1.Factor4 = ADO1.Factor4, 	RDR1.PackQty = ADO1.PackQty, 	RDR1.UpdInvntry = ADO1.UpdInvntry, 	RDR1.BaseDocNum = ADO1.BaseDocNum, 	RDR1.BaseAtCard = ADO1.BaseAtCard, 	RDR1.SWW = ADO1.SWW, 	RDR1.VatSum = ADO1.VatSum, 	RDR1.VatSumFrgn = ADO1.VatSumFrgn, 	RDR1.VatSumSy = ADO1.VatSumSy, 	RDR1.FinncPriod = ADO1.FinncPriod, 	RDR1.ObjType = ADO1.ObjType, 	RDR1.LogInstanc = ADO1.LogInstanc, 	RDR1.BlockNum = ADO1.BlockNum, 	RDR1.ImportLog = ADO1.ImportLog, 	RDR1.DedVatSum = ADO1.DedVatSum, 	RDR1.DedVatSumF = ADO1.DedVatSumF, 	RDR1.DedVatSumS = ADO1.DedVatSumS, 	RDR1.IsAqcuistn = ADO1.IsAqcuistn, 	RDR1.DistribSum = ADO1.DistribSum, 	RDR1.DstrbSumFC = ADO1.DstrbSumFC, 	RDR1.DstrbSumSC = ADO1.DstrbSumSC, 	RDR1.GrssProfit = ADO1.GrssProfit, 	RDR1.GrssProfSC = ADO1.GrssProfSC, 	RDR1.GrssProfFC = ADO1.GrssProfFC, 	RDR1.VisOrder = ADO1.VisOrder, 	RDR1.INMPrice = ADO1.INMPrice, 	RDR1.PoTrgNum = ADO1.PoTrgNum, 	RDR1.PoTrgEntry = ADO1.PoTrgEntry, 	RDR1.DropShip = ADO1.DropShip, 	RDR1.PoLineNum = ADO1.PoLineNum, 	RDR1.Address = ADO1.Address, 	RDR1.TaxCode = ADO1.TaxCode, 	RDR1.TaxType = ADO1.TaxType, 	RDR1.OrigItem = ADO1.OrigItem, 	RDR1.BackOrdr = ADO1.BackOrdr, 	RDR1.FreeTxt = ADO1.FreeTxt, 	RDR1.PickStatus = ADO1.PickStatus, 	RDR1.PickOty = ADO1.PickOty, 	RDR1.PickIdNo = ADO1.PickIdNo, 	RDR1.TrnsCode = ADO1.TrnsCode, 	RDR1.VatAppld = ADO1.VatAppld, 	RDR1.VatAppldFC = ADO1.VatAppldFC, 	RDR1.VatAppldSC = ADO1.VatAppldSC, 	RDR1.BaseQty = ADO1.BaseQty, 	RDR1.BaseOpnQty = ADO1.BaseOpnQty, 	RDR1.VatDscntPr = ADO1.VatDscntPr, 	RDR1.WtLiable = ADO1.WtLiable, 	RDR1.DeferrTax = ADO1.DeferrTax, 	RDR1.EquVatPer = ADO1.EquVatPer, 	RDR1.EquVatSum = ADO1.EquVatSum, 	RDR1.EquVatSumF = ADO1.EquVatSumF, 	RDR1.EquVatSumS = ADO1.EquVatSumS, 	RDR1.LineVat = ADO1.LineVat, 	RDR1.LineVatlF = ADO1.LineVatlF, 	RDR1.LineVatS = ADO1.LineVatS, 	RDR1.unitMsr = ADO1.unitMsr, 	RDR1.NumPerMsr = ADO1.NumPerMsr, 	RDR1.CEECFlag = ADO1.CEECFlag, 	RDR1.ToStock = ADO1.ToStock, 	RDR1.ToDiff = ADO1.ToDiff, 	RDR1.ExciseAmt = ADO1.ExciseAmt, 	RDR1.TaxPerUnit = ADO1.TaxPerUnit, 	RDR1.TotInclTax = ADO1.TotInclTax, 	RDR1.CountryOrg = ADO1.CountryOrg, 	RDR1.StckDstSum = ADO1.StckDstSum, 	RDR1.ReleasQtty = ADO1.ReleasQtty, 	RDR1.LineType = ADO1.LineType, 	RDR1.TranType = ADO1.TranType, 	RDR1.Text = ADO1.Text, 	RDR1.OwnerCode = ADO1.OwnerCode, 	RDR1.StockPrice = ADO1.StockPrice, 	RDR1.ConsumeFCT = ADO1.ConsumeFCT, 	RDR1.LstByDsSum = ADO1.LstByDsSum, 	RDR1.StckINMPr = ADO1.StckINMPr, 	RDR1.LstBINMPr = ADO1.LstBINMPr, 	RDR1.StckDstFc = ADO1.StckDstFc, 	RDR1.StckDstSc = ADO1.StckDstSc, 	RDR1.LstByDsFc = ADO1.LstByDsFc, 	RDR1.LstByDsSc = ADO1.LstByDsSc, 	RDR1.StockSum = ADO1.StockSum, 	RDR1.StockSumFc = ADO1.StockSumFc, 	RDR1.StockSumSc = ADO1.StockSumSc, 	RDR1.StckSumApp = ADO1.StckSumApp, 	RDR1.StckAppFc = ADO1.StckAppFc, 	RDR1.StckAppSc = ADO1.StckAppSc, 	RDR1.ShipToCode = ADO1.ShipToCode, 	RDR1.ShipToDesc = ADO1.ShipToDesc, 	RDR1.StckAppD = ADO1.StckAppD, 	RDR1.StckAppDFC = ADO1.StckAppDFC, 	RDR1.StckAppDSC = ADO1.StckAppDSC, 	RDR1.BasePrice = ADO1.BasePrice, 	RDR1.GTotal = ADO1.GTotal, 	RDR1.GTotalFC = ADO1.GTotalFC, 	RDR1.GTotalSC = ADO1.GTotalSC, 	RDR1.DistribExp = ADO1.DistribExp, 	RDR1.DescOW = ADO1.DescOW, 	RDR1.DetailsOW = ADO1.DetailsOW, 	RDR1.GrossBase = ADO1.GrossBase, 	RDR1.VatWoDpm = ADO1.VatWoDpm, 	RDR1.VatWoDpmFc = ADO1.VatWoDpmFc, 	RDR1.VatWoDpmSc = ADO1.VatWoDpmSc, 	RDR1.CFOPCode = ADO1.CFOPCode, 	RDR1.CSTCode = ADO1.CSTCode, 	RDR1.Usage = ADO1.Usage, 	RDR1.TaxOnly = ADO1.TaxOnly, 	RDR1.WtCalced = ADO1.WtCalced, 	RDR1.QtyToShip = ADO1.QtyToShip, 	RDR1.DelivrdQty = ADO1.DelivrdQty, 	RDR1.OrderedQty = ADO1.OrderedQty, 	RDR1.CogsOcrCod = ADO1.CogsOcrCod, 	RDR1.CiOppLineN = ADO1.CiOppLineN, 	RDR1.CogsAcct = ADO1.CogsAcct, 	RDR1.ChgAsmBoMW = ADO1.ChgAsmBoMW, 	RDR1.ActDelDate = ADO1.ActDelDate, 	RDR1.OcrCode2 = ADO1.OcrCode2, 	RDR1.OcrCode3 = ADO1.OcrCode3, 	RDR1.OcrCode4 = ADO1.OcrCode4, 	RDR1.OcrCode5 = ADO1.OcrCode5, 	RDR1.TaxDistSum = ADO1.TaxDistSum, 	RDR1.TaxDistSFC = ADO1.TaxDistSFC, 	RDR1.TaxDistSSC = ADO1.TaxDistSSC, 	RDR1.PostTax = ADO1.PostTax, 	RDR1.Excisable = ADO1.Excisable, 	RDR1.AssblValue = ADO1.AssblValue, 	RDR1.RG23APart1 = ADO1.RG23APart1, 	RDR1.RG23APart2 = ADO1.RG23APart2, 	RDR1.RG23CPart1 = ADO1.RG23CPart1, 	RDR1.RG23CPart2 = ADO1.RG23CPart2, 	RDR1.CogsOcrCo2 = ADO1.CogsOcrCo2, 	RDR1.CogsOcrCo3 = ADO1.CogsOcrCo3, 	RDR1.CogsOcrCo4 = ADO1.CogsOcrCo4, 	RDR1.CogsOcrCo5 = ADO1.CogsOcrCo5, 	RDR1.LnExcised = ADO1.LnExcised, 	RDR1.LocCode = ADO1.LocCode, 	RDR1.StockValue = ADO1.StockValue, 	RDR1.GPTtlBasPr = ADO1.GPTtlBasPr, 	RDR1.unitMsr2 = ADO1.unitMsr2, 	RDR1.NumPerMsr2 = ADO1.NumPerMsr2, 	RDR1.SpecPrice = ADO1.SpecPrice, 	RDR1.CSTfIPI = ADO1.CSTfIPI, 	RDR1.CSTfPIS = ADO1.CSTfPIS, 	RDR1.CSTfCOFINS = ADO1.CSTfCOFINS, 	RDR1.ExLineNo = ADO1.ExLineNo, 	RDR1.isSrvCall = ADO1.isSrvCall, 	RDR1.PQTReqQty = ADO1.PQTReqQty, 	RDR1.PQTReqDate = ADO1.PQTReqDate, 	RDR1.PcDocType = ADO1.PcDocType, 	RDR1.PcQuantity = ADO1.PcQuantity, 	RDR1.LinManClsd = ADO1.LinManClsd, 	RDR1.VatGrpSrc = ADO1.VatGrpSrc, 	RDR1.NoInvtryMv = ADO1.NoInvtryMv, 	RDR1.ActBaseEnt = ADO1.ActBaseEnt, 	RDR1.ActBaseLn = ADO1.ActBaseLn, 	RDR1.ActBaseNum = ADO1.ActBaseNum, 	RDR1.OpenRtnQty = ADO1.OpenRtnQty, 	RDR1.AgrNo = ADO1.AgrNo, 	RDR1.AgrLnNum = ADO1.AgrLnNum, 	RDR1.CredOrigin = ADO1.CredOrigin, 	RDR1.Surpluses = ADO1.Surpluses, 	RDR1.DefBreak = ADO1.DefBreak, 	RDR1.Shortages = ADO1.Shortages, 	RDR1.UomEntry = ADO1.UomEntry, 	RDR1.UomEntry2 = ADO1.UomEntry2, 	RDR1.UomCode = ADO1.UomCode, 	RDR1.UomCode2 = ADO1.UomCode2, 	RDR1.FromWhsCod = ADO1.FromWhsCod, 	RDR1.NeedQty = ADO1.NeedQty, 	RDR1.PartRetire = ADO1.PartRetire, 	RDR1.RetireQty = ADO1.RetireQty, 	RDR1.RetireAPC = ADO1.RetireAPC, 	RDR1.RetirAPCFC = ADO1.RetirAPCFC, 	RDR1.RetirAPCSC = ADO1.RetirAPCSC, 	RDR1.InvQty = ADO1.InvQty, 	RDR1.OpenInvQty = ADO1.OpenInvQty, 	RDR1.EnSetCost = ADO1.EnSetCost, 	RDR1.RetCost = ADO1.RetCost, 	RDR1.Incoterms = ADO1.Incoterms, 	RDR1.TransMod = ADO1.TransMod, 	RDR1.LineVendor = ADO1.LineVendor, 	RDR1.DistribIS = ADO1.DistribIS, 	RDR1.ISDistrb = ADO1.ISDistrb, 	RDR1.ISDistrbFC = ADO1.ISDistrbFC, 	RDR1.ISDistrbSC = ADO1.ISDistrbSC, 	RDR1.LinePoPrss = ADO1.LinePoPrss, 	RDR1.FreeChrgBP = ADO1.FreeChrgBP, 	RDR1.LegalText = ADO1.LegalText, 	RDR1.TaxRelev = ADO1.TaxRelev, 	RDR1.U_addedClFiscal = ADO1.U_addedClFiscal, 	RDR1.U_addedCCusto = ADO1.U_addedCCusto, 	RDR1.U_addedAtivo = ADO1.U_addedAtivo, 	RDR1.U_addedAPartirDe = ADO1.U_addedAPartirDe, 	RDR1.U_addedQtParc = ADO1.U_addedQtParc, 	RDR1.U_addedGeradas = ADO1.U_addedGeradas, 	RDR1.U_TIPOOP = ADO1.U_TIPOOP, 	RDR1.U_addedHistPPB = ADO1.U_addedHistPPB, 	RDR1.U_addedMoeda = ADO1.U_addedMoeda, 	RDR1.U_addedRate = ADO1.U_addedRate, 	RDR1.U_addedCusto = ADO1.U_addedCusto, 	RDR1.U_addedIcmCusto = ADO1.U_addedIcmCusto, 	RDR1.U_addedIcmSTCusto = ADO1.U_addedIcmSTCusto, 	RDR1.U_addedIpiCusto = ADO1.U_addedIpiCusto, 	RDR1.U_addedTxImpos = ADO1.U_addedTxImpos, 	RDR1.U_addedValidade = ADO1.U_addedValidade, 	RDR1.U_addedUsuario = ADO1.U_addedUsuario, 	RDR1.U_addedRespons = ADO1.U_addedRespons, 	RDR1.U_addedFornCot = ADO1.U_addedFornCot, 	RDR1.U_addedImporDe = ADO1.U_addedImporDe, 	RDR1.U_addedSomCota = ADO1.U_addedSomCota, 	RDR1.U_addedObserva = ADO1.U_addedObserva, 	RDR1.U_addedComFrete = ADO1.U_addedComFrete, 	RDR1.U_addedComTaxa1 = ADO1.U_addedComTaxa1, 	RDR1.U_addedComTaxa2 = ADO1.U_addedComTaxa2, 	RDR1.U_addedComTaxa3 = ADO1.U_addedComTaxa3, 	RDR1.U_IdRegra = ADO1.U_IdRegra, 	RDR1.U_CustoComis = ADO1.U_CustoComis, 	RDR1.U_addedMargem = ADO1.U_addedMargem, 	RDR1.U_addedComTotal = ADO1.U_addedComTotal, 	RDR1.U_IdMargem = ADO1.U_IdMargem, 	RDR1.U_addedIdContrato = ADO1.U_addedIdContrato, 	RDR1.U_CSTIPI = ADO1.U_CSTIPI, 	RDR1.U_CSTPIS = ADO1.U_CSTPIS, 	RDR1.U_CSTCOFINS = ADO1.U_CSTCOFINS, 	RDR1.U_SKILL_QT = ADO1.U_SKILL_QT, 	RDR1.U_SKILL_UT = ADO1.U_SKILL_UT, 	RDR1.U_addedTaxCode = ADO1.U_addedTaxCode, 	RDR1.U_addedDescAdic = ADO1.U_addedDescAdic, 	RDR1.U_addedDescCont = ADO1.U_addedDescCont, 	RDR1.U_addedCustoImpo = ADO1.U_addedCustoImpo, 	RDR1.U_SKILL_CompBas = ADO1.U_SKILL_CompBas, 	RDR1.U_SKILL_MDI = ADO1.U_SKILL_MDI, 	RDR1.U_SKILL_NP = ADO1.U_SKILL_NP, 	RDR1.U_SKILL_IP = ADO1.U_SKILL_IP, 	RDR1.U_NAT_BC_CRED = ADO1.U_NAT_BC_CRED, 	RDR1.U_COD_TOT_PAR = ADO1.U_COD_TOT_PAR, 	RDR1.U_COD_MUN_ORIG = ADO1.U_COD_MUN_ORIG, 	RDR1.U_COD_MUN_DEST = ADO1.U_COD_MUN_DEST, 	RDR1.U_VEIC_ID = ADO1.U_VEIC_ID, 	RDR1.U_UF_ID = ADO1.U_UF_ID, 	RDR1.U_B1SYS_IVAST = ADO1.U_B1SYS_IVAST, 	RDR1.U_B1SYS_TaxUoM = ADO1.U_B1SYS_TaxUoM, 	RDR1.U_B1SYS_QtyPerTaxUoM = ADO1.U_B1SYS_QtyPerTaxUoM, 	RDR1.U_nr_Tot = ADO1.U_nr_Tot, 	RDR1.U_SKILL_TotTribIBPT = ADO1.U_SKILL_TotTribIBPT, 	RDR1.U_pDevol = ADO1.U_pDevol, 	RDR1.U_SKILL_NVE = ADO1.U_SKILL_NVE, 	RDR1.U_SKILL_nRECOPI = ADO1.U_SKILL_nRECOPI, 	RDR1.U_SKILL_InfAdItem = ADO1.U_SKILL_InfAdItem, 	RDR1.U_OKS_BSREF = ADO1.U_OKS_BSREF, 	RDR1.U_IncFiscal = ADO1.U_IncFiscal, 	RDR1.U_nProcesso = ADO1.U_nProcesso, 	RDR1.U_OKS_BSDEV = ADO1.U_OKS_BSDEV
from ADO1 
where Ado1.DocEntry = Rdr1.DocEntry and ADO1.LineNum = rdr1.LineNum and RDR1.DocEntry = 498 and Ado1.ObjType = RDR1.ObjType

update ORDR Set
ORDR.DocEntry = ADOC.DocEntry, 	ORDR.DocNum = ADOC.DocNum, 	ORDR.DocType = ADOC.DocType, 	ORDR.CANCELED = ADOC.CANCELED, 	ORDR.Handwrtten = ADOC.Handwrtten, 	ORDR.Printed = ADOC.Printed, 	ORDR.DocStatus = ADOC.DocStatus, 	ORDR.InvntSttus = ADOC.InvntSttus, 	ORDR.Transfered = ADOC.Transfered, 	ORDR.ObjType = ADOC.ObjType, 	ORDR.DocDate = ADOC.DocDate, 	ORDR.DocDueDate = ADOC.DocDueDate, 	ORDR.CardCode = ADOC.CardCode, 	ORDR.CardName = ADOC.CardName, 	ORDR.Address = ADOC.Address, 	ORDR.NumAtCard = ADOC.NumAtCard, 	ORDR.VatPercent = ADOC.VatPercent, 	ORDR.VatSum = ADOC.VatSum, 	ORDR.VatSumFC = ADOC.VatSumFC, 	ORDR.DiscPrcnt = ADOC.DiscPrcnt, 	ORDR.DiscSum = ADOC.DiscSum, 	ORDR.DiscSumFC = ADOC.DiscSumFC, 	ORDR.DocCur = ADOC.DocCur, 	ORDR.DocRate = ADOC.DocRate, 	ORDR.DocTotal = ADOC.DocTotal, 	ORDR.DocTotalFC = ADOC.DocTotalFC, 	ORDR.PaidToDate = ADOC.PaidToDate, 	ORDR.PaidFC = ADOC.PaidFC, 	ORDR.GrosProfit = ADOC.GrosProfit, 	ORDR.GrosProfFC = ADOC.GrosProfFC, 	ORDR.Ref1 = ADOC.Ref1, 	ORDR.Ref2 = ADOC.Ref2, 	ORDR.Comments = ADOC.Comments, 	ORDR.JrnlMemo = ADOC.JrnlMemo, 	ORDR.TransId = ADOC.TransId, 	ORDR.ReceiptNum = ADOC.ReceiptNum, 	ORDR.GroupNum = ADOC.GroupNum, 	ORDR.DocTime = ADOC.DocTime, 	ORDR.SlpCode = ADOC.SlpCode, 	ORDR.TrnspCode = ADOC.TrnspCode, 	ORDR.PartSupply = ADOC.PartSupply, 	ORDR.Confirmed = ADOC.Confirmed, 	ORDR.GrossBase = ADOC.GrossBase, 	ORDR.ImportEnt = ADOC.ImportEnt, 	ORDR.CreateTran = ADOC.CreateTran, 	ORDR.SummryType = ADOC.SummryType, 	ORDR.UpdInvnt = ADOC.UpdInvnt, 	ORDR.UpdCardBal = ADOC.UpdCardBal, 	ORDR.Instance = ADOC.Instance, 	ORDR.Flags = ADOC.Flags, 	ORDR.InvntDirec = ADOC.InvntDirec, 	ORDR.CntctCode = ADOC.CntctCode, 	ORDR.ShowSCN = ADOC.ShowSCN, 	ORDR.FatherCard = ADOC.FatherCard, 	ORDR.SysRate = ADOC.SysRate, 	ORDR.CurSource = ADOC.CurSource, 	ORDR.VatSumSy = ADOC.VatSumSy, 	ORDR.DiscSumSy = ADOC.DiscSumSy, 	ORDR.DocTotalSy = ADOC.DocTotalSy, 	ORDR.PaidSys = ADOC.PaidSys, 	ORDR.FatherType = ADOC.FatherType, 	ORDR.GrosProfSy = ADOC.GrosProfSy, 	ORDR.UpdateDate = ADOC.UpdateDate, 	ORDR.IsICT = ADOC.IsICT, 	ORDR.CreateDate = ADOC.CreateDate, 	ORDR.Volume = ADOC.Volume, 	ORDR.VolUnit = ADOC.VolUnit, 	ORDR.Weight = ADOC.Weight, 	ORDR.WeightUnit = ADOC.WeightUnit, 	ORDR.Series = ADOC.Series, 	ORDR.TaxDate = ADOC.TaxDate, 	ORDR.Filler = ADOC.Filler, 	ORDR.DataSource = ADOC.DataSource, 	ORDR.StampNum = ADOC.StampNum, 	ORDR.isCrin = ADOC.isCrin, 	ORDR.FinncPriod = ADOC.FinncPriod, 	ORDR.UserSign = ADOC.UserSign, 	ORDR.selfInv = ADOC.selfInv, 	ORDR.VatPaid = ADOC.VatPaid, 	ORDR.VatPaidFC = ADOC.VatPaidFC, 	ORDR.VatPaidSys = ADOC.VatPaidSys, 	ORDR.UserSign2 = ADOC.UserSign2, 	ORDR.WddStatus = ADOC.WddStatus, 	ORDR.draftKey = ADOC.draftKey, 	ORDR.TotalExpns = ADOC.TotalExpns, 	ORDR.TotalExpFC = ADOC.TotalExpFC, 	ORDR.TotalExpSC = ADOC.TotalExpSC, 	ORDR.DunnLevel = ADOC.DunnLevel, 	ORDR.Address2 = ADOC.Address2, 	ORDR.LogInstanc = ADOC.LogInstanc, 	ORDR.Exported = ADOC.Exported, 	ORDR.StationID = ADOC.StationID, 	ORDR.Indicator = ADOC.Indicator, 	ORDR.NetProc = ADOC.NetProc, 	ORDR.AqcsTax = ADOC.AqcsTax, 	ORDR.AqcsTaxFC = ADOC.AqcsTaxFC, 	ORDR.AqcsTaxSC = ADOC.AqcsTaxSC, 	ORDR.CashDiscPr = ADOC.CashDiscPr, 	ORDR.CashDiscnt = ADOC.CashDiscnt, 	ORDR.CashDiscFC = ADOC.CashDiscFC, 	ORDR.CashDiscSC = ADOC.CashDiscSC, 	ORDR.ShipToCode = ADOC.ShipToCode, 	ORDR.LicTradNum = ADOC.LicTradNum, 	ORDR.PaymentRef = ADOC.PaymentRef, 	ORDR.WTSum = ADOC.WTSum, 	ORDR.WTSumFC = ADOC.WTSumFC, 	ORDR.WTSumSC = ADOC.WTSumSC, 	ORDR.RoundDif = ADOC.RoundDif, 	ORDR.RoundDifFC = ADOC.RoundDifFC, 	ORDR.RoundDifSy = ADOC.RoundDifSy, 	ORDR.CheckDigit = ADOC.CheckDigit, 	ORDR.Form1099 = ADOC.Form1099, 	ORDR.Box1099 = ADOC.Box1099, 	ORDR.submitted = ADOC.submitted, 	ORDR.PoPrss = ADOC.PoPrss, 	ORDR.Rounding = ADOC.Rounding, 	ORDR.RevisionPo = ADOC.RevisionPo, 	ORDR.Segment = ADOC.Segment, 	ORDR.ReqDate = ADOC.ReqDate, 	ORDR.CancelDate = ADOC.CancelDate, 	ORDR.PickStatus = ADOC.PickStatus, 	ORDR.Pick = ADOC.Pick, 	ORDR.BlockDunn = ADOC.BlockDunn, 	ORDR.PeyMethod = ADOC.PeyMethod, 	ORDR.PayBlock = ADOC.PayBlock, 	ORDR.PayBlckRef = ADOC.PayBlckRef, 	ORDR.MaxDscn = ADOC.MaxDscn, 	ORDR.Reserve = ADOC.Reserve, 	ORDR.Max1099 = ADOC.Max1099, 	ORDR.CntrlBnk = ADOC.CntrlBnk, 	ORDR.PickRmrk = ADOC.PickRmrk, 	ORDR.ISRCodLine = ADOC.ISRCodLine, 	ORDR.ExpAppl = ADOC.ExpAppl, 	ORDR.ExpApplFC = ADOC.ExpApplFC, 	ORDR.ExpApplSC = ADOC.ExpApplSC, 	ORDR.Project = ADOC.Project, 	ORDR.DeferrTax = ADOC.DeferrTax, 	ORDR.LetterNum = ADOC.LetterNum, 	ORDR.FromDate = ADOC.FromDate, 	ORDR.ToDate = ADOC.ToDate, 	ORDR.WTApplied = ADOC.WTApplied, 	ORDR.WTAppliedF = ADOC.WTAppliedF, 	ORDR.BoeReserev = ADOC.BoeReserev, 	ORDR.AgentCode = ADOC.AgentCode, 	ORDR.WTAppliedS = ADOC.WTAppliedS, 	ORDR.EquVatSum = ADOC.EquVatSum, 	ORDR.EquVatSumF = ADOC.EquVatSumF, 	ORDR.EquVatSumS = ADOC.EquVatSumS, 	ORDR.Installmnt = ADOC.Installmnt, 	ORDR.VATFirst = ADOC.VATFirst, 	ORDR.NnSbAmnt = ADOC.NnSbAmnt, 	ORDR.NnSbAmntSC = ADOC.NnSbAmntSC, 	ORDR.NbSbAmntFC = ADOC.NbSbAmntFC, 	ORDR.ExepAmnt = ADOC.ExepAmnt, 	ORDR.ExepAmntSC = ADOC.ExepAmntSC, 	ORDR.ExepAmntFC = ADOC.ExepAmntFC, 	ORDR.VatDate = ADOC.VatDate, 	ORDR.CorrExt = ADOC.CorrExt, 	ORDR.CorrInv = ADOC.CorrInv, 	ORDR.NCorrInv = ADOC.NCorrInv, 	ORDR.CEECFlag = ADOC.CEECFlag, 	ORDR.BaseAmnt = ADOC.BaseAmnt, 	ORDR.BaseAmntSC = ADOC.BaseAmntSC, 	ORDR.BaseAmntFC = ADOC.BaseAmntFC, 	ORDR.CtlAccount = ADOC.CtlAccount, 	ORDR.BPLId = ADOC.BPLId, 	ORDR.BPLName = ADOC.BPLName, 	ORDR.VATRegNum = ADOC.VATRegNum, 	ORDR.TxInvRptNo = ADOC.TxInvRptNo, 	ORDR.TxInvRptDt = ADOC.TxInvRptDt, 	ORDR.KVVATCode = ADOC.KVVATCode, 	ORDR.WTDetails = ADOC.WTDetails, 	ORDR.SumAbsId = ADOC.SumAbsId, 	ORDR.SumRptDate = ADOC.SumRptDate, 	ORDR.PIndicator = ADOC.PIndicator, 	ORDR.ManualNum = ADOC.ManualNum, 	ORDR.UseShpdGd = ADOC.UseShpdGd, 	ORDR.BaseVtAt = ADOC.BaseVtAt, 	ORDR.BaseVtAtSC = ADOC.BaseVtAtSC, 	ORDR.BaseVtAtFC = ADOC.BaseVtAtFC, 	ORDR.NnSbVAt = ADOC.NnSbVAt, 	ORDR.NnSbVAtSC = ADOC.NnSbVAtSC, 	ORDR.NbSbVAtFC = ADOC.NbSbVAtFC, 	ORDR.ExptVAt = ADOC.ExptVAt, 	ORDR.ExptVAtSC = ADOC.ExptVAtSC, 	ORDR.ExptVAtFC = ADOC.ExptVAtFC, 	ORDR.LYPmtAt = ADOC.LYPmtAt, 	ORDR.LYPmtAtSC = ADOC.LYPmtAtSC, 	ORDR.LYPmtAtFC = ADOC.LYPmtAtFC, 	ORDR.ExpAnSum = ADOC.ExpAnSum, 	ORDR.ExpAnSys = ADOC.ExpAnSys, 	ORDR.ExpAnFrgn = ADOC.ExpAnFrgn, 	ORDR.DocSubType = ADOC.DocSubType, 	ORDR.DpmStatus = ADOC.DpmStatus, 	ORDR.DpmAmnt = ADOC.DpmAmnt, 	ORDR.DpmAmntSC = ADOC.DpmAmntSC, 	ORDR.DpmAmntFC = ADOC.DpmAmntFC, 	ORDR.DpmDrawn = ADOC.DpmDrawn, 	ORDR.DpmPrcnt = ADOC.DpmPrcnt, 	ORDR.PaidSum = ADOC.PaidSum, 	ORDR.PaidSumFc = ADOC.PaidSumFc, 	ORDR.PaidSumSc = ADOC.PaidSumSc, 	ORDR.FolioPref = ADOC.FolioPref, 	ORDR.FolioNum = ADOC.FolioNum, 	ORDR.DpmAppl = ADOC.DpmAppl, 	ORDR.DpmApplFc = ADOC.DpmApplFc, 	ORDR.DpmApplSc = ADOC.DpmApplSc, 	ORDR.LPgFolioN = ADOC.LPgFolioN, 	ORDR.Header = ADOC.Header, 	ORDR.Footer = ADOC.Footer, 	ORDR.Posted = ADOC.Posted, 	ORDR.OwnerCode = ADOC.OwnerCode, 	ORDR.BPChCode = ADOC.BPChCode, 	ORDR.BPChCntc = ADOC.BPChCntc, 	ORDR.PayToCode = ADOC.PayToCode, 	ORDR.IsPaytoBnk = ADOC.IsPaytoBnk, 	ORDR.BnkCntry = ADOC.BnkCntry, 	ORDR.BankCode = ADOC.BankCode, 	ORDR.BnkAccount = ADOC.BnkAccount, 	ORDR.BnkBranch = ADOC.BnkBranch, 	ORDR.isIns = ADOC.isIns, 	ORDR.TrackNo = ADOC.TrackNo, 	ORDR.VersionNum = ADOC.VersionNum, 	ORDR.LangCode = ADOC.LangCode, 	ORDR.BPNameOW = ADOC.BPNameOW, 	ORDR.BillToOW = ADOC.BillToOW, 	ORDR.ShipToOW = ADOC.ShipToOW, 	ORDR.RetInvoice = ADOC.RetInvoice, 	ORDR.ClsDate = ADOC.ClsDate, 	ORDR.MInvNum = ADOC.MInvNum, 	ORDR.MInvDate = ADOC.MInvDate, 	ORDR.SeqCode = ADOC.SeqCode, 	ORDR.Serial = ADOC.Serial, 	ORDR.SeriesStr = ADOC.SeriesStr, 	ORDR.SubStr = ADOC.SubStr, 	ORDR.Model = ADOC.Model, 	ORDR.TaxOnExp = ADOC.TaxOnExp, 	ORDR.TaxOnExpFc = ADOC.TaxOnExpFc, 	ORDR.TaxOnExpSc = ADOC.TaxOnExpSc, 	ORDR.TaxOnExAp = ADOC.TaxOnExAp, 	ORDR.TaxOnExApF = ADOC.TaxOnExApF, 	ORDR.TaxOnExApS = ADOC.TaxOnExApS, 	ORDR.LastPmnTyp = ADOC.LastPmnTyp, 	ORDR.LndCstNum = ADOC.LndCstNum, 	ORDR.UseCorrVat = ADOC.UseCorrVat, 	ORDR.BlkCredMmo = ADOC.BlkCredMmo, 	ORDR.OpenForLaC = ADOC.OpenForLaC, 	ORDR.Excised = ADOC.Excised, 	ORDR.ExcRefDate = ADOC.ExcRefDate, 	ORDR.ExcRmvTime = ADOC.ExcRmvTime, 	ORDR.SrvGpPrcnt = ADOC.SrvGpPrcnt, 	ORDR.DepositNum = ADOC.DepositNum, 	ORDR.CertNum = ADOC.CertNum, 	ORDR.DutyStatus = ADOC.DutyStatus, 	ORDR.AutoCrtFlw = ADOC.AutoCrtFlw, 	ORDR.FlwRefDate = ADOC.FlwRefDate, 	ORDR.FlwRefNum = ADOC.FlwRefNum, 	ORDR.VatJENum = ADOC.VatJENum, 	ORDR.DpmVat = ADOC.DpmVat, 	ORDR.DpmVatFc = ADOC.DpmVatFc, 	ORDR.DpmVatSc = ADOC.DpmVatSc, 	ORDR.DpmAppVat = ADOC.DpmAppVat, 	ORDR.DpmAppVatF = ADOC.DpmAppVatF, 	ORDR.DpmAppVatS = ADOC.DpmAppVatS, 	ORDR.InsurOp347 = ADOC.InsurOp347, 	ORDR.IgnRelDoc = ADOC.IgnRelDoc, 	ORDR.BuildDesc = ADOC.BuildDesc, 	ORDR.ResidenNum = ADOC.ResidenNum, 	ORDR.Checker = ADOC.Checker, 	ORDR.Payee = ADOC.Payee, 	ORDR.CopyNumber = ADOC.CopyNumber, 	ORDR.SSIExmpt = ADOC.SSIExmpt, 	ORDR.PQTGrpSer = ADOC.PQTGrpSer, 	ORDR.PQTGrpNum = ADOC.PQTGrpNum, 	ORDR.PQTGrpHW = ADOC.PQTGrpHW, 	ORDR.ReopOriDoc = ADOC.ReopOriDoc, 	ORDR.ReopManCls = ADOC.ReopManCls, 	ORDR.DocManClsd = ADOC.DocManClsd, 	ORDR.ClosingOpt = ADOC.ClosingOpt, 	ORDR.SpecDate = ADOC.SpecDate, 	ORDR.Ordered = ADOC.Ordered, 	ORDR.NTSApprov = ADOC.NTSApprov, 	ORDR.NTSWebSite = ADOC.NTSWebSite, 	ORDR.NTSeTaxNo = ADOC.NTSeTaxNo, 	ORDR.NTSApprNo = ADOC.NTSApprNo, 	ORDR.PayDuMonth = ADOC.PayDuMonth, 	ORDR.ExtraMonth = ADOC.ExtraMonth, 	ORDR.ExtraDays = ADOC.ExtraDays, 	ORDR.CdcOffset = ADOC.CdcOffset, 	ORDR.SignMsg = ADOC.SignMsg, 	ORDR.SignDigest = ADOC.SignDigest, 	ORDR.CertifNum = ADOC.CertifNum, 	ORDR.KeyVersion = ADOC.KeyVersion, 	ORDR.EDocGenTyp = ADOC.EDocGenTyp, 	ORDR.ESeries = ADOC.ESeries, 	ORDR.EDocNum = ADOC.EDocNum, 	ORDR.EDocExpFrm = ADOC.EDocExpFrm, 	ORDR.OnlineQuo = ADOC.OnlineQuo, 	ORDR.POSEqNum = ADOC.POSEqNum, 	ORDR.POSManufSN = ADOC.POSManufSN, 	ORDR.POSCashN = ADOC.POSCashN, 	ORDR.EDocStatus = ADOC.EDocStatus, 	ORDR.EDocCntnt = ADOC.EDocCntnt, 	ORDR.EDocProces = ADOC.EDocProces, 	ORDR.EDocErrCod = ADOC.EDocErrCod, 	ORDR.EDocErrMsg = ADOC.EDocErrMsg, 	ORDR.EDocCancel = ADOC.EDocCancel, 	ORDR.EDocTest = ADOC.EDocTest, 	ORDR.EDocPrefix = ADOC.EDocPrefix, 	ORDR.CUP = ADOC.CUP, 	ORDR.CIG = ADOC.CIG, 	ORDR.DpmAsDscnt = ADOC.DpmAsDscnt, 	ORDR.Attachment = ADOC.Attachment, 	ORDR.AtcEntry = ADOC.AtcEntry, 	ORDR.SupplCode = ADOC.SupplCode, 	ORDR.GTSRlvnt = ADOC.GTSRlvnt, 	ORDR.BaseDisc = ADOC.BaseDisc, 	ORDR.BaseDiscSc = ADOC.BaseDiscSc, 	ORDR.BaseDiscFc = ADOC.BaseDiscFc, 	ORDR.BaseDiscPr = ADOC.BaseDiscPr, 	ORDR.CreateTS = ADOC.CreateTS, 	ORDR.UpdateTS = ADOC.UpdateTS, 	ORDR.SrvTaxRule = ADOC.SrvTaxRule, 	ORDR.AnnInvDecR = ADOC.AnnInvDecR, 	ORDR.Supplier = ADOC.Supplier, 	ORDR.Releaser = ADOC.Releaser, 	ORDR.Receiver = ADOC.Receiver, 	ORDR.ToWhsCode = ADOC.ToWhsCode, 	ORDR.AssetDate = ADOC.AssetDate, 	ORDR.Requester = ADOC.Requester, 	ORDR.ReqName = ADOC.ReqName, 	ORDR.Branch = ADOC.Branch, 	ORDR.Department = ADOC.Department, 	ORDR.Email = ADOC.Email, 	ORDR.Notify = ADOC.Notify, 	ORDR.ReqType = ADOC.ReqType, 	ORDR.OriginType = ADOC.OriginType, 	ORDR.IsReuseNum = ADOC.IsReuseNum, 	ORDR.IsReuseNFN = ADOC.IsReuseNFN, 	ORDR.DocDlvry = ADOC.DocDlvry, 	ORDR.PaidDpm = ADOC.PaidDpm, 	ORDR.PaidDpmF = ADOC.PaidDpmF, 	ORDR.PaidDpmS = ADOC.PaidDpmS, 	ORDR.EnvTypeNFe = ADOC.EnvTypeNFe, 	ORDR.AgrNo = ADOC.AgrNo, 	ORDR.IsAlt = ADOC.IsAlt, 	ORDR.AltBaseTyp = ADOC.AltBaseTyp, 	ORDR.AltBaseEnt = ADOC.AltBaseEnt, 	ORDR.AuthCode = ADOC.AuthCode, 	ORDR.StDlvDate = ADOC.StDlvDate, 	ORDR.StDlvTime = ADOC.StDlvTime, 	ORDR.EndDlvDate = ADOC.EndDlvDate, 	ORDR.EndDlvTime = ADOC.EndDlvTime, 	ORDR.VclPlate = ADOC.VclPlate, 	ORDR.ElCoStatus = ADOC.ElCoStatus, 	ORDR.AtDocType = ADOC.AtDocType, 	ORDR.ElCoMsg = ADOC.ElCoMsg, 	ORDR.PrintSEPA = ADOC.PrintSEPA, 	ORDR.FreeChrg = ADOC.FreeChrg, 	ORDR.FreeChrgFC = ADOC.FreeChrgFC, 	ORDR.FreeChrgSC = ADOC.FreeChrgSC, 	ORDR.NfeValue = ADOC.NfeValue, 	ORDR.FiscDocNum = ADOC.FiscDocNum, 	ORDR.CCDEntry = ADOC.CCDEntry, 	ORDR.U_TIPOOP = ADOC.U_TIPOOP, 	ORDR.U_ClassFiscal = ADOC.U_ClassFiscal, 	ORDR.U_Cfop = ADOC.U_Cfop, 	ORDR.U_Natope = ADOC.U_Natope, 	ORDR.U_DescServ = ADOC.U_DescServ, 	ORDR.U_VlServic = ADOC.U_VlServic, 	ORDR.U_VlISS = ADOC.U_VlISS, 	ORDR.U_VlProdut = ADOC.U_VlProdut, 	ORDR.U_Frete = ADOC.U_Frete, 	ORDR.U_VDPNCOD = ADOC.U_VDPNCOD, 	ORDR.U_VDPNNOME = ADOC.U_VDPNNOME, 	ORDR.U_VDNF = ADOC.U_VDNF, 	ORDR.U_addedIdContrato = ADOC.U_addedIdContrato, 	ORDR.U_addedParcContr = ADOC.U_addedParcContr, 	ORDR.U_addedDtInicial = ADOC.U_addedDtInicial, 	ORDR.U_addedDtFinal = ADOC.U_addedDtFinal, 	ORDR.U_addedCardCode2 = ADOC.U_addedCardCode2, 	ORDR.U_addedCardName2 = ADOC.U_addedCardName2, 	ORDR.U_addedPedidoRes = ADOC.U_addedPedidoRes, 	ORDR.U_TargetType = ADOC.U_TargetType, 	ORDR.U_TargetEntry = ADOC.U_TargetEntry, 	ORDR.U_addedSentido = ADOC.U_addedSentido, 	ORDR.U_addedNrNFe = ADOC.U_addedNrNFe, 	ORDR.U_addedDtNFe = ADOC.U_addedDtNFe, 	ORDR.U_addedHrNFe = ADOC.U_addedHrNFe, 	ORDR.U_addedCodNFe = ADOC.U_addedCodNFe, 	ORDR.U_addedSituRPS = ADOC.U_addedSituRPS, 	ORDR.U_addedVlCredNFe = ADOC.U_addedVlCredNFe, 	ORDR.U_addedVlDeduNFe = ADOC.U_addedVlDeduNFe, 	ORDR.U_addedVlIssNFe = ADOC.U_addedVlIssNFe, 	ORDR.U_addedNrGuiaNFe = ADOC.U_addedNrGuiaNFe, 	ORDR.U_addedDtGuiaNFe = ADOC.U_addedDtGuiaNFe, 	ORDR.U_addedLinkNFe = ADOC.U_addedLinkNFe, 	ORDR.U_addedComFrete = ADOC.U_addedComFrete, 	ORDR.U_addedComTaxa1 = ADOC.U_addedComTaxa1, 	ORDR.U_addedComTaxa2 = ADOC.U_addedComTaxa2, 	ORDR.U_addedComTaxa3 = ADOC.U_addedComTaxa3, 	ORDR.U_ComVdDireta = ADOC.U_ComVdDireta, 	ORDR.U_addedConsolidado = ADOC.U_addedConsolidado, 	ORDR.U_ChAutent = ADOC.U_ChAutent, 	ORDR.U_Justfi = ADOC.U_Justfi, 	ORDR.U_chaveacesso = ADOC.U_chaveacesso, 	ORDR.U_operacao = ADOC.U_operacao, 	ORDR.U_ChRef = ADOC.U_ChRef, 	ORDR.U_addedIdEasy = ADOC.U_addedIdEasy, 	ORDR.U_addedMgBruta = ADOC.U_addedMgBruta, 	ORDR.U_CodeEq = ADOC.U_CodeEq, 	ORDR.U_ECF_COO = ADOC.U_ECF_COO, 	ORDR.U_txBol = ADOC.U_txBol, 	ORDR.U_SKILL_ENDENT = ADOC.U_SKILL_ENDENT, 	ORDR.U_SKILL_ENDCOL = ADOC.U_SKILL_ENDCOL, 	ORDR.U_SKILL_NR_MEMO = ADOC.U_SKILL_NR_MEMO, 	ORDR.U_SKILL_VL_FORN = ADOC.U_SKILL_VL_FORN, 	ORDR.U_SKILL_SERV_NT = ADOC.U_SKILL_SERV_NT, 	ORDR.U_SKILL_VL_TERC = ADOC.U_SKILL_VL_TERC, 	ORDR.U_TP_LIGACAO = ADOC.U_TP_LIGACAO, 	ORDR.U_COD_GRUPO_TENSAO = ADOC.U_COD_GRUPO_TENSAO, 	ORDR.U_SKILL_TipTrib = ADOC.U_SKILL_TipTrib, 	ORDR.U_SKILL_CREDST = ADOC.U_SKILL_CREDST, 	ORDR.U_B1SYS_ConnTypeCode = ADOC.U_B1SYS_ConnTypeCode, 	ORDR.U_B1SYS_TensGrpCode = ADOC.U_B1SYS_TensGrpCode, 	ORDR.U_B1SYS_EnergConsCls = ADOC.U_B1SYS_EnergConsCls, 	ORDR.U_B1SYS_ParticipantC = ADOC.U_B1SYS_ParticipantC, 	ORDR.U_B1SYS_SubscrCode = ADOC.U_B1SYS_SubscrCode, 	ORDR.U_B1SYS_MeterCode = ADOC.U_B1SYS_MeterCode, 	ORDR.U_B1SYS_RevIndC510 = ADOC.U_B1SYS_RevIndC510, 	ORDR.U_B1SYS_RevIndD600 = ADOC.U_B1SYS_RevIndD600, 	ORDR.U_B1SYS_RevIndD510 = ADOC.U_B1SYS_RevIndD510, 	ORDR.U_TP_CTe = ADOC.U_TP_CTe, 	ORDR.U_SKILL_SIMNAC = ADOC.U_SKILL_SIMNAC, 	ORDR.U_Skill_DescValores = ADOC.U_Skill_DescValores, 	ORDR.U_RNTC = ADOC.U_RNTC, 	ORDR.U_SKILL_NrRpsSubst = ADOC.U_SKILL_NrRpsSubst, 	ORDR.U_SKILL_NrCFPS = ADOC.U_SKILL_NrCFPS, 	ORDR.U_SKILL_tsCodigoObra = ADOC.U_SKILL_tsCodigoObra, 	ORDR.U_SKILL_tsART = ADOC.U_SKILL_tsART, 	ORDR.U_SKILL_DtSaida = ADOC.U_SKILL_DtSaida, 	ORDR.U_SKILL_HrSaida = ADOC.U_SKILL_HrSaida, 	ORDR.U_SKILL_PRORUR = ADOC.U_SKILL_PRORUR, 	ORDR.U_SKILL_ESCEXT = ADOC.U_SKILL_ESCEXT, 	ORDR.U_SKILL_STACTE = ADOC.U_SKILL_STACTE, 	ORDR.U_SKILL_DTPRE = ADOC.U_SKILL_DTPRE, 	ORDR.U_indFinal = ADOC.U_indFinal, 	ORDR.U_indPres = ADOC.U_indPres, 	ORDR.U_finNfe = ADOC.U_finNfe, 	ORDR.U_SKILL_NVE = ADOC.U_SKILL_NVE, 	ORDR.U_SKILL_nRECOPI = ADOC.U_SKILL_nRECOPI, 	ORDR.U_SKILL_cnpjAut = ADOC.U_SKILL_cnpjAut, 	ORDR.U_SKILL_IgnEnvioAut = ADOC.U_SKILL_IgnEnvioAut, 	ORDR.U_SKILL_ServPais = ADOC.U_SKILL_ServPais, 	ORDR.U_SKILL_ServRua = ADOC.U_SKILL_ServRua, 	ORDR.U_SKILL_ServNumero = ADOC.U_SKILL_ServNumero, 	ORDR.U_SKILL_ServComple = ADOC.U_SKILL_ServComple, 	ORDR.U_SKILL_ServBairro = ADOC.U_SKILL_ServBairro, 	ORDR.U_SKILL_ServCEP = ADOC.U_SKILL_ServCEP, 	ORDR.U_SKILL_NumProcesso = ADOC.U_SKILL_NumProcesso, 	ORDR.U_SKILL_SIT_ESP = ADOC.U_SKILL_SIT_ESP, 	ORDR.U_SKILL_ServPublic = ADOC.U_SKILL_ServPublic, 	ORDR.U_SKILL_CODSIT = ADOC.U_SKILL_CODSIT, 	ORDR.U_OKS_BSENTRY = ADOC.U_OKS_BSENTRY, 	ORDR.U_OKS_BSETYPE = ADOC.U_OKS_BSETYPE, 	ORDR.U_OKS_ORIGEM = ADOC.U_OKS_ORIGEM, 	ORDR.U_OKS_BSREC = ADOC.U_OKS_BSREC, 	ORDR.U_SKILL_NrNfseSubst = ADOC.U_SKILL_NrNfseSubst, 	ORDR.U_SKILL_DtNfseSubst = ADOC.U_SKILL_DtNfseSubst, 	ORDR.U_Skill_ServTipLog = ADOC.U_Skill_ServTipLog, 	ORDR.U_SKILL_IndISS = ADOC.U_SKILL_IndISS, 	ORDR.U_SKILLWORPostDate = ADOC.U_SKILLWORPostDate, 	ORDR.U_SKILLWORCloseDate = ADOC.U_SKILLWORCloseDate, 	ORDR.U_SKILLWORDocNum = ADOC.U_SKILLWORDocNum, 	ORDR.U_SKILLBlocoK = ADOC.U_SKILLBlocoK, 	ORDR.U_OKS_WHSDEST = ADOC.U_OKS_WHSDEST
From ADOC
where ADOC.DocEntry = ORDR.DocEntry and ORDR.DocEntry = 498 and ADOC.ObjType = ORDR.ObjType

update RDR6 SET
RDR6.DocEntry = ADO6.DocEntry, 	RDR6.InstlmntID = ADO6.InstlmntID, 	RDR6.ObjType = ADO6.ObjType, 	RDR6.LogInstanc = ADO6.LogInstanc, 	RDR6.DueDate = ADO6.DueDate, 	RDR6.Status = ADO6.Status, 	RDR6.DunnLevel = ADO6.DunnLevel, 	RDR6.InsTotal = ADO6.InsTotal, 	RDR6.InsTotalFC = ADO6.InsTotalFC, 	RDR6.InsTotalSy = ADO6.InsTotalSy, 	RDR6.PaidToDate = ADO6.PaidToDate, 	RDR6.PaidFC = ADO6.PaidFC, 	RDR6.PaidSys = ADO6.PaidSys, 	RDR6.VatSum = ADO6.VatSum, 	RDR6.VatSumFC = ADO6.VatSumFC, 	RDR6.VatSumSy = ADO6.VatSumSy, 	RDR6.VatPaid = ADO6.VatPaid, 	RDR6.VatPaidFC = ADO6.VatPaidFC, 	RDR6.VatPaidSys = ADO6.VatPaidSys, 	RDR6.TotalExpns = ADO6.TotalExpns, 	RDR6.TotalExpFC = ADO6.TotalExpFC, 	RDR6.TotalExpSC = ADO6.TotalExpSC, 	RDR6.ExpAppl = ADO6.ExpAppl, 	RDR6.ExpApplFC = ADO6.ExpApplFC, 	RDR6.ExpApplSC = ADO6.ExpApplSC, 	RDR6.WTSum = ADO6.WTSum, 	RDR6.WTSumFC = ADO6.WTSumFC, 	RDR6.WTSumSC = ADO6.WTSumSC, 	RDR6.WTApplied = ADO6.WTApplied, 	RDR6.WTAppliedF = ADO6.WTAppliedF, 	RDR6.WTAppliedS = ADO6.WTAppliedS, 	RDR6.TotalBlck = ADO6.TotalBlck, 	RDR6.TotalBlckF = ADO6.TotalBlckF, 	RDR6.TotalBlckS = ADO6.TotalBlckS, 	RDR6.VATBlck = ADO6.VATBlck, 	RDR6.VATBlckFC = ADO6.VATBlckFC, 	RDR6.VATBlckSC = ADO6.VATBlckSC, 	RDR6.ExpnsBlck = ADO6.ExpnsBlck, 	RDR6.ExpnsBlckF = ADO6.ExpnsBlckF, 	RDR6.ExpnsBlckS = ADO6.ExpnsBlckS, 	RDR6.WTBlocked = ADO6.WTBlocked, 	RDR6.WTBlockedF = ADO6.WTBlockedF, 	RDR6.WTBlockedS = ADO6.WTBlockedS, 	RDR6.InstPrcnt = ADO6.InstPrcnt, 	RDR6.DunWizBlck = ADO6.DunWizBlck, 	RDR6.DunDate = ADO6.DunDate, 	RDR6.Paid = ADO6.Paid, 	RDR6.PaidFrgn = ADO6.PaidFrgn, 	RDR6.PaidSc = ADO6.PaidSc, 	RDR6.reserved = ADO6.reserved, 	RDR6.TaxOnExp = ADO6.TaxOnExp, 	RDR6.TaxOnExpFc = ADO6.TaxOnExpFc, 	RDR6.TaxOnExpSc = ADO6.TaxOnExpSc, 	RDR6.TaxOnExpAp = ADO6.TaxOnExpAp, 	RDR6.TaxOnExApF = ADO6.TaxOnExApF, 	RDR6.TaxOnExApS = ADO6.TaxOnExApS, 	RDR6.TaxOnExBlo = ADO6.TaxOnExBlo, 	RDR6.TaxOnExBlF = ADO6.TaxOnExBlF, 	RDR6.TaxOnExBlS = ADO6.TaxOnExBlS, 	RDR6.LvlUpdDate = ADO6.LvlUpdDate, 	RDR6.Ordered = ADO6.Ordered, 	RDR6.PaidDpm = ADO6.PaidDpm, 	RDR6.PaidDpmFc = ADO6.PaidDpmFc, 	RDR6.PaidDpmSc = ADO6.PaidDpmSc, 	RDR6.U_addedObsFin = ADO6.U_addedObsFin
FROM ADO6
where ADO6.DocEntry = RDR6.DocEntry and RDR6.DocEntry = 498 and ADO6.ObjType = RDR6.ObjType

update RDR4 set LogInstanc =0 where docentry = 498
update RDR12 set LogInstanc =0 where docentry = 498

Delete from ADOC where docentry = 498 and objtype = 17
Delete from Ado1 where docentry = 498 and objtype = 17
Delete from ADO4 where docentry = 498 and ObjectType = 17
Delete from ADO6 where docentry = 498 and objtype = 17
Delete from ADO12 where docentry = 498 and objecttype = 17