Quando a falha ocorre?
Ao realizar importação de XML apresenta erro:
2147217900 - Invalid column name: aoi_fk_cfop
Como corrigir o erro?
- Realize backup da base geral.
- Realize script: - CREATE TABLE "lfs_ajusteobs_icms"( - "aoi_id" IDENTITY DEFAULT '0', 
 "aoi_fk_indicador" INTEGER NOT NULL ,
 "aoi_tipo" SMALLINT NOT NULL ,
 "aoi_fk_empresa" INTEGER NOT NULL ,
 "aoi_codigo" CHAR(15) NOT NULL ,
 "aoi_descricao" CHAR(80) NOT NULL ,
 "aoi_fk_cfop" INTEGER,
 "aoi_cte_sat" BIT DEFAULT '0' NOT NULL ,
 "aoi_modelo" SMALLINT DEFAULT '0' NOT NULL ,
 CONSTRAINT cempc_aoi_fk_empresa FOREIGN KEY ("aoi_fk_empresa") REFERENCES prg_empresa_compl ON UPDATE RESTRICT ON DELETE CASCADE ,
 CONSTRAINT caoi_aou_fk_uf FOREIGN KEY ("aoi_fk_indicador") REFERENCES lfs_ajusteobs_uf ON UPDATE RESTRICT ON DELETE RESTRICT ,
 CONSTRAINT caoi_fk_cfop FOREIGN KEY ("aoi_fk_cfop") REFERENCES cfop ON UPDATE RESTRICT ON DELETE CASCADE ,
 PRIMARY KEY ("aoi_id"),
 UNIQUE ("aoi_id"));- CREATE INDEX "iaoi_Codigo" USING 5 ON "lfs_ajusteobs_icms"("aoi_codigo"); 
 CREATE INDEX "iaoi_Empresa" USING 6 ON "lfs_ajusteobs_icms"("aoi_fk_empresa");
 CREATE INDEX "iaoi_Indicador" USING 7 ON "lfs_ajusteobs_icms"("aoi_fk_indicador");
 CREATE INDEX "iaoi_Todos" USING 8 ON "lfs_ajusteobs_icms"("aoi_fk_indicador", "aoi_fk_empresa", "aoi_fk_cfop");
 CREATE UNIQUE INDEX "iaoiIndTipoCodCfop" USING 1 ON "lfs_ajusteobs_icms"("aoi_fk_indicador", "aoi_tipo", "aoi_fk_empresa", "aoi_fk_cfop");
 
