CREATE PROCEDURE "SBO_TaxOne"."P_RemoveDataBaseTeste" 
(
    in pCompanyDb nvarchar(128)
)
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
AS
BEGIN
    
    ---- Remove historico de documentos de Servico -------------
            DELETE
            FROM "DocHist"
            WHERE "BatchId" in
                (SELECT "BatchId"
                 FROM "Doc"
                 WHERE "EntityId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =pCompanyDb) );
            DELETE
            FROM "Doc"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "SBO_TaxOne"."SettingEntityEnv"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "SBO_TaxOne"."SettingEntityEnvLog"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "SBO_TaxOne"."SettingEntitySeqCodeInv"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
    ---- Remove historico de documentos Nf-e -------------------
            DELETE
            FROM "DBInvOne"."ProcessHist"
            WHERE "BatchId" in
                (SELECT "BatchId"
                 FROM "DBInvOne"."Process"
                 WHERE "CompanyId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =pCompanyDb) );
            DELETE
            FROM "DBInvOne"."Process"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "DBInvOne"."SettingCompany"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "DBInvOne"."SettingCompanyLog"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "DBInvOne"."SettingCompanySeqCode"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
    ---- Remove historico Df-e ----------------------------
            DELETE
            FROM "DBInvOne"."DocReceivedAttach"
            WHERE "DocReceivedId" in
                (SELECT "Id"
                 FROM "DBInvOne"."DocReceived"
                 WHERE "CompanyId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =pCompanyDb) );
            DELETE
            FROM "DBInvOne"."DocReceivedAttach"
            WHERE "DocReceivedId" in
                (SELECT "Id"
                 FROM "DBInvOne"."DocReceived"
                 WHERE "CompanyId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =pCompanyDb) );
            DELETE
            FROM "DBInvOne"."DocReceivedHist"
            WHERE "DocReceivedId" in
                (SELECT "Id"
                 FROM "DBInvOne"."DocReceived"
                 WHERE "CompanyId" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =pCompanyDb) );
            DELETE
            FROM "DBInvOne"."DocReceived"
            WHERE "CompanyId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "DBInvOne"."ReceiptSetting"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "DBInvOne"."ReceiptSettingCfop"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "DBInvOne"."ReceiptSettingProductFoundBy"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "DBInvOne"."ReceiptSettingUsage"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "DBInvOne"."ReceiptSettingUserField"
            WHERE "EntityId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
   ---- Remover a apuracao ------------------------------------------
            DELETE
            FROM "SBO_TaxOne"."ApuracaoPeriodoDetalhe"
            WHERE "PeriodoApuracaoId" in
                (SELECT "ID"
                 FROM "SBO_TaxOne"."ApuracaoPeriodo"
                 WHERE "Entidade" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =pCompanyDb) );
            DELETE
            FROM "SBO_TaxOne"."ApuracaoPeriodoResumo"
            WHERE "PeriodoApuracao" in
                (SELECT "ID"
                 FROM "SBO_TaxOne"."ApuracaoPeriodo"
                 WHERE "Entidade" in
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =pCompanyDb) );
            DELETE
            FROM "SBO_TaxOne"."ApuracaoPeriodo"
            WHERE "Entidade" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "SBO_TaxOne"."SpedFiscalSetting"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
   --- Remove ECF --- TaxPlus
     
            DELETE
            FROM "SBO_TaxOne"."TX_ECF_PLANO_DE_CONTA_VINCULO"
            WHERE "CodigoDaVigencia" IN
                (SELECT "Codigo"
                 FROM "SBO_TaxOne"."TX_ECF_PLANO_DE_CONTA_VIGENCIA"
                 WHERE "CodigoDaEntidade" IN
                     (SELECT "ID"
                      FROM "Entidade"
                      WHERE "CompanyDb" =pCompanyDb));
                      
            DELETE
            FROM "SBO_TaxOne"."TX_ECF_PLANO_DE_CONTA_VIGENCIA"
            WHERE "CodigoDaEntidade" IN
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
   --- Remove Entidade --- TaxPlus
            DELETE
            FROM "SBO_TaxOne"."EntidadeCategoriaImposto"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "SBO_TaxOne"."EntidadeCertificado"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "SBO_TaxOne"."EntidadeCertificadoLog"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "SBO_TaxOne"."EntidadeComplementoImposto"
            WHERE "EntidadeId" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "SBO_TaxOne"."EntidadeResponsavel"
            WHERE "Entidade" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
            DELETE
            FROM "SBO_TaxOne"."EntidadeSubstitutoTributario"
            WHERE "Entidade" in
                (SELECT "ID"
                 FROM "Entidade"
                 WHERE "CompanyDb" =pCompanyDb);
END