{"id":8032,"date":"2024-03-28T15:14:48","date_gmt":"2024-03-28T15:14:48","guid":{"rendered":"https:\/\/podpora.nuggetsw.cz\/?post_type=lsvr_faq&#038;p=8032"},"modified":"2024-05-16T09:49:12","modified_gmt":"2024-05-16T09:49:12","slug":"query-a-produkty-sporeni-na-stari-penzijni-fondy","status":"publish","type":"lsvr_faq","link":"https:\/\/podpora.nuggetsw.cz\/index.php\/faq\/query-a-produkty-sporeni-na-stari-penzijni-fondy\/","title":{"rendered":"Query a produkty spo\u0159en\u00ed na st\u00e1\u0159\u00ed (penzijn\u00ed fondy)"},"content":{"rendered":"\n<p>Aktualizovali jsme \u00fadaje pro vytv\u00e1\u0159en\u00ed u\u017eivatelsk\u00fdch sestav Query. M\u016f\u017eete vytv\u00e1\u0159et sestavu ze souboru sr\u00e1\u017eek na \u00fa\u010det (LS044) nebo z karty zam\u011bstnance (LS001).<\/p>\n\n\n\n<h3 class=\"has-text-align-center wp-block-heading\">a) query &#8211; sr\u00e1\u017eky na \u00fa\u010det<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>funkce mzdy 12-4 U\u017eivatelsk\u00e9 query<\/strong> &#8211; p\u0159es lev\u00e9 spodn\u00ed tla\u010d\u00edtko <strong>Soubor p\u0159idejte soubor LS044<\/strong> &#8211; viz foto n\u00ed\u017ee<\/li><li>Query ze souboru LS044 roz\u0161\u00ed\u0159eno o nov\u00e9 \u00fadaje, co\u017e by m\u011blo umo\u017enit lep\u0161\u00ed kontrolu dat: <ul><li>L6009, L6009NAZ \u2013 \u010c\u00edslo a n\u00e1zev penzijn\u00edho fondu<\/li><\/ul><ul><li>L6010 &#8211; Datum p\u0159ihl\u00e1\u0161en\u00ed k PF<\/li><li>L7038, L7038NAZ \u2013 Druh spo\u0159en\u00ed<\/li><li>L7003O \u2013 P\u0159\u00edsp\u011bvek za organizaci<\/li><li>L7003Z \u2013 p\u0159\u00edsp\u011bvek za zam\u011bstnance<\/li><li>L7044 \u2013 sr\u00e1\u017eka za t\u0159et\u00ed osobu<\/li><\/ul><\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>pokud pou\u017eijete v querech pouze z\u00e1kladn\u00ed soubor LS001, co\u017ee je karta zam\u011bstnance, dostanete \u00fadaje sice z karty zam\u011bstnance, ale jak bylo \u0159e\u010deno v\u00fd\u0161e, p\u016fjde pouze o informativn\u00ed \u00fadaje <ul><li>nap\u0159. n\u011bkdo m\u016f\u017ee \u00fadaj L6010 na kart\u011b zam\u011bstnance pou\u017e\u00edt pro faktick\u00fd za\u010d\u00e1tek smlouvy (p\u0159\u00edklad: smlouva platn\u00e1 od 1.5.2024 mus\u00ed b\u00fdt odvedena ji\u017e v dubnov\u00e9 v\u00fdplat\u011b, proto\u017ee poji\u0161\u0165ovna bere datum p\u0159ips\u00e1n\u00ed pen\u011bz)<\/li><\/ul><\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"931\" height=\"747\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/03\/image-22.png\" alt=\"\" class=\"wp-image-7854\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/03\/image-22.png 931w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/03\/image-22-300x241.png 300w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/03\/image-22-768x616.png 768w\" sizes=\"auto, (max-width: 931px) 100vw, 931px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>pro pr\u00e1ci s Query m\u00e1me samostatn\u00fd n\u00e1vod <a rel=\"noreferrer noopener\" href=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/query\/\" data-type=\"URL\" data-id=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/query\/\" target=\"_blank\">zde<\/a><\/li><\/ul>\n\n\n\n<h3 class=\"has-text-align-center wp-block-heading\">b) query &#8211; z karty zam\u011bstnance<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>funkce mzdy 12-4 U\u017eivatelsk\u00e9 query<\/strong><\/li><li>v \u00fadaj\u00edch souboru LS001 najdete \u00fadaje, kter\u00e9 sumarizuj\u00ed hodnoty jednotliv\u00fdch sr\u00e1\u017eek produkt\u016f na st\u00e1\u0159\u00ed do z\u00e1kladn\u00edho pohledu na kmenov\u00e1 data <\/li><li>p\u011bt sad &#8211; dle produktu (DIP, DPS, PRO, PPR a ANY &#8211; jako celkem) \u0161esti \u00fadaj\u016f L4051, L4052, L4054, L6009, L6009N a L6010<\/li><li><em>jde o \u00fadaje<\/em>:<\/li><\/ul>\n\n\n\n<p>L4051ANY &#8211; P\u0159\u00edsp\u011bvek organizace celkem<br>L4051DIP &#8211; P\u0159\u00edsp\u011bvek organizace DIP<br>L4051DPS &#8211; P\u0159\u00edsp\u011bvek organizace DPS<br>L4051PPO &#8211; P\u0159\u00edsp\u011bvek organizace PPO<br>L4051PPR &#8211; P\u0159\u00edsp\u011bvek organizace PPR<br>L4052ANY &#8211; P\u0159\u00edsp\u011bvek organizace% celkem<br>L4052DIP &#8211; P\u0159\u00edsp\u011bvek organizace DIP %<br>L4052DPS &#8211; P\u0159\u00edsp\u011bvek organizace DPS %<br>L4052PPO &#8211; P\u0159\u00edsp\u011bvek organizace PPO %<br>L4052PPR &#8211; P\u0159\u00edsp\u011bvek organizace PPR %<br>L4054ANY &#8211; P\u0159\u00edsp\u011bvek zam\u011bstnance celkem<br>L4054DIP &#8211; P\u0159\u00edsp\u011bvek zam\u011bstnance DIP<br>L4054DPS &#8211; P\u0159\u00edsp\u011bvek zam\u011bstnance DPS<br>L4054PPO &#8211; P\u0159\u00edsp\u011bvek zam\u011bstnance PPO<br>L4054PPR &#8211; P\u0159\u00edsp\u011bvek zam\u011bstnance PPR<br>L6009ANY &#8211; \u010c\u00edslo PF<br>L6009ANYN &#8211; \u010c\u00edslo PF<br>L6009DIP &#8211; \u010c\u00edslo PF PPR<br>L6009DIPN &#8211; \u010c\u00edslo PF DIP<br>L6009DPS &#8211; \u010c\u00edslo PF DPS<br>L6009DPSN &#8211; \u010c\u00edslo PF DPS<br>L6009NAZ &#8211; \u010c\u00edslo penzijn\u00edho fondu<br>L6009PPO &#8211; \u010c\u00edslo PF PPR<br>L6009PPON &#8211; \u010c\u00edslo PF PPO<br>L6009PPR &#8211; \u010c\u00edslo PF PPR<br>L6009PPRN &#8211; \u010c\u00edslo PF PPR<br>L6010ANY &#8211; Datum PF<br>L6010DIP &#8211; Datum PF DIP<br>L6010DPS &#8211; Datum PF DPS<br>L6010PPO &#8211; Datum PF PPO<br>L6010PPR &#8211; Datum PF PPR<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>z\u00e1rove\u0148 z\u016fst\u00e1v\u00e1 mo\u017enost vytv\u00e1\u0159et u\u017eivatelskou sestavu z p\u016fvodn\u00edch \u00fadaj\u016f, kter\u00e9 jsou moment\u00e1ln\u011b na kart\u011b zam\u011bstnance pouze informativn\u00ed, jde o \u00fadaje z karty zam\u011bstnance<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"460\" height=\"111\" src=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/05\/image-23.png\" alt=\"\" class=\"wp-image-8263\" srcset=\"https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/05\/image-23.png 460w, https:\/\/podpora.nuggetsw.cz\/wp-content\/uploads\/2024\/05\/image-23-300x72.png 300w\" sizes=\"auto, (max-width: 460px) 100vw, 460px\" \/><\/figure><\/div>\n\n\n\n<ul class=\"wp-block-list\"><li>pro Query m\u00e1me samostatn\u00fd n\u00e1vod&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/podpora.nuggetsw.cz\/index.php\/knowledge-base\/query\/\" target=\"_blank\">zde<\/a><\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Aktualizovali jsme \u00fadaje pro vytv\u00e1\u0159en\u00ed u\u017eivatelsk\u00fdch sestav Query. M\u016f\u017eete vytv\u00e1\u0159et sestavu ze souboru sr\u00e1\u017eek na \u00fa\u010det (LS044) nebo z karty zam\u011bstnance (LS001). a) query &#8211; sr\u00e1\u017eky na \u00fa\u010det funkce mzdy 12-4 U\u017eivatelsk\u00e9 query &#8211; p\u0159es lev\u00e9 spodn\u00ed tla\u010d\u00edtko Soubor p\u0159idejte soubor LS044 &#8211; viz foto n\u00ed\u017ee Query ze souboru LS044 roz\u0161\u00ed\u0159eno o nov\u00e9 \u00fadaje, co\u017e [&hellip;]<\/p>\n","protected":false},"author":3,"template":"","meta":{"footnotes":""},"lsvr_faq_cat":[41],"lsvr_faq_tag":[],"class_list":["post-8032","lsvr_faq","type-lsvr_faq","status-publish","hentry","lsvr_faq_cat-nejcastejsi-dotazy"],"_links":{"self":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_faq\/8032","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_faq"}],"about":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/types\/lsvr_faq"}],"author":[{"embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/users\/3"}],"version-history":[{"count":3,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_faq\/8032\/revisions"}],"predecessor-version":[{"id":8265,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_faq\/8032\/revisions\/8265"}],"wp:attachment":[{"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/media?parent=8032"}],"wp:term":[{"taxonomy":"lsvr_faq_cat","embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_faq_cat?post=8032"},{"taxonomy":"lsvr_faq_tag","embeddable":true,"href":"https:\/\/podpora.nuggetsw.cz\/index.php\/wp-json\/wp\/v2\/lsvr_faq_tag?post=8032"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}