Index

Ticket

TabName

FileName

STRUCTURE_HDRCA_44397619537037

Headers CA

ANGA Production_HeadersCA

SELECT * FROM CC_HEADERS

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_443996459143519

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

SELECT CC_STRUCT.[Poste CC] AS GrpPoste, CC_STRUCT.[Grp CC], CC_STRUCT.[S_Grp CC], CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description],'' as Colsepar, CC_STRUCT.Direct, CC_STRUCT.[25_Prc], CC_STRUCT.Indirect, CC_STRUCT.Non_TS, CC_STRUCT.[Cmts TS], '' as Colsepar1, CC_STRUCT.Screen, CC_STRUCT.[Cmts SCREEN],'' as Colsepar2, CC_STRUCT.WALL, CC_STRUCT.[Cmts WALL] FROM CC_STRUCT WHERE (((CC_STRUCT.[Main])=True)) ORDER BY CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description];

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_443996459837963

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_443996461111111

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_443996461111111

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_443996463425926

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_HDRCA_44399646712963

Headers CA

ANGA Production_HeadersCA

SELECT * FROM CC_HEADERS

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_443996469907407

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_444004744212963

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_444005949189815

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_444005950578704

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

LIST_FILMS_444105380439815

Nos Productions

ANGA Production_NosProductions

select * from WEBDATA_FILMs

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_444184598611111

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

DEVIS_TAX_SHELTER_EXTERNE_PLUS_EXTRA_444255796180556

Devis Tax Shelter + Extra

ANGA Production_DevisTaxShelter+Extra

SELECT Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique as [Code], CA_GEN, Devis_Situation.Rubrique_Libel as Libellé, '' as COLSEPAR, Devis_Situation.Amount_Tot as Devis, Devis_Situation.Extra_Tot as [Extra Devis], Devis_Situation.Devis_Tot as [Tot Devis], Devis_Benef_Perte.Devis_Tot_New as [New Devis], Devis_Situation.Engagé, Devis_Situation.Solde as [Reste Devis], Devis_Situation.Closed, Devis_Benef_Perte.[Bénéfice Glb] as [Bénéf Total], Devis_Benef_Perte.[Perte Glb] as [Perte Total], '' AS COLSEPAR8, Devis_Situation.Amount_TSD AS [Direct D], Devis_Situation.Extra_TSD AS [Extra D], Devis_Benef_Perte.Devis_TD_New AS [New Direct D], Devis_Situation.Actual_TD AS [Engagé D], Devis_Benef_Perte.[Solde TD] AS [Reste D], Devis_Benef_Perte.[Bénéfice TD] AS [Bénéf D], Devis_Benef_Perte.[Perte TD] AS [Perte D], '' AS COLSEPAR9, Devis_Situation.Amount_TS25 AS [Direct 25], Devis_Situation.Extra_TS25 AS [Extra 25], Devis_Benef_Perte.Devis_T25_New AS [New Direct 25], Devis_Situation.Actual_T25 AS [Engagé 25], Devis_Benef_Perte.[Solde T25] AS [Reste 25], Devis_Benef_Perte.[Bénéfice T25] AS [Bénéf 25], Devis_Benef_Perte.[Perte T25] AS [Perte 25], '' as COLSEPAR1, Devis_Situation.Amount_TSD2 as [Direct D25], Devis_Situation.Extra_TSD2 as [Extra D25], Devis_Benef_Perte.[Devis_TD25_New] as [New Direct D25] , Devis_Situation.Actual_TD25 as [Engagé D25], Devis_Benef_Perte.[Solde TD25] as [Reste D25], Devis_Benef_Perte.[Bénéfice TD25] as [Bénéf D25], Devis_Benef_Perte.[Perte TD25] as [Perte D25], '' as COLSEPAR2, Devis_Situation.Amount_TSI as [Indirect], Devis_Situation.Extra_TSI as [Extra I], Devis_Benef_Perte.[Devis_TI_New] as [New Indirect] ,Devis_Situation.Actual_TI as [Engagé I], Devis_Benef_Perte.[Solde TI] as [Reste I], Devis_Benef_Perte.[Bénéfice TI] as [Bénéf I], Devis_Benef_Perte.[Perte TI] as [Perte I], '' as COLSEPAR3, iif(Amount_TSD2 is null,0,[Amount_TSD2]) + iif(Extra_TSD2 is null,0,[Extra_TSD2]) + iif(Amount_TSI is null,0,[Amount_TSI]) + iif(Extra_TSI is null,0,[Extra_TSI]) as [Total D&I], Devis_Benef_Perte.[Devis_TD25_New] + Devis_Benef_Perte.[Devis_TI_New] as [New Total D&I], iif(Actual_TD25 is null,0,[Actual_TD25]) + iif(Actual_TI is null,0,[Actual_TI]) as [Engagé D&I], [Total D&I] - [Engagé D&I] as [Solde D&I], iif ([Devis_Situation.Closed],iif ([Solde D&I] >0 ,[Solde D&I])) as [Benéf D&I], iif ([Devis_Situation.Closed],iif ([Solde D&I] <0 ,[Solde D&I])) as [Perte D&I], '' as COLSEPAR4, Devis_Situation.Amount_NTS as [Devis NTS], Devis_Situation.Extra_NTS as [Extra NTS], Devis_Benef_Perte.[Devis_NTS_New] as [New NTS] , Devis_Situation.Actual_TSN as [Engagé NTS], [Bénéfice NTS], [Perte NTS], iif([Devis_Situation.Closed] and [Perte Glb] >0 ,'color:red |font-weight:bold ', iif([Devis_Situation.Solde] <= -1 ,'color:red')) as RowStyle FROM Devis_Situation INNER JOIN Devis_Benef_Perte ON (Devis_Situation.Rubrique = Devis_Benef_Perte.Rubrique) AND (Devis_Situation.Film_Code = Devis_Benef_Perte.Film_Code) WHERE Devis_Situation.Film_Code <> '' ORDER BY Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER2_444335271296296

Attestations TaxShelter - Smart

ANGA Production_AttestationsTaxShelter-Smart

SELECT dossier , [Code Film],année & '-' & Prd as Period, Tax_SHELTER.Film, Tax_SHELTER.[Date Doc], Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[N° doc], Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[Montant HT], TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Direct TS], [25%] , Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Non TS], iif(right([Code TS],1)='N', [Montant HT] ,0) as [Total (N)], Tax_SHELTER.Document,[Commentaire ANA] as [Commentaire] FROM Tax_SHELTER Where ( dossier <> 'cce' or [CA Complet] like '95%' ) and [Code Film] = 'CDS' order by dossier, [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

FA_PRISE_EN_CHARGE_444544165972222

Prise en charge

ANGA Production_Priseencharge

SELECT année & '-' & Prd as Periode, dossier , [Code Film] , année & '-' & Prd as GrpPrd, Tax_SHELTER.Film, Tax_SHELTER.[Date Doc], Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[N° doc], Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[Montant HT], TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Direct TS], [25%] , Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Non TS], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >Archive</a>' as Archive FROM Tax_SHELTER Where ( dossier <> 'cce' or [CA Complet] like '95%' ) and (année & '-' & Prd ) > format(now - 730,'yyyy-mm') and [Code Film] <> '' order by année & '-' & Prd , Tax_SHELTER.[N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_GRP_CA_444595337384259

Situation 2 chiffres - Compta

ANGA Production_Situation2chiffres-Compta

SELECT Tax_Shelter.[Code Film], Struc_devis.Code1 AS ClsCa, Struc_devis.Code_2, [Struc_devis].[Code_2] & ' - ' & [Struc_devis].[libel_2] AS GrpCa, Devis_Benef_CA.Devis_CA, Devis_Benef_CA.New_Devis_CA, Sum(Tax_Shelter.[Direct TS]) AS [Direct TS], Sum(Tax_Shelter.[25%]) AS [Total 25%], Sum(Tax_Shelter.[Indirect TS]) AS [Indirect TS], Sum(Tax_Shelter.[Non TS]) AS [Non TS], Sum(Tax_Shelter.[Montant HT]) AS [Total HT], Right([Code TS],1) AS [A/N] FROM (Struc_devis LEFT JOIN (select * from Tax_SHELTER where [Code Film] = 'ALL') AS Tax_Shelter ON Struc_devis.Code_2 = Tax_Shelter.Code2) LEFT JOIN Devis_Benef_CA ON (Tax_Shelter.Code_2_Ca = Devis_Benef_CA.Code_2_CA) AND (Tax_Shelter.[Code Film] = Devis_Benef_CA.Film_Code) WHERE (((Tax_Shelter.[Code Film])='ALL' Or (Tax_Shelter.[Code Film]) Is Null)) GROUP BY Tax_Shelter.[Code Film], Struc_devis.Code1, Struc_devis.Code_2, [Struc_devis].[Code_2] & ' - ' & [Struc_devis].[libel_2], Devis_Benef_CA.Devis_CA, Devis_Benef_CA.New_Devis_CA, Right([Code TS],1) ORDER BY Struc_devis.Code_2;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_GRP_CA_444595338425926

Situation 2 chiffres - Compta

ANGA Production_Situation2chiffres-Compta

SELECT Tax_Shelter.[Code Film], Struc_devis.Code1 AS ClsCa, Struc_devis.Code_2, [Struc_devis].[Code_2] & ' - ' & [Struc_devis].[libel_2] AS GrpCa, Devis_Benef_CA.Devis_CA, Devis_Benef_CA.New_Devis_CA, Sum(Tax_Shelter.[Direct TS]) AS [Direct TS], Sum(Tax_Shelter.[25%]) AS [Total 25%], Sum(Tax_Shelter.[Indirect TS]) AS [Indirect TS], Sum(Tax_Shelter.[Non TS]) AS [Non TS], Sum(Tax_Shelter.[Montant HT]) AS [Total HT], Right([Code TS],1) AS [A/N] FROM (Struc_devis LEFT JOIN (select * from Tax_SHELTER where [Code Film] = 'COR') AS Tax_Shelter ON Struc_devis.Code_2 = Tax_Shelter.Code2) LEFT JOIN Devis_Benef_CA ON (Tax_Shelter.Code_2_Ca = Devis_Benef_CA.Code_2_CA) AND (Tax_Shelter.[Code Film] = Devis_Benef_CA.Film_Code) WHERE (((Tax_Shelter.[Code Film])='COR' Or (Tax_Shelter.[Code Film]) Is Null)) GROUP BY Tax_Shelter.[Code Film], Struc_devis.Code1, Struc_devis.Code_2, [Struc_devis].[Code_2] & ' - ' & [Struc_devis].[libel_2], Devis_Benef_CA.Devis_CA, Devis_Benef_CA.New_Devis_CA, Right([Code TS],1) ORDER BY Struc_devis.Code_2;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER2_444765260069444

Attestations TaxShelter - Smart

ANGA Production_AttestationsTaxShelter-Smart

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER2_445176170833333

Attestations TaxShelter - Smart

ANGA Production_AttestationsTaxShelter-Smart

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

PL_FILMS_44523598900463

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

PL_FILMS_445244354976852

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

LIST_FILMS_445264977546296

Nos Productions

ANGA Production_NosProductions

select * from WEBDATA_FILMs

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER2_445456333333333

Attestations TaxShelter - Smart

ANGA Production_AttestationsTaxShelter-Smart

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

FILMS_JNL_445575400694444

Films - Table Officielle

ANGA Production_Films-TableOfficielle

SELECT IIf(Film_Jnl.[Actif],'Actifs','Non Actifs') AS GrpActifs, Film_Jnl.DbkCodeACH AS CodeACH, Film_Jnl.DbkCodeNDF AS CodeNDF, Film_Jnl.Terminaison as Nro, Film_Jnl.CodeFilm AS Code, Film_Jnl.TitreFilm, Type_Film, Film_Jnl.Status, Film_Jnl.Tournage_Debut AS Trn_Debut, Film_Jnl.Tournage_Fin AS Trn_Fin, Film_Jnl.Copie_0, Film_Jnl.Sortie, Film_Jnl.Prod, Film_Jnl.Postprod, Film_Jnl.Dist, Film_Jnl.[Actif], Film_Jnl.BETV, Film_Jnl.PROX, Film_Jnl.RTBF, Film_Jnl.WalImage, Film_Jnl.SCREEN, Film_Jnl.FWB, Film_Jnl.[Autre Fin], Film_Jnl.TS, Film_Jnl.Coproducteur, Film_Jnl.Pays_Coprod as Pays, Film_Jnl.Distributeur FROM Film_Jnl ORDER BY Film_Jnl.CodeFilm;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

LIST_FILMS_445607208680556

Nos Productions

ANGA Production_NosProductions

select * from WEBDATA_FILMs

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

PL_FILMS_445684016898148

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.[Tiers Client / Fournisseur], cstr('<div style=width:50px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' >' & [Type Dist] & '</div>') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'LBN' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and not [type Jrnl] in ('OD') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

LIST_FILMS_445684130439815

Nos Productions

ANGA Production_NosProductions

select * from WEBDATA_FILMs

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_GRP_FULL_445786798842593

TAX Shelter - CA Complet

ANGA Production_TAXShelter-CAComplet

SELECT * from YVDA_GRP_FULL Where [Code Film] = 'FIT'

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_445786804861111

Attestations TaxShelter

ANGA Production_AttestationsTaxShelter

SELECT Tax_SHELTER.Dossier, Tax_SHELTER.Film, Tax_SHELTER.[N° doc], Tax_SHELTER.[Code Film], Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Montant HT], Tax_SHELTER.TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Tot TS T] AS [Montant Total], Tax_SHELTER.[Cumul TS], Tax_SHELTER.[Direct TS], Tax_SHELTER.[25%], Tax_SHELTER.[Cumul TS Direct], Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Cumul TS Indirect], Tax_SHELTER.[Non TS], Tax_SHELTER.Document, [Link Archive], [Commentaire Ana], TCE,ExtraZone FROM Tax_SHELTER Where [Code Film] = 'FIT' order by dossier, Tax_SHELTER.[Date Doc], [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_GRP_FULL_445786915046296

TAX Shelter - CA Complet

ANGA Production_TAXShelter-CAComplet

SELECT * from YVDA_GRP_FULL Where [Code Film] = 'FIT'

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

DEVIS_ENGAGE_SHORT_445786930671296

Suivi résumé 1 chiffre

ANGA Production_Suivirésumé1chiffre

SELECT Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique, Devis_Situation.Rubrique_Libel, Devis_Situation.Closed, Devis_Situation.CA_Gen, Devis_Situation.Devis_Tot, Devis_Situation.Engagé, Devis_Situation.Solde, Devis_Situation.Actual_TD25I, Devis_Situation.Actual_TSN, Devis_Situation.Devis_BXL, Devis_Situation.[Actual Wal B] as [Actual BXL], Devis_Situation.Devis_WAL, Devis_Situation.[Actual Wal W] as [Actual Wal], Devis_Situation.Engagé - Devis_Situation.[Actual Copro N] as [Verif Dep N] FROM Devis_Situation WHERE [Film_Code] = 'FIT' ORDER BY Film_Code, Chapitre, [Section], Rubrique

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

LIST_FILMS_445793730092593

Nos Productions

ANGA Production_NosProductions

select * from WEBDATA_FILMs

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

LIST_FILMS_445795960069444

Nos Productions

ANGA Production_NosProductions

select * from WEBDATA_FILMs

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

FILM_PROD_INFOS_445796845023148

Films - Infos

ANGA Production_Films-Infos

SELECT Film_Jnl.Terminaison as Nro, Film_Product_Infos.Code, Film_Jnl.TitreFilm, Film_Jnl.Type_Film, Film_Jnl.Sortie, Film_Product_Infos.Producteur_Nom, Film_Product_Infos.Producteur_Email, Film_Product_Infos.Producteur_Tel, Film_Product_Infos.Dir_Production_Nom, Film_Product_Infos.Dir_Production_Email, Film_Product_Infos.Dir_Production_Tel, Film_Product_Infos.Dir_Post_Prod_Nom, Film_Product_Infos.Dir_Post_Prod_Email, Film_Product_Infos.Dir_Post_Prod_Tel, Film_Product_Infos.Distributeur_Nom, Film_Product_Infos.Distributeur_Email, Film_Product_Infos.Distributeur_Tel FROM Film_Jnl INNER JOIN Film_Product_Infos ON Film_Jnl.CodeFilm = Film_Product_Infos.Code;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_445863904166667

Attestations TaxShelter

ANGA Production_AttestationsTaxShelter

SELECT Tax_SHELTER.Dossier, Tax_SHELTER.Film, Tax_SHELTER.[N° doc], Tax_SHELTER.[Code Film], Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Montant HT], Tax_SHELTER.TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Tot TS T] AS [Montant Total], Tax_SHELTER.[Cumul TS], Tax_SHELTER.[Direct TS], Tax_SHELTER.[25%], Tax_SHELTER.[Cumul TS Direct], Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Cumul TS Indirect], Tax_SHELTER.[Non TS], Tax_SHELTER.Document, [Link Archive], [Commentaire Ana], TCE,ExtraZone FROM Tax_SHELTER Where [Code Film] = 'SIL' order by dossier, Tax_SHELTER.[Date Doc], [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

PL_FILMS_446006458101852

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.[Tiers Client / Fournisseur], cstr('<div style=width:50px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' >' & [Type Dist] & '</div>') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'LBN' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

PL_FILMS_446014747800926

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.[Tiers Client / Fournisseur], cstr('<div style=width:50px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' >' & [Type Dist] & '</div>') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] <> '' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

FILMS_JNL_446095183333333

Films - Table Officielle

ANGA Production_Films-TableOfficielle

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

PL_FILMS_446286686342593

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] <> '' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

FILM_VENTE_TBL_446444312384259

Etat des financements

ANGA Production_Etatdesfinancements

SELECT Film_Contrats_Ventes.[Actif] AS GrpStatus, Film_Contrats_Ventes.Client_1 & ' - ' & Client_2 & ' - ' & [Dossier] AS GrpCtrct, [Film Code] & ' - ' & [TitreFilm] AS GrpFilm, Film_Contrats_Ventes.Dossier, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & Archive1 & ' target=myPdf >' & Film_Contrats_Ventes.Contract_Doc & '</a>'AS Contract, Film_Contrats_Ventes.[Film Code], Film_Contrats_Ventes.Client_1 AS Client, Film_Contrats_Ventes.Client_2 AS Détail, Film_Contrats_Ventes.[Contract Part] AS Tranche, Film_Contrats_Ventes.[Contract Status] AS Statut, Film_Contrats_Ventes.[Montant Prévu] as [Montant Total], iif( [Contract Status]<>'Payé',[Montant Prévu]) as [Montant Prévu], iif( [Contract Status]='Payé',[Montant Prévu]) as [Montant Reçu], Film_Contrats_Ventes.Commentaire, Film_Contrats_Ventes.Escompte, '' AS COLSEPAR, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & Archive2 & ' target=myPdf >' & Film_Contrats_Ventes.[Doc Facture] & '</a>'AS [Doc Facture], Film_Contrats_Ventes.[Date FA], Film_Contrats_Ventes.Rappel, Film_Contrats_Ventes.[Doc Paiement], Film_Contrats_Ventes.[Date Paid], Film_Contrats_Ventes.Notes, Film_Contrats_Ventes.[Actif], '' AS COLSEPAR1, Film_Contrats_Ventes.[Salaire Prod], Film_Contrats_Ventes.[Tot Contrat], Film_Contrats_Ventes.[Date Fact], Film_Contrats_Ventes.[Ref Fact], iif( Film_Contrats_Ventes.Actif='1 Signature', ' font-weight:bold; ', IIf([Contract Status]='A fact.',' color:blue; ',IIf([Contract Status]='Emis',' color:green; ',''))) AS RowStyle FROM Film_Contrats_Ventes INNER JOIN Film_Jnl ON Film_Contrats_Ventes.[Film Code] = Film_Jnl.CodeFilm ORDER BY [Contract No] & 'du ' & [Contract Part];

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Films_Vente.accdb

Delete

Test

ROYALTY_MNGR_P_446494451736111

Royalty Manager

ANGA Production_RoyaltyManager

SELECT id, Film_Code, Film_Title, Fournisseur, Territoire, '<span><a target=interface href=royalty_report_p.asp?film=' & film_Code & '&four=' & Fournisseur & '>Vers Interface</a></span>' AS Report, Prc_Salles, Prc_Video, Prc_VOD, Prc_TV, RNPP_Anga, RNPP_AgicPro, RNPP_Monde, RNPP_Divers,RNPP_Divers_Lib, MG, Comments,Distributeur,End_exploit,Num_Contrat FROM Royalty_Mngr where Film_Code <> '' order by Film_Code,Fournisseur

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\RoyaltyPeriode.accdb

Delete

Test

FILM_VENTE_TBL_446575347337963

Etat des financements

ANGA Production_Etatdesfinancements

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Films_Vente.accdb

Delete

Test

FILM_VENTE_TBL_446916172106481

Etat des financements

ANGA Production_Etatdesfinancements

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Films_Vente.accdb

Delete

Test

DEVIS_TAX_SHELTER_EXTERNE_PLUS_V1_446975110763889

Devis Tax Shelter

ANGA Production_DevisTaxShelter

SELECT Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique as [Code], CA_GEN, Devis_Situation.Rubrique_Libel as Libellé, iif ( Ca_Cmts is null,'<div class="divCmts" id="MODIFY_COMMENT_01" onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_COMMENT_01" valcmts onclick="clickAction(event)" ></div>') as Cmts, iif((CA_Pdf is null or CA_PDF = ''),'<div class="divPdf" updCode="FILM_DOCS_CA" uk="' & [Devis_Situation].[Film_Code] & '|' & [Devis_Situation].[Rubrique] & '" ></div>','<div class="divPdf" updCode="FILM_DOCS_CA" uk="' & [Devis_Situation].[Film_Code] & '|' & [Devis_Situation].[Rubrique] & '" valPdf=' & [CA_Pdf] & ' ></div>') as Pdf, iif ( Fact is null,'<div class="divCmts" id="MODIFY_FACT_01" target="Fact" noexcla tac onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_FACT_01" valcmts noexcla tac target="Fact" onclick="clickAction(event)" >' & Fact & '</div>') as [Fact],iif ( Reg is null,'<div class="divCmts" id="MODIFY_REG_01" target="Reg" noexcla tac onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_REG_01" valcmts noexcla tac target="Reg" onclick="clickAction(event)" >' & Reg & '</div>') as [Reg],iif ( CA_Supplier is null,'<div class="divCmts" id="MODIFY_SUPPLIER_01" target="Supplier" onclick="clickAction(event)" noexcla tac ></div>','<div class="divCmts" id="MODIFY_SUPPLIER_01" valcmts noexcla tac target="Supplier" onclick="clickAction(event)" >' & CA_Supplier & '</div>') as [Supplier], '' as COLSEPAR, Devis_Situation.Amount_Tot as Devis, Devis_Situation.Extra_Tot as [Extra Devis], Devis_Situation.Devis_Tot as [Tot Devis], Devis_Benef_Perte.Devis_Tot_New as [New Devis], Devis_Situation.Engagé, Devis_Situation.Solde_Tmp as [Solde Devis] , Devis_Benef_Perte.[Bénéfice Tmp], Devis_Benef_Perte.[Perte Tmp] , Devis_Situation.Closed, Devis_Benef_Perte.[Bénéfice Glb] as [Bénéf Total], Devis_Benef_Perte.[Perte Glb] as [Perte Total], '' AS COLSEPAR8, Devis_Situation.Amount_TSD AS [Direct D], Devis_Situation.Extra_TSD AS [Extra D], Devis_Benef_Perte.Devis_TD_New AS [New Direct D], Devis_Situation.Actual_TD AS [Engagé D], [Solde TD Tmp] AS [Solde D], '' AS COLSEPAR9, Devis_Situation.Amount_TS25 AS [Direct 25], Devis_Situation.Extra_TS25 AS [Extra 25], Devis_Benef_Perte.Devis_T25_New AS [New Direct 25], Devis_Situation.Actual_T25 AS [Engagé 25], Devis_Benef_Perte.[Solde T25 Tmp] AS [Solde 25], '' as COLSEPAR1, Devis_Situation.Amount_TSD2 as [Direct D25], Devis_Situation.Extra_TSD2 as [Extra D25], Devis_Benef_Perte.[Devis_TD25_New] as [New Direct D25] , Devis_Situation.Actual_TD25 as [Engagé D25], Devis_Benef_Perte.[Solde TD25 Tmp] as [Solde D25], '' as COLSEPAR2, Devis_Situation.Amount_TSI as [Indirect], Devis_Situation.Extra_TSI as [Extra I], Devis_Benef_Perte.[Devis_TI_New] as [New Indirect] ,Devis_Situation.Actual_TI as [Engagé I], Devis_Benef_Perte.[Solde TI Tmp] as [Solde I], '' as COLSEPAR3, iif(Amount_TSD2 is null,0,[Amount_TSD2]) + iif(Extra_TSD2 is null,0,[Extra_TSD2]) + iif(Amount_TSI is null,0,[Amount_TSI]) + iif(Extra_TSI is null,0,[Extra_TSI]) as [Total D&I], Devis_Benef_Perte.[Devis_TD25_New] + Devis_Benef_Perte.[Devis_TI_New] as [New Total D&I], iif(Actual_TD25 is null,0,[Actual_TD25]) + iif(Actual_TI is null,0,[Actual_TI]) as [Engagé D&I], iif([Solde D25] is null,0,[Solde D25]) + iif([Solde I] is null,0,[Solde I]) as [Solde D&I], '' as COLSEPAR4, Devis_Situation.Amount_NTS as [Devis NTS], Devis_Situation.Extra_NTS as [Extra NTS], Devis_Benef_Perte.[Devis_NTS_New] as [New NTS] , Devis_Situation.Actual_TSN as [Engagé NTS], iif([Devis_Situation.Closed] and [Perte Glb] >0 ,'color:red |font-weight:bold ', iif([Devis_Situation.Solde] < 0 ,'color:red')) as RowStyle FROM Devis_Situation INNER JOIN Devis_Benef_Perte ON (Devis_Situation.Rubrique = Devis_Benef_Perte.Rubrique) AND (Devis_Situation.Film_Code = Devis_Benef_Perte.Film_Code) WHERE not Devis_Situation.Rubrique in('ZZ0ANG','ZZ0CCE','ZZ0PAN') and Devis_Situation.Film_Code = 'EST' ORDER BY Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_447206594675926

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc], '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'BON' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc], '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, Null, [Code Film] HAVING [Code Film] = 'BON' union SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc], [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'BON' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

DEVIS_TAX_SHELTER_EXTERNE_PLUS_V1_447216483101852

Devis Tax Shelter

ANGA Production_DevisTaxShelter

SELECT Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique as [Code], CA_GEN, Devis_Situation.Rubrique_Libel as Libellé, iif ( Ca_Cmts is null,'<div class="divCmts" id="MODIFY_COMMENT_01" onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_COMMENT_01" valcmts onclick="clickAction(event)" ></div>') as Cmts, iif((CA_Pdf is null or CA_PDF = ''),'<div class="divPdf" updCode="FILM_DOCS_CA" uk="' & [Devis_Situation].[Film_Code] & '|' & [Devis_Situation].[Rubrique] & '" ></div>','<div class="divPdf" updCode="FILM_DOCS_CA" uk="' & [Devis_Situation].[Film_Code] & '|' & [Devis_Situation].[Rubrique] & '" valPdf=' & [CA_Pdf] & ' ></div>') as Pdf, iif ( Fact is null,'<div class="divCmts" id="MODIFY_FACT_01" target="Fact" noexcla tac onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_FACT_01" valcmts noexcla tac target="Fact" onclick="clickAction(event)" >' & Fact & '</div>') as [Fact],iif ( Reg is null,'<div class="divCmts" id="MODIFY_REG_01" target="Reg" noexcla tac onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_REG_01" valcmts noexcla tac target="Reg" onclick="clickAction(event)" >' & Reg & '</div>') as [Reg],iif ( Ts is null,'<div class="divCmts" id="MODIFY_TS_01" target="Ts" noexcla tac onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_TS_01" valcmts noexcla tac target="Ts" onclick="clickAction(event)" >' & Ts & '</div>') as [Ts],iif ( CA_Supplier is null,'<div class="divCmts" id="MODIFY_SUPPLIER_01" target="Supplier" onclick="clickAction(event)" noexcla tac ></div>','<div class="divCmts" id="MODIFY_SUPPLIER_01" valcmts noexcla tac target="Supplier" onclick="clickAction(event)" >' & CA_Supplier & '</div>') as [Supplier], '' as COLSEPAR, Devis_Situation.Amount_Tot as Devis, Devis_Situation.Extra_Tot as [Extra Devis], Devis_Situation.Devis_Tot as [Tot Devis], Devis_Benef_Perte.Devis_Tot_New as [New Devis], Devis_Situation.Engagé, Devis_Situation.Solde_Tmp as [Solde Devis] , Devis_Benef_Perte.[Bénéfice Tmp], Devis_Benef_Perte.[Perte Tmp] , Devis_Situation.Closed, Devis_Benef_Perte.[Bénéfice Glb] as [Bénéf Total], Devis_Benef_Perte.[Perte Glb] as [Perte Total], '' AS COLSEPAR8, Devis_Situation.Amount_TSD AS [Direct D], Devis_Situation.Extra_TSD AS [Extra D], Devis_Benef_Perte.Devis_TD_New AS [New Direct D], Devis_Situation.Actual_TD AS [Engagé D], [Solde TD Tmp] AS [Solde D], '' AS COLSEPAR9, Devis_Situation.Amount_TS25 AS [Direct 25], Devis_Situation.Extra_TS25 AS [Extra 25], Devis_Benef_Perte.Devis_T25_New AS [New Direct 25], Devis_Situation.Actual_T25 AS [Engagé 25], Devis_Benef_Perte.[Solde T25 Tmp] AS [Solde 25], '' as COLSEPAR1, Devis_Situation.Amount_TSD2 as [Direct D25], Devis_Situation.Extra_TSD2 as [Extra D25], Devis_Benef_Perte.[Devis_TD25_New] as [New Direct D25] , Devis_Situation.Actual_TD25 as [Engagé D25], Devis_Benef_Perte.[Solde TD25 Tmp] as [Solde D25], '' as COLSEPAR2, Devis_Situation.Amount_TSI as [Indirect], Devis_Situation.Extra_TSI as [Extra I], Devis_Benef_Perte.[Devis_TI_New] as [New Indirect] ,Devis_Situation.Actual_TI as [Engagé I], Devis_Benef_Perte.[Solde TI Tmp] as [Solde I], '' as COLSEPAR3, iif(Amount_TSD2 is null,0,[Amount_TSD2]) + iif(Extra_TSD2 is null,0,[Extra_TSD2]) + iif(Amount_TSI is null,0,[Amount_TSI]) + iif(Extra_TSI is null,0,[Extra_TSI]) as [Total D&I], Devis_Benef_Perte.[Devis_TD25_New] + Devis_Benef_Perte.[Devis_TI_New] as [New Total D&I], iif(Actual_TD25 is null,0,[Actual_TD25]) + iif(Actual_TI is null,0,[Actual_TI]) as [Engagé D&I], iif([Solde D25] is null,0,[Solde D25]) + iif([Solde I] is null,0,[Solde I]) as [Solde D&I], '' as COLSEPAR4, Devis_Situation.Amount_NTS as [Devis NTS], Devis_Situation.Extra_NTS as [Extra NTS], Devis_Benef_Perte.[Devis_NTS_New] as [New NTS] , Devis_Situation.Actual_TSN as [Engagé NTS], iif([Devis_Situation.Closed] and [Perte Glb] >0 ,'color:red |font-weight:bold ', iif([Devis_Situation.Solde] < 0 ,'color:red')) as RowStyle FROM Devis_Situation INNER JOIN Devis_Benef_Perte ON (Devis_Situation.Rubrique = Devis_Benef_Perte.Rubrique) AND (Devis_Situation.Film_Code = Devis_Benef_Perte.Film_Code) WHERE not Devis_Situation.Rubrique in('ZZ0ANG','ZZ0CCE','ZZ0PAN') and Devis_Situation.Film_Code = 'EST' ORDER BY Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER2_447286644444444

Attestations TaxShelter - Smart

ANGA Production_AttestationsTaxShelter-Smart

SELECT dossier , [Code Film],année & '-' & Prd as Period, Tax_SHELTER.Film, Tax_SHELTER.[Date Doc], Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[N° doc], Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[Montant HT], TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Direct TS], [25%] , Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Non TS], iif(right([Code TS],1)='N', [Montant HT] ,0) as [Total (N)], Tax_SHELTER.Document,[Commentaire ANA] as [Commentaire], TCE FROM Tax_SHELTER Where ( dossier <> 'cce' or [CA Complet] like '95%' ) and [Code Film] = 'EST' order by dossier, [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_44734454212963

Situation 6 chiffres Compta Détails

ANGA Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc], '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'PFL' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc], '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, Null, [Code Film] HAVING [Code Film] = 'PFL' union SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc], [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'PFL' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

EMP_REQUEST_FULL_447764019328704

Demande d'information contrat

ANGA Production_Demanded'informationcontrat

SELECT '(' & [project_code] & ') ' & [project_title] AS Film, Employee_request.email, Employee_request.NUM281, Employee_request.FIRNAME281, Employee_request.SECNAME281, Employee_request.sending_date, Employee_request.response_date FROM Employee_request INNER JOIN project_infos ON Employee_request.Projet = project_infos.project_code;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_RECU_447765075694444

Demande d'information contrat

ANGA Production_Demanded'informationcontrat

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_FULL_447767245023148

Demande d'information contrat

ANGA Production_Demanded'informationcontrat

SELECT '(' & [project_code] & ') ' & [project_title] AS Film,status,Employee_request.SECNAME281,Employee_request.FIRNAME281, Employee_request.email,telnumber, Employee_request.NUM281, Employee_request.sending_date, Employee_request.response_date FROM Employee_request INNER JOIN project_infos ON Employee_request.Projet = project_infos.project_code where status <> 'NOT_SEND' order by SECNAME281,FIRNAME281,email

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_FULL_447783925925926

Demande d'information contrat

ANGA Production_Demanded'informationcontrat

SELECT Employee_request.id,'(' & [project_code] & ') ' & [project_title] AS Film,status,Employee_request.SECNAME281,Employee_request.FIRNAME281, Employee_request.email,telnumber, Employee_request.NUM281, Employee_request.sending_date, Employee_request.response_date FROM Employee_request INNER JOIN project_infos ON Employee_request.Projet = project_infos.project_code where status <> 'NOT_SEND' order by SECNAME281,FIRNAME281,email

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_RECU_447785027777778

Full infos

ANGA Production_Fullinfos

SELECT Employee_request.*, Employee_request.status, Employee_request.Projet FROM Employee_request WHERE (((Employee_request.status)="ENCODED") AND ((Employee_request.Projet)="VIS"));

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_INJECTED_447837206481481

Employés injectés

ANGA Production_Employésinjectés

SELECT Employee_request.*, Employee_request.status, Employee_request.Projet FROM Employee_request WHERE (((Employee_request.status)="INJECTED") AND ((Employee_request.Projet)="VIS"));

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_INJECTED_447916233101852

Employés injectés

ANGA Production_Employésinjectés

SELECT id,NUMBER,NUM281 as NISS,FIRNAME281 as prénom,SECNAME281 as nom,adress1 as adresse,zipcode,city as ville,region,country as pays,telnumber as telephone,email,IBAN,lang,departement,fonction,emp_statut FROM Employee_request WHERE (((Employee_request.status)="INJECTED") AND ((Employee_request.Projet)="VIS"));

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

PL_FILMS_447975196759259

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'LAP' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

PL_FILMS_447975278703704

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'LAP' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

DEVIS_TAX_SHELTER_EXTERNE_PLUS_V1_448035212268519

Devis Tax Shelter

ANGA Production_DevisTaxShelter

SELECT Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique as [Code], CA_GEN, Devis_Situation.Rubrique_Libel as Libellé, iif ( Ca_Cmts is null,'<div class="divCmts" id="MODIFY_COMMENT_01" onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_COMMENT_01" valcmts onclick="clickAction(event)" ></div>') as Cmts, iif((CA_Pdf is null or CA_PDF = ''),'<div class="divPdf" updCode="FILM_DOCS_CA" uk="' & [Devis_Situation].[Film_Code] & '|' & [Devis_Situation].[Rubrique] & '" ></div>','<div class="divPdf" updCode="FILM_DOCS_CA" uk="' & [Devis_Situation].[Film_Code] & '|' & [Devis_Situation].[Rubrique] & '" valPdf=' & [CA_Pdf] & ' ></div>') as Pdf, iif ( Fact is null,'<div class="divCmts" id="MODIFY_FACT_01" target="Fact" noexcla tac onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_FACT_01" valcmts noexcla tac target="Fact" onclick="clickAction(event)" >' & Fact & '</div>') as [Fact],iif ( Reg is null,'<div class="divCmts" id="MODIFY_REG_01" target="Reg" noexcla tac onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_REG_01" valcmts noexcla tac target="Reg" onclick="clickAction(event)" >' & Reg & '</div>') as [Reg],iif ( Ts is null,'<div class="divCmts" id="MODIFY_TS_01" target="Ts" noexcla tac onclick="clickAction(event)" ></div>','<div class="divCmts" id="MODIFY_TS_01" valcmts noexcla tac target="Ts" onclick="clickAction(event)" >' & Ts & '</div>') as [Ts],iif ( CA_Supplier is null,'<div class="divCmts" id="MODIFY_SUPPLIER_01" target="Supplier" onclick="clickAction(event)" noexcla tac ></div>','<div class="divCmts" id="MODIFY_SUPPLIER_01" valcmts noexcla tac target="Supplier" onclick="clickAction(event)" >' & CA_Supplier & '</div>') as [Supplier], '' as COLSEPAR, Devis_Situation.Amount_Tot as Devis, Devis_Situation.Extra_Tot as [Extra Devis], Devis_Situation.Devis_Tot as [Tot Devis], Devis_Benef_Perte.Devis_Tot_New as [New Devis], Devis_Situation.Engagé, Devis_Situation.Solde_Tmp as [Solde Devis] , Devis_Benef_Perte.[Bénéfice Tmp], Devis_Benef_Perte.[Perte Tmp] , Devis_Situation.Closed, Devis_Benef_Perte.[Bénéfice Glb] as [Bénéf Total], Devis_Benef_Perte.[Perte Glb] as [Perte Total], '' AS COLSEPAR8, Devis_Situation.Amount_TSD AS [Direct D], Devis_Situation.Extra_TSD AS [Extra D], Devis_Benef_Perte.Devis_TD_New AS [New Direct D], Devis_Situation.Actual_TD AS [Engagé D], [Solde TD Tmp] AS [Solde D], '' AS COLSEPAR9, Devis_Situation.Amount_TS25 AS [Direct 25], Devis_Situation.Extra_TS25 AS [Extra 25], Devis_Benef_Perte.Devis_T25_New AS [New Direct 25], Devis_Situation.Actual_T25 AS [Engagé 25], Devis_Benef_Perte.[Solde T25 Tmp] AS [Solde 25], '' as COLSEPAR1, Devis_Situation.Amount_TSD2 as [Direct D25], Devis_Situation.Extra_TSD2 as [Extra D25], Devis_Benef_Perte.[Devis_TD25_New] as [New Direct D25] , Devis_Situation.Actual_TD25 as [Engagé D25], Devis_Benef_Perte.[Solde TD25 Tmp] as [Solde D25], '' as COLSEPAR2, Devis_Situation.Amount_TSI as [Indirect], Devis_Situation.Extra_TSI as [Extra I], Devis_Benef_Perte.[Devis_TI_New] as [New Indirect] ,Devis_Situation.Actual_TI as [Engagé I], Devis_Benef_Perte.[Solde TI Tmp] as [Solde I], '' as COLSEPAR3, iif(Amount_TSD2 is null,0,[Amount_TSD2]) + iif(Extra_TSD2 is null,0,[Extra_TSD2]) + iif(Amount_TSI is null,0,[Amount_TSI]) + iif(Extra_TSI is null,0,[Extra_TSI]) as [Total D&I], Devis_Benef_Perte.[Devis_TD25_New] + Devis_Benef_Perte.[Devis_TI_New] as [New Total D&I], iif(Actual_TD25 is null,0,[Actual_TD25]) + iif(Actual_TI is null,0,[Actual_TI]) as [Engagé D&I], iif([Solde D25] is null,0,[Solde D25]) + iif([Solde I] is null,0,[Solde I]) as [Solde D&I], '' as COLSEPAR4, Devis_Situation.Amount_NTS as [Devis NTS], Devis_Situation.Extra_NTS as [Extra NTS], Devis_Benef_Perte.[Devis_NTS_New] as [New NTS] , Devis_Situation.Actual_TSN as [Engagé NTS], iif([Devis_Situation.Closed] and [Perte Glb] >0 ,'color:red |font-weight:bold ', iif([Devis_Situation.Solde] < 0 ,'color:red')) as RowStyle FROM Devis_Situation INNER JOIN Devis_Benef_Perte ON (Devis_Situation.Rubrique = Devis_Benef_Perte.Rubrique) AND (Devis_Situation.Film_Code = Devis_Benef_Perte.Film_Code) WHERE not Devis_Situation.Rubrique in('ZZ0ANG','ZZ0CCE','ZZ0PAN') and Devis_Situation.Film_Code = 'PFL' ORDER BY Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

PL_FILMS_448095081828704

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'LAP' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

EMP_REQUEST_INJECTED_448176248958333

Employés injectés

ANGA Production_Employésinjectés

SELECT id,Projet,NUMBER,NUM281 as NISS,FIRNAME281 as prénom,SECNAME281 as nom,adress1 as adresse,zipcode,city as ville,region,country as pays,telnumber as telephone,email,IBAN,lang,departement,fonction,emp_statut FROM Employee_request WHERE Employee_request.status="INJECTED"

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_INJECTED_448176288425926

Employés injectés

ANGA Production_Employésinjectés

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_INJECTED_44817629837963

Employés injectés

ANGA Production_Employésinjectés

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_448195554282407

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'SLB' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, Null, [Code Film] HAVING [Code Film] = 'SLB' union SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'SLB' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_TIERS_448336176388889

Clients et fournisseurs

ANGA Production_Clientsetfournisseurs

Select dossier as GrpDossier ,Dossier,[Code Tiers], Company, Poste, Fonction, Soc_Priv, Type_TVA, TVA, NISS, Adresse, zipcode, Ville, Region, Email, Telephone, Master_Csf_Full.[Compte Bancaire], Lng, Master_Csf_Full.[Type Tiers], Email_Decompte from Master_Csf_Full

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_448686827777778

Attestations TaxShelter

ANGA Production_AttestationsTaxShelter

SELECT Tax_SHELTER.Dossier, Tax_SHELTER.Film, Tax_SHELTER.[N° doc], Tax_SHELTER.[Code Film], Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Année] & '-' & Tax_SHELTER.[Prd] AS Periode, Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Montant HT], Tax_SHELTER.TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Direct TS], Tax_SHELTER.[25%], Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Non TS], Tax_SHELTER.Document, [Link Archive], [Commentaire Ana], TCE,ExtraZone FROM Tax_SHELTER Where [Code Film] = 'CON' order by dossier, Tax_SHELTER.[Date Doc], [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

EMP_CONTRATS_448835247685185

Employés et Contrats

ANGA Production_EmployésetContrats

SELECT [Employee_Infos.NUMBER] & " - " & [Employee_Infos.Email] AS Employé, [Employee_Infos.NUMBER] AS num, [Employee_Infos.SECNAME281] AS nom, [Employee_Infos.FIRNAME281] AS prénom, Contrats.refContrat, Employee_Infos.emp_statut, Film_Jnl.CodeFilm, Film_Jnl.TitreFilm, Employee_Infos.fonction, Contrats.Entree, Contrats.Sortie, Contrats.lieu_tournage, Contrats.Jrs, Contrats.BrutJr, Contrats.Repas_Midi, Contrats.Repas_Soir, Contrats.RepasOff, Contrats.Voyage, Contrats.Km, Contrats.Bijoute, Contrats.code_ana FROM (Employee_Infos INNER JOIN Contrats ON Employee_Infos.NUMBER = Contrats.CodeWB) INNER JOIN Film_Jnl ON Contrats.Projet = Film_Jnl.CodeFilm;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

INVESTOR_LIST_448874658333333

Récap Investisseurs

ANGA Production_RécapInvestisseurs

SELECT Film_Jnl.[Actif], [N° Doc Complet], TS_Investor.[Contract No], Vers, TS_Investor.FilmCode as [Code], CCE_csf.name1 AS [Client], 'La Cie Cinema' as [Société de production], TS_Investor.Date_Ctrct as [Date CC], TS_Investor.QP, TS_Investor.Date_Ctrct_New as [Nouv Date CC], Film_Jnl.TitreFilm, TS_Investor.[Investment Amount] as Montant, TS_Investor.Coeff as [Coeff Oblig Dep], TS_Investor.Pay_Date as [Date Paiement TS],round(TS_Investor.[Investment Amount] * Coeff /100,2) as [Oblig DEP], TS_Investor.[Interest Rate] as [Tx intérêt], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=Open_Fct>' & [Contract No] & '</a>' as Archive FROM (TS_Investor INNER JOIN Film_Jnl ON TS_Investor.FilmCode = Film_Jnl.CodeFilm) LEFT JOIN CCE_csf ON TS_Investor.Accountrp = CCE_csf.number WHERE (((Film_Jnl.[Actif])<>False) AND ((TS_Investor.[FilmCode])<>'')) and FilmCode <> '' and (CCE_CSF.type = '2') ORDER BY TS_Investor.Date_Ctrct;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

FILMS_JNL_448876918518519

Films - Table Officielle

ANGA Production_Films-TableOfficielle

SELECT IIf(Film_Jnl.[Actif],'Actifs','Non Actifs') AS GrpActifs, Film_Jnl.DbkCodeACH AS CodeACH, Film_Jnl.DbkCodeNDF AS CodeNDF, Film_Jnl.Terminaison as Nro, Film_Jnl.CodeFilm AS Code, Film_Jnl.TitreFilm, Bilan,Type_Film, Film_Jnl.Status, Film_Jnl.Tournage_Debut AS Trn_Debut, Film_Jnl.Tournage_Fin AS Trn_Fin, Film_Jnl.Copie_0, Film_Jnl.Sortie, Film_Jnl.Prod, Film_Jnl.Postprod, Film_Jnl.Dist, Film_Jnl.[Actif], Film_Jnl.BETV, Film_Jnl.PROX, Film_Jnl.RTBF, Film_Jnl.WalImage, Film_Jnl.SCREEN, Film_Jnl.FWB, Film_Jnl.[Autre Fin], Film_Jnl.TS, Film_Jnl.Coproducteur, Film_Jnl.Pays_Coprod as Pays , Realisateur FROM Film_Jnl ORDER BY Film_Jnl.CodeFilm;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

INVESTOR_LIST_448876996412037

Récap Investisseurs

ANGA Production_RécapInvestisseurs

SELECT Film_Jnl.[Actif], [N° Doc Complet], TS_Investor.[Contract No], Vers, TS_Investor.FilmCode as [Code], CCE_csf.name1 AS [Client], 'La Cie Cinema' as [Société de production], TS_Investor.Date_Ctrct as [Date CC], TS_Investor.QP, TS_Investor.Date_Ctrct_New as [Nouv Date CC], Film_Jnl.TitreFilm, TS_Investor.[Investment Amount] as Montant, TS_Investor.Coeff as [Coeff Oblig Dep], TS_Investor.Pay_Date as [Date Paiement TS],round(TS_Investor.[Investment Amount] * Coeff /100,2) as [Oblig DEP], TS_Investor.[Interest Rate] as [Tx intérêt], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=Open_Fct>' & [Contract No] & '</a>' as Archive FROM (TS_Investor INNER JOIN Film_Jnl ON TS_Investor.FilmCode = Film_Jnl.CodeFilm) LEFT JOIN CCE_csf ON TS_Investor.Accountrp = CCE_csf.number WHERE (((Film_Jnl.[Actif])<>False) AND ((TS_Investor.[FilmCode])<>'')) and FilmCode = 'EST' and (CCE_CSF.type = '2') ORDER BY TS_Investor.Date_Ctrct;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_448935947569444

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'EST' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'EST' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'EST' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

DROITS_MANDATS_FILMS_448946400694444

Films - Droits & Mandats

ANGA Production_Films-Droits&Mandats

SELECT Exploit_Films.Status AS GrpStatus, iif(Archive1 <> null,'0','1') as lnk, iif(Archive1 <> null, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & Exploit_Films.Archive1 & ' target=myPdf >' & Exploit_Films.Contrat & '</a>' , Exploit_Films.Contrat) AS Contract, Exploit_Films.Film_Code as Code, Film_Jnl.TitreFilm, Exploit_Films.Exploitant, Exploit_Films.Tranche as Support, Exploit_Films.[Type Mandat], Exploit_Films.Territoire, Film_Jnl.Sortie, Exploit_Films.[Date Début], Exploit_Films.[Date Fin], Exploit_Films.Comment, Exploit_Films.Status, Exclus FROM Exploit_Films LEFT JOIN Film_Jnl ON Exploit_Films.Film_Code = Film_Jnl.CodeFilm order by Film_Code, [Date fin] desc

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Films_Vente.accdb

Delete

Test

LIST_FILMS_448975309027778

Nos Productions

ANGA Production_NosProductions

select * from WEBDATA_FILMs

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

LIST_FILMS_449014166782407

Nos Productions

ANGA Production_NosProductions

select * from WEBDATA_FILMs

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_449015522222222

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'TRE' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'TRE' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'TRE' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

FILMS_JNL_449504265856482

Films - Table Officielle

ANGA Production_Films-TableOfficielle

SELECT IIf(Film_Jnl.[Actif],'Actifs','Non Actifs') AS GrpActifs, Film_Jnl.DbkCodeACH AS CodeACH, Film_Jnl.DbkCodeNDF AS CodeNDF, Film_Jnl.Terminaison as Nro, Film_Jnl.CodeFilm as Code, Film_Jnl.TitreFilm, Bilan,Type_Film, Film_Jnl.Status, Film_Jnl.Tournage_Debut AS Trn_Debut, Film_Jnl.Tournage_Fin AS Trn_Fin, Film_Jnl.Copie_0, Film_Jnl.Sortie, Film_Jnl.Prod, Film_Jnl.Postprod, Film_Jnl.Dist, Film_Jnl.[Actif], Film_Jnl.BETV, Film_Jnl.PROX, Film_Jnl.RTBF, Film_Jnl.WalImage, Film_Jnl.SCREEN, Film_Jnl.FWB, Film_Jnl.[Autre Fin], Film_Jnl.TS, Film_Jnl.Coproducteur, Film_Jnl.Pays_Coprod as Pays , Realisateur FROM Film_Jnl ORDER BY Film_Jnl.CodeFilm;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_449506869907407

Situation 6 chiffres Compta Détails

ANGA Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'EST' union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'EST' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'EST' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ROYALTY_MNGR_P_449633940046296

Royalty Manager

ANGA Production_RoyaltyManager

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\RoyaltyPeriode.accdb

Delete

Test

PL_FILMS_449636665162037

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'COR' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ROYALTY_MNGR_P_449646406018519

Royalty Manager

ANGA Production_RoyaltyManager

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\RoyaltyPeriode.accdb

Delete

Test

ROYALTY_MNGR_P_449646439814815

Royalty Manager

ANGA Production_RoyaltyManager

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\RoyaltyPeriode.accdb

Delete

Test

INVESTOR_LIST_449716016550926

Récap Investisseurs

ANGA Production_RécapInvestisseurs

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

FILM_VENTE_TBL_449776299074074

Etat des financements

ANGA Production_Etatdesfinancements

SELECT Film_Contrats_Ventes.[Actif] AS GrpStatus, Film_Contrats_Ventes.Client_1 & ' - ' & Client_2 & ' - ' & [Dossier] AS GrpCtrct, [Film Code] & ' - ' & [TitreFilm] AS GrpFilm, Film_Contrats_Ventes.Dossier as grpDossier,Film_Contrats_Ventes.Dossier, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & Archive1 & ' target=myPdf >' & Film_Contrats_Ventes.Contract_Doc & '</a>'AS Contract, Film_Contrats_Ventes.[Film Code], Film_Contrats_Ventes.Client_1 AS Client, Film_Contrats_Ventes.Client_2 AS Détail, Film_Contrats_Ventes.[Contract Part] AS Tranche, Film_Contrats_Ventes.[Contract Status] AS Statut, Film_Contrats_Ventes.[Montant Prévu] as [Montant Total], iif( [Contract Status]<>'Payé',[Montant Prévu]) as [Montant Prévu], iif( [Contract Status]='Payé',[Montant Prévu]) as [Montant Reçu], Film_Contrats_Ventes.Commentaire, Film_Contrats_Ventes.Escompte, '' AS COLSEPAR, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & Archive2 & ' target=myPdf >' & Film_Contrats_Ventes.[Doc Facture] & '</a>'AS [Doc Facture], Film_Contrats_Ventes.[Date FA], Film_Contrats_Ventes.Rappel, Film_Contrats_Ventes.[Doc Paiement], Film_Contrats_Ventes.[Date Paid], Film_Contrats_Ventes.Notes, Film_Contrats_Ventes.[Actif], '' AS COLSEPAR1, Film_Contrats_Ventes.[Salaire Prod], Film_Contrats_Ventes.[Tot Contrat], Film_Contrats_Ventes.[Date Fact], Film_Contrats_Ventes.[Ref Fact], iif( Film_Contrats_Ventes.Actif='1 Signature', ' font-weight:bold; ', IIf([Contract Status]='A fact.',' color:blue; ',IIf([Contract Status]='Emis',' color:green; ',''))) AS RowStyle FROM Film_Contrats_Ventes INNER JOIN Film_Jnl ON Film_Contrats_Ventes.[Film Code] = Film_Jnl.CodeFilm ORDER BY [Contract No] & 'du ' & [Contract Part];

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Films_Vente.accdb

Delete

Test

FILMS_JNL_449996845486111

Films - Table Officielle

ANGA Production_Films-TableOfficielle

SELECT IIf(Film_Jnl.[Actif],'Actifs','Non Actifs') AS GrpActifs, Film_Jnl.Status as StatusGrp, Film_Jnl.DbkCodeACH AS CodeACH, Film_Jnl.DbkCodeNDF AS CodeNDF, Film_Jnl.Terminaison as Nro, Film_Jnl.CodeFilm as Code, Film_Jnl.TitreFilm, Bilan,Type_Film, '' as colsepar01,Film_Jnl.Status, Film_Jnl.Tournage_Debut AS Trn_Debut, Film_Jnl.Tournage_Fin AS Trn_Fin, Film_Jnl.Copie_0, Film_Jnl.Sortie,'' as colsepar02, Film_Jnl.Prod, Film_Jnl.Postprod, Film_Jnl.Dist, Film_Jnl.[Actif],'' as colsepar03, Film_Jnl.BETV, Film_Jnl.PROX, Film_Jnl.RTBF, Film_Jnl.WalImage, Film_Jnl.SCREEN, Film_Jnl.FWB, Film_Jnl.[Autre Fin], Film_Jnl.TS,'' as colsepar04, Film_Jnl.Coproducteur, Film_Jnl.Pays_Coprod as Pays , Realisateur FROM Film_Jnl ORDER BY Film_Jnl.CodeFilm;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER2_450367225347222

Attestations TaxShelter - Smart

ANGA Production_AttestationsTaxShelter-Smart

SELECT dossier ,[Code Film],Tax_SHELTER.[Date Doc], année & '-' & Prd as Period, Tax_SHELTER.Film, Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[N° doc], Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[Montant HT], TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Direct TS], [25%] , Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Non TS], iif(right([Code TS],1)='N', [Montant HT] ,0) as [Total (N)], Tax_SHELTER.Document,[Commentaire ANA] as [Commentaire], TCE FROM Tax_SHELTER Where ( dossier <> 'cce' or [CA Complet] like '95%' ) and [Code Film] = 'MUR' order by dossier, Tax_SHELTER.[Date Doc], [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

SECRETARIAT_450416033333333

Gestion des prestations

ANGA Production_Gestiondesprestations

SELECT Infos_secretariat.id, Infos_secretariat.periode, Infos_secretariat.contrat, Employee_Infos.region as R, Contrats.Projet, Film_Jnl.TitreFilm, Employee_Infos.SECNAME281 as Nom, Employee_Infos.FIRNAME281 as Prénom, Contrats.fonction, Employee_Infos.NUM281, Employee_Infos.emp_statut as statut, Employee_Infos.precompte, Contrats.Entree, Contrats.Sortie, Infos_secretariat.Jrs_199, Infos_secretariat.Ferie_1102, Infos_secretariat.JFR_1167, Infos_secretariat.Malad_1109, Contrats.BrutJr as BrutJrs_2109,(Infos_secretariat.Jrs_199 + Infos_secretariat.Ferie_1102 + Infos_secretariat.JFR_1167 + Malad_1109) * Contrats.BrutJr as BrutMois_2101, Infos_secretariat.Prime_2135, Infos_secretariat.Nuit_2153, Infos_secretariat.H25_3151, Infos_secretariat.H50_3152, Infos_secretariat.H75_3153, ((Infos_secretariat.Jrs_199 + Infos_secretariat.Ferie_1102 + Infos_secretariat.JFR_1167 + Malad_1109) * Contrats.BrutJr ) + Infos_secretariat.Prime_2135 + Infos_secretariat.Nuit_2153 + Infos_secretariat.H25_3151 + Infos_secretariat.H50_3152 + Infos_secretariat.H75_3153 AS totbrut,Infos_secretariat.Repas_2903,Infos_secretariat.Voyage_2357,Infos_secretariat.Km_2938,Infos_secretariat.Bijoute_3315,Infos_secretariat.NDF_2316,Infos_secretariat.Acompte , Infos_secretariat.Valide FROM Film_Jnl INNER JOIN ((Contrats INNER JOIN Employee_Infos ON Contrats.CodeWB = Employee_Infos.NUMBER) INNER JOIN Infos_secretariat ON Contrats.refContrat = Infos_secretariat.contrat) ON Film_Jnl.CodeFilm = Contrats.Projet where todelete=false order by Employee_Infos.SECNAME281 ,Employee_Infos.FIRNAME281

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

DEVIS_FILM_EDIT_ENTRY_CRT_450894762615741

Films - Table Officielle

ANGA Production_Films-TableOfficielle

SELECT Devis_Films_Entry.Film_Code AS GrpFilm, IIf(Devis_Films_Entry.Rubrique Like 'ZZ0000','0Z',IIf(Devis_Situation.Chapitre Is Null,'Titres du devis',Devis_Situation.Chapitre)) AS grpChapitre, Devis_Films_Entry.Film_Code as Films, Devis_Films_Entry.Rubrique as Code, Devis_Films_Entry.CA_Gen as GCA, Devis_Films_Entry.Rubrique_Libel, Devis_Films_Entry.Supplier_Ca, Devis_Films_Entry.Film_Docs_CA_Pdf, Devis_Films_Entry.Fact, Devis_Films_Entry.Reg, '' AS COLSEPAR, Devis_Situation.Amount_Tot AS Devis, Devis_Situation.Extra_Tot AS [Extra Devis], Devis_Films_Entry.Extra_C19 as C19, Devis_Benef_Perte.Devis_Tot_New AS [New Devis], Devis_Situation.Engagé, Devis_Situation.Solde_Tmp AS [Solde Devis], Devis_Films_Entry.Closed as Closed, '' AS Colsepar01, Devis_Films_Entry.Amount_TSD as Amount_D, Devis_Films_Entry.Extra_TSD as Extra_D, Devis_Benef_Perte.Devis_TD_New AS [New_D], Devis_Situation.Actual_TD AS [Engagé_D], Devis_Benef_Perte.[Solde TD Tmp] AS [Solde_D], '' AS Colsepar02, Devis_Films_Entry.Amount_TS25 as Amount_25, Devis_Films_Entry.Extra_TS25 as Extra_25, Devis_Benef_Perte.Devis_T25_New AS [New_25], Devis_Situation.Actual_T25 AS [Engagé_25], Devis_Benef_Perte.[Solde T25 Tmp] AS [Solde_25], '' AS Colsepar04, Devis_Films_Entry.Amount_TSI as Amount_I, Devis_Films_Entry.Extra_TSI as Extra_I, Devis_Benef_Perte.Devis_TI_New AS [New_I], Devis_Situation.Actual_TI AS [Engagé_I], Devis_Benef_Perte.[Solde TI Tmp] AS [Solde_I], '' AS COLSEPAR3, Devis_Films_Entry.Amount_NTS as Amount_N, Devis_Films_Entry.Extra_NTS as Extra_N, Devis_Benef_Perte.Devis_NTS_New AS [New_N], Devis_Situation.Actual_TSN AS [Engagé_N], '' AS COLSEPAR5, Devis_Films_Entry.RL1, Devis_Films_Entry.RL2, Devis_Films_Entry.Supplier, Devis_Films_Entry.ID, IIf([Devis_Situation.Closed] And [Perte Glb]>0,'color:red |font-weight:bold ',IIf([Devis_Situation.Solde]<0,'color:red',iif(Devis_Films_Entry.CA_Gen Like '%[cC]','color:blue',IIf([Devis_Benef_Perte.Devis_Tot_New]=0,'color:#e0e2e5')))) AS RowStyle FROM (Devis_Films_Entry LEFT JOIN Devis_Benef_Perte ON (Devis_Films_Entry.Rubrique = Devis_Benef_Perte.Rubrique) AND (Devis_Films_Entry.Film_Code = Devis_Benef_Perte.Film_Code)) LEFT JOIN Devis_Situation ON (Devis_Films_Entry.Rubrique = Devis_Situation.Rubrique) AND (Devis_Films_Entry.Film_Code = Devis_Situation.Film_Code) Where [Devis_Films_Entry].[Film_Code] = 'ECB' and not Devis_Situation.Rubrique in('ZZ0ANG','ZZ0CCE','ZZ0PAN') order by Devis_Films_Entry.Film_Code, Devis_Films_Entry.Rubrique

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_451124347916667

Attestations TaxShelter

ANGA Production_AttestationsTaxShelter

SELECT Tax_SHELTER.Dossier, Tax_SHELTER.Film, Tax_SHELTER.[N° doc], Tax_SHELTER.[Code Film], Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Année] & '-' & Tax_SHELTER.[Prd] AS Periode, Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Montant HT], Tax_SHELTER.TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Direct TS], Tax_SHELTER.[25%], Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Non TS], Tax_SHELTER.Document, [Link Archive], [Commentaire Ana], TCE,ExtraZone FROM Tax_SHELTER Where [Code Film] = 'ECB' order by dossier, Tax_SHELTER.[Date Doc], [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_451346307175926

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'UAP' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'UAP' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'UAP' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

EMP_REQUEST_INJECTED_451386921875

Employés injectés

ANGA Production_Employésinjectés

SELECT Employee_Infos.NUMBER, Employee_Infos.NUM281 AS NISS, Employee_Infos.FIRNAME281 AS prénom, Employee_Infos.SECNAME281 AS nom,Employee_Infos.fonction,Employee_Infos.departement,Employee_Infos.telnumber AS telephone,Employee_Infos.email, Employee_Infos.adress1 AS adresse, Employee_Infos.zipcode, Employee_Infos.city AS ville, Employee_Infos.region, Employee_Infos.country AS pays, Employee_Infos.IBAN, Employee_Infos.lang, Employee_Infos.emp_statut FROM Employee_Infos order by SECNAME281,FIRNAME281

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

LISTING_WALLIMAGE_45204624849537

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'EST' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

FILMS_JNL_452384223263889

Films - Table Officielle

ANGA Production_Films-TableOfficielle

SELECT IIf(Film_Jnl.[Actif],'Actifs','Non Actifs') AS GrpActifs, Film_Jnl.Status as StatusGrp, Film_Jnl.Terminaison as Nro, Film_Jnl.CodeFilm as Code, Film_Jnl.TitreFilm, Bilan,Type_Film, '' as colsepar01,Film_Jnl.Status, Film_Jnl.Tournage_Debut AS Trn_Debut, Film_Jnl.Tournage_Fin AS Trn_Fin, Film_Jnl.Copie_0, Film_Jnl.Sortie,'' as colsepar02, Film_Jnl.Prod, Film_Jnl.Postprod, Film_Jnl.Dist, Film_Jnl.[Actif],'' as colsepar03, Film_Jnl.BETV, Film_Jnl.PROX, Film_Jnl.RTBF, Film_Jnl.WalImage, Film_Jnl.SCREEN, Film_Jnl.FWB, Film_Jnl.[Autre Fin], Film_Jnl.TS,'' as colsepar04, Film_Jnl.Coproducteur, Film_Jnl.Pays_Coprod as Pays , Realisateur,Film_Jnl.DbkCodeACH AS CodeACH, Film_Jnl.DbkCodeNDF AS CodeNDF FROM Film_Jnl ORDER BY Film_Jnl.CodeFilm;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_452507130439815

Situation 6 chiffres Compta Détails

ANGA Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'UDM' union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'UDM' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'UDM' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_452726900694444

Attestations TaxShelter

ANGA Production_AttestationsTaxShelter

SELECT Tax_SHELTER.Dossier, Tax_SHELTER.Film, Tax_SHELTER.[N° doc], Tax_SHELTER.[Code Film], Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Année] & '-' & Tax_SHELTER.[Prd] AS Periode, Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Montant HT], Tax_SHELTER.TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Direct TS], Tax_SHELTER.[25%], Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Non TS], Tax_SHELTER.Document, [Link Archive], [Commentaire Ana], TCE,ExtraZone FROM Tax_SHELTER Where [Code Film] = 'LSV' order by dossier, Tax_SHELTER.[Date Doc], [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

PL_FILMS_453446855439815

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'ECB' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

EMP_REQUEST_INJECTED_453487156018519

Employés injectés

ANGA Production_Employésinjectés

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

FILMS_JNL_453634512847222

Films - Table Officielle

ANGA Production_Films-TableOfficielle

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_453654449074074

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('SUR') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('SUR') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('SUR') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

DEVIS_FILM_EDIT_ENTRY_CRT_453866672337963

Films - Table Officielle

ANGA Production_Films-TableOfficielle

SELECT Devis_Films_Entry.Film_Code AS GrpFilm, IIf(Devis_Films_Entry.Rubrique Like 'ZZ0000','0Z',IIf(Devis_Situation.Chapitre Is Null,'Titres du devis',Devis_Situation.Chapitre)) AS grpChapitre, Devis_Films_Entry.Film_Code as Films, Devis_Films_Entry.Rubrique as Code, Devis_Films_Entry.CA_Gen as GCA, Devis_Films_Entry.Rubrique_Libel, Devis_Films_Entry.Supplier_Ca, Devis_Films_Entry.Film_Docs_CA_Pdf, Devis_Films_Entry.Fact, Devis_Films_Entry.Reg, '' AS COLSEPAR, Devis_Situation.Amount_Tot AS Devis, Devis_Situation.Extra_Tot AS [Extra Devis], Devis_Films_Entry.Extra_C19 as C19, Devis_Benef_Perte.Devis_Tot_New AS [New Devis], Devis_Situation.Engagé, Devis_Situation.Solde_Tmp AS [Solde Devis], Devis_Films_Entry.Closed as Closed, '' AS Colsepar01, Devis_Films_Entry.Amount_TSD as Amount_D, Devis_Films_Entry.Extra_TSD as Extra_D, Devis_Benef_Perte.Devis_TD_New AS [New_D], Devis_Situation.Actual_TD AS [Engagé_D], Devis_Benef_Perte.[Solde TD Tmp] AS [Solde_D], '' AS Colsepar02, Devis_Films_Entry.Amount_TS25 as Amount_25, Devis_Films_Entry.Extra_TS25 as Extra_25, Devis_Benef_Perte.Devis_T25_New AS [New_25], Devis_Situation.Actual_T25 AS [Engagé_25], Devis_Benef_Perte.[Solde T25 Tmp] AS [Solde_25], '' AS Colsepar04, Devis_Films_Entry.Amount_TSI as Amount_I, Devis_Films_Entry.Extra_TSI as Extra_I, Devis_Benef_Perte.Devis_TI_New AS [New_I], Devis_Situation.Actual_TI AS [Engagé_I], Devis_Benef_Perte.[Solde TI Tmp] AS [Solde_I], '' AS COLSEPAR3, Devis_Films_Entry.Amount_NTS as Amount_N, Devis_Films_Entry.Extra_NTS as Extra_N, Devis_Benef_Perte.Devis_NTS_New AS [New_N], Devis_Situation.Actual_TSN AS [Engagé_N], '' AS COLSEPAR5, Devis_Films_Entry.RL1, Devis_Films_Entry.RL2, Devis_Films_Entry.Supplier, Devis_Films_Entry.ID, IIf([Devis_Situation.Closed] And [Perte Glb]>0,'color:red |font-weight:bold ',IIf([Devis_Situation.Solde]<0,'color:red',iif(Devis_Films_Entry.CA_Gen Like '%[cC]','color:blue',IIf([Devis_Benef_Perte.Devis_Tot_New]=0,'color:#e0e2e5')))) AS RowStyle FROM (Devis_Films_Entry LEFT JOIN Devis_Benef_Perte ON (Devis_Films_Entry.Rubrique = Devis_Benef_Perte.Rubrique) AND (Devis_Films_Entry.Film_Code = Devis_Benef_Perte.Film_Code)) LEFT JOIN Devis_Situation ON (Devis_Films_Entry.Rubrique = Devis_Situation.Rubrique) AND (Devis_Films_Entry.Film_Code = Devis_Situation.Film_Code) Where [Devis_Films_Entry].[Film_Code] = 'ZOR' and not Devis_Situation.Rubrique in('ZZ0ANG','ZZ0CCE','ZZ0PAN') order by Devis_Films_Entry.Film_Code, Devis_Films_Entry.Rubrique

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

DEVIS_FILM_EDIT_ENTRY_EXTRA_CRT_453904112037037

Situation 2 chiffres - Production X

ANGA Production_Situation2chiffres-ProductionX

SELECT Devis_Films_Entry.Film_Code AS GrpFilm, IIf(Devis_Films_Entry.Rubrique ALike 'ZZ0000','0Z',IIf(Devis_Situation.Chapitre Is Null,'Titres du devis',Devis_Situation.Chapitre)) AS grpChapitre, Devis_Films_Entry.Film_Code AS Films, Devis_Films_Entry.CA_Gen AS GCA, Devis_Films_Entry.Rubrique_Libel, '' as Situ1,'' as Situ2,'' as Situ3,'' as Situ4,'' as Situ5,Devis_Situation.Amount_Tot AS Devis, Devis_Situation.Engagé, '' AS Colsepar01, Devis_Situation.Actual_TD AS Direct, Devis_Situation.Actual_T25 AS [25%], Devis_Situation.Actual_TI AS Indirect, Devis_Situation.Actual_TSN AS NTS, IIf([Devis_Situation.Closed] And [Perte Glb]>0,'color:red |font-weight:bold ',IIf([Devis_Situation.Solde]<0,'color:red',iif(Devis_Films_Entry.CA_Gen Like '%[cC]','color:blue',IIf([Devis_Benef_Perte.Devis_Tot_New]=0,'color:#e0e2e5')))) AS RowStyle FROM (Devis_Films_Entry LEFT JOIN Devis_Benef_Perte ON (Devis_Films_Entry.Rubrique = Devis_Benef_Perte.Rubrique) AND (Devis_Films_Entry.Film_Code = Devis_Benef_Perte.Film_Code)) LEFT JOIN Devis_Situation ON (Devis_Films_Entry.Rubrique = Devis_Situation.Rubrique) AND (Devis_Films_Entry.Film_Code = Devis_Situation.Film_Code) Where [Devis_Films_Entry].[Film_Code] = 'ZOR' and not Devis_Situation.Rubrique in('ZZ0ANG','ZZ0CCE','ZZ0PAN') order by Devis_Films_Entry.Film_Code, Devis_Films_Entry.Rubrique

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

EMP_REQUEST_FULL_453923558912037

Gestion des demandes

ANGA Production_Gestiondesdemandes

SELECT Employee_request.id,'(' & [project_code] & ') ' & [project_title] AS Film,status,Employee_request.SECNAME281,Employee_request.FIRNAME281, Employee_request.email,telnumber, Employee_request.NUM281, Employee_request.sending_date,reminder_date, Employee_request.response_date FROM Employee_request INNER JOIN project_infos ON Employee_request.Projet = project_infos.project_code where status <> 'NOT_SEND' and status <> 'INJECTED' and Project_Code in ('DAL') order by SECNAME281,FIRNAME281,email

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_45392359849537

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('DAL') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('DAL') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('DAL') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_453923599884259

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('DAL') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('DAL') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('DAL') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_453934555902778

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('DAL') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('DAL') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('DAL') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_454064913078704

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('DAL') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('DAL') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('DAL') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

STRUCTURE_CA_S_454079122337963

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

SELECT CC_STRUCT.[Poste CC] AS GrpPoste, CC_STRUCT.[Grp CC], CC_STRUCT.[S_Grp CC], CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description],'' as Colsepar, CC_STRUCT.Direct, CC_STRUCT.[25_Prc], CC_STRUCT.Indirect, CC_STRUCT.Non_TS, CC_STRUCT.[Cmts TS] FROM CC_STRUCT WHERE (((CC_STRUCT.[Main])=True)) ORDER BY CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description];

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

LISTING_WALLIMAGE_454144879050926

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'UAP' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

PL_FILMS_454336825

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'UDM' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_454347056018518

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'DAL' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'DAL' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'DAL' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_454426121412037

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'DAL' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'DAL' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'DAL' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_454494348958333

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'DAL' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'DAL' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'DAL' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_454505368402778

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'DAL' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'DAL' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'DAL' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_454605072916667

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'ZOR' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'ZOR' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'ZOR' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_WALLIMAGE_454617079861111

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'UAP' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_WALLIMAGE_454636610763889

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'ZOR' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_454745075694444

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'DAL' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'DAL' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'DAL' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_45474713912037

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'ZOR' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'ZOR' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'ZOR' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_454754007175926

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'ZOR' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'ZOR' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'ZOR' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER2_454786144444444

Attestations TaxShelter - Smart

ANGA Production_AttestationsTaxShelter-Smart

SELECT dossier ,[Code Film],Tax_SHELTER.[Date Doc], année & '-' & Prd as Period, Tax_SHELTER.Film, Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[N° doc], Tax_SHELTER.[Tiers Client / Fournisseur], Tax_SHELTER.[Montant HT], TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Direct TS], [25%] , Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Non TS], iif(right([Code TS],1)='N', [Montant HT] ,0) as [Total (N)], Tax_SHELTER.Document,[Commentaire ANA] as [Commentaire], TCE FROM Tax_SHELTER Where ( dossier <> 'cce' or [CA Complet] like '95%' ) and [Code Film] = 'DAL' order by dossier, Tax_SHELTER.[Date Doc], [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

EMP_REQUEST_FULL_EXP_455264355787037

Gestion des demandes

ANGA Production_Gestiondesdemandes

SELECT *,Employee_request.id,'(' & [project_code] & ') ' & [project_title] AS Film,status,Employee_request.SECNAME281,Employee_request.FIRNAME281, Employee_request.email,telnumber, Employee_request.NUM281,Employee_request.precompte,Employee_request.adress1,Employee_request.zipcode as cp,Employee_request.city as localite,Employee_request.bnkaccnt as [COMPTE BANCAIRE],Employee_request.etat_civil as [ETAT CIVIL],Employee_request.enfants as [ENFANTS A CHARGES],Employee_request.conjoint_nom as [NOM CONJOINT],Employee_request.conjoint_naissance as [DATE NAISSANCE CONJOINT], Employee_request.sending_date,reminder_date, Employee_request.response_date FROM Employee_request INNER JOIN project_infos ON Employee_request.Projet = project_infos.project_code where status <> 'NOT_SEND' and status <> 'INJECTED' and Project_Code = 'DAL' order by SECNAME281,FIRNAME281,email

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

LISTING_WALLIMAGE_455264371296296

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'ZOR' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

EMP_REQUEST_FULL_EXP_455264405671296

Gestion des demandes

ANGA Production_Gestiondesdemandes

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_FULL_EXP_455264408101852

Gestion des demandes

ANGA Production_Gestiondesdemandes

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_FULL_EXP_455264459143519

Gestion des demandes

ANGA Production_Gestiondesdemandes

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_FULL_EXP_45526458275463

Gestion des demandes

ANGA Production_Gestiondesdemandes

SELECT *,Employee_request.id as id,'(' & [project_code] & ') ' & [project_title] AS Film,status,Employee_request.SECNAME281,Employee_request.FIRNAME281, Employee_request.email,telnumber, Employee_request.NUM281,Employee_request.precompte,Employee_request.adress1,Employee_request.zipcode as cp,Employee_request.city as localite,Employee_request.etat_civil as [ETAT CIVIL],Employee_request.enfants as [ENFANTS A CHARGES],Employee_request.conjoint_nom as [NOM CONJOINT],Employee_request.conjoint_naissance as [DATE NAISSANCE CONJOINT], Employee_request.sending_date,reminder_date, Employee_request.response_date FROM Employee_request INNER JOIN project_infos ON Employee_request.Projet = project_infos.project_code where status <> 'NOT_SEND' and status <> 'INJECTED' and Project_Code <> '' order by SECNAME281,FIRNAME281,email

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_FULL_EXP_455264709027778

Gestion des demandes

ANGA Production_Gestiondesdemandes

SELECT Employee_request.id as id,'(' & [project_code] & ') ' & [project_title] AS Film,status,Employee_request.SECNAME281,Employee_request.FIRNAME281, Employee_request.email,telnumber, Employee_request.NUM281,Employee_request.precompte,Employee_request.emp_statut as [statut employé],Employee_request.date_naissance as [Date de Naissance],Employee_request.lieu_naissance as [lieu de naissance],Employee_request.nationalite,Employee_request.adress1,Employee_request.zipcode as cp,Employee_request.city as localite,Employee_request.IBAN,Employee_request.BIC,Employee_request.etat_civil as [ETAT CIVIL],Employee_request.enfants as [ENFANTS A CHARGES],Employee_request.conjoint_nom as [NOM CONJOINT],Employee_request.conjoint_naissance as [DATE NAISSANCE CONJOINT], Employee_request.sending_date,reminder_date, Employee_request.response_date FROM Employee_request INNER JOIN project_infos ON Employee_request.Projet = project_infos.project_code where status <> 'NOT_SEND' and status <> 'INJECTED' and Project_Code = 'DAL' order by SECNAME281,FIRNAME281,email

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_455278206828704

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'DAL' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'DAL' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'DAL' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

EMP_REQUEST_FULL_EXP_455334848148148

Gestion des demandes

ANGA Production_Gestiondesdemandes

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_FULL_EXP_455375083217593

Gestion des demandes

ANGA Production_Gestiondesdemandes

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

EMP_REQUEST_FULL_EXP_455407048032407

Gestion des demandes

ANGA Production_Gestiondesdemandes

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

LISTING_BXL_455414367013889

Listing BXL pour XLS

ANGA Production_ListingBXLpourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier,[Code TS] FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'DAL' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TB','NB') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

DEVIS_ENGAGE_SHORT_455514525231481

Suivi résumé 1 chiffre

ANGA Production_Suivirésumé1chiffre

SELECT Devis_Situation.Film_Code, Devis_Situation.Chapitre, Devis_Situation.[Section], Devis_Situation.Rubrique, Devis_Situation.Rubrique_Libel, Devis_Situation.Closed, Devis_Situation.CA_Gen, Devis_Situation.Devis_Tot, Devis_Situation.Engagé, Devis_Situation.Solde, Devis_Situation.Actual_TD25I, Devis_Situation.Actual_TSN, Devis_Situation.Devis_BXL, Devis_Situation.[Actual Wal B] as [Actual BXL], Devis_Situation.Devis_WAL, Devis_Situation.[Actual Wal W] as [Actual Wal], Devis_Situation.Engagé - Devis_Situation.[Actual Copro N] as [Verif Dep N] FROM Devis_Situation WHERE [Film_Code] = 'KAB' ORDER BY Film_Code, Chapitre, [Section], Rubrique

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

LISTING_TIERS_FILM_455524311342593

Fournisseurs / Film

ANGA Production_Fournisseurs/Film

SELECT DISTINCT Master_ANT.Dossier as GrpDossier,Master_ANT.Dossier, Master_ANT.[Code Film], Master_ANT.[Code Tiers], Master_Csf_Full.Company, Master_Csf_Full.[Type Tiers], Poste, Fonction, Soc_Priv, Type_TVA, TVA, NISS, Adresse, Master_Csf_Full.zipcode, Ville, Region, Email, Telephone, Master_Csf_Full.[Compte Bancaire], Lng, Email_Decompte FROM Master_ANT LEFT JOIN Master_Csf_Full ON (left(Master_ANT.Dossier,20) = left(Master_Csf_Full.Dossier,20)) AND Master_ANT.[Code Tiers] = Master_Csf_Full.[Code Tiers] WHERE Master_ANT.[Code Film] = 'LSV' AND Master_ANT.[Code Tiers] Is Not Null and Master_Csf_Full.[Type Tiers] = 'Fournisseur'

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_TIERS_FILM_455546470717593

Fournisseurs / Film

ANGA Production_Fournisseurs/Film

SELECT DISTINCT Master_ANT.Dossier as GrpDossier,Master_ANT.Dossier, Master_ANT.[Code Film], Master_ANT.[Code Tiers], Master_Csf_Full.Company, Master_Csf_Full.[Type Tiers], Poste, Fonction, Soc_Priv, Type_TVA, TVA, NISS, Adresse, Master_Csf_Full.zipcode, Ville, Region, Email, Telephone, Master_Csf_Full.[Compte Bancaire], Lng, Email_Decompte FROM Master_ANT LEFT JOIN Master_Csf_Full ON (left(Master_ANT.Dossier,20) = left(Master_Csf_Full.Dossier,20)) AND Master_ANT.[Code Tiers] = Master_Csf_Full.[Code Tiers] WHERE Master_ANT.[Code Film] = 'MUR' AND Master_ANT.[Code Tiers] Is Not Null and Master_Csf_Full.[Type Tiers] = 'Fournisseur'

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_WALLIMAGE_455606804513889

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier,[Code TS] FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'DAL' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_WALLIMAGE_45561438912037

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier,[Code TS] FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'DAL' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

STRUCTURE_CA_S_455824519212963

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

SELECT CC_STRUCT.[Poste CC] AS GrpPoste, CC_STRUCT.[Grp CC], CC_STRUCT.[S_Grp CC], CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description],'' as Colsepar, CC_STRUCT.Direct, CC_STRUCT.[25_Prc], CC_STRUCT.Indirect, CC_STRUCT.Non_TS, CC_STRUCT.[Cmts TS] FROM CC_STRUCT WHERE (((CC_STRUCT.[Main])=True)) ORDER BY CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description];

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_S_455824526388889

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

SELECT CC_STRUCT.[Poste CC] AS GrpPoste, CC_STRUCT.[Grp CC], CC_STRUCT.[S_Grp CC], CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description],'' as Colsepar, CC_STRUCT.Direct, CC_STRUCT.[25_Prc], CC_STRUCT.Indirect, CC_STRUCT.Non_TS, CC_STRUCT.[Cmts TS] FROM CC_STRUCT WHERE (((CC_STRUCT.[Main])=True)) ORDER BY CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description];

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_455946557986111

Situation 6 chiffres Prod Détails

Specimen Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_455946563310185

Situation 6 chiffres Prod Détails

Specimen Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ROYALTY_MNGR_P_456034332523148

Royalty Manager

ANGA Production_RoyaltyManager

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\RoyaltyPeriode.accdb

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_456187232060185

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_456187232060185

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_456187232060185

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_456187232175926

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_456226796064815

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_456226854861111

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

EMP_REQUEST_FULL_45623395775463

Gestion des demandes

ANGA Production_Gestiondesdemandes

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_456234924421296

Situation 6 chiffres Prod Détails

Specimen Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

FILMS_JNL_456315127083333

Films - Table Officielle

ANGA Production_Films-TableOfficielle

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_456356384837963

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added,'' as Ext ,Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'DAL' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added,'' as Ext , Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'DAL' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added,TCE as Ext , [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'DAL' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_456774325925926

Situation 6 chiffres Compta Détails

ANGA Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'SUR' union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'SUR' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'SUR' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_WALLIMAGE_456995392013889

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier,[Code TS] FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'KAB' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_45714830462963

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_457487364351852

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_457487375694444

Situation 6 chiffres Prod Détails

Specimen Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

PL_FILMS_457914988078704

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] <> '' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

PL_FILMS_458243991319444

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'LAP' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_458256888888889

Attestations TaxShelter

ANGA Production_AttestationsTaxShelter

SELECT Tax_SHELTER.Dossier, Tax_SHELTER.Film, Tax_SHELTER.[N° doc], Tax_SHELTER.[Code Film], Tax_SHELTER.[N° Doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Année] & '-' & Tax_SHELTER.[Prd] AS Periode, Tax_SHELTER.[Tiers Client / Fournisseur],TCE as Ext, Tax_SHELTER.[CA Complet], Tax_SHELTER.[CA Libelle], Tax_SHELTER.[Code TS], Tax_SHELTER.[Montant HT], Tax_SHELTER.TxTva, Tax_SHELTER.[Montant TTC], Tax_SHELTER.[Tot TS T], Tax_SHELTER.TC2, Tax_SHELTER.[Direct TS], Tax_SHELTER.[25%], Tax_SHELTER.[Indirect TS], Tax_SHELTER.[Non TS], Tax_SHELTER.Document, [Link Archive], [Commentaire Ana],ExtraZone, Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités FROM Tax_SHELTER Where [Code Film] = 'DAL' order by dossier, Tax_SHELTER.[Date Doc], [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_45880498587963

Situation 6 chiffres Prod Détails

Specimen Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

PL_FILMS_458915242824074

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'RAP' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

PL_FILMS_458915975694444

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'LIN' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_459106765740741

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_GRP_FULL_459106831944444

TAX Shelter - CA Complet

Specimen Production_TAXShelter-CAComplet

SELECT * from YVDA_GRP_FULL Where [Code Film] in ('LSK','')

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

PL_FILMS_459174084027778

Decompte charges et Produits

ANGA Production_DecomptechargesetProduits

SELECT Master_ANT.[Code Film], Master_ANT.Dossier, Left([Cpt Compta],3) AS [Grp Compte], [Cpt Compta] , [Libellé Compte], Master_ANT.Jrnl, Master_ANT.[N° Doc], Master_ANT.[Date Doc], Année as GrpYear, Master_ANT.Année & '-' & format(Master_ANT.Mois,'00') as Period, -[master_ant].[Montant] AS Montant, Master_ANT.Doc_Solde as [Doc Payement], Master_ANT.[Pay Date] as [Date Pay], Master_ANT.[Tiers Client / Fournisseur], cstr('<input maxlength=6 style=width:70px class=DEWB sclass=z5 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & '@' & [Ligne Piece] & '@' & [Montant] & ' value="' & [Type Dist] & '" oldvalue="' & [Type Dist] & '" />') as [Type Droits], [CA Complet], [CA Libelle], '<input maxlength=40 docnumber=' & [Dossier] & '@' & [N° Doc Complet] & ' type=text class=DEWB sclass=CMTDOC oldvalue=' & chr(34) & [Commentaire Doc] &chr(34) & ' value=' & chr(34) & [Commentaire Doc] &chr(34) & ' />' as [WB Coment], '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Archive_WB] & ' target=myPdf >' & [N° Doc Complet] & '</a>' as Archive FROM Master_ANT where [Code Film] = 'CTC' and Left([Cpt Compta],3) In ('605','606','705','745','706','746','444') and (not [type Jrnl] in ('OD') or Jrnl = 'ODCONT') order by [CPT Compta], Année, Mois,Master_ANT.[Tiers Client / Fournisseur],[Date Doc]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

STRUCTURE_CA_S_45918700462963

Structure Analytique Devis

ANGA Production_StructureAnalytiqueDevis

SELECT CC_STRUCT.[Poste CC] AS GrpPoste, CC_STRUCT.[Grp CC], CC_STRUCT.[S_Grp CC], CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description],'' as Colsepar, CC_STRUCT.Direct, CC_STRUCT.[25_Prc], CC_STRUCT.Indirect, CC_STRUCT.Non_TS, CC_STRUCT.[Cmts TS] FROM CC_STRUCT WHERE (((CC_STRUCT.[Main])=True)) ORDER BY CC_STRUCT.[Code CC], CC_STRUCT.[Cost Center Description];

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga.mdb

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_459225075925926

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added,'' as Ext ,Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'ALI' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added,'' as Ext , Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'ALI' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added,TCE as Ext , [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'ALI' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_459247345949074

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added,'' as Ext ,Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('ALI') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added,'' as Ext , Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('ALI') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added,TCE as Ext , [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('ALI') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_WALLIMAGE_45929724537037

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier,[Code TS] FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] <> '' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_459305029861111

Situation 6 chiffres Prod Détails

ANGA Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added,'' as Ext ,Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'SAB' union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added,'' as Ext , Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'SAB' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added,TCE as Ext , [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'SAB' and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_459516693055556

Situation 6 chiffres Prod Détails

Specimen Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

LISTING_WALLIMAGE_459604917592593

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier,[Code TS] FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] = 'HPA' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_WALLIMAGE_45987472025463

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier,[Code TS] FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] <> '' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

LISTING_WALLIMAGE_459874782060185

Listing WallImage pour XLS

ANGA Production_ListingWallImagepourXLS

SELECT iif ( [Code1] < '5','Groupe 1 - 4','Groupe 5 - 9') as Code_Group, Libel_1,Libel_2, Tax_SHELTER.[Code Film], Tax_SHELTER.[N° doc Complet], Tax_SHELTER.[Date Doc], Tax_SHELTER.[Tiers Client / Fournisseur] as Fournisseur, [adress1] & ' - ' & [Zipcode] & ' ' & [City] AS Adresse, [Montant HT], Tax_SHELTER.[Pay Date], [Pay Mode] & ' - ' & [Pay Jrnl] AS Modalités, Tax_SHELTER.[Commentaire Doc] AS [Ref Facture], '' AS Col1, '' AS Col2, '' AS Col3, Tax_SHELTER.[Commentaire ANA], iif( not Cmts_Mngr.Cmts_External is null, Cmts_Mngr.Cmts_External,[CA Libelle] ) as [External Comment], Left([Code2],1) & '.' & Right([Code2],1) AS [Type Dep], Tax_SHELTER.Code1 AS Poste, Tax_SHELTER.CodeDevis, '<a href=https://mb23rds10.mslive.one/GetArchive4.asp?' & [Link Archive] & ' target=myPdf >' & Tax_SHELTER.[N° doc] & '</a>' as Archive, Tax_SHELTER.Dossier,[Code TS] FROM (Tax_SHELTER LEFT JOIN Master_Csf ON (Tax_SHELTER.Dossier = Master_Csf.Dossier) AND (Tax_SHELTER.[Code Tiers] = Master_Csf.number)) LEFT JOIN Cmts_Mngr ON Tax_SHELTER.Cmts_Ref_Tag = Cmts_Mngr.Ref_Tag WHERE Tax_SHELTER.[Code Film] <> '' AND (Master_Csf.type='2' Or Master_Csf.type Is Null) and Left([Code TS],2) In ('TW','NW') order by [N° Doc Complet]

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_459896138888889

Situation 6 chiffres Compta Détails

ANGA Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] = 'AGM' union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] = 'AGM' union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] = 'AGM' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\Datas_Anga_WEB.accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_460084005324074

Situation 6 chiffres Prod Détails

Specimen Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_PROD_DETAILS_460084114814815

Situation 6 chiffres Prod Détails

Specimen Production_Situation6chiffresProdDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER WHERE Tax_SHELTER.[Code TS] Like '%N' GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & '-' & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') and Tax_SHELTER.[Code TS] Like '%N' ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

EMP_REQUEST_INJECTED_460295910532407

Employés injectés

ANGA Production_Employésinjectés

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\Angadatas\contrat_employe.accdb

Delete

Test

ATTEST_TAX_SHELTER_GRP_FULL_460425197569444

TAX Shelter - CA Complet

Specimen Production_TAXShelter-CAComplet

SELECT * from YVDA_GRP_FULL Where [Code Film] in ('LSK','')

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_460425202199074

Situation 6 chiffres Compta Détails

Specimen Production_Situation6chiffresComptaDétails

select * from ( SELECT 1 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],1) & '0000000' AS CAC,'' as added, Left([CA Complet],1) AS [CA Comp], Libel_1 AS [CA Libelle], Sum([Montant HT]) AS 1chiffre, Sum(Null) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Left([CA Complet],1) & '0000000', Left([CA Complet],1), Libel_1, null, Null, '', Film, '', '', Null, '', Null, '', Null, Null, '', '', [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 2 AS row_type, now AS date_tri, '' AS Film, '' AS [N° Doc Complet], '' AS [Date Doc],'' as Periode, '' AS [Tiers Client / Fournisseur], Left([CA Complet],2) & '000000' AS CAC,'' as added, Left([CA Complet],2) AS [CA Comp], Libel_2 AS [CA Libelle], Sum(Null) AS 1chiffre, Sum([Montant HT]) AS 2chiffre, Null AS [Montant HT],'' as [Code TS], Null AS [Eligible TS], '' AS TC2, Null AS [Direct TS], '' AS [25%], Null AS [Indirect TS], Null AS [Non TS], '' AS Document, '' AS [Commentaire ANA] FROM Tax_SHELTER GROUP BY Film, Left([CA Complet],2) & '000000', Left([CA Complet],2), Libel_2, null, Null, [Code Film] HAVING [Code Film] in ('LSK','') union all SELECT 3 AS row_type, [Date Doc] AS date_tri, Film, [N° Doc Complet], [Date Doc],[Année] & "-" & Prd as Periode, [Tiers Client / Fournisseur], Left([CA Complet],2) & [CA Complet] AS CAC,'' as added, [CA Complet] AS [CA Comp], [CA Libelle], null AS 1chiffre, null AS 2chiffre, [Montant HT],Tax_SHELTER.[Code TS], [Tot TS T] AS [Eligible TS], TC2, [Direct TS], [25%], [Indirect TS], [Non TS], Document, [Commentaire ANA] FROM Tax_SHELTER WHERE [Code Film] in ('LSK','') ) ORDER BY CAC, date_tri;

Provider=Microsoft.ace.OLEDB.12.0;Data Source=Y:\SnapShot\specimendatas\Specimen_Datas_WEB.Accdb;Mode=Read

Delete

Test