Intégré toutes les fonctions, procédures stockées et vues de la BD coda-prod

diff --git a/auf_p_p4_intero_cumul.sql b/auf_p_p4_intero_cumul.sql
deleted file mode 100644 (file)
index 7d84f3e..0000000
--- a/auf_p_p4_intero_cumul.sql
+++ /dev/null
@@ -1,111 +0,0 @@
-CREATE PROCEDURE auf_p_p4_intero_cumul
-    @annee int,
-    @periodeD int,
-    @periodeF int,
-    @projet varchar(7),
-    @region varchar(12),
-    @implantation varchar(12),
-    @el1 varchar(6)
-
-AS
-
-SET NOCOUNT ON;
-
-SELECT @annee AS exercice,
-       b.el1,
-       b.el3,
-       g.nom_court,
-       g.nom,
-       CASE WHEN b.el1 LIKE '97%' OR
-                 (b.el1 LIKE '1%' AND b.el3 NOT LIKE '9003%') OR
-                 b.el1 LIKE '7%'
-            THEN 'Recette'
-            WHEN b.el1 LIKE '86%' OR b.el1 LIKE '986%' THEN 'Dépense BSTG'
-            WHEN b.el1 LIKE '87%' OR b.el1 LIKE '987%' THEN 'Recette BSTG'
-            ELSE 'Dépense'
-       END AS nature,
-       g.region,
-       g.implantation AS code_implantation,
-       gi.sname AS nom_implantation,
-       CASE g.implantation
-            WHEN 'ICM1' THEN '10'
-            WHEN 'IGA1' THEN '11'
-            WHEN 'ITD1' THEN '12'
-            WHEN 'ICD1' THEN '13'
-            WHEN 'ICF1' THEN '14'
-            WHEN 'IBI1' THEN '15'
-            WHEN 'ICG1' THEN '16'
-            WHEN 'ICD2' THEN '18'
-            WHEN 'ICM2' THEN '19'
-            WHEN 'ISN1' THEN '20'
-            WHEN 'ISN2' THEN '21'
-            WHEN 'IGN1' THEN '22'
-            WHEN 'IMR1' THEN '23'
-            WHEN 'IML1' THEN '24'
-            WHEN 'IBF1' THEN '25'
-            WHEN 'INE1' THEN '26'
-            WHEN 'ICI1' THEN '27'
-            WHEN 'ITG1' THEN '28'
-            WHEN 'IBJ1' THEN '29'
-            WHEN 'IHT1' THEN '35'
-            WHEN 'IHT2' THEN '36'
-            WHEN 'IVN1' THEN '40'
-            WHEN 'IVN2' THEN '41'
-            WHEN 'IVN3' THEN '42'
-            WHEN 'IVN4' THEN '43'
-            WHEN 'ILA1' THEN '45'
-            WHEN 'ILA2' THEN '46'
-            WHEN 'IKH1' THEN '47'
-            WHEN 'IVU1' THEN '49'
-            WHEN 'ILB1' THEN '55'
-            WHEN 'ILB3' THEN '59'
-            WHEN 'ISY1' THEN '57'
-            WHEN 'ISY2' THEN '58'
-            WHEN 'IEG1' THEN '52'
-            WHEN 'IRO1' THEN '65'
-            WHEN 'IAM1' THEN '62'
-            WHEN 'IGE1' THEN '64'
-            WHEN 'IBG1' THEN '66'
-            WHEN 'IMD1' THEN '67'
-            WHEN 'IAL1' THEN '68'
-            WHEN 'IBG2' THEN '69'
-            WHEN 'IMG1' THEN '70'
-            WHEN 'IMG2' THEN '71'
-            WHEN 'IMU1' THEN '72'
-            WHEN 'IMU2' THEN '73'
-            WHEN 'IKM1' THEN '74'
-            WHEN 'ICA2' THEN '81'
-            WHEN 'IBR1' THEN '85'
-            WHEN 'IBE1' THEN '93'
-            WHEN 'IMA1' THEN '90'
-            WHEN 'ITN1' THEN '91'
-            WHEN 'IDZ1' THEN '94'
-            WHEN 'IDZ2' THEN '95'
-            WHEN 'IDZ3' THEN '96'
-            WHEN 'ICA1' THEN '01'
-            WHEN 'ICA2' THEN '02'
-       END AS no_implantation,
-       gr.name AS rubrique,
-       SUM(CASE WHEN b.balcode = 'BUDGET' THEN b.full_value ELSE 0 END) AS budget,
-       SUM(CASE WHEN b.balcode = 'ESTIME' THEN b.full_value ELSE 0 END) AS estime,
-       SUM(CASE WHEN b.balcode = 'BUDGET-MENS' THEN b.full_value ELSE 0 END) AS mensul,
-       SUM(CASE WHEN b.balcode = 'REEL' THEN b.full_value ELSE 0 END) AS reel,
-       SUM(CASE WHEN b.balcode = 'ENGAGE' THEN b.full_value ELSE 0 END) AS engage
-FROM auf_v_p4_projets_groupes g
-     INNER JOIN oas_balance b ON b.el3 = g.code_budgetaire
-     LEFT JOIN oas_group gi ON gi.code = g.implantation
-     LEFT JOIN oas_group glr ON glr.code = b.el3
-     LEFT JOIN oas_group gr ON gr.code = glr.grpcode
-WHERE b.yr = @annee AND
-      b.period BETWEEN @periodeD AND @periodeF AND
-      b.curcode = 'EUR' AND
-      b.repbasis = 5 AND
-      b.balcode NOT LIKE 'DBM%' AND
-      b.el3 LIKE @projet + '%' AND
-      b.el1 NOT LIKE '4%' AND
-      b.el1 LIKE @el1 + '%' AND
-      g.region LIKE @region + '%' AND
-      g.implantation LIKE 'I' + RTRIM(LTRIM(@implantation)) + '%'
-GROUP BY b.el1, b.el3, g.nom_court, g.nom, g.region, g.implantation
-ORDER BY b.el1, b.el3;
-GO

diff --git a/db/fonctions/auf_dernjourMois.sql b/db/fonctions/auf_dernjourMois.sql
new file mode 100644 (file)
index 0000000..dc8a77f
Binary files /dev/null and b/db/fonctions/auf_dernjourMois.sql differ

diff --git a/db/fonctions/auf_f_moisEnLettres.sql b/db/fonctions/auf_f_moisEnLettres.sql
new file mode 100644 (file)
index 0000000..75f0a09
Binary files /dev/null and b/db/fonctions/auf_f_moisEnLettres.sql differ

diff --git a/db/fonctions/auf_f_montantenLettre.sql b/db/fonctions/auf_f_montantenLettre.sql
new file mode 100644 (file)
index 0000000..70943fe
Binary files /dev/null and b/db/fonctions/auf_f_montantenLettre.sql differ

diff --git a/db/procedures/auf_p_ArchiverComptesSQL.sql b/db/procedures/auf_p_ArchiverComptesSQL.sql
new file mode 100644 (file)
index 0000000..0dd3ed2
Binary files /dev/null and b/db/procedures/auf_p_ArchiverComptesSQL.sql differ

diff --git a/db/procedures/auf_p_Balance_GroupByEl2.sql b/db/procedures/auf_p_Balance_GroupByEl2.sql
new file mode 100644 (file)
index 0000000..651cccf
Binary files /dev/null and b/db/procedures/auf_p_Balance_GroupByEl2.sql differ

diff --git a/db/procedures/auf_p_Balance_Verification.sql b/db/procedures/auf_p_Balance_Verification.sql
new file mode 100644 (file)
index 0000000..3bd44ed
Binary files /dev/null and b/db/procedures/auf_p_Balance_Verification.sql differ

diff --git a/db/procedures/auf_p_Balance_VerificationAUF.sql b/db/procedures/auf_p_Balance_VerificationAUF.sql
new file mode 100644 (file)
index 0000000..7f64f36
Binary files /dev/null and b/db/procedures/auf_p_Balance_VerificationAUF.sql differ

diff --git a/db/procedures/auf_p_Balance_VerificationAUFel2.sql b/db/procedures/auf_p_Balance_VerificationAUFel2.sql
new file mode 100644 (file)
index 0000000..162eae1
Binary files /dev/null and b/db/procedures/auf_p_Balance_VerificationAUFel2.sql differ

diff --git a/db/procedures/auf_p_Balance_VerificationEl2.sql b/db/procedures/auf_p_Balance_VerificationEl2.sql
new file mode 100644 (file)
index 0000000..dbf74aa
Binary files /dev/null and b/db/procedures/auf_p_Balance_VerificationEl2.sql differ

diff --git a/db/procedures/auf_p_Balance_VerificationEl2_PCGtous.sql b/db/procedures/auf_p_Balance_VerificationEl2_PCGtous.sql
new file mode 100644 (file)
index 0000000..d54b2a3
Binary files /dev/null and b/db/procedures/auf_p_Balance_VerificationEl2_PCGtous.sql differ

diff --git a/db/procedures/auf_p_Balance_Verification_Banque_Caisse.sql b/db/procedures/auf_p_Balance_Verification_Banque_Caisse.sql
new file mode 100644 (file)
index 0000000..cb4e8a4
Binary files /dev/null and b/db/procedures/auf_p_Balance_Verification_Banque_Caisse.sql differ

diff --git a/db/procedures/auf_p_ChargerElements.sql b/db/procedures/auf_p_ChargerElements.sql
new file mode 100644 (file)
index 0000000..88b1613
Binary files /dev/null and b/db/procedures/auf_p_ChargerElements.sql differ

diff --git a/db/procedures/auf_p_ExecuteCommandeSQL.sql b/db/procedures/auf_p_ExecuteCommandeSQL.sql
new file mode 100644 (file)
index 0000000..e45bdd5
Binary files /dev/null and b/db/procedures/auf_p_ExecuteCommandeSQL.sql differ

diff --git a/db/procedures/auf_p_GDE_maj_CGRM.sql b/db/procedures/auf_p_GDE_maj_CGRM.sql
new file mode 100644 (file)
index 0000000..71f303c
Binary files /dev/null and b/db/procedures/auf_p_GDE_maj_CGRM.sql differ

diff --git a/db/procedures/auf_p_ImputerCorbeille.sql b/db/procedures/auf_p_ImputerCorbeille.sql
new file mode 100644 (file)
index 0000000..7d62b50
Binary files /dev/null and b/db/procedures/auf_p_ImputerCorbeille.sql differ

diff --git a/db/procedures/auf_p_InsererEnteteDoc.sql b/db/procedures/auf_p_InsererEnteteDoc.sql
new file mode 100644 (file)
index 0000000..ffc0c47
Binary files /dev/null and b/db/procedures/auf_p_InsererEnteteDoc.sql differ

diff --git a/db/procedures/auf_p_InsererGroupesElem.sql b/db/procedures/auf_p_InsererGroupesElem.sql
new file mode 100644 (file)
index 0000000..c6a19dd
Binary files /dev/null and b/db/procedures/auf_p_InsererGroupesElem.sql differ

diff --git a/db/procedures/auf_p_InsererLigneDoc.sql b/db/procedures/auf_p_InsererLigneDoc.sql
new file mode 100644 (file)
index 0000000..217e4b8
Binary files /dev/null and b/db/procedures/auf_p_InsererLigneDoc.sql differ

diff --git a/db/procedures/auf_p_InsererLigneDocSommaire.sql b/db/procedures/auf_p_InsererLigneDocSommaire.sql
new file mode 100644 (file)
index 0000000..b071e87
Binary files /dev/null and b/db/procedures/auf_p_InsererLigneDocSommaire.sql differ

diff --git a/db/procedures/auf_p_InsererListeGauche.sql b/db/procedures/auf_p_InsererListeGauche.sql
new file mode 100644 (file)
index 0000000..f3b0185
Binary files /dev/null and b/db/procedures/auf_p_InsererListeGauche.sql differ

diff --git a/db/procedures/auf_p_InsererSupportsAuto.sql b/db/procedures/auf_p_InsererSupportsAuto.sql
new file mode 100644 (file)
index 0000000..d4544c8
Binary files /dev/null and b/db/procedures/auf_p_InsererSupportsAuto.sql differ

diff --git a/db/procedures/auf_p_ViderTablesLink.sql b/db/procedures/auf_p_ViderTablesLink.sql
new file mode 100644 (file)
index 0000000..270700d
Binary files /dev/null and b/db/procedures/auf_p_ViderTablesLink.sql differ

diff --git a/db/procedures/auf_p_ages_comptes.sql b/db/procedures/auf_p_ages_comptes.sql
new file mode 100644 (file)
index 0000000..d9bc445
Binary files /dev/null and b/db/procedures/auf_p_ages_comptes.sql differ

diff --git a/db/procedures/auf_p_ages_comptes_reeval.sql b/db/procedures/auf_p_ages_comptes_reeval.sql
new file mode 100644 (file)
index 0000000..9f8a742
Binary files /dev/null and b/db/procedures/auf_p_ages_comptes_reeval.sql differ

diff --git a/db/procedures/auf_p_analyseAchat.sql b/db/procedures/auf_p_analyseAchat.sql
new file mode 100644 (file)
index 0000000..c23693d
Binary files /dev/null and b/db/procedures/auf_p_analyseAchat.sql differ

diff --git a/db/procedures/auf_p_analyse_financiere.sql b/db/procedures/auf_p_analyse_financiere.sql
new file mode 100644 (file)
index 0000000..70fd0df
Binary files /dev/null and b/db/procedures/auf_p_analyse_financiere.sql differ

diff --git a/db/procedures/auf_p_auxiliaire_comptes.sql b/db/procedures/auf_p_auxiliaire_comptes.sql
new file mode 100644 (file)
index 0000000..5f58e3f
Binary files /dev/null and b/db/procedures/auf_p_auxiliaire_comptes.sql differ

diff --git a/db/procedures/auf_p_avances_salaires.sql b/db/procedures/auf_p_avances_salaires.sql
new file mode 100644 (file)
index 0000000..5c77edc
Binary files /dev/null and b/db/procedures/auf_p_avances_salaires.sql differ

diff --git a/db/procedures/auf_p_banqueVcaisse.sql b/db/procedures/auf_p_banqueVcaisse.sql
new file mode 100644 (file)
index 0000000..162d084
Binary files /dev/null and b/db/procedures/auf_p_banqueVcaisse.sql differ

diff --git a/db/procedures/auf_p_banqueVcaisse_anc.sql b/db/procedures/auf_p_banqueVcaisse_anc.sql
new file mode 100644 (file)
index 0000000..b3976be
Binary files /dev/null and b/db/procedures/auf_p_banqueVcaisse_anc.sql differ

diff --git a/db/procedures/auf_p_cgrm_solde_cotis.sql b/db/procedures/auf_p_cgrm_solde_cotis.sql
new file mode 100644 (file)
index 0000000..897370e
Binary files /dev/null and b/db/procedures/auf_p_cgrm_solde_cotis.sql differ

diff --git a/db/procedures/auf_p_charger_cumul.sql b/db/procedures/auf_p_charger_cumul.sql
new file mode 100644 (file)
index 0000000..bfa028e
Binary files /dev/null and b/db/procedures/auf_p_charger_cumul.sql differ

diff --git a/db/procedures/auf_p_controleDevise.sql b/db/procedures/auf_p_controleDevise.sql
new file mode 100644 (file)
index 0000000..c715dc5
Binary files /dev/null and b/db/procedures/auf_p_controleDevise.sql differ

diff --git a/db/procedures/auf_p_controleDeviseTBTC.sql b/db/procedures/auf_p_controleDeviseTBTC.sql
new file mode 100644 (file)
index 0000000..dd11103
Binary files /dev/null and b/db/procedures/auf_p_controleDeviseTBTC.sql differ

diff --git a/db/procedures/auf_p_controleDeviseTiers.sql b/db/procedures/auf_p_controleDeviseTiers.sql
new file mode 100644 (file)
index 0000000..8471732
Binary files /dev/null and b/db/procedures/auf_p_controleDeviseTiers.sql differ

diff --git a/db/procedures/auf_p_controle_Bilan.sql b/db/procedures/auf_p_controle_Bilan.sql
new file mode 100644 (file)
index 0000000..29dec28
Binary files /dev/null and b/db/procedures/auf_p_controle_Bilan.sql differ

diff --git a/db/procedures/auf_p_ctrlCodeDeviseElement.sql b/db/procedures/auf_p_ctrlCodeDeviseElement.sql
new file mode 100644 (file)
index 0000000..788040c
Binary files /dev/null and b/db/procedures/auf_p_ctrlCodeDeviseElement.sql differ

diff --git a/db/procedures/auf_p_ctrlCptEcriture.sql b/db/procedures/auf_p_ctrlCptEcriture.sql
new file mode 100644 (file)
index 0000000..b2d00bc
Binary files /dev/null and b/db/procedures/auf_p_ctrlCptEcriture.sql differ

diff --git a/db/procedures/auf_p_ctrlGroupesElement.sql b/db/procedures/auf_p_ctrlGroupesElement.sql
new file mode 100644 (file)
index 0000000..b6b3c6c
Binary files /dev/null and b/db/procedures/auf_p_ctrlGroupesElement.sql differ

diff --git a/db/procedures/auf_p_ctrlPaysElement.sql b/db/procedures/auf_p_ctrlPaysElement.sql
new file mode 100644 (file)
index 0000000..259e218
Binary files /dev/null and b/db/procedures/auf_p_ctrlPaysElement.sql differ

diff --git a/db/procedures/auf_p_detailBilan.sql b/db/procedures/auf_p_detailBilan.sql
new file mode 100644 (file)
index 0000000..5f51c88
Binary files /dev/null and b/db/procedures/auf_p_detailBilan.sql differ

diff --git a/db/procedures/auf_p_elementExiste.sql b/db/procedures/auf_p_elementExiste.sql
new file mode 100644 (file)
index 0000000..7d542a3
Binary files /dev/null and b/db/procedures/auf_p_elementExiste.sql differ

diff --git a/db/procedures/auf_p_etat_bilan.sql b/db/procedures/auf_p_etat_bilan.sql
new file mode 100644 (file)
index 0000000..6069e3b
Binary files /dev/null and b/db/procedures/auf_p_etat_bilan.sql differ

diff --git a/db/procedures/auf_p_etat_bilan_2008.sql b/db/procedures/auf_p_etat_bilan_2008.sql
new file mode 100644 (file)
index 0000000..1fd968e
Binary files /dev/null and b/db/procedures/auf_p_etat_bilan_2008.sql differ

diff --git a/db/procedures/auf_p_etat_bilan_2009.sql b/db/procedures/auf_p_etat_bilan_2009.sql
new file mode 100644 (file)
index 0000000..f6399a2
Binary files /dev/null and b/db/procedures/auf_p_etat_bilan_2009.sql differ

diff --git a/db/procedures/auf_p_etat_bilan_2009_2.sql b/db/procedures/auf_p_etat_bilan_2009_2.sql
new file mode 100644 (file)
index 0000000..aa5dd6b
Binary files /dev/null and b/db/procedures/auf_p_etat_bilan_2009_2.sql differ

diff --git a/db/procedures/auf_p_etat_budget.sql b/db/procedures/auf_p_etat_budget.sql
new file mode 100644 (file)
index 0000000..c2bd66b
Binary files /dev/null and b/db/procedures/auf_p_etat_budget.sql differ

diff --git a/db/procedures/auf_p_etat_resultats.sql b/db/procedures/auf_p_etat_resultats.sql
new file mode 100644 (file)
index 0000000..a1b5a89
Binary files /dev/null and b/db/procedures/auf_p_etat_resultats.sql differ

diff --git a/db/procedures/auf_p_etat_resultats2007.sql b/db/procedures/auf_p_etat_resultats2007.sql
new file mode 100644 (file)
index 0000000..5c49dbe
Binary files /dev/null and b/db/procedures/auf_p_etat_resultats2007.sql differ

diff --git a/db/procedures/auf_p_etat_resultats_2007.sql b/db/procedures/auf_p_etat_resultats_2007.sql
new file mode 100644 (file)
index 0000000..019485a
Binary files /dev/null and b/db/procedures/auf_p_etat_resultats_2007.sql differ

diff --git a/db/procedures/auf_p_etat_resultats_2009.sql b/db/procedures/auf_p_etat_resultats_2009.sql
new file mode 100644 (file)
index 0000000..5d668b3
Binary files /dev/null and b/db/procedures/auf_p_etat_resultats_2009.sql differ

diff --git a/db/procedures/auf_p_etat_resultats_p4.sql b/db/procedures/auf_p_etat_resultats_p4.sql
new file mode 100644 (file)
index 0000000..a56135d
Binary files /dev/null and b/db/procedures/auf_p_etat_resultats_p4.sql differ

diff --git a/db/procedures/auf_p_etat_resultats_p4_ex_precedent_2011.sql b/db/procedures/auf_p_etat_resultats_p4_ex_precedent_2011.sql
new file mode 100644 (file)
index 0000000..c042c94
Binary files /dev/null and b/db/procedures/auf_p_etat_resultats_p4_ex_precedent_2011.sql differ

diff --git a/db/procedures/auf_p_genere_analyste_fin.sql b/db/procedures/auf_p_genere_analyste_fin.sql
new file mode 100644 (file)
index 0000000..ec16f6c
Binary files /dev/null and b/db/procedures/auf_p_genere_analyste_fin.sql differ

diff --git a/db/procedures/auf_p_hexadecimal.sql b/db/procedures/auf_p_hexadecimal.sql
new file mode 100644 (file)
index 0000000..2f233ac
Binary files /dev/null and b/db/procedures/auf_p_hexadecimal.sql differ

diff --git a/db/procedures/auf_p_imp_depenseQI.sql b/db/procedures/auf_p_imp_depenseQI.sql
new file mode 100644 (file)
index 0000000..667ddff
Binary files /dev/null and b/db/procedures/auf_p_imp_depenseQI.sql differ

diff --git a/db/procedures/auf_p_imp_depenseQI_dev.sql b/db/procedures/auf_p_imp_depenseQI_dev.sql
new file mode 100644 (file)
index 0000000..8bc8edc
Binary files /dev/null and b/db/procedures/auf_p_imp_depenseQI_dev.sql differ

diff --git a/db/procedures/auf_p_intero_balance.sql b/db/procedures/auf_p_intero_balance.sql
new file mode 100644 (file)
index 0000000..273e1a4
Binary files /dev/null and b/db/procedures/auf_p_intero_balance.sql differ

diff --git a/db/procedures/auf_p_intero_boursiers.sql b/db/procedures/auf_p_intero_boursiers.sql
new file mode 100644 (file)
index 0000000..9f1b705
Binary files /dev/null and b/db/procedures/auf_p_intero_boursiers.sql differ

diff --git a/db/procedures/auf_p_intero_cumul.sql b/db/procedures/auf_p_intero_cumul.sql
new file mode 100644 (file)
index 0000000..f13310e
Binary files /dev/null and b/db/procedures/auf_p_intero_cumul.sql differ

diff --git a/db/procedures/auf_p_intero_cumul_comp.sql b/db/procedures/auf_p_intero_cumul_comp.sql
new file mode 100644 (file)
index 0000000..d852658
Binary files /dev/null and b/db/procedures/auf_p_intero_cumul_comp.sql differ

diff --git a/db/procedures/auf_p_intero_cumul_dep_rec.sql b/db/procedures/auf_p_intero_cumul_dep_rec.sql
new file mode 100644 (file)
index 0000000..bc8735b
Binary files /dev/null and b/db/procedures/auf_p_intero_cumul_dep_rec.sql differ

diff --git a/db/procedures/auf_p_intero_cumul_dep_rec_dev.sql b/db/procedures/auf_p_intero_cumul_dep_rec_dev.sql
new file mode 100644 (file)
index 0000000..e98d400
Binary files /dev/null and b/db/procedures/auf_p_intero_cumul_dep_rec_dev.sql differ

diff --git a/db/procedures/auf_p_intero_cumul_proj.sql b/db/procedures/auf_p_intero_cumul_proj.sql
new file mode 100644 (file)
index 0000000..2ec9cb3
Binary files /dev/null and b/db/procedures/auf_p_intero_cumul_proj.sql differ

diff --git a/db/procedures/auf_p_intero_cumul_tous.sql b/db/procedures/auf_p_intero_cumul_tous.sql
new file mode 100644 (file)
index 0000000..2515028
Binary files /dev/null and b/db/procedures/auf_p_intero_cumul_tous.sql differ

diff --git a/db/procedures/auf_p_interro_detail.sql b/db/procedures/auf_p_interro_detail.sql
new file mode 100644 (file)
index 0000000..9a1f3a0
Binary files /dev/null and b/db/procedures/auf_p_interro_detail.sql differ

diff --git a/db/procedures/auf_p_maj_base_AG.sql b/db/procedures/auf_p_maj_base_AG.sql
new file mode 100644 (file)
index 0000000..a52abdc
Binary files /dev/null and b/db/procedures/auf_p_maj_base_AG.sql differ

diff --git a/db/procedures/auf_p_miseajour_elm23.sql b/db/procedures/auf_p_miseajour_elm23.sql
new file mode 100644 (file)
index 0000000..7fbbefa
Binary files /dev/null and b/db/procedures/auf_p_miseajour_elm23.sql differ

diff --git a/db/procedures/auf_p_p4_intero_cumul.sql b/db/procedures/auf_p_p4_intero_cumul.sql
new file mode 100644 (file)
index 0000000..35ff330
Binary files /dev/null and b/db/procedures/auf_p_p4_intero_cumul.sql differ

diff --git a/db/procedures/auf_p_publication.sql b/db/procedures/auf_p_publication.sql
new file mode 100644 (file)
index 0000000..3838faf
Binary files /dev/null and b/db/procedures/auf_p_publication.sql differ

diff --git a/db/procedures/auf_p_restaurer_deldate.sql b/db/procedures/auf_p_restaurer_deldate.sql
new file mode 100644 (file)
index 0000000..eb83ccf
Binary files /dev/null and b/db/procedures/auf_p_restaurer_deldate.sql differ

diff --git a/db/procedures/auf_p_sigma_transfertProjetP.sql b/db/procedures/auf_p_sigma_transfertProjetP.sql
new file mode 100644 (file)
index 0000000..fe57ede
Binary files /dev/null and b/db/procedures/auf_p_sigma_transfertProjetP.sql differ

diff --git a/db/procedures/auf_p_sqi_etatprojet.sql b/db/procedures/auf_p_sqi_etatprojet.sql
new file mode 100644 (file)
index 0000000..f96da5a
Binary files /dev/null and b/db/procedures/auf_p_sqi_etatprojet.sql differ

diff --git a/db/procedures/auf_p_sqi_maj_groupes.sql b/db/procedures/auf_p_sqi_maj_groupes.sql
new file mode 100644 (file)
index 0000000..f0fb442
Binary files /dev/null and b/db/procedures/auf_p_sqi_maj_groupes.sql differ

diff --git a/db/procedures/auf_p_sqi_maj_projetComment.sql b/db/procedures/auf_p_sqi_maj_projetComment.sql
new file mode 100644 (file)
index 0000000..759a6e4
Binary files /dev/null and b/db/procedures/auf_p_sqi_maj_projetComment.sql differ

diff --git a/db/procedures/auf_p_sqi_maj_projetIndic.sql b/db/procedures/auf_p_sqi_maj_projetIndic.sql
new file mode 100644 (file)
index 0000000..72d2f71
Binary files /dev/null and b/db/procedures/auf_p_sqi_maj_projetIndic.sql differ

diff --git a/db/procedures/auf_p_sqi_maj_projetPoste.sql b/db/procedures/auf_p_sqi_maj_projetPoste.sql
new file mode 100644 (file)
index 0000000..6dc7b9f
Binary files /dev/null and b/db/procedures/auf_p_sqi_maj_projetPoste.sql differ

diff --git a/db/procedures/auf_p_taux.sql b/db/procedures/auf_p_taux.sql
new file mode 100644 (file)
index 0000000..97ab9e1
Binary files /dev/null and b/db/procedures/auf_p_taux.sql differ

diff --git a/db/vues/auf_v_Avance_Employes.sql b/db/vues/auf_v_Avance_Employes.sql
new file mode 100644 (file)
index 0000000..ac6d93e
Binary files /dev/null and b/db/vues/auf_v_Avance_Employes.sql differ

diff --git a/db/vues/auf_v_BanquevCaisse.sql b/db/vues/auf_v_BanquevCaisse.sql
new file mode 100644 (file)
index 0000000..f84a9e4
Binary files /dev/null and b/db/vues/auf_v_BanquevCaisse.sql differ

diff --git a/db/vues/auf_v_ControleBoursierBanques.sql b/db/vues/auf_v_ControleBoursierBanques.sql
new file mode 100644 (file)
index 0000000..5a0f24c
Binary files /dev/null and b/db/vues/auf_v_ControleBoursierBanques.sql differ

diff --git a/db/vues/auf_v_EtatCompteCotisation.sql b/db/vues/auf_v_EtatCompteCotisation.sql
new file mode 100644 (file)
index 0000000..e353bc0
Binary files /dev/null and b/db/vues/auf_v_EtatCompteCotisation.sql differ

diff --git a/db/vues/auf_v_GDE_membres.sql b/db/vues/auf_v_GDE_membres.sql
new file mode 100644 (file)
index 0000000..c8604bd
Binary files /dev/null and b/db/vues/auf_v_GDE_membres.sql differ

diff --git a/db/vues/auf_v_acces_demcom.sql b/db/vues/auf_v_acces_demcom.sql
new file mode 100644 (file)
index 0000000..64b80fb
Binary files /dev/null and b/db/vues/auf_v_acces_demcom.sql differ

diff --git a/db/vues/auf_v_ag_2009.sql b/db/vues/auf_v_ag_2009.sql
new file mode 100644 (file)
index 0000000..ccf23a5
Binary files /dev/null and b/db/vues/auf_v_ag_2009.sql differ

diff --git a/db/vues/auf_v_analyseIWR.sql b/db/vues/auf_v_analyseIWR.sql
new file mode 100644 (file)
index 0000000..632dce3
Binary files /dev/null and b/db/vues/auf_v_analyseIWR.sql differ

diff --git a/db/vues/auf_v_analyse_financier.sql b/db/vues/auf_v_analyse_financier.sql
new file mode 100644 (file)
index 0000000..37d2ff1
Binary files /dev/null and b/db/vues/auf_v_analyse_financier.sql differ

diff --git a/db/vues/auf_v_auxiliaire_comptes2008.sql b/db/vues/auf_v_auxiliaire_comptes2008.sql
new file mode 100644 (file)
index 0000000..5cba537
Binary files /dev/null and b/db/vues/auf_v_auxiliaire_comptes2008.sql differ

diff --git a/db/vues/auf_v_bilan.sql b/db/vues/auf_v_bilan.sql
new file mode 100644 (file)
index 0000000..27b6184
Binary files /dev/null and b/db/vues/auf_v_bilan.sql differ

diff --git a/db/vues/auf_v_bilan_1.sql b/db/vues/auf_v_bilan_1.sql
new file mode 100644 (file)
index 0000000..f3290d7
Binary files /dev/null and b/db/vues/auf_v_bilan_1.sql differ

diff --git a/db/vues/auf_v_bilan_1_loc.sql b/db/vues/auf_v_bilan_1_loc.sql
new file mode 100644 (file)
index 0000000..42b5edd
Binary files /dev/null and b/db/vues/auf_v_bilan_1_loc.sql differ

diff --git a/db/vues/auf_v_bilan_somme.sql b/db/vues/auf_v_bilan_somme.sql
new file mode 100644 (file)
index 0000000..d7815c4
Binary files /dev/null and b/db/vues/auf_v_bilan_somme.sql differ

diff --git a/db/vues/auf_v_bilan_somme_loc.sql b/db/vues/auf_v_bilan_somme_loc.sql
new file mode 100644 (file)
index 0000000..9732f76
Binary files /dev/null and b/db/vues/auf_v_bilan_somme_loc.sql differ

diff --git a/db/vues/auf_v_boursiers.sql b/db/vues/auf_v_boursiers.sql
new file mode 100644 (file)
index 0000000..96d44a4
Binary files /dev/null and b/db/vues/auf_v_boursiers.sql differ

diff --git a/db/vues/auf_v_budget_cumuls.sql b/db/vues/auf_v_budget_cumuls.sql
new file mode 100644 (file)
index 0000000..d037f73
Binary files /dev/null and b/db/vues/auf_v_budget_cumuls.sql differ

diff --git a/db/vues/auf_v_controleBoursiers.sql b/db/vues/auf_v_controleBoursiers.sql
new file mode 100644 (file)
index 0000000..31bbd9e
Binary files /dev/null and b/db/vues/auf_v_controleBoursiers.sql differ

diff --git a/db/vues/auf_v_controleElements1.sql b/db/vues/auf_v_controleElements1.sql
new file mode 100644 (file)
index 0000000..59bd33f
Binary files /dev/null and b/db/vues/auf_v_controleElements1.sql differ

diff --git a/db/vues/auf_v_controleElements3.sql b/db/vues/auf_v_controleElements3.sql
new file mode 100644 (file)
index 0000000..b89571a
Binary files /dev/null and b/db/vues/auf_v_controleElements3.sql differ

diff --git a/db/vues/auf_v_controleFournisseurs.sql b/db/vues/auf_v_controleFournisseurs.sql
new file mode 100644 (file)
index 0000000..5cd91e2
Binary files /dev/null and b/db/vues/auf_v_controleFournisseurs.sql differ

diff --git a/db/vues/auf_v_controleTiersCDOS.sql b/db/vues/auf_v_controleTiersCDOS.sql
new file mode 100644 (file)
index 0000000..41ed955
Binary files /dev/null and b/db/vues/auf_v_controleTiersCDOS.sql differ

diff --git a/db/vues/auf_v_controleTiersOperations.sql b/db/vues/auf_v_controleTiersOperations.sql
new file mode 100644 (file)
index 0000000..8be098c
Binary files /dev/null and b/db/vues/auf_v_controleTiersOperations.sql differ

diff --git a/db/vues/auf_v_ctrl_boursiers.sql b/db/vues/auf_v_ctrl_boursiers.sql
new file mode 100644 (file)
index 0000000..ea743ab
Binary files /dev/null and b/db/vues/auf_v_ctrl_boursiers.sql differ

diff --git a/db/vues/auf_v_cumuls.sql b/db/vues/auf_v_cumuls.sql
new file mode 100644 (file)
index 0000000..c88b7ae
Binary files /dev/null and b/db/vues/auf_v_cumuls.sql differ

diff --git a/db/vues/auf_v_depenses_programmes.sql b/db/vues/auf_v_depenses_programmes.sql
new file mode 100644 (file)
index 0000000..5a17685
Binary files /dev/null and b/db/vues/auf_v_depenses_programmes.sql differ

diff --git a/db/vues/auf_v_devises.sql b/db/vues/auf_v_devises.sql
new file mode 100644 (file)
index 0000000..e8053ac
Binary files /dev/null and b/db/vues/auf_v_devises.sql differ

diff --git a/db/vues/auf_v_el2.sql b/db/vues/auf_v_el2.sql
new file mode 100644 (file)
index 0000000..94a8842
Binary files /dev/null and b/db/vues/auf_v_el2.sql differ

diff --git a/db/vues/auf_v_elm_nonexistent.sql b/db/vues/auf_v_elm_nonexistent.sql
new file mode 100644 (file)
index 0000000..33f210b
Binary files /dev/null and b/db/vues/auf_v_elm_nonexistent.sql differ

diff --git a/db/vues/auf_v_gen_implantations.sql b/db/vues/auf_v_gen_implantations.sql
new file mode 100644 (file)
index 0000000..06a3bd7
Binary files /dev/null and b/db/vues/auf_v_gen_implantations.sql differ

diff --git a/db/vues/auf_v_iac_AchatAScommande.sql b/db/vues/auf_v_iac_AchatAScommande.sql
new file mode 100644 (file)
index 0000000..49d12fd
Binary files /dev/null and b/db/vues/auf_v_iac_AchatAScommande.sql differ

diff --git a/db/vues/auf_v_iac_achatAScommande_PCG.sql b/db/vues/auf_v_iac_achatAScommande_PCG.sql
new file mode 100644 (file)
index 0000000..c93032a
Binary files /dev/null and b/db/vues/auf_v_iac_achatAScommande_PCG.sql differ

diff --git a/db/vues/auf_v_icg_categorie.sql b/db/vues/auf_v_icg_categorie.sql
new file mode 100644 (file)
index 0000000..23a1051
Binary files /dev/null and b/db/vues/auf_v_icg_categorie.sql differ

diff --git a/db/vues/auf_v_icg_group_projet.sql b/db/vues/auf_v_icg_group_projet.sql
new file mode 100644 (file)
index 0000000..1057c1a
Binary files /dev/null and b/db/vues/auf_v_icg_group_projet.sql differ

diff --git a/db/vues/auf_v_icg_projetQI.sql b/db/vues/auf_v_icg_projetQI.sql
new file mode 100644 (file)
index 0000000..9c7654b
Binary files /dev/null and b/db/vues/auf_v_icg_projetQI.sql differ

diff --git a/db/vues/auf_v_implantations.sql b/db/vues/auf_v_implantations.sql
new file mode 100644 (file)
index 0000000..780bda1
Binary files /dev/null and b/db/vues/auf_v_implantations.sql differ

diff --git a/db/vues/auf_v_implantations_publie.sql b/db/vues/auf_v_implantations_publie.sql
new file mode 100644 (file)
index 0000000..36a9857
Binary files /dev/null and b/db/vues/auf_v_implantations_publie.sql differ

diff --git a/db/vues/auf_v_intero.sql b/db/vues/auf_v_intero.sql
new file mode 100644 (file)
index 0000000..27a97ef
Binary files /dev/null and b/db/vues/auf_v_intero.sql differ

diff --git a/db/vues/auf_v_intero_cumul.sql b/db/vues/auf_v_intero_cumul.sql
new file mode 100644 (file)
index 0000000..9b00b9d
Binary files /dev/null and b/db/vues/auf_v_intero_cumul.sql differ

diff --git a/db/vues/auf_v_interro_detail.sql b/db/vues/auf_v_interro_detail.sql
new file mode 100644 (file)
index 0000000..36b1cf3
Binary files /dev/null and b/db/vues/auf_v_interro_detail.sql differ

diff --git a/db/vues/auf_v_it_virement_Banque.sql b/db/vues/auf_v_it_virement_Banque.sql
new file mode 100644 (file)
index 0000000..ec34fce
Binary files /dev/null and b/db/vues/auf_v_it_virement_Banque.sql differ

diff --git a/db/vues/auf_v_iwr_cfg.sql b/db/vues/auf_v_iwr_cfg.sql
new file mode 100644 (file)
index 0000000..efd6fca
Binary files /dev/null and b/db/vues/auf_v_iwr_cfg.sql differ

diff --git a/db/vues/auf_v_p4_projets_groupes.sql b/db/vues/auf_v_p4_projets_groupes.sql
new file mode 100644 (file)
index 0000000..7b86bd0
Binary files /dev/null and b/db/vues/auf_v_p4_projets_groupes.sql differ

diff --git a/db/vues/auf_v_rapprochements.sql b/db/vues/auf_v_rapprochements.sql
new file mode 100644 (file)
index 0000000..c01576b
Binary files /dev/null and b/db/vues/auf_v_rapprochements.sql differ

diff --git a/db/vues/auf_v_resultats_pc.sql b/db/vues/auf_v_resultats_pc.sql
new file mode 100644 (file)
index 0000000..1cdb593
Binary files /dev/null and b/db/vues/auf_v_resultats_pc.sql differ

diff --git a/db/vues/auf_v_sqi_list_projet.sql b/db/vues/auf_v_sqi_list_projet.sql
new file mode 100644 (file)
index 0000000..5879321
Binary files /dev/null and b/db/vues/auf_v_sqi_list_projet.sql differ

diff --git a/db/vues/auf_v_sqi_projetsactif.sql b/db/vues/auf_v_sqi_projetsactif.sql
new file mode 100644 (file)
index 0000000..0b01018
Binary files /dev/null and b/db/vues/auf_v_sqi_projetsactif.sql differ

diff --git a/db/vues/auf_v_suivi_budget.sql b/db/vues/auf_v_suivi_budget.sql
new file mode 100644 (file)
index 0000000..647f270
Binary files /dev/null and b/db/vues/auf_v_suivi_budget.sql differ

diff --git a/db/vues/auf_v_taux.sql b/db/vues/auf_v_taux.sql
new file mode 100644 (file)
index 0000000..76ce684
Binary files /dev/null and b/db/vues/auf_v_taux.sql differ

diff --git a/db/vues/auf_v_taux_devise.sql b/db/vues/auf_v_taux_devise.sql
new file mode 100644 (file)
index 0000000..d319aa4
Binary files /dev/null and b/db/vues/auf_v_taux_devise.sql differ

diff --git a/db/vues/auf_v_verif_imputation.sql b/db/vues/auf_v_verif_imputation.sql
new file mode 100644 (file)
index 0000000..1fb56de
Binary files /dev/null and b/db/vues/auf_v_verif_imputation.sql differ

diff --git a/db/vues/auf_v_web_ControleCleCpt.sql b/db/vues/auf_v_web_ControleCleCpt.sql
new file mode 100644 (file)
index 0000000..039fcdc
Binary files /dev/null and b/db/vues/auf_v_web_ControleCleCpt.sql differ

diff --git a/db/vues/auf_v_web_ControleCleCptOLD.sql b/db/vues/auf_v_web_ControleCleCptOLD.sql
new file mode 100644 (file)
index 0000000..513effe
Binary files /dev/null and b/db/vues/auf_v_web_ControleCleCptOLD.sql differ

diff --git a/db/vues/auf_v_web_ControleDevise.sql b/db/vues/auf_v_web_ControleDevise.sql
new file mode 100644 (file)
index 0000000..600bc84
Binary files /dev/null and b/db/vues/auf_v_web_ControleDevise.sql differ

diff --git a/db/vues/auf_v_web_ControleElement.sql b/db/vues/auf_v_web_ControleElement.sql
new file mode 100644 (file)
index 0000000..3ae97af
Binary files /dev/null and b/db/vues/auf_v_web_ControleElement.sql differ

diff --git a/db/vues/auf_v_web_VerifLettrage.sql b/db/vues/auf_v_web_VerifLettrage.sql
new file mode 100644 (file)
index 0000000..4d2fb2f
Binary files /dev/null and b/db/vues/auf_v_web_VerifLettrage.sql differ

diff --git a/db/vues/auf_v_web_boursiers.sql b/db/vues/auf_v_web_boursiers.sql
new file mode 100644 (file)
index 0000000..12303a8
Binary files /dev/null and b/db/vues/auf_v_web_boursiers.sql differ

diff --git a/db/vues/auf_v_web_detailBoursiers.sql b/db/vues/auf_v_web_detailBoursiers.sql
new file mode 100644 (file)
index 0000000..731ad7b
Binary files /dev/null and b/db/vues/auf_v_web_detailBoursiers.sql differ

diff --git a/db/vues/auf_v_web_devise.sql b/db/vues/auf_v_web_devise.sql
new file mode 100644 (file)
index 0000000..e0bf128
Binary files /dev/null and b/db/vues/auf_v_web_devise.sql differ

diff --git a/db/vues/auf_v_web_deviseInv.sql b/db/vues/auf_v_web_deviseInv.sql
new file mode 100644 (file)
index 0000000..1270a53
Binary files /dev/null and b/db/vues/auf_v_web_deviseInv.sql differ

diff --git a/db/vues/auf_v_web_elementsTiers.sql b/db/vues/auf_v_web_elementsTiers.sql
new file mode 100644 (file)
index 0000000..62dba9f
Binary files /dev/null and b/db/vues/auf_v_web_elementsTiers.sql differ

diff --git a/db/vues/auf_v_web_groupes.sql b/db/vues/auf_v_web_groupes.sql
new file mode 100644 (file)
index 0000000..ae54ed2
Binary files /dev/null and b/db/vues/auf_v_web_groupes.sql differ

diff --git a/db/vues/auf_v_web_grpOperation.sql b/db/vues/auf_v_web_grpOperation.sql
new file mode 100644 (file)
index 0000000..712ddc1
Binary files /dev/null and b/db/vues/auf_v_web_grpOperation.sql differ

diff --git a/db/vues/auf_v_web_lettreCheque.sql b/db/vues/auf_v_web_lettreCheque.sql
new file mode 100644 (file)
index 0000000..17d90a5
Binary files /dev/null and b/db/vues/auf_v_web_lettreCheque.sql differ

diff --git a/db/vues/auf_v_web_listePCG.sql b/db/vues/auf_v_web_listePCG.sql
new file mode 100644 (file)
index 0000000..3e50072
Binary files /dev/null and b/db/vues/auf_v_web_listePCG.sql differ

diff --git a/db/vues/auf_v_web_pays.sql b/db/vues/auf_v_web_pays.sql
new file mode 100644 (file)
index 0000000..4f0a6b4
Binary files /dev/null and b/db/vues/auf_v_web_pays.sql differ

diff --git a/db/vues/auf_v_web_projetpost.sql b/db/vues/auf_v_web_projetpost.sql
new file mode 100644 (file)
index 0000000..80a4ec6
Binary files /dev/null and b/db/vues/auf_v_web_projetpost.sql differ

diff --git a/db/vues/auf_v_web_utilisateurs.sql b/db/vues/auf_v_web_utilisateurs.sql
new file mode 100644 (file)
index 0000000..87ab795
Binary files /dev/null and b/db/vues/auf_v_web_utilisateurs.sql differ

diff --git a/db/vues/auf_v_web_virement_Banque.sql b/db/vues/auf_v_web_virement_Banque.sql
new file mode 100644 (file)
index 0000000..479daef
Binary files /dev/null and b/db/vues/auf_v_web_virement_Banque.sql differ