Insere / Replica empresa

INSERT INTO consinco.max_empresa
SELECT 2,
NULL,
seqpessoaemp,
nrosegmentoprinc,
nrodivisao,
nrogrupoempresa,
nomereduzido,
razaosocial,
fantasia,
endereco,
bairro,
cep,
cidade,
uf,
nrocgc,
digcgc,
inscricaoestadual,
gerentegeral,
admsistema,
foneddd,
fonenro,
faxddd,
faxnro,
emailcontato,
emailintranet,
ctlalcadapedcompra,
ctlverbacompra,
tipdtactlverba,
empfncverbacompra,
autfazpedcompra,
actpedacimaverba,
actrecqtdacipedcom,
actrecvlracipedcom,
actrecpzoabxpedcom,
actrecantesdtaped,
actrecaposdtalimpc,
inddescactabfornec,
gernrointernoreceb,
caldesctransf,
perdesctransf,
caldescduplic,
pmtestqnegtransloc,
tipaltprecofamilia,
tipatualizapreco,
tipaltprecorectonf,
tipaltprecomanual,
tipaltprecoequipar,
tipaltprecosugcent,
tipaltprecooutmot,
autmgmlucropropria,
serpadraoentnf,
serpadraoemissnf,
indemicabecnf,
perpis,
serpadraoeminfent,
percofins,
percpmf,
perir,
pericmsestimativa,
peroutroimposto,
perdespoperacional,
perdespdiversa,
perperda,
percalcrecfinanc,
percalcdespfinanc,
cgobaixasaidapdv,
cgoauxbaixapdv,
cgotransflocori,
cgotransflocdest,
cgobaixaproducao,
cgoentrproducao,
cgobaixainventario,
cgoentrinventario,
cgoemissnfvenda,
cgodevcli,
cgoenttransf,
nrocheckoutloja,
nrocheckoutinicial,
nrocheckoutfinal,
nrometro2loja,
nrofuncionariooper,
nrofuncionarioadm,
indabertsabado,
indabertdomingo,
metagermargemlucro,
metagerdiaestq,
softpdv,
softbalanca,
softetiqueta,
direxportacaopdv,
dirimportacaopdv,
direxpetiqueta,
indexportacl,
status,
indcentralloja,
indreplicacao,
indgeroureplicacao,
pais,
indimprimeembetiq,
indembemissaonf,
resaltprecomanual,
resaltprecosugcent,
resaltprecoprom,
indgercustoprimrec,
indgerdescverbcomp,
perlimqtdacipedcom,
perlimqtdacipedpes,
perlimvlracipedcom,
dtaultgercontabent,
numdiapzoabxpedcom,
dtaultgercontabsai,
ufformacaopreco,
nrnfpropria,
indimpfatnf,
pmtaltstatusprloja,
formetiquetbal,
indautovalidprod,
intreccorpaccount,
intreccorpfinance,
intreccorptribute,
indsuframa,
intsaicorptribute,
ufbasepreco,
indacmmediavenda,
tipoacmmediavenda,
indapropdescfincusto,
nroregtributacao,
pzomaxcancnf,
indusaaprovqtdcompra,
indgeracordopromoc,
codtipoacpromoc,
indacrdescflexsugpreco,
nroempresaadmverba,
indcompraiteminativo,
indfaturaipi,
indfaturaiss,
perciss,
indretencaoiss,
obsretencaoiss,
gerinfobroker,
nroempresawms,
indicmspropriolf,
indgercustodiaemp,
indgeracredpis,
indgeracredcofins,
nroempresafiscal,
padraoetiqgondola,
regminiagricestado,
obsregminiagricest,
regminiagricfederal,
obsregminiagricfed,
dtabloqexclusaonf,
nrodiabloqexcnf,
indusatipovlrfinance,
tipocalccomissao,
gercomissaofinance,
mascararua,
mascarapredio,
mascaravao,
funcaoseparador,
funcaoconferente,
funcaoentregador,
indusaadmpreco,
dirimportinvent,
qtdmaxinvcoletor,
obspadraopedcompra,
indgerareservafisc,
ocorrenciaretpe,
cgosaiprontaentrega,
cgodevprontaentrega,
cgovdaprontaentrega,
cgodevfornec,
indabatcancacordo,
geraentradatransf,
tiporotexterno,
percsll,
vlrfixoseguro,
percseguro,
vlrminisentoseguro,
NULL,
NULL,
NULL,
indusaloteestoque,
tipoaliqfretetransp,
geraprodinativopdv,
indfaturaicmsdif,
cgoenttransfprod,
cgosaitransfprod,
dtafechafiscal,
dtafechacontabil,
indcredpiscofinsme,
seqlocalselinversa,
indgerastpiscofins,
dtainiciomovestoque,
nroempcustoabc,
tipovlrbasecomissao,
nronsunf,
indgeransunf,
cgobaixaperda,
indgeranroformulario,
indgeranroselofiscal,
dtaultalteracao,
usuultalteracao,
perirlucrat,
percslllucrat,
seqclassesaz,
nroempresaabastec,
perredbasepiscofins,
cgoajustecusto,
tipoemisnfe,
indimportadora,
cgoajustecustoredu,
nroempracordopromoc,
indusadescreserv,
cgobaixadfprodint,
cgoentrdfprodint,
formetiquetballinha,
nrobaseexportacao,
indtelvdareduzcomissrep,
indempscannfe,
indexecutatransfnf,
percreduzpercrep,
indsugcompraclasseabast,
seqfarmaceuticoresp,
obsleidescincond,
cgovdaavaria,
nrocondpagavaria,
nroformapagavaria,
taxasuframa,
dtacontingencianfe,
descontingencianfe,
serienfeabort,
indapropdesccontratocusto,
situacaonfpisdevsai01,
situacaonfcofinsdevsai01,
situacaonfpisdevsai02,
situacaonfcofinsdevsai02,
indarredlastropalete,
cgocontmovavariacoml,
percomissaoempratrestorno,
percomissaorepratrestorno,
percomissaofatorratrestorno,
obsdenuncianfe,
cgopadraoimportacao,
nroalvaraemp,
nrolicencaemp,
nroalvaraespecialemp,
dtaalvaraemp,
seqrepreslegal,
tpocontroleprecomonit,
indbloqprecomonfixonormal,
indbloqprecomonfixoprom,
indbloqprecomonmgmnormal,
indbloqprecomonmgmprom,
indbloqprecomonminmnormal,
indbloqprecomonminmprom,
indbloqprecomongradenormal,
indbloqprecomongradeprom,
md5,
indcalcdescsuframa,
cgodevfornecabatimento,
indusaafv,
tipoemiscte,
nomeafv,
peracrescsugpromo,
qtddiasiniciopromo,
qtddiasfimpromo,
indconverteembnfe,
NULL,
NULL,
cgodevajudic,
cgodevressarcicmsret,
perinss,
qtdeminestmin,
indobsnf1regime,
indobsnf2regime,
seqfaixasimplesnac,
pzomaxinutilizacaonf,
nroregtributimportacao,
indacrescicmsdifer,
obspadraodanfe,
obspadraodacte,
cgovdatroca,
NULL,
indutilformpcoipisobmipc,
percajusteficalipi,
nroempresamaetitcontrato,
fusohorario,
tipoemismdfe,
modelomdfe,
seriemdfe,
tipoemitentemdfe,
pzomaxcancmdfe,
obspadraomdfe,
seriemdfeabort,
indbloqdtanfforn,
indapropicmssimplescusto,
NULL,
NULL,
NULL,
pzomaxcancextempnf,
indutilcancextempnf,
indtransfemunidade,
indusamgmprodempseg,
indvisuicmsstsimulapreco,
indgradearredsimulapreco,
indusacongdigitaitem,
permaxredcomissaorestorno,
emailnfeemp,
indresolucao13intrauf,
indcontrolapontoimpcte,
nrorecopi,
tipoemisnfse,
pmtestqnegtransprod,
indtipoentrverbasellin,
indtipoentrverbabonifsellin,
indcontrolaverbasellin,
indaprovapedtransfauto,
caminhoxmlnfeparacte,
indutilizadecreto46517,
cgocomplantecipado,
NULL,
indrestauticms,
NULL,
cgorestauticms,
indtiporestauticms,
cgoemissaonfprodrural,
seqagnavegacao,
seqregcomprapadrao,
indempcompregcompra,
indtipopessoapiscofformpreco,
indtipopessoaipiformpreco,
indvisufatorstsimulapreco,
tipacpromocselloutred,
tipacpromocselloutacr,
indgeraressarcstsn,
vlrminretir,
dtagermsuvencto,
fusohorarioctemdfe,
cgoentradanfinv,
cgosaidanfinv,
cgobaixaprodutoembalagem,
nrocondpagnfinventario,
nroreprnfinventario,
indutilaprovacaomovestq,
vlrlimiteaprovacao,
indaprovacaomovestqoper,
nrocrf,
indicmscalcbcalcantec,
NULL,
cgoentradadivergfaixaxtol,
cgosaidadivergfaixatol,
descimpacresitensbonifgerartit,
indfracembabastec,
indconsidstsemdestqpiscof,
indtipoentrtransfsellin,
indexibelucroreal,
indprocopertransfmg,
pertxtcif,
caractereseparadorgs1128,
indempdepositofechado,
perpisrecfinanc,
percofinsrecfinanc,
taxajuro,
NULL,
nrodiavenctoiss,
nroformapagtotitiss,
nrocondicaopagtotitiss,
codespecietitiss,
seqpessoatitiss,
indutlagendamentoweb,
indsubtraiicmsbasepiscofins,
seqpessoaicms,
seqpessoaipi,
seqpessoapis,
seqpessoacofins,
tipacpromocpedbonifcom,
tipacpromocpedbonifsem,
indgeracordopromocpedbonif,
nrocgcantt,
digcgcantt,
emailcontatogerente,
indutlportariaweb,
indutilacrescimost,
nroregtributacaost,
indutilcalcfcp,
indsomafcpicmscusto,
cgoentradanfmovitotal,
cgosaidanfmovitotal,
cgoentradanfinvtotal,
cgosaidanfinvtotal,
cgoentradanfmoviparcial,
cgosaidanfmoviparcial,
cgoentradanfinvparcial,
cgosaidanfinvparcial,
cgoentradanfmovivazio,
cgosaidanfmovivazio,
cgoentradanfinvvazio,
cgosaidanfinvvazio,
indgerapafecf,
indpermnfsesemtomador,
seqpessoanfsetitsemtomador,
codtipoacpromoc_sellin,
codtipoacpromoc_sellout,
utipmcportariacat9417,
indenviomanifestoauto,
nrodiasenvopintdesc,
nrodiasenvopintdescnid,
nrodiasenvopinterestdescnid,
nrodiasenvopintnreal,
nrodiasenvopintnrealnid,
nrodiasenvopinterestnreal,
nrodiasenvopinterestnrealnid,
justifmanifestopnaoreal,
indprodutosstrestauto,
nrodiasenvopinterestdesc,
seqprodutoressarcicmsretfcpst,
indusabasecalcipiart195,
indcontratonddcargo,
pontoemissorciot,
codperfilorigem,
codperfildestino,
indcalcfeefcusto,
vlrminretcsllpiscofins,
codperfildestsugpreco,
permusoetiqcod2d,
bloqenviocentraladm,
2,
indutilcredicmssubsicmsst,
statuscompraprodemp,
indusafiltropromocespecial,
dtaultexecjobmanifestnfe

FROM consinco.max_empresa a
WHERE a.nroempresa = 1