Ticket

TabName

FileName

ATTEST_TAX_SHELTER_6_PROD_DETAILS_462954369444444

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

ATTEST_TAX_SHELTER_6_PROD_DETAILS_462954536458333

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] = 'LEA' 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] = 'LEA' 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] = 'LEA' 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

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_462954567708333

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] = 'SAB' 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] = '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, [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' ) ORDER BY CAC, date_tri;

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

Delete

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_462955720486111

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] = 'LEA' 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] = 'LEA' 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] = 'LEA' ) ORDER BY CAC, date_tri;

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

Delete

ATTEST_TAX_SHELTER_6_COMPTA_DETAILS_462956017361111

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] = 'SAB' 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] = '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, [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' ) ORDER BY CAC, date_tri;

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

Delete