Obiectul ЗаполнениеДвижений
Detalierea Obiectului : ЗаполнениеДвижений
Nume Obiect : ЗаполнениеДвижений
Nume Tabela Sursa : _Document6936_VT6954
Nume View : RegistersEditor_ЗаполнениеДвижений
-
Tabela în care este stocat : _Document6936_VT6954
Nu există înregistrări
Guid-uri
- Guid Catalog Id
- Configurație : e5437b9d-367d-4422-8e11-64ccbca50788
- Bază de date : 0x8E1164CCBCA507884422367DE5437B9D
Câmpuri
Detaliere Câmpuri
Câmpul ParentRef
- Nume Câmp în baza de date : _Document6936_IDRRef
- Descriere Câmp : Referință către înregistrarea părinte
- Tip Câmp : binary
Câmpul KeyField
- Nume Câmp în baza de date : _KeyField
- Descriere Câmp : Câmpul cheie
- Tip Câmp : binary
Câmpul LineNo
- Nume Câmp în baza de date : _LineNo6955
- Descriere Câmp : Numărul liniei
- Tip Câmp : number
Câmpul Действие
Nume Câmp în baza de date : _Fld6956
Descriere Câmp :
Tip Câmp : string
Guid Atribut Id
- Configurație : 7f0d7563-7ae1-4cb1-b067-9d77dd27ebf4
- Bază de date : 0xB0679D77DD27EBF44CB17AE17F0D7563
Câmpul Документ
Nume Câmp în baza de date : _Fld6957
Descriere Câmp :
Tip Câmp : complex
Guid Atribut Id
- Configurație : 12f13a9d-eb0e-4fc7-925e-925abd212923
- Bază de date : 0x925E925ABD2129234FC7EB0E12F13A9D
Exemplu de interogari :
select [Документ_Id] = [ЗаполнениеДвижений].[_Fld6957_RRRef], -- Документ [Документ_RaportReglementat] = [Документ_RaportReglementat].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportReglementat].[_Date_Time]), 104), -- Документ din Rapoarte reglementate [Документ_RaportReglementat_ID] = [Документ_RaportReglementat].[_IDRRef], -- KeyField din Rapoarte reglementate [Документ_ReturDeLaClient] = N'Retur de la client ' + [Документ_ReturDeLaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ReturDeLaClient].[_Date_Time]), 104) , -- Документ din Retur de la client [Документ_ReturDeLaClient_ID] = [Документ_ReturDeLaClient].[_IDRRef], -- KeyField din Retur de la client [Документ_ReturLaFurnizor] = N'Retur la furnizor ' + [Документ_ReturLaFurnizor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ReturLaFurnizor].[_Date_Time]), 104) , -- Документ din Retur la furnizor [Документ_ReturLaFurnizor_ID] = [Документ_ReturLaFurnizor].[_IDRRef], -- KeyField din Retur la furnizor [Документ_Salarii] = N'Calculare salarii sume totale) ' + [Документ_Salarii].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Salarii].[_Date_Time]), 104) , -- Документ din Calculare salarii (sume totale) [Документ_Salarii_ID] = [Документ_Salarii].[_IDRRef], -- KeyField din Calculare salarii (sume totale) [Документ_SchimbareaGraficAnualDeAmortizareMF] = [Документ_SchimbareaGraficAnualDeAmortizareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareaGraficAnualDeAmortizareMF].[_Date_Time]), 104), -- Документ din Schimbare grafic anual de amortizare MF [Документ_SchimbareaGraficAnualDeAmortizareMF_ID] = [Документ_SchimbareaGraficAnualDeAmortizareMF].[_IDRRef], -- KeyField din Schimbare grafic anual de amortizare MF [Документ_SchimbareaParametrilorAmortizariiMF] = [Документ_SchimbareaParametrilorAmortizariiMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareaParametrilorAmortizariiMF].[_Date_Time]), 104), -- Документ din Schimbare parametri de amortizare MF [Документ_SchimbareaParametrilorAmortizariiMF_ID] = [Документ_SchimbareaParametrilorAmortizariiMF].[_IDRRef], -- KeyField din Schimbare parametri de amortizare MF [Документ_SchimbareaStareMF] = [Документ_SchimbareaStareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareaStareMF].[_Date_Time]), 104), -- Документ din Schimbare stare MF [Документ_SchimbareaStareMF_ID] = [Документ_SchimbareaStareMF].[_IDRRef], -- KeyField din Schimbare stare MF [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_Date_Time]), 104), -- Документ din Schimbare metoda de afișare cheltuielilor de amortizare imob necorporale [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale_ID] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_IDRRef], -- KeyField din Schimbare metoda de afișare cheltuielilor de amortizare imob necorporale [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_Date_Time]), 104), -- Документ din Schimbare metoda de afisare cheltuielilor de amortizare MF [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF_ID] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_IDRRef], -- KeyField din Schimbare metoda de afisare cheltuielilor de amortizare MF [Документ_SchimbarePretAmanunt] = [Документ_SchimbarePretAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbarePretAmanunt].[_Date_Time]), 104), -- Документ din Schimbare prețuri cu amănunt [Документ_SchimbarePretAmanunt_ID] = [Документ_SchimbarePretAmanunt].[_IDRRef], -- KeyField din Schimbare prețuri cu amănunt [Документ_SchimbarePretNomenclator] = [Документ_SchimbarePretNomenclator].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbarePretNomenclator].[_Date_Time]), 104), -- Документ din Schimbare prețuri articole [Документ_SchimbarePretNomenclator_ID] = [Документ_SchimbarePretNomenclator].[_IDRRef], -- KeyField din Schimbare prețuri articole [Документ_SchimbarePretNomenclatorPartener] = [Документ_SchimbarePretNomenclatorPartener].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbarePretNomenclatorPartener].[_Date_Time]), 104), -- Документ din Schimbare prețuri partener [Документ_SchimbarePretNomenclatorPartener_ID] = [Документ_SchimbarePretNomenclatorPartener].[_IDRRef], -- KeyField din Schimbare prețuri partener [Документ_Stornare] = [Документ_Stornare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Stornare].[_Date_Time]), 104), -- Документ din Stornare [Документ_Stornare_ID] = [Документ_Stornare].[_IDRRef], -- KeyField din Stornare [Документ_TransferCadreInOrganizatiile] = [Документ_TransferCadreInOrganizatiile].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TransferCadreInOrganizatiile].[_Date_Time]), 104), -- Документ din Decizie de mutare [Документ_TransferCadreInOrganizatiile_ID] = [Документ_TransferCadreInOrganizatiile].[_IDRRef], -- KeyField din Decizie de mutare [Документ_TransferDeMarfuri] = N'Transfer între gestiuni ' + [Документ_TransferDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TransferDeMarfuri].[_Date_Time]), 104) , -- Документ din Transfer între gestiuni [Документ_TransferDeMarfuri_ID] = [Документ_TransferDeMarfuri].[_IDRRef], -- KeyField din Transfer între gestiuni [Документ_TransferMF] = [Документ_TransferMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TransferMF].[_Date_Time]), 104), -- Документ din Transfer MF [Документ_TransferMF_ID] = [Документ_TransferMF].[_IDRRef], -- KeyField din Transfer MF [Документ_TransferUtilajPentruMontare] = [Документ_TransferUtilajPentruMontare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TransferUtilajPentruMontare].[_Date_Time]), 104), -- Документ din Transfer utilaj pentru montare [Документ_TransferUtilajPentruMontare_ID] = [Документ_TransferUtilajPentruMontare].[_IDRRef], -- KeyField din Transfer utilaj pentru montare [Документ_VanzareMarfuriSiServiciiPrestate] = N'Vânzare și servicii prestate ' + [Документ_VanzareMarfuriSiServiciiPrestate].[_Fld2712] + ' ' + [Документ_VanzareMarfuriSiServiciiPrestate].[_Fld2707] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_VanzareMarfuriSiServiciiPrestate].[_Date_Time]), 104) , -- Документ din Vânzare și servicii prestate [Документ_VanzareMarfuriSiServiciiPrestate_ID] = [Документ_VanzareMarfuriSiServiciiPrestate].[_IDRRef], -- KeyField din Vânzare și servicii prestate [Документ_Absente] = [Документ_Absente].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Absente].[_Date_Time]), 104), -- Документ din Absenţe [Документ_Absente_ID] = [Документ_Absente].[_IDRRef], -- KeyField din Absenţe [Документ_AbsenteLaLucru] = [Документ_AbsenteLaLucru].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_AbsenteLaLucru].[_Date_Time]), 104), -- Документ din Absențe la lucru [Документ_AbsenteLaLucru_ID] = [Документ_AbsenteLaLucru].[_IDRRef], -- KeyField din Absențe la lucru [Документ_Asamblare] = N'Asamblare ' + [Документ_Asamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Asamblare].[_Date_Time]), 104) , -- Документ din Asamblare [Документ_Asamblare_ID] = [Документ_Asamblare].[_IDRRef], -- KeyField din Asamblare [Документ_CalculareConcediiDeOdihna] = [Документ_CalculareConcediiDeOdihna].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculareConcediiDeOdihna].[_Date_Time]), 104), -- Документ din Calculare concedii de odihnă [Документ_CalculareConcediiDeOdihna_ID] = [Документ_CalculareConcediiDeOdihna].[_IDRRef], -- KeyField din Calculare concedii de odihnă [Документ_CalculareConcediiMedicale] = [Документ_CalculareConcediiMedicale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculareConcediiMedicale].[_Date_Time]), 104), -- Документ din Concedii medicale [Документ_CalculareConcediiMedicale_ID] = [Документ_CalculareConcediiMedicale].[_IDRRef], -- KeyField din Concedii medicale [Документ_CalculareLaEliberareDinFunctie] = [Документ_CalculareLaEliberareDinFunctie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculareLaEliberareDinFunctie].[_Date_Time]), 104), -- Документ din Calculare la eliberare din functie [Документ_CalculareLaEliberareDinFunctie_ID] = [Документ_CalculareLaEliberareDinFunctie].[_IDRRef], -- KeyField din Calculare la eliberare din functie [Документ_CalculareSalarii] = [Документ_CalculareSalarii].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculareSalarii].[_Date_Time]), 104), -- Документ din Calculare salarii [Документ_CalculareSalarii_ID] = [Документ_CalculareSalarii].[_IDRRef], -- KeyField din Calculare salarii [Документ_ComandaDeviz] = [Документ_ComandaDeviz].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ComandaDeviz].[_Date_Time]), 104), -- Документ din Comanda deviz [Документ_ComandaDeviz_ID] = [Документ_ComandaDeviz].[_IDRRef], -- KeyField din Comanda deviz [Документ_ComandaService] = [Документ_ComandaService].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ComandaService].[_Date_Time]), 104), -- Документ din Comanda service [Документ_ComandaService_ID] = [Документ_ComandaService].[_IDRRef], -- KeyField din Comanda service [Документ_ConcediiDeOdihna] = [Документ_ConcediiDeOdihna].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ConcediiDeOdihna].[_Date_Time]), 104), -- Документ din Concedii de odihnă [Документ_ConcediiDeOdihna_ID] = [Документ_ConcediiDeOdihna].[_IDRRef], -- KeyField din Concedii de odihnă [Документ_CorectareRegistrelorDeAcumulare] = [Документ_CorectareRegistrelorDeAcumulare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectareRegistrelorDeAcumulare].[_Date_Time]), 104), -- Документ din Corectare registrelor de acumulare (nu se utilizează) [Документ_CorectareRegistrelorDeAcumulare_ID] = [Документ_CorectareRegistrelorDeAcumulare].[_IDRRef], -- KeyField din Corectare registrelor de acumulare (nu se utilizează) [Документ_CorectareTimpDeLucruAngajati] = [Документ_CorectareTimpDeLucruAngajati].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectareTimpDeLucruAngajati].[_Date_Time]), 104), -- Документ din Corectare timp de lucru angajaţi [Документ_CorectareTimpDeLucruAngajati_ID] = [Документ_CorectareTimpDeLucruAngajati].[_IDRRef], -- KeyField din Corectare timp de lucru angajaţi [Документ_Deplasari] = [Документ_Deplasari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Deplasari].[_Date_Time]), 104), -- Документ din Deplasări [Документ_Deplasari_ID] = [Документ_Deplasari].[_IDRRef], -- KeyField din Deplasări [Документ_Dezasamblare] = N'Dezasamblare ' + [Документ_Dezasamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Dezasamblare].[_Date_Time]), 104) , -- Документ din Dezasamblare [Документ_Dezasamblare_ID] = [Документ_Dezasamblare].[_IDRRef], -- KeyField din Dezasamblare [Документ_Export] = [Документ_Export].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Export].[_Date_Time]), 104), -- Документ din Export [Документ_Export_ID] = [Документ_Export].[_IDRRef], -- KeyField din Export [Документ_InregistrareIntreruperiInMunca] = [Документ_InregistrareIntreruperiInMunca].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareIntreruperiInMunca].[_Date_Time]), 104), -- Документ din Inregistrare întreruperi în muncă [Документ_InregistrareIntreruperiInMunca_ID] = [Документ_InregistrareIntreruperiInMunca].[_IDRRef], -- KeyField din Inregistrare întreruperi în muncă [Документ_InregistrareRetineriUnici] = [Документ_InregistrareRetineriUnici].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareRetineriUnici].[_Date_Time]), 104), -- Документ din Inregistrare rețineri unici [Документ_InregistrareRetineriUnici_ID] = [Документ_InregistrareRetineriUnici].[_IDRRef], -- KeyField din Inregistrare rețineri unici [Документ_InregistrareSporuriUnici] = [Документ_InregistrareSporuriUnici].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareSporuriUnici].[_Date_Time]), 104), -- Документ din Înregistrare sporuri unici [Документ_InregistrareSporuriUnici_ID] = [Документ_InregistrareSporuriUnici].[_IDRRef], -- KeyField din Înregistrare sporuri unici [Документ_OrdinInAcord] = [Документ_OrdinInAcord].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdinInAcord].[_Date_Time]), 104), -- Документ din Ordin in acord [Документ_OrdinInAcord_ID] = [Документ_OrdinInAcord].[_IDRRef], -- KeyField din Ordin in acord [Документ_PlataOreSuplimentare] = [Документ_PlataOreSuplimentare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_PlataOreSuplimentare].[_Date_Time]), 104), -- Документ din Plata ore suplimentare [Документ_PlataOreSuplimentare_ID] = [Документ_PlataOreSuplimentare].[_IDRRef], -- KeyField din Plata ore suplimentare [Документ_Prime] = [Документ_Prime].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Prime].[_Date_Time]), 104), -- Документ din Prime [Документ_Prime_ID] = [Документ_Prime].[_IDRRef], -- KeyField din Prime [Документ_ReincepereaActivitatii] = [Документ_ReincepereaActivitatii].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ReincepereaActivitatii].[_Date_Time]), 104), -- Документ din Reînceperea activității [Документ_ReincepereaActivitatii_ID] = [Документ_ReincepereaActivitatii].[_IDRRef], -- KeyField din Reînceperea activității [Документ_TitluDeExecutare] = [Документ_TitluDeExecutare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TitluDeExecutare].[_Date_Time]), 104), -- Документ din Titlu de executare [Документ_TitluDeExecutare_ID] = [Документ_TitluDeExecutare].[_IDRRef], -- KeyField din Titlu de executare [Документ_ContractDeMunca] = [Документ_ContractDeMunca].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ContractDeMunca].[_Date_Time]), 104), -- Документ din Contract de muncă [Документ_ContractDeMunca_ID] = [Документ_ContractDeMunca].[_IDRRef], -- KeyField din Contract de muncă [Документ_IntroducereaReduceri] = [Документ_IntroducereaReduceri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaReduceri].[_Date_Time]), 104), -- Документ din Introducerea reduceri [Документ_IntroducereaReduceri_ID] = [Документ_IntroducereaReduceri].[_IDRRef], -- KeyField din Introducerea reduceri [Документ_IntroducereaRetineriPlanificate] = [Документ_IntroducereaRetineriPlanificate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaRetineriPlanificate].[_Date_Time]), 104), -- Документ din Întroducerea rețineri planificate [Документ_IntroducereaRetineriPlanificate_ID] = [Документ_IntroducereaRetineriPlanificate].[_IDRRef], -- KeyField din Întroducerea rețineri planificate [Документ_IntroducereaRetineriSporuriPlanificate] = [Документ_IntroducereaRetineriSporuriPlanificate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaRetineriSporuriPlanificate].[_Date_Time]), 104), -- Документ din Întroducerea rețineri sporuri planificate [Документ_IntroducereaRetineriSporuriPlanificate_ID] = [Документ_IntroducereaRetineriSporuriPlanificate].[_IDRRef], -- KeyField din Întroducerea rețineri sporuri planificate [Документ_IntroducereaSporuriPlanificate] = [Документ_IntroducereaSporuriPlanificate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaSporuriPlanificate].[_Date_Time]), 104), -- Документ din Întroducerea sporuri planificate [Документ_IntroducereaSporuriPlanificate_ID] = [Документ_IntroducereaSporuriPlanificate].[_IDRRef], -- KeyField din Întroducerea sporuri planificate [Документ_RambursareaTicheteDeMasa] = [Документ_RambursareaTicheteDeMasa].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RambursareaTicheteDeMasa].[_Date_Time]), 104), -- Документ din Rambursarea tichete de masă [Документ_RambursareaTicheteDeMasa_ID] = [Документ_RambursareaTicheteDeMasa].[_IDRRef], -- KeyField din Rambursarea tichete de masă [Документ_FiscalizarePlansaDeNumereRegimSpecial] = [Документ_FiscalizarePlansaDeNumereRegimSpecial].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_FiscalizarePlansaDeNumereRegimSpecial].[_Date_Time]), 104), -- Документ din Fiscalizare planșe de numere regim special [Документ_FiscalizarePlansaDeNumereRegimSpecial_ID] = [Документ_FiscalizarePlansaDeNumereRegimSpecial].[_IDRRef], -- KeyField din Fiscalizare planșe de numere regim special [Документ_CasareOI] = [Документ_CasareOI].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CasareOI].[_Date_Time]), 104), -- Документ din Casare obiecte de inventar [Документ_CasareOI_ID] = [Документ_CasareOI].[_IDRRef], -- KeyField din Casare obiecte de inventar [Документ_DareInFolosinteOI] = [Документ_DareInFolosinteOI].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_DareInFolosinteOI].[_Date_Time]), 104), -- Документ din Dare în folosințe obiecte de inventar [Документ_DareInFolosinteOI_ID] = [Документ_DareInFolosinteOI].[_IDRRef], -- KeyField din Dare în folosințe obiecte de inventar [Документ_InregistrareManualaInJurnalDeVanzari] = [Документ_InregistrareManualaInJurnalDeVanzari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareManualaInJurnalDeVanzari].[_Date_Time]), 104), -- Документ din Inregistrare manuală în jurnal de vanzari [Документ_InregistrareManualaInJurnalDeVanzari_ID] = [Документ_InregistrareManualaInJurnalDeVanzari].[_IDRRef], -- KeyField din Inregistrare manuală în jurnal de vanzari [Документ_FoaiePrezenta] = [Документ_FoaiePrezenta].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_FoaiePrezenta].[_Date_Time]), 104), -- Документ din Foaie prezenta [Документ_FoaiePrezenta_ID] = [Документ_FoaiePrezenta].[_IDRRef], -- KeyField din Foaie prezenta [Документ_AprovizionareMarfuriSiServiciiPrimite] = N'Factură achiziție ' + [Документ_AprovizionareMarfuriSiServiciiPrimite].[_Fld629] + ' ' + [Документ_AprovizionareMarfuriSiServiciiPrimite].[_Fld622] + ' din ' + convert(varchar(10), dateadd(year, -2000, [Документ_AprovizionareMarfuriSiServiciiPrimite].[_Fld642]), 104), -- Документ din Aprovizionare și servicii primite [Документ_AprovizionareMarfuriSiServiciiPrimite_ID] = [Документ_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef], -- KeyField din Aprovizionare și servicii primite [Документ_AvizDeIesire] = N'Aviz de ieșire ' + [Документ_AvizDeIesire].[_Fld743] + ' ' + [Документ_AvizDeIesire].[_Fld744] + ' din ' + convert(varchar(10), dateadd(year, -2000, [Документ_AvizDeIesire].[_Date_Time]), 104), -- Документ din Aviz de ieșire [Документ_AvizDeIesire_ID] = [Документ_AvizDeIesire].[_IDRRef], -- KeyField din Aviz de ieșire [Документ_AvizDeIntrare] = N'Aviz de intrare ' + coalesce(nullif(rtrim(ltrim([Документ_AvizDeIntrare].[_Fld805])), '') + ' ', '') + coalesce(nullif(rtrim(ltrim([Документ_AvizDeIntrare].[_Fld800])), ''), [Документ_AvizDeIntrare].[_Number]) + ' din ' + convert(varchar(10), dateadd(year, -2000, [Документ_AvizDeIntrare].[_Date_Time]), 104), -- Документ din Aviz de intrare [Документ_AvizDeIntrare_ID] = [Документ_AvizDeIntrare].[_IDRRef], -- KeyField din Aviz de intrare [Документ_IntroducereSoldurilorInformativeMagazin] = [Документ_IntroducereSoldurilorInformativeMagazin].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereSoldurilorInformativeMagazin].[_Date_Time]), 104), -- Документ din Introducere soldurilor informative magazin [Документ_IntroducereSoldurilorInformativeMagazin_ID] = [Документ_IntroducereSoldurilorInformativeMagazin].[_IDRRef], -- KeyField din Introducere soldurilor informative magazin [Документ_OrdinDeIncasare] = [Документ_OrdinDeIncasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdinDeIncasare].[_Date_Time]), 104), -- Документ din Ordin de incasare [Документ_OrdinDeIncasare_ID] = [Документ_OrdinDeIncasare].[_IDRRef], -- KeyField din Ordin de incasare [Документ_BonDeConsum] = N'Bon de consum ' + [Документ_BonDeConsum].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_BonDeConsum].[_Date_Time]), 104), -- Документ din Bon de consum [Документ_BonDeConsum_ID] = [Документ_BonDeConsum].[_IDRRef], -- KeyField din Bon de consum [Документ_BonFiscal] = N'Bon fiscal ' + [Документ_BonFiscal].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_BonFiscal].[_Date_Time]), 104), -- Документ din Bon fiscal [Документ_BonFiscal_ID] = [Документ_BonFiscal].[_IDRRef], -- KeyField din Bon fiscal [Документ_CalculImpozit] = [Документ_CalculImpozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculImpozit].[_Date_Time]), 104), -- Документ din Calcul impozit [Документ_CalculImpozit_ID] = [Документ_CalculImpozit].[_IDRRef], -- KeyField din Calcul impozit [Документ_CasareImobNecorporale] = [Документ_CasareImobNecorporale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CasareImobNecorporale].[_Date_Time]), 104), -- Документ din Casare imobilizări necorporale [Документ_CasareImobNecorporale_ID] = [Документ_CasareImobNecorporale].[_IDRRef], -- KeyField din Casare imobilizări necorporale [Документ_CasareMF] = [Документ_CasareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CasareMF].[_Date_Time]), 104), -- Документ din Casare MF [Документ_CasareMF_ID] = [Документ_CasareMF].[_IDRRef], -- KeyField din Casare MF [Документ_ReevaluareMF] = [Документ_ReevaluareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ReevaluareMF].[_Date_Time]), 104), -- Документ din Reevaluare MF [Документ_ReevaluareMF_ID] = [Документ_ReevaluareMF].[_IDRRef], -- KeyField din Reevaluare MF [Документ_CheltuieliSuplimentareLaAprovizionare] = [Документ_CheltuieliSuplimentareLaAprovizionare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CheltuieliSuplimentareLaAprovizionare].[_Date_Time]), 104), -- Документ din Cheltuieli suplimentare la aprovizionare [Документ_CheltuieliSuplimentareLaAprovizionare_ID] = [Документ_CheltuieliSuplimentareLaAprovizionare].[_IDRRef], -- KeyField din Cheltuieli suplimentare la aprovizionare [Документ_Compensare] = N'Compensare ' + [Документ_Compensare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Compensare].[_Date_Time]), 104), -- Документ din Compensare [Документ_Compensare_ID] = [Документ_Compensare].[_IDRRef], -- KeyField din Compensare [Документ_InchidereAnalitice] = [Документ_InchidereAnalitice].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InchidereAnalitice].[_Date_Time]), 104), -- Документ din Inchidere analitice [Документ_InchidereAnalitice_ID] = [Документ_InchidereAnalitice].[_IDRRef], -- KeyField din Inchidere analitice [Документ_DecontDeAvans] = [Документ_DecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_DecontDeAvans].[_Date_Time]), 104), -- Документ din Decont de avans [Документ_DecontDeAvans_ID] = [Документ_DecontDeAvans].[_IDRRef], -- KeyField din Decont de avans [Документ_Demisie] = [Документ_Demisie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Demisie].[_Date_Time]), 104), -- Документ din Reziliere contract de muncă [Документ_Demisie_ID] = [Документ_Demisie].[_IDRRef], -- KeyField din Reziliere contract de muncă [Документ_DiminuareStocDeMarfuri] = [Документ_DiminuareStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_DiminuareStocDeMarfuri].[_Date_Time]), 104), -- Документ din Diminuare stoc de articole [Документ_DiminuareStocDeMarfuri_ID] = [Документ_DiminuareStocDeMarfuri].[_IDRRef], -- KeyField din Diminuare stoc de articole [Документ_RegistersEditor] = [Документ_RegistersEditor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RegistersEditor].[_Date_Time]), 104), -- Документ din Corectarea miscarilor registrului [Документ_RegistersEditor_ID] = [Документ_RegistersEditor].[_IDRRef], -- KeyField din Corectarea miscarilor registrului [Документ_CorectieProcurari] = [Документ_CorectieProcurari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectieProcurari].[_Date_Time]), 104), -- Документ din Corecție Aprovizionări [Документ_CorectieProcurari_ID] = [Документ_CorectieProcurari].[_IDRRef], -- KeyField din Corecție Aprovizionări [Документ_CorectieAnaliticiDecontDeAvans] = [Документ_CorectieAnaliticiDecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectieAnaliticiDecontDeAvans].[_Date_Time]), 104), -- Документ din Corectie analitici decont de avans [Документ_CorectieAnaliticiDecontDeAvans_ID] = [Документ_CorectieAnaliticiDecontDeAvans].[_IDRRef], -- KeyField din Corectie analitici decont de avans [Документ_EfecteDePlatit] = [Документ_EfecteDePlatit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_EfecteDePlatit].[_Date_Time]), 104), -- Документ din Efecte de plătit [Документ_EfecteDePlatit_ID] = [Документ_EfecteDePlatit].[_IDRRef], -- KeyField din Efecte de plătit [Документ_EfecteDePrimit] = [Документ_EfecteDePrimit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_EfecteDePrimit].[_Date_Time]), 104), -- Документ din Efecte de primit [Документ_EfecteDePrimit_ID] = [Документ_EfecteDePrimit].[_IDRRef], -- KeyField din Efecte de primit [Документ_ActAditional] = [Документ_ActAditional].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ActAditional].[_Date_Time]), 104), -- Документ din Act adțional la Contract [Документ_ActAditional_ID] = [Документ_ActAditional].[_IDRRef], -- KeyField din Act adțional la Contract [Документ_CorectieAnaliticiRetur] = [Документ_CorectieAnaliticiRetur].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectieAnaliticiRetur].[_Date_Time]), 104), -- Документ din Corectie analitici retur [Документ_CorectieAnaliticiRetur_ID] = [Документ_CorectieAnaliticiRetur].[_IDRRef], -- KeyField din Corectie analitici retur [Документ_ProcesVerbalLivrariAmanunt] = [Документ_ProcesVerbalLivrariAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ProcesVerbalLivrariAmanunt].[_Date_Time]), 104), -- Документ din Proces Verbal de Livrari in Amanunt [Документ_ProcesVerbalLivrariAmanunt_ID] = [Документ_ProcesVerbalLivrariAmanunt].[_IDRRef], -- KeyField din Proces Verbal de Livrari in Amanunt [Документ_ExtrasDeCont] = N'Extras de cont ' + [Документ_ExtrasDeCont].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ExtrasDeCont].[_Date_Time]), 104), -- Документ din Extras de cont [Документ_ExtrasDeCont_ID] = [Документ_ExtrasDeCont].[_IDRRef], -- KeyField din Extras de cont [Документ_Import] = N'Import ' + [Документ_Import].[_Fld1360] + ' ' + [Документ_Import].[_Fld1353] + ' din ' + convert(varchar(10), dateadd(year, -2000, [Документ_Import].[_Date_Time]), 104), -- Документ din Import [Документ_Import_ID] = [Документ_Import].[_IDRRef], -- KeyField din Import [Документ_ComandaClient] = [Документ_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ComandaClient].[_Date_Time]), 104), -- Документ din Comanda client [Документ_ComandaClient_ID] = [Документ_ComandaClient].[_IDRRef], -- KeyField din Comanda client [Документ_Incasare] = N'Dispoziție de încasare ' + [Документ_Incasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Incasare].[_Date_Time]), 104) , -- Документ din Dispoziție de încasare [Документ_Incasare_ID] = [Документ_Incasare].[_IDRRef], -- KeyField din Dispoziție de încasare [Документ_InchidereLunaDeExercitiu] = N'Închidere lună de exercițiu ' + [Документ_InchidereLunaDeExercitiu].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InchidereLunaDeExercitiu].[_Date_Time]), 104) , -- Документ din Închidere lună de exercițiu [Документ_InchidereLunaDeExercitiu_ID] = [Документ_InchidereLunaDeExercitiu].[_IDRRef], -- KeyField din Închidere lună de exercițiu [Документ_InregistrareManualaInJurnalDeCumparari] = [Документ_InregistrareManualaInJurnalDeCumparari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareManualaInJurnalDeCumparari].[_Date_Time]), 104), -- Документ din Inregistrare manuală în jurnal de cumpărări [Документ_InregistrareManualaInJurnalDeCumparari_ID] = [Документ_InregistrareManualaInJurnalDeCumparari].[_IDRRef], -- KeyField din Inregistrare manuală în jurnal de cumpărări [Документ_IncasareCard] = [Документ_IncasareCard].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IncasareCard].[_Date_Time]), 104), -- Документ din Incasare card [Документ_IncasareCard_ID] = [Документ_IncasareCard].[_IDRRef], -- KeyField din Incasare card [Документ_IntroducereaSoldurilor] = [Документ_IntroducereaSoldurilor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaSoldurilor].[_Date_Time]), 104), -- Документ din Introducere solduri [Документ_IntroducereaSoldurilor_ID] = [Документ_IntroducereaSoldurilor].[_IDRRef], -- KeyField din Introducere solduri [Документ_IntroducereaSoldurilorAmanunt] = [Документ_IntroducereaSoldurilorAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaSoldurilorAmanunt].[_Date_Time]), 104), -- Документ din Introducere solduri amănunt [Документ_IntroducereaSoldurilorAmanunt_ID] = [Документ_IntroducereaSoldurilorAmanunt].[_IDRRef], -- KeyField din Introducere solduri amănunt [Документ_IntroducereSolduriInitialeMF] = [Документ_IntroducereSolduriInitialeMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereSolduriInitialeMF].[_Date_Time]), 104), -- Документ din Introducere solduri inițiale MF [Документ_IntroducereSolduriInitialeMF_ID] = [Документ_IntroducereSolduriInitialeMF].[_IDRRef], -- KeyField din Introducere solduri inițiale MF [Документ_InventariereMarfuriInDepozit] = [Документ_InventariereMarfuriInDepozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InventariereMarfuriInDepozit].[_Date_Time]), 104), -- Документ din Inventariere articole [Документ_InventariereMarfuriInDepozit_ID] = [Документ_InventariereMarfuriInDepozit].[_IDRRef], -- KeyField din Inventariere articole [Документ_InventariereMF] = [Документ_InventariereMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InventariereMF].[_Date_Time]), 104), -- Документ din Inventariere MF [Документ_InventariereMF_ID] = [Документ_InventariereMF].[_IDRRef], -- KeyField din Inventariere MF [Документ_InventariereProductieNeterminata] = [Документ_InventariereProductieNeterminata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InventariereProductieNeterminata].[_Date_Time]), 104), -- Документ din Inventariere producție neterminată [Документ_InventariereProductieNeterminata_ID] = [Документ_InventariereProductieNeterminata].[_IDRRef], -- KeyField din Inventariere producție neterminată [Документ_MarireStocDeMarfuri] = [Документ_MarireStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_MarireStocDeMarfuri].[_Date_Time]), 104), -- Документ din Mărire stoc de articole [Документ_MarireStocDeMarfuri_ID] = [Документ_MarireStocDeMarfuri].[_IDRRef], -- KeyField din Mărire stoc de articole [Документ_ModernizareMF] = [Документ_ModernizareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ModernizareMF].[_Date_Time]), 104), -- Документ din Modernizare MF [Документ_ModernizareMF_ID] = [Документ_ModernizareMF].[_IDRRef], -- KeyField din Modernizare MF [Документ_NotaDeConfirmareSoldPartener] = [Документ_NotaDeConfirmareSoldPartener].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_NotaDeConfirmareSoldPartener].[_Date_Time]), 104), -- Документ din Notă de confirmare [Документ_NotaDeConfirmareSoldPartener_ID] = [Документ_NotaDeConfirmareSoldPartener].[_IDRRef], -- KeyField din Notă de confirmare [Документ_Operatia] = N'Operație contabilă ' + [Документ_Operatia].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Operatia].[_Date_Time]), 104) , -- Документ din Operație contabilă [Документ_Operatia_ID] = [Документ_Operatia].[_IDRRef], -- KeyField din Operație contabilă [Документ_OrdinDeAngajare] = [Документ_OrdinDeAngajare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdinDeAngajare].[_Date_Time]), 104), -- Документ din Contract de angajare [Документ_OrdinDeAngajare_ID] = [Документ_OrdinDeAngajare].[_IDRRef], -- KeyField din Contract de angajare [Документ_OrdinDePlata] = [Документ_OrdinDePlata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdinDePlata].[_Date_Time]), 104), -- Документ din Ordin de plată [Документ_OrdinDePlata_ID] = [Документ_OrdinDePlata].[_IDRRef], -- KeyField din Ordin de plată [Документ_OrdineaDeInchidereDepartamente] = [Документ_OrdineaDeInchidereDepartamente].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdineaDeInchidereDepartamente].[_Date_Time]), 104), -- Документ din Ordinea de închidere a departamentelor [Документ_OrdineaDeInchidereDepartamente_ID] = [Документ_OrdineaDeInchidereDepartamente].[_IDRRef], -- KeyField din Ordinea de închidere a departamentelor [Документ_Partida] = [Документ_Partida].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Partida].[_Date_Time]), 104), -- Документ din Partida de mărfuri [Документ_Partida_ID] = [Документ_Partida].[_IDRRef], -- KeyField din Partida de mărfuri [Документ_Plata] = N'Dispoziție de plată ' + [Документ_Plata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Plata].[_Date_Time]), 104) , -- Документ din Dispoziție de plată [Документ_Plata_ID] = [Документ_Plata].[_IDRRef], -- KeyField din Dispoziție de plată [Документ_ProformaPentruClient] = [Документ_ProformaPentruClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ProformaPentruClient].[_Date_Time]), 104), -- Документ din Proforma client [Документ_ProformaPentruClient_ID] = [Документ_ProformaPentruClient].[_IDRRef], -- KeyField din Proforma client [Документ_PunereaInEvidentaImobilizariNecorporale] = [Документ_PunereaInEvidentaImobilizariNecorporale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_PunereaInEvidentaImobilizariNecorporale].[_Date_Time]), 104), -- Документ din Punere în evidență imobilizări necorporale [Документ_PunereaInEvidentaImobilizariNecorporale_ID] = [Документ_PunereaInEvidentaImobilizariNecorporale].[_IDRRef], -- KeyField din Punere în evidență imobilizări necorporale [Документ_PunereaInEvidentaMF] = [Документ_PunereaInEvidentaMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_PunereaInEvidentaMF].[_Date_Time]), 104), -- Документ din Punere în evidență MF [Документ_PunereaInEvidentaMF_ID] = [Документ_PunereaInEvidentaMF].[_IDRRef], -- KeyField din Punere în evidență MF [Документ_RapoarteReglementateExportate] = [Документ_RapoarteReglementateExportate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RapoarteReglementateExportate].[_Date_Time]), 104), -- Документ din Rapoarte reglementate descărcate [Документ_RapoarteReglementateExportate_ID] = [Документ_RapoarteReglementateExportate].[_IDRRef], -- KeyField din Rapoarte reglementate descărcate [Документ_RaportComisionarDespreVanzari] = [Документ_RaportComisionarDespreVanzari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportComisionarDespreVanzari].[_Date_Time]), 104), -- Документ din Raport comisionar despre vânzări [Документ_RaportComisionarDespreVanzari_ID] = [Документ_RaportComisionarDespreVanzari].[_IDRRef], -- KeyField din Raport comisionar despre vânzări [Документ_RaportComitentDespreVanzari] = [Документ_RaportComitentDespreVanzari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportComitentDespreVanzari].[_Date_Time]), 104), -- Документ din Raport comitent despre vanzari [Документ_RaportComitentDespreVanzari_ID] = [Документ_RaportComitentDespreVanzari].[_IDRRef], -- KeyField din Raport comitent despre vanzari [Документ_RaportDeProductie] = [Документ_RaportDeProductie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportDeProductie].[_Date_Time]), 104), -- Документ din Raport de producție [Документ_RaportDeProductie_ID] = [Документ_RaportDeProductie].[_IDRRef], -- KeyField din Raport de producție [Документ_RaportDeVanzariCuAmanunt] = N'Raport de vânzări cu amănunt ' + [Документ_RaportDeVanzariCuAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportDeVanzariCuAmanunt].[_Date_Time]), 104) , -- Документ din Raport de vânzări cu amănunt [Документ_RaportDeVanzariCuAmanunt_ID] = [Документ_RaportDeVanzariCuAmanunt].[_IDRRef], -- KeyField din Raport de vânzări cu amănunt [ЗаполнениеДвижений].* from [flax].[dbo].[_Document6936_VT6954] as [ЗаполнениеДвижений] left join [flax].[dbo].[_Document100] as [Документ_RaportReglementat] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000064 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportReglementat].[_IDRRef]) left join [flax].[dbo].[_Document101] as [Документ_ReturDeLaClient] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000065 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ReturDeLaClient].[_IDRRef]) left join [flax].[dbo].[_Document102] as [Документ_ReturLaFurnizor] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000066 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ReturLaFurnizor].[_IDRRef]) left join [flax].[dbo].[_Document103] as [Документ_Salarii] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000067 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Salarii].[_IDRRef]) left join [flax].[dbo].[_Document104] as [Документ_SchimbareaGraficAnualDeAmortizareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000068 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareaGraficAnualDeAmortizareMF].[_IDRRef]) left join [flax].[dbo].[_Document105] as [Документ_SchimbareaParametrilorAmortizariiMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000069 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareaParametrilorAmortizariiMF].[_IDRRef]) left join [flax].[dbo].[_Document106] as [Документ_SchimbareaStareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareaStareMF].[_IDRRef]) left join [flax].[dbo].[_Document107] as [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document108] as [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_IDRRef]) left join [flax].[dbo].[_Document109] as [Документ_SchimbarePretAmanunt] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbarePretAmanunt].[_IDRRef]) left join [flax].[dbo].[_Document110] as [Документ_SchimbarePretNomenclator] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbarePretNomenclator].[_IDRRef]) left join [flax].[dbo].[_Document111] as [Документ_SchimbarePretNomenclatorPartener] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbarePretNomenclatorPartener].[_IDRRef]) left join [flax].[dbo].[_Document112] as [Документ_Stornare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000070 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Stornare].[_IDRRef]) left join [flax].[dbo].[_Document113] as [Документ_TransferCadreInOrganizatiile] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000071 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TransferCadreInOrganizatiile].[_IDRRef]) left join [flax].[dbo].[_Document114] as [Документ_TransferDeMarfuri] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000072 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TransferDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document115] as [Документ_TransferMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000073 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TransferMF].[_IDRRef]) left join [flax].[dbo].[_Document116] as [Документ_TransferUtilajPentruMontare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000074 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TransferUtilajPentruMontare].[_IDRRef]) left join [flax].[dbo].[_Document117] as [Документ_VanzareMarfuriSiServiciiPrestate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000075 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_VanzareMarfuriSiServiciiPrestate].[_IDRRef]) left join [flax].[dbo].[_Document3363] as [Документ_Absente] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D23 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Absente].[_IDRRef]) left join [flax].[dbo].[_Document3364] as [Документ_AbsenteLaLucru] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D24 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_AbsenteLaLucru].[_IDRRef]) left join [flax].[dbo].[_Document3365] as [Документ_Asamblare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D25 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Asamblare].[_IDRRef]) left join [flax].[dbo].[_Document3366] as [Документ_CalculareConcediiDeOdihna] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D26 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculareConcediiDeOdihna].[_IDRRef]) left join [flax].[dbo].[_Document3367] as [Документ_CalculareConcediiMedicale] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D27 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculareConcediiMedicale].[_IDRRef]) left join [flax].[dbo].[_Document3369] as [Документ_CalculareLaEliberareDinFunctie] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D29 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculareLaEliberareDinFunctie].[_IDRRef]) left join [flax].[dbo].[_Document3370] as [Документ_CalculareSalarii] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculareSalarii].[_IDRRef]) left join [flax].[dbo].[_Document3371] as [Документ_ComandaDeviz] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ComandaDeviz].[_IDRRef]) left join [flax].[dbo].[_Document3372] as [Документ_ComandaService] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ComandaService].[_IDRRef]) left join [flax].[dbo].[_Document3373] as [Документ_ConcediiDeOdihna] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ConcediiDeOdihna].[_IDRRef]) left join [flax].[dbo].[_Document3374] as [Документ_CorectareRegistrelorDeAcumulare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectareRegistrelorDeAcumulare].[_IDRRef]) left join [flax].[dbo].[_Document3375] as [Документ_CorectareTimpDeLucruAngajati] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectareTimpDeLucruAngajati].[_IDRRef]) left join [flax].[dbo].[_Document3376] as [Документ_Deplasari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D30 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Deplasari].[_IDRRef]) left join [flax].[dbo].[_Document3377] as [Документ_Dezasamblare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D31 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Dezasamblare].[_IDRRef]) left join [flax].[dbo].[_Document3378] as [Документ_Export] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D32 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Export].[_IDRRef]) left join [flax].[dbo].[_Document3379] as [Документ_InregistrareIntreruperiInMunca] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D33 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareIntreruperiInMunca].[_IDRRef]) left join [flax].[dbo].[_Document3380] as [Документ_InregistrareRetineriUnici] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D34 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareRetineriUnici].[_IDRRef]) left join [flax].[dbo].[_Document3381] as [Документ_InregistrareSporuriUnici] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D35 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareSporuriUnici].[_IDRRef]) left join [flax].[dbo].[_Document3382] as [Документ_OrdinInAcord] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D36 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdinInAcord].[_IDRRef]) left join [flax].[dbo].[_Document3383] as [Документ_PlataOreSuplimentare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D37 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_PlataOreSuplimentare].[_IDRRef]) left join [flax].[dbo].[_Document3386] as [Документ_Prime] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D3A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Prime].[_IDRRef]) left join [flax].[dbo].[_Document3387] as [Документ_ReincepereaActivitatii] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D3B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ReincepereaActivitatii].[_IDRRef]) left join [flax].[dbo].[_Document3388] as [Документ_TitluDeExecutare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D3C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TitluDeExecutare].[_IDRRef]) left join [flax].[dbo].[_Document4656] as [Документ_ContractDeMunca] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001230 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ContractDeMunca].[_IDRRef]) left join [flax].[dbo].[_Document4657] as [Документ_IntroducereaReduceri] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001231 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaReduceri].[_IDRRef]) left join [flax].[dbo].[_Document4658] as [Документ_IntroducereaRetineriPlanificate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001232 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaRetineriPlanificate].[_IDRRef]) left join [flax].[dbo].[_Document4659] as [Документ_IntroducereaRetineriSporuriPlanificate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001233 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaRetineriSporuriPlanificate].[_IDRRef]) left join [flax].[dbo].[_Document4660] as [Документ_IntroducereaSporuriPlanificate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001234 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaSporuriPlanificate].[_IDRRef]) left join [flax].[dbo].[_Document4661] as [Документ_RambursareaTicheteDeMasa] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001235 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RambursareaTicheteDeMasa].[_IDRRef]) left join [flax].[dbo].[_Document5212] as [Документ_FiscalizarePlansaDeNumereRegimSpecial] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000145C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_FiscalizarePlansaDeNumereRegimSpecial].[_IDRRef]) left join [flax].[dbo].[_Document5338] as [Документ_CasareOI] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000014DA and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CasareOI].[_IDRRef]) left join [flax].[dbo].[_Document5339] as [Документ_DareInFolosinteOI] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000014DB and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_DareInFolosinteOI].[_IDRRef]) left join [flax].[dbo].[_Document5340] as [Документ_InregistrareManualaInJurnalDeVanzari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000014DC and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareManualaInJurnalDeVanzari].[_IDRRef]) left join [flax].[dbo].[_Document5438] as [Документ_FoaiePrezenta] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000153E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_FoaiePrezenta].[_IDRRef]) left join [flax].[dbo].[_Document56] as [Документ_AprovizionareMarfuriSiServiciiPrimite] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000038 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef]) left join [flax].[dbo].[_Document57] as [Документ_AvizDeIesire] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000039 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_AvizDeIesire].[_IDRRef]) left join [flax].[dbo].[_Document58] as [Документ_AvizDeIntrare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_AvizDeIntrare].[_IDRRef]) left join [flax].[dbo].[_Document5860] as [Документ_IntroducereSoldurilorInformativeMagazin] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000016E4 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereSoldurilorInformativeMagazin].[_IDRRef]) left join [flax].[dbo].[_Document5861] as [Документ_OrdinDeIncasare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000016E5 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdinDeIncasare].[_IDRRef]) left join [flax].[dbo].[_Document59] as [Документ_BonDeConsum] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_BonDeConsum].[_IDRRef]) left join [flax].[dbo].[_Document60] as [Документ_BonFiscal] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_BonFiscal].[_IDRRef]) left join [flax].[dbo].[_Document61] as [Документ_CalculImpozit] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculImpozit].[_IDRRef]) left join [flax].[dbo].[_Document62] as [Документ_CasareImobNecorporale] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CasareImobNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document63] as [Документ_CasareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CasareMF].[_IDRRef]) left join [flax].[dbo].[_Document6336] as [Документ_ReevaluareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000018C0 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ReevaluareMF].[_IDRRef]) left join [flax].[dbo].[_Document64] as [Документ_CheltuieliSuplimentareLaAprovizionare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000040 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CheltuieliSuplimentareLaAprovizionare].[_IDRRef]) left join [flax].[dbo].[_Document65] as [Документ_Compensare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000041 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Compensare].[_IDRRef]) left join [flax].[dbo].[_Document6640] as [Документ_InchidereAnalitice] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000019F0 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InchidereAnalitice].[_IDRRef]) left join [flax].[dbo].[_Document67] as [Документ_DecontDeAvans] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000043 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_DecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document68] as [Документ_Demisie] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000044 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Demisie].[_IDRRef]) left join [flax].[dbo].[_Document69] as [Документ_DiminuareStocDeMarfuri] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000045 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_DiminuareStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document6936] as [Документ_RegistersEditor] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001B18 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RegistersEditor].[_IDRRef]) left join [flax].[dbo].[_Document6988] as [Документ_CorectieProcurari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001B4C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectieProcurari].[_IDRRef]) left join [flax].[dbo].[_Document6989] as [Документ_CorectieAnaliticiDecontDeAvans] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001B4D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectieAnaliticiDecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document70] as [Документ_EfecteDePlatit] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000046 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_EfecteDePlatit].[_IDRRef]) left join [flax].[dbo].[_Document71] as [Документ_EfecteDePrimit] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000047 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_EfecteDePrimit].[_IDRRef]) left join [flax].[dbo].[_Document7108] as [Документ_ActAditional] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001BC4 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ActAditional].[_IDRRef]) left join [flax].[dbo].[_Document7109] as [Документ_CorectieAnaliticiRetur] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001BC5 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectieAnaliticiRetur].[_IDRRef]) left join [flax].[dbo].[_Document7110] as [Документ_ProcesVerbalLivrariAmanunt] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001BC6 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ProcesVerbalLivrariAmanunt].[_IDRRef]) left join [flax].[dbo].[_Document72] as [Документ_ExtrasDeCont] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000048 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ExtrasDeCont].[_IDRRef]) left join [flax].[dbo].[_Document73] as [Документ_Import] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000049 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Import].[_IDRRef]) left join [flax].[dbo].[_Document7382] as [Документ_ComandaClient] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001CD6 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ComandaClient].[_IDRRef]) left join [flax].[dbo].[_Document74] as [Документ_Incasare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Incasare].[_IDRRef]) left join [flax].[dbo].[_Document75] as [Документ_InchidereLunaDeExercitiu] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InchidereLunaDeExercitiu].[_IDRRef]) left join [flax].[dbo].[_Document76] as [Документ_InregistrareManualaInJurnalDeCumparari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareManualaInJurnalDeCumparari].[_IDRRef]) left join [flax].[dbo].[_Document7633] as [Документ_IncasareCard] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001DD1 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IncasareCard].[_IDRRef]) left join [flax].[dbo].[_Document77] as [Документ_IntroducereaSoldurilor] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaSoldurilor].[_IDRRef]) left join [flax].[dbo].[_Document78] as [Документ_IntroducereaSoldurilorAmanunt] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaSoldurilorAmanunt].[_IDRRef]) left join [flax].[dbo].[_Document79] as [Документ_IntroducereSolduriInitialeMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereSolduriInitialeMF].[_IDRRef]) left join [flax].[dbo].[_Document80] as [Документ_InventariereMarfuriInDepozit] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000050 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InventariereMarfuriInDepozit].[_IDRRef]) left join [flax].[dbo].[_Document81] as [Документ_InventariereMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000051 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InventariereMF].[_IDRRef]) left join [flax].[dbo].[_Document82] as [Документ_InventariereProductieNeterminata] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000052 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InventariereProductieNeterminata].[_IDRRef]) left join [flax].[dbo].[_Document83] as [Документ_MarireStocDeMarfuri] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000053 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_MarireStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document84] as [Документ_ModernizareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000054 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ModernizareMF].[_IDRRef]) left join [flax].[dbo].[_Document85] as [Документ_NotaDeConfirmareSoldPartener] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000055 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_NotaDeConfirmareSoldPartener].[_IDRRef]) left join [flax].[dbo].[_Document86] as [Документ_Operatia] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000056 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Operatia].[_IDRRef]) left join [flax].[dbo].[_Document87] as [Документ_OrdinDeAngajare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000057 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdinDeAngajare].[_IDRRef]) left join [flax].[dbo].[_Document88] as [Документ_OrdinDePlata] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000058 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdinDePlata].[_IDRRef]) left join [flax].[dbo].[_Document89] as [Документ_OrdineaDeInchidereDepartamente] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000059 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdineaDeInchidereDepartamente].[_IDRRef]) left join [flax].[dbo].[_Document90] as [Документ_Partida] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Partida].[_IDRRef]) left join [flax].[dbo].[_Document91] as [Документ_Plata] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Plata].[_IDRRef]) left join [flax].[dbo].[_Document92] as [Документ_ProformaPentruClient] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ProformaPentruClient].[_IDRRef]) left join [flax].[dbo].[_Document93] as [Документ_PunereaInEvidentaImobilizariNecorporale] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_PunereaInEvidentaImobilizariNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document94] as [Документ_PunereaInEvidentaMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_PunereaInEvidentaMF].[_IDRRef]) left join [flax].[dbo].[_Document95] as [Документ_RapoarteReglementateExportate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RapoarteReglementateExportate].[_IDRRef]) left join [flax].[dbo].[_Document96] as [Документ_RaportComisionarDespreVanzari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000060 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportComisionarDespreVanzari].[_IDRRef]) left join [flax].[dbo].[_Document97] as [Документ_RaportComitentDespreVanzari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000061 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportComitentDespreVanzari].[_IDRRef]) left join [flax].[dbo].[_Document98] as [Документ_RaportDeProductie] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000062 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportDeProductie].[_IDRRef]) left join [flax].[dbo].[_Document99] as [Документ_RaportDeVanzariCuAmanunt] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000063 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportDeVanzariCuAmanunt].[_IDRRef])
Câmpul Примечание
Nume Câmp în baza de date : _Fld6958
Descriere Câmp :
Tip Câmp : string
Guid Atribut Id
- Configurație : 4bb87f56-cf7d-42c9-b019-ea54e501a0e4
- Bază de date : 0xB019EA54E501A0E442C9CF7D4BB87F56
Full Sql Select
Exemplu de apel pentru obiectul curent din baza sursa
select [ParentRef] = [ЗаполнениеДвижений].[_Document6936_IDRRef], -- Referință către înregistrarea părinte [KeyField] = [ЗаполнениеДвижений].[_KeyField], -- Câmpul cheie [LineNo] = [ЗаполнениеДвижений].[_LineNo6955], -- Numărul liniei [Действие] = [ЗаполнениеДвижений].[_Fld6956], -- Действие [Документ_Id] = [ЗаполнениеДвижений].[_Fld6957_RRRef], -- Документ [Документ_RaportReglementat] = [Документ_RaportReglementat].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportReglementat].[_Date_Time]), 104), -- Документ din Rapoarte reglementate [Документ_RaportReglementat_ID] = [Документ_RaportReglementat].[_IDRRef], -- KeyField din Rapoarte reglementate [Документ_ReturDeLaClient] = N'Retur de la client ' + [Документ_ReturDeLaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ReturDeLaClient].[_Date_Time]), 104) , -- Документ din Retur de la client [Документ_ReturDeLaClient_ID] = [Документ_ReturDeLaClient].[_IDRRef], -- KeyField din Retur de la client [Документ_ReturLaFurnizor] = N'Retur la furnizor ' + [Документ_ReturLaFurnizor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ReturLaFurnizor].[_Date_Time]), 104) , -- Документ din Retur la furnizor [Документ_ReturLaFurnizor_ID] = [Документ_ReturLaFurnizor].[_IDRRef], -- KeyField din Retur la furnizor [Документ_Salarii] = N'Calculare salarii sume totale) ' + [Документ_Salarii].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Salarii].[_Date_Time]), 104) , -- Документ din Calculare salarii (sume totale) [Документ_Salarii_ID] = [Документ_Salarii].[_IDRRef], -- KeyField din Calculare salarii (sume totale) [Документ_SchimbareaGraficAnualDeAmortizareMF] = [Документ_SchimbareaGraficAnualDeAmortizareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareaGraficAnualDeAmortizareMF].[_Date_Time]), 104), -- Документ din Schimbare grafic anual de amortizare MF [Документ_SchimbareaGraficAnualDeAmortizareMF_ID] = [Документ_SchimbareaGraficAnualDeAmortizareMF].[_IDRRef], -- KeyField din Schimbare grafic anual de amortizare MF [Документ_SchimbareaParametrilorAmortizariiMF] = [Документ_SchimbareaParametrilorAmortizariiMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareaParametrilorAmortizariiMF].[_Date_Time]), 104), -- Документ din Schimbare parametri de amortizare MF [Документ_SchimbareaParametrilorAmortizariiMF_ID] = [Документ_SchimbareaParametrilorAmortizariiMF].[_IDRRef], -- KeyField din Schimbare parametri de amortizare MF [Документ_SchimbareaStareMF] = [Документ_SchimbareaStareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareaStareMF].[_Date_Time]), 104), -- Документ din Schimbare stare MF [Документ_SchimbareaStareMF_ID] = [Документ_SchimbareaStareMF].[_IDRRef], -- KeyField din Schimbare stare MF [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_Date_Time]), 104), -- Документ din Schimbare metoda de afișare cheltuielilor de amortizare imob necorporale [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale_ID] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_IDRRef], -- KeyField din Schimbare metoda de afișare cheltuielilor de amortizare imob necorporale [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_Date_Time]), 104), -- Документ din Schimbare metoda de afisare cheltuielilor de amortizare MF [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF_ID] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_IDRRef], -- KeyField din Schimbare metoda de afisare cheltuielilor de amortizare MF [Документ_SchimbarePretAmanunt] = [Документ_SchimbarePretAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbarePretAmanunt].[_Date_Time]), 104), -- Документ din Schimbare prețuri cu amănunt [Документ_SchimbarePretAmanunt_ID] = [Документ_SchimbarePretAmanunt].[_IDRRef], -- KeyField din Schimbare prețuri cu amănunt [Документ_SchimbarePretNomenclator] = [Документ_SchimbarePretNomenclator].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbarePretNomenclator].[_Date_Time]), 104), -- Документ din Schimbare prețuri articole [Документ_SchimbarePretNomenclator_ID] = [Документ_SchimbarePretNomenclator].[_IDRRef], -- KeyField din Schimbare prețuri articole [Документ_SchimbarePretNomenclatorPartener] = [Документ_SchimbarePretNomenclatorPartener].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_SchimbarePretNomenclatorPartener].[_Date_Time]), 104), -- Документ din Schimbare prețuri partener [Документ_SchimbarePretNomenclatorPartener_ID] = [Документ_SchimbarePretNomenclatorPartener].[_IDRRef], -- KeyField din Schimbare prețuri partener [Документ_Stornare] = [Документ_Stornare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Stornare].[_Date_Time]), 104), -- Документ din Stornare [Документ_Stornare_ID] = [Документ_Stornare].[_IDRRef], -- KeyField din Stornare [Документ_TransferCadreInOrganizatiile] = [Документ_TransferCadreInOrganizatiile].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TransferCadreInOrganizatiile].[_Date_Time]), 104), -- Документ din Decizie de mutare [Документ_TransferCadreInOrganizatiile_ID] = [Документ_TransferCadreInOrganizatiile].[_IDRRef], -- KeyField din Decizie de mutare [Документ_TransferDeMarfuri] = N'Transfer între gestiuni ' + [Документ_TransferDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TransferDeMarfuri].[_Date_Time]), 104) , -- Документ din Transfer între gestiuni [Документ_TransferDeMarfuri_ID] = [Документ_TransferDeMarfuri].[_IDRRef], -- KeyField din Transfer între gestiuni [Документ_TransferMF] = [Документ_TransferMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TransferMF].[_Date_Time]), 104), -- Документ din Transfer MF [Документ_TransferMF_ID] = [Документ_TransferMF].[_IDRRef], -- KeyField din Transfer MF [Документ_TransferUtilajPentruMontare] = [Документ_TransferUtilajPentruMontare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TransferUtilajPentruMontare].[_Date_Time]), 104), -- Документ din Transfer utilaj pentru montare [Документ_TransferUtilajPentruMontare_ID] = [Документ_TransferUtilajPentruMontare].[_IDRRef], -- KeyField din Transfer utilaj pentru montare [Документ_VanzareMarfuriSiServiciiPrestate] = N'Vânzare și servicii prestate ' + [Документ_VanzareMarfuriSiServiciiPrestate].[_Fld2712] + ' ' + [Документ_VanzareMarfuriSiServiciiPrestate].[_Fld2707] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_VanzareMarfuriSiServiciiPrestate].[_Date_Time]), 104) , -- Документ din Vânzare și servicii prestate [Документ_VanzareMarfuriSiServiciiPrestate_ID] = [Документ_VanzareMarfuriSiServiciiPrestate].[_IDRRef], -- KeyField din Vânzare și servicii prestate [Документ_Absente] = [Документ_Absente].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Absente].[_Date_Time]), 104), -- Документ din Absenţe [Документ_Absente_ID] = [Документ_Absente].[_IDRRef], -- KeyField din Absenţe [Документ_AbsenteLaLucru] = [Документ_AbsenteLaLucru].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_AbsenteLaLucru].[_Date_Time]), 104), -- Документ din Absențe la lucru [Документ_AbsenteLaLucru_ID] = [Документ_AbsenteLaLucru].[_IDRRef], -- KeyField din Absențe la lucru [Документ_Asamblare] = N'Asamblare ' + [Документ_Asamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Asamblare].[_Date_Time]), 104) , -- Документ din Asamblare [Документ_Asamblare_ID] = [Документ_Asamblare].[_IDRRef], -- KeyField din Asamblare [Документ_CalculareConcediiDeOdihna] = [Документ_CalculareConcediiDeOdihna].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculareConcediiDeOdihna].[_Date_Time]), 104), -- Документ din Calculare concedii de odihnă [Документ_CalculareConcediiDeOdihna_ID] = [Документ_CalculareConcediiDeOdihna].[_IDRRef], -- KeyField din Calculare concedii de odihnă [Документ_CalculareConcediiMedicale] = [Документ_CalculareConcediiMedicale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculareConcediiMedicale].[_Date_Time]), 104), -- Документ din Concedii medicale [Документ_CalculareConcediiMedicale_ID] = [Документ_CalculareConcediiMedicale].[_IDRRef], -- KeyField din Concedii medicale [Документ_CalculareLaEliberareDinFunctie] = [Документ_CalculareLaEliberareDinFunctie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculareLaEliberareDinFunctie].[_Date_Time]), 104), -- Документ din Calculare la eliberare din functie [Документ_CalculareLaEliberareDinFunctie_ID] = [Документ_CalculareLaEliberareDinFunctie].[_IDRRef], -- KeyField din Calculare la eliberare din functie [Документ_CalculareSalarii] = [Документ_CalculareSalarii].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculareSalarii].[_Date_Time]), 104), -- Документ din Calculare salarii [Документ_CalculareSalarii_ID] = [Документ_CalculareSalarii].[_IDRRef], -- KeyField din Calculare salarii [Документ_ComandaDeviz] = [Документ_ComandaDeviz].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ComandaDeviz].[_Date_Time]), 104), -- Документ din Comanda deviz [Документ_ComandaDeviz_ID] = [Документ_ComandaDeviz].[_IDRRef], -- KeyField din Comanda deviz [Документ_ComandaService] = [Документ_ComandaService].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ComandaService].[_Date_Time]), 104), -- Документ din Comanda service [Документ_ComandaService_ID] = [Документ_ComandaService].[_IDRRef], -- KeyField din Comanda service [Документ_ConcediiDeOdihna] = [Документ_ConcediiDeOdihna].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ConcediiDeOdihna].[_Date_Time]), 104), -- Документ din Concedii de odihnă [Документ_ConcediiDeOdihna_ID] = [Документ_ConcediiDeOdihna].[_IDRRef], -- KeyField din Concedii de odihnă [Документ_CorectareRegistrelorDeAcumulare] = [Документ_CorectareRegistrelorDeAcumulare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectareRegistrelorDeAcumulare].[_Date_Time]), 104), -- Документ din Corectare registrelor de acumulare (nu se utilizează) [Документ_CorectareRegistrelorDeAcumulare_ID] = [Документ_CorectareRegistrelorDeAcumulare].[_IDRRef], -- KeyField din Corectare registrelor de acumulare (nu se utilizează) [Документ_CorectareTimpDeLucruAngajati] = [Документ_CorectareTimpDeLucruAngajati].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectareTimpDeLucruAngajati].[_Date_Time]), 104), -- Документ din Corectare timp de lucru angajaţi [Документ_CorectareTimpDeLucruAngajati_ID] = [Документ_CorectareTimpDeLucruAngajati].[_IDRRef], -- KeyField din Corectare timp de lucru angajaţi [Документ_Deplasari] = [Документ_Deplasari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Deplasari].[_Date_Time]), 104), -- Документ din Deplasări [Документ_Deplasari_ID] = [Документ_Deplasari].[_IDRRef], -- KeyField din Deplasări [Документ_Dezasamblare] = N'Dezasamblare ' + [Документ_Dezasamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Dezasamblare].[_Date_Time]), 104) , -- Документ din Dezasamblare [Документ_Dezasamblare_ID] = [Документ_Dezasamblare].[_IDRRef], -- KeyField din Dezasamblare [Документ_Export] = [Документ_Export].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Export].[_Date_Time]), 104), -- Документ din Export [Документ_Export_ID] = [Документ_Export].[_IDRRef], -- KeyField din Export [Документ_InregistrareIntreruperiInMunca] = [Документ_InregistrareIntreruperiInMunca].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareIntreruperiInMunca].[_Date_Time]), 104), -- Документ din Inregistrare întreruperi în muncă [Документ_InregistrareIntreruperiInMunca_ID] = [Документ_InregistrareIntreruperiInMunca].[_IDRRef], -- KeyField din Inregistrare întreruperi în muncă [Документ_InregistrareRetineriUnici] = [Документ_InregistrareRetineriUnici].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareRetineriUnici].[_Date_Time]), 104), -- Документ din Inregistrare rețineri unici [Документ_InregistrareRetineriUnici_ID] = [Документ_InregistrareRetineriUnici].[_IDRRef], -- KeyField din Inregistrare rețineri unici [Документ_InregistrareSporuriUnici] = [Документ_InregistrareSporuriUnici].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareSporuriUnici].[_Date_Time]), 104), -- Документ din Înregistrare sporuri unici [Документ_InregistrareSporuriUnici_ID] = [Документ_InregistrareSporuriUnici].[_IDRRef], -- KeyField din Înregistrare sporuri unici [Документ_OrdinInAcord] = [Документ_OrdinInAcord].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdinInAcord].[_Date_Time]), 104), -- Документ din Ordin in acord [Документ_OrdinInAcord_ID] = [Документ_OrdinInAcord].[_IDRRef], -- KeyField din Ordin in acord [Документ_PlataOreSuplimentare] = [Документ_PlataOreSuplimentare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_PlataOreSuplimentare].[_Date_Time]), 104), -- Документ din Plata ore suplimentare [Документ_PlataOreSuplimentare_ID] = [Документ_PlataOreSuplimentare].[_IDRRef], -- KeyField din Plata ore suplimentare [Документ_Prime] = [Документ_Prime].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Prime].[_Date_Time]), 104), -- Документ din Prime [Документ_Prime_ID] = [Документ_Prime].[_IDRRef], -- KeyField din Prime [Документ_ReincepereaActivitatii] = [Документ_ReincepereaActivitatii].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ReincepereaActivitatii].[_Date_Time]), 104), -- Документ din Reînceperea activității [Документ_ReincepereaActivitatii_ID] = [Документ_ReincepereaActivitatii].[_IDRRef], -- KeyField din Reînceperea activității [Документ_TitluDeExecutare] = [Документ_TitluDeExecutare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_TitluDeExecutare].[_Date_Time]), 104), -- Документ din Titlu de executare [Документ_TitluDeExecutare_ID] = [Документ_TitluDeExecutare].[_IDRRef], -- KeyField din Titlu de executare [Документ_ContractDeMunca] = [Документ_ContractDeMunca].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ContractDeMunca].[_Date_Time]), 104), -- Документ din Contract de muncă [Документ_ContractDeMunca_ID] = [Документ_ContractDeMunca].[_IDRRef], -- KeyField din Contract de muncă [Документ_IntroducereaReduceri] = [Документ_IntroducereaReduceri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaReduceri].[_Date_Time]), 104), -- Документ din Introducerea reduceri [Документ_IntroducereaReduceri_ID] = [Документ_IntroducereaReduceri].[_IDRRef], -- KeyField din Introducerea reduceri [Документ_IntroducereaRetineriPlanificate] = [Документ_IntroducereaRetineriPlanificate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaRetineriPlanificate].[_Date_Time]), 104), -- Документ din Întroducerea rețineri planificate [Документ_IntroducereaRetineriPlanificate_ID] = [Документ_IntroducereaRetineriPlanificate].[_IDRRef], -- KeyField din Întroducerea rețineri planificate [Документ_IntroducereaRetineriSporuriPlanificate] = [Документ_IntroducereaRetineriSporuriPlanificate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaRetineriSporuriPlanificate].[_Date_Time]), 104), -- Документ din Întroducerea rețineri sporuri planificate [Документ_IntroducereaRetineriSporuriPlanificate_ID] = [Документ_IntroducereaRetineriSporuriPlanificate].[_IDRRef], -- KeyField din Întroducerea rețineri sporuri planificate [Документ_IntroducereaSporuriPlanificate] = [Документ_IntroducereaSporuriPlanificate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaSporuriPlanificate].[_Date_Time]), 104), -- Документ din Întroducerea sporuri planificate [Документ_IntroducereaSporuriPlanificate_ID] = [Документ_IntroducereaSporuriPlanificate].[_IDRRef], -- KeyField din Întroducerea sporuri planificate [Документ_RambursareaTicheteDeMasa] = [Документ_RambursareaTicheteDeMasa].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RambursareaTicheteDeMasa].[_Date_Time]), 104), -- Документ din Rambursarea tichete de masă [Документ_RambursareaTicheteDeMasa_ID] = [Документ_RambursareaTicheteDeMasa].[_IDRRef], -- KeyField din Rambursarea tichete de masă [Документ_FiscalizarePlansaDeNumereRegimSpecial] = [Документ_FiscalizarePlansaDeNumereRegimSpecial].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_FiscalizarePlansaDeNumereRegimSpecial].[_Date_Time]), 104), -- Документ din Fiscalizare planșe de numere regim special [Документ_FiscalizarePlansaDeNumereRegimSpecial_ID] = [Документ_FiscalizarePlansaDeNumereRegimSpecial].[_IDRRef], -- KeyField din Fiscalizare planșe de numere regim special [Документ_CasareOI] = [Документ_CasareOI].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CasareOI].[_Date_Time]), 104), -- Документ din Casare obiecte de inventar [Документ_CasareOI_ID] = [Документ_CasareOI].[_IDRRef], -- KeyField din Casare obiecte de inventar [Документ_DareInFolosinteOI] = [Документ_DareInFolosinteOI].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_DareInFolosinteOI].[_Date_Time]), 104), -- Документ din Dare în folosințe obiecte de inventar [Документ_DareInFolosinteOI_ID] = [Документ_DareInFolosinteOI].[_IDRRef], -- KeyField din Dare în folosințe obiecte de inventar [Документ_InregistrareManualaInJurnalDeVanzari] = [Документ_InregistrareManualaInJurnalDeVanzari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareManualaInJurnalDeVanzari].[_Date_Time]), 104), -- Документ din Inregistrare manuală în jurnal de vanzari [Документ_InregistrareManualaInJurnalDeVanzari_ID] = [Документ_InregistrareManualaInJurnalDeVanzari].[_IDRRef], -- KeyField din Inregistrare manuală în jurnal de vanzari [Документ_FoaiePrezenta] = [Документ_FoaiePrezenta].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_FoaiePrezenta].[_Date_Time]), 104), -- Документ din Foaie prezenta [Документ_FoaiePrezenta_ID] = [Документ_FoaiePrezenta].[_IDRRef], -- KeyField din Foaie prezenta [Документ_AprovizionareMarfuriSiServiciiPrimite] = N'Factură achiziție ' + [Документ_AprovizionareMarfuriSiServiciiPrimite].[_Fld629] + ' ' + [Документ_AprovizionareMarfuriSiServiciiPrimite].[_Fld622] + ' din ' + convert(varchar(10), dateadd(year, -2000, [Документ_AprovizionareMarfuriSiServiciiPrimite].[_Fld642]), 104), -- Документ din Aprovizionare și servicii primite [Документ_AprovizionareMarfuriSiServiciiPrimite_ID] = [Документ_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef], -- KeyField din Aprovizionare și servicii primite [Документ_AvizDeIesire] = N'Aviz de ieșire ' + [Документ_AvizDeIesire].[_Fld743] + ' ' + [Документ_AvizDeIesire].[_Fld744] + ' din ' + convert(varchar(10), dateadd(year, -2000, [Документ_AvizDeIesire].[_Date_Time]), 104), -- Документ din Aviz de ieșire [Документ_AvizDeIesire_ID] = [Документ_AvizDeIesire].[_IDRRef], -- KeyField din Aviz de ieșire [Документ_AvizDeIntrare] = N'Aviz de intrare ' + coalesce(nullif(rtrim(ltrim([Документ_AvizDeIntrare].[_Fld805])), '') + ' ', '') + coalesce(nullif(rtrim(ltrim([Документ_AvizDeIntrare].[_Fld800])), ''), [Документ_AvizDeIntrare].[_Number]) + ' din ' + convert(varchar(10), dateadd(year, -2000, [Документ_AvizDeIntrare].[_Date_Time]), 104), -- Документ din Aviz de intrare [Документ_AvizDeIntrare_ID] = [Документ_AvizDeIntrare].[_IDRRef], -- KeyField din Aviz de intrare [Документ_IntroducereSoldurilorInformativeMagazin] = [Документ_IntroducereSoldurilorInformativeMagazin].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereSoldurilorInformativeMagazin].[_Date_Time]), 104), -- Документ din Introducere soldurilor informative magazin [Документ_IntroducereSoldurilorInformativeMagazin_ID] = [Документ_IntroducereSoldurilorInformativeMagazin].[_IDRRef], -- KeyField din Introducere soldurilor informative magazin [Документ_OrdinDeIncasare] = [Документ_OrdinDeIncasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdinDeIncasare].[_Date_Time]), 104), -- Документ din Ordin de incasare [Документ_OrdinDeIncasare_ID] = [Документ_OrdinDeIncasare].[_IDRRef], -- KeyField din Ordin de incasare [Документ_BonDeConsum] = N'Bon de consum ' + [Документ_BonDeConsum].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_BonDeConsum].[_Date_Time]), 104), -- Документ din Bon de consum [Документ_BonDeConsum_ID] = [Документ_BonDeConsum].[_IDRRef], -- KeyField din Bon de consum [Документ_BonFiscal] = N'Bon fiscal ' + [Документ_BonFiscal].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_BonFiscal].[_Date_Time]), 104), -- Документ din Bon fiscal [Документ_BonFiscal_ID] = [Документ_BonFiscal].[_IDRRef], -- KeyField din Bon fiscal [Документ_CalculImpozit] = [Документ_CalculImpozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CalculImpozit].[_Date_Time]), 104), -- Документ din Calcul impozit [Документ_CalculImpozit_ID] = [Документ_CalculImpozit].[_IDRRef], -- KeyField din Calcul impozit [Документ_CasareImobNecorporale] = [Документ_CasareImobNecorporale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CasareImobNecorporale].[_Date_Time]), 104), -- Документ din Casare imobilizări necorporale [Документ_CasareImobNecorporale_ID] = [Документ_CasareImobNecorporale].[_IDRRef], -- KeyField din Casare imobilizări necorporale [Документ_CasareMF] = [Документ_CasareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CasareMF].[_Date_Time]), 104), -- Документ din Casare MF [Документ_CasareMF_ID] = [Документ_CasareMF].[_IDRRef], -- KeyField din Casare MF [Документ_ReevaluareMF] = [Документ_ReevaluareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ReevaluareMF].[_Date_Time]), 104), -- Документ din Reevaluare MF [Документ_ReevaluareMF_ID] = [Документ_ReevaluareMF].[_IDRRef], -- KeyField din Reevaluare MF [Документ_CheltuieliSuplimentareLaAprovizionare] = [Документ_CheltuieliSuplimentareLaAprovizionare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CheltuieliSuplimentareLaAprovizionare].[_Date_Time]), 104), -- Документ din Cheltuieli suplimentare la aprovizionare [Документ_CheltuieliSuplimentareLaAprovizionare_ID] = [Документ_CheltuieliSuplimentareLaAprovizionare].[_IDRRef], -- KeyField din Cheltuieli suplimentare la aprovizionare [Документ_Compensare] = N'Compensare ' + [Документ_Compensare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Compensare].[_Date_Time]), 104), -- Документ din Compensare [Документ_Compensare_ID] = [Документ_Compensare].[_IDRRef], -- KeyField din Compensare [Документ_InchidereAnalitice] = [Документ_InchidereAnalitice].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InchidereAnalitice].[_Date_Time]), 104), -- Документ din Inchidere analitice [Документ_InchidereAnalitice_ID] = [Документ_InchidereAnalitice].[_IDRRef], -- KeyField din Inchidere analitice [Документ_DecontDeAvans] = [Документ_DecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_DecontDeAvans].[_Date_Time]), 104), -- Документ din Decont de avans [Документ_DecontDeAvans_ID] = [Документ_DecontDeAvans].[_IDRRef], -- KeyField din Decont de avans [Документ_Demisie] = [Документ_Demisie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Demisie].[_Date_Time]), 104), -- Документ din Reziliere contract de muncă [Документ_Demisie_ID] = [Документ_Demisie].[_IDRRef], -- KeyField din Reziliere contract de muncă [Документ_DiminuareStocDeMarfuri] = [Документ_DiminuareStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_DiminuareStocDeMarfuri].[_Date_Time]), 104), -- Документ din Diminuare stoc de articole [Документ_DiminuareStocDeMarfuri_ID] = [Документ_DiminuareStocDeMarfuri].[_IDRRef], -- KeyField din Diminuare stoc de articole [Документ_RegistersEditor] = [Документ_RegistersEditor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RegistersEditor].[_Date_Time]), 104), -- Документ din Corectarea miscarilor registrului [Документ_RegistersEditor_ID] = [Документ_RegistersEditor].[_IDRRef], -- KeyField din Corectarea miscarilor registrului [Документ_CorectieProcurari] = [Документ_CorectieProcurari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectieProcurari].[_Date_Time]), 104), -- Документ din Corecție Aprovizionări [Документ_CorectieProcurari_ID] = [Документ_CorectieProcurari].[_IDRRef], -- KeyField din Corecție Aprovizionări [Документ_CorectieAnaliticiDecontDeAvans] = [Документ_CorectieAnaliticiDecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectieAnaliticiDecontDeAvans].[_Date_Time]), 104), -- Документ din Corectie analitici decont de avans [Документ_CorectieAnaliticiDecontDeAvans_ID] = [Документ_CorectieAnaliticiDecontDeAvans].[_IDRRef], -- KeyField din Corectie analitici decont de avans [Документ_EfecteDePlatit] = [Документ_EfecteDePlatit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_EfecteDePlatit].[_Date_Time]), 104), -- Документ din Efecte de plătit [Документ_EfecteDePlatit_ID] = [Документ_EfecteDePlatit].[_IDRRef], -- KeyField din Efecte de plătit [Документ_EfecteDePrimit] = [Документ_EfecteDePrimit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_EfecteDePrimit].[_Date_Time]), 104), -- Документ din Efecte de primit [Документ_EfecteDePrimit_ID] = [Документ_EfecteDePrimit].[_IDRRef], -- KeyField din Efecte de primit [Документ_ActAditional] = [Документ_ActAditional].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ActAditional].[_Date_Time]), 104), -- Документ din Act adțional la Contract [Документ_ActAditional_ID] = [Документ_ActAditional].[_IDRRef], -- KeyField din Act adțional la Contract [Документ_CorectieAnaliticiRetur] = [Документ_CorectieAnaliticiRetur].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_CorectieAnaliticiRetur].[_Date_Time]), 104), -- Документ din Corectie analitici retur [Документ_CorectieAnaliticiRetur_ID] = [Документ_CorectieAnaliticiRetur].[_IDRRef], -- KeyField din Corectie analitici retur [Документ_ProcesVerbalLivrariAmanunt] = [Документ_ProcesVerbalLivrariAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ProcesVerbalLivrariAmanunt].[_Date_Time]), 104), -- Документ din Proces Verbal de Livrari in Amanunt [Документ_ProcesVerbalLivrariAmanunt_ID] = [Документ_ProcesVerbalLivrariAmanunt].[_IDRRef], -- KeyField din Proces Verbal de Livrari in Amanunt [Документ_ExtrasDeCont] = N'Extras de cont ' + [Документ_ExtrasDeCont].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ExtrasDeCont].[_Date_Time]), 104), -- Документ din Extras de cont [Документ_ExtrasDeCont_ID] = [Документ_ExtrasDeCont].[_IDRRef], -- KeyField din Extras de cont [Документ_Import] = N'Import ' + [Документ_Import].[_Fld1360] + ' ' + [Документ_Import].[_Fld1353] + ' din ' + convert(varchar(10), dateadd(year, -2000, [Документ_Import].[_Date_Time]), 104), -- Документ din Import [Документ_Import_ID] = [Документ_Import].[_IDRRef], -- KeyField din Import [Документ_ComandaClient] = [Документ_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ComandaClient].[_Date_Time]), 104), -- Документ din Comanda client [Документ_ComandaClient_ID] = [Документ_ComandaClient].[_IDRRef], -- KeyField din Comanda client [Документ_Incasare] = N'Dispoziție de încasare ' + [Документ_Incasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Incasare].[_Date_Time]), 104) , -- Документ din Dispoziție de încasare [Документ_Incasare_ID] = [Документ_Incasare].[_IDRRef], -- KeyField din Dispoziție de încasare [Документ_InchidereLunaDeExercitiu] = N'Închidere lună de exercițiu ' + [Документ_InchidereLunaDeExercitiu].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InchidereLunaDeExercitiu].[_Date_Time]), 104) , -- Документ din Închidere lună de exercițiu [Документ_InchidereLunaDeExercitiu_ID] = [Документ_InchidereLunaDeExercitiu].[_IDRRef], -- KeyField din Închidere lună de exercițiu [Документ_InregistrareManualaInJurnalDeCumparari] = [Документ_InregistrareManualaInJurnalDeCumparari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InregistrareManualaInJurnalDeCumparari].[_Date_Time]), 104), -- Документ din Inregistrare manuală în jurnal de cumpărări [Документ_InregistrareManualaInJurnalDeCumparari_ID] = [Документ_InregistrareManualaInJurnalDeCumparari].[_IDRRef], -- KeyField din Inregistrare manuală în jurnal de cumpărări [Документ_IncasareCard] = [Документ_IncasareCard].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IncasareCard].[_Date_Time]), 104), -- Документ din Incasare card [Документ_IncasareCard_ID] = [Документ_IncasareCard].[_IDRRef], -- KeyField din Incasare card [Документ_IntroducereaSoldurilor] = [Документ_IntroducereaSoldurilor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaSoldurilor].[_Date_Time]), 104), -- Документ din Introducere solduri [Документ_IntroducereaSoldurilor_ID] = [Документ_IntroducereaSoldurilor].[_IDRRef], -- KeyField din Introducere solduri [Документ_IntroducereaSoldurilorAmanunt] = [Документ_IntroducereaSoldurilorAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereaSoldurilorAmanunt].[_Date_Time]), 104), -- Документ din Introducere solduri amănunt [Документ_IntroducereaSoldurilorAmanunt_ID] = [Документ_IntroducereaSoldurilorAmanunt].[_IDRRef], -- KeyField din Introducere solduri amănunt [Документ_IntroducereSolduriInitialeMF] = [Документ_IntroducereSolduriInitialeMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_IntroducereSolduriInitialeMF].[_Date_Time]), 104), -- Документ din Introducere solduri inițiale MF [Документ_IntroducereSolduriInitialeMF_ID] = [Документ_IntroducereSolduriInitialeMF].[_IDRRef], -- KeyField din Introducere solduri inițiale MF [Документ_InventariereMarfuriInDepozit] = [Документ_InventariereMarfuriInDepozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InventariereMarfuriInDepozit].[_Date_Time]), 104), -- Документ din Inventariere articole [Документ_InventariereMarfuriInDepozit_ID] = [Документ_InventariereMarfuriInDepozit].[_IDRRef], -- KeyField din Inventariere articole [Документ_InventariereMF] = [Документ_InventariereMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InventariereMF].[_Date_Time]), 104), -- Документ din Inventariere MF [Документ_InventariereMF_ID] = [Документ_InventariereMF].[_IDRRef], -- KeyField din Inventariere MF [Документ_InventariereProductieNeterminata] = [Документ_InventariereProductieNeterminata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_InventariereProductieNeterminata].[_Date_Time]), 104), -- Документ din Inventariere producție neterminată [Документ_InventariereProductieNeterminata_ID] = [Документ_InventariereProductieNeterminata].[_IDRRef], -- KeyField din Inventariere producție neterminată [Документ_MarireStocDeMarfuri] = [Документ_MarireStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_MarireStocDeMarfuri].[_Date_Time]), 104), -- Документ din Mărire stoc de articole [Документ_MarireStocDeMarfuri_ID] = [Документ_MarireStocDeMarfuri].[_IDRRef], -- KeyField din Mărire stoc de articole [Документ_ModernizareMF] = [Документ_ModernizareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ModernizareMF].[_Date_Time]), 104), -- Документ din Modernizare MF [Документ_ModernizareMF_ID] = [Документ_ModernizareMF].[_IDRRef], -- KeyField din Modernizare MF [Документ_NotaDeConfirmareSoldPartener] = [Документ_NotaDeConfirmareSoldPartener].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_NotaDeConfirmareSoldPartener].[_Date_Time]), 104), -- Документ din Notă de confirmare [Документ_NotaDeConfirmareSoldPartener_ID] = [Документ_NotaDeConfirmareSoldPartener].[_IDRRef], -- KeyField din Notă de confirmare [Документ_Operatia] = N'Operație contabilă ' + [Документ_Operatia].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Operatia].[_Date_Time]), 104) , -- Документ din Operație contabilă [Документ_Operatia_ID] = [Документ_Operatia].[_IDRRef], -- KeyField din Operație contabilă [Документ_OrdinDeAngajare] = [Документ_OrdinDeAngajare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdinDeAngajare].[_Date_Time]), 104), -- Документ din Contract de angajare [Документ_OrdinDeAngajare_ID] = [Документ_OrdinDeAngajare].[_IDRRef], -- KeyField din Contract de angajare [Документ_OrdinDePlata] = [Документ_OrdinDePlata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdinDePlata].[_Date_Time]), 104), -- Документ din Ordin de plată [Документ_OrdinDePlata_ID] = [Документ_OrdinDePlata].[_IDRRef], -- KeyField din Ordin de plată [Документ_OrdineaDeInchidereDepartamente] = [Документ_OrdineaDeInchidereDepartamente].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_OrdineaDeInchidereDepartamente].[_Date_Time]), 104), -- Документ din Ordinea de închidere a departamentelor [Документ_OrdineaDeInchidereDepartamente_ID] = [Документ_OrdineaDeInchidereDepartamente].[_IDRRef], -- KeyField din Ordinea de închidere a departamentelor [Документ_Partida] = [Документ_Partida].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Partida].[_Date_Time]), 104), -- Документ din Partida de mărfuri [Документ_Partida_ID] = [Документ_Partida].[_IDRRef], -- KeyField din Partida de mărfuri [Документ_Plata] = N'Dispoziție de plată ' + [Документ_Plata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_Plata].[_Date_Time]), 104) , -- Документ din Dispoziție de plată [Документ_Plata_ID] = [Документ_Plata].[_IDRRef], -- KeyField din Dispoziție de plată [Документ_ProformaPentruClient] = [Документ_ProformaPentruClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_ProformaPentruClient].[_Date_Time]), 104), -- Документ din Proforma client [Документ_ProformaPentruClient_ID] = [Документ_ProformaPentruClient].[_IDRRef], -- KeyField din Proforma client [Документ_PunereaInEvidentaImobilizariNecorporale] = [Документ_PunereaInEvidentaImobilizariNecorporale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_PunereaInEvidentaImobilizariNecorporale].[_Date_Time]), 104), -- Документ din Punere în evidență imobilizări necorporale [Документ_PunereaInEvidentaImobilizariNecorporale_ID] = [Документ_PunereaInEvidentaImobilizariNecorporale].[_IDRRef], -- KeyField din Punere în evidență imobilizări necorporale [Документ_PunereaInEvidentaMF] = [Документ_PunereaInEvidentaMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_PunereaInEvidentaMF].[_Date_Time]), 104), -- Документ din Punere în evidență MF [Документ_PunereaInEvidentaMF_ID] = [Документ_PunereaInEvidentaMF].[_IDRRef], -- KeyField din Punere în evidență MF [Документ_RapoarteReglementateExportate] = [Документ_RapoarteReglementateExportate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RapoarteReglementateExportate].[_Date_Time]), 104), -- Документ din Rapoarte reglementate descărcate [Документ_RapoarteReglementateExportate_ID] = [Документ_RapoarteReglementateExportate].[_IDRRef], -- KeyField din Rapoarte reglementate descărcate [Документ_RaportComisionarDespreVanzari] = [Документ_RaportComisionarDespreVanzari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportComisionarDespreVanzari].[_Date_Time]), 104), -- Документ din Raport comisionar despre vânzări [Документ_RaportComisionarDespreVanzari_ID] = [Документ_RaportComisionarDespreVanzari].[_IDRRef], -- KeyField din Raport comisionar despre vânzări [Документ_RaportComitentDespreVanzari] = [Документ_RaportComitentDespreVanzari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportComitentDespreVanzari].[_Date_Time]), 104), -- Документ din Raport comitent despre vanzari [Документ_RaportComitentDespreVanzari_ID] = [Документ_RaportComitentDespreVanzari].[_IDRRef], -- KeyField din Raport comitent despre vanzari [Документ_RaportDeProductie] = [Документ_RaportDeProductie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportDeProductie].[_Date_Time]), 104), -- Документ din Raport de producție [Документ_RaportDeProductie_ID] = [Документ_RaportDeProductie].[_IDRRef], -- KeyField din Raport de producție [Документ_RaportDeVanzariCuAmanunt] = N'Raport de vânzări cu amănunt ' + [Документ_RaportDeVanzariCuAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Документ_RaportDeVanzariCuAmanunt].[_Date_Time]), 104) , -- Документ din Raport de vânzări cu amănunt [Документ_RaportDeVanzariCuAmanunt_ID] = [Документ_RaportDeVanzariCuAmanunt].[_IDRRef], -- KeyField din Raport de vânzări cu amănunt [Примечание] = [ЗаполнениеДвижений].[_Fld6958] -- Примечание from [flax].[dbo].[_Document6936_VT6954] as [ЗаполнениеДвижений] left join [flax].[dbo].[_Document100] as [Документ_RaportReglementat] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000064 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportReglementat].[_IDRRef]) left join [flax].[dbo].[_Document101] as [Документ_ReturDeLaClient] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000065 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ReturDeLaClient].[_IDRRef]) left join [flax].[dbo].[_Document102] as [Документ_ReturLaFurnizor] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000066 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ReturLaFurnizor].[_IDRRef]) left join [flax].[dbo].[_Document103] as [Документ_Salarii] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000067 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Salarii].[_IDRRef]) left join [flax].[dbo].[_Document104] as [Документ_SchimbareaGraficAnualDeAmortizareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000068 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareaGraficAnualDeAmortizareMF].[_IDRRef]) left join [flax].[dbo].[_Document105] as [Документ_SchimbareaParametrilorAmortizariiMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000069 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareaParametrilorAmortizariiMF].[_IDRRef]) left join [flax].[dbo].[_Document106] as [Документ_SchimbareaStareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareaStareMF].[_IDRRef]) left join [flax].[dbo].[_Document107] as [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document108] as [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_IDRRef]) left join [flax].[dbo].[_Document109] as [Документ_SchimbarePretAmanunt] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbarePretAmanunt].[_IDRRef]) left join [flax].[dbo].[_Document110] as [Документ_SchimbarePretNomenclator] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbarePretNomenclator].[_IDRRef]) left join [flax].[dbo].[_Document111] as [Документ_SchimbarePretNomenclatorPartener] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000006F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_SchimbarePretNomenclatorPartener].[_IDRRef]) left join [flax].[dbo].[_Document112] as [Документ_Stornare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000070 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Stornare].[_IDRRef]) left join [flax].[dbo].[_Document113] as [Документ_TransferCadreInOrganizatiile] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000071 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TransferCadreInOrganizatiile].[_IDRRef]) left join [flax].[dbo].[_Document114] as [Документ_TransferDeMarfuri] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000072 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TransferDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document115] as [Документ_TransferMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000073 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TransferMF].[_IDRRef]) left join [flax].[dbo].[_Document116] as [Документ_TransferUtilajPentruMontare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000074 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TransferUtilajPentruMontare].[_IDRRef]) left join [flax].[dbo].[_Document117] as [Документ_VanzareMarfuriSiServiciiPrestate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000075 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_VanzareMarfuriSiServiciiPrestate].[_IDRRef]) left join [flax].[dbo].[_Document3363] as [Документ_Absente] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D23 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Absente].[_IDRRef]) left join [flax].[dbo].[_Document3364] as [Документ_AbsenteLaLucru] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D24 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_AbsenteLaLucru].[_IDRRef]) left join [flax].[dbo].[_Document3365] as [Документ_Asamblare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D25 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Asamblare].[_IDRRef]) left join [flax].[dbo].[_Document3366] as [Документ_CalculareConcediiDeOdihna] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D26 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculareConcediiDeOdihna].[_IDRRef]) left join [flax].[dbo].[_Document3367] as [Документ_CalculareConcediiMedicale] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D27 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculareConcediiMedicale].[_IDRRef]) left join [flax].[dbo].[_Document3369] as [Документ_CalculareLaEliberareDinFunctie] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D29 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculareLaEliberareDinFunctie].[_IDRRef]) left join [flax].[dbo].[_Document3370] as [Документ_CalculareSalarii] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculareSalarii].[_IDRRef]) left join [flax].[dbo].[_Document3371] as [Документ_ComandaDeviz] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ComandaDeviz].[_IDRRef]) left join [flax].[dbo].[_Document3372] as [Документ_ComandaService] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ComandaService].[_IDRRef]) left join [flax].[dbo].[_Document3373] as [Документ_ConcediiDeOdihna] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ConcediiDeOdihna].[_IDRRef]) left join [flax].[dbo].[_Document3374] as [Документ_CorectareRegistrelorDeAcumulare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectareRegistrelorDeAcumulare].[_IDRRef]) left join [flax].[dbo].[_Document3375] as [Документ_CorectareTimpDeLucruAngajati] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D2F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectareTimpDeLucruAngajati].[_IDRRef]) left join [flax].[dbo].[_Document3376] as [Документ_Deplasari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D30 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Deplasari].[_IDRRef]) left join [flax].[dbo].[_Document3377] as [Документ_Dezasamblare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D31 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Dezasamblare].[_IDRRef]) left join [flax].[dbo].[_Document3378] as [Документ_Export] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D32 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Export].[_IDRRef]) left join [flax].[dbo].[_Document3379] as [Документ_InregistrareIntreruperiInMunca] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D33 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareIntreruperiInMunca].[_IDRRef]) left join [flax].[dbo].[_Document3380] as [Документ_InregistrareRetineriUnici] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D34 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareRetineriUnici].[_IDRRef]) left join [flax].[dbo].[_Document3381] as [Документ_InregistrareSporuriUnici] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D35 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareSporuriUnici].[_IDRRef]) left join [flax].[dbo].[_Document3382] as [Документ_OrdinInAcord] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D36 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdinInAcord].[_IDRRef]) left join [flax].[dbo].[_Document3383] as [Документ_PlataOreSuplimentare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D37 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_PlataOreSuplimentare].[_IDRRef]) left join [flax].[dbo].[_Document3386] as [Документ_Prime] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D3A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Prime].[_IDRRef]) left join [flax].[dbo].[_Document3387] as [Документ_ReincepereaActivitatii] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D3B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ReincepereaActivitatii].[_IDRRef]) left join [flax].[dbo].[_Document3388] as [Документ_TitluDeExecutare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000D3C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_TitluDeExecutare].[_IDRRef]) left join [flax].[dbo].[_Document4656] as [Документ_ContractDeMunca] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001230 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ContractDeMunca].[_IDRRef]) left join [flax].[dbo].[_Document4657] as [Документ_IntroducereaReduceri] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001231 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaReduceri].[_IDRRef]) left join [flax].[dbo].[_Document4658] as [Документ_IntroducereaRetineriPlanificate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001232 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaRetineriPlanificate].[_IDRRef]) left join [flax].[dbo].[_Document4659] as [Документ_IntroducereaRetineriSporuriPlanificate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001233 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaRetineriSporuriPlanificate].[_IDRRef]) left join [flax].[dbo].[_Document4660] as [Документ_IntroducereaSporuriPlanificate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001234 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaSporuriPlanificate].[_IDRRef]) left join [flax].[dbo].[_Document4661] as [Документ_RambursareaTicheteDeMasa] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001235 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RambursareaTicheteDeMasa].[_IDRRef]) left join [flax].[dbo].[_Document5212] as [Документ_FiscalizarePlansaDeNumereRegimSpecial] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000145C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_FiscalizarePlansaDeNumereRegimSpecial].[_IDRRef]) left join [flax].[dbo].[_Document5338] as [Документ_CasareOI] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000014DA and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CasareOI].[_IDRRef]) left join [flax].[dbo].[_Document5339] as [Документ_DareInFolosinteOI] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000014DB and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_DareInFolosinteOI].[_IDRRef]) left join [flax].[dbo].[_Document5340] as [Документ_InregistrareManualaInJurnalDeVanzari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000014DC and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareManualaInJurnalDeVanzari].[_IDRRef]) left join [flax].[dbo].[_Document5438] as [Документ_FoaiePrezenta] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000153E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_FoaiePrezenta].[_IDRRef]) left join [flax].[dbo].[_Document56] as [Документ_AprovizionareMarfuriSiServiciiPrimite] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000038 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef]) left join [flax].[dbo].[_Document57] as [Документ_AvizDeIesire] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000039 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_AvizDeIesire].[_IDRRef]) left join [flax].[dbo].[_Document58] as [Документ_AvizDeIntrare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_AvizDeIntrare].[_IDRRef]) left join [flax].[dbo].[_Document5860] as [Документ_IntroducereSoldurilorInformativeMagazin] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000016E4 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereSoldurilorInformativeMagazin].[_IDRRef]) left join [flax].[dbo].[_Document5861] as [Документ_OrdinDeIncasare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000016E5 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdinDeIncasare].[_IDRRef]) left join [flax].[dbo].[_Document59] as [Документ_BonDeConsum] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_BonDeConsum].[_IDRRef]) left join [flax].[dbo].[_Document60] as [Документ_BonFiscal] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_BonFiscal].[_IDRRef]) left join [flax].[dbo].[_Document61] as [Документ_CalculImpozit] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CalculImpozit].[_IDRRef]) left join [flax].[dbo].[_Document62] as [Документ_CasareImobNecorporale] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CasareImobNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document63] as [Документ_CasareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000003F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CasareMF].[_IDRRef]) left join [flax].[dbo].[_Document6336] as [Документ_ReevaluareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000018C0 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ReevaluareMF].[_IDRRef]) left join [flax].[dbo].[_Document64] as [Документ_CheltuieliSuplimentareLaAprovizionare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000040 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CheltuieliSuplimentareLaAprovizionare].[_IDRRef]) left join [flax].[dbo].[_Document65] as [Документ_Compensare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000041 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Compensare].[_IDRRef]) left join [flax].[dbo].[_Document6640] as [Документ_InchidereAnalitice] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x000019F0 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InchidereAnalitice].[_IDRRef]) left join [flax].[dbo].[_Document67] as [Документ_DecontDeAvans] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000043 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_DecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document68] as [Документ_Demisie] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000044 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Demisie].[_IDRRef]) left join [flax].[dbo].[_Document69] as [Документ_DiminuareStocDeMarfuri] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000045 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_DiminuareStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document6936] as [Документ_RegistersEditor] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001B18 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RegistersEditor].[_IDRRef]) left join [flax].[dbo].[_Document6988] as [Документ_CorectieProcurari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001B4C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectieProcurari].[_IDRRef]) left join [flax].[dbo].[_Document6989] as [Документ_CorectieAnaliticiDecontDeAvans] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001B4D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectieAnaliticiDecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document70] as [Документ_EfecteDePlatit] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000046 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_EfecteDePlatit].[_IDRRef]) left join [flax].[dbo].[_Document71] as [Документ_EfecteDePrimit] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000047 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_EfecteDePrimit].[_IDRRef]) left join [flax].[dbo].[_Document7108] as [Документ_ActAditional] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001BC4 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ActAditional].[_IDRRef]) left join [flax].[dbo].[_Document7109] as [Документ_CorectieAnaliticiRetur] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001BC5 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_CorectieAnaliticiRetur].[_IDRRef]) left join [flax].[dbo].[_Document7110] as [Документ_ProcesVerbalLivrariAmanunt] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001BC6 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ProcesVerbalLivrariAmanunt].[_IDRRef]) left join [flax].[dbo].[_Document72] as [Документ_ExtrasDeCont] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000048 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ExtrasDeCont].[_IDRRef]) left join [flax].[dbo].[_Document73] as [Документ_Import] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000049 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Import].[_IDRRef]) left join [flax].[dbo].[_Document7382] as [Документ_ComandaClient] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001CD6 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ComandaClient].[_IDRRef]) left join [flax].[dbo].[_Document74] as [Документ_Incasare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Incasare].[_IDRRef]) left join [flax].[dbo].[_Document75] as [Документ_InchidereLunaDeExercitiu] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InchidereLunaDeExercitiu].[_IDRRef]) left join [flax].[dbo].[_Document76] as [Документ_InregistrareManualaInJurnalDeCumparari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InregistrareManualaInJurnalDeCumparari].[_IDRRef]) left join [flax].[dbo].[_Document7633] as [Документ_IncasareCard] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00001DD1 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IncasareCard].[_IDRRef]) left join [flax].[dbo].[_Document77] as [Документ_IntroducereaSoldurilor] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaSoldurilor].[_IDRRef]) left join [flax].[dbo].[_Document78] as [Документ_IntroducereaSoldurilorAmanunt] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereaSoldurilorAmanunt].[_IDRRef]) left join [flax].[dbo].[_Document79] as [Документ_IntroducereSolduriInitialeMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000004F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_IntroducereSolduriInitialeMF].[_IDRRef]) left join [flax].[dbo].[_Document80] as [Документ_InventariereMarfuriInDepozit] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000050 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InventariereMarfuriInDepozit].[_IDRRef]) left join [flax].[dbo].[_Document81] as [Документ_InventariereMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000051 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InventariereMF].[_IDRRef]) left join [flax].[dbo].[_Document82] as [Документ_InventariereProductieNeterminata] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000052 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_InventariereProductieNeterminata].[_IDRRef]) left join [flax].[dbo].[_Document83] as [Документ_MarireStocDeMarfuri] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000053 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_MarireStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document84] as [Документ_ModernizareMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000054 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ModernizareMF].[_IDRRef]) left join [flax].[dbo].[_Document85] as [Документ_NotaDeConfirmareSoldPartener] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000055 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_NotaDeConfirmareSoldPartener].[_IDRRef]) left join [flax].[dbo].[_Document86] as [Документ_Operatia] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000056 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Operatia].[_IDRRef]) left join [flax].[dbo].[_Document87] as [Документ_OrdinDeAngajare] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000057 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdinDeAngajare].[_IDRRef]) left join [flax].[dbo].[_Document88] as [Документ_OrdinDePlata] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000058 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdinDePlata].[_IDRRef]) left join [flax].[dbo].[_Document89] as [Документ_OrdineaDeInchidereDepartamente] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000059 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_OrdineaDeInchidereDepartamente].[_IDRRef]) left join [flax].[dbo].[_Document90] as [Документ_Partida] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005A and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Partida].[_IDRRef]) left join [flax].[dbo].[_Document91] as [Документ_Plata] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005B and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_Plata].[_IDRRef]) left join [flax].[dbo].[_Document92] as [Документ_ProformaPentruClient] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005C and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_ProformaPentruClient].[_IDRRef]) left join [flax].[dbo].[_Document93] as [Документ_PunereaInEvidentaImobilizariNecorporale] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005D and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_PunereaInEvidentaImobilizariNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document94] as [Документ_PunereaInEvidentaMF] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005E and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_PunereaInEvidentaMF].[_IDRRef]) left join [flax].[dbo].[_Document95] as [Документ_RapoarteReglementateExportate] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x0000005F and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RapoarteReglementateExportate].[_IDRRef]) left join [flax].[dbo].[_Document96] as [Документ_RaportComisionarDespreVanzari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000060 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportComisionarDespreVanzari].[_IDRRef]) left join [flax].[dbo].[_Document97] as [Документ_RaportComitentDespreVanzari] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000061 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportComitentDespreVanzari].[_IDRRef]) left join [flax].[dbo].[_Document98] as [Документ_RaportDeProductie] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000062 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportDeProductie].[_IDRRef]) left join [flax].[dbo].[_Document99] as [Документ_RaportDeVanzariCuAmanunt] on ([ЗаполнениеДвижений].[_Fld6957_TYPE] = 0x08 and [ЗаполнениеДвижений].[_Fld6957_RTRef] = 0x00000063 and [ЗаполнениеДвижений].[_Fld6957_RRRef] = [Документ_RaportDeVanzariCuAmanunt].[_IDRRef])
Full View Select Sql with fields
Exemplu de apel pentru view-ul asociat obiectul curent din baza destinatie cu câmpuri
select [ParentRef], --Referință către înregistrarea părinte [KeyField], --Câmpul cheie [LineNo], --Numărul liniei [Действие], --Действие [Документ_Id], --Документ [Документ_RaportReglementat], -- din Rapoarte reglementate [Документ_RaportReglementat_ID], -- din Rapoarte reglementate ID [Документ_ReturDeLaClient], -- din Retur de la client [Документ_ReturDeLaClient_ID], -- din Retur de la client ID [Документ_ReturLaFurnizor], -- din Retur la furnizor [Документ_ReturLaFurnizor_ID], -- din Retur la furnizor ID [Документ_Salarii], -- din Calculare salarii (sume totale) [Документ_Salarii_ID], -- din Calculare salarii (sume totale) ID [Документ_SchimbareaGraficAnualDeAmortizareMF], -- din Schimbare grafic anual de amortizare MF [Документ_SchimbareaGraficAnualDeAmortizareMF_ID], -- din Schimbare grafic anual de amortizare MF ID [Документ_SchimbareaParametrilorAmortizariiMF], -- din Schimbare parametri de amortizare MF [Документ_SchimbareaParametrilorAmortizariiMF_ID], -- din Schimbare parametri de amortizare MF ID [Документ_SchimbareaStareMF], -- din Schimbare stare MF [Документ_SchimbareaStareMF_ID], -- din Schimbare stare MF ID [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale], -- din Schimbare metoda de afișare cheltuielilor de amortizare imob necorporale [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale_ID],-- din Schimbare metoda de afișare cheltuielilor de amortizare imob necorporale ID [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF], -- din Schimbare metoda de afisare cheltuielilor de amortizare MF [Документ_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF_ID], -- din Schimbare metoda de afisare cheltuielilor de amortizare MF ID [Документ_SchimbarePretAmanunt], -- din Schimbare prețuri cu amănunt [Документ_SchimbarePretAmanunt_ID], -- din Schimbare prețuri cu amănunt ID [Документ_SchimbarePretNomenclator], -- din Schimbare prețuri articole [Документ_SchimbarePretNomenclator_ID], -- din Schimbare prețuri articole ID [Документ_SchimbarePretNomenclatorPartener], -- din Schimbare prețuri partener [Документ_SchimbarePretNomenclatorPartener_ID], -- din Schimbare prețuri partener ID [Документ_Stornare], -- din Stornare [Документ_Stornare_ID], -- din Stornare ID [Документ_TransferCadreInOrganizatiile], -- din Decizie de mutare [Документ_TransferCadreInOrganizatiile_ID], -- din Decizie de mutare ID [Документ_TransferDeMarfuri], -- din Transfer între gestiuni [Документ_TransferDeMarfuri_ID], -- din Transfer între gestiuni ID [Документ_TransferMF], -- din Transfer MF [Документ_TransferMF_ID], -- din Transfer MF ID [Документ_TransferUtilajPentruMontare], -- din Transfer utilaj pentru montare [Документ_TransferUtilajPentruMontare_ID], -- din Transfer utilaj pentru montare ID [Документ_VanzareMarfuriSiServiciiPrestate], -- din Vânzare și servicii prestate [Документ_VanzareMarfuriSiServiciiPrestate_ID], -- din Vânzare și servicii prestate ID [Документ_Absente], -- din Absenţe [Документ_Absente_ID], -- din Absenţe ID [Документ_AbsenteLaLucru], -- din Absențe la lucru [Документ_AbsenteLaLucru_ID], -- din Absențe la lucru ID [Документ_Asamblare], -- din Asamblare [Документ_Asamblare_ID], -- din Asamblare ID [Документ_CalculareConcediiDeOdihna], -- din Calculare concedii de odihnă [Документ_CalculareConcediiDeOdihna_ID], -- din Calculare concedii de odihnă ID [Документ_CalculareConcediiMedicale], -- din Concedii medicale [Документ_CalculareConcediiMedicale_ID], -- din Concedii medicale ID [Документ_CalculareLaEliberareDinFunctie], -- din Calculare la eliberare din functie [Документ_CalculareLaEliberareDinFunctie_ID], -- din Calculare la eliberare din functie ID [Документ_CalculareSalarii], -- din Calculare salarii [Документ_CalculareSalarii_ID], -- din Calculare salarii ID [Документ_ComandaDeviz], -- din Comanda deviz [Документ_ComandaDeviz_ID], -- din Comanda deviz ID [Документ_ComandaService], -- din Comanda service [Документ_ComandaService_ID], -- din Comanda service ID [Документ_ConcediiDeOdihna], -- din Concedii de odihnă [Документ_ConcediiDeOdihna_ID], -- din Concedii de odihnă ID [Документ_CorectareRegistrelorDeAcumulare], -- din Corectare registrelor de acumulare (nu se utilizează) [Документ_CorectareRegistrelorDeAcumulare_ID], -- din Corectare registrelor de acumulare (nu se utilizează) ID [Документ_CorectareTimpDeLucruAngajati], -- din Corectare timp de lucru angajaţi [Документ_CorectareTimpDeLucruAngajati_ID], -- din Corectare timp de lucru angajaţi ID [Документ_Deplasari], -- din Deplasări [Документ_Deplasari_ID], -- din Deplasări ID [Документ_Dezasamblare], -- din Dezasamblare [Документ_Dezasamblare_ID], -- din Dezasamblare ID [Документ_Export], -- din Export [Документ_Export_ID], -- din Export ID [Документ_InregistrareIntreruperiInMunca], -- din Inregistrare întreruperi în muncă [Документ_InregistrareIntreruperiInMunca_ID], -- din Inregistrare întreruperi în muncă ID [Документ_InregistrareRetineriUnici], -- din Inregistrare rețineri unici [Документ_InregistrareRetineriUnici_ID], -- din Inregistrare rețineri unici ID [Документ_InregistrareSporuriUnici], -- din Înregistrare sporuri unici [Документ_InregistrareSporuriUnici_ID], -- din Înregistrare sporuri unici ID [Документ_OrdinInAcord], -- din Ordin in acord [Документ_OrdinInAcord_ID], -- din Ordin in acord ID [Документ_PlataOreSuplimentare], -- din Plata ore suplimentare [Документ_PlataOreSuplimentare_ID], -- din Plata ore suplimentare ID [Документ_Prime], -- din Prime [Документ_Prime_ID], -- din Prime ID [Документ_ReincepereaActivitatii], -- din Reînceperea activității [Документ_ReincepereaActivitatii_ID], -- din Reînceperea activității ID [Документ_TitluDeExecutare], -- din Titlu de executare [Документ_TitluDeExecutare_ID], -- din Titlu de executare ID [Документ_ContractDeMunca], -- din Contract de muncă [Документ_ContractDeMunca_ID], -- din Contract de muncă ID [Документ_IntroducereaReduceri], -- din Introducerea reduceri [Документ_IntroducereaReduceri_ID], -- din Introducerea reduceri ID [Документ_IntroducereaRetineriPlanificate], -- din Întroducerea rețineri planificate [Документ_IntroducereaRetineriPlanificate_ID], -- din Întroducerea rețineri planificate ID [Документ_IntroducereaRetineriSporuriPlanificate], -- din Întroducerea rețineri sporuri planificate [Документ_IntroducereaRetineriSporuriPlanificate_ID], -- din Întroducerea rețineri sporuri planificate ID [Документ_IntroducereaSporuriPlanificate], -- din Întroducerea sporuri planificate [Документ_IntroducereaSporuriPlanificate_ID], -- din Întroducerea sporuri planificate ID [Документ_RambursareaTicheteDeMasa], -- din Rambursarea tichete de masă [Документ_RambursareaTicheteDeMasa_ID], -- din Rambursarea tichete de masă ID [Документ_FiscalizarePlansaDeNumereRegimSpecial], -- din Fiscalizare planșe de numere regim special [Документ_FiscalizarePlansaDeNumereRegimSpecial_ID], -- din Fiscalizare planșe de numere regim special ID [Документ_CasareOI], -- din Casare obiecte de inventar [Документ_CasareOI_ID], -- din Casare obiecte de inventar ID [Документ_DareInFolosinteOI], -- din Dare în folosințe obiecte de inventar [Документ_DareInFolosinteOI_ID], -- din Dare în folosințe obiecte de inventar ID [Документ_InregistrareManualaInJurnalDeVanzari], -- din Inregistrare manuală în jurnal de vanzari [Документ_InregistrareManualaInJurnalDeVanzari_ID], -- din Inregistrare manuală în jurnal de vanzari ID [Документ_FoaiePrezenta], -- din Foaie prezenta [Документ_FoaiePrezenta_ID], -- din Foaie prezenta ID [Документ_AprovizionareMarfuriSiServiciiPrimite], -- din Aprovizionare și servicii primite [Документ_AprovizionareMarfuriSiServiciiPrimite_ID], -- din Aprovizionare și servicii primite ID [Документ_AvizDeIesire], -- din Aviz de ieșire [Документ_AvizDeIesire_ID], -- din Aviz de ieșire ID [Документ_AvizDeIntrare], -- din Aviz de intrare [Документ_AvizDeIntrare_ID], -- din Aviz de intrare ID [Документ_IntroducereSoldurilorInformativeMagazin], -- din Introducere soldurilor informative magazin [Документ_IntroducereSoldurilorInformativeMagazin_ID], -- din Introducere soldurilor informative magazin ID [Документ_OrdinDeIncasare], -- din Ordin de incasare [Документ_OrdinDeIncasare_ID], -- din Ordin de incasare ID [Документ_BonDeConsum], -- din Bon de consum [Документ_BonDeConsum_ID], -- din Bon de consum ID [Документ_BonFiscal], -- din Bon fiscal [Документ_BonFiscal_ID], -- din Bon fiscal ID [Документ_CalculImpozit], -- din Calcul impozit [Документ_CalculImpozit_ID], -- din Calcul impozit ID [Документ_CasareImobNecorporale], -- din Casare imobilizări necorporale [Документ_CasareImobNecorporale_ID], -- din Casare imobilizări necorporale ID [Документ_CasareMF], -- din Casare MF [Документ_CasareMF_ID], -- din Casare MF ID [Документ_ReevaluareMF], -- din Reevaluare MF [Документ_ReevaluareMF_ID], -- din Reevaluare MF ID [Документ_CheltuieliSuplimentareLaAprovizionare], -- din Cheltuieli suplimentare la aprovizionare [Документ_CheltuieliSuplimentareLaAprovizionare_ID], -- din Cheltuieli suplimentare la aprovizionare ID [Документ_Compensare], -- din Compensare [Документ_Compensare_ID], -- din Compensare ID [Документ_InchidereAnalitice], -- din Inchidere analitice [Документ_InchidereAnalitice_ID], -- din Inchidere analitice ID [Документ_DecontDeAvans], -- din Decont de avans [Документ_DecontDeAvans_ID], -- din Decont de avans ID [Документ_Demisie], -- din Reziliere contract de muncă [Документ_Demisie_ID], -- din Reziliere contract de muncă ID [Документ_DiminuareStocDeMarfuri], -- din Diminuare stoc de articole [Документ_DiminuareStocDeMarfuri_ID], -- din Diminuare stoc de articole ID [Документ_RegistersEditor], -- din Corectarea miscarilor registrului [Документ_RegistersEditor_ID], -- din Corectarea miscarilor registrului ID [Документ_CorectieProcurari], -- din Corecție Aprovizionări [Документ_CorectieProcurari_ID], -- din Corecție Aprovizionări ID [Документ_CorectieAnaliticiDecontDeAvans], -- din Corectie analitici decont de avans [Документ_CorectieAnaliticiDecontDeAvans_ID], -- din Corectie analitici decont de avans ID [Документ_EfecteDePlatit], -- din Efecte de plătit [Документ_EfecteDePlatit_ID], -- din Efecte de plătit ID [Документ_EfecteDePrimit], -- din Efecte de primit [Документ_EfecteDePrimit_ID], -- din Efecte de primit ID [Документ_ActAditional], -- din Act adțional la Contract [Документ_ActAditional_ID], -- din Act adțional la Contract ID [Документ_CorectieAnaliticiRetur], -- din Corectie analitici retur [Документ_CorectieAnaliticiRetur_ID], -- din Corectie analitici retur ID [Документ_ProcesVerbalLivrariAmanunt], -- din Proces Verbal de Livrari in Amanunt [Документ_ProcesVerbalLivrariAmanunt_ID], -- din Proces Verbal de Livrari in Amanunt ID [Документ_ExtrasDeCont], -- din Extras de cont [Документ_ExtrasDeCont_ID], -- din Extras de cont ID [Документ_Import], -- din Import [Документ_Import_ID], -- din Import ID [Документ_ComandaClient], -- din Comanda client [Документ_ComandaClient_ID], -- din Comanda client ID [Документ_Incasare], -- din Dispoziție de încasare [Документ_Incasare_ID], -- din Dispoziție de încasare ID [Документ_InchidereLunaDeExercitiu], -- din Închidere lună de exercițiu [Документ_InchidereLunaDeExercitiu_ID], -- din Închidere lună de exercițiu ID [Документ_InregistrareManualaInJurnalDeCumparari], -- din Inregistrare manuală în jurnal de cumpărări [Документ_InregistrareManualaInJurnalDeCumparari_ID], -- din Inregistrare manuală în jurnal de cumpărări ID [Документ_IncasareCard], -- din Incasare card [Документ_IncasareCard_ID], -- din Incasare card ID [Документ_IntroducereaSoldurilor], -- din Introducere solduri [Документ_IntroducereaSoldurilor_ID], -- din Introducere solduri ID [Документ_IntroducereaSoldurilorAmanunt], -- din Introducere solduri amănunt [Документ_IntroducereaSoldurilorAmanunt_ID], -- din Introducere solduri amănunt ID [Документ_IntroducereSolduriInitialeMF], -- din Introducere solduri inițiale MF [Документ_IntroducereSolduriInitialeMF_ID], -- din Introducere solduri inițiale MF ID [Документ_InventariereMarfuriInDepozit], -- din Inventariere articole [Документ_InventariereMarfuriInDepozit_ID], -- din Inventariere articole ID [Документ_InventariereMF], -- din Inventariere MF [Документ_InventariereMF_ID], -- din Inventariere MF ID [Документ_InventariereProductieNeterminata], -- din Inventariere producție neterminată [Документ_InventariereProductieNeterminata_ID], -- din Inventariere producție neterminată ID [Документ_MarireStocDeMarfuri], -- din Mărire stoc de articole [Документ_MarireStocDeMarfuri_ID], -- din Mărire stoc de articole ID [Документ_ModernizareMF], -- din Modernizare MF [Документ_ModernizareMF_ID], -- din Modernizare MF ID [Документ_NotaDeConfirmareSoldPartener], -- din Notă de confirmare [Документ_NotaDeConfirmareSoldPartener_ID], -- din Notă de confirmare ID [Документ_Operatia], -- din Operație contabilă [Документ_Operatia_ID], -- din Operație contabilă ID [Документ_OrdinDeAngajare], -- din Contract de angajare [Документ_OrdinDeAngajare_ID], -- din Contract de angajare ID [Документ_OrdinDePlata], -- din Ordin de plată [Документ_OrdinDePlata_ID], -- din Ordin de plată ID [Документ_OrdineaDeInchidereDepartamente], -- din Ordinea de închidere a departamentelor [Документ_OrdineaDeInchidereDepartamente_ID], -- din Ordinea de închidere a departamentelor ID [Документ_Partida], -- din Partida de mărfuri [Документ_Partida_ID], -- din Partida de mărfuri ID [Документ_Plata], -- din Dispoziție de plată [Документ_Plata_ID], -- din Dispoziție de plată ID [Документ_ProformaPentruClient], -- din Proforma client [Документ_ProformaPentruClient_ID], -- din Proforma client ID [Документ_PunereaInEvidentaImobilizariNecorporale], -- din Punere în evidență imobilizări necorporale [Документ_PunereaInEvidentaImobilizariNecorporale_ID], -- din Punere în evidență imobilizări necorporale ID [Документ_PunereaInEvidentaMF], -- din Punere în evidență MF [Документ_PunereaInEvidentaMF_ID], -- din Punere în evidență MF ID [Документ_RapoarteReglementateExportate], -- din Rapoarte reglementate descărcate [Документ_RapoarteReglementateExportate_ID], -- din Rapoarte reglementate descărcate ID [Документ_RaportComisionarDespreVanzari], -- din Raport comisionar despre vânzări [Документ_RaportComisionarDespreVanzari_ID], -- din Raport comisionar despre vânzări ID [Документ_RaportComitentDespreVanzari], -- din Raport comitent despre vanzari [Документ_RaportComitentDespreVanzari_ID], -- din Raport comitent despre vanzari ID [Документ_RaportDeProductie], -- din Raport de producție [Документ_RaportDeProductie_ID], -- din Raport de producție ID [Документ_RaportDeVanzariCuAmanunt], -- din Raport de vânzări cu amănunt [Документ_RaportDeVanzariCuAmanunt_ID], -- din Raport de vânzări cu amănunt ID [Примечание] --Примечание from [flax].[RegistersEditor_ЗаполнениеДвижений] -- ЗаполнениеДвижений
Full View Select Sql
Exemplu de apel pentru view-ul asociat obiectul curent din baza destinatie fără câmpuri
select * from [flax].[RegistersEditor_ЗаполнениеДвижений] -- ЗаполнениеДвижений