Obiectul Rezervari
Detalierea Obiectului : Rezervari
Nume Obiect : Rezervari
Nume Tabela Sursa : _InfoRg7602
Nume View : InfoRg_Rezervari
-
Tabela în care este stocat : _InfoRg7602
Conținut tabelă _InfoRg7602
Conține 152 înregistrări
| _Fld7603RRef | _Fld7604RRef | _Fld7605RRef | _Fld7618_TYPE | _Fld7618_RTRef | _Fld7618_RRRef | _Fld7619 | _Fld7606 | _SimpleKey |
|---|---|---|---|---|---|---|---|---|
| 0x00000000000000000000000000000000 | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5B57F1F30368 | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5B57F1F30368 | 1 | 1,000 | 0x1A92B99D2E656F4C821CFEAA2F8E1B8E |
| 0x00000000000000000000000000000000 | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5B57F1F3036C | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5B57F1F3036C | 1 | 1,000 | 0xB1872ADB94735D46939C7B726AA7FC0D |
| 0x00000000000000000000000000000000 | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5BF7298AE3D8 | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5BF7298AE3D8 | 3 | 1,000 | 0xE9909CA6CD20044B83C693B907DC30A9 |
| 0x00000000000000000000000000000000 | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5BF7298AE3D8 | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5BF7298AE3D8 | 10 | 1,000 | 0x051D6D2B1EFFF4489FB4A20BDC7CB53E |
| 0x92CB00E04C18BD5D11E2A7F067A23711 | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5C8016DDD13F | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5C8016DDD13F | 1 | 1,000 | 0x27D305DB49B40549B17FDE4B8F19FB61 |
| 0x9406D067E5E9285611E357FE16931E15 | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5BF7298AE3EC | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5BF7298AE3EC | 2 | 1,000 | 0xC8762984E1DEBD45A131A53DF9B49484 |
| 0x940AD067E5E9285611E39ACA9E17CB3B | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5BF7298AE3CE | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5BF7298AE3CE | 1 | 1,000 | 0x9FC46FEECFB81D49AF95118AE5C21687 |
| 0x940AD067E5E9285611E39ACA9E17CB3B | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5BF7298AE3EB | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5BF7298AE3EB | 1 | 1,000 | 0x562E2EA3D7EC794EAA486DF89584811E |
| 0x9414D067E5E9285611E49BC76AB843BD | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5B57F1F30375 | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5B57F1F30375 | 1 | 1,000 | 0xACA281B5D4BD754AB5FD33BC515B8191 |
| 0x9414D067E5E9285611E4C6F60EB31F9E | 0x902200E04D066AF511DF21E4D2956371 | 0xBEDA00155D10D30411EF5C197D9D352B | 0x08 | 0x00001CD6 | 0xBEDA00155D10D30411EF5C197D9D352B | 4 | 3,000 | 0xA2BAD59AD4AFB2459AB0312F9939921A |
Guid-uri
- Guid Catalog Id
- Configurație : dca0be12-2e01-4191-ae3d-e4f1012d3a3d
- Bază de date : 0xAE3DE4F1012D3A3D41912E01DCA0BE12
Câmpuri
| Nume | Camp | Descriere | Tip |
|---|---|---|---|
| Articol | _Fld7603RRef | Articol | Nomenclator de articole |
| Depozit | _Fld7604RRef | Depozit | Depozite |
| Comanda | _Fld7605RRef | Comanda | Comanda client |
| Document | _Fld7618 | Document |
|
| Line | _Fld7619 | Line | decimal |
| Cant | _Fld7606 | Cant | decimal |
| SimpleKey | _SimpleKey | Keye simpla pentru registrul de informatii | binary |
Detaliere Câmpuri
Câmpul Articol
Nume Câmp în baza de date : _Fld7603RRef
Descriere Câmp : Articol
Tip Câmp : CatalogRef.Nomenclator
Guid Atribut Id
- Configurație : c98e8eb6-26f0-481e-8374-347fdd4caa81
- Bază de date : 0x8374347FDD4CAA81481E26F0C98E8EB6
Exemplu de interogari :
select [Articol] = [Articol_Nomenclator]._Description, -- Articol din Nomenclator de articole [Articol_ID] = [Articol_Nomenclator].[_IDRRef], -- KeyField din Nomenclator de articole [Rezervari].* from [flax].[dbo].[_InfoRg7602] as [Rezervari] left join [flax].[dbo].[_Reference32] as [Articol_Nomenclator] on ([Rezervari].[_Fld7603RRef] = [Articol_Nomenclator].[_IDRRef])
Câmpul Depozit
Nume Câmp în baza de date : _Fld7604RRef
Descriere Câmp : Depozit
Tip Câmp : CatalogRef.Depozite
Guid Atribut Id
- Configurație : 99f13030-7457-490a-a882-4d6b28f57a16
- Bază de date : 0xA8824D6B28F57A16490A745799F13030
Exemplu de interogari :
select [Depozit] = [Depozit_Depozite]._Description, -- Depozit din Depozite [Depozit_ID] = [Depozit_Depozite].[_IDRRef], -- KeyField din Depozite [Rezervari].* from [flax].[dbo].[_InfoRg7602] as [Rezervari] left join [flax].[dbo].[_Reference19] as [Depozit_Depozite] on ([Rezervari].[_Fld7604RRef] = [Depozit_Depozite].[_IDRRef])
Câmpul Comanda
Nume Câmp în baza de date : _Fld7605RRef
Descriere Câmp : Comanda
Tip Câmp : DocumentRef.ComandaClient
Guid Atribut Id
- Configurație : 2a2f77fe-6a58-4146-a10f-d88684d161f0
- Bază de date : 0xA10FD88684D161F041466A582A2F77FE
Exemplu de interogari :
select [Comanda] = [Comanda_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Comanda_ComandaClient].[_Date_Time]), 104), -- Comanda din Comanda client [Comanda_ID] = [Comanda_ComandaClient].[_IDRRef], -- KeyField din Comanda client [Rezervari].* from [flax].[dbo].[_InfoRg7602] as [Rezervari] left join [flax].[dbo].[_Document7382] as [Comanda_ComandaClient] on ([Rezervari].[_Fld7605RRef] = [Comanda_ComandaClient].[_IDRRef])
Câmpul Document
Nume Câmp în baza de date : _Fld7618
Descriere Câmp : Document
Tip Câmp : complex
Guid Atribut Id
- Configurație : 18ca3876-7a79-4cc8-8806-745f01c6dfd4
- Bază de date : 0x8806745F01C6DFD44CC87A7918CA3876
Exemplu de interogari :
select [Document_Id] = [Rezervari].[_Fld7618_RRRef], -- Document [Document_Type] = [Rezervari].[_Fld7618_RTRef], -- Document [Document_Desc] = case [Rezervari].[_Fld7618_RTRef] -- DescriereDocument when 0x00001CD6 then [Document_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ComandaClient].[_Date_Time]), 104) -- Document din Comanda client else null end, -- Valoare necompletata [Document_RaportReglementat] = [Document_RaportReglementat].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_RaportReglementat].[_Date_Time]), 104), -- Document din Rapoarte reglementate [Document_RaportReglementat_ID] = [Document_RaportReglementat].[_IDRRef], -- KeyField din Rapoarte reglementate [Document_No] = case [Rezervari].[_Fld7618_RTRef] -- DescriereDocument when 0x00001CD6 then [Document_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ComandaClient].[_Date_Time]), 104) -- Document din Comanda client else null end, -- Valoare necompletata [Document_ReturDeLaClient] = N'Retur de la client ' + [Document_ReturDeLaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ReturDeLaClient].[_Date_Time]), 104) , -- Document din Retur de la client [Document_ReturDeLaClient_ID] = [Document_ReturDeLaClient].[_IDRRef], -- KeyField din Retur de la client [Document_ReturLaFurnizor] = N'Retur la furnizor ' + [Document_ReturLaFurnizor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ReturLaFurnizor].[_Date_Time]), 104) , -- Document din Retur la furnizor [Document_ReturLaFurnizor_ID] = [Document_ReturLaFurnizor].[_IDRRef], -- KeyField din Retur la furnizor [Document_Salarii] = N'Calculare salarii sume totale) ' + [Document_Salarii].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Salarii].[_Date_Time]), 104) , -- Document din Calculare salarii (sume totale) [Document_Salarii_ID] = [Document_Salarii].[_IDRRef], -- KeyField din Calculare salarii (sume totale) [Document_SchimbareaGraficAnualDeAmortizareMF] = [Document_SchimbareaGraficAnualDeAmortizareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_SchimbareaGraficAnualDeAmortizareMF].[_Date_Time]), 104), -- Document din Schimbare grafic anual de amortizare MF [Document_SchimbareaGraficAnualDeAmortizareMF_ID] = [Document_SchimbareaGraficAnualDeAmortizareMF].[_IDRRef], -- KeyField din Schimbare grafic anual de amortizare MF [Document_SchimbareaParametrilorAmortizariiMF] = [Document_SchimbareaParametrilorAmortizariiMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_SchimbareaParametrilorAmortizariiMF].[_Date_Time]), 104), -- Document din Schimbare parametri de amortizare MF [Document_SchimbareaParametrilorAmortizariiMF_ID] = [Document_SchimbareaParametrilorAmortizariiMF].[_IDRRef], -- KeyField din Schimbare parametri de amortizare MF [Document_SchimbareaStareMF] = [Document_SchimbareaStareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_SchimbareaStareMF].[_Date_Time]), 104), -- Document din Schimbare stare MF [Document_SchimbareaStareMF_ID] = [Document_SchimbareaStareMF].[_IDRRef], -- KeyField din Schimbare stare MF [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale] = [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_Date_Time]), 104), -- Document din Schimbare metoda de afișare cheltuielilor de amortizare imob necorporale [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale_ID] = [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_IDRRef], -- KeyField din Schimbare metoda de afișare cheltuielilor de amortizare imob necorporale [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF] = [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_Date_Time]), 104), -- Document din Schimbare metoda de afisare cheltuielilor de amortizare MF [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF_ID] = [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_IDRRef], -- KeyField din Schimbare metoda de afisare cheltuielilor de amortizare MF [Document_SchimbarePretAmanunt] = [Document_SchimbarePretAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_SchimbarePretAmanunt].[_Date_Time]), 104), -- Document din Schimbare prețuri cu amănunt [Document_SchimbarePretAmanunt_ID] = [Document_SchimbarePretAmanunt].[_IDRRef], -- KeyField din Schimbare prețuri cu amănunt [Document_SchimbarePretNomenclator] = [Document_SchimbarePretNomenclator].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_SchimbarePretNomenclator].[_Date_Time]), 104), -- Document din Schimbare prețuri articole [Document_SchimbarePretNomenclator_ID] = [Document_SchimbarePretNomenclator].[_IDRRef], -- KeyField din Schimbare prețuri articole [Document_SchimbarePretNomenclatorPartener] = [Document_SchimbarePretNomenclatorPartener].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_SchimbarePretNomenclatorPartener].[_Date_Time]), 104), -- Document din Schimbare prețuri partener [Document_SchimbarePretNomenclatorPartener_ID] = [Document_SchimbarePretNomenclatorPartener].[_IDRRef], -- KeyField din Schimbare prețuri partener [Document_Stornare] = [Document_Stornare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Stornare].[_Date_Time]), 104), -- Document din Stornare [Document_Stornare_ID] = [Document_Stornare].[_IDRRef], -- KeyField din Stornare [Document_TransferCadreInOrganizatiile] = [Document_TransferCadreInOrganizatiile].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_TransferCadreInOrganizatiile].[_Date_Time]), 104), -- Document din Decizie de mutare [Document_TransferCadreInOrganizatiile_ID] = [Document_TransferCadreInOrganizatiile].[_IDRRef], -- KeyField din Decizie de mutare [Document_TransferDeMarfuri] = N'Transfer între gestiuni ' + [Document_TransferDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_TransferDeMarfuri].[_Date_Time]), 104) , -- Document din Transfer între gestiuni [Document_TransferDeMarfuri_ID] = [Document_TransferDeMarfuri].[_IDRRef], -- KeyField din Transfer între gestiuni [Document_TransferMF] = [Document_TransferMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_TransferMF].[_Date_Time]), 104), -- Document din Transfer MF [Document_TransferMF_ID] = [Document_TransferMF].[_IDRRef], -- KeyField din Transfer MF [Document_TransferUtilajPentruMontare] = [Document_TransferUtilajPentruMontare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_TransferUtilajPentruMontare].[_Date_Time]), 104), -- Document din Transfer utilaj pentru montare [Document_TransferUtilajPentruMontare_ID] = [Document_TransferUtilajPentruMontare].[_IDRRef], -- KeyField din Transfer utilaj pentru montare [Document_VanzareMarfuriSiServiciiPrestate] = N'Vânzare și servicii prestate ' + [Document_VanzareMarfuriSiServiciiPrestate].[_Fld2712] + ' ' + [Document_VanzareMarfuriSiServiciiPrestate].[_Fld2707] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_VanzareMarfuriSiServiciiPrestate].[_Date_Time]), 104) , -- Document din Vânzare și servicii prestate [Document_VanzareMarfuriSiServiciiPrestate_ID] = [Document_VanzareMarfuriSiServiciiPrestate].[_IDRRef], -- KeyField din Vânzare și servicii prestate [Document_Absente] = [Document_Absente].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Absente].[_Date_Time]), 104), -- Document din Absenţe [Document_Absente_ID] = [Document_Absente].[_IDRRef], -- KeyField din Absenţe [Document_AbsenteLaLucru] = [Document_AbsenteLaLucru].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_AbsenteLaLucru].[_Date_Time]), 104), -- Document din Absențe la lucru [Document_AbsenteLaLucru_ID] = [Document_AbsenteLaLucru].[_IDRRef], -- KeyField din Absențe la lucru [Document_Asamblare] = N'Asamblare ' + [Document_Asamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Asamblare].[_Date_Time]), 104) , -- Document din Asamblare [Document_Asamblare_ID] = [Document_Asamblare].[_IDRRef], -- KeyField din Asamblare [Document_CalculareConcediiDeOdihna] = [Document_CalculareConcediiDeOdihna].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CalculareConcediiDeOdihna].[_Date_Time]), 104), -- Document din Calculare concedii de odihnă [Document_CalculareConcediiDeOdihna_ID] = [Document_CalculareConcediiDeOdihna].[_IDRRef], -- KeyField din Calculare concedii de odihnă [Document_CalculareConcediiMedicale] = [Document_CalculareConcediiMedicale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CalculareConcediiMedicale].[_Date_Time]), 104), -- Document din Concedii medicale [Document_CalculareConcediiMedicale_ID] = [Document_CalculareConcediiMedicale].[_IDRRef], -- KeyField din Concedii medicale [Document_CalculareLaEliberareDinFunctie] = [Document_CalculareLaEliberareDinFunctie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CalculareLaEliberareDinFunctie].[_Date_Time]), 104), -- Document din Calculare la eliberare din functie [Document_CalculareLaEliberareDinFunctie_ID] = [Document_CalculareLaEliberareDinFunctie].[_IDRRef], -- KeyField din Calculare la eliberare din functie [Document_CalculareSalarii] = [Document_CalculareSalarii].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CalculareSalarii].[_Date_Time]), 104), -- Document din Calculare salarii [Document_CalculareSalarii_ID] = [Document_CalculareSalarii].[_IDRRef], -- KeyField din Calculare salarii [Document_ComandaDeviz] = [Document_ComandaDeviz].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ComandaDeviz].[_Date_Time]), 104), -- Document din Comanda deviz [Document_ComandaDeviz_ID] = [Document_ComandaDeviz].[_IDRRef], -- KeyField din Comanda deviz [Document_ComandaService] = [Document_ComandaService].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ComandaService].[_Date_Time]), 104), -- Document din Comanda service [Document_ComandaService_ID] = [Document_ComandaService].[_IDRRef], -- KeyField din Comanda service [Document_ConcediiDeOdihna] = [Document_ConcediiDeOdihna].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ConcediiDeOdihna].[_Date_Time]), 104), -- Document din Concedii de odihnă [Document_ConcediiDeOdihna_ID] = [Document_ConcediiDeOdihna].[_IDRRef], -- KeyField din Concedii de odihnă [Document_CorectareRegistrelorDeAcumulare] = [Document_CorectareRegistrelorDeAcumulare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CorectareRegistrelorDeAcumulare].[_Date_Time]), 104), -- Document din Corectare registrelor de acumulare (nu se utilizează) [Document_CorectareRegistrelorDeAcumulare_ID] = [Document_CorectareRegistrelorDeAcumulare].[_IDRRef], -- KeyField din Corectare registrelor de acumulare (nu se utilizează) [Document_CorectareTimpDeLucruAngajati] = [Document_CorectareTimpDeLucruAngajati].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CorectareTimpDeLucruAngajati].[_Date_Time]), 104), -- Document din Corectare timp de lucru angajaţi [Document_CorectareTimpDeLucruAngajati_ID] = [Document_CorectareTimpDeLucruAngajati].[_IDRRef], -- KeyField din Corectare timp de lucru angajaţi [Document_Deplasari] = [Document_Deplasari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Deplasari].[_Date_Time]), 104), -- Document din Deplasări [Document_Deplasari_ID] = [Document_Deplasari].[_IDRRef], -- KeyField din Deplasări [Document_Dezasamblare] = N'Dezasamblare ' + [Document_Dezasamblare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Dezasamblare].[_Date_Time]), 104) , -- Document din Dezasamblare [Document_Dezasamblare_ID] = [Document_Dezasamblare].[_IDRRef], -- KeyField din Dezasamblare [Document_Export] = [Document_Export].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Export].[_Date_Time]), 104), -- Document din Export [Document_Export_ID] = [Document_Export].[_IDRRef], -- KeyField din Export [Document_InregistrareIntreruperiInMunca] = [Document_InregistrareIntreruperiInMunca].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InregistrareIntreruperiInMunca].[_Date_Time]), 104), -- Document din Inregistrare întreruperi în muncă [Document_InregistrareIntreruperiInMunca_ID] = [Document_InregistrareIntreruperiInMunca].[_IDRRef], -- KeyField din Inregistrare întreruperi în muncă [Document_InregistrareRetineriUnici] = [Document_InregistrareRetineriUnici].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InregistrareRetineriUnici].[_Date_Time]), 104), -- Document din Inregistrare rețineri unici [Document_InregistrareRetineriUnici_ID] = [Document_InregistrareRetineriUnici].[_IDRRef], -- KeyField din Inregistrare rețineri unici [Document_InregistrareSporuriUnici] = [Document_InregistrareSporuriUnici].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InregistrareSporuriUnici].[_Date_Time]), 104), -- Document din Înregistrare sporuri unici [Document_InregistrareSporuriUnici_ID] = [Document_InregistrareSporuriUnici].[_IDRRef], -- KeyField din Înregistrare sporuri unici [Document_OrdinInAcord] = [Document_OrdinInAcord].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_OrdinInAcord].[_Date_Time]), 104), -- Document din Ordin in acord [Document_OrdinInAcord_ID] = [Document_OrdinInAcord].[_IDRRef], -- KeyField din Ordin in acord [Document_PlataOreSuplimentare] = [Document_PlataOreSuplimentare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_PlataOreSuplimentare].[_Date_Time]), 104), -- Document din Plata ore suplimentare [Document_PlataOreSuplimentare_ID] = [Document_PlataOreSuplimentare].[_IDRRef], -- KeyField din Plata ore suplimentare [Document_Prime] = [Document_Prime].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Prime].[_Date_Time]), 104), -- Document din Prime [Document_Prime_ID] = [Document_Prime].[_IDRRef], -- KeyField din Prime [Document_ReincepereaActivitatii] = [Document_ReincepereaActivitatii].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ReincepereaActivitatii].[_Date_Time]), 104), -- Document din Reînceperea activității [Document_ReincepereaActivitatii_ID] = [Document_ReincepereaActivitatii].[_IDRRef], -- KeyField din Reînceperea activității [Document_TitluDeExecutare] = [Document_TitluDeExecutare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_TitluDeExecutare].[_Date_Time]), 104), -- Document din Titlu de executare [Document_TitluDeExecutare_ID] = [Document_TitluDeExecutare].[_IDRRef], -- KeyField din Titlu de executare [Document_ContractDeMunca] = [Document_ContractDeMunca].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ContractDeMunca].[_Date_Time]), 104), -- Document din Contract de muncă [Document_ContractDeMunca_ID] = [Document_ContractDeMunca].[_IDRRef], -- KeyField din Contract de muncă [Document_IntroducereaReduceri] = [Document_IntroducereaReduceri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_IntroducereaReduceri].[_Date_Time]), 104), -- Document din Introducerea reduceri [Document_IntroducereaReduceri_ID] = [Document_IntroducereaReduceri].[_IDRRef], -- KeyField din Introducerea reduceri [Document_IntroducereaRetineriPlanificate] = [Document_IntroducereaRetineriPlanificate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_IntroducereaRetineriPlanificate].[_Date_Time]), 104), -- Document din Întroducerea rețineri planificate [Document_IntroducereaRetineriPlanificate_ID] = [Document_IntroducereaRetineriPlanificate].[_IDRRef], -- KeyField din Întroducerea rețineri planificate [Document_IntroducereaRetineriSporuriPlanificate] = [Document_IntroducereaRetineriSporuriPlanificate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_IntroducereaRetineriSporuriPlanificate].[_Date_Time]), 104), -- Document din Întroducerea rețineri sporuri planificate [Document_IntroducereaRetineriSporuriPlanificate_ID] = [Document_IntroducereaRetineriSporuriPlanificate].[_IDRRef], -- KeyField din Întroducerea rețineri sporuri planificate [Document_IntroducereaSporuriPlanificate] = [Document_IntroducereaSporuriPlanificate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_IntroducereaSporuriPlanificate].[_Date_Time]), 104), -- Document din Întroducerea sporuri planificate [Document_IntroducereaSporuriPlanificate_ID] = [Document_IntroducereaSporuriPlanificate].[_IDRRef], -- KeyField din Întroducerea sporuri planificate [Document_RambursareaTicheteDeMasa] = [Document_RambursareaTicheteDeMasa].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_RambursareaTicheteDeMasa].[_Date_Time]), 104), -- Document din Rambursarea tichete de masă [Document_RambursareaTicheteDeMasa_ID] = [Document_RambursareaTicheteDeMasa].[_IDRRef], -- KeyField din Rambursarea tichete de masă [Document_FiscalizarePlansaDeNumereRegimSpecial] = [Document_FiscalizarePlansaDeNumereRegimSpecial].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_FiscalizarePlansaDeNumereRegimSpecial].[_Date_Time]), 104), -- Document din Fiscalizare planșe de numere regim special [Document_FiscalizarePlansaDeNumereRegimSpecial_ID] = [Document_FiscalizarePlansaDeNumereRegimSpecial].[_IDRRef], -- KeyField din Fiscalizare planșe de numere regim special [Document_CasareOI] = [Document_CasareOI].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CasareOI].[_Date_Time]), 104), -- Document din Casare obiecte de inventar [Document_CasareOI_ID] = [Document_CasareOI].[_IDRRef], -- KeyField din Casare obiecte de inventar [Document_DareInFolosinteOI] = [Document_DareInFolosinteOI].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_DareInFolosinteOI].[_Date_Time]), 104), -- Document din Dare în folosințe obiecte de inventar [Document_DareInFolosinteOI_ID] = [Document_DareInFolosinteOI].[_IDRRef], -- KeyField din Dare în folosințe obiecte de inventar [Document_InregistrareManualaInJurnalDeVanzari] = [Document_InregistrareManualaInJurnalDeVanzari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InregistrareManualaInJurnalDeVanzari].[_Date_Time]), 104), -- Document din Inregistrare manuală în jurnal de vanzari [Document_InregistrareManualaInJurnalDeVanzari_ID] = [Document_InregistrareManualaInJurnalDeVanzari].[_IDRRef], -- KeyField din Inregistrare manuală în jurnal de vanzari [Document_FoaiePrezenta] = [Document_FoaiePrezenta].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_FoaiePrezenta].[_Date_Time]), 104), -- Document din Foaie prezenta [Document_FoaiePrezenta_ID] = [Document_FoaiePrezenta].[_IDRRef], -- KeyField din Foaie prezenta [Document_AprovizionareMarfuriSiServiciiPrimite] = N'Factură achiziție ' + [Document_AprovizionareMarfuriSiServiciiPrimite].[_Fld629] + ' ' + [Document_AprovizionareMarfuriSiServiciiPrimite].[_Fld622] + ' din ' + convert(varchar(10), dateadd(year, -2000, [Document_AprovizionareMarfuriSiServiciiPrimite].[_Fld642]), 104), -- Document din Aprovizionare și servicii primite [Document_AprovizionareMarfuriSiServiciiPrimite_ID] = [Document_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef], -- KeyField din Aprovizionare și servicii primite [Document_AvizDeIesire] = N'Aviz de ieșire ' + [Document_AvizDeIesire].[_Fld743] + ' ' + [Document_AvizDeIesire].[_Fld744] + ' din ' + convert(varchar(10), dateadd(year, -2000, [Document_AvizDeIesire].[_Date_Time]), 104), -- Document din Aviz de ieșire [Document_AvizDeIesire_ID] = [Document_AvizDeIesire].[_IDRRef], -- KeyField din Aviz de ieșire [Document_AvizDeIntrare] = N'Aviz de intrare ' + coalesce(nullif(rtrim(ltrim([Document_AvizDeIntrare].[_Fld805])), '') + ' ', '') + coalesce(nullif(rtrim(ltrim([Document_AvizDeIntrare].[_Fld800])), ''), [Document_AvizDeIntrare].[_Number]) + ' din ' + convert(varchar(10), dateadd(year, -2000, [Document_AvizDeIntrare].[_Date_Time]), 104), -- Document din Aviz de intrare [Document_AvizDeIntrare_ID] = [Document_AvizDeIntrare].[_IDRRef], -- KeyField din Aviz de intrare [Document_IntroducereSoldurilorInformativeMagazin] = [Document_IntroducereSoldurilorInformativeMagazin].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_IntroducereSoldurilorInformativeMagazin].[_Date_Time]), 104), -- Document din Introducere soldurilor informative magazin [Document_IntroducereSoldurilorInformativeMagazin_ID] = [Document_IntroducereSoldurilorInformativeMagazin].[_IDRRef], -- KeyField din Introducere soldurilor informative magazin [Document_OrdinDeIncasare] = [Document_OrdinDeIncasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_OrdinDeIncasare].[_Date_Time]), 104), -- Document din Ordin de incasare [Document_OrdinDeIncasare_ID] = [Document_OrdinDeIncasare].[_IDRRef], -- KeyField din Ordin de incasare [Document_BonDeConsum] = N'Bon de consum ' + [Document_BonDeConsum].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_BonDeConsum].[_Date_Time]), 104), -- Document din Bon de consum [Document_BonDeConsum_ID] = [Document_BonDeConsum].[_IDRRef], -- KeyField din Bon de consum [Document_BonFiscal] = N'Bon fiscal ' + [Document_BonFiscal].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_BonFiscal].[_Date_Time]), 104), -- Document din Bon fiscal [Document_BonFiscal_ID] = [Document_BonFiscal].[_IDRRef], -- KeyField din Bon fiscal [Document_CalculImpozit] = [Document_CalculImpozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CalculImpozit].[_Date_Time]), 104), -- Document din Calcul impozit [Document_CalculImpozit_ID] = [Document_CalculImpozit].[_IDRRef], -- KeyField din Calcul impozit [Document_CasareImobNecorporale] = [Document_CasareImobNecorporale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CasareImobNecorporale].[_Date_Time]), 104), -- Document din Casare imobilizări necorporale [Document_CasareImobNecorporale_ID] = [Document_CasareImobNecorporale].[_IDRRef], -- KeyField din Casare imobilizări necorporale [Document_CasareMF] = [Document_CasareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CasareMF].[_Date_Time]), 104), -- Document din Casare MF [Document_CasareMF_ID] = [Document_CasareMF].[_IDRRef], -- KeyField din Casare MF [Document_ReevaluareMF] = [Document_ReevaluareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ReevaluareMF].[_Date_Time]), 104), -- Document din Reevaluare MF [Document_ReevaluareMF_ID] = [Document_ReevaluareMF].[_IDRRef], -- KeyField din Reevaluare MF [Document_CheltuieliSuplimentareLaAprovizionare] = [Document_CheltuieliSuplimentareLaAprovizionare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CheltuieliSuplimentareLaAprovizionare].[_Date_Time]), 104), -- Document din Cheltuieli suplimentare la aprovizionare [Document_CheltuieliSuplimentareLaAprovizionare_ID] = [Document_CheltuieliSuplimentareLaAprovizionare].[_IDRRef], -- KeyField din Cheltuieli suplimentare la aprovizionare [Document_Compensare] = N'Compensare ' + [Document_Compensare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Compensare].[_Date_Time]), 104), -- Document din Compensare [Document_Compensare_ID] = [Document_Compensare].[_IDRRef], -- KeyField din Compensare [Document_InchidereAnalitice] = [Document_InchidereAnalitice].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InchidereAnalitice].[_Date_Time]), 104), -- Document din Inchidere analitice [Document_InchidereAnalitice_ID] = [Document_InchidereAnalitice].[_IDRRef], -- KeyField din Inchidere analitice [Document_DecontDeAvans] = [Document_DecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_DecontDeAvans].[_Date_Time]), 104), -- Document din Decont de avans [Document_DecontDeAvans_ID] = [Document_DecontDeAvans].[_IDRRef], -- KeyField din Decont de avans [Document_Demisie] = [Document_Demisie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Demisie].[_Date_Time]), 104), -- Document din Reziliere contract de muncă [Document_Demisie_ID] = [Document_Demisie].[_IDRRef], -- KeyField din Reziliere contract de muncă [Document_DiminuareStocDeMarfuri] = [Document_DiminuareStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_DiminuareStocDeMarfuri].[_Date_Time]), 104), -- Document din Diminuare stoc de articole [Document_DiminuareStocDeMarfuri_ID] = [Document_DiminuareStocDeMarfuri].[_IDRRef], -- KeyField din Diminuare stoc de articole [Document_RegistersEditor] = [Document_RegistersEditor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_RegistersEditor].[_Date_Time]), 104), -- Document din Corectarea miscarilor registrului [Document_RegistersEditor_ID] = [Document_RegistersEditor].[_IDRRef], -- KeyField din Corectarea miscarilor registrului [Document_CorectieProcurari] = [Document_CorectieProcurari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CorectieProcurari].[_Date_Time]), 104), -- Document din Corecție Aprovizionări [Document_CorectieProcurari_ID] = [Document_CorectieProcurari].[_IDRRef], -- KeyField din Corecție Aprovizionări [Document_CorectieAnaliticiDecontDeAvans] = [Document_CorectieAnaliticiDecontDeAvans].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CorectieAnaliticiDecontDeAvans].[_Date_Time]), 104), -- Document din Corectie analitici decont de avans [Document_CorectieAnaliticiDecontDeAvans_ID] = [Document_CorectieAnaliticiDecontDeAvans].[_IDRRef], -- KeyField din Corectie analitici decont de avans [Document_EfecteDePlatit] = [Document_EfecteDePlatit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_EfecteDePlatit].[_Date_Time]), 104), -- Document din Efecte de plătit [Document_EfecteDePlatit_ID] = [Document_EfecteDePlatit].[_IDRRef], -- KeyField din Efecte de plătit [Document_EfecteDePrimit] = [Document_EfecteDePrimit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_EfecteDePrimit].[_Date_Time]), 104), -- Document din Efecte de primit [Document_EfecteDePrimit_ID] = [Document_EfecteDePrimit].[_IDRRef], -- KeyField din Efecte de primit [Document_ActAditional] = [Document_ActAditional].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ActAditional].[_Date_Time]), 104), -- Document din Act adțional la Contract [Document_ActAditional_ID] = [Document_ActAditional].[_IDRRef], -- KeyField din Act adțional la Contract [Document_CorectieAnaliticiRetur] = [Document_CorectieAnaliticiRetur].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_CorectieAnaliticiRetur].[_Date_Time]), 104), -- Document din Corectie analitici retur [Document_CorectieAnaliticiRetur_ID] = [Document_CorectieAnaliticiRetur].[_IDRRef], -- KeyField din Corectie analitici retur [Document_ProcesVerbalLivrariAmanunt] = [Document_ProcesVerbalLivrariAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ProcesVerbalLivrariAmanunt].[_Date_Time]), 104), -- Document din Proces Verbal de Livrari in Amanunt [Document_ProcesVerbalLivrariAmanunt_ID] = [Document_ProcesVerbalLivrariAmanunt].[_IDRRef], -- KeyField din Proces Verbal de Livrari in Amanunt [Document_ExtrasDeCont] = N'Extras de cont ' + [Document_ExtrasDeCont].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ExtrasDeCont].[_Date_Time]), 104), -- Document din Extras de cont [Document_ExtrasDeCont_ID] = [Document_ExtrasDeCont].[_IDRRef], -- KeyField din Extras de cont [Document_Import] = N'Import ' + [Document_Import].[_Fld1360] + ' ' + [Document_Import].[_Fld1353] + ' din ' + convert(varchar(10), dateadd(year, -2000, [Document_Import].[_Date_Time]), 104), -- Document din Import [Document_Import_ID] = [Document_Import].[_IDRRef], -- KeyField din Import [Document_ComandaClient] = [Document_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ComandaClient].[_Date_Time]), 104), -- Document din Comanda client [Document_ComandaClient_ID] = [Document_ComandaClient].[_IDRRef], -- KeyField din Comanda client [Document_Incasare] = N'Dispoziție de încasare ' + [Document_Incasare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Incasare].[_Date_Time]), 104) , -- Document din Dispoziție de încasare [Document_Incasare_ID] = [Document_Incasare].[_IDRRef], -- KeyField din Dispoziție de încasare [Document_InchidereLunaDeExercitiu] = N'Închidere lună de exercițiu ' + [Document_InchidereLunaDeExercitiu].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InchidereLunaDeExercitiu].[_Date_Time]), 104) , -- Document din Închidere lună de exercițiu [Document_InchidereLunaDeExercitiu_ID] = [Document_InchidereLunaDeExercitiu].[_IDRRef], -- KeyField din Închidere lună de exercițiu [Document_InregistrareManualaInJurnalDeCumparari] = [Document_InregistrareManualaInJurnalDeCumparari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InregistrareManualaInJurnalDeCumparari].[_Date_Time]), 104), -- Document din Inregistrare manuală în jurnal de cumpărări [Document_InregistrareManualaInJurnalDeCumparari_ID] = [Document_InregistrareManualaInJurnalDeCumparari].[_IDRRef], -- KeyField din Inregistrare manuală în jurnal de cumpărări [Document_IncasareCard] = [Document_IncasareCard].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_IncasareCard].[_Date_Time]), 104), -- Document din Incasare card [Document_IncasareCard_ID] = [Document_IncasareCard].[_IDRRef], -- KeyField din Incasare card [Document_IntroducereaSoldurilor] = [Document_IntroducereaSoldurilor].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_IntroducereaSoldurilor].[_Date_Time]), 104), -- Document din Introducere solduri [Document_IntroducereaSoldurilor_ID] = [Document_IntroducereaSoldurilor].[_IDRRef], -- KeyField din Introducere solduri [Document_IntroducereaSoldurilorAmanunt] = [Document_IntroducereaSoldurilorAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_IntroducereaSoldurilorAmanunt].[_Date_Time]), 104), -- Document din Introducere solduri amănunt [Document_IntroducereaSoldurilorAmanunt_ID] = [Document_IntroducereaSoldurilorAmanunt].[_IDRRef], -- KeyField din Introducere solduri amănunt [Document_IntroducereSolduriInitialeMF] = [Document_IntroducereSolduriInitialeMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_IntroducereSolduriInitialeMF].[_Date_Time]), 104), -- Document din Introducere solduri inițiale MF [Document_IntroducereSolduriInitialeMF_ID] = [Document_IntroducereSolduriInitialeMF].[_IDRRef], -- KeyField din Introducere solduri inițiale MF [Document_InventariereMarfuriInDepozit] = [Document_InventariereMarfuriInDepozit].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InventariereMarfuriInDepozit].[_Date_Time]), 104), -- Document din Inventariere articole [Document_InventariereMarfuriInDepozit_ID] = [Document_InventariereMarfuriInDepozit].[_IDRRef], -- KeyField din Inventariere articole [Document_InventariereMF] = [Document_InventariereMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InventariereMF].[_Date_Time]), 104), -- Document din Inventariere MF [Document_InventariereMF_ID] = [Document_InventariereMF].[_IDRRef], -- KeyField din Inventariere MF [Document_InventariereProductieNeterminata] = [Document_InventariereProductieNeterminata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_InventariereProductieNeterminata].[_Date_Time]), 104), -- Document din Inventariere producție neterminată [Document_InventariereProductieNeterminata_ID] = [Document_InventariereProductieNeterminata].[_IDRRef], -- KeyField din Inventariere producție neterminată [Document_MarireStocDeMarfuri] = [Document_MarireStocDeMarfuri].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_MarireStocDeMarfuri].[_Date_Time]), 104), -- Document din Mărire stoc de articole [Document_MarireStocDeMarfuri_ID] = [Document_MarireStocDeMarfuri].[_IDRRef], -- KeyField din Mărire stoc de articole [Document_ModernizareMF] = [Document_ModernizareMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ModernizareMF].[_Date_Time]), 104), -- Document din Modernizare MF [Document_ModernizareMF_ID] = [Document_ModernizareMF].[_IDRRef], -- KeyField din Modernizare MF [Document_NotaDeConfirmareSoldPartener] = [Document_NotaDeConfirmareSoldPartener].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_NotaDeConfirmareSoldPartener].[_Date_Time]), 104), -- Document din Notă de confirmare [Document_NotaDeConfirmareSoldPartener_ID] = [Document_NotaDeConfirmareSoldPartener].[_IDRRef], -- KeyField din Notă de confirmare [Document_Operatia] = N'Operație contabilă ' + [Document_Operatia].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Operatia].[_Date_Time]), 104) , -- Document din Operație contabilă [Document_Operatia_ID] = [Document_Operatia].[_IDRRef], -- KeyField din Operație contabilă [Document_OrdinDeAngajare] = [Document_OrdinDeAngajare].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_OrdinDeAngajare].[_Date_Time]), 104), -- Document din Contract de angajare [Document_OrdinDeAngajare_ID] = [Document_OrdinDeAngajare].[_IDRRef], -- KeyField din Contract de angajare [Document_OrdinDePlata] = [Document_OrdinDePlata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_OrdinDePlata].[_Date_Time]), 104), -- Document din Ordin de plată [Document_OrdinDePlata_ID] = [Document_OrdinDePlata].[_IDRRef], -- KeyField din Ordin de plată [Document_OrdineaDeInchidereDepartamente] = [Document_OrdineaDeInchidereDepartamente].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_OrdineaDeInchidereDepartamente].[_Date_Time]), 104), -- Document din Ordinea de închidere a departamentelor [Document_OrdineaDeInchidereDepartamente_ID] = [Document_OrdineaDeInchidereDepartamente].[_IDRRef], -- KeyField din Ordinea de închidere a departamentelor [Document_Partida] = [Document_Partida].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Partida].[_Date_Time]), 104), -- Document din Partida de mărfuri [Document_Partida_ID] = [Document_Partida].[_IDRRef], -- KeyField din Partida de mărfuri [Document_Plata] = N'Dispoziție de plată ' + [Document_Plata].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_Plata].[_Date_Time]), 104) , -- Document din Dispoziție de plată [Document_Plata_ID] = [Document_Plata].[_IDRRef], -- KeyField din Dispoziție de plată [Document_ProformaPentruClient] = [Document_ProformaPentruClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ProformaPentruClient].[_Date_Time]), 104), -- Document din Proforma client [Document_ProformaPentruClient_ID] = [Document_ProformaPentruClient].[_IDRRef], -- KeyField din Proforma client [Document_PunereaInEvidentaImobilizariNecorporale] = [Document_PunereaInEvidentaImobilizariNecorporale].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_PunereaInEvidentaImobilizariNecorporale].[_Date_Time]), 104), -- Document din Punere în evidență imobilizări necorporale [Document_PunereaInEvidentaImobilizariNecorporale_ID] = [Document_PunereaInEvidentaImobilizariNecorporale].[_IDRRef], -- KeyField din Punere în evidență imobilizări necorporale [Document_PunereaInEvidentaMF] = [Document_PunereaInEvidentaMF].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_PunereaInEvidentaMF].[_Date_Time]), 104), -- Document din Punere în evidență MF [Document_PunereaInEvidentaMF_ID] = [Document_PunereaInEvidentaMF].[_IDRRef], -- KeyField din Punere în evidență MF [Document_RapoarteReglementateExportate] = [Document_RapoarteReglementateExportate].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_RapoarteReglementateExportate].[_Date_Time]), 104), -- Document din Rapoarte reglementate descărcate [Document_RapoarteReglementateExportate_ID] = [Document_RapoarteReglementateExportate].[_IDRRef], -- KeyField din Rapoarte reglementate descărcate [Document_RaportComisionarDespreVanzari] = [Document_RaportComisionarDespreVanzari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_RaportComisionarDespreVanzari].[_Date_Time]), 104), -- Document din Raport comisionar despre vânzări [Document_RaportComisionarDespreVanzari_ID] = [Document_RaportComisionarDespreVanzari].[_IDRRef], -- KeyField din Raport comisionar despre vânzări [Document_RaportComitentDespreVanzari] = [Document_RaportComitentDespreVanzari].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_RaportComitentDespreVanzari].[_Date_Time]), 104), -- Document din Raport comitent despre vanzari [Document_RaportComitentDespreVanzari_ID] = [Document_RaportComitentDespreVanzari].[_IDRRef], -- KeyField din Raport comitent despre vanzari [Document_RaportDeProductie] = [Document_RaportDeProductie].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_RaportDeProductie].[_Date_Time]), 104), -- Document din Raport de producție [Document_RaportDeProductie_ID] = [Document_RaportDeProductie].[_IDRRef], -- KeyField din Raport de producție [Document_RaportDeVanzariCuAmanunt] = N'Raport de vânzări cu amănunt ' + [Document_RaportDeVanzariCuAmanunt].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_RaportDeVanzariCuAmanunt].[_Date_Time]), 104) , -- Document din Raport de vânzări cu amănunt [Document_RaportDeVanzariCuAmanunt_ID] = [Document_RaportDeVanzariCuAmanunt].[_IDRRef], -- KeyField din Raport de vânzări cu amănunt [Rezervari].* from [flax].[dbo].[_InfoRg7602] as [Rezervari] left join [flax].[dbo].[_Document100] as [Document_RaportReglementat] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000064 and [Rezervari].[_Fld7618_RRRef] = [Document_RaportReglementat].[_IDRRef]) left join [flax].[dbo].[_Document101] as [Document_ReturDeLaClient] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000065 and [Rezervari].[_Fld7618_RRRef] = [Document_ReturDeLaClient].[_IDRRef]) left join [flax].[dbo].[_Document102] as [Document_ReturLaFurnizor] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000066 and [Rezervari].[_Fld7618_RRRef] = [Document_ReturLaFurnizor].[_IDRRef]) left join [flax].[dbo].[_Document103] as [Document_Salarii] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000067 and [Rezervari].[_Fld7618_RRRef] = [Document_Salarii].[_IDRRef]) left join [flax].[dbo].[_Document104] as [Document_SchimbareaGraficAnualDeAmortizareMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000068 and [Rezervari].[_Fld7618_RRRef] = [Document_SchimbareaGraficAnualDeAmortizareMF].[_IDRRef]) left join [flax].[dbo].[_Document105] as [Document_SchimbareaParametrilorAmortizariiMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000069 and [Rezervari].[_Fld7618_RRRef] = [Document_SchimbareaParametrilorAmortizariiMF].[_IDRRef]) left join [flax].[dbo].[_Document106] as [Document_SchimbareaStareMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000006A and [Rezervari].[_Fld7618_RRRef] = [Document_SchimbareaStareMF].[_IDRRef]) left join [flax].[dbo].[_Document107] as [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000006B and [Rezervari].[_Fld7618_RRRef] = [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareImobNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document108] as [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000006C and [Rezervari].[_Fld7618_RRRef] = [Document_SchimbareMetodaDeAfisareCheltuielilorDeAmortizareMF].[_IDRRef]) left join [flax].[dbo].[_Document109] as [Document_SchimbarePretAmanunt] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000006D and [Rezervari].[_Fld7618_RRRef] = [Document_SchimbarePretAmanunt].[_IDRRef]) left join [flax].[dbo].[_Document110] as [Document_SchimbarePretNomenclator] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000006E and [Rezervari].[_Fld7618_RRRef] = [Document_SchimbarePretNomenclator].[_IDRRef]) left join [flax].[dbo].[_Document111] as [Document_SchimbarePretNomenclatorPartener] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000006F and [Rezervari].[_Fld7618_RRRef] = [Document_SchimbarePretNomenclatorPartener].[_IDRRef]) left join [flax].[dbo].[_Document112] as [Document_Stornare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000070 and [Rezervari].[_Fld7618_RRRef] = [Document_Stornare].[_IDRRef]) left join [flax].[dbo].[_Document113] as [Document_TransferCadreInOrganizatiile] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000071 and [Rezervari].[_Fld7618_RRRef] = [Document_TransferCadreInOrganizatiile].[_IDRRef]) left join [flax].[dbo].[_Document114] as [Document_TransferDeMarfuri] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000072 and [Rezervari].[_Fld7618_RRRef] = [Document_TransferDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document115] as [Document_TransferMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000073 and [Rezervari].[_Fld7618_RRRef] = [Document_TransferMF].[_IDRRef]) left join [flax].[dbo].[_Document116] as [Document_TransferUtilajPentruMontare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000074 and [Rezervari].[_Fld7618_RRRef] = [Document_TransferUtilajPentruMontare].[_IDRRef]) left join [flax].[dbo].[_Document117] as [Document_VanzareMarfuriSiServiciiPrestate] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000075 and [Rezervari].[_Fld7618_RRRef] = [Document_VanzareMarfuriSiServiciiPrestate].[_IDRRef]) left join [flax].[dbo].[_Document3363] as [Document_Absente] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D23 and [Rezervari].[_Fld7618_RRRef] = [Document_Absente].[_IDRRef]) left join [flax].[dbo].[_Document3364] as [Document_AbsenteLaLucru] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D24 and [Rezervari].[_Fld7618_RRRef] = [Document_AbsenteLaLucru].[_IDRRef]) left join [flax].[dbo].[_Document3365] as [Document_Asamblare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D25 and [Rezervari].[_Fld7618_RRRef] = [Document_Asamblare].[_IDRRef]) left join [flax].[dbo].[_Document3366] as [Document_CalculareConcediiDeOdihna] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D26 and [Rezervari].[_Fld7618_RRRef] = [Document_CalculareConcediiDeOdihna].[_IDRRef]) left join [flax].[dbo].[_Document3367] as [Document_CalculareConcediiMedicale] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D27 and [Rezervari].[_Fld7618_RRRef] = [Document_CalculareConcediiMedicale].[_IDRRef]) left join [flax].[dbo].[_Document3369] as [Document_CalculareLaEliberareDinFunctie] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D29 and [Rezervari].[_Fld7618_RRRef] = [Document_CalculareLaEliberareDinFunctie].[_IDRRef]) left join [flax].[dbo].[_Document3370] as [Document_CalculareSalarii] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D2A and [Rezervari].[_Fld7618_RRRef] = [Document_CalculareSalarii].[_IDRRef]) left join [flax].[dbo].[_Document3371] as [Document_ComandaDeviz] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D2B and [Rezervari].[_Fld7618_RRRef] = [Document_ComandaDeviz].[_IDRRef]) left join [flax].[dbo].[_Document3372] as [Document_ComandaService] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D2C and [Rezervari].[_Fld7618_RRRef] = [Document_ComandaService].[_IDRRef]) left join [flax].[dbo].[_Document3373] as [Document_ConcediiDeOdihna] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D2D and [Rezervari].[_Fld7618_RRRef] = [Document_ConcediiDeOdihna].[_IDRRef]) left join [flax].[dbo].[_Document3374] as [Document_CorectareRegistrelorDeAcumulare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D2E and [Rezervari].[_Fld7618_RRRef] = [Document_CorectareRegistrelorDeAcumulare].[_IDRRef]) left join [flax].[dbo].[_Document3375] as [Document_CorectareTimpDeLucruAngajati] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D2F and [Rezervari].[_Fld7618_RRRef] = [Document_CorectareTimpDeLucruAngajati].[_IDRRef]) left join [flax].[dbo].[_Document3376] as [Document_Deplasari] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D30 and [Rezervari].[_Fld7618_RRRef] = [Document_Deplasari].[_IDRRef]) left join [flax].[dbo].[_Document3377] as [Document_Dezasamblare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D31 and [Rezervari].[_Fld7618_RRRef] = [Document_Dezasamblare].[_IDRRef]) left join [flax].[dbo].[_Document3378] as [Document_Export] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D32 and [Rezervari].[_Fld7618_RRRef] = [Document_Export].[_IDRRef]) left join [flax].[dbo].[_Document3379] as [Document_InregistrareIntreruperiInMunca] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D33 and [Rezervari].[_Fld7618_RRRef] = [Document_InregistrareIntreruperiInMunca].[_IDRRef]) left join [flax].[dbo].[_Document3380] as [Document_InregistrareRetineriUnici] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D34 and [Rezervari].[_Fld7618_RRRef] = [Document_InregistrareRetineriUnici].[_IDRRef]) left join [flax].[dbo].[_Document3381] as [Document_InregistrareSporuriUnici] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D35 and [Rezervari].[_Fld7618_RRRef] = [Document_InregistrareSporuriUnici].[_IDRRef]) left join [flax].[dbo].[_Document3382] as [Document_OrdinInAcord] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D36 and [Rezervari].[_Fld7618_RRRef] = [Document_OrdinInAcord].[_IDRRef]) left join [flax].[dbo].[_Document3383] as [Document_PlataOreSuplimentare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D37 and [Rezervari].[_Fld7618_RRRef] = [Document_PlataOreSuplimentare].[_IDRRef]) left join [flax].[dbo].[_Document3386] as [Document_Prime] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D3A and [Rezervari].[_Fld7618_RRRef] = [Document_Prime].[_IDRRef]) left join [flax].[dbo].[_Document3387] as [Document_ReincepereaActivitatii] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D3B and [Rezervari].[_Fld7618_RRRef] = [Document_ReincepereaActivitatii].[_IDRRef]) left join [flax].[dbo].[_Document3388] as [Document_TitluDeExecutare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000D3C and [Rezervari].[_Fld7618_RRRef] = [Document_TitluDeExecutare].[_IDRRef]) left join [flax].[dbo].[_Document4656] as [Document_ContractDeMunca] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001230 and [Rezervari].[_Fld7618_RRRef] = [Document_ContractDeMunca].[_IDRRef]) left join [flax].[dbo].[_Document4657] as [Document_IntroducereaReduceri] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001231 and [Rezervari].[_Fld7618_RRRef] = [Document_IntroducereaReduceri].[_IDRRef]) left join [flax].[dbo].[_Document4658] as [Document_IntroducereaRetineriPlanificate] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001232 and [Rezervari].[_Fld7618_RRRef] = [Document_IntroducereaRetineriPlanificate].[_IDRRef]) left join [flax].[dbo].[_Document4659] as [Document_IntroducereaRetineriSporuriPlanificate] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001233 and [Rezervari].[_Fld7618_RRRef] = [Document_IntroducereaRetineriSporuriPlanificate].[_IDRRef]) left join [flax].[dbo].[_Document4660] as [Document_IntroducereaSporuriPlanificate] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001234 and [Rezervari].[_Fld7618_RRRef] = [Document_IntroducereaSporuriPlanificate].[_IDRRef]) left join [flax].[dbo].[_Document4661] as [Document_RambursareaTicheteDeMasa] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001235 and [Rezervari].[_Fld7618_RRRef] = [Document_RambursareaTicheteDeMasa].[_IDRRef]) left join [flax].[dbo].[_Document5212] as [Document_FiscalizarePlansaDeNumereRegimSpecial] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000145C and [Rezervari].[_Fld7618_RRRef] = [Document_FiscalizarePlansaDeNumereRegimSpecial].[_IDRRef]) left join [flax].[dbo].[_Document5338] as [Document_CasareOI] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x000014DA and [Rezervari].[_Fld7618_RRRef] = [Document_CasareOI].[_IDRRef]) left join [flax].[dbo].[_Document5339] as [Document_DareInFolosinteOI] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x000014DB and [Rezervari].[_Fld7618_RRRef] = [Document_DareInFolosinteOI].[_IDRRef]) left join [flax].[dbo].[_Document5340] as [Document_InregistrareManualaInJurnalDeVanzari] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x000014DC and [Rezervari].[_Fld7618_RRRef] = [Document_InregistrareManualaInJurnalDeVanzari].[_IDRRef]) left join [flax].[dbo].[_Document5438] as [Document_FoaiePrezenta] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000153E and [Rezervari].[_Fld7618_RRRef] = [Document_FoaiePrezenta].[_IDRRef]) left join [flax].[dbo].[_Document56] as [Document_AprovizionareMarfuriSiServiciiPrimite] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000038 and [Rezervari].[_Fld7618_RRRef] = [Document_AprovizionareMarfuriSiServiciiPrimite].[_IDRRef]) left join [flax].[dbo].[_Document57] as [Document_AvizDeIesire] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000039 and [Rezervari].[_Fld7618_RRRef] = [Document_AvizDeIesire].[_IDRRef]) left join [flax].[dbo].[_Document58] as [Document_AvizDeIntrare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000003A and [Rezervari].[_Fld7618_RRRef] = [Document_AvizDeIntrare].[_IDRRef]) left join [flax].[dbo].[_Document5860] as [Document_IntroducereSoldurilorInformativeMagazin] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x000016E4 and [Rezervari].[_Fld7618_RRRef] = [Document_IntroducereSoldurilorInformativeMagazin].[_IDRRef]) left join [flax].[dbo].[_Document5861] as [Document_OrdinDeIncasare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x000016E5 and [Rezervari].[_Fld7618_RRRef] = [Document_OrdinDeIncasare].[_IDRRef]) left join [flax].[dbo].[_Document59] as [Document_BonDeConsum] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000003B and [Rezervari].[_Fld7618_RRRef] = [Document_BonDeConsum].[_IDRRef]) left join [flax].[dbo].[_Document60] as [Document_BonFiscal] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000003C and [Rezervari].[_Fld7618_RRRef] = [Document_BonFiscal].[_IDRRef]) left join [flax].[dbo].[_Document61] as [Document_CalculImpozit] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000003D and [Rezervari].[_Fld7618_RRRef] = [Document_CalculImpozit].[_IDRRef]) left join [flax].[dbo].[_Document62] as [Document_CasareImobNecorporale] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000003E and [Rezervari].[_Fld7618_RRRef] = [Document_CasareImobNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document63] as [Document_CasareMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000003F and [Rezervari].[_Fld7618_RRRef] = [Document_CasareMF].[_IDRRef]) left join [flax].[dbo].[_Document6336] as [Document_ReevaluareMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x000018C0 and [Rezervari].[_Fld7618_RRRef] = [Document_ReevaluareMF].[_IDRRef]) left join [flax].[dbo].[_Document64] as [Document_CheltuieliSuplimentareLaAprovizionare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000040 and [Rezervari].[_Fld7618_RRRef] = [Document_CheltuieliSuplimentareLaAprovizionare].[_IDRRef]) left join [flax].[dbo].[_Document65] as [Document_Compensare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000041 and [Rezervari].[_Fld7618_RRRef] = [Document_Compensare].[_IDRRef]) left join [flax].[dbo].[_Document6640] as [Document_InchidereAnalitice] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x000019F0 and [Rezervari].[_Fld7618_RRRef] = [Document_InchidereAnalitice].[_IDRRef]) left join [flax].[dbo].[_Document67] as [Document_DecontDeAvans] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000043 and [Rezervari].[_Fld7618_RRRef] = [Document_DecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document68] as [Document_Demisie] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000044 and [Rezervari].[_Fld7618_RRRef] = [Document_Demisie].[_IDRRef]) left join [flax].[dbo].[_Document69] as [Document_DiminuareStocDeMarfuri] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000045 and [Rezervari].[_Fld7618_RRRef] = [Document_DiminuareStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document6936] as [Document_RegistersEditor] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001B18 and [Rezervari].[_Fld7618_RRRef] = [Document_RegistersEditor].[_IDRRef]) left join [flax].[dbo].[_Document6988] as [Document_CorectieProcurari] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001B4C and [Rezervari].[_Fld7618_RRRef] = [Document_CorectieProcurari].[_IDRRef]) left join [flax].[dbo].[_Document6989] as [Document_CorectieAnaliticiDecontDeAvans] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001B4D and [Rezervari].[_Fld7618_RRRef] = [Document_CorectieAnaliticiDecontDeAvans].[_IDRRef]) left join [flax].[dbo].[_Document70] as [Document_EfecteDePlatit] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000046 and [Rezervari].[_Fld7618_RRRef] = [Document_EfecteDePlatit].[_IDRRef]) left join [flax].[dbo].[_Document71] as [Document_EfecteDePrimit] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000047 and [Rezervari].[_Fld7618_RRRef] = [Document_EfecteDePrimit].[_IDRRef]) left join [flax].[dbo].[_Document7108] as [Document_ActAditional] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001BC4 and [Rezervari].[_Fld7618_RRRef] = [Document_ActAditional].[_IDRRef]) left join [flax].[dbo].[_Document7109] as [Document_CorectieAnaliticiRetur] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001BC5 and [Rezervari].[_Fld7618_RRRef] = [Document_CorectieAnaliticiRetur].[_IDRRef]) left join [flax].[dbo].[_Document7110] as [Document_ProcesVerbalLivrariAmanunt] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001BC6 and [Rezervari].[_Fld7618_RRRef] = [Document_ProcesVerbalLivrariAmanunt].[_IDRRef]) left join [flax].[dbo].[_Document72] as [Document_ExtrasDeCont] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000048 and [Rezervari].[_Fld7618_RRRef] = [Document_ExtrasDeCont].[_IDRRef]) left join [flax].[dbo].[_Document73] as [Document_Import] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000049 and [Rezervari].[_Fld7618_RRRef] = [Document_Import].[_IDRRef]) left join [flax].[dbo].[_Document7382] as [Document_ComandaClient] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001CD6 and [Rezervari].[_Fld7618_RRRef] = [Document_ComandaClient].[_IDRRef]) left join [flax].[dbo].[_Document74] as [Document_Incasare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000004A and [Rezervari].[_Fld7618_RRRef] = [Document_Incasare].[_IDRRef]) left join [flax].[dbo].[_Document75] as [Document_InchidereLunaDeExercitiu] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000004B and [Rezervari].[_Fld7618_RRRef] = [Document_InchidereLunaDeExercitiu].[_IDRRef]) left join [flax].[dbo].[_Document76] as [Document_InregistrareManualaInJurnalDeCumparari] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000004C and [Rezervari].[_Fld7618_RRRef] = [Document_InregistrareManualaInJurnalDeCumparari].[_IDRRef]) left join [flax].[dbo].[_Document7633] as [Document_IncasareCard] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001DD1 and [Rezervari].[_Fld7618_RRRef] = [Document_IncasareCard].[_IDRRef]) left join [flax].[dbo].[_Document77] as [Document_IntroducereaSoldurilor] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000004D and [Rezervari].[_Fld7618_RRRef] = [Document_IntroducereaSoldurilor].[_IDRRef]) left join [flax].[dbo].[_Document78] as [Document_IntroducereaSoldurilorAmanunt] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000004E and [Rezervari].[_Fld7618_RRRef] = [Document_IntroducereaSoldurilorAmanunt].[_IDRRef]) left join [flax].[dbo].[_Document79] as [Document_IntroducereSolduriInitialeMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000004F and [Rezervari].[_Fld7618_RRRef] = [Document_IntroducereSolduriInitialeMF].[_IDRRef]) left join [flax].[dbo].[_Document80] as [Document_InventariereMarfuriInDepozit] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000050 and [Rezervari].[_Fld7618_RRRef] = [Document_InventariereMarfuriInDepozit].[_IDRRef]) left join [flax].[dbo].[_Document81] as [Document_InventariereMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000051 and [Rezervari].[_Fld7618_RRRef] = [Document_InventariereMF].[_IDRRef]) left join [flax].[dbo].[_Document82] as [Document_InventariereProductieNeterminata] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000052 and [Rezervari].[_Fld7618_RRRef] = [Document_InventariereProductieNeterminata].[_IDRRef]) left join [flax].[dbo].[_Document83] as [Document_MarireStocDeMarfuri] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000053 and [Rezervari].[_Fld7618_RRRef] = [Document_MarireStocDeMarfuri].[_IDRRef]) left join [flax].[dbo].[_Document84] as [Document_ModernizareMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000054 and [Rezervari].[_Fld7618_RRRef] = [Document_ModernizareMF].[_IDRRef]) left join [flax].[dbo].[_Document85] as [Document_NotaDeConfirmareSoldPartener] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000055 and [Rezervari].[_Fld7618_RRRef] = [Document_NotaDeConfirmareSoldPartener].[_IDRRef]) left join [flax].[dbo].[_Document86] as [Document_Operatia] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000056 and [Rezervari].[_Fld7618_RRRef] = [Document_Operatia].[_IDRRef]) left join [flax].[dbo].[_Document87] as [Document_OrdinDeAngajare] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000057 and [Rezervari].[_Fld7618_RRRef] = [Document_OrdinDeAngajare].[_IDRRef]) left join [flax].[dbo].[_Document88] as [Document_OrdinDePlata] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000058 and [Rezervari].[_Fld7618_RRRef] = [Document_OrdinDePlata].[_IDRRef]) left join [flax].[dbo].[_Document89] as [Document_OrdineaDeInchidereDepartamente] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000059 and [Rezervari].[_Fld7618_RRRef] = [Document_OrdineaDeInchidereDepartamente].[_IDRRef]) left join [flax].[dbo].[_Document90] as [Document_Partida] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000005A and [Rezervari].[_Fld7618_RRRef] = [Document_Partida].[_IDRRef]) left join [flax].[dbo].[_Document91] as [Document_Plata] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000005B and [Rezervari].[_Fld7618_RRRef] = [Document_Plata].[_IDRRef]) left join [flax].[dbo].[_Document92] as [Document_ProformaPentruClient] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000005C and [Rezervari].[_Fld7618_RRRef] = [Document_ProformaPentruClient].[_IDRRef]) left join [flax].[dbo].[_Document93] as [Document_PunereaInEvidentaImobilizariNecorporale] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000005D and [Rezervari].[_Fld7618_RRRef] = [Document_PunereaInEvidentaImobilizariNecorporale].[_IDRRef]) left join [flax].[dbo].[_Document94] as [Document_PunereaInEvidentaMF] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000005E and [Rezervari].[_Fld7618_RRRef] = [Document_PunereaInEvidentaMF].[_IDRRef]) left join [flax].[dbo].[_Document95] as [Document_RapoarteReglementateExportate] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x0000005F and [Rezervari].[_Fld7618_RRRef] = [Document_RapoarteReglementateExportate].[_IDRRef]) left join [flax].[dbo].[_Document96] as [Document_RaportComisionarDespreVanzari] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000060 and [Rezervari].[_Fld7618_RRRef] = [Document_RaportComisionarDespreVanzari].[_IDRRef]) left join [flax].[dbo].[_Document97] as [Document_RaportComitentDespreVanzari] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000061 and [Rezervari].[_Fld7618_RRRef] = [Document_RaportComitentDespreVanzari].[_IDRRef]) left join [flax].[dbo].[_Document98] as [Document_RaportDeProductie] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000062 and [Rezervari].[_Fld7618_RRRef] = [Document_RaportDeProductie].[_IDRRef]) left join [flax].[dbo].[_Document99] as [Document_RaportDeVanzariCuAmanunt] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00000063 and [Rezervari].[_Fld7618_RRRef] = [Document_RaportDeVanzariCuAmanunt].[_IDRRef])
Câmpul Line
Nume Câmp în baza de date : _Fld7619
Descriere Câmp : Line
Tip Câmp : decimal
Guid Atribut Id
- Configurație : 7af526b7-18dd-4c68-9997-1c87501a07c4
- Bază de date : 0x99971C87501A07C44C6818DD7AF526B7
Câmpul Cant
Nume Câmp în baza de date : _Fld7606
Descriere Câmp : Cant
Tip Câmp : decimal
Guid Atribut Id
- Configurație : 31beaf0b-14a1-42dd-8a3c-bf3512ec82df
- Bază de date : 0x8A3CBF3512EC82DF42DD14A131BEAF0B
Câmpul SimpleKey
- Nume Câmp în baza de date : _SimpleKey
- Descriere Câmp : Keye simpla pentru registrul de informatii
- Tip Câmp : binary
Full Sql Select
Exemplu de apel pentru obiectul curent din baza sursa
select [Articol] = [Articol_Nomenclator]._Description, -- Articol din Nomenclator de articole [Articol_ID] = [Articol_Nomenclator].[_IDRRef], -- KeyField din Nomenclator de articole [Depozit] = [Depozit_Depozite]._Description, -- Depozit din Depozite [Depozit_ID] = [Depozit_Depozite].[_IDRRef], -- KeyField din Depozite [Comanda] = [Comanda_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Comanda_ComandaClient].[_Date_Time]), 104), -- Comanda din Comanda client [Comanda_ID] = [Comanda_ComandaClient].[_IDRRef], -- KeyField din Comanda client [Document_Id] = [Rezervari].[_Fld7618_RRRef], -- Document [Document_Type] = [Rezervari].[_Fld7618_RTRef], -- Document [Document_Desc] = case [Rezervari].[_Fld7618_RTRef] -- DescriereDocument when 0x00001CD6 then [Document_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ComandaClient].[_Date_Time]), 104) -- Document din Comanda client else null end, -- Valoare necompletata [Document_No] = case [Rezervari].[_Fld7618_RTRef] -- DescriereDocument when 0x00001CD6 then [Document_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ComandaClient].[_Date_Time]), 104) -- Document din Comanda client else null end, -- Valoare necompletata [Document_ComandaClient] = [Document_ComandaClient].[_Number] + '/' + convert(varchar(10), dateadd(year, -2000, [Document_ComandaClient].[_Date_Time]), 104), -- Document din Comanda client [Document_ComandaClient_ID] = [Document_ComandaClient].[_IDRRef], -- KeyField din Comanda client [Line] = [Rezervari].[_Fld7619], -- Line [Cant] = [Rezervari].[_Fld7606], -- Cant [SimpleKey] = [Rezervari].[_SimpleKey] -- Keye simpla pentru registrul de informatii from [flax].[dbo].[_InfoRg7602] as [Rezervari] left join [flax].[dbo].[_Reference32] as [Articol_Nomenclator] on ([Rezervari].[_Fld7603RRef] = [Articol_Nomenclator].[_IDRRef]) left join [flax].[dbo].[_Reference19] as [Depozit_Depozite] on ([Rezervari].[_Fld7604RRef] = [Depozit_Depozite].[_IDRRef]) left join [flax].[dbo].[_Document7382] as [Comanda_ComandaClient] on ([Rezervari].[_Fld7605RRef] = [Comanda_ComandaClient].[_IDRRef]) left join [flax].[dbo].[_Document7382] as [Document_ComandaClient] on ([Rezervari].[_Fld7618_TYPE] = 0x08 and [Rezervari].[_Fld7618_RTRef] = 0x00001CD6 and [Rezervari].[_Fld7618_RRRef] = [Document_ComandaClient].[_IDRRef])
Full View Select Sql with fields
Exemplu de apel pentru view-ul asociat obiectul curent din baza destinatie cu câmpuri
select [Articol], --Articol din Nomenclator de articole [Articol_ID], --Articol din Nomenclator de articole ID [Depozit], --Depozit din Depozite [Depozit_ID], --Depozit din Depozite ID [Comanda], --Comanda din Comanda client [Comanda_ID], --Comanda din Comanda client ID [Document_Id], --Document [Document_Type], --Document [Document_Desc], --Document [Document_No], --Document [Document_ComandaClient], --Document din Comanda client [Document_ComandaClient_ID],--Document din Comanda client ID [Line], --Line [Cant], --Cant [SimpleKey] --Keye simpla pentru registrul de informatii from [flax].[InfoRg_Rezervari] -- Rezervari
Full View Select Sql
Exemplu de apel pentru view-ul asociat obiectul curent din baza destinatie fără câmpuri
select * from [flax].[InfoRg_Rezervari] -- Rezervari