--boletos delete from cb_boletocobranca --logistica delete from lg_recebimento_pagto delete from lg_recebimento_parcelas delete from lg_romaneio delete from lg_romaneio_itens --contas a receber delete from cr_romaneio_pagto delete from cr_romaneio_parcelas delete from cr_romaneio delete from cr_romaneio_itens delete from cr_titulo delete from cr_recebimento_pagto delete from cr_recebimento_parcelas delete from cr_parcelas delete from CR_PARCELAS_CANC_BX delete from CR_PARCELAS_EXC delete from CR_RECEBIMENTO_PAGTO_CANC_BX delete from CR_RECEBIMENTO_PARCELAS_CANC_BX delete from CR_TITULO_CANC_BX delete from CR_TITULO_EXC --caixas e bancos delete from cx_fechamento delete from cx_movimento --contas a pagar delete from cp_recebimento_pagto delete from cp_recebimento_parcelas delete from cp_titulos delete from nf_titulos_nproc delete from nf_parcelas_nproc delete from CP_PARCELAS_CANC_BX delete from CP_PARCELAS_EXC delete from CP_RECEBIMENTO_PAGTO_CANC_BX delete from CP_RECEBIMENTO_PARCELAS_CANC_BX delete from CP_TITULOS_CANC_BX delete from CP_TITULOS_EXC --estoques delete from ce_estoque_filial_fiscal delete from ce_estoquefilial delete from ce_lotevalidade delete from ce_movim delete from ce_movim_estoque delete from ce_movim_fiscal delete from ce_movim_nproc delete from ce_movim_item_nproc delete from ce_lotevalidade_nproc delete from ce_movim_rascunho delete from ce_movim_item_rascunho delete from ce_lotevalidade_rascunho delete from CE_ATUALIZADOR_FISCAL_PRODUTOS_ITENS_LOG delete from CE_ATUALIZADOR_FISCAL_PRODUTOS_LOG delete from CE_CLASSIFPROD delete from CE_CONTROLE_CLASS_NEGATIVA delete from CE_CONTROLE_CLASS_POSITIVA delete from CE_MOVIM_VINC_CTE delete from CE_MOVIM_OBS DELETE FROM CC_REL_PROD_FORN --nota fiscal delete from nf_fatura delete from nf_pedido delete from nf_lanc delete from nf_lanc_item delete from nf_titulos_nproc delete from nf_parcelas_nproc delete from NF_C100 delete from NF_C170 delete from NF_C500 delete from NF_D100 delete from NF_DEV_TOTAL_PEDNF delete from NF_LANC_CUPOM_REF delete from NF_LANC_ENDERECO delete from NF_LANC_INU delete from NF_LANC_ITEM_DI delete from NF_LANC_ITEM_DI_ADI delete from NF_LANC_ITEM_ICMS_UF_DEST delete from NF_LANC_ITEM_INF_COM delete from NF_LANC_ITEM_INU delete from NF_LANC_ITEM_LEIS delete from NF_LANC_ITEM_LOTE_MED delete from NF_SEGREGACAO delete from NF_TOTECF delete from NFE_CARTA_CORRECAO --pdas delete from pda_cidades delete from pda_classe delete from pda_cliente delete from pda_condpagto delete from pda_cred_cli delete from pda_lstprcprodutos delete from pda_parcela delete from pda_pedido delete from pda_vb_comercial delete from pda_nf_aliq --pedido de venda delete from pv_pedido delete from pv_ped_item_lotval delete from pv_ultpreco delete from pv_naovenda delete from pv_pedido_auditoria delete from pv_pedido_status_ped delete from PV_PED_DESCTO delete from PV_PED_ITEM_BONIF delete from PV_PED_ITEM_CONF_POS_FAT delete from PV_PED_ITEM_CUPOM_CANC delete from PV_PED_ITEM_IMPOSTO delete from PV_PED_ITEM_LOTE_MED delete from PV_PED_ITEM_VOLUMES delete from PV_PED_ITEM_VOLUMES_PRECODEBAR delete from PV_PED_ITEM_LOTVAL delete from PV_PEDIDO_AUX_CUPOM delete from PV_PEDIDO_BONIF delete from PV_PEDIDO_CUPOM_CANC delete from PV_PEDIDO_EC delete from PV_PEDIDO_ENDERECO delete from PV_PEDIDO_PE_PAGTO delete from PV_PEDIDO_RASCUNHOAFV delete from PV_PEDIDO_SUPR delete from PV_PEDIDO_VINC_ECF delete from PV_TMP_ETIQUETA delete from VD_LOTE_CADPED_INU --Compras delete from cc_pedido delete from cc_ped_item delete from cc_parcelas delete from cc_pedcomp_recebto delete from cc_pedcomp_recebto_nproc delete from CC_COTACAO delete from CC_COTACAO_ITEM delete from CC_LOTE_COTA delete from CC_LOTE_COTA_ITEM delete from CC_REQUISICAO --tesouraria delete from ts_cheque_titulo_cr delete from ts_cheque_titulo_cp delete from ts_cheque delete from ts_fluxo_caixa --lote de digitaçã o delete from vd_lote_cadped -- COBRANCA delete from CR_ROMANEIO delete from CR_ROMANEIO_ITENS delete from CR_ROMANEIO_PAGTO delete from CR_ROMANEIO_PARCELAS --extrato verba comercial delete from vd_vbextrato --historico dos produtos delete from hisaltprecoproduto delete from ce_estoque_filial_fiscal -- PARAMETROS delete from TLOG delete from TMESTREENTRADASAIDA -- PARCEIROS FISCAIS delete from LOG_INTCONT_FOLHAMATIC delete from LOG_INTCONT_FOLHAMATIC_ARQ -- PRONTA ENTREGA delete from PE_CARREGAMENTO delete from PE_CARREGTO_CONF_PRODUTOS delete from PE_CARREGTO_DOCTOS delete from PE_CARREGTO_LOTE_PRE_VENDA delete from PE_CARREGTO_NFE delete from PE_CARREGTO_PEDIDOS_PRE_VENDA delete from PE_CARREGTO_ROMANEIO -- PCP delete from PCP_APONTAMENTO_PRODUCAO delete from PCP_APONTAMENTO_PRODUCAO_INSUMOS delete from PCP_APONTAMENTO_PRODUCAO_ITENS delete from PCP_NECESSIDADES delete from PCP_NECESSIDADES_ITENS delete from PCP_OP delete from PCP_OP_ELAB delete from PCP_OP_ITEM delete from PCP_OP_ITEM_ETIQ delete from PCP_PLANO_PRODUCAO delete from PCP_PLANO_PRODUCAO_ITENS delete from PCP_PLANO_VENDAS delete from PCP_PLANO_VENDAS_ITENS delete from PCP_PLANO_VENDAS_PEDIDO delete from PCP_PARAM -- CODEBAR delete from LG_CODEBAR_EQUIPE_RECEB delete from LG_CODEBAR_ETIQUETA delete from LG_CODEBAR_ETIQUETA_GS1_128 delete from LG_CODEBAR_SSCC delete from LG_CODEBAR_ETIQUETA_MOVIM delete from LG_CODEBAR_INVENTARIO delete from LG_CODEBAR_INVENTARIO_ITEM delete from LG_CODEBAR_LOTE delete from LG_CODEBAR_RECEB_ITEM delete from LG_CODEBAR_RECEB_ITEM_PESO delete from LG_CODEBAR_RECEBIMENTO delete from LG_CODEBAR_UA -- CUSTOS delete from CT_CUSTO_APROP_DOC delete from CT_CUSTO_DOCUMENTO --Alterar o inventário Físico para 0 update CE_PRODUTOS set ESTOQUE = 0 update CE_PRODUTOS set EST_FISCAL = 0 --Auditoria dos pedidos delete from PV_PEDIDO_AUDITORIA where DATA < '2019-10-19' ---DELETE FROM CE_MOVIM_NPROC ---PDV delete from pagto_venda delete from movimento_cfe delete from movimento delete from venda_cfe delete from venda ---Excluir Redução Z