Difference between revisions of "Export carduri angajati"
Cosmin Maxim (talk | contribs) (→Filtre) |
|||
| (42 intermediate revisions by 9 users not shown) | |||
| Line 4: | Line 4: | ||
****Export Carduri | ****Export Carduri | ||
| − | + | ===Tipuri export=== | |
Export sume platite pe card pentru salarii angajati in urmatoarele formate: | Export sume platite pe card pentru salarii angajati in urmatoarele formate: | ||
| − | :- Export carduri ALPHA BANK (.csv) | + | :- Export carduri ALPHA BANK (.csv) - Separator: ,~, |
| − | :- Export carduri ALPHA BANK (.txt) | + | :- Export carduri ALPHA BANK (.txt) - Separator: | |
| + | :- Export carduri ALPHA BANK 2 (.txt) - Se foloseste codul extern - codul IBAN de pe angajat; Separator: ~ | ||
:- Export carduri BANCPOST (.txt) | :- Export carduri BANCPOST (.txt) | ||
:- Export carduri BCR (.csv) | :- Export carduri BCR (.csv) | ||
:- Export carduri BCR 2 (.csv) | :- Export carduri BCR 2 (.csv) | ||
:- Export carduri BCR 3 (.csv) | :- Export carduri BCR 3 (.csv) | ||
| + | :- Export carduri BCR 4 (.csv) | ||
:- Export carduri BRD (.csv) | :- Export carduri BRD (.csv) | ||
| + | :- Export carduri BRD 2 (.csv) | ||
| + | :- Export carduri BRD 3 (.csv) | ||
| + | :- Export carduri BRD 4 (.csv) | ||
| + | :- Export carduri BRD 5 (.csv) | ||
:- Export carduri BRD (.txt) | :- Export carduri BRD (.txt) | ||
| + | :- Export carduri CEC BANK(.csv) | ||
| + | :- Export carduri CEC BANK 2(.csv) | ||
| + | :- Export carduri CEC BANK XLSX(.xlsx) | ||
| + | :- Export carduri CEC BANK 4(.csv) | ||
:- Export carduri CITI (.txt) | :- Export carduri CITI (.txt) | ||
:- Export carduri e-BCR+(.csv) | :- Export carduri e-BCR+(.csv) | ||
| Line 21: | Line 31: | ||
:- Export carduri Plata multipla ING (.txt) | :- Export carduri Plata multipla ING (.txt) | ||
:- Export carduri RAIFFEISEN (.csv) | :- Export carduri RAIFFEISEN (.csv) | ||
| + | :- Export carduri RAIFFEISEN 2 (.csv) | ||
| + | :- Export carduri RAIFFEISEN 3 (.txt) | ||
| + | :- Export carduri RAIFFEISEN 4 (.txt) | ||
| + | :- Export carduri RAIFFEISEN 5 (.txt) | ||
| + | :- Export carduri RAIFFEISEN 6 (.txt) | ||
| + | :- Export carduri RAIFFEISEN 7 (.csv) | ||
| + | :- Export carduri RAIFFEISEN 8 (.txt) | ||
| + | :- Export carduri RAIFFEISEN 9 (.xlsx) | ||
| + | :- Export carduri RAIFFEISEN 10 (.xlsx) | ||
| + | :- Export carduri RAIFFEISEN 11 (.xlsx) | ||
| + | :- Export carduri Retineri RAIFFEISEN (.csv) | ||
| + | :- Export carduri Retineri TRANSILVANIA (.csv) | ||
:- Export carduri TRANSILVANIA (.csv) | :- Export carduri TRANSILVANIA (.csv) | ||
:- Export carduri TRANSILVANIA 2 (.xls) | :- Export carduri TRANSILVANIA 2 (.xls) | ||
| + | :- Export carduri TRANSILVANIA 3 (.csv) | ||
| + | :- Export carduri TRANSILVANIA 4 (.csv) | ||
| + | :- Export carduri TRANSILVANIA 5 (.csv) | ||
| + | :- Export carduri TRANSILVANIA 8 (.csv) | ||
| + | :- Export carduri TRANSILVANIA 9 (.csv) | ||
| + | :- Export carduri TRANSILVANIA 10 (.csv): la fel ca transilvania 2 dar aduce suma in valuta | ||
| + | :- Export carduri TRANSILVANIA 11 (.csv): la fel ca transilvania 8 dar aduce suma in valuta | ||
| + | :- Export carduri TRANSILVANIA 12 (.csv) | ||
| + | :- Export carduri TRANSILVANIA 13 (.csv) | ||
| + | :- Export carduri TRANSILVANIA 14 (.csv) | ||
:- Export carduri UNICREDIT (.csv) | :- Export carduri UNICREDIT (.csv) | ||
| + | :- Export carduri UNICREDIT 2 (.txt) | ||
| + | :- Export carduri UNICREDIT XML (.xml) | ||
| + | :- Export carduri UNICREDIT XML 2 (.xml) | ||
:- Export carduri VENETO (.csv) | :- Export carduri VENETO (.csv) | ||
:- Export carduri BANCA ROMANEASCA (.csv) | :- Export carduri BANCA ROMANEASCA (.csv) | ||
| Line 29: | Line 64: | ||
:- Export carduri ING 2 (.csv) | :- Export carduri ING 2 (.csv) | ||
:- Export carduri ING 3 (.txt) | :- Export carduri ING 3 (.txt) | ||
| + | :- Export carduri ING 4 (.txt) | ||
| + | :- Export carduri ING 5 (.txt) | ||
| + | :- Export carduri ING 6 (.csv) | ||
:- Export carduri BANCA FEROVIARA (.txt) | :- Export carduri BANCA FEROVIARA (.txt) | ||
:- Export carduri Plata multipla BRD (.roi) | :- Export carduri Plata multipla BRD (.roi) | ||
:- Export carduri OTP (.csv) | :- Export carduri OTP (.csv) | ||
| − | + | :- Export carduri VISTA (.csv) | |
| + | ;- Export carduri Banca Romaneasca - xml (.xml) | ||
| + | :- Export carduri Retineri Techventures (.txt) | ||
| + | :- Export carduri Retineri Techventures 2 (.csv) | ||
| + | :- Export carduri Techventures (.csv) | ||
===Lista=== | ===Lista=== | ||
| Line 47: | Line 89: | ||
;Expresie:Se exporta sumele determinate de formula scrisa | ;Expresie:Se exporta sumele determinate de formula scrisa | ||
;Cont bancar firma:Se va completa in fisier la cont firma (pentru fisierele care includ in structura acest camp) | ;Cont bancar firma:Se va completa in fisier la cont firma (pentru fisierele care includ in structura acest camp) | ||
| + | ;Valuta | ||
;Format fisier | ;Format fisier | ||
;Explicatii | ;Explicatii | ||
| Line 53: | Line 96: | ||
;Loc plata | ;Loc plata | ||
;Departament | ;Departament | ||
| + | ;Tip contract angajat : Filtreaza dupa tipul contractului | ||
| + | ;Stergere exporturi generate: folosit pentru a sterge toate exporturile generate in perioada filtrata si pe formatul selectat | ||
| + | ;Reinitializare export: se anuleaza exporturile care nu se afla in xml-ul creat la salvare si nici in tabela temporara creata pe baza xml-ului anterior mentionat. | ||
| + | ;Tip comision: apare doar atunci cand formatul are un tip de comision setat pe el | ||
===Coloane=== | ===Coloane=== | ||
;Persoana | ;Persoana | ||
| + | ;Beneficiar: coloana disponibila doar in cazul fisierelor cu bifa de 'Retinere' selectata | ||
;Banca | ;Banca | ||
;Cont bancar | ;Cont bancar | ||
| + | ;Cod Extern | ||
;Contract | ;Contract | ||
;CNP | ;CNP | ||
;Suma | ;Suma | ||
| + | ;Suma platita | ||
| + | ;Diferenta | ||
| + | ;Plata urgenta: apare doar daca pe formatul selectat este pusa bifa "Are plata urgenta" | ||
;Selectare:Se exporta doar inregistrarile selectate | ;Selectare:Se exporta doar inregistrarile selectate | ||
===Operatii globale=== | ===Operatii globale=== | ||
;Lista fisiere: Lista de unde se pot descarca fisierele generate | ;Lista fisiere: Lista de unde se pot descarca fisierele generate | ||
Latest revision as of 12:20, 13 November 2024
- Resurse umane
- Salarizare
- Rapoarte
- Export Carduri
- Rapoarte
- Salarizare
Tipuri export
Export sume platite pe card pentru salarii angajati in urmatoarele formate:
- - Export carduri ALPHA BANK (.csv) - Separator: ,~,
- - Export carduri ALPHA BANK (.txt) - Separator: |
- - Export carduri ALPHA BANK 2 (.txt) - Se foloseste codul extern - codul IBAN de pe angajat; Separator: ~
- - Export carduri BANCPOST (.txt)
- - Export carduri BCR (.csv)
- - Export carduri BCR 2 (.csv)
- - Export carduri BCR 3 (.csv)
- - Export carduri BCR 4 (.csv)
- - Export carduri BRD (.csv)
- - Export carduri BRD 2 (.csv)
- - Export carduri BRD 3 (.csv)
- - Export carduri BRD 4 (.csv)
- - Export carduri BRD 5 (.csv)
- - Export carduri BRD (.txt)
- - Export carduri CEC BANK(.csv)
- - Export carduri CEC BANK 2(.csv)
- - Export carduri CEC BANK XLSX(.xlsx)
- - Export carduri CEC BANK 4(.csv)
- - Export carduri CITI (.txt)
- - Export carduri e-BCR+(.csv)
- - Export carduri GARANTI (.xls)
- - Export carduri Plata multipla BCR (.txt)
- - Export carduri Plata multipla BRD (.txt)
- - Export carduri Plata multipla ING (.txt)
- - Export carduri RAIFFEISEN (.csv)
- - Export carduri RAIFFEISEN 2 (.csv)
- - Export carduri RAIFFEISEN 3 (.txt)
- - Export carduri RAIFFEISEN 4 (.txt)
- - Export carduri RAIFFEISEN 5 (.txt)
- - Export carduri RAIFFEISEN 6 (.txt)
- - Export carduri RAIFFEISEN 7 (.csv)
- - Export carduri RAIFFEISEN 8 (.txt)
- - Export carduri RAIFFEISEN 9 (.xlsx)
- - Export carduri RAIFFEISEN 10 (.xlsx)
- - Export carduri RAIFFEISEN 11 (.xlsx)
- - Export carduri Retineri RAIFFEISEN (.csv)
- - Export carduri Retineri TRANSILVANIA (.csv)
- - Export carduri TRANSILVANIA (.csv)
- - Export carduri TRANSILVANIA 2 (.xls)
- - Export carduri TRANSILVANIA 3 (.csv)
- - Export carduri TRANSILVANIA 4 (.csv)
- - Export carduri TRANSILVANIA 5 (.csv)
- - Export carduri TRANSILVANIA 8 (.csv)
- - Export carduri TRANSILVANIA 9 (.csv)
- - Export carduri TRANSILVANIA 10 (.csv): la fel ca transilvania 2 dar aduce suma in valuta
- - Export carduri TRANSILVANIA 11 (.csv): la fel ca transilvania 8 dar aduce suma in valuta
- - Export carduri TRANSILVANIA 12 (.csv)
- - Export carduri TRANSILVANIA 13 (.csv)
- - Export carduri TRANSILVANIA 14 (.csv)
- - Export carduri UNICREDIT (.csv)
- - Export carduri UNICREDIT 2 (.txt)
- - Export carduri UNICREDIT XML (.xml)
- - Export carduri UNICREDIT XML 2 (.xml)
- - Export carduri VENETO (.csv)
- - Export carduri BANCA ROMANEASCA (.csv)
- - Export carduri ING (.csv)
- - Export carduri ING 2 (.csv)
- - Export carduri ING 3 (.txt)
- - Export carduri ING 4 (.txt)
- - Export carduri ING 5 (.txt)
- - Export carduri ING 6 (.csv)
- - Export carduri BANCA FEROVIARA (.txt)
- - Export carduri Plata multipla BRD (.roi)
- - Export carduri OTP (.csv)
- - Export carduri VISTA (.csv)
- - Export carduri Banca Romaneasca - xml (.xml)
- - Export carduri Retineri Techventures (.txt)
- - Export carduri Retineri Techventures 2 (.csv)
- - Export carduri Techventures (.csv)
Lista
Filtre
- An
- Se exporta sumele din anul ales
- Luna
- Se exporta sumele din luna aleasa
- Data plata
- Aceasta data se va completa in fisier ca data platii (pentru fisierele care includ in structura acest camp)
- Avans
- Se exporta sumele de avans
- Lichidare
- Se exporta sumele de lichidare
- Tip cont
- Salarii / Decont / Tichete de masa / Garantii
- Alte sume
- Se exporta sumele calculate pe variabila aleasa
- Expresie
- Se exporta sumele determinate de formula scrisa
- Cont bancar firma
- Se va completa in fisier la cont firma (pentru fisierele care includ in structura acest camp)
- Valuta
- Format fisier
- Explicatii
- Angajat
- Banca angajat
- Filtreaza banca angajat
- Loc plata
- Departament
- Tip contract angajat
- Filtreaza dupa tipul contractului
- Stergere exporturi generate
- folosit pentru a sterge toate exporturile generate in perioada filtrata si pe formatul selectat
- Reinitializare export
- se anuleaza exporturile care nu se afla in xml-ul creat la salvare si nici in tabela temporara creata pe baza xml-ului anterior mentionat.
- Tip comision
- apare doar atunci cand formatul are un tip de comision setat pe el
Coloane
- Persoana
- Beneficiar
- coloana disponibila doar in cazul fisierelor cu bifa de 'Retinere' selectata
- Banca
- Cont bancar
- Cod Extern
- Contract
- CNP
- Suma
- Suma platita
- Diferenta
- Plata urgenta
- apare doar daca pe formatul selectat este pusa bifa "Are plata urgenta"
- Selectare
- Se exporta doar inregistrarile selectate
Operatii globale
- Lista fisiere
- Lista de unde se pot descarca fisierele generate
