Área

Assunto

Nome da Tabela / Arquivo de Metadado

Stored Procedure para Sincronização

Comercial

Faturamento

DIS_DTS_Invoice_Fact

up_dts_delete_fact_range 'DIS_DTS_Invoice_Fact', 'DT_Day'

Devolução de Vendas

DIS_DTS_Sales_Return_Fact

up_dts_delete_fact_range 'DIS_DTS_Sales_Return_Fact', 'DT_Day'

Previsão de Vendas

DIS_DTS_Forecast_Fact

up_dts_delete_fact_range 'DIS_DTS_Forecast_Fact', 'DT_Day'

Cotas de Vendas

DIS_DTS_Sales_Quotes_Fact

up_dts_delete_fact_range 'DIS_DTS_Sales_Quotes_Fact', 'DT_Day'

Vendas

DIS_DTS_Sales_Fact

up_dts_delete_fact_range 'DIS_DTS_Sales_Fact', 'DT_Day'

Carteira de Vendas

DIS_DTS_Open_Orders_Fact

up_dts_delete_fact_today 'DIS_DTS_Open_Orders_Fact', 'DT_Pipeline'

Limite de Crédito

DIS_DTS_Credit_Limit_Fact

up_dts_delete_fact_today 'DIS_DTS_Credit_Limit_Fact', 'DT_Day'

Entregas

DIS_DTS_Shipment_Fact

up_dts_delete_fact_range 'DIS_DTS_Shipment_Fact', 'DT_Day'

Produção

Produção Realizada

MAN_DTS_Produced_Production_Performance_Fact

up_dts_delete_fact_range 'MAN_DTS_Produced_Production_Performance_Fact', 'DT_Report'

Produção Carteira

MAN_DTS_Pipeline_Production_Performance_Fact

up_dts_delete_fact_today 'MAN_DTS_Pipeline_Production_Performance_Fact', 'DT_Pipeline'

Produção Programada

MAN_DTS_Estimated_Production_Performance_Fact

up_dts_delete_fact_range 'MAN_DTS_Estimated_Production_Performance_Fact', 'DT_End'

Matéria-Prima Programada

MAN_DTS_Estimated_Raw_Material_Fact

up_dts_delete_fact_range 'MAN_DTS_Estimated_Raw_Material_Fact', 'DT_Programmed_Delivery'

Matéria-Prima Realizada

MAN_DTS_Consumed_Raw_Material_Fact

up_dts_delete_fact_range 'MAN_DTS_Consumed_Raw_Material_Fact', 'DT_Movement'

Matéria-Prima Carteira

MAN_DTS_Pipeline_Raw_Material_Fact

up_dts_delete_fact_today 'MAN_DTS_Pipeline_Raw_Material_Fact', 'DT_Pipeline'

Mão-de-Obra Realizada

MAN_DTS_Produced_Work_Force_Perfornance_Fact

up_dts_delete_fact_range 'MAN_DTS_Produced_Work_Force_Perfornance_Fact', 'DT_Movement'

Mão-de-Obra Programada

MAN_DTS_Estimated_Work_Force_Performance_Fact

up_dts_delete_fact_range 'MAN_DTS_Estimated_Work_Force_Performance_Fact', 'DT_Programed_Deliver'

Mão-de-Obra Carteira

MAN_DTS_Pipeline_Work_Force_Performance_Fact

up_dts_delete_fact_today 'MAN_DTS_Pipeline_Work_Force_Performance_Fact ', 'DT_Initial_Order'

GGF Programado

MAN_DTS_Estimated_GGF_Fact

up_dts_delete_fact_range 'MAN_DTS_Estimated_GGF_Fact', 'DT_Programmed_Delivery'

GGF Realizado

MAN_DTS_Producced_GGF_Fact

up_dts_delete_fact_range 'MAN_DTS_Producced_GGF_Fact', 'DT_Movement'

GGF Carteira

MAN_DTS_Pipeline_GGF_Fact

up_dts_delete_fact_today 'MAN_DTS_Pipeline_GGF_Fact', 'DT_Initial_Order'

Custo Real

MAN_DTS_Real_Cost_Fact

up_dts_delete_fact_today 'MAN_DTS_Real_Cost_Fact', 'DT_Day'

Custo Centro de Custos

MAN_DTS_Cost_Center_Cost_Fact

up_dts_delete_fact_range 'MAN_DTS_Cost_Center_Cost_Fact', 'DT_Day'

Materiais

Controle de Qualidade

MAT_DTS_Quality_Fact

up_dts_delete_fact_range 'MAT_DTS_Quality_Fact', 'DT_Day'

Controle de Qualidade - Carteira

MAT_DTS_Pipeline_Quality_Fact

up_dts_delete_fact_today 'MAT_DTS_Pipeline_Quality_Fact', 'DT_Pipeline'

Compras

MAT_DTS_Purchase_Fact

up_dts_delete_fact_range 'MAT_DTS_Purchase_Fact', 'DT_Emission'

Carteira de Compras

MAT_DTS_Pipeline_Purchase_Fact

up_dts_delete_fact_today 'MAT_DTS_Pipeline_Purchase_Fact', 'DT_Pipeline'

Devolução de Compras

MAT_DTS_Returned_Purchase_Fact

up_dts_delete_fact_range 'MAT_DTS_Returned_Purchase_Fact', 'DT_Devolution'

Recebimento 

MAT_DTS_Receiving_Fact

up_dts_delete_fact_range 'MAT_DTS_Receiving_Fact', 'DT_Receiving'

Estoque - Movimentação Diário

MAT_DTS_Daily_Inventory_Fact

up_dts_delete_fact_range 'MAT_DTS_Daily_Inventory_Fact', 'DT_Day'

Estoque - Mensal

MAT_DTS_Monthly_Inventory_Fact

up_dts_delete_fact_range 'MAT_DTS_Monthly_Inventory_Fact', 'DT_Day'

Estoque - Saldo Diário

MAT_DTS_Daily_Balance_Fact

up_dts_delete_fact_last_days 'MAT_DTS_Daily_Balance_Fact', 'DT_Balance'

Finanças

Contas a Pagar - Carteira

FIN_DTS_Pipeline_Accounts_Payable_Fact

up_dts_delete_fact_today 'FIN_DTS_Pipeline_Accounts_Payable_Fact', 'DT_Pipeline'

Contas a Pagar - Pagamento

FIN_DTS_Payment_Accounts_Payable_Fact

up_dts_delete_fact_range 'FIN_DTS_Payment_Accounts_Payable_Fact', 'DT_Payment'

Contas a Pagar - Emissão

FIN_DTS_Emission_Accounts_Payable_Fact

up_dts_delete_fact_range 'FIN_DTS_Emission_Accounts_Payable_Fact', 'DT_Emission'

Contas a Pagar - Vencimento

FIN_DTS_Due_Accounts_Payable_Fact

up_dts_delete_fact_range 'FIN_DTS_Due_Accounts_Payable_Fact', 'DT_Due'

Contas a Receber - Carteira

FIN_DTS_Pipeline_Accounts_Receivable_Fact

up_dts_delete_fact_today 'FIN_DTS_Pipeline_Accounts_Receivable_Fact', 'DT_Pipeline'

Contas a Receber - Recebimento

FIN_DTS_Payment_Accounts_Receivable_Fact

up_dts_delete_fact_range 'FIN_DTS_Payment_Accounts_Receivable_Fact', 'DT_Payment'

Contas a Receber - Emissão

FIN_DTS_Emission_Accounts_Receivable_Fact

up_dts_delete_fact_range 'FIN_DTS_Emission_Accounts_Receivable_Fact', 'DT_Emission'

Contas a Receber - Vencimento

FIN_DTS_Due_Accounts_Receivable_Fact

up_dts_delete_fact_range 'FIN_DTS_Due_Accounts_Receivable_Fact', 'DT_Due'

Fluxo de Caixa Orçado

FIN_DTS_Budget_Financial_Flow_Fact

up_dts_delete_fact_date 'FIN_DTS_Budget_Financial_Flow_Fact', 'DT_Day'

Fluxo de Caixa Previsto

FIN_DTS_Estimated_Financial_Flow_Fact

up_dts_delete_fact_range 'FIN_DTS_Estimated_Financial_Flow_Fact', 'DT_Day'

Fluxo de Caixa Realizado

FIN_DTS_Accomplished_Financial_Flow_Fact

up_dts_delete_fact_range 'FIN_DTS_Accomplished_Financial_Flow_Fact', 'DT_Day'

Controladoria

Contabilidade Orçada

FIN_DTS_Budget_General_Accounting_Fact

up_dts_delete_fact_last_months 'FIN_DTS_Budget_General_Accounting_Fact', 'DT_Day'

Contabilidade Realizada

FIN_DTS_Accomplished_General_Accounting_Fact

up_dts_delete_fact_last_months 'FIN_DTS_Accomplished_General_Accounting_Fact', 'DT_Day'

Indicadores Econômicos Financeiros

FIN_DTS_Management_Indicator_Fact

up_dts_delete_fact_last_months 'FIN_DTS_Management_Indicator_Fact', 'DT_Day'

Gestão Capital Humano

Banco de Horas

HUR_DTS_Overtime_Bank_Fact

up_dts_delete_fact_range 'HUR_DTS_Overtime_Bank_Fact', 'DT_Day'

Treinamentos

HUR_DTS_Accomplished_Training_Fact

up_dts_delete_fact_range 'HUR_DTS_Accomplished_Training_Fact', 'DT_Accomplished'

Vida Profissional

HUR_DTS_Professional_Life_Fact

up_dts_delete_fact_range 'HUR_DTS_Professional_Life_Fact', 'DT_Day'

Folha de Pagamentos

HUR_DTS_Payroll_Fact

up_dts_delete_fact_range 'HUR_DTS_Payroll_Fact', 'DT_Day'

Gestão de Planos

Beneficiários

HEA_DTS_Beneficiary_Fact

up_dts_delete_fact_last_months 'HEA_DTS_Beneficiary_Fact', 'DT_Competency'

Prestadores

HEA_DTS_Lender_Fact

(1) DELETE FROM HEA_DTS_Lender_Fact

Procedimentos Por Prestador

HEA_DTS_Lender_Proc_Fact

(1) DELETE FROM HEA_DTS_Lender_Proc_Fact

Insumos Por Prestador

HEA_DTS_Lender_Mat_Fact

(1) DELETE FROM HEA_DTS_Lender_Mat_Fact

Eventos Por Prestador

HEA_DTS_Lender_Event_Fact

(1) DELETE FROM HEA_DTS_Lender_Event_Fact

Especialidade Por Prestador

HEA_DTS_Lender_Spec_Fact

(1) DELETE FROM HEA_DTS_Lender_Spec_Fact

Receita Custo Operacional

HEA_DTS_Revenues_Cost_Fact

up_dts_delete_fact_range ' HEA_DTS_Revenues_Cost_Fact',’DT_Emission'

Receita Pré-Pagamento

HEA_DTS_Revenues_Previous_Payment_Fact

up_dts_delete_fact_range ' HEA_DTS_Revenues_Previous_Payment_Fact','DT_Emission'

Despesa de Produção

HEA_DTS_Expenses_Production_Fact

up_dts_delete_fact_range ' HEA_DTS_Expenses_Production_Fact','DT_Production'

Despesa Por Repasse

HEA_DTS_Expenses_Transfer_Fact

up_dts_delete_fact_today 'HEA_DTS_Expenses_Transfer_Fact', 'DT_Emission'

Despesa Extra

HEA_DTS_Expenses_Extra_Fact

up_dts_delete_fact_range 'HEA_DTS_Expenses_Extra_Fact', 'DT_Production'

Despesa EB

HEA_DTS_Expenses_EB_Fact

up_dts_delete_fact_last_months 'HEA_DTS_Expenses_EB_Fact', 'DT_Competency'

Despesa ESET

HEA_DTS_Expenses_ESET_Fact

up_dts_delete_fact_last_months 'HEA_DTS_Expenses_ESET_Fact', 'DT_Competency'

Guias de Autorização

HEA_DTS_Request_Fact

up_dts_delete_fact_range 'HEA_DTS_Request_Fact', 'DT_Emission'

Internação Hospitalar

HEA_DTS_Hospital_Internment_Cost_Fact

up_dts_delete_fact_hea_requests 'HEA_DTS_Hospital_Internment_Cost_Fact'