Obiectul Excel funcții raport (RecordsWithExtDimensions)
Detalierea Obiectului : Excel funcții raport (RecordsWithExtDimensions)
Nume Obiect : ExcelReportFunctions_RecordsWithExtDimensions
Nume Tabela Sursa : _Reference6798
Nume View : ExcelReportFunctions_RecordsWithExtDimensions
-
Tabela în care este stocat : _Reference6798
Nu există înregistrări
Guid-uri
- Guid Catalog Id
- Configurație : 4136449d-c231-4b89-9be1-f183d9fe595a
- Bază de date : 0x9BE1F183D9FE595A4B89C2314136449D
- Guid Type Id
- Configurație : 3201e49f-11fd-4c5f-91bb-cebc722934ac
- Bază de date : 0x91BBCEBC722934AC4C5F11FD3201E49F
- Guid Value Id
- Configurație : c07ab148-4286-409b-af2d-c7db3f091f4b
- Bază de date : 0xAF2DC7DB3F091F4B409B4286C07AB148
- Guid Object T Id
- Configurație : 53b25981-4939-4ced-aeb0-5633c23a7522
- Bază de date : 0xAEB05633C23A75224CED493953B25981
- Guid Object V Id
- Configurație : 9981283d-7ed1-45cd-afb6-cdf48944b7a8
- Bază de date : 0xAFB6CDF48944B7A845CD7ED19981283D
Câmpuri
Detaliere Câmpuri
Câmpul KeyField
- Nume Câmp în baza de date : _IDRRef
- Descriere Câmp : Referință către înregistrare
- Tip Câmp : binary
Câmpul Version
- Nume Câmp în baza de date : _Version
- Descriere Câmp : Versiune înregistrare
- Tip Câmp : binary
Câmpul Marked
- Nume Câmp în baza de date : _Marked
- Descriere Câmp : Înregistrare marcată
- Tip Câmp : boolean
Câmpul Metadata
- Nume Câmp în baza de date : _IsMetadata
- Descriere Câmp : Metadate înregistrare
- Tip Câmp : boolean
Câmpul OwnerId
- Nume Câmp în baza de date : _OwnerIDRRef
- Descriere Câmp : Owner-ul documentului
- Tip Câmp : binary
Câmpul Code
- Nume Câmp în baza de date : _Code
- Descriere Câmp : Codul de identificare al înregistrării
- Tip Câmp : string
Câmpul Description
- Nume Câmp în baza de date : _Description
- Descriere Câmp : Descriere înregistrării
- Tip Câmp : string
Câmpul Sign
Nume Câmp în baza de date : _Fld6809RRef
Descriere Câmp : Semn
Tip Câmp : EnumRef.Signs
Guid Atribut Id
- Configurație : d086a25c-0053-454a-94f0-dc2e452e7f56
- Bază de date : 0x94F0DC2E452E7F56454A0053D086A25C
Exemplu de interogari :
select [Sign] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6809RRef] -- Semn when 0x895C1D0151F291DD4B901846BDC7C46C then 'Plus' -- + when 0xAADEA83168EE0E5C48D4616A26F9457E then 'Minus' -- - else null end, -- Valoare necompletata [ExcelReportFunctions_RecordsWithExtDimensions].* from [flax].[dbo].[_Reference6798] as [ExcelReportFunctions_RecordsWithExtDimensions]
Câmpul Indicator
Nume Câmp în baza de date : _Fld6810RRef
Descriere Câmp : Indicator
Tip Câmp : EnumRef.Indicators_RecordsWithExtDimensions
Guid Atribut Id
- Configurație : d66df6e5-f7e1-4ce5-b780-46867d372dd7
- Bază de date : 0xB78046867D372DD74CE5F7E1D66DF6E5
Exemplu de interogari :
select [Indicator] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6810RRef] -- Indicator when 0x8E267BB15B7B625C4D5C3859526A4023 then 'Suma' -- Suma when 0x91D8B116F548C7FB4D49212EE1F0287E then 'SumaValDr' -- SumaValDr when 0xAAF56594ADE25809496BD83A22F1B390 then 'SumaValCr' -- SumaValCr when 0xAC37B6C994199CE64BCB93BDC8F89C12 then 'CountDr' -- CountDr when 0xA13F9EEB0EE495F54C29AB4F2EF113EB then 'CountCr' -- CountCr else null end, -- Valoare necompletata [ExcelReportFunctions_RecordsWithExtDimensions].* from [flax].[dbo].[_Reference6798] as [ExcelReportFunctions_RecordsWithExtDimensions]
Câmpul ExtDimensionTypeDr
Nume Câmp în baza de date : _Fld6811RRef
Descriere Câmp : Tip analitic (Dt)
Tip Câmp : ChartOfCharacteristicTypesRef.TipSubcontoGeneral
Guid Atribut Id
- Configurație : a6b163f7-3a91-4b3b-84d6-315a2b59a508
- Bază de date : 0x84D6315A2B59A5084B3B3A91A6B163F7
Exemplu de interogari :
select [ExtDimensionTypeDr] = [ExtDimensionTypeDr_TipSubcontoGeneral]._Description, -- Tip analitic (Dt) din Tip subconto general [ExtDimensionTypeDr_ID] = [ExtDimensionTypeDr_TipSubcontoGeneral].[_IDRRef], -- KeyField din Tip subconto general [ExcelReportFunctions_RecordsWithExtDimensions].* from [flax].[dbo].[_Reference6798] as [ExcelReportFunctions_RecordsWithExtDimensions] left join [flax].[dbo].[_Chrc203] as [ExtDimensionTypeDr_TipSubcontoGeneral] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6811RRef] = [ExtDimensionTypeDr_TipSubcontoGeneral].[_IDRRef])
Câmpul ExtDimensionTypeCr
Nume Câmp în baza de date : _Fld6812RRef
Descriere Câmp : Tip analitic (Ct)
Tip Câmp : ChartOfCharacteristicTypesRef.TipSubcontoGeneral
Guid Atribut Id
- Configurație : 249433a9-c2bf-49ab-8a17-10f6af148921
- Bază de date : 0x8A1710F6AF14892149ABC2BF249433A9
Exemplu de interogari :
select [ExtDimensionTypeCr] = [ExtDimensionTypeCr_TipSubcontoGeneral]._Description, -- Tip analitic (Ct) din Tip subconto general [ExtDimensionTypeCr_ID] = [ExtDimensionTypeCr_TipSubcontoGeneral].[_IDRRef], -- KeyField din Tip subconto general [ExcelReportFunctions_RecordsWithExtDimensions].* from [flax].[dbo].[_Reference6798] as [ExcelReportFunctions_RecordsWithExtDimensions] left join [flax].[dbo].[_Chrc203] as [ExtDimensionTypeCr_TipSubcontoGeneral] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6812RRef] = [ExtDimensionTypeCr_TipSubcontoGeneral].[_IDRRef])
Câmpul ExtDimensionDr
Nume Câmp în baza de date : _Fld6813
Descriere Câmp : Analitic (Dt)
Tip Câmp : complex
Guid Atribut Id
- Configurație : e7263520-d41f-4921-ac68-bbd65569cf21
- Bază de date : 0xAC68BBD65569CF214921D41FE7263520
Exemplu de interogari :
select [ExtDimensionDr_Id] = [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef], -- Analitic (Dt) [ExtDimensionDr_AvizDeIesire] = N'Aviz de ieșire ' + [ExtDimensionDr_AvizDeIesire].[_Fld743] + ' ' + [ExtDimensionDr_AvizDeIesire].[_Fld744] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_AvizDeIesire].[_Date_Time]), 104), -- Analitic (Dt) din Aviz de ieșire [ExtDimensionDr_AvizDeIesire_ID] = [ExtDimensionDr_AvizDeIesire].[_IDRRef], -- KeyField din Aviz de ieșire [ExtDimensionDr_ComandaService] = [ExtDimensionDr_ComandaService].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ComandaService].[_Date_Time]), 104), -- Analitic (Dt) din Comanda service [ExtDimensionDr_ComandaService_ID] = [ExtDimensionDr_ComandaService].[_IDRRef], -- KeyField din Comanda service [ExtDimensionDr_Venituri] = [ExtDimensionDr_Venituri]._Description, -- Analitic (Dt) din Venituri [ExtDimensionDr_Venituri_ID] = [ExtDimensionDr_Venituri].[_IDRRef], -- KeyField din Venituri [ExtDimensionDr_Import] = N'Import ' + [ExtDimensionDr_Import].[_Fld1360] + ' ' + [ExtDimensionDr_Import].[_Fld1353] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Import].[_Date_Time]), 104), -- Analitic (Dt) din Import [ExtDimensionDr_Import_ID] = [ExtDimensionDr_Import].[_IDRRef], -- KeyField din Import [ExtDimensionDr_Asamblare] = N'Asamblare ' + [ExtDimensionDr_Asamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Asamblare].[_Date_Time]), 104) , -- Analitic (Dt) din Asamblare [ExtDimensionDr_Asamblare_ID] = [ExtDimensionDr_Asamblare].[_IDRRef], -- KeyField din Asamblare [ExtDimensionDr_CheltuieliInAvans] = [ExtDimensionDr_CheltuieliInAvans]._Description, -- Analitic (Dt) din Cheltuieli în avans [ExtDimensionDr_CheltuieliInAvans_ID] = [ExtDimensionDr_CheltuieliInAvans].[_IDRRef], -- KeyField din Cheltuieli în avans [ExtDimensionDr_VenituriInAvans] = [ExtDimensionDr_VenituriInAvans]._Description, -- Analitic (Dt) din Venituri in avans [ExtDimensionDr_VenituriInAvans_ID] = [ExtDimensionDr_VenituriInAvans].[_IDRRef], -- KeyField din Venituri in avans [ExtDimensionDr_CoteTVA] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] -- Analitic (Dt) when 0xB4C7BA8ECAB8E9AA4781AB0C411CD3F7 then 'TVA24' -- 24% when 0x8E93795A2BFED36C41B6F46A053024B3 then 'TVA21' -- 21% when 0x84D7EA11D667B93443492CD03507ECF7 then 'TaxareInversa21' -- Taxare inversă cu cota TVA 21% when 0x916083897E575D3C4BDC5D55A45F4DF9 then 'TVA20' -- 20% when 0x8C1BE8BE1214692E44A8CDC688A8FBD6 then 'TVA19' -- 19% when 0x9BC8FDF9D7F874E645E90A55DC827E17 then 'TVA11' -- 11% when 0xABD86D672B9B5AC34E5679E443BEEC03 then 'TaxareInversa11' -- Taxare inversă cu cota TVA 11% when 0x80332F55AAC32BC94C993597696E1CC8 then 'TVA9' -- 9% when 0x8CE7B143CE2700A342C2E998812E3013 then 'TVA24BunuriDeCapital' -- 24% bunuri de capital when 0xA7CF114FA29E70C14ED698F8D155D6D1 then 'TVA20BunuriDeCapital' -- 20% bunuri de capital when 0x8203DFB60F64D95B45712811F1253CEB then 'TVA19BunuriDeCapital' -- 19% bunuri de capital when 0xBBCC419882DF91A94CFAD82F96C13E88 then 'TVA24NevoileFirmei' -- 24% nevoile firmei when 0x9EEDCAF3CAD4A9214BC5F501072B8ED3 then 'TVA20NevoileFirmei' -- 20% nevoile firmei when 0x80877F489FAEB92C428BA6A6CBB82BA9 then 'TVA19NevoileFirmei' -- 19% nevoile firmei when 0x865D336410F9072441C203F0377FA38C then 'TVA9NevoileFirmei' -- 9% nevoile firmei when 0xBE19D5CA351265EB4AECCDCA5E883434 then 'TVA24Fara' -- 24% fara drept de deducere when 0x8820314B861028A4487963A27F199FB9 then 'TVA20Fara' -- 20% fara drept de deducere when 0x89B17E9CB06A67AD408A8C506B31125D then 'TVA19Fara' -- 19% fara drept de deducere when 0x9CC53A5115830A83494B041D0FBF2B9A then 'TVA9Fara' -- 9% fara drept de deducere when 0x9201A6EA2FABA7F4486ED6550570B1EA then 'TVA5' -- Cota TVA 5% when 0xBF9BD68072E19A6443A6AD318917B35F then 'TVA5Fara' -- 5% fara drept de deducere when 0xA50008B4BC5BB5F6488067F06E225693 then 'TVAEU24' -- TVA la Import din UE cu cota TVA 24% when 0x98CDACE4D8112D17404D89F6EC78E58E then 'TVAEU20' -- TVA la Import din UE cu cota TVA 20% when 0xAA2DE3C795A60A4946C58A73B8C0D3D8 then 'TVAEU9' -- TVA la Import din UE cu cota TVA 9% when 0x9D7F41833CA965AD40D2EF75370D822F then 'TVAEU' -- TVA la Import din UE cu cota TVA 19% when 0xA7343E8E1A0E850E47499B6984E590D0 then 'TVAEUNevoileFirmei24' -- TVA la Import din UE pentru nevoile firmei 24% when 0xADD1FA8C2C531E7C4214C4136C7BE690 then 'TVAEUNevoileFirmei20' -- TVA la Import din UE pentru nevoile firmei 20% when 0xA63CAE39443F3F124E4FE4E5764FECED then 'TVAEUNevoileFirmei' -- TVA la Import din UE pentru nevoile firmei 19% when 0x90E847CAFD85B7D5449935D4869368A8 then 'ScutiteTVA' -- Scutite cu drept de deducere when 0x8475B75F9F772E4F483986B48A433441 then 'ScutiteTVAFara' -- Scutite fără drept de deducere when 0xAD95376DCFAE2A2E4D2EBDC397205D06 then 'ScutiteTVAExport' -- Scutite la Export cu drept de deducere when 0x84CDF3A0C3ED4D014963A725AD3D4325 then 'ScutiteTVAExportFara' -- Scutite la Export fără drept de deducere when 0xBBD8E71C3D67978943A649D63ECD8670 then 'ScutiteTVAEU' -- Scutite la Import din UE destinate revănzării when 0x9C67E1729338633C42C051FA429020BD then 'ScutiteTVAEUNevoileFirmei' -- Scutite la Import din UE pentru nevoile firmei when 0xB3061F8936BA52BC401F2800CDC6BB0C then 'ScutiteTVAExportEUArtA' -- Scutite la Export in UE conf. art.143 alin.2 lit.a) și d) when 0x985FDEF4B5E79BD248AD96AA65D298FA then 'ScutiteTVAExportEUArtB' -- Scutite la Export in UE conf. art.143 alin.2 lit.b) și c) when 0xBEF4E78F4A77E6F44933AE33DB4FC66D then 'ScutiteTVAExportArtC' -- Scutite la Export cu drept de deducere conf. art.143 alin.1 lit.c) și d) when 0x9B960D4C23DC1FB641D65C66EFBA015B then 'Neimpozabile' -- Neimpozabile when 0xA66C90AF717CACA04A14D1188C830084 then 'NeimpozabileEU' -- Neimpozabile la import din UE destinate revănzării when 0xBA28595D7674F34848E03E664F8293C1 then 'NeimpozabileEUNevoileFirmei' -- Neimpozabile la import din UE pentru nevoile firmei when 0x8F47D6FEB598A44147EAB8B39751B55C then 'TaxareInversa24' -- Taxare inversă cu cota TVA 24% when 0x8D85819C3502D9644F3554EF2A4E3205 then 'TaxareInversa20' -- Taxare inversă cu cota TVA 20% when 0x8AD9A80A67D813514E35CC59323A347C then 'TaxareInversa' -- Taxare inversă cu cota TVA 19% when 0xB6A801C6EF4283484A1B0ACE22370816 then 'TaxareInversa9' -- Taxare inversă cu cota TVA 9% when 0x884A08E3B99FD767426E8839E179CA05 then 'TaxareInversaServiciiIntangibile24' -- Taxare inversă servicii intangibile cu cota TVA 24% when 0x91D2395B478FB1C7403B9C973C22F1D2 then 'TaxareInversaServiciiIntangibile20' -- Taxare inversă servicii intangibile cu cota TVA 20% when 0x89574632F1AA15C341325D142FB16ADF then 'TaxareInversaServiciiIntangibile' -- Taxare inversă servicii intangibile cu cota TVA 19% else null end, -- Valoare necompletata [ExtDimensionDr_DecontDeAvans] = [ExtDimensionDr_DecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_DecontDeAvans].[_Date_Time]), 104), -- Analitic (Dt) din Decont de avans [ExtDimensionDr_DecontDeAvans_ID] = [ExtDimensionDr_DecontDeAvans].[_IDRRef], -- KeyField din Decont de avans [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate] = N'Vânzare și servicii prestate ' + [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_Fld2712] + ' ' + [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_Fld2707] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_Date_Time]), 104) , -- Analitic (Dt) din Vânzare și servicii prestate [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate_ID] = [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_IDRRef], -- KeyField din Vânzare și servicii prestate [ExtDimensionDr_IntroducereaSoldurilor] = [ExtDimensionDr_IntroducereaSoldurilor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_IntroducereaSoldurilor].[_Date_Time]), 104), -- Analitic (Dt) din Introducere solduri [ExtDimensionDr_IntroducereaSoldurilor_ID] = [ExtDimensionDr_IntroducereaSoldurilor].[_IDRRef], -- KeyField din Introducere solduri [ExtDimensionDr_CorectieAnaliticiDecontDeAvans] = [ExtDimensionDr_CorectieAnaliticiDecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_CorectieAnaliticiDecontDeAvans].[_Date_Time]), 104), -- Analitic (Dt) din Corectie analitici decont de avans [ExtDimensionDr_CorectieAnaliticiDecontDeAvans_ID] = [ExtDimensionDr_CorectieAnaliticiDecontDeAvans].[_IDRRef], -- KeyField din Corectie analitici decont de avans [ExtDimensionDr_AlteCheltuieliSiVenituri] = [ExtDimensionDr_AlteCheltuieliSiVenituri]._Description, -- Analitic (Dt) din Alte cheltuieli și venituri [ExtDimensionDr_AlteCheltuieliSiVenituri_ID] = [ExtDimensionDr_AlteCheltuieliSiVenituri].[_IDRRef], -- KeyField din Alte cheltuieli și venituri [ExtDimensionDr_Departamente] = [ExtDimensionDr_Departamente]._Description, -- Analitic (Dt) din Departamente [ExtDimensionDr_Departamente_ID] = [ExtDimensionDr_Departamente].[_IDRRef], -- KeyField din Departamente [ExtDimensionDr_Organizatii] = [ExtDimensionDr_Organizatii]._Description, -- Analitic (Dt) din Societăți [ExtDimensionDr_Organizatii_ID] = [ExtDimensionDr_Organizatii].[_IDRRef], -- KeyField din Societăți [ExtDimensionDr_EfecteDePrimit] = [ExtDimensionDr_EfecteDePrimit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_EfecteDePrimit].[_Date_Time]), 104), -- Analitic (Dt) din Efecte de primit [ExtDimensionDr_EfecteDePrimit_ID] = [ExtDimensionDr_EfecteDePrimit].[_IDRRef], -- KeyField din Efecte de primit [ExtDimensionDr_Incasare] = N'Dispoziție de încasare ' + [ExtDimensionDr_Incasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Incasare].[_Date_Time]), 104) , -- Analitic (Dt) din Dispoziție de încasare [ExtDimensionDr_Incasare_ID] = [ExtDimensionDr_Incasare].[_IDRRef], -- KeyField din Dispoziție de încasare [ExtDimensionDr_ExtrasDeCont] = N'Extras de cont ' + [ExtDimensionDr_ExtrasDeCont].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ExtrasDeCont].[_Date_Time]), 104), -- Analitic (Dt) din Extras de cont [ExtDimensionDr_ExtrasDeCont_ID] = [ExtDimensionDr_ExtrasDeCont].[_IDRRef], -- KeyField din Extras de cont [ExtDimensionDr_ReturDeLaClient] = N'Retur de la client ' + [ExtDimensionDr_ReturDeLaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ReturDeLaClient].[_Date_Time]), 104) , -- Analitic (Dt) din Retur de la client [ExtDimensionDr_ReturDeLaClient_ID] = [ExtDimensionDr_ReturDeLaClient].[_IDRRef], -- KeyField din Retur de la client [ExtDimensionDr_Dezasamblare] = N'Dezasamblare ' + [ExtDimensionDr_Dezasamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Dezasamblare].[_Date_Time]), 104) , -- Analitic (Dt) din Dezasamblare [ExtDimensionDr_Dezasamblare_ID] = [ExtDimensionDr_Dezasamblare].[_IDRRef], -- KeyField din Dezasamblare [ExtDimensionDr_Cheltuieli] = [ExtDimensionDr_Cheltuieli]._Description, -- Analitic (Dt) din Cheltuieli [ExtDimensionDr_Cheltuieli_ID] = [ExtDimensionDr_Cheltuieli].[_IDRRef], -- KeyField din Cheltuieli [ExtDimensionDr_Export] = [ExtDimensionDr_Export].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Export].[_Date_Time]), 104), -- Analitic (Dt) din Export [ExtDimensionDr_Export_ID] = [ExtDimensionDr_Export].[_IDRRef], -- KeyField din Export [ExtDimensionDr_CasareMF] = [ExtDimensionDr_CasareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_CasareMF].[_Date_Time]), 104), -- Analitic (Dt) din Casare MF [ExtDimensionDr_CasareMF_ID] = [ExtDimensionDr_CasareMF].[_IDRRef], -- KeyField din Casare MF [ExtDimensionDr_Casierii] = [ExtDimensionDr_Casierii]._Description, -- Analitic (Dt) din Casierii [ExtDimensionDr_Casierii_ID] = [ExtDimensionDr_Casierii].[_IDRRef], -- KeyField din Casierii [ExtDimensionDr_ImobilizariNecorporale] = [ExtDimensionDr_ImobilizariNecorporale]._Description, -- Analitic (Dt) din Imobilizari necorporale [ExtDimensionDr_ImobilizariNecorporale_ID] = [ExtDimensionDr_ImobilizariNecorporale].[_IDRRef], -- KeyField din Imobilizari necorporale [ExtDimensionDr_IntroducereaSoldurilorAmanunt] = [ExtDimensionDr_IntroducereaSoldurilorAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_IntroducereaSoldurilorAmanunt].[_Date_Time]), 104), -- Analitic (Dt) din Introducere solduri amănunt [ExtDimensionDr_IntroducereaSoldurilorAmanunt_ID] = [ExtDimensionDr_IntroducereaSoldurilorAmanunt].[_IDRRef], -- KeyField din Introducere solduri amănunt [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale] = [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale]._Description, -- Analitic (Dt) din Operații trezoreriale [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale_ID] = [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale].[_IDRRef], -- KeyField din Operații trezoreriale [ExtDimensionDr_ConturiBancare] = [ExtDimensionDr_ConturiBancare]._Description, -- Analitic (Dt) din Conturi bancare [ExtDimensionDr_ConturiBancare_ID] = [ExtDimensionDr_ConturiBancare].[_IDRRef], -- KeyField din Conturi bancare [ExtDimensionDr_EfecteDePlatit] = [ExtDimensionDr_EfecteDePlatit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_EfecteDePlatit].[_Date_Time]), 104), -- Analitic (Dt) din Efecte de plătit [ExtDimensionDr_EfecteDePlatit_ID] = [ExtDimensionDr_EfecteDePlatit].[_IDRRef], -- KeyField din Efecte de plătit [ExtDimensionDr_RaportDeProductie] = [ExtDimensionDr_RaportDeProductie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_RaportDeProductie].[_Date_Time]), 104), -- Analitic (Dt) din Raport de producție [ExtDimensionDr_RaportDeProductie_ID] = [ExtDimensionDr_RaportDeProductie].[_IDRRef], -- KeyField din Raport de producție [ExtDimensionDr_ReturLaFurnizor] = N'Retur la furnizor ' + [ExtDimensionDr_ReturLaFurnizor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ReturLaFurnizor].[_Date_Time]), 104) , -- Analitic (Dt) din Retur la furnizor [ExtDimensionDr_ReturLaFurnizor_ID] = [ExtDimensionDr_ReturLaFurnizor].[_IDRRef], -- KeyField din Retur la furnizor [ExtDimensionDr_PersoaneFizice] = [ExtDimensionDr_PersoaneFizice]._Description, -- Analitic (Dt) din Persoane fizice [ExtDimensionDr_PersoaneFizice_ID] = [ExtDimensionDr_PersoaneFizice].[_IDRRef], -- KeyField din Persoane fizice [ExtDimensionDr_AvizDeIntrare] = N'Aviz de intrare ' + coalesce(nullif(rtrim(ltrim([ExtDimensionDr_AvizDeIntrare].[_Fld805])), '') + ' ', '') + coalesce(nullif(rtrim(ltrim([ExtDimensionDr_AvizDeIntrare].[_Fld800])), ''), [ExtDimensionDr_AvizDeIntrare].[_Number]) + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_AvizDeIntrare].[_Date_Time]), 104), -- Analitic (Dt) din Aviz de intrare [ExtDimensionDr_AvizDeIntrare_ID] = [ExtDimensionDr_AvizDeIntrare].[_IDRRef], -- KeyField din Aviz de intrare [ExtDimensionDr_TransferDeMarfuri] = N'Transfer între gestiuni ' + [ExtDimensionDr_TransferDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_TransferDeMarfuri].[_Date_Time]), 104) , -- Analitic (Dt) din Transfer între gestiuni [ExtDimensionDr_TransferDeMarfuri_ID] = [ExtDimensionDr_TransferDeMarfuri].[_IDRRef], -- KeyField din Transfer între gestiuni [ExtDimensionDr_RambursareaTicheteDeMasa] = [ExtDimensionDr_RambursareaTicheteDeMasa].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_RambursareaTicheteDeMasa].[_Date_Time]), 104), -- Analitic (Dt) din Rambursarea tichete de masă [ExtDimensionDr_RambursareaTicheteDeMasa_ID] = [ExtDimensionDr_RambursareaTicheteDeMasa].[_IDRRef], -- KeyField din Rambursarea tichete de masă [ExtDimensionDr_Plata] = N'Dispoziție de plată ' + [ExtDimensionDr_Plata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Plata].[_Date_Time]), 104) , -- Analitic (Dt) din Dispoziție de plată [ExtDimensionDr_Plata_ID] = [ExtDimensionDr_Plata].[_IDRRef], -- KeyField din Dispoziție de plată [ExtDimensionDr_Partenerii] = [ExtDimensionDr_Partenerii]._Description, -- Analitic (Dt) din Parteneri [ExtDimensionDr_Partenerii_ID] = [ExtDimensionDr_Partenerii].[_IDRRef], -- KeyField din Parteneri [ExtDimensionDr_Partida] = [ExtDimensionDr_Partida].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Partida].[_Date_Time]), 104), -- Analitic (Dt) din Partida de mărfuri [ExtDimensionDr_Partida_ID] = [ExtDimensionDr_Partida].[_IDRRef], -- KeyField din Partida de mărfuri [ExtDimensionDr_InventariereMarfuriInDepozit] = [ExtDimensionDr_InventariereMarfuriInDepozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_InventariereMarfuriInDepozit].[_Date_Time]), 104), -- Analitic (Dt) din Inventariere articole [ExtDimensionDr_InventariereMarfuriInDepozit_ID] = [ExtDimensionDr_InventariereMarfuriInDepozit].[_IDRRef], -- KeyField din Inventariere articole [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare] = [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare].[_Date_Time]), 104), -- Analitic (Dt) din Cheltuieli suplimentare la aprovizionare [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare_ID] = [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare].[_IDRRef], -- KeyField din Cheltuieli suplimentare la aprovizionare [ExtDimensionDr_ComandaDeviz] = [ExtDimensionDr_ComandaDeviz].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ComandaDeviz].[_Date_Time]), 104), -- Analitic (Dt) din Comanda deviz [ExtDimensionDr_ComandaDeviz_ID] = [ExtDimensionDr_ComandaDeviz].[_IDRRef], -- KeyField din Comanda deviz [ExtDimensionDr_Contracte] = [ExtDimensionDr_Contracte]._Description, -- Analitic (Dt) din Contracte [ExtDimensionDr_Contracte_ID] = [ExtDimensionDr_Contracte].[_IDRRef], -- KeyField din Contracte [ExtDimensionDr_MarireStocDeMarfuri] = [ExtDimensionDr_MarireStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_MarireStocDeMarfuri].[_Date_Time]), 104), -- Analitic (Dt) din Mărire stoc de articole [ExtDimensionDr_MarireStocDeMarfuri_ID] = [ExtDimensionDr_MarireStocDeMarfuri].[_IDRRef], -- KeyField din Mărire stoc de articole [ExtDimensionDr_Impozite] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] -- Analitic (Dt) when 0xA8BF7C70C4B54DCB4855177118C8B1A2 then 'Accize' -- Accize when 0xAD6F0559D7818679470BC55C6743FB69 then 'CASAngajat' -- CAS Angajat when 0x977E7D76659FBC6D4E096212938578DA then 'CASSAngajat' -- CASS Angajat when 0xA2BAED59635BBBAC4495DF1FDA904EBB then 'CCIAngajator' -- CCI angajator when 0x8865D469BF93F472468240BAE2734793 then 'ComisionITM' -- Comision ITM when 0x95DA6B80F381D548493D6F717CA23B16 then 'ComisionVamal' -- Comision vamal when 0x8737C7AB74F828C74CEA56E6BCCB67F1 then 'FacturiNesositeClient' -- Facturi nesosite client when 0x8265826A2911CC814DDF92A394BA6BC7 then 'FacturiNesositeFurnizor' -- Facturi nesosite furnizor when 0xB1F2CBC7E55761AC4084230D69BAAF61 then 'FondDeAccidente' -- Fond de accidente when 0xB648A9AEE68E0EA24345A1955DEE96CA then 'FondDeGarantare' -- Fond de garantare when 0x9797C05E7CEF9E0E45C49E40122164B9 then 'FondDeMediu' -- Fond de mediu when 0xA6F0FB8F8B75FAE34736FF540083F8C9 then 'FondSanatate' -- Fond sanatate when 0x8BCB1A709E39B25840841C3FC3CBAC95 then 'ImpozitPeAlteVenituriPF' -- Impozite pe alte venituri ale persoanelor fizice when 0x9248ABA269A22EF44EE0A356093DFB75 then 'ImpozitPeCladiri' -- Impozit pe clădiri when 0x9DB8AF7669CDD6D3442E2581350F18BF then 'ImpozitPeConstructiiSpeciale' -- Impozit pe construcții speciale (taxa de stâlp) when 0xAFE317D4C4738D4E4807771A8B516697 then 'ImpozitPeMasini' -- Impozit pe mașini when 0x88ACC35CCD5EAE804590C406404896E1 then 'ImpozitPeProfit' -- Impozit pe profit when 0x8F6E22CD256B84B541318BC74268CA90 then 'ImpozitPeSalarii' -- Impozit pe salarii when 0x8E30EC7E093667B547C335E26F356E86 then 'ImpozitPeTeren' -- Impozit pe teren when 0x861B188568D9DFA249414DD7C034834E then 'ImpozitTaxaFirmei' -- Impozit taxa firmei when 0x9F6AC006925F64034F26200BCF95F56A then 'ImpozitulPeVeniturileMicrointreprinderilor' -- Impozitul pe veniturile microintreprinderilor when 0xA6DBDC732961DFD84B36E0EA67D09133 then 'Somaj' -- Somaj angajator when 0xA4759E7A258F84DD4DD4AD6FD301817D then 'SomajAngajat' -- Somaj angajat when 0xBFAACF24C8E4F21240DD4E7B93BC7F22 then 'TaxaHabitat' -- Taxa habitat when 0xA6D94A070395F1274F5620535DCE8BC1 then 'TVAAmanunt' -- TVA amănunt when 0xB62EA4DB1BB0ED384B81B54331FD6F4F then 'TVAColectata' -- TVA colectată when 0xB832507147DA60D34B138B69AEE3C330 then 'TVADeductibila' -- TVA deductibila when 0xA460909062B9FB6D40FE5AB98FBEAF22 then 'TVANeexigibilaCumparari' -- TVA neexigibila cumparari when 0x815578729BB635DF49168ABFD719B7A7 then 'TVANeexigibilaVanzari' -- TVA neexigibila vanzari when 0x8CA232DB75D72FB44C71101BB2D202BC then 'TVARegularizari' -- Regularizări TVA else null end, -- Valoare necompletata [ExtDimensionDr_Depozite] = [ExtDimensionDr_Depozite]._Description, -- Analitic (Dt) din Depozite [ExtDimensionDr_Depozite_ID] = [ExtDimensionDr_Depozite].[_IDRRef], -- KeyField din Depozite [ExtDimensionDr_GrupeNomenclator] = [ExtDimensionDr_GrupeNomenclator]._Description, -- Analitic (Dt) din Categorii de articole [ExtDimensionDr_GrupeNomenclator_ID] = [ExtDimensionDr_GrupeNomenclator].[_IDRRef], -- KeyField din Categorii de articole [ExtDimensionDr_ImobilizariCorporale] = [ExtDimensionDr_ImobilizariCorporale]._Description, -- Analitic (Dt) din Imobilizări corporale [ExtDimensionDr_ImobilizariCorporale_ID] = [ExtDimensionDr_ImobilizariCorporale].[_IDRRef], -- KeyField din Imobilizări corporale [ExtDimensionDr_Nomenclator] = [ExtDimensionDr_Nomenclator]._Description, -- Analitic (Dt) din Nomenclator de articole [ExtDimensionDr_Nomenclator_ID] = [ExtDimensionDr_Nomenclator].[_IDRRef], -- KeyField din Nomenclator de articole [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite] = N'Factură achiziție ' + [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_Fld629] + ' ' + [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_Fld622] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_Fld642]), 104), -- Analitic (Dt) din Aprovizionare și servicii primite [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite_ID] = [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef], -- KeyField din Aprovizionare și servicii primite [ExcelReportFunctions_RecordsWithExtDimensions].* from [flax].[dbo].[_Reference6798] as [ExcelReportFunctions_RecordsWithExtDimensions] left join [flax].[dbo].[_Document57] as [ExtDimensionDr_AvizDeIesire] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000039 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_AvizDeIesire].[_IDRRef]) left join [flax].[dbo].[_Document3372] as [ExtDimensionDr_ComandaService] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D2C and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ComandaService].[_IDRRef]) left join [flax].[dbo].[_Reference54] as [ExtDimensionDr_Venituri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000036 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Venituri].[_IDRRef]) left join [flax].[dbo].[_Document73] as [ExtDimensionDr_Import] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000049 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Import].[_IDRRef]) left join [flax].[dbo].[_Document3365] as [ExtDimensionDr_Asamblare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D25 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Asamblare].[_IDRRef]) left join [flax].[dbo].[_Reference11] as [ExtDimensionDr_CheltuieliInAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000000B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_CheltuieliInAvans].[_IDRRef]) left join [flax].[dbo].[_Reference5437] as [ExtDimensionDr_VenituriInAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000153D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_VenituriInAvans].[_IDRRef]) left join [flax].[dbo].[_Document67] as [ExtDimensionDr_DecontDeAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000043 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_DecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document117] as [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000075 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_IDRRef]) left join [flax].[dbo].[_Document77] as [ExtDimensionDr_IntroducereaSoldurilor] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000004D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_IntroducereaSoldurilor].[_IDRRef]) left join [flax].[dbo].[_Document6989] as [ExtDimensionDr_CorectieAnaliticiDecontDeAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00001B4D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_CorectieAnaliticiDecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Reference3] as [ExtDimensionDr_AlteCheltuieliSiVenituri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000003 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_AlteCheltuieliSiVenituri].[_IDRRef]) left join [flax].[dbo].[_Reference18] as [ExtDimensionDr_Departamente] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000012 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Departamente].[_IDRRef]) left join [flax].[dbo].[_Reference34] as [ExtDimensionDr_Organizatii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000022 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Organizatii].[_IDRRef]) left join [flax].[dbo].[_Document71] as [ExtDimensionDr_EfecteDePrimit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000047 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_EfecteDePrimit].[_IDRRef]) left join [flax].[dbo].[_Document74] as [ExtDimensionDr_Incasare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000004A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Incasare].[_IDRRef]) left join [flax].[dbo].[_Document72] as [ExtDimensionDr_ExtrasDeCont] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000048 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ExtrasDeCont].[_IDRRef]) left join [flax].[dbo].[_Document101] as [ExtDimensionDr_ReturDeLaClient] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000065 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ReturDeLaClient].[_IDRRef]) left join [flax].[dbo].[_Document3377] as [ExtDimensionDr_Dezasamblare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D31 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Dezasamblare].[_IDRRef]) left join [flax].[dbo].[_Reference10] as [ExtDimensionDr_Cheltuieli] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000000A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Cheltuieli].[_IDRRef]) left join [flax].[dbo].[_Document3378] as [ExtDimensionDr_Export] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D32 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Export].[_IDRRef]) left join [flax].[dbo].[_Document63] as [ExtDimensionDr_CasareMF] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000003F and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_CasareMF].[_IDRRef]) left join [flax].[dbo].[_Reference8] as [ExtDimensionDr_Casierii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000008 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Casierii].[_IDRRef]) left join [flax].[dbo].[_Reference29] as [ExtDimensionDr_ImobilizariNecorporale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000001D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ImobilizariNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document78] as [ExtDimensionDr_IntroducereaSoldurilorAmanunt] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000004E and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_IntroducereaSoldurilorAmanunt].[_IDRRef]) left join [flax].[dbo].[_Reference46] as [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000002E and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale].[_IDRRef]) left join [flax].[dbo].[_Reference16] as [ExtDimensionDr_ConturiBancare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000010 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ConturiBancare].[_IDRRef]) left join [flax].[dbo].[_Document70] as [ExtDimensionDr_EfecteDePlatit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000046 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_EfecteDePlatit].[_IDRRef]) left join [flax].[dbo].[_Document98] as [ExtDimensionDr_RaportDeProductie] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000062 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_RaportDeProductie].[_IDRRef]) left join [flax].[dbo].[_Document102] as [ExtDimensionDr_ReturLaFurnizor] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000066 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ReturLaFurnizor].[_IDRRef]) left join [flax].[dbo].[_Reference37] as [ExtDimensionDr_PersoaneFizice] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000025 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_PersoaneFizice].[_IDRRef]) left join [flax].[dbo].[_Document58] as [ExtDimensionDr_AvizDeIntrare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000003A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_AvizDeIntrare].[_IDRRef]) left join [flax].[dbo].[_Document114] as [ExtDimensionDr_TransferDeMarfuri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000072 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_TransferDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document4661] as [ExtDimensionDr_RambursareaTicheteDeMasa] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00001235 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_RambursareaTicheteDeMasa].[_IDRRef]) left join [flax].[dbo].[_Document91] as [ExtDimensionDr_Plata] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000005B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Plata].[_IDRRef]) left join [flax].[dbo].[_Reference35] as [ExtDimensionDr_Partenerii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000023 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Partenerii].[_IDRRef]) left join [flax].[dbo].[_Document90] as [ExtDimensionDr_Partida] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000005A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Partida].[_IDRRef]) left join [flax].[dbo].[_Document80] as [ExtDimensionDr_InventariereMarfuriInDepozit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000050 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_InventariereMarfuriInDepozit].[_IDRRef]) left join [flax].[dbo].[_Document64] as [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000040 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare].[_IDRRef]) left join [flax].[dbo].[_Document3371] as [ExtDimensionDr_ComandaDeviz] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D2B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ComandaDeviz].[_IDRRef]) left join [flax].[dbo].[_Reference15] as [ExtDimensionDr_Contracte] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000000F and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Contracte].[_IDRRef]) left join [flax].[dbo].[_Document83] as [ExtDimensionDr_MarireStocDeMarfuri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000053 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_MarireStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Reference19] as [ExtDimensionDr_Depozite] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000013 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Depozite].[_IDRRef]) left join [flax].[dbo].[_Reference26] as [ExtDimensionDr_GrupeNomenclator] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000001A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_GrupeNomenclator].[_IDRRef]) left join [flax].[dbo].[_Reference28] as [ExtDimensionDr_ImobilizariCorporale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000001C and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ImobilizariCorporale].[_IDRRef]) left join [flax].[dbo].[_Reference32] as [ExtDimensionDr_Nomenclator] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000020 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Nomenclator].[_IDRRef]) left join [flax].[dbo].[_Document56] as [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000038 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef])
Câmpul ExtDimensionCr
Nume Câmp în baza de date : _Fld6814
Descriere Câmp : Analitic (Ct)
Tip Câmp : complex
Guid Atribut Id
- Configurație : acaf074f-e658-4731-aee5-625e40e3e2c9
- Bază de date : 0xAEE5625E40E3E2C94731E658ACAF074F
Exemplu de interogari :
select [ExtDimensionCr_Id] = [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef], -- Analitic (Ct) [ExtDimensionCr_AvizDeIesire] = N'Aviz de ieșire ' + [ExtDimensionCr_AvizDeIesire].[_Fld743] + ' ' + [ExtDimensionCr_AvizDeIesire].[_Fld744] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_AvizDeIesire].[_Date_Time]), 104), -- Analitic (Ct) din Aviz de ieșire [ExtDimensionCr_AvizDeIesire_ID] = [ExtDimensionCr_AvizDeIesire].[_IDRRef], -- KeyField din Aviz de ieșire [ExtDimensionCr_ComandaService] = [ExtDimensionCr_ComandaService].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ComandaService].[_Date_Time]), 104), -- Analitic (Ct) din Comanda service [ExtDimensionCr_ComandaService_ID] = [ExtDimensionCr_ComandaService].[_IDRRef], -- KeyField din Comanda service [ExtDimensionCr_Venituri] = [ExtDimensionCr_Venituri]._Description, -- Analitic (Ct) din Venituri [ExtDimensionCr_Venituri_ID] = [ExtDimensionCr_Venituri].[_IDRRef], -- KeyField din Venituri [ExtDimensionCr_Import] = N'Import ' + [ExtDimensionCr_Import].[_Fld1360] + ' ' + [ExtDimensionCr_Import].[_Fld1353] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Import].[_Date_Time]), 104), -- Analitic (Ct) din Import [ExtDimensionCr_Import_ID] = [ExtDimensionCr_Import].[_IDRRef], -- KeyField din Import [ExtDimensionCr_Asamblare] = N'Asamblare ' + [ExtDimensionCr_Asamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Asamblare].[_Date_Time]), 104) , -- Analitic (Ct) din Asamblare [ExtDimensionCr_Asamblare_ID] = [ExtDimensionCr_Asamblare].[_IDRRef], -- KeyField din Asamblare [ExtDimensionCr_CheltuieliInAvans] = [ExtDimensionCr_CheltuieliInAvans]._Description, -- Analitic (Ct) din Cheltuieli în avans [ExtDimensionCr_CheltuieliInAvans_ID] = [ExtDimensionCr_CheltuieliInAvans].[_IDRRef], -- KeyField din Cheltuieli în avans [ExtDimensionCr_VenituriInAvans] = [ExtDimensionCr_VenituriInAvans]._Description, -- Analitic (Ct) din Venituri in avans [ExtDimensionCr_VenituriInAvans_ID] = [ExtDimensionCr_VenituriInAvans].[_IDRRef], -- KeyField din Venituri in avans [ExtDimensionCr_CoteTVA] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] -- Analitic (Ct) when 0xB4C7BA8ECAB8E9AA4781AB0C411CD3F7 then 'TVA24' -- 24% when 0x8E93795A2BFED36C41B6F46A053024B3 then 'TVA21' -- 21% when 0x84D7EA11D667B93443492CD03507ECF7 then 'TaxareInversa21' -- Taxare inversă cu cota TVA 21% when 0x916083897E575D3C4BDC5D55A45F4DF9 then 'TVA20' -- 20% when 0x8C1BE8BE1214692E44A8CDC688A8FBD6 then 'TVA19' -- 19% when 0x9BC8FDF9D7F874E645E90A55DC827E17 then 'TVA11' -- 11% when 0xABD86D672B9B5AC34E5679E443BEEC03 then 'TaxareInversa11' -- Taxare inversă cu cota TVA 11% when 0x80332F55AAC32BC94C993597696E1CC8 then 'TVA9' -- 9% when 0x8CE7B143CE2700A342C2E998812E3013 then 'TVA24BunuriDeCapital' -- 24% bunuri de capital when 0xA7CF114FA29E70C14ED698F8D155D6D1 then 'TVA20BunuriDeCapital' -- 20% bunuri de capital when 0x8203DFB60F64D95B45712811F1253CEB then 'TVA19BunuriDeCapital' -- 19% bunuri de capital when 0xBBCC419882DF91A94CFAD82F96C13E88 then 'TVA24NevoileFirmei' -- 24% nevoile firmei when 0x9EEDCAF3CAD4A9214BC5F501072B8ED3 then 'TVA20NevoileFirmei' -- 20% nevoile firmei when 0x80877F489FAEB92C428BA6A6CBB82BA9 then 'TVA19NevoileFirmei' -- 19% nevoile firmei when 0x865D336410F9072441C203F0377FA38C then 'TVA9NevoileFirmei' -- 9% nevoile firmei when 0xBE19D5CA351265EB4AECCDCA5E883434 then 'TVA24Fara' -- 24% fara drept de deducere when 0x8820314B861028A4487963A27F199FB9 then 'TVA20Fara' -- 20% fara drept de deducere when 0x89B17E9CB06A67AD408A8C506B31125D then 'TVA19Fara' -- 19% fara drept de deducere when 0x9CC53A5115830A83494B041D0FBF2B9A then 'TVA9Fara' -- 9% fara drept de deducere when 0x9201A6EA2FABA7F4486ED6550570B1EA then 'TVA5' -- Cota TVA 5% when 0xBF9BD68072E19A6443A6AD318917B35F then 'TVA5Fara' -- 5% fara drept de deducere when 0xA50008B4BC5BB5F6488067F06E225693 then 'TVAEU24' -- TVA la Import din UE cu cota TVA 24% when 0x98CDACE4D8112D17404D89F6EC78E58E then 'TVAEU20' -- TVA la Import din UE cu cota TVA 20% when 0xAA2DE3C795A60A4946C58A73B8C0D3D8 then 'TVAEU9' -- TVA la Import din UE cu cota TVA 9% when 0x9D7F41833CA965AD40D2EF75370D822F then 'TVAEU' -- TVA la Import din UE cu cota TVA 19% when 0xA7343E8E1A0E850E47499B6984E590D0 then 'TVAEUNevoileFirmei24' -- TVA la Import din UE pentru nevoile firmei 24% when 0xADD1FA8C2C531E7C4214C4136C7BE690 then 'TVAEUNevoileFirmei20' -- TVA la Import din UE pentru nevoile firmei 20% when 0xA63CAE39443F3F124E4FE4E5764FECED then 'TVAEUNevoileFirmei' -- TVA la Import din UE pentru nevoile firmei 19% when 0x90E847CAFD85B7D5449935D4869368A8 then 'ScutiteTVA' -- Scutite cu drept de deducere when 0x8475B75F9F772E4F483986B48A433441 then 'ScutiteTVAFara' -- Scutite fără drept de deducere when 0xAD95376DCFAE2A2E4D2EBDC397205D06 then 'ScutiteTVAExport' -- Scutite la Export cu drept de deducere when 0x84CDF3A0C3ED4D014963A725AD3D4325 then 'ScutiteTVAExportFara' -- Scutite la Export fără drept de deducere when 0xBBD8E71C3D67978943A649D63ECD8670 then 'ScutiteTVAEU' -- Scutite la Import din UE destinate revănzării when 0x9C67E1729338633C42C051FA429020BD then 'ScutiteTVAEUNevoileFirmei' -- Scutite la Import din UE pentru nevoile firmei when 0xB3061F8936BA52BC401F2800CDC6BB0C then 'ScutiteTVAExportEUArtA' -- Scutite la Export in UE conf. art.143 alin.2 lit.a) și d) when 0x985FDEF4B5E79BD248AD96AA65D298FA then 'ScutiteTVAExportEUArtB' -- Scutite la Export in UE conf. art.143 alin.2 lit.b) și c) when 0xBEF4E78F4A77E6F44933AE33DB4FC66D then 'ScutiteTVAExportArtC' -- Scutite la Export cu drept de deducere conf. art.143 alin.1 lit.c) și d) when 0x9B960D4C23DC1FB641D65C66EFBA015B then 'Neimpozabile' -- Neimpozabile when 0xA66C90AF717CACA04A14D1188C830084 then 'NeimpozabileEU' -- Neimpozabile la import din UE destinate revănzării when 0xBA28595D7674F34848E03E664F8293C1 then 'NeimpozabileEUNevoileFirmei' -- Neimpozabile la import din UE pentru nevoile firmei when 0x8F47D6FEB598A44147EAB8B39751B55C then 'TaxareInversa24' -- Taxare inversă cu cota TVA 24% when 0x8D85819C3502D9644F3554EF2A4E3205 then 'TaxareInversa20' -- Taxare inversă cu cota TVA 20% when 0x8AD9A80A67D813514E35CC59323A347C then 'TaxareInversa' -- Taxare inversă cu cota TVA 19% when 0xB6A801C6EF4283484A1B0ACE22370816 then 'TaxareInversa9' -- Taxare inversă cu cota TVA 9% when 0x884A08E3B99FD767426E8839E179CA05 then 'TaxareInversaServiciiIntangibile24' -- Taxare inversă servicii intangibile cu cota TVA 24% when 0x91D2395B478FB1C7403B9C973C22F1D2 then 'TaxareInversaServiciiIntangibile20' -- Taxare inversă servicii intangibile cu cota TVA 20% when 0x89574632F1AA15C341325D142FB16ADF then 'TaxareInversaServiciiIntangibile' -- Taxare inversă servicii intangibile cu cota TVA 19% else null end, -- Valoare necompletata [ExtDimensionCr_DecontDeAvans] = [ExtDimensionCr_DecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_DecontDeAvans].[_Date_Time]), 104), -- Analitic (Ct) din Decont de avans [ExtDimensionCr_DecontDeAvans_ID] = [ExtDimensionCr_DecontDeAvans].[_IDRRef], -- KeyField din Decont de avans [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate] = N'Vânzare și servicii prestate ' + [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_Fld2712] + ' ' + [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_Fld2707] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_Date_Time]), 104) , -- Analitic (Ct) din Vânzare și servicii prestate [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate_ID] = [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_IDRRef], -- KeyField din Vânzare și servicii prestate [ExtDimensionCr_IntroducereaSoldurilor] = [ExtDimensionCr_IntroducereaSoldurilor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_IntroducereaSoldurilor].[_Date_Time]), 104), -- Analitic (Ct) din Introducere solduri [ExtDimensionCr_IntroducereaSoldurilor_ID] = [ExtDimensionCr_IntroducereaSoldurilor].[_IDRRef], -- KeyField din Introducere solduri [ExtDimensionCr_CorectieAnaliticiDecontDeAvans] = [ExtDimensionCr_CorectieAnaliticiDecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_CorectieAnaliticiDecontDeAvans].[_Date_Time]), 104), -- Analitic (Ct) din Corectie analitici decont de avans [ExtDimensionCr_CorectieAnaliticiDecontDeAvans_ID] = [ExtDimensionCr_CorectieAnaliticiDecontDeAvans].[_IDRRef], -- KeyField din Corectie analitici decont de avans [ExtDimensionCr_AlteCheltuieliSiVenituri] = [ExtDimensionCr_AlteCheltuieliSiVenituri]._Description, -- Analitic (Ct) din Alte cheltuieli și venituri [ExtDimensionCr_AlteCheltuieliSiVenituri_ID] = [ExtDimensionCr_AlteCheltuieliSiVenituri].[_IDRRef], -- KeyField din Alte cheltuieli și venituri [ExtDimensionCr_Departamente] = [ExtDimensionCr_Departamente]._Description, -- Analitic (Ct) din Departamente [ExtDimensionCr_Departamente_ID] = [ExtDimensionCr_Departamente].[_IDRRef], -- KeyField din Departamente [ExtDimensionCr_Organizatii] = [ExtDimensionCr_Organizatii]._Description, -- Analitic (Ct) din Societăți [ExtDimensionCr_Organizatii_ID] = [ExtDimensionCr_Organizatii].[_IDRRef], -- KeyField din Societăți [ExtDimensionCr_EfecteDePrimit] = [ExtDimensionCr_EfecteDePrimit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_EfecteDePrimit].[_Date_Time]), 104), -- Analitic (Ct) din Efecte de primit [ExtDimensionCr_EfecteDePrimit_ID] = [ExtDimensionCr_EfecteDePrimit].[_IDRRef], -- KeyField din Efecte de primit [ExtDimensionCr_Incasare] = N'Dispoziție de încasare ' + [ExtDimensionCr_Incasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Incasare].[_Date_Time]), 104) , -- Analitic (Ct) din Dispoziție de încasare [ExtDimensionCr_Incasare_ID] = [ExtDimensionCr_Incasare].[_IDRRef], -- KeyField din Dispoziție de încasare [ExtDimensionCr_ExtrasDeCont] = N'Extras de cont ' + [ExtDimensionCr_ExtrasDeCont].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ExtrasDeCont].[_Date_Time]), 104), -- Analitic (Ct) din Extras de cont [ExtDimensionCr_ExtrasDeCont_ID] = [ExtDimensionCr_ExtrasDeCont].[_IDRRef], -- KeyField din Extras de cont [ExtDimensionCr_ReturDeLaClient] = N'Retur de la client ' + [ExtDimensionCr_ReturDeLaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ReturDeLaClient].[_Date_Time]), 104) , -- Analitic (Ct) din Retur de la client [ExtDimensionCr_ReturDeLaClient_ID] = [ExtDimensionCr_ReturDeLaClient].[_IDRRef], -- KeyField din Retur de la client [ExtDimensionCr_Dezasamblare] = N'Dezasamblare ' + [ExtDimensionCr_Dezasamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Dezasamblare].[_Date_Time]), 104) , -- Analitic (Ct) din Dezasamblare [ExtDimensionCr_Dezasamblare_ID] = [ExtDimensionCr_Dezasamblare].[_IDRRef], -- KeyField din Dezasamblare [ExtDimensionCr_Cheltuieli] = [ExtDimensionCr_Cheltuieli]._Description, -- Analitic (Ct) din Cheltuieli [ExtDimensionCr_Cheltuieli_ID] = [ExtDimensionCr_Cheltuieli].[_IDRRef], -- KeyField din Cheltuieli [ExtDimensionCr_Export] = [ExtDimensionCr_Export].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Export].[_Date_Time]), 104), -- Analitic (Ct) din Export [ExtDimensionCr_Export_ID] = [ExtDimensionCr_Export].[_IDRRef], -- KeyField din Export [ExtDimensionCr_CasareMF] = [ExtDimensionCr_CasareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_CasareMF].[_Date_Time]), 104), -- Analitic (Ct) din Casare MF [ExtDimensionCr_CasareMF_ID] = [ExtDimensionCr_CasareMF].[_IDRRef], -- KeyField din Casare MF [ExtDimensionCr_Casierii] = [ExtDimensionCr_Casierii]._Description, -- Analitic (Ct) din Casierii [ExtDimensionCr_Casierii_ID] = [ExtDimensionCr_Casierii].[_IDRRef], -- KeyField din Casierii [ExtDimensionCr_ImobilizariNecorporale] = [ExtDimensionCr_ImobilizariNecorporale]._Description, -- Analitic (Ct) din Imobilizari necorporale [ExtDimensionCr_ImobilizariNecorporale_ID] = [ExtDimensionCr_ImobilizariNecorporale].[_IDRRef], -- KeyField din Imobilizari necorporale [ExtDimensionCr_IntroducereaSoldurilorAmanunt] = [ExtDimensionCr_IntroducereaSoldurilorAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_IntroducereaSoldurilorAmanunt].[_Date_Time]), 104), -- Analitic (Ct) din Introducere solduri amănunt [ExtDimensionCr_IntroducereaSoldurilorAmanunt_ID] = [ExtDimensionCr_IntroducereaSoldurilorAmanunt].[_IDRRef], -- KeyField din Introducere solduri amănunt [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale] = [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale]._Description, -- Analitic (Ct) din Operații trezoreriale [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale_ID] = [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale].[_IDRRef], -- KeyField din Operații trezoreriale [ExtDimensionCr_ConturiBancare] = [ExtDimensionCr_ConturiBancare]._Description, -- Analitic (Ct) din Conturi bancare [ExtDimensionCr_ConturiBancare_ID] = [ExtDimensionCr_ConturiBancare].[_IDRRef], -- KeyField din Conturi bancare [ExtDimensionCr_EfecteDePlatit] = [ExtDimensionCr_EfecteDePlatit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_EfecteDePlatit].[_Date_Time]), 104), -- Analitic (Ct) din Efecte de plătit [ExtDimensionCr_EfecteDePlatit_ID] = [ExtDimensionCr_EfecteDePlatit].[_IDRRef], -- KeyField din Efecte de plătit [ExtDimensionCr_RaportDeProductie] = [ExtDimensionCr_RaportDeProductie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_RaportDeProductie].[_Date_Time]), 104), -- Analitic (Ct) din Raport de producție [ExtDimensionCr_RaportDeProductie_ID] = [ExtDimensionCr_RaportDeProductie].[_IDRRef], -- KeyField din Raport de producție [ExtDimensionCr_ReturLaFurnizor] = N'Retur la furnizor ' + [ExtDimensionCr_ReturLaFurnizor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ReturLaFurnizor].[_Date_Time]), 104) , -- Analitic (Ct) din Retur la furnizor [ExtDimensionCr_ReturLaFurnizor_ID] = [ExtDimensionCr_ReturLaFurnizor].[_IDRRef], -- KeyField din Retur la furnizor [ExtDimensionCr_PersoaneFizice] = [ExtDimensionCr_PersoaneFizice]._Description, -- Analitic (Ct) din Persoane fizice [ExtDimensionCr_PersoaneFizice_ID] = [ExtDimensionCr_PersoaneFizice].[_IDRRef], -- KeyField din Persoane fizice [ExtDimensionCr_AvizDeIntrare] = N'Aviz de intrare ' + coalesce(nullif(rtrim(ltrim([ExtDimensionCr_AvizDeIntrare].[_Fld805])), '') + ' ', '') + coalesce(nullif(rtrim(ltrim([ExtDimensionCr_AvizDeIntrare].[_Fld800])), ''), [ExtDimensionCr_AvizDeIntrare].[_Number]) + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_AvizDeIntrare].[_Date_Time]), 104), -- Analitic (Ct) din Aviz de intrare [ExtDimensionCr_AvizDeIntrare_ID] = [ExtDimensionCr_AvizDeIntrare].[_IDRRef], -- KeyField din Aviz de intrare [ExtDimensionCr_TransferDeMarfuri] = N'Transfer între gestiuni ' + [ExtDimensionCr_TransferDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_TransferDeMarfuri].[_Date_Time]), 104) , -- Analitic (Ct) din Transfer între gestiuni [ExtDimensionCr_TransferDeMarfuri_ID] = [ExtDimensionCr_TransferDeMarfuri].[_IDRRef], -- KeyField din Transfer între gestiuni [ExtDimensionCr_RambursareaTicheteDeMasa] = [ExtDimensionCr_RambursareaTicheteDeMasa].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_RambursareaTicheteDeMasa].[_Date_Time]), 104), -- Analitic (Ct) din Rambursarea tichete de masă [ExtDimensionCr_RambursareaTicheteDeMasa_ID] = [ExtDimensionCr_RambursareaTicheteDeMasa].[_IDRRef], -- KeyField din Rambursarea tichete de masă [ExtDimensionCr_Plata] = N'Dispoziție de plată ' + [ExtDimensionCr_Plata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Plata].[_Date_Time]), 104) , -- Analitic (Ct) din Dispoziție de plată [ExtDimensionCr_Plata_ID] = [ExtDimensionCr_Plata].[_IDRRef], -- KeyField din Dispoziție de plată [ExtDimensionCr_Partenerii] = [ExtDimensionCr_Partenerii]._Description, -- Analitic (Ct) din Parteneri [ExtDimensionCr_Partenerii_ID] = [ExtDimensionCr_Partenerii].[_IDRRef], -- KeyField din Parteneri [ExtDimensionCr_Partida] = [ExtDimensionCr_Partida].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Partida].[_Date_Time]), 104), -- Analitic (Ct) din Partida de mărfuri [ExtDimensionCr_Partida_ID] = [ExtDimensionCr_Partida].[_IDRRef], -- KeyField din Partida de mărfuri [ExtDimensionCr_InventariereMarfuriInDepozit] = [ExtDimensionCr_InventariereMarfuriInDepozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_InventariereMarfuriInDepozit].[_Date_Time]), 104), -- Analitic (Ct) din Inventariere articole [ExtDimensionCr_InventariereMarfuriInDepozit_ID] = [ExtDimensionCr_InventariereMarfuriInDepozit].[_IDRRef], -- KeyField din Inventariere articole [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare] = [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare].[_Date_Time]), 104), -- Analitic (Ct) din Cheltuieli suplimentare la aprovizionare [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare_ID] = [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare].[_IDRRef], -- KeyField din Cheltuieli suplimentare la aprovizionare [ExtDimensionCr_ComandaDeviz] = [ExtDimensionCr_ComandaDeviz].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ComandaDeviz].[_Date_Time]), 104), -- Analitic (Ct) din Comanda deviz [ExtDimensionCr_ComandaDeviz_ID] = [ExtDimensionCr_ComandaDeviz].[_IDRRef], -- KeyField din Comanda deviz [ExtDimensionCr_Contracte] = [ExtDimensionCr_Contracte]._Description, -- Analitic (Ct) din Contracte [ExtDimensionCr_Contracte_ID] = [ExtDimensionCr_Contracte].[_IDRRef], -- KeyField din Contracte [ExtDimensionCr_MarireStocDeMarfuri] = [ExtDimensionCr_MarireStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_MarireStocDeMarfuri].[_Date_Time]), 104), -- Analitic (Ct) din Mărire stoc de articole [ExtDimensionCr_MarireStocDeMarfuri_ID] = [ExtDimensionCr_MarireStocDeMarfuri].[_IDRRef], -- KeyField din Mărire stoc de articole [ExtDimensionCr_Impozite] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] -- Analitic (Ct) when 0xA8BF7C70C4B54DCB4855177118C8B1A2 then 'Accize' -- Accize when 0xAD6F0559D7818679470BC55C6743FB69 then 'CASAngajat' -- CAS Angajat when 0x977E7D76659FBC6D4E096212938578DA then 'CASSAngajat' -- CASS Angajat when 0xA2BAED59635BBBAC4495DF1FDA904EBB then 'CCIAngajator' -- CCI angajator when 0x8865D469BF93F472468240BAE2734793 then 'ComisionITM' -- Comision ITM when 0x95DA6B80F381D548493D6F717CA23B16 then 'ComisionVamal' -- Comision vamal when 0x8737C7AB74F828C74CEA56E6BCCB67F1 then 'FacturiNesositeClient' -- Facturi nesosite client when 0x8265826A2911CC814DDF92A394BA6BC7 then 'FacturiNesositeFurnizor' -- Facturi nesosite furnizor when 0xB1F2CBC7E55761AC4084230D69BAAF61 then 'FondDeAccidente' -- Fond de accidente when 0xB648A9AEE68E0EA24345A1955DEE96CA then 'FondDeGarantare' -- Fond de garantare when 0x9797C05E7CEF9E0E45C49E40122164B9 then 'FondDeMediu' -- Fond de mediu when 0xA6F0FB8F8B75FAE34736FF540083F8C9 then 'FondSanatate' -- Fond sanatate when 0x8BCB1A709E39B25840841C3FC3CBAC95 then 'ImpozitPeAlteVenituriPF' -- Impozite pe alte venituri ale persoanelor fizice when 0x9248ABA269A22EF44EE0A356093DFB75 then 'ImpozitPeCladiri' -- Impozit pe clădiri when 0x9DB8AF7669CDD6D3442E2581350F18BF then 'ImpozitPeConstructiiSpeciale' -- Impozit pe construcții speciale (taxa de stâlp) when 0xAFE317D4C4738D4E4807771A8B516697 then 'ImpozitPeMasini' -- Impozit pe mașini when 0x88ACC35CCD5EAE804590C406404896E1 then 'ImpozitPeProfit' -- Impozit pe profit when 0x8F6E22CD256B84B541318BC74268CA90 then 'ImpozitPeSalarii' -- Impozit pe salarii when 0x8E30EC7E093667B547C335E26F356E86 then 'ImpozitPeTeren' -- Impozit pe teren when 0x861B188568D9DFA249414DD7C034834E then 'ImpozitTaxaFirmei' -- Impozit taxa firmei when 0x9F6AC006925F64034F26200BCF95F56A then 'ImpozitulPeVeniturileMicrointreprinderilor' -- Impozitul pe veniturile microintreprinderilor when 0xA6DBDC732961DFD84B36E0EA67D09133 then 'Somaj' -- Somaj angajator when 0xA4759E7A258F84DD4DD4AD6FD301817D then 'SomajAngajat' -- Somaj angajat when 0xBFAACF24C8E4F21240DD4E7B93BC7F22 then 'TaxaHabitat' -- Taxa habitat when 0xA6D94A070395F1274F5620535DCE8BC1 then 'TVAAmanunt' -- TVA amănunt when 0xB62EA4DB1BB0ED384B81B54331FD6F4F then 'TVAColectata' -- TVA colectată when 0xB832507147DA60D34B138B69AEE3C330 then 'TVADeductibila' -- TVA deductibila when 0xA460909062B9FB6D40FE5AB98FBEAF22 then 'TVANeexigibilaCumparari' -- TVA neexigibila cumparari when 0x815578729BB635DF49168ABFD719B7A7 then 'TVANeexigibilaVanzari' -- TVA neexigibila vanzari when 0x8CA232DB75D72FB44C71101BB2D202BC then 'TVARegularizari' -- Regularizări TVA else null end, -- Valoare necompletata [ExtDimensionCr_Depozite] = [ExtDimensionCr_Depozite]._Description, -- Analitic (Ct) din Depozite [ExtDimensionCr_Depozite_ID] = [ExtDimensionCr_Depozite].[_IDRRef], -- KeyField din Depozite [ExtDimensionCr_GrupeNomenclator] = [ExtDimensionCr_GrupeNomenclator]._Description, -- Analitic (Ct) din Categorii de articole [ExtDimensionCr_GrupeNomenclator_ID] = [ExtDimensionCr_GrupeNomenclator].[_IDRRef], -- KeyField din Categorii de articole [ExtDimensionCr_ImobilizariCorporale] = [ExtDimensionCr_ImobilizariCorporale]._Description, -- Analitic (Ct) din Imobilizări corporale [ExtDimensionCr_ImobilizariCorporale_ID] = [ExtDimensionCr_ImobilizariCorporale].[_IDRRef], -- KeyField din Imobilizări corporale [ExtDimensionCr_Nomenclator] = [ExtDimensionCr_Nomenclator]._Description, -- Analitic (Ct) din Nomenclator de articole [ExtDimensionCr_Nomenclator_ID] = [ExtDimensionCr_Nomenclator].[_IDRRef], -- KeyField din Nomenclator de articole [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite] = N'Factură achiziție ' + [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_Fld629] + ' ' + [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_Fld622] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_Fld642]), 104), -- Analitic (Ct) din Aprovizionare și servicii primite [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite_ID] = [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef], -- KeyField din Aprovizionare și servicii primite [ExcelReportFunctions_RecordsWithExtDimensions].* from [flax].[dbo].[_Reference6798] as [ExcelReportFunctions_RecordsWithExtDimensions] left join [flax].[dbo].[_Document57] as [ExtDimensionCr_AvizDeIesire] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000039 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_AvizDeIesire].[_IDRRef]) left join [flax].[dbo].[_Document3372] as [ExtDimensionCr_ComandaService] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D2C and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ComandaService].[_IDRRef]) left join [flax].[dbo].[_Reference54] as [ExtDimensionCr_Venituri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000036 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Venituri].[_IDRRef]) left join [flax].[dbo].[_Document73] as [ExtDimensionCr_Import] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000049 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Import].[_IDRRef]) left join [flax].[dbo].[_Document3365] as [ExtDimensionCr_Asamblare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D25 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Asamblare].[_IDRRef]) left join [flax].[dbo].[_Reference11] as [ExtDimensionCr_CheltuieliInAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000000B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_CheltuieliInAvans].[_IDRRef]) left join [flax].[dbo].[_Reference5437] as [ExtDimensionCr_VenituriInAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000153D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_VenituriInAvans].[_IDRRef]) left join [flax].[dbo].[_Document67] as [ExtDimensionCr_DecontDeAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000043 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_DecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document117] as [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000075 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_IDRRef]) left join [flax].[dbo].[_Document77] as [ExtDimensionCr_IntroducereaSoldurilor] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000004D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_IntroducereaSoldurilor].[_IDRRef]) left join [flax].[dbo].[_Document6989] as [ExtDimensionCr_CorectieAnaliticiDecontDeAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00001B4D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_CorectieAnaliticiDecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Reference3] as [ExtDimensionCr_AlteCheltuieliSiVenituri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000003 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_AlteCheltuieliSiVenituri].[_IDRRef]) left join [flax].[dbo].[_Reference18] as [ExtDimensionCr_Departamente] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000012 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Departamente].[_IDRRef]) left join [flax].[dbo].[_Reference34] as [ExtDimensionCr_Organizatii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000022 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Organizatii].[_IDRRef]) left join [flax].[dbo].[_Document71] as [ExtDimensionCr_EfecteDePrimit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000047 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_EfecteDePrimit].[_IDRRef]) left join [flax].[dbo].[_Document74] as [ExtDimensionCr_Incasare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000004A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Incasare].[_IDRRef]) left join [flax].[dbo].[_Document72] as [ExtDimensionCr_ExtrasDeCont] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000048 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ExtrasDeCont].[_IDRRef]) left join [flax].[dbo].[_Document101] as [ExtDimensionCr_ReturDeLaClient] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000065 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ReturDeLaClient].[_IDRRef]) left join [flax].[dbo].[_Document3377] as [ExtDimensionCr_Dezasamblare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D31 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Dezasamblare].[_IDRRef]) left join [flax].[dbo].[_Reference10] as [ExtDimensionCr_Cheltuieli] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000000A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Cheltuieli].[_IDRRef]) left join [flax].[dbo].[_Document3378] as [ExtDimensionCr_Export] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D32 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Export].[_IDRRef]) left join [flax].[dbo].[_Document63] as [ExtDimensionCr_CasareMF] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000003F and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_CasareMF].[_IDRRef]) left join [flax].[dbo].[_Reference8] as [ExtDimensionCr_Casierii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000008 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Casierii].[_IDRRef]) left join [flax].[dbo].[_Reference29] as [ExtDimensionCr_ImobilizariNecorporale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000001D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ImobilizariNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document78] as [ExtDimensionCr_IntroducereaSoldurilorAmanunt] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000004E and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_IntroducereaSoldurilorAmanunt].[_IDRRef]) left join [flax].[dbo].[_Reference46] as [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000002E and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale].[_IDRRef]) left join [flax].[dbo].[_Reference16] as [ExtDimensionCr_ConturiBancare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000010 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ConturiBancare].[_IDRRef]) left join [flax].[dbo].[_Document70] as [ExtDimensionCr_EfecteDePlatit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000046 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_EfecteDePlatit].[_IDRRef]) left join [flax].[dbo].[_Document98] as [ExtDimensionCr_RaportDeProductie] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000062 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_RaportDeProductie].[_IDRRef]) left join [flax].[dbo].[_Document102] as [ExtDimensionCr_ReturLaFurnizor] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000066 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ReturLaFurnizor].[_IDRRef]) left join [flax].[dbo].[_Reference37] as [ExtDimensionCr_PersoaneFizice] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000025 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_PersoaneFizice].[_IDRRef]) left join [flax].[dbo].[_Document58] as [ExtDimensionCr_AvizDeIntrare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000003A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_AvizDeIntrare].[_IDRRef]) left join [flax].[dbo].[_Document114] as [ExtDimensionCr_TransferDeMarfuri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000072 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_TransferDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document4661] as [ExtDimensionCr_RambursareaTicheteDeMasa] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00001235 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_RambursareaTicheteDeMasa].[_IDRRef]) left join [flax].[dbo].[_Document91] as [ExtDimensionCr_Plata] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000005B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Plata].[_IDRRef]) left join [flax].[dbo].[_Reference35] as [ExtDimensionCr_Partenerii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000023 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Partenerii].[_IDRRef]) left join [flax].[dbo].[_Document90] as [ExtDimensionCr_Partida] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000005A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Partida].[_IDRRef]) left join [flax].[dbo].[_Document80] as [ExtDimensionCr_InventariereMarfuriInDepozit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000050 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_InventariereMarfuriInDepozit].[_IDRRef]) left join [flax].[dbo].[_Document64] as [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000040 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare].[_IDRRef]) left join [flax].[dbo].[_Document3371] as [ExtDimensionCr_ComandaDeviz] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D2B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ComandaDeviz].[_IDRRef]) left join [flax].[dbo].[_Reference15] as [ExtDimensionCr_Contracte] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000000F and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Contracte].[_IDRRef]) left join [flax].[dbo].[_Document83] as [ExtDimensionCr_MarireStocDeMarfuri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000053 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_MarireStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Reference19] as [ExtDimensionCr_Depozite] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000013 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Depozite].[_IDRRef]) left join [flax].[dbo].[_Reference26] as [ExtDimensionCr_GrupeNomenclator] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000001A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_GrupeNomenclator].[_IDRRef]) left join [flax].[dbo].[_Reference28] as [ExtDimensionCr_ImobilizariCorporale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000001C and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ImobilizariCorporale].[_IDRRef]) left join [flax].[dbo].[_Reference32] as [ExtDimensionCr_Nomenclator] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000020 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Nomenclator].[_IDRRef]) left join [flax].[dbo].[_Document56] as [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000038 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef])
Câmpul Expression
Nume Câmp în baza de date : _Fld6815
Descriere Câmp : Expresie
Tip Câmp : string
Guid Atribut Id
- Configurație : c5114490-1f9f-49b5-ae6a-f46999736c0e
- Bază de date : 0xAE6AF46999736C0E49B51F9FC5114490
Full Sql Select
Exemplu de apel pentru obiectul curent din baza sursa
select [KeyField] = [ExcelReportFunctions_RecordsWithExtDimensions].[_IDRRef], -- Referință către înregistrare [Version] = [ExcelReportFunctions_RecordsWithExtDimensions].[_Version], -- Versiune înregistrare [Marked] = [ExcelReportFunctions_RecordsWithExtDimensions].[_Marked], -- Înregistrare marcată [Metadata] = [ExcelReportFunctions_RecordsWithExtDimensions].[_IsMetadata], -- Metadate înregistrare [OwnerId] = [ExcelReportFunctions_RecordsWithExtDimensions].[_OwnerIDRRef], -- Owner-ul documentului [Code] = [ExcelReportFunctions_RecordsWithExtDimensions].[_Code], -- Codul de identificare al înregistrării [Description] = [ExcelReportFunctions_RecordsWithExtDimensions].[_Description], -- Descriere înregistrării [Sign] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6809RRef] -- Semn when 0x895C1D0151F291DD4B901846BDC7C46C then 'Plus' -- + when 0xAADEA83168EE0E5C48D4616A26F9457E then 'Minus' -- - else null end, -- Valoare necompletata [Indicator] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6810RRef] -- Indicator when 0x8E267BB15B7B625C4D5C3859526A4023 then 'Suma' -- Suma when 0x91D8B116F548C7FB4D49212EE1F0287E then 'SumaValDr' -- SumaValDr when 0xAAF56594ADE25809496BD83A22F1B390 then 'SumaValCr' -- SumaValCr when 0xAC37B6C994199CE64BCB93BDC8F89C12 then 'CountDr' -- CountDr when 0xA13F9EEB0EE495F54C29AB4F2EF113EB then 'CountCr' -- CountCr else null end, -- Valoare necompletata [ExtDimensionTypeDr] = [ExtDimensionTypeDr_TipSubcontoGeneral]._Description, -- Tip analitic (Dt) din Tip subconto general [ExtDimensionTypeDr_ID] = [ExtDimensionTypeDr_TipSubcontoGeneral].[_IDRRef], -- KeyField din Tip subconto general [ExtDimensionTypeCr] = [ExtDimensionTypeCr_TipSubcontoGeneral]._Description, -- Tip analitic (Ct) din Tip subconto general [ExtDimensionTypeCr_ID] = [ExtDimensionTypeCr_TipSubcontoGeneral].[_IDRRef], -- KeyField din Tip subconto general [ExtDimensionDr_Id] = [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef], -- Analitic (Dt) [ExtDimensionDr_AvizDeIesire] = N'Aviz de ieșire ' + [ExtDimensionDr_AvizDeIesire].[_Fld743] + ' ' + [ExtDimensionDr_AvizDeIesire].[_Fld744] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_AvizDeIesire].[_Date_Time]), 104), -- Analitic (Dt) din Aviz de ieșire [ExtDimensionDr_AvizDeIesire_ID] = [ExtDimensionDr_AvizDeIesire].[_IDRRef], -- KeyField din Aviz de ieșire [ExtDimensionDr_ComandaService] = [ExtDimensionDr_ComandaService].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ComandaService].[_Date_Time]), 104), -- Analitic (Dt) din Comanda service [ExtDimensionDr_ComandaService_ID] = [ExtDimensionDr_ComandaService].[_IDRRef], -- KeyField din Comanda service [ExtDimensionDr_Venituri] = [ExtDimensionDr_Venituri]._Description, -- Analitic (Dt) din Venituri [ExtDimensionDr_Venituri_ID] = [ExtDimensionDr_Venituri].[_IDRRef], -- KeyField din Venituri [ExtDimensionDr_Import] = N'Import ' + [ExtDimensionDr_Import].[_Fld1360] + ' ' + [ExtDimensionDr_Import].[_Fld1353] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Import].[_Date_Time]), 104), -- Analitic (Dt) din Import [ExtDimensionDr_Import_ID] = [ExtDimensionDr_Import].[_IDRRef], -- KeyField din Import [ExtDimensionDr_Asamblare] = N'Asamblare ' + [ExtDimensionDr_Asamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Asamblare].[_Date_Time]), 104) , -- Analitic (Dt) din Asamblare [ExtDimensionDr_Asamblare_ID] = [ExtDimensionDr_Asamblare].[_IDRRef], -- KeyField din Asamblare [ExtDimensionDr_CheltuieliInAvans] = [ExtDimensionDr_CheltuieliInAvans]._Description, -- Analitic (Dt) din Cheltuieli în avans [ExtDimensionDr_CheltuieliInAvans_ID] = [ExtDimensionDr_CheltuieliInAvans].[_IDRRef], -- KeyField din Cheltuieli în avans [ExtDimensionDr_VenituriInAvans] = [ExtDimensionDr_VenituriInAvans]._Description, -- Analitic (Dt) din Venituri in avans [ExtDimensionDr_VenituriInAvans_ID] = [ExtDimensionDr_VenituriInAvans].[_IDRRef], -- KeyField din Venituri in avans [ExtDimensionDr_CoteTVA] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] -- Analitic (Dt) when 0xB4C7BA8ECAB8E9AA4781AB0C411CD3F7 then 'TVA24' -- 24% when 0x8E93795A2BFED36C41B6F46A053024B3 then 'TVA21' -- 21% when 0x84D7EA11D667B93443492CD03507ECF7 then 'TaxareInversa21' -- Taxare inversă cu cota TVA 21% when 0x916083897E575D3C4BDC5D55A45F4DF9 then 'TVA20' -- 20% when 0x8C1BE8BE1214692E44A8CDC688A8FBD6 then 'TVA19' -- 19% when 0x9BC8FDF9D7F874E645E90A55DC827E17 then 'TVA11' -- 11% when 0xABD86D672B9B5AC34E5679E443BEEC03 then 'TaxareInversa11' -- Taxare inversă cu cota TVA 11% when 0x80332F55AAC32BC94C993597696E1CC8 then 'TVA9' -- 9% when 0x8CE7B143CE2700A342C2E998812E3013 then 'TVA24BunuriDeCapital' -- 24% bunuri de capital when 0xA7CF114FA29E70C14ED698F8D155D6D1 then 'TVA20BunuriDeCapital' -- 20% bunuri de capital when 0x8203DFB60F64D95B45712811F1253CEB then 'TVA19BunuriDeCapital' -- 19% bunuri de capital when 0xBBCC419882DF91A94CFAD82F96C13E88 then 'TVA24NevoileFirmei' -- 24% nevoile firmei when 0x9EEDCAF3CAD4A9214BC5F501072B8ED3 then 'TVA20NevoileFirmei' -- 20% nevoile firmei when 0x80877F489FAEB92C428BA6A6CBB82BA9 then 'TVA19NevoileFirmei' -- 19% nevoile firmei when 0x865D336410F9072441C203F0377FA38C then 'TVA9NevoileFirmei' -- 9% nevoile firmei when 0xBE19D5CA351265EB4AECCDCA5E883434 then 'TVA24Fara' -- 24% fara drept de deducere when 0x8820314B861028A4487963A27F199FB9 then 'TVA20Fara' -- 20% fara drept de deducere when 0x89B17E9CB06A67AD408A8C506B31125D then 'TVA19Fara' -- 19% fara drept de deducere when 0x9CC53A5115830A83494B041D0FBF2B9A then 'TVA9Fara' -- 9% fara drept de deducere when 0x9201A6EA2FABA7F4486ED6550570B1EA then 'TVA5' -- Cota TVA 5% when 0xBF9BD68072E19A6443A6AD318917B35F then 'TVA5Fara' -- 5% fara drept de deducere when 0xA50008B4BC5BB5F6488067F06E225693 then 'TVAEU24' -- TVA la Import din UE cu cota TVA 24% when 0x98CDACE4D8112D17404D89F6EC78E58E then 'TVAEU20' -- TVA la Import din UE cu cota TVA 20% when 0xAA2DE3C795A60A4946C58A73B8C0D3D8 then 'TVAEU9' -- TVA la Import din UE cu cota TVA 9% when 0x9D7F41833CA965AD40D2EF75370D822F then 'TVAEU' -- TVA la Import din UE cu cota TVA 19% when 0xA7343E8E1A0E850E47499B6984E590D0 then 'TVAEUNevoileFirmei24' -- TVA la Import din UE pentru nevoile firmei 24% when 0xADD1FA8C2C531E7C4214C4136C7BE690 then 'TVAEUNevoileFirmei20' -- TVA la Import din UE pentru nevoile firmei 20% when 0xA63CAE39443F3F124E4FE4E5764FECED then 'TVAEUNevoileFirmei' -- TVA la Import din UE pentru nevoile firmei 19% when 0x90E847CAFD85B7D5449935D4869368A8 then 'ScutiteTVA' -- Scutite cu drept de deducere when 0x8475B75F9F772E4F483986B48A433441 then 'ScutiteTVAFara' -- Scutite fără drept de deducere when 0xAD95376DCFAE2A2E4D2EBDC397205D06 then 'ScutiteTVAExport' -- Scutite la Export cu drept de deducere when 0x84CDF3A0C3ED4D014963A725AD3D4325 then 'ScutiteTVAExportFara' -- Scutite la Export fără drept de deducere when 0xBBD8E71C3D67978943A649D63ECD8670 then 'ScutiteTVAEU' -- Scutite la Import din UE destinate revănzării when 0x9C67E1729338633C42C051FA429020BD then 'ScutiteTVAEUNevoileFirmei' -- Scutite la Import din UE pentru nevoile firmei when 0xB3061F8936BA52BC401F2800CDC6BB0C then 'ScutiteTVAExportEUArtA' -- Scutite la Export in UE conf. art.143 alin.2 lit.a) și d) when 0x985FDEF4B5E79BD248AD96AA65D298FA then 'ScutiteTVAExportEUArtB' -- Scutite la Export in UE conf. art.143 alin.2 lit.b) și c) when 0xBEF4E78F4A77E6F44933AE33DB4FC66D then 'ScutiteTVAExportArtC' -- Scutite la Export cu drept de deducere conf. art.143 alin.1 lit.c) și d) when 0x9B960D4C23DC1FB641D65C66EFBA015B then 'Neimpozabile' -- Neimpozabile when 0xA66C90AF717CACA04A14D1188C830084 then 'NeimpozabileEU' -- Neimpozabile la import din UE destinate revănzării when 0xBA28595D7674F34848E03E664F8293C1 then 'NeimpozabileEUNevoileFirmei' -- Neimpozabile la import din UE pentru nevoile firmei when 0x8F47D6FEB598A44147EAB8B39751B55C then 'TaxareInversa24' -- Taxare inversă cu cota TVA 24% when 0x8D85819C3502D9644F3554EF2A4E3205 then 'TaxareInversa20' -- Taxare inversă cu cota TVA 20% when 0x8AD9A80A67D813514E35CC59323A347C then 'TaxareInversa' -- Taxare inversă cu cota TVA 19% when 0xB6A801C6EF4283484A1B0ACE22370816 then 'TaxareInversa9' -- Taxare inversă cu cota TVA 9% when 0x884A08E3B99FD767426E8839E179CA05 then 'TaxareInversaServiciiIntangibile24' -- Taxare inversă servicii intangibile cu cota TVA 24% when 0x91D2395B478FB1C7403B9C973C22F1D2 then 'TaxareInversaServiciiIntangibile20' -- Taxare inversă servicii intangibile cu cota TVA 20% when 0x89574632F1AA15C341325D142FB16ADF then 'TaxareInversaServiciiIntangibile' -- Taxare inversă servicii intangibile cu cota TVA 19% else null end, -- Valoare necompletata [ExtDimensionDr_DecontDeAvans] = [ExtDimensionDr_DecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_DecontDeAvans].[_Date_Time]), 104), -- Analitic (Dt) din Decont de avans [ExtDimensionDr_DecontDeAvans_ID] = [ExtDimensionDr_DecontDeAvans].[_IDRRef], -- KeyField din Decont de avans [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate] = N'Vânzare și servicii prestate ' + [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_Fld2712] + ' ' + [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_Fld2707] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_Date_Time]), 104) , -- Analitic (Dt) din Vânzare și servicii prestate [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate_ID] = [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_IDRRef], -- KeyField din Vânzare și servicii prestate [ExtDimensionDr_IntroducereaSoldurilor] = [ExtDimensionDr_IntroducereaSoldurilor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_IntroducereaSoldurilor].[_Date_Time]), 104), -- Analitic (Dt) din Introducere solduri [ExtDimensionDr_IntroducereaSoldurilor_ID] = [ExtDimensionDr_IntroducereaSoldurilor].[_IDRRef], -- KeyField din Introducere solduri [ExtDimensionDr_CorectieAnaliticiDecontDeAvans] = [ExtDimensionDr_CorectieAnaliticiDecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_CorectieAnaliticiDecontDeAvans].[_Date_Time]), 104), -- Analitic (Dt) din Corectie analitici decont de avans [ExtDimensionDr_CorectieAnaliticiDecontDeAvans_ID] = [ExtDimensionDr_CorectieAnaliticiDecontDeAvans].[_IDRRef], -- KeyField din Corectie analitici decont de avans [ExtDimensionDr_AlteCheltuieliSiVenituri] = [ExtDimensionDr_AlteCheltuieliSiVenituri]._Description, -- Analitic (Dt) din Alte cheltuieli și venituri [ExtDimensionDr_AlteCheltuieliSiVenituri_ID] = [ExtDimensionDr_AlteCheltuieliSiVenituri].[_IDRRef], -- KeyField din Alte cheltuieli și venituri [ExtDimensionDr_Departamente] = [ExtDimensionDr_Departamente]._Description, -- Analitic (Dt) din Departamente [ExtDimensionDr_Departamente_ID] = [ExtDimensionDr_Departamente].[_IDRRef], -- KeyField din Departamente [ExtDimensionDr_Organizatii] = [ExtDimensionDr_Organizatii]._Description, -- Analitic (Dt) din Societăți [ExtDimensionDr_Organizatii_ID] = [ExtDimensionDr_Organizatii].[_IDRRef], -- KeyField din Societăți [ExtDimensionDr_EfecteDePrimit] = [ExtDimensionDr_EfecteDePrimit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_EfecteDePrimit].[_Date_Time]), 104), -- Analitic (Dt) din Efecte de primit [ExtDimensionDr_EfecteDePrimit_ID] = [ExtDimensionDr_EfecteDePrimit].[_IDRRef], -- KeyField din Efecte de primit [ExtDimensionDr_Incasare] = N'Dispoziție de încasare ' + [ExtDimensionDr_Incasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Incasare].[_Date_Time]), 104) , -- Analitic (Dt) din Dispoziție de încasare [ExtDimensionDr_Incasare_ID] = [ExtDimensionDr_Incasare].[_IDRRef], -- KeyField din Dispoziție de încasare [ExtDimensionDr_ExtrasDeCont] = N'Extras de cont ' + [ExtDimensionDr_ExtrasDeCont].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ExtrasDeCont].[_Date_Time]), 104), -- Analitic (Dt) din Extras de cont [ExtDimensionDr_ExtrasDeCont_ID] = [ExtDimensionDr_ExtrasDeCont].[_IDRRef], -- KeyField din Extras de cont [ExtDimensionDr_ReturDeLaClient] = N'Retur de la client ' + [ExtDimensionDr_ReturDeLaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ReturDeLaClient].[_Date_Time]), 104) , -- Analitic (Dt) din Retur de la client [ExtDimensionDr_ReturDeLaClient_ID] = [ExtDimensionDr_ReturDeLaClient].[_IDRRef], -- KeyField din Retur de la client [ExtDimensionDr_Dezasamblare] = N'Dezasamblare ' + [ExtDimensionDr_Dezasamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Dezasamblare].[_Date_Time]), 104) , -- Analitic (Dt) din Dezasamblare [ExtDimensionDr_Dezasamblare_ID] = [ExtDimensionDr_Dezasamblare].[_IDRRef], -- KeyField din Dezasamblare [ExtDimensionDr_Cheltuieli] = [ExtDimensionDr_Cheltuieli]._Description, -- Analitic (Dt) din Cheltuieli [ExtDimensionDr_Cheltuieli_ID] = [ExtDimensionDr_Cheltuieli].[_IDRRef], -- KeyField din Cheltuieli [ExtDimensionDr_Export] = [ExtDimensionDr_Export].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Export].[_Date_Time]), 104), -- Analitic (Dt) din Export [ExtDimensionDr_Export_ID] = [ExtDimensionDr_Export].[_IDRRef], -- KeyField din Export [ExtDimensionDr_CasareMF] = [ExtDimensionDr_CasareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_CasareMF].[_Date_Time]), 104), -- Analitic (Dt) din Casare MF [ExtDimensionDr_CasareMF_ID] = [ExtDimensionDr_CasareMF].[_IDRRef], -- KeyField din Casare MF [ExtDimensionDr_Casierii] = [ExtDimensionDr_Casierii]._Description, -- Analitic (Dt) din Casierii [ExtDimensionDr_Casierii_ID] = [ExtDimensionDr_Casierii].[_IDRRef], -- KeyField din Casierii [ExtDimensionDr_ImobilizariNecorporale] = [ExtDimensionDr_ImobilizariNecorporale]._Description, -- Analitic (Dt) din Imobilizari necorporale [ExtDimensionDr_ImobilizariNecorporale_ID] = [ExtDimensionDr_ImobilizariNecorporale].[_IDRRef], -- KeyField din Imobilizari necorporale [ExtDimensionDr_IntroducereaSoldurilorAmanunt] = [ExtDimensionDr_IntroducereaSoldurilorAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_IntroducereaSoldurilorAmanunt].[_Date_Time]), 104), -- Analitic (Dt) din Introducere solduri amănunt [ExtDimensionDr_IntroducereaSoldurilorAmanunt_ID] = [ExtDimensionDr_IntroducereaSoldurilorAmanunt].[_IDRRef], -- KeyField din Introducere solduri amănunt [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale] = [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale]._Description, -- Analitic (Dt) din Operații trezoreriale [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale_ID] = [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale].[_IDRRef], -- KeyField din Operații trezoreriale [ExtDimensionDr_ConturiBancare] = [ExtDimensionDr_ConturiBancare]._Description, -- Analitic (Dt) din Conturi bancare [ExtDimensionDr_ConturiBancare_ID] = [ExtDimensionDr_ConturiBancare].[_IDRRef], -- KeyField din Conturi bancare [ExtDimensionDr_EfecteDePlatit] = [ExtDimensionDr_EfecteDePlatit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_EfecteDePlatit].[_Date_Time]), 104), -- Analitic (Dt) din Efecte de plătit [ExtDimensionDr_EfecteDePlatit_ID] = [ExtDimensionDr_EfecteDePlatit].[_IDRRef], -- KeyField din Efecte de plătit [ExtDimensionDr_RaportDeProductie] = [ExtDimensionDr_RaportDeProductie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_RaportDeProductie].[_Date_Time]), 104), -- Analitic (Dt) din Raport de producție [ExtDimensionDr_RaportDeProductie_ID] = [ExtDimensionDr_RaportDeProductie].[_IDRRef], -- KeyField din Raport de producție [ExtDimensionDr_ReturLaFurnizor] = N'Retur la furnizor ' + [ExtDimensionDr_ReturLaFurnizor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ReturLaFurnizor].[_Date_Time]), 104) , -- Analitic (Dt) din Retur la furnizor [ExtDimensionDr_ReturLaFurnizor_ID] = [ExtDimensionDr_ReturLaFurnizor].[_IDRRef], -- KeyField din Retur la furnizor [ExtDimensionDr_PersoaneFizice] = [ExtDimensionDr_PersoaneFizice]._Description, -- Analitic (Dt) din Persoane fizice [ExtDimensionDr_PersoaneFizice_ID] = [ExtDimensionDr_PersoaneFizice].[_IDRRef], -- KeyField din Persoane fizice [ExtDimensionDr_AvizDeIntrare] = N'Aviz de intrare ' + coalesce(nullif(rtrim(ltrim([ExtDimensionDr_AvizDeIntrare].[_Fld805])), '') + ' ', '') + coalesce(nullif(rtrim(ltrim([ExtDimensionDr_AvizDeIntrare].[_Fld800])), ''), [ExtDimensionDr_AvizDeIntrare].[_Number]) + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_AvizDeIntrare].[_Date_Time]), 104), -- Analitic (Dt) din Aviz de intrare [ExtDimensionDr_AvizDeIntrare_ID] = [ExtDimensionDr_AvizDeIntrare].[_IDRRef], -- KeyField din Aviz de intrare [ExtDimensionDr_TransferDeMarfuri] = N'Transfer între gestiuni ' + [ExtDimensionDr_TransferDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_TransferDeMarfuri].[_Date_Time]), 104) , -- Analitic (Dt) din Transfer între gestiuni [ExtDimensionDr_TransferDeMarfuri_ID] = [ExtDimensionDr_TransferDeMarfuri].[_IDRRef], -- KeyField din Transfer între gestiuni [ExtDimensionDr_RambursareaTicheteDeMasa] = [ExtDimensionDr_RambursareaTicheteDeMasa].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_RambursareaTicheteDeMasa].[_Date_Time]), 104), -- Analitic (Dt) din Rambursarea tichete de masă [ExtDimensionDr_RambursareaTicheteDeMasa_ID] = [ExtDimensionDr_RambursareaTicheteDeMasa].[_IDRRef], -- KeyField din Rambursarea tichete de masă [ExtDimensionDr_Plata] = N'Dispoziție de plată ' + [ExtDimensionDr_Plata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Plata].[_Date_Time]), 104) , -- Analitic (Dt) din Dispoziție de plată [ExtDimensionDr_Plata_ID] = [ExtDimensionDr_Plata].[_IDRRef], -- KeyField din Dispoziție de plată [ExtDimensionDr_Partenerii] = [ExtDimensionDr_Partenerii]._Description, -- Analitic (Dt) din Parteneri [ExtDimensionDr_Partenerii_ID] = [ExtDimensionDr_Partenerii].[_IDRRef], -- KeyField din Parteneri [ExtDimensionDr_Partida] = [ExtDimensionDr_Partida].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_Partida].[_Date_Time]), 104), -- Analitic (Dt) din Partida de mărfuri [ExtDimensionDr_Partida_ID] = [ExtDimensionDr_Partida].[_IDRRef], -- KeyField din Partida de mărfuri [ExtDimensionDr_InventariereMarfuriInDepozit] = [ExtDimensionDr_InventariereMarfuriInDepozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_InventariereMarfuriInDepozit].[_Date_Time]), 104), -- Analitic (Dt) din Inventariere articole [ExtDimensionDr_InventariereMarfuriInDepozit_ID] = [ExtDimensionDr_InventariereMarfuriInDepozit].[_IDRRef], -- KeyField din Inventariere articole [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare] = [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare].[_Date_Time]), 104), -- Analitic (Dt) din Cheltuieli suplimentare la aprovizionare [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare_ID] = [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare].[_IDRRef], -- KeyField din Cheltuieli suplimentare la aprovizionare [ExtDimensionDr_ComandaDeviz] = [ExtDimensionDr_ComandaDeviz].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_ComandaDeviz].[_Date_Time]), 104), -- Analitic (Dt) din Comanda deviz [ExtDimensionDr_ComandaDeviz_ID] = [ExtDimensionDr_ComandaDeviz].[_IDRRef], -- KeyField din Comanda deviz [ExtDimensionDr_Contracte] = [ExtDimensionDr_Contracte]._Description, -- Analitic (Dt) din Contracte [ExtDimensionDr_Contracte_ID] = [ExtDimensionDr_Contracte].[_IDRRef], -- KeyField din Contracte [ExtDimensionDr_MarireStocDeMarfuri] = [ExtDimensionDr_MarireStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_MarireStocDeMarfuri].[_Date_Time]), 104), -- Analitic (Dt) din Mărire stoc de articole [ExtDimensionDr_MarireStocDeMarfuri_ID] = [ExtDimensionDr_MarireStocDeMarfuri].[_IDRRef], -- KeyField din Mărire stoc de articole [ExtDimensionDr_Impozite] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] -- Analitic (Dt) when 0xA8BF7C70C4B54DCB4855177118C8B1A2 then 'Accize' -- Accize when 0xAD6F0559D7818679470BC55C6743FB69 then 'CASAngajat' -- CAS Angajat when 0x977E7D76659FBC6D4E096212938578DA then 'CASSAngajat' -- CASS Angajat when 0xA2BAED59635BBBAC4495DF1FDA904EBB then 'CCIAngajator' -- CCI angajator when 0x8865D469BF93F472468240BAE2734793 then 'ComisionITM' -- Comision ITM when 0x95DA6B80F381D548493D6F717CA23B16 then 'ComisionVamal' -- Comision vamal when 0x8737C7AB74F828C74CEA56E6BCCB67F1 then 'FacturiNesositeClient' -- Facturi nesosite client when 0x8265826A2911CC814DDF92A394BA6BC7 then 'FacturiNesositeFurnizor' -- Facturi nesosite furnizor when 0xB1F2CBC7E55761AC4084230D69BAAF61 then 'FondDeAccidente' -- Fond de accidente when 0xB648A9AEE68E0EA24345A1955DEE96CA then 'FondDeGarantare' -- Fond de garantare when 0x9797C05E7CEF9E0E45C49E40122164B9 then 'FondDeMediu' -- Fond de mediu when 0xA6F0FB8F8B75FAE34736FF540083F8C9 then 'FondSanatate' -- Fond sanatate when 0x8BCB1A709E39B25840841C3FC3CBAC95 then 'ImpozitPeAlteVenituriPF' -- Impozite pe alte venituri ale persoanelor fizice when 0x9248ABA269A22EF44EE0A356093DFB75 then 'ImpozitPeCladiri' -- Impozit pe clădiri when 0x9DB8AF7669CDD6D3442E2581350F18BF then 'ImpozitPeConstructiiSpeciale' -- Impozit pe construcții speciale (taxa de stâlp) when 0xAFE317D4C4738D4E4807771A8B516697 then 'ImpozitPeMasini' -- Impozit pe mașini when 0x88ACC35CCD5EAE804590C406404896E1 then 'ImpozitPeProfit' -- Impozit pe profit when 0x8F6E22CD256B84B541318BC74268CA90 then 'ImpozitPeSalarii' -- Impozit pe salarii when 0x8E30EC7E093667B547C335E26F356E86 then 'ImpozitPeTeren' -- Impozit pe teren when 0x861B188568D9DFA249414DD7C034834E then 'ImpozitTaxaFirmei' -- Impozit taxa firmei when 0x9F6AC006925F64034F26200BCF95F56A then 'ImpozitulPeVeniturileMicrointreprinderilor' -- Impozitul pe veniturile microintreprinderilor when 0xA6DBDC732961DFD84B36E0EA67D09133 then 'Somaj' -- Somaj angajator when 0xA4759E7A258F84DD4DD4AD6FD301817D then 'SomajAngajat' -- Somaj angajat when 0xBFAACF24C8E4F21240DD4E7B93BC7F22 then 'TaxaHabitat' -- Taxa habitat when 0xA6D94A070395F1274F5620535DCE8BC1 then 'TVAAmanunt' -- TVA amănunt when 0xB62EA4DB1BB0ED384B81B54331FD6F4F then 'TVAColectata' -- TVA colectată when 0xB832507147DA60D34B138B69AEE3C330 then 'TVADeductibila' -- TVA deductibila when 0xA460909062B9FB6D40FE5AB98FBEAF22 then 'TVANeexigibilaCumparari' -- TVA neexigibila cumparari when 0x815578729BB635DF49168ABFD719B7A7 then 'TVANeexigibilaVanzari' -- TVA neexigibila vanzari when 0x8CA232DB75D72FB44C71101BB2D202BC then 'TVARegularizari' -- Regularizări TVA else null end, -- Valoare necompletata [ExtDimensionDr_Depozite] = [ExtDimensionDr_Depozite]._Description, -- Analitic (Dt) din Depozite [ExtDimensionDr_Depozite_ID] = [ExtDimensionDr_Depozite].[_IDRRef], -- KeyField din Depozite [ExtDimensionDr_GrupeNomenclator] = [ExtDimensionDr_GrupeNomenclator]._Description, -- Analitic (Dt) din Categorii de articole [ExtDimensionDr_GrupeNomenclator_ID] = [ExtDimensionDr_GrupeNomenclator].[_IDRRef], -- KeyField din Categorii de articole [ExtDimensionDr_ImobilizariCorporale] = [ExtDimensionDr_ImobilizariCorporale]._Description, -- Analitic (Dt) din Imobilizări corporale [ExtDimensionDr_ImobilizariCorporale_ID] = [ExtDimensionDr_ImobilizariCorporale].[_IDRRef], -- KeyField din Imobilizări corporale [ExtDimensionDr_Nomenclator] = [ExtDimensionDr_Nomenclator]._Description, -- Analitic (Dt) din Nomenclator de articole [ExtDimensionDr_Nomenclator_ID] = [ExtDimensionDr_Nomenclator].[_IDRRef], -- KeyField din Nomenclator de articole [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite] = N'Factură achiziție ' + [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_Fld629] + ' ' + [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_Fld622] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_Fld642]), 104), -- Analitic (Dt) din Aprovizionare și servicii primite [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite_ID] = [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef], -- KeyField din Aprovizionare și servicii primite [ExtDimensionCr_Id] = [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef], -- Analitic (Ct) [ExtDimensionCr_AvizDeIesire] = N'Aviz de ieșire ' + [ExtDimensionCr_AvizDeIesire].[_Fld743] + ' ' + [ExtDimensionCr_AvizDeIesire].[_Fld744] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_AvizDeIesire].[_Date_Time]), 104), -- Analitic (Ct) din Aviz de ieșire [ExtDimensionCr_AvizDeIesire_ID] = [ExtDimensionCr_AvizDeIesire].[_IDRRef], -- KeyField din Aviz de ieșire [ExtDimensionCr_ComandaService] = [ExtDimensionCr_ComandaService].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ComandaService].[_Date_Time]), 104), -- Analitic (Ct) din Comanda service [ExtDimensionCr_ComandaService_ID] = [ExtDimensionCr_ComandaService].[_IDRRef], -- KeyField din Comanda service [ExtDimensionCr_Venituri] = [ExtDimensionCr_Venituri]._Description, -- Analitic (Ct) din Venituri [ExtDimensionCr_Venituri_ID] = [ExtDimensionCr_Venituri].[_IDRRef], -- KeyField din Venituri [ExtDimensionCr_Import] = N'Import ' + [ExtDimensionCr_Import].[_Fld1360] + ' ' + [ExtDimensionCr_Import].[_Fld1353] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Import].[_Date_Time]), 104), -- Analitic (Ct) din Import [ExtDimensionCr_Import_ID] = [ExtDimensionCr_Import].[_IDRRef], -- KeyField din Import [ExtDimensionCr_Asamblare] = N'Asamblare ' + [ExtDimensionCr_Asamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Asamblare].[_Date_Time]), 104) , -- Analitic (Ct) din Asamblare [ExtDimensionCr_Asamblare_ID] = [ExtDimensionCr_Asamblare].[_IDRRef], -- KeyField din Asamblare [ExtDimensionCr_CheltuieliInAvans] = [ExtDimensionCr_CheltuieliInAvans]._Description, -- Analitic (Ct) din Cheltuieli în avans [ExtDimensionCr_CheltuieliInAvans_ID] = [ExtDimensionCr_CheltuieliInAvans].[_IDRRef], -- KeyField din Cheltuieli în avans [ExtDimensionCr_VenituriInAvans] = [ExtDimensionCr_VenituriInAvans]._Description, -- Analitic (Ct) din Venituri in avans [ExtDimensionCr_VenituriInAvans_ID] = [ExtDimensionCr_VenituriInAvans].[_IDRRef], -- KeyField din Venituri in avans [ExtDimensionCr_CoteTVA] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] -- Analitic (Ct) when 0xB4C7BA8ECAB8E9AA4781AB0C411CD3F7 then 'TVA24' -- 24% when 0x8E93795A2BFED36C41B6F46A053024B3 then 'TVA21' -- 21% when 0x84D7EA11D667B93443492CD03507ECF7 then 'TaxareInversa21' -- Taxare inversă cu cota TVA 21% when 0x916083897E575D3C4BDC5D55A45F4DF9 then 'TVA20' -- 20% when 0x8C1BE8BE1214692E44A8CDC688A8FBD6 then 'TVA19' -- 19% when 0x9BC8FDF9D7F874E645E90A55DC827E17 then 'TVA11' -- 11% when 0xABD86D672B9B5AC34E5679E443BEEC03 then 'TaxareInversa11' -- Taxare inversă cu cota TVA 11% when 0x80332F55AAC32BC94C993597696E1CC8 then 'TVA9' -- 9% when 0x8CE7B143CE2700A342C2E998812E3013 then 'TVA24BunuriDeCapital' -- 24% bunuri de capital when 0xA7CF114FA29E70C14ED698F8D155D6D1 then 'TVA20BunuriDeCapital' -- 20% bunuri de capital when 0x8203DFB60F64D95B45712811F1253CEB then 'TVA19BunuriDeCapital' -- 19% bunuri de capital when 0xBBCC419882DF91A94CFAD82F96C13E88 then 'TVA24NevoileFirmei' -- 24% nevoile firmei when 0x9EEDCAF3CAD4A9214BC5F501072B8ED3 then 'TVA20NevoileFirmei' -- 20% nevoile firmei when 0x80877F489FAEB92C428BA6A6CBB82BA9 then 'TVA19NevoileFirmei' -- 19% nevoile firmei when 0x865D336410F9072441C203F0377FA38C then 'TVA9NevoileFirmei' -- 9% nevoile firmei when 0xBE19D5CA351265EB4AECCDCA5E883434 then 'TVA24Fara' -- 24% fara drept de deducere when 0x8820314B861028A4487963A27F199FB9 then 'TVA20Fara' -- 20% fara drept de deducere when 0x89B17E9CB06A67AD408A8C506B31125D then 'TVA19Fara' -- 19% fara drept de deducere when 0x9CC53A5115830A83494B041D0FBF2B9A then 'TVA9Fara' -- 9% fara drept de deducere when 0x9201A6EA2FABA7F4486ED6550570B1EA then 'TVA5' -- Cota TVA 5% when 0xBF9BD68072E19A6443A6AD318917B35F then 'TVA5Fara' -- 5% fara drept de deducere when 0xA50008B4BC5BB5F6488067F06E225693 then 'TVAEU24' -- TVA la Import din UE cu cota TVA 24% when 0x98CDACE4D8112D17404D89F6EC78E58E then 'TVAEU20' -- TVA la Import din UE cu cota TVA 20% when 0xAA2DE3C795A60A4946C58A73B8C0D3D8 then 'TVAEU9' -- TVA la Import din UE cu cota TVA 9% when 0x9D7F41833CA965AD40D2EF75370D822F then 'TVAEU' -- TVA la Import din UE cu cota TVA 19% when 0xA7343E8E1A0E850E47499B6984E590D0 then 'TVAEUNevoileFirmei24' -- TVA la Import din UE pentru nevoile firmei 24% when 0xADD1FA8C2C531E7C4214C4136C7BE690 then 'TVAEUNevoileFirmei20' -- TVA la Import din UE pentru nevoile firmei 20% when 0xA63CAE39443F3F124E4FE4E5764FECED then 'TVAEUNevoileFirmei' -- TVA la Import din UE pentru nevoile firmei 19% when 0x90E847CAFD85B7D5449935D4869368A8 then 'ScutiteTVA' -- Scutite cu drept de deducere when 0x8475B75F9F772E4F483986B48A433441 then 'ScutiteTVAFara' -- Scutite fără drept de deducere when 0xAD95376DCFAE2A2E4D2EBDC397205D06 then 'ScutiteTVAExport' -- Scutite la Export cu drept de deducere when 0x84CDF3A0C3ED4D014963A725AD3D4325 then 'ScutiteTVAExportFara' -- Scutite la Export fără drept de deducere when 0xBBD8E71C3D67978943A649D63ECD8670 then 'ScutiteTVAEU' -- Scutite la Import din UE destinate revănzării when 0x9C67E1729338633C42C051FA429020BD then 'ScutiteTVAEUNevoileFirmei' -- Scutite la Import din UE pentru nevoile firmei when 0xB3061F8936BA52BC401F2800CDC6BB0C then 'ScutiteTVAExportEUArtA' -- Scutite la Export in UE conf. art.143 alin.2 lit.a) și d) when 0x985FDEF4B5E79BD248AD96AA65D298FA then 'ScutiteTVAExportEUArtB' -- Scutite la Export in UE conf. art.143 alin.2 lit.b) și c) when 0xBEF4E78F4A77E6F44933AE33DB4FC66D then 'ScutiteTVAExportArtC' -- Scutite la Export cu drept de deducere conf. art.143 alin.1 lit.c) și d) when 0x9B960D4C23DC1FB641D65C66EFBA015B then 'Neimpozabile' -- Neimpozabile when 0xA66C90AF717CACA04A14D1188C830084 then 'NeimpozabileEU' -- Neimpozabile la import din UE destinate revănzării when 0xBA28595D7674F34848E03E664F8293C1 then 'NeimpozabileEUNevoileFirmei' -- Neimpozabile la import din UE pentru nevoile firmei when 0x8F47D6FEB598A44147EAB8B39751B55C then 'TaxareInversa24' -- Taxare inversă cu cota TVA 24% when 0x8D85819C3502D9644F3554EF2A4E3205 then 'TaxareInversa20' -- Taxare inversă cu cota TVA 20% when 0x8AD9A80A67D813514E35CC59323A347C then 'TaxareInversa' -- Taxare inversă cu cota TVA 19% when 0xB6A801C6EF4283484A1B0ACE22370816 then 'TaxareInversa9' -- Taxare inversă cu cota TVA 9% when 0x884A08E3B99FD767426E8839E179CA05 then 'TaxareInversaServiciiIntangibile24' -- Taxare inversă servicii intangibile cu cota TVA 24% when 0x91D2395B478FB1C7403B9C973C22F1D2 then 'TaxareInversaServiciiIntangibile20' -- Taxare inversă servicii intangibile cu cota TVA 20% when 0x89574632F1AA15C341325D142FB16ADF then 'TaxareInversaServiciiIntangibile' -- Taxare inversă servicii intangibile cu cota TVA 19% else null end, -- Valoare necompletata [ExtDimensionCr_DecontDeAvans] = [ExtDimensionCr_DecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_DecontDeAvans].[_Date_Time]), 104), -- Analitic (Ct) din Decont de avans [ExtDimensionCr_DecontDeAvans_ID] = [ExtDimensionCr_DecontDeAvans].[_IDRRef], -- KeyField din Decont de avans [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate] = N'Vânzare și servicii prestate ' + [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_Fld2712] + ' ' + [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_Fld2707] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_Date_Time]), 104) , -- Analitic (Ct) din Vânzare și servicii prestate [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate_ID] = [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_IDRRef], -- KeyField din Vânzare și servicii prestate [ExtDimensionCr_IntroducereaSoldurilor] = [ExtDimensionCr_IntroducereaSoldurilor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_IntroducereaSoldurilor].[_Date_Time]), 104), -- Analitic (Ct) din Introducere solduri [ExtDimensionCr_IntroducereaSoldurilor_ID] = [ExtDimensionCr_IntroducereaSoldurilor].[_IDRRef], -- KeyField din Introducere solduri [ExtDimensionCr_CorectieAnaliticiDecontDeAvans] = [ExtDimensionCr_CorectieAnaliticiDecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_CorectieAnaliticiDecontDeAvans].[_Date_Time]), 104), -- Analitic (Ct) din Corectie analitici decont de avans [ExtDimensionCr_CorectieAnaliticiDecontDeAvans_ID] = [ExtDimensionCr_CorectieAnaliticiDecontDeAvans].[_IDRRef], -- KeyField din Corectie analitici decont de avans [ExtDimensionCr_AlteCheltuieliSiVenituri] = [ExtDimensionCr_AlteCheltuieliSiVenituri]._Description, -- Analitic (Ct) din Alte cheltuieli și venituri [ExtDimensionCr_AlteCheltuieliSiVenituri_ID] = [ExtDimensionCr_AlteCheltuieliSiVenituri].[_IDRRef], -- KeyField din Alte cheltuieli și venituri [ExtDimensionCr_Departamente] = [ExtDimensionCr_Departamente]._Description, -- Analitic (Ct) din Departamente [ExtDimensionCr_Departamente_ID] = [ExtDimensionCr_Departamente].[_IDRRef], -- KeyField din Departamente [ExtDimensionCr_Organizatii] = [ExtDimensionCr_Organizatii]._Description, -- Analitic (Ct) din Societăți [ExtDimensionCr_Organizatii_ID] = [ExtDimensionCr_Organizatii].[_IDRRef], -- KeyField din Societăți [ExtDimensionCr_EfecteDePrimit] = [ExtDimensionCr_EfecteDePrimit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_EfecteDePrimit].[_Date_Time]), 104), -- Analitic (Ct) din Efecte de primit [ExtDimensionCr_EfecteDePrimit_ID] = [ExtDimensionCr_EfecteDePrimit].[_IDRRef], -- KeyField din Efecte de primit [ExtDimensionCr_Incasare] = N'Dispoziție de încasare ' + [ExtDimensionCr_Incasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Incasare].[_Date_Time]), 104) , -- Analitic (Ct) din Dispoziție de încasare [ExtDimensionCr_Incasare_ID] = [ExtDimensionCr_Incasare].[_IDRRef], -- KeyField din Dispoziție de încasare [ExtDimensionCr_ExtrasDeCont] = N'Extras de cont ' + [ExtDimensionCr_ExtrasDeCont].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ExtrasDeCont].[_Date_Time]), 104), -- Analitic (Ct) din Extras de cont [ExtDimensionCr_ExtrasDeCont_ID] = [ExtDimensionCr_ExtrasDeCont].[_IDRRef], -- KeyField din Extras de cont [ExtDimensionCr_ReturDeLaClient] = N'Retur de la client ' + [ExtDimensionCr_ReturDeLaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ReturDeLaClient].[_Date_Time]), 104) , -- Analitic (Ct) din Retur de la client [ExtDimensionCr_ReturDeLaClient_ID] = [ExtDimensionCr_ReturDeLaClient].[_IDRRef], -- KeyField din Retur de la client [ExtDimensionCr_Dezasamblare] = N'Dezasamblare ' + [ExtDimensionCr_Dezasamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Dezasamblare].[_Date_Time]), 104) , -- Analitic (Ct) din Dezasamblare [ExtDimensionCr_Dezasamblare_ID] = [ExtDimensionCr_Dezasamblare].[_IDRRef], -- KeyField din Dezasamblare [ExtDimensionCr_Cheltuieli] = [ExtDimensionCr_Cheltuieli]._Description, -- Analitic (Ct) din Cheltuieli [ExtDimensionCr_Cheltuieli_ID] = [ExtDimensionCr_Cheltuieli].[_IDRRef], -- KeyField din Cheltuieli [ExtDimensionCr_Export] = [ExtDimensionCr_Export].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Export].[_Date_Time]), 104), -- Analitic (Ct) din Export [ExtDimensionCr_Export_ID] = [ExtDimensionCr_Export].[_IDRRef], -- KeyField din Export [ExtDimensionCr_CasareMF] = [ExtDimensionCr_CasareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_CasareMF].[_Date_Time]), 104), -- Analitic (Ct) din Casare MF [ExtDimensionCr_CasareMF_ID] = [ExtDimensionCr_CasareMF].[_IDRRef], -- KeyField din Casare MF [ExtDimensionCr_Casierii] = [ExtDimensionCr_Casierii]._Description, -- Analitic (Ct) din Casierii [ExtDimensionCr_Casierii_ID] = [ExtDimensionCr_Casierii].[_IDRRef], -- KeyField din Casierii [ExtDimensionCr_ImobilizariNecorporale] = [ExtDimensionCr_ImobilizariNecorporale]._Description, -- Analitic (Ct) din Imobilizari necorporale [ExtDimensionCr_ImobilizariNecorporale_ID] = [ExtDimensionCr_ImobilizariNecorporale].[_IDRRef], -- KeyField din Imobilizari necorporale [ExtDimensionCr_IntroducereaSoldurilorAmanunt] = [ExtDimensionCr_IntroducereaSoldurilorAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_IntroducereaSoldurilorAmanunt].[_Date_Time]), 104), -- Analitic (Ct) din Introducere solduri amănunt [ExtDimensionCr_IntroducereaSoldurilorAmanunt_ID] = [ExtDimensionCr_IntroducereaSoldurilorAmanunt].[_IDRRef], -- KeyField din Introducere solduri amănunt [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale] = [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale]._Description, -- Analitic (Ct) din Operații trezoreriale [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale_ID] = [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale].[_IDRRef], -- KeyField din Operații trezoreriale [ExtDimensionCr_ConturiBancare] = [ExtDimensionCr_ConturiBancare]._Description, -- Analitic (Ct) din Conturi bancare [ExtDimensionCr_ConturiBancare_ID] = [ExtDimensionCr_ConturiBancare].[_IDRRef], -- KeyField din Conturi bancare [ExtDimensionCr_EfecteDePlatit] = [ExtDimensionCr_EfecteDePlatit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_EfecteDePlatit].[_Date_Time]), 104), -- Analitic (Ct) din Efecte de plătit [ExtDimensionCr_EfecteDePlatit_ID] = [ExtDimensionCr_EfecteDePlatit].[_IDRRef], -- KeyField din Efecte de plătit [ExtDimensionCr_RaportDeProductie] = [ExtDimensionCr_RaportDeProductie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_RaportDeProductie].[_Date_Time]), 104), -- Analitic (Ct) din Raport de producție [ExtDimensionCr_RaportDeProductie_ID] = [ExtDimensionCr_RaportDeProductie].[_IDRRef], -- KeyField din Raport de producție [ExtDimensionCr_ReturLaFurnizor] = N'Retur la furnizor ' + [ExtDimensionCr_ReturLaFurnizor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ReturLaFurnizor].[_Date_Time]), 104) , -- Analitic (Ct) din Retur la furnizor [ExtDimensionCr_ReturLaFurnizor_ID] = [ExtDimensionCr_ReturLaFurnizor].[_IDRRef], -- KeyField din Retur la furnizor [ExtDimensionCr_PersoaneFizice] = [ExtDimensionCr_PersoaneFizice]._Description, -- Analitic (Ct) din Persoane fizice [ExtDimensionCr_PersoaneFizice_ID] = [ExtDimensionCr_PersoaneFizice].[_IDRRef], -- KeyField din Persoane fizice [ExtDimensionCr_AvizDeIntrare] = N'Aviz de intrare ' + coalesce(nullif(rtrim(ltrim([ExtDimensionCr_AvizDeIntrare].[_Fld805])), '') + ' ', '') + coalesce(nullif(rtrim(ltrim([ExtDimensionCr_AvizDeIntrare].[_Fld800])), ''), [ExtDimensionCr_AvizDeIntrare].[_Number]) + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_AvizDeIntrare].[_Date_Time]), 104), -- Analitic (Ct) din Aviz de intrare [ExtDimensionCr_AvizDeIntrare_ID] = [ExtDimensionCr_AvizDeIntrare].[_IDRRef], -- KeyField din Aviz de intrare [ExtDimensionCr_TransferDeMarfuri] = N'Transfer între gestiuni ' + [ExtDimensionCr_TransferDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_TransferDeMarfuri].[_Date_Time]), 104) , -- Analitic (Ct) din Transfer între gestiuni [ExtDimensionCr_TransferDeMarfuri_ID] = [ExtDimensionCr_TransferDeMarfuri].[_IDRRef], -- KeyField din Transfer între gestiuni [ExtDimensionCr_RambursareaTicheteDeMasa] = [ExtDimensionCr_RambursareaTicheteDeMasa].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_RambursareaTicheteDeMasa].[_Date_Time]), 104), -- Analitic (Ct) din Rambursarea tichete de masă [ExtDimensionCr_RambursareaTicheteDeMasa_ID] = [ExtDimensionCr_RambursareaTicheteDeMasa].[_IDRRef], -- KeyField din Rambursarea tichete de masă [ExtDimensionCr_Plata] = N'Dispoziție de plată ' + [ExtDimensionCr_Plata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Plata].[_Date_Time]), 104) , -- Analitic (Ct) din Dispoziție de plată [ExtDimensionCr_Plata_ID] = [ExtDimensionCr_Plata].[_IDRRef], -- KeyField din Dispoziție de plată [ExtDimensionCr_Partenerii] = [ExtDimensionCr_Partenerii]._Description, -- Analitic (Ct) din Parteneri [ExtDimensionCr_Partenerii_ID] = [ExtDimensionCr_Partenerii].[_IDRRef], -- KeyField din Parteneri [ExtDimensionCr_Partida] = [ExtDimensionCr_Partida].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_Partida].[_Date_Time]), 104), -- Analitic (Ct) din Partida de mărfuri [ExtDimensionCr_Partida_ID] = [ExtDimensionCr_Partida].[_IDRRef], -- KeyField din Partida de mărfuri [ExtDimensionCr_InventariereMarfuriInDepozit] = [ExtDimensionCr_InventariereMarfuriInDepozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_InventariereMarfuriInDepozit].[_Date_Time]), 104), -- Analitic (Ct) din Inventariere articole [ExtDimensionCr_InventariereMarfuriInDepozit_ID] = [ExtDimensionCr_InventariereMarfuriInDepozit].[_IDRRef], -- KeyField din Inventariere articole [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare] = [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare].[_Date_Time]), 104), -- Analitic (Ct) din Cheltuieli suplimentare la aprovizionare [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare_ID] = [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare].[_IDRRef], -- KeyField din Cheltuieli suplimentare la aprovizionare [ExtDimensionCr_ComandaDeviz] = [ExtDimensionCr_ComandaDeviz].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_ComandaDeviz].[_Date_Time]), 104), -- Analitic (Ct) din Comanda deviz [ExtDimensionCr_ComandaDeviz_ID] = [ExtDimensionCr_ComandaDeviz].[_IDRRef], -- KeyField din Comanda deviz [ExtDimensionCr_Contracte] = [ExtDimensionCr_Contracte]._Description, -- Analitic (Ct) din Contracte [ExtDimensionCr_Contracte_ID] = [ExtDimensionCr_Contracte].[_IDRRef], -- KeyField din Contracte [ExtDimensionCr_MarireStocDeMarfuri] = [ExtDimensionCr_MarireStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_MarireStocDeMarfuri].[_Date_Time]), 104), -- Analitic (Ct) din Mărire stoc de articole [ExtDimensionCr_MarireStocDeMarfuri_ID] = [ExtDimensionCr_MarireStocDeMarfuri].[_IDRRef], -- KeyField din Mărire stoc de articole [ExtDimensionCr_Impozite] = case [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] -- Analitic (Ct) when 0xA8BF7C70C4B54DCB4855177118C8B1A2 then 'Accize' -- Accize when 0xAD6F0559D7818679470BC55C6743FB69 then 'CASAngajat' -- CAS Angajat when 0x977E7D76659FBC6D4E096212938578DA then 'CASSAngajat' -- CASS Angajat when 0xA2BAED59635BBBAC4495DF1FDA904EBB then 'CCIAngajator' -- CCI angajator when 0x8865D469BF93F472468240BAE2734793 then 'ComisionITM' -- Comision ITM when 0x95DA6B80F381D548493D6F717CA23B16 then 'ComisionVamal' -- Comision vamal when 0x8737C7AB74F828C74CEA56E6BCCB67F1 then 'FacturiNesositeClient' -- Facturi nesosite client when 0x8265826A2911CC814DDF92A394BA6BC7 then 'FacturiNesositeFurnizor' -- Facturi nesosite furnizor when 0xB1F2CBC7E55761AC4084230D69BAAF61 then 'FondDeAccidente' -- Fond de accidente when 0xB648A9AEE68E0EA24345A1955DEE96CA then 'FondDeGarantare' -- Fond de garantare when 0x9797C05E7CEF9E0E45C49E40122164B9 then 'FondDeMediu' -- Fond de mediu when 0xA6F0FB8F8B75FAE34736FF540083F8C9 then 'FondSanatate' -- Fond sanatate when 0x8BCB1A709E39B25840841C3FC3CBAC95 then 'ImpozitPeAlteVenituriPF' -- Impozite pe alte venituri ale persoanelor fizice when 0x9248ABA269A22EF44EE0A356093DFB75 then 'ImpozitPeCladiri' -- Impozit pe clădiri when 0x9DB8AF7669CDD6D3442E2581350F18BF then 'ImpozitPeConstructiiSpeciale' -- Impozit pe construcții speciale (taxa de stâlp) when 0xAFE317D4C4738D4E4807771A8B516697 then 'ImpozitPeMasini' -- Impozit pe mașini when 0x88ACC35CCD5EAE804590C406404896E1 then 'ImpozitPeProfit' -- Impozit pe profit when 0x8F6E22CD256B84B541318BC74268CA90 then 'ImpozitPeSalarii' -- Impozit pe salarii when 0x8E30EC7E093667B547C335E26F356E86 then 'ImpozitPeTeren' -- Impozit pe teren when 0x861B188568D9DFA249414DD7C034834E then 'ImpozitTaxaFirmei' -- Impozit taxa firmei when 0x9F6AC006925F64034F26200BCF95F56A then 'ImpozitulPeVeniturileMicrointreprinderilor' -- Impozitul pe veniturile microintreprinderilor when 0xA6DBDC732961DFD84B36E0EA67D09133 then 'Somaj' -- Somaj angajator when 0xA4759E7A258F84DD4DD4AD6FD301817D then 'SomajAngajat' -- Somaj angajat when 0xBFAACF24C8E4F21240DD4E7B93BC7F22 then 'TaxaHabitat' -- Taxa habitat when 0xA6D94A070395F1274F5620535DCE8BC1 then 'TVAAmanunt' -- TVA amănunt when 0xB62EA4DB1BB0ED384B81B54331FD6F4F then 'TVAColectata' -- TVA colectată when 0xB832507147DA60D34B138B69AEE3C330 then 'TVADeductibila' -- TVA deductibila when 0xA460909062B9FB6D40FE5AB98FBEAF22 then 'TVANeexigibilaCumparari' -- TVA neexigibila cumparari when 0x815578729BB635DF49168ABFD719B7A7 then 'TVANeexigibilaVanzari' -- TVA neexigibila vanzari when 0x8CA232DB75D72FB44C71101BB2D202BC then 'TVARegularizari' -- Regularizări TVA else null end, -- Valoare necompletata [ExtDimensionCr_Depozite] = [ExtDimensionCr_Depozite]._Description, -- Analitic (Ct) din Depozite [ExtDimensionCr_Depozite_ID] = [ExtDimensionCr_Depozite].[_IDRRef], -- KeyField din Depozite [ExtDimensionCr_GrupeNomenclator] = [ExtDimensionCr_GrupeNomenclator]._Description, -- Analitic (Ct) din Categorii de articole [ExtDimensionCr_GrupeNomenclator_ID] = [ExtDimensionCr_GrupeNomenclator].[_IDRRef], -- KeyField din Categorii de articole [ExtDimensionCr_ImobilizariCorporale] = [ExtDimensionCr_ImobilizariCorporale]._Description, -- Analitic (Ct) din Imobilizări corporale [ExtDimensionCr_ImobilizariCorporale_ID] = [ExtDimensionCr_ImobilizariCorporale].[_IDRRef], -- KeyField din Imobilizări corporale [ExtDimensionCr_Nomenclator] = [ExtDimensionCr_Nomenclator]._Description, -- Analitic (Ct) din Nomenclator de articole [ExtDimensionCr_Nomenclator_ID] = [ExtDimensionCr_Nomenclator].[_IDRRef], -- KeyField din Nomenclator de articole [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite] = N'Factură achiziție ' + [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_Fld629] + ' ' + [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_Fld622] + ' din ' + convert(varchar(10), dateadd(year, -2000, [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_Fld642]), 104), -- Analitic (Ct) din Aprovizionare și servicii primite [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite_ID] = [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef], -- KeyField din Aprovizionare și servicii primite [Expression] = [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6815] -- Expresie from [flax].[dbo].[_Reference6798] as [ExcelReportFunctions_RecordsWithExtDimensions] left join [flax].[dbo].[_Chrc203] as [ExtDimensionTypeDr_TipSubcontoGeneral] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6811RRef] = [ExtDimensionTypeDr_TipSubcontoGeneral].[_IDRRef]) left join [flax].[dbo].[_Chrc203] as [ExtDimensionTypeCr_TipSubcontoGeneral] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6812RRef] = [ExtDimensionTypeCr_TipSubcontoGeneral].[_IDRRef]) left join [flax].[dbo].[_Document57] as [ExtDimensionDr_AvizDeIesire] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000039 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_AvizDeIesire].[_IDRRef]) left join [flax].[dbo].[_Document3372] as [ExtDimensionDr_ComandaService] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D2C and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ComandaService].[_IDRRef]) left join [flax].[dbo].[_Reference54] as [ExtDimensionDr_Venituri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000036 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Venituri].[_IDRRef]) left join [flax].[dbo].[_Document73] as [ExtDimensionDr_Import] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000049 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Import].[_IDRRef]) left join [flax].[dbo].[_Document3365] as [ExtDimensionDr_Asamblare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D25 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Asamblare].[_IDRRef]) left join [flax].[dbo].[_Reference11] as [ExtDimensionDr_CheltuieliInAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000000B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_CheltuieliInAvans].[_IDRRef]) left join [flax].[dbo].[_Reference5437] as [ExtDimensionDr_VenituriInAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000153D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_VenituriInAvans].[_IDRRef]) left join [flax].[dbo].[_Document67] as [ExtDimensionDr_DecontDeAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000043 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_DecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document117] as [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000075 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate].[_IDRRef]) left join [flax].[dbo].[_Document77] as [ExtDimensionDr_IntroducereaSoldurilor] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000004D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_IntroducereaSoldurilor].[_IDRRef]) left join [flax].[dbo].[_Document6989] as [ExtDimensionDr_CorectieAnaliticiDecontDeAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00001B4D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_CorectieAnaliticiDecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Reference3] as [ExtDimensionDr_AlteCheltuieliSiVenituri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000003 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_AlteCheltuieliSiVenituri].[_IDRRef]) left join [flax].[dbo].[_Reference18] as [ExtDimensionDr_Departamente] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000012 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Departamente].[_IDRRef]) left join [flax].[dbo].[_Reference34] as [ExtDimensionDr_Organizatii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000022 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Organizatii].[_IDRRef]) left join [flax].[dbo].[_Document71] as [ExtDimensionDr_EfecteDePrimit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000047 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_EfecteDePrimit].[_IDRRef]) left join [flax].[dbo].[_Document74] as [ExtDimensionDr_Incasare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000004A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Incasare].[_IDRRef]) left join [flax].[dbo].[_Document72] as [ExtDimensionDr_ExtrasDeCont] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000048 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ExtrasDeCont].[_IDRRef]) left join [flax].[dbo].[_Document101] as [ExtDimensionDr_ReturDeLaClient] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000065 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ReturDeLaClient].[_IDRRef]) left join [flax].[dbo].[_Document3377] as [ExtDimensionDr_Dezasamblare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D31 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Dezasamblare].[_IDRRef]) left join [flax].[dbo].[_Reference10] as [ExtDimensionDr_Cheltuieli] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000000A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Cheltuieli].[_IDRRef]) left join [flax].[dbo].[_Document3378] as [ExtDimensionDr_Export] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D32 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Export].[_IDRRef]) left join [flax].[dbo].[_Document63] as [ExtDimensionDr_CasareMF] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000003F and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_CasareMF].[_IDRRef]) left join [flax].[dbo].[_Reference8] as [ExtDimensionDr_Casierii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000008 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Casierii].[_IDRRef]) left join [flax].[dbo].[_Reference29] as [ExtDimensionDr_ImobilizariNecorporale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000001D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ImobilizariNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document78] as [ExtDimensionDr_IntroducereaSoldurilorAmanunt] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000004E and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_IntroducereaSoldurilorAmanunt].[_IDRRef]) left join [flax].[dbo].[_Reference46] as [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000002E and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale].[_IDRRef]) left join [flax].[dbo].[_Reference16] as [ExtDimensionDr_ConturiBancare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000010 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ConturiBancare].[_IDRRef]) left join [flax].[dbo].[_Document70] as [ExtDimensionDr_EfecteDePlatit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000046 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_EfecteDePlatit].[_IDRRef]) left join [flax].[dbo].[_Document98] as [ExtDimensionDr_RaportDeProductie] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000062 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_RaportDeProductie].[_IDRRef]) left join [flax].[dbo].[_Document102] as [ExtDimensionDr_ReturLaFurnizor] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000066 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ReturLaFurnizor].[_IDRRef]) left join [flax].[dbo].[_Reference37] as [ExtDimensionDr_PersoaneFizice] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000025 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_PersoaneFizice].[_IDRRef]) left join [flax].[dbo].[_Document58] as [ExtDimensionDr_AvizDeIntrare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000003A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_AvizDeIntrare].[_IDRRef]) left join [flax].[dbo].[_Document114] as [ExtDimensionDr_TransferDeMarfuri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000072 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_TransferDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document4661] as [ExtDimensionDr_RambursareaTicheteDeMasa] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00001235 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_RambursareaTicheteDeMasa].[_IDRRef]) left join [flax].[dbo].[_Document91] as [ExtDimensionDr_Plata] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000005B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Plata].[_IDRRef]) left join [flax].[dbo].[_Reference35] as [ExtDimensionDr_Partenerii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000023 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Partenerii].[_IDRRef]) left join [flax].[dbo].[_Document90] as [ExtDimensionDr_Partida] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000005A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Partida].[_IDRRef]) left join [flax].[dbo].[_Document80] as [ExtDimensionDr_InventariereMarfuriInDepozit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000050 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_InventariereMarfuriInDepozit].[_IDRRef]) left join [flax].[dbo].[_Document64] as [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000040 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare].[_IDRRef]) left join [flax].[dbo].[_Document3371] as [ExtDimensionDr_ComandaDeviz] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000D2B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ComandaDeviz].[_IDRRef]) left join [flax].[dbo].[_Reference15] as [ExtDimensionDr_Contracte] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000000F and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Contracte].[_IDRRef]) left join [flax].[dbo].[_Document83] as [ExtDimensionDr_MarireStocDeMarfuri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000053 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_MarireStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Reference19] as [ExtDimensionDr_Depozite] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000013 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Depozite].[_IDRRef]) left join [flax].[dbo].[_Reference26] as [ExtDimensionDr_GrupeNomenclator] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000001A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_GrupeNomenclator].[_IDRRef]) left join [flax].[dbo].[_Reference28] as [ExtDimensionDr_ImobilizariCorporale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x0000001C and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_ImobilizariCorporale].[_IDRRef]) left join [flax].[dbo].[_Reference32] as [ExtDimensionDr_Nomenclator] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000020 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_Nomenclator].[_IDRRef]) left join [flax].[dbo].[_Document56] as [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RTRef] = 0x00000038 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6813_RRRef] = [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef]) left join [flax].[dbo].[_Document57] as [ExtDimensionCr_AvizDeIesire] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000039 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_AvizDeIesire].[_IDRRef]) left join [flax].[dbo].[_Document3372] as [ExtDimensionCr_ComandaService] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D2C and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ComandaService].[_IDRRef]) left join [flax].[dbo].[_Reference54] as [ExtDimensionCr_Venituri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000036 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Venituri].[_IDRRef]) left join [flax].[dbo].[_Document73] as [ExtDimensionCr_Import] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000049 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Import].[_IDRRef]) left join [flax].[dbo].[_Document3365] as [ExtDimensionCr_Asamblare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D25 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Asamblare].[_IDRRef]) left join [flax].[dbo].[_Reference11] as [ExtDimensionCr_CheltuieliInAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000000B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_CheltuieliInAvans].[_IDRRef]) left join [flax].[dbo].[_Reference5437] as [ExtDimensionCr_VenituriInAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000153D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_VenituriInAvans].[_IDRRef]) left join [flax].[dbo].[_Document67] as [ExtDimensionCr_DecontDeAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000043 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_DecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document117] as [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000075 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate].[_IDRRef]) left join [flax].[dbo].[_Document77] as [ExtDimensionCr_IntroducereaSoldurilor] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000004D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_IntroducereaSoldurilor].[_IDRRef]) left join [flax].[dbo].[_Document6989] as [ExtDimensionCr_CorectieAnaliticiDecontDeAvans] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00001B4D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_CorectieAnaliticiDecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Reference3] as [ExtDimensionCr_AlteCheltuieliSiVenituri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000003 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_AlteCheltuieliSiVenituri].[_IDRRef]) left join [flax].[dbo].[_Reference18] as [ExtDimensionCr_Departamente] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000012 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Departamente].[_IDRRef]) left join [flax].[dbo].[_Reference34] as [ExtDimensionCr_Organizatii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000022 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Organizatii].[_IDRRef]) left join [flax].[dbo].[_Document71] as [ExtDimensionCr_EfecteDePrimit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000047 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_EfecteDePrimit].[_IDRRef]) left join [flax].[dbo].[_Document74] as [ExtDimensionCr_Incasare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000004A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Incasare].[_IDRRef]) left join [flax].[dbo].[_Document72] as [ExtDimensionCr_ExtrasDeCont] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000048 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ExtrasDeCont].[_IDRRef]) left join [flax].[dbo].[_Document101] as [ExtDimensionCr_ReturDeLaClient] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000065 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ReturDeLaClient].[_IDRRef]) left join [flax].[dbo].[_Document3377] as [ExtDimensionCr_Dezasamblare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D31 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Dezasamblare].[_IDRRef]) left join [flax].[dbo].[_Reference10] as [ExtDimensionCr_Cheltuieli] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000000A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Cheltuieli].[_IDRRef]) left join [flax].[dbo].[_Document3378] as [ExtDimensionCr_Export] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D32 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Export].[_IDRRef]) left join [flax].[dbo].[_Document63] as [ExtDimensionCr_CasareMF] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000003F and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_CasareMF].[_IDRRef]) left join [flax].[dbo].[_Reference8] as [ExtDimensionCr_Casierii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000008 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Casierii].[_IDRRef]) left join [flax].[dbo].[_Reference29] as [ExtDimensionCr_ImobilizariNecorporale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000001D and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ImobilizariNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document78] as [ExtDimensionCr_IntroducereaSoldurilorAmanunt] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000004E and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_IntroducereaSoldurilorAmanunt].[_IDRRef]) left join [flax].[dbo].[_Reference46] as [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000002E and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale].[_IDRRef]) left join [flax].[dbo].[_Reference16] as [ExtDimensionCr_ConturiBancare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000010 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ConturiBancare].[_IDRRef]) left join [flax].[dbo].[_Document70] as [ExtDimensionCr_EfecteDePlatit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000046 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_EfecteDePlatit].[_IDRRef]) left join [flax].[dbo].[_Document98] as [ExtDimensionCr_RaportDeProductie] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000062 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_RaportDeProductie].[_IDRRef]) left join [flax].[dbo].[_Document102] as [ExtDimensionCr_ReturLaFurnizor] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000066 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ReturLaFurnizor].[_IDRRef]) left join [flax].[dbo].[_Reference37] as [ExtDimensionCr_PersoaneFizice] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000025 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_PersoaneFizice].[_IDRRef]) left join [flax].[dbo].[_Document58] as [ExtDimensionCr_AvizDeIntrare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000003A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_AvizDeIntrare].[_IDRRef]) left join [flax].[dbo].[_Document114] as [ExtDimensionCr_TransferDeMarfuri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000072 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_TransferDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document4661] as [ExtDimensionCr_RambursareaTicheteDeMasa] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00001235 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_RambursareaTicheteDeMasa].[_IDRRef]) left join [flax].[dbo].[_Document91] as [ExtDimensionCr_Plata] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000005B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Plata].[_IDRRef]) left join [flax].[dbo].[_Reference35] as [ExtDimensionCr_Partenerii] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000023 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Partenerii].[_IDRRef]) left join [flax].[dbo].[_Document90] as [ExtDimensionCr_Partida] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000005A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Partida].[_IDRRef]) left join [flax].[dbo].[_Document80] as [ExtDimensionCr_InventariereMarfuriInDepozit] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000050 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_InventariereMarfuriInDepozit].[_IDRRef]) left join [flax].[dbo].[_Document64] as [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000040 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare].[_IDRRef]) left join [flax].[dbo].[_Document3371] as [ExtDimensionCr_ComandaDeviz] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000D2B and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ComandaDeviz].[_IDRRef]) left join [flax].[dbo].[_Reference15] as [ExtDimensionCr_Contracte] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000000F and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Contracte].[_IDRRef]) left join [flax].[dbo].[_Document83] as [ExtDimensionCr_MarireStocDeMarfuri] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000053 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_MarireStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Reference19] as [ExtDimensionCr_Depozite] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000013 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Depozite].[_IDRRef]) left join [flax].[dbo].[_Reference26] as [ExtDimensionCr_GrupeNomenclator] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000001A and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_GrupeNomenclator].[_IDRRef]) left join [flax].[dbo].[_Reference28] as [ExtDimensionCr_ImobilizariCorporale] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x0000001C and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_ImobilizariCorporale].[_IDRRef]) left join [flax].[dbo].[_Reference32] as [ExtDimensionCr_Nomenclator] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000020 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_Nomenclator].[_IDRRef]) left join [flax].[dbo].[_Document56] as [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite] on ([ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_TYPE] = 0x08 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RTRef] = 0x00000038 and [ExcelReportFunctions_RecordsWithExtDimensions].[_Fld6814_RRRef] = [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef])
Full View Select Sql with fields
Exemplu de apel pentru view-ul asociat obiectul curent din baza destinatie cu câmpuri
select [KeyField], --Referință către înregistrare [Version], --Versiune înregistrare [Marked], --Înregistrare marcată [Metadata], --Metadate înregistrare [OwnerId], --Owner-ul documentului [Code], --Codul de identificare al înregistrării [Description], --Descriere înregistrării [Sign], --Semn [Indicator], --Indicator [ExtDimensionTypeDr], --Tip analitic (Dt) din Tip subconto general [ExtDimensionTypeDr_ID], --Tip analitic (Dt) din Tip subconto general ID [ExtDimensionTypeCr], --Tip analitic (Ct) din Tip subconto general [ExtDimensionTypeCr_ID], --Tip analitic (Ct) din Tip subconto general ID [ExtDimensionDr_Id], --Analitic (Dt) [ExtDimensionDr_AvizDeIesire], --Analitic (Dt) din Aviz de ieșire [ExtDimensionDr_AvizDeIesire_ID], --Analitic (Dt) din Aviz de ieșire ID [ExtDimensionDr_ComandaService], --Analitic (Dt) din Comanda service [ExtDimensionDr_ComandaService_ID], --Analitic (Dt) din Comanda service ID [ExtDimensionDr_Venituri], --Analitic (Dt) din Venituri [ExtDimensionDr_Venituri_ID], --Analitic (Dt) din Venituri ID [ExtDimensionDr_Import], --Analitic (Dt) din Import [ExtDimensionDr_Import_ID], --Analitic (Dt) din Import ID [ExtDimensionDr_Asamblare], --Analitic (Dt) din Asamblare [ExtDimensionDr_Asamblare_ID], --Analitic (Dt) din Asamblare ID [ExtDimensionDr_CheltuieliInAvans], --Analitic (Dt) din Cheltuieli în avans [ExtDimensionDr_CheltuieliInAvans_ID], --Analitic (Dt) din Cheltuieli în avans ID [ExtDimensionDr_VenituriInAvans], --Analitic (Dt) din Venituri in avans [ExtDimensionDr_VenituriInAvans_ID], --Analitic (Dt) din Venituri in avans ID [ExtDimensionDr_CoteTVA], --Analitic (Dt) [ExtDimensionDr_DecontDeAvans], --Analitic (Dt) din Decont de avans [ExtDimensionDr_DecontDeAvans_ID], --Analitic (Dt) din Decont de avans ID [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate], --Analitic (Dt) din Vânzare și servicii prestate [ExtDimensionDr_VanzareMarfuriSiServiciiPrestate_ID], --Analitic (Dt) din Vânzare și servicii prestate ID [ExtDimensionDr_IntroducereaSoldurilor], --Analitic (Dt) din Introducere solduri [ExtDimensionDr_IntroducereaSoldurilor_ID], --Analitic (Dt) din Introducere solduri ID [ExtDimensionDr_CorectieAnaliticiDecontDeAvans], --Analitic (Dt) din Corectie analitici decont de avans [ExtDimensionDr_CorectieAnaliticiDecontDeAvans_ID], --Analitic (Dt) din Corectie analitici decont de avans ID [ExtDimensionDr_AlteCheltuieliSiVenituri], --Analitic (Dt) din Alte cheltuieli și venituri [ExtDimensionDr_AlteCheltuieliSiVenituri_ID], --Analitic (Dt) din Alte cheltuieli și venituri ID [ExtDimensionDr_Departamente], --Analitic (Dt) din Departamente [ExtDimensionDr_Departamente_ID], --Analitic (Dt) din Departamente ID [ExtDimensionDr_Organizatii], --Analitic (Dt) din Societăți [ExtDimensionDr_Organizatii_ID], --Analitic (Dt) din Societăți ID [ExtDimensionDr_EfecteDePrimit], --Analitic (Dt) din Efecte de primit [ExtDimensionDr_EfecteDePrimit_ID], --Analitic (Dt) din Efecte de primit ID [ExtDimensionDr_Incasare], --Analitic (Dt) din Dispoziție de încasare [ExtDimensionDr_Incasare_ID], --Analitic (Dt) din Dispoziție de încasare ID [ExtDimensionDr_ExtrasDeCont], --Analitic (Dt) din Extras de cont [ExtDimensionDr_ExtrasDeCont_ID], --Analitic (Dt) din Extras de cont ID [ExtDimensionDr_ReturDeLaClient], --Analitic (Dt) din Retur de la client [ExtDimensionDr_ReturDeLaClient_ID], --Analitic (Dt) din Retur de la client ID [ExtDimensionDr_Dezasamblare], --Analitic (Dt) din Dezasamblare [ExtDimensionDr_Dezasamblare_ID], --Analitic (Dt) din Dezasamblare ID [ExtDimensionDr_Cheltuieli], --Analitic (Dt) din Cheltuieli [ExtDimensionDr_Cheltuieli_ID], --Analitic (Dt) din Cheltuieli ID [ExtDimensionDr_Export], --Analitic (Dt) din Export [ExtDimensionDr_Export_ID], --Analitic (Dt) din Export ID [ExtDimensionDr_CasareMF], --Analitic (Dt) din Casare MF [ExtDimensionDr_CasareMF_ID], --Analitic (Dt) din Casare MF ID [ExtDimensionDr_Casierii], --Analitic (Dt) din Casierii [ExtDimensionDr_Casierii_ID], --Analitic (Dt) din Casierii ID [ExtDimensionDr_ImobilizariNecorporale], --Analitic (Dt) din Imobilizari necorporale [ExtDimensionDr_ImobilizariNecorporale_ID], --Analitic (Dt) din Imobilizari necorporale ID [ExtDimensionDr_IntroducereaSoldurilorAmanunt], --Analitic (Dt) din Introducere solduri amănunt [ExtDimensionDr_IntroducereaSoldurilorAmanunt_ID], --Analitic (Dt) din Introducere solduri amănunt ID [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale], --Analitic (Dt) din Operații trezoreriale [ExtDimensionDr_TipuriDeOperatiuniTrezoreriale_ID], --Analitic (Dt) din Operații trezoreriale ID [ExtDimensionDr_ConturiBancare], --Analitic (Dt) din Conturi bancare [ExtDimensionDr_ConturiBancare_ID], --Analitic (Dt) din Conturi bancare ID [ExtDimensionDr_EfecteDePlatit], --Analitic (Dt) din Efecte de plătit [ExtDimensionDr_EfecteDePlatit_ID], --Analitic (Dt) din Efecte de plătit ID [ExtDimensionDr_RaportDeProductie], --Analitic (Dt) din Raport de producție [ExtDimensionDr_RaportDeProductie_ID], --Analitic (Dt) din Raport de producție ID [ExtDimensionDr_ReturLaFurnizor], --Analitic (Dt) din Retur la furnizor [ExtDimensionDr_ReturLaFurnizor_ID], --Analitic (Dt) din Retur la furnizor ID [ExtDimensionDr_PersoaneFizice], --Analitic (Dt) din Persoane fizice [ExtDimensionDr_PersoaneFizice_ID], --Analitic (Dt) din Persoane fizice ID [ExtDimensionDr_AvizDeIntrare], --Analitic (Dt) din Aviz de intrare [ExtDimensionDr_AvizDeIntrare_ID], --Analitic (Dt) din Aviz de intrare ID [ExtDimensionDr_TransferDeMarfuri], --Analitic (Dt) din Transfer între gestiuni [ExtDimensionDr_TransferDeMarfuri_ID], --Analitic (Dt) din Transfer între gestiuni ID [ExtDimensionDr_RambursareaTicheteDeMasa], --Analitic (Dt) din Rambursarea tichete de masă [ExtDimensionDr_RambursareaTicheteDeMasa_ID], --Analitic (Dt) din Rambursarea tichete de masă ID [ExtDimensionDr_Plata], --Analitic (Dt) din Dispoziție de plată [ExtDimensionDr_Plata_ID], --Analitic (Dt) din Dispoziție de plată ID [ExtDimensionDr_Partenerii], --Analitic (Dt) din Parteneri [ExtDimensionDr_Partenerii_ID], --Analitic (Dt) din Parteneri ID [ExtDimensionDr_Partida], --Analitic (Dt) din Partida de mărfuri [ExtDimensionDr_Partida_ID], --Analitic (Dt) din Partida de mărfuri ID [ExtDimensionDr_InventariereMarfuriInDepozit], --Analitic (Dt) din Inventariere articole [ExtDimensionDr_InventariereMarfuriInDepozit_ID], --Analitic (Dt) din Inventariere articole ID [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare], --Analitic (Dt) din Cheltuieli suplimentare la aprovizionare [ExtDimensionDr_CheltuieliSuplimentareLaAprovizionare_ID],--Analitic (Dt) din Cheltuieli suplimentare la aprovizionare ID [ExtDimensionDr_ComandaDeviz], --Analitic (Dt) din Comanda deviz [ExtDimensionDr_ComandaDeviz_ID], --Analitic (Dt) din Comanda deviz ID [ExtDimensionDr_Contracte], --Analitic (Dt) din Contracte [ExtDimensionDr_Contracte_ID], --Analitic (Dt) din Contracte ID [ExtDimensionDr_MarireStocDeMarfuri], --Analitic (Dt) din Mărire stoc de articole [ExtDimensionDr_MarireStocDeMarfuri_ID], --Analitic (Dt) din Mărire stoc de articole ID [ExtDimensionDr_Impozite], --Analitic (Dt) [ExtDimensionDr_Depozite], --Analitic (Dt) din Depozite [ExtDimensionDr_Depozite_ID], --Analitic (Dt) din Depozite ID [ExtDimensionDr_GrupeNomenclator], --Analitic (Dt) din Categorii de articole [ExtDimensionDr_GrupeNomenclator_ID], --Analitic (Dt) din Categorii de articole ID [ExtDimensionDr_ImobilizariCorporale], --Analitic (Dt) din Imobilizări corporale [ExtDimensionDr_ImobilizariCorporale_ID], --Analitic (Dt) din Imobilizări corporale ID [ExtDimensionDr_Nomenclator], --Analitic (Dt) din Nomenclator de articole [ExtDimensionDr_Nomenclator_ID], --Analitic (Dt) din Nomenclator de articole ID [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite], --Analitic (Dt) din Aprovizionare și servicii primite [ExtDimensionDr_AprovizionareMarfuriSiServiciiPrimite_ID],--Analitic (Dt) din Aprovizionare și servicii primite ID [ExtDimensionCr_Id], --Analitic (Ct) [ExtDimensionCr_AvizDeIesire], --Analitic (Ct) din Aviz de ieșire [ExtDimensionCr_AvizDeIesire_ID], --Analitic (Ct) din Aviz de ieșire ID [ExtDimensionCr_ComandaService], --Analitic (Ct) din Comanda service [ExtDimensionCr_ComandaService_ID], --Analitic (Ct) din Comanda service ID [ExtDimensionCr_Venituri], --Analitic (Ct) din Venituri [ExtDimensionCr_Venituri_ID], --Analitic (Ct) din Venituri ID [ExtDimensionCr_Import], --Analitic (Ct) din Import [ExtDimensionCr_Import_ID], --Analitic (Ct) din Import ID [ExtDimensionCr_Asamblare], --Analitic (Ct) din Asamblare [ExtDimensionCr_Asamblare_ID], --Analitic (Ct) din Asamblare ID [ExtDimensionCr_CheltuieliInAvans], --Analitic (Ct) din Cheltuieli în avans [ExtDimensionCr_CheltuieliInAvans_ID], --Analitic (Ct) din Cheltuieli în avans ID [ExtDimensionCr_VenituriInAvans], --Analitic (Ct) din Venituri in avans [ExtDimensionCr_VenituriInAvans_ID], --Analitic (Ct) din Venituri in avans ID [ExtDimensionCr_CoteTVA], --Analitic (Ct) [ExtDimensionCr_DecontDeAvans], --Analitic (Ct) din Decont de avans [ExtDimensionCr_DecontDeAvans_ID], --Analitic (Ct) din Decont de avans ID [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate], --Analitic (Ct) din Vânzare și servicii prestate [ExtDimensionCr_VanzareMarfuriSiServiciiPrestate_ID], --Analitic (Ct) din Vânzare și servicii prestate ID [ExtDimensionCr_IntroducereaSoldurilor], --Analitic (Ct) din Introducere solduri [ExtDimensionCr_IntroducereaSoldurilor_ID], --Analitic (Ct) din Introducere solduri ID [ExtDimensionCr_CorectieAnaliticiDecontDeAvans], --Analitic (Ct) din Corectie analitici decont de avans [ExtDimensionCr_CorectieAnaliticiDecontDeAvans_ID], --Analitic (Ct) din Corectie analitici decont de avans ID [ExtDimensionCr_AlteCheltuieliSiVenituri], --Analitic (Ct) din Alte cheltuieli și venituri [ExtDimensionCr_AlteCheltuieliSiVenituri_ID], --Analitic (Ct) din Alte cheltuieli și venituri ID [ExtDimensionCr_Departamente], --Analitic (Ct) din Departamente [ExtDimensionCr_Departamente_ID], --Analitic (Ct) din Departamente ID [ExtDimensionCr_Organizatii], --Analitic (Ct) din Societăți [ExtDimensionCr_Organizatii_ID], --Analitic (Ct) din Societăți ID [ExtDimensionCr_EfecteDePrimit], --Analitic (Ct) din Efecte de primit [ExtDimensionCr_EfecteDePrimit_ID], --Analitic (Ct) din Efecte de primit ID [ExtDimensionCr_Incasare], --Analitic (Ct) din Dispoziție de încasare [ExtDimensionCr_Incasare_ID], --Analitic (Ct) din Dispoziție de încasare ID [ExtDimensionCr_ExtrasDeCont], --Analitic (Ct) din Extras de cont [ExtDimensionCr_ExtrasDeCont_ID], --Analitic (Ct) din Extras de cont ID [ExtDimensionCr_ReturDeLaClient], --Analitic (Ct) din Retur de la client [ExtDimensionCr_ReturDeLaClient_ID], --Analitic (Ct) din Retur de la client ID [ExtDimensionCr_Dezasamblare], --Analitic (Ct) din Dezasamblare [ExtDimensionCr_Dezasamblare_ID], --Analitic (Ct) din Dezasamblare ID [ExtDimensionCr_Cheltuieli], --Analitic (Ct) din Cheltuieli [ExtDimensionCr_Cheltuieli_ID], --Analitic (Ct) din Cheltuieli ID [ExtDimensionCr_Export], --Analitic (Ct) din Export [ExtDimensionCr_Export_ID], --Analitic (Ct) din Export ID [ExtDimensionCr_CasareMF], --Analitic (Ct) din Casare MF [ExtDimensionCr_CasareMF_ID], --Analitic (Ct) din Casare MF ID [ExtDimensionCr_Casierii], --Analitic (Ct) din Casierii [ExtDimensionCr_Casierii_ID], --Analitic (Ct) din Casierii ID [ExtDimensionCr_ImobilizariNecorporale], --Analitic (Ct) din Imobilizari necorporale [ExtDimensionCr_ImobilizariNecorporale_ID], --Analitic (Ct) din Imobilizari necorporale ID [ExtDimensionCr_IntroducereaSoldurilorAmanunt], --Analitic (Ct) din Introducere solduri amănunt [ExtDimensionCr_IntroducereaSoldurilorAmanunt_ID], --Analitic (Ct) din Introducere solduri amănunt ID [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale], --Analitic (Ct) din Operații trezoreriale [ExtDimensionCr_TipuriDeOperatiuniTrezoreriale_ID], --Analitic (Ct) din Operații trezoreriale ID [ExtDimensionCr_ConturiBancare], --Analitic (Ct) din Conturi bancare [ExtDimensionCr_ConturiBancare_ID], --Analitic (Ct) din Conturi bancare ID [ExtDimensionCr_EfecteDePlatit], --Analitic (Ct) din Efecte de plătit [ExtDimensionCr_EfecteDePlatit_ID], --Analitic (Ct) din Efecte de plătit ID [ExtDimensionCr_RaportDeProductie], --Analitic (Ct) din Raport de producție [ExtDimensionCr_RaportDeProductie_ID], --Analitic (Ct) din Raport de producție ID [ExtDimensionCr_ReturLaFurnizor], --Analitic (Ct) din Retur la furnizor [ExtDimensionCr_ReturLaFurnizor_ID], --Analitic (Ct) din Retur la furnizor ID [ExtDimensionCr_PersoaneFizice], --Analitic (Ct) din Persoane fizice [ExtDimensionCr_PersoaneFizice_ID], --Analitic (Ct) din Persoane fizice ID [ExtDimensionCr_AvizDeIntrare], --Analitic (Ct) din Aviz de intrare [ExtDimensionCr_AvizDeIntrare_ID], --Analitic (Ct) din Aviz de intrare ID [ExtDimensionCr_TransferDeMarfuri], --Analitic (Ct) din Transfer între gestiuni [ExtDimensionCr_TransferDeMarfuri_ID], --Analitic (Ct) din Transfer între gestiuni ID [ExtDimensionCr_RambursareaTicheteDeMasa], --Analitic (Ct) din Rambursarea tichete de masă [ExtDimensionCr_RambursareaTicheteDeMasa_ID], --Analitic (Ct) din Rambursarea tichete de masă ID [ExtDimensionCr_Plata], --Analitic (Ct) din Dispoziție de plată [ExtDimensionCr_Plata_ID], --Analitic (Ct) din Dispoziție de plată ID [ExtDimensionCr_Partenerii], --Analitic (Ct) din Parteneri [ExtDimensionCr_Partenerii_ID], --Analitic (Ct) din Parteneri ID [ExtDimensionCr_Partida], --Analitic (Ct) din Partida de mărfuri [ExtDimensionCr_Partida_ID], --Analitic (Ct) din Partida de mărfuri ID [ExtDimensionCr_InventariereMarfuriInDepozit], --Analitic (Ct) din Inventariere articole [ExtDimensionCr_InventariereMarfuriInDepozit_ID], --Analitic (Ct) din Inventariere articole ID [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare], --Analitic (Ct) din Cheltuieli suplimentare la aprovizionare [ExtDimensionCr_CheltuieliSuplimentareLaAprovizionare_ID],--Analitic (Ct) din Cheltuieli suplimentare la aprovizionare ID [ExtDimensionCr_ComandaDeviz], --Analitic (Ct) din Comanda deviz [ExtDimensionCr_ComandaDeviz_ID], --Analitic (Ct) din Comanda deviz ID [ExtDimensionCr_Contracte], --Analitic (Ct) din Contracte [ExtDimensionCr_Contracte_ID], --Analitic (Ct) din Contracte ID [ExtDimensionCr_MarireStocDeMarfuri], --Analitic (Ct) din Mărire stoc de articole [ExtDimensionCr_MarireStocDeMarfuri_ID], --Analitic (Ct) din Mărire stoc de articole ID [ExtDimensionCr_Impozite], --Analitic (Ct) [ExtDimensionCr_Depozite], --Analitic (Ct) din Depozite [ExtDimensionCr_Depozite_ID], --Analitic (Ct) din Depozite ID [ExtDimensionCr_GrupeNomenclator], --Analitic (Ct) din Categorii de articole [ExtDimensionCr_GrupeNomenclator_ID], --Analitic (Ct) din Categorii de articole ID [ExtDimensionCr_ImobilizariCorporale], --Analitic (Ct) din Imobilizări corporale [ExtDimensionCr_ImobilizariCorporale_ID], --Analitic (Ct) din Imobilizări corporale ID [ExtDimensionCr_Nomenclator], --Analitic (Ct) din Nomenclator de articole [ExtDimensionCr_Nomenclator_ID], --Analitic (Ct) din Nomenclator de articole ID [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite], --Analitic (Ct) din Aprovizionare și servicii primite [ExtDimensionCr_AprovizionareMarfuriSiServiciiPrimite_ID],--Analitic (Ct) din Aprovizionare și servicii primite ID [Expression] --Expresie from [flax].[ExcelReportFunctions_RecordsWithExtDimensions] -- Excel funcții raport (RecordsWithExtDimensions)
Full View Select Sql
Exemplu de apel pentru view-ul asociat obiectul curent din baza destinatie fără câmpuri
select * from [flax].[ExcelReportFunctions_RecordsWithExtDimensions] -- Excel funcții raport (RecordsWithExtDimensions)