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");