{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["JPK-Nagłówek","JPK-Lista faktur","JPK-Pozycje faktur","JPK-Zamówienia","Parametry","techniczne"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":130,"comments":6,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"JPK-Nagłówek","index":0,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,8,3,15],[10,8,10,11],[13,8,13,9],[14,8,14,9],[7,8,7,11],[12,8,12,11]]}
[null,null,null,null,null,"JPK_FA (wersja obowiązująca od kwietnia 2022)"]
[null,null,null,{"$f":"DataWytworzenia()","v":"2022-04-22T12:47:05"}]
[]
[null,null,"Cel złożenia:",1,null,null,null,"Pełna nazwa podmiotu:","Pełna nazwa przedsiębiorstwa"]
[null,null,null,null,null,null,null,"NIP/numer id. OSS/IOSS","1111111111"]
[null,null,"Data od:","2016-08-01"]
[null,null,"Data do:","2016-08-31"]
[null,null,null,null,null,null,null,"Ulica:","Magnoliowa"]
[null,null,null,null,null,null,null,"Nr domu:","12","Nr lokalu:",""]
[null,null,null,null,null,null,null,"Kod pocztowy:","62-052"]
[null,null,"Kod urzędu skarbowego:","3023",null,null,null,"Miejscowość:","Komorniki",null,null,null,"Kod kraju:","PL"]
[]
[null,null,null,null,null,null,null,"Gmina:","Komorniki"]
[null,null,null,null,null,null,null,"Powiat:","Poznań"]
[null,null,null,null,null,null,null,"Województwo:","Wielkopolskie"]
[]
[]
[null,"Pola obowiązkowe:"]
[null,"Pola opcjonalne:"]

{"sheet":"JPK-Lista faktur","index":1,"n_rows":16,"n_cols":61,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2016-08-01"},{"$f":"IF(E7=\"\",\"\",SUBTOTAL(5,E7:E1048576))","v":"2016-08-02"},null,null,"Liczba faktur:",{"$f":"SUBTOTAL(3,E7:E1048576)","v":10},null,null,null,null,null,null,"Wartości sprzedaży i kwoty podatku wypełnia się w walucie, w której wystawiono fakturę,"]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2016-08-31"},{"$f":"IF(E7=\"\",\"\",SUBTOTAL(4,E7:E1048576))","v":"2016-08-30"},null,null,"Wartość faktur:",{"$f":"AG4","v":2777.2599999999998},null,null,null,null,null,null,"z wyjątkiem pól P_14_1W, P_14_2W, P_14_3W, P_14_4W, w których kwoty podatku zostały przeliczone zgodnie z art. 31a w związku z art. 106e ust. 11 ustawy "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,Q7:Q1048576)","v":1268.8200000000002},291.83999999999997,0,0,0,0,0,0,0,0,0,0,1216.5999999999999,{"$f":"SUBTOTAL(9,AD7:AD1048576)","v":0},0,0,2777.2599999999998]
[]
[null,null,null,"Błąd","P 1","P 2A","P 3A","P 3B","P 3C","P 3D","P 4A","P 4B","P 5A","P 5B","P 6","Kod Waluty","P 13 1","P 14 1","P 14 1W","P 13 2","P 14 2","P 14 2W","P 13 3","P 14 3","P 14 3W","P 13 4","P 14 4","P 14 4W","P 13 5","P 14 5","P 13 6","P 13 7","P 15","P 16","P 17","P 18","P 18A","P 19","P 19A","P 19B","P 19C","P 20","P 20A","P 20B","P 21","P 21A","P 21B","P 21C","P 22","P 22A","P 22B","P 22C","P 23","P 106E 2","P 106E 3","P 106E 3A","Rodzaj Faktury","Przyczyna korekty","Nr fa. korygowanej","Okres fa. Korygowanej","Nr fa. zaliczkowej"]
[null,null,null,null,"2016-08-24","162508016","CEJROWSKI WOJCIECH","87-800 WŁOCŁAWEK, PLAC WOLNOŚCI 17/8","ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860",null,null,"2016-05-24","PLN",1253.67,288.33999999999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1542.01,false,false,false,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"VAT"]
[null,null,null,null,"2016-08-04","167200434","PARAGON BYDGOSZCZ",null,"ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860",null,null,"2016-05-04","PLN",-50.99,-11.73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-62.72,false,false,false,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"KOREKTA","korekta ilościowa","162506772","2016"]
[null,null,null,null,"2016-08-02","160075538","JGH HOLDING AB","177 33 JÄRFÄLLA, FRIHETSVÄGEN 64","ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860","SE","SE239454","2016-05-02","SEK",null,null,null,null,null,null,null,null,null,null,null,null,1216.5999999999999,null,null,null,1216.5999999999999,false,false,true,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"VAT"]
[null,null,null,null,"2016-08-19","160085644","PRZEDSIĘBIORSTWO HANDLOWO-USŁUGOWE ROMAN WOŹNIAKOWSKI","54-434 WROCŁAW, UL.BUDZISZYŃSKA 33/4","ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860",null,"8941696920","2016-05-19","PLN",209.4,48.16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,257.56,false,false,false,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"VAT"]
[null,null,null,null,"2016-08-19","164000073","KLESZCZYK EUZEBIUSZ","97-400 BEŁCHATÓW, EMILIN 123","ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860",null,null,"2016-05-19","PLN",166.67,38.33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,205,false,false,false,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"VAT"]
[null,null,null,null,"2016-08-30","167300880","SHIELE TADEUSZ","10-811 OLSZTYN, UL.ŻNIWNA 12A","ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860",null,"7390008147","2016-05-30","PLN",-132.65,-30.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-163.15,false,false,false,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"KOREKTA","korekta wartościowa","160086358","2016"]
[null,null,null,null,"2016-08-20","167600132","PPHU OKMET - WOJCIECH OKIŃCZYC","58-160 ŚWIEBODZICE, PLAC DWORCOWY 2","ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860",null,"8840032242","2016-05-20","PLN",-18,-4.1399999999999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-22.14,false,false,false,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"KOREKTA"]
[null,null,null,null,"2016-08-06","163000184","LEWADNOWSKI WOJCIECH","87-800 WŁOCŁAWEK, ŁANOWA 15/49","ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860",null,null,"2016-05-06","PLN",325.2,74.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,false,false,false,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"ZAL"]
[null,null,null,null,"2016-08-04","167007885","RASTISLAV SUBJAK - RASUB","02774 TVRDOSIN, VOJTASSAKOVA 664","ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860","SK","SK1020472937","2016-05-04","PLN",-199.92,-45.98,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-245.9,false,false,false,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"KOREKTA","korekta ilościowa","160035964","2016"]
[null,null,null,null,"2016-08-17","167500009","ZAKŁAD USŁUG WOD-KAN,CO,GAZ ANDRZEJ STELTMANN","86-005 BIAŁE BŁOTA, UL.WIŚNIOWA 6   KRUSZYN KRAJEŃSKI","ZigZak Sp. z o.o.","62-052 Komorniki, Magnoliowa 12",null,"5262297860",null,null,"2016-05-17","PLN",-284.56,-65.44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-350,false,false,false,false,false,null,null,null,false,null,null,false,null,null,null,false,null,null,null,false,false,false,null,"KOREKTA","korekta wartościowa","162507572","2016"]

{"sheet":"JPK-Pozycje faktur","index":2,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2016-08-01"},null,null,"Liczba wierszy:",{"$f":"SUBTOTAL(3,E7:E1048576)","v":21},null,"Pozycje faktur należy podać w walucie, w której wystawiono fakturę"]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2016-08-31"},null,null,"Wartość wierszy",{"$f":"L4","v":2160.2300000000009}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,L7:L1048576)","v":2160.2300000000009},{"$f":"SUBTOTAL(9,M7:M1048576)","v":2377.2600000000007}]
[]
[null,null,null,"Błąd","P 2B","P 7","P 8A","P 8B","P 9A","P 9B","P 10","P 11","P 11A","P 12","P 12 XII"]
[null,null,null,null,"160075538","SFAP-952077: POMPA ROZDRABN.SANIACESS2","SZT",1,1216.5999999999999,1216.5999999999999,null,1216.5999999999999,1216.5999999999999,"np"]
[null,null,null,null,"160085644","ADTR00: Opłata admin.za dostawę towaru",null,1,18,22.14,null,18,22.14,"23"]
[null,null,null,null,"160085644","ARCL-940551: OTULINA DO RUR 114/13","SZT",10,19.14,23.54,null,191.4,235.42,"23"]
[null,null,null,null,"162508016","ALTH-201606: MOCOW.GRZEJ.WIESZAK","SZT",3,2,2,null,4.88,6,"23"]
[null,null,null,null,"162508016","ALTH-913232: KOMPLET KORKÓW GRZEJN.1\"X1/2\"","KPL",3,16,16,null,39.03,48,"23"]
[null,null,null,null,"162508016","ALTH-943094: ZESTAW GRZEJ.TERM.KĄTOWY","SZT",1,71.5,71.5,null,58.14,71.510000000000005,"23"]
[null,null,null,null,"162508016","ALTH-943095: ZESTAW GRZEJ.TERM.PROSTY","SZT",3,71.5,71.5,null,174.39,214.5,"23"]
[null,null,null,null,"162508016","ALTH-965881: GRZEJ.ŻEBER.ALUMIN.500/80","SZT",3,324,324,null,790.25,972,"23"]
[null,null,null,null,"162508016","ALTN-982310: GRZEJ.ŁAZ.STAL.500X 915","SZT",1,230,230,null,186.99,230,"23"]
[null,null,null,null,"164000073","DOPRAC:KLESZCZYK EUZEBUSZ WYROWNANIE",null,1,166.67,205,null,166.67,205,"23"]
[null,null,null,null,"167007885","ROCA-203972: DESKA SEDESOWA TWARDA WOLNOOP.","SZT",-1,199.92,245.9,null,-199.92,-245.9,"23"]
[null,null,null,null,"167200434","FERR-025528: ZAWÓR CZERPALNY 3/4\"","SZT",-2,31.36,31.36,null,-50.99,-62.72,"23"]
[null,null,null,null,"167300880","KATH-640226: O.PEX-ROZDZIEL.4-OB. DO O.P.","SZT",-1,334.95,411.99,null,-334.95,-411.99,"23"]
[null,null,null,null,"167300880","KATH-640226: O.PEX-ROZDZIEL.4-OB. DO O.P.","SZT",1,296.67,364.91,null,296.67,364.91,"23"]
[null,null,null,null,"167300880","KATH-647334: O.PEX-SZAFKA ROZDZ.710X780","SZT",-1,188.34,231.64,null,-188.33,-231.64,"23"]
[null,null,null,null,"167300880","KATH-647334: O.PEX-SZAFKA ROZDZ.710X780","SZT",1,166.81,205.17,null,166.81,205.17,"23"]
[null,null,null,null,"167300880","KATH-942360: O.PEX-ROZDZIEL.8-OB. DO O.P.","SZT",1,564.63,694.5,null,564.63,694.5,"23"]
[null,null,null,null,"167300880","KATH-942360: O.PEX-ROZDZIEL.8-OB. DO O.P.","SZT",-1,637.48,784.1,null,-637.48,-784.1,"23"]
[null,null,null,null,"167500009","SAS.-658869: KOCIOŁ PAL.STAŁE 14KW","SZT",1,3950,3950,null,3211.38,3950,"23"]
[null,null,null,null,"167500009","SAS.-658869: KOCIOŁ PAL.STAŁE 14KW","SZT",-1,4300,4300,null,-3495.94,-4300,"23"]
[null,null,null,null,"167600132","ADTR00: Opłata admin.za dostawę towaru",null,1,-18,-22.14,null,-18,-22.14,"23"]

{"sheet":"JPK-Zamówienia","index":3,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Zestawienie dla danych od dnia:",{"$f":"IF(DataOd = \"\",\"\",DataOd)","v":"2016-08-01"},null,null,"Liczba wierszy:",{"$f":"IF(E5=0,\"\",E5)","v":1},"Pozycje zamówienia lub umowy dla faktur zaliczkowych, o których mowa w art. 106f ust. 1 pkt 4 ustawy"]
[null,null,null,"do dnia:",{"$f":"IF(DataDo=\"\",\"\",DataDo)","v":"2016-08-31"},null,null,"Wartość wierszy",{"$f":"IF(L4=0,\"\",L4)","v":22.14},"w walucie, w której wystawiono fakturę zaliczkową"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J7:J1048576)","v":18},{"$f":"SUBTOTAL(9,K7:K1048576)","v":4.1399999999999997},{"$f":"SUBTOTAL(9,L7:L1048576)","v":22.14}]
[null,null,null,null,{"$f":"SUBTOTAL(3,E7:E1048576)","v":1}]
[null,null,null,"Błąd","P 2AZ","P 7Z","P 8AZ","P 8BZ","P 9AZ","P 11 Netto Z","P 11 Vat Z","Wartość brutto","P 12Z","P 12Z XII"]
[null,null,null,null,"163000184","ADTR00: Opłata admin.za dostawę towaru","SZT",1,18,18,4.1399999999999997,22.14,"23"]

{"sheet":"Parametry","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Rozszerzenie pliku importu:"]
[]
[]
[null,"Arkusz","Komponent obsługujący import"]
[null,"JPK-Lista faktur","brak"]
[null,"JPK-Pozycje faktur","brak"]
[null,"JPK-Zamówienia","brak"]
[]
[]
[null,"Modyfikuj pola sumaryczne",0]

{"sheet":"techniczne","index":5,"n_rows":116,"n_cols":20,"rows_kept":116,"cut":false,"hidden":true,"merged":[[108,14,108,15],[108,16,108,17],[104,14,104,15],[104,16,104,17],[107,14,107,15],[107,16,107,17],[105,14,105,15],[105,16,105,17],[106,14,106,15],[106,16,106,17],[102,14,102,15],[102,16,102,17],[103,14,103,15],[103,16,103,17],[103,4,107,6],[103,8,107,10]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Elementy list","Numery automat:","Nr obowiązkowej kolumny"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Faktura",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FakturaWiersz",null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zamowienie",null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XED","#4538"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"XSD:","https://www.gov.pl/attachment/aaa27be2-3663-46cd-bf53-f8925f0170b3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Namespace:","http://jpk.mf.gov.pl/wzor/2022/02/17/02171/"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroToEmpty",false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ZeroFollowsFields:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dodatkowe testy merytoryczne podczas Importu i dopisywania (Append):"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sprawdź podczas importu","Sprawdź podczas dołączania","Wykonać przed walidacją XSD?","Węzeł z porównywaną wartością (wyrażenie Xpath) (uruchamiane dla DocumentNode)","Oczekiwana wartość","Komunikat o ewentualnym błędzie (Wpisz {Val} tam, gdzie ma być podstawiona wartość z importowanego dokumentu)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRUE","v":true},{"$f":"TRUE","v":true},{"$f":"TRUE","v":true},"*[local-name()='Naglowek']/*[local-name()='KodFormularza']","JPK_FA",{"$f":"\"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być '\" & S17 & \"'\"","v":"Niewłaściwy typ pliku JPK ({Val}), podczas gdy powinien to być 'JPK_FA'"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"jpk:Podmiot1/jpk:IdentyfikatorPodmiotu/*[local-name()='NIP']",{"$f":"NIP","v":"1111111111"},{"$f":"\"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: \" &S18 & \")\"","v":"Plik dotyczy przedsiębiorstwa o innym NIP ({Val}) niż dotychczas wczytane dane (dla przedsiębiorstwa o NIP: 1111111111)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"jpk:Naglowek/jpk:DataOd",{"$f":"TEXT(DataOd,\"rrrr-MM-dd\")","v":"2016-08-01"},{"$f":"\"Plik dotyczy okresu o innej dacie początkowej ({Val}) niż dotychczas wczytane dane (\" & S19 & \")\"","v":"Plik dotyczy okresu o innej dacie początkowej ({Val}) niż dotychczas wczytane dane (2016-08-01)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"FALSE","v":false},{"$f":"TRUE","v":true},{"$f":"FALSE","v":false},"jpk:Naglowek/jpk:DataDo",{"$f":"TEXT(DataDo,\"rrrr-MM-dd\")","v":"2016-08-31"},{"$f":"\"Plik dotyczy okresu o innej dacie końcowej ({Val}) niż dotychczas wczytane dane (\" & S20 & \")\"","v":"Plik dotyczy okresu o innej dacie końcowej ({Val}) niż dotychczas wczytane dane (2016-08-31)"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nazwa skoroszytu:",null,"JPK_FA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer seryjny:",null,"DEMO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Numer edycji:",null,1.82]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wygenerowano:",null,"2024-04-02T13:55:18"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Komunikaty w oknach dialogowych",null,"00"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Specyficzne dla tego skoroszytu:"]
["Wartości logiczne:",null,0,1,"tak","nie",true,false,null,null,null,null,null,null,"Schematy, używane gdy nie można użyć wersji online z Ministerstwa Finansów:"]
["Adres:",{"$f":"IF(OR(KodKraju=\"PL\",KodKraju=\"\"),\nE104,\nI104\n)","v":"<AdresPodmiotu>\n\t\t\t<etd:KodKraju></etd:KodKraju>\n\t\t\t<etd:Wojewodztwo></etd:Wojewodztwo>\n\t\t\t<etd:Powiat></etd:Powiat>\n\t\t\t<etd:Gmina></etd:Gmina>\n\t\t\t<etd:Ulica></etd:Ulica>\n\t\t\t<etd:NrDomu></etd:NrDomu>\n\t\t\t<etd:NrLokalu></etd:NrLokalu>\n\t\t\t<etd:Miejscowosc></etd:Miejscowosc>\n\t\t\t<etd:KodPocztowy></etd:KodPocztowy>\n\t\t</AdresPodmiotu>"},null," ","polski:",null,null,null,"zagraniczny:",null,null,null,null,null,"Nazwa ramki",null,"Przestrzeń nazw"]
[null,null,null,null,"<AdresPodmiotu>\n\t\t\t<etd:KodKraju></etd:KodKraju>\n\t\t\t<etd:Wojewodztwo></etd:Wojewodztwo>\n\t\t\t<etd:Powiat></etd:Powiat>\n\t\t\t<etd:Gmina></etd:Gmina>\n\t\t\t<etd:Ulica></etd:Ulica>\n\t\t\t<etd:NrDomu></etd:NrDomu>\n\t\t\t<etd:NrLokalu></etd:NrLokalu>\n\t\t\t<etd:Miejscowosc></etd:Miejscowosc>\n\t\t\t<etd:KodPocztowy></etd:KodPocztowy>\n\t\t</AdresPodmiotu>",null,null,null,"<AdresPodmiotu2>\n\t\t\t<etd:KodKraju></etd:KodKraju>\n\t\t\t<etd:KodPocztowy></etd:KodPocztowy>\n\t\t\t<etd:Miejscowosc></etd:Miejscowosc>\n\t\t\t<etd:Ulica></etd:Ulica>\n\t\t\t<etd:NrDomu></etd:NrDomu>\n\t\t\t<etd:NrLokalu></etd:NrLokalu>\n\t\t</AdresPodmiotu2>",null,null,null,null,null,"UrzedySkarbowe",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2018/08/24/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ElementarneTypyDanych",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2018/08/24/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KodyCechyKrajow",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2013/05/23/eD/KodyCECHKRAJOW/",null,"Choć JPK_FA korzysta ze swoich definicji krajów i walut,"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KodyKrajow",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2018/08/24/eD/DefinicjeTypy/",null,"to te dwa pliki są nadal potrzebne do zwalidowania StrukturyDanych!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"StrukturyDanych",null,"http://crd.gov.pl/xml/schematy/dziedzinowe/mf/2018/08/24/eD/DefinicjeTypy/"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JPK",null,{"$f":"JPK_Namespace","v":"http://jpk.mf.gov.pl/wzor/2022/02/17/02171/"}]
["Arkusze transformacji (potrzebne do rozdzielania na wejściu I scalania na wyjściu elementów <Zamowienie>)"]
["XsltInput:"]
[null,"<xsl:stylesheet version=\"1.0\"\n  xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\"\n    xmlns:jpk=\"http://jpk.mf.gov.pl/wzor/2022/02/17/02171/\"\n  >\n\t<xsl:output method='xml' indent=\"yes\" encoding=\"UTF-8\"/>\n<!-- basic: identity copy: -->\n\t<xsl:template match=\"@*|node()\">\n\t\t<xsl:copy><xsl:apply-templates select=\"@*|node()\"/></xsl:copy>\n\t</xsl:template>  \n<!-- rozdzielanie jpk:Zamowienie na elementy z jednym wierszem: -->\n\t<xsl:template match=\"jpk:Zamowienie\">\n\t\t<xsl:for-each select=\"jpk:ZamowienieWiersz\">\n\t\t\t<jpk:Zamowienie>\n\t\t\t\t<jpk:P_2AZ><xsl:value-of select=\"../jpk:P_2AZ\"/></jpk:P_2AZ>\n\t\t\t\t<jpk:WartoscZamowienia><xsl:value-of select=\"jpk:P_11NettoZ + jpk:P_11VatZ\"/></jpk:WartoscZamowienia>\n\t\t\t\t<xsl:apply-templates select=\".\"/> <!-- Skopiuj wiersz zamówienia z tego elementu -->\n\t\t\t</jpk:Zamowienie>\n\t\t</xsl:for-each>\n\t</xsl:template>\n\t<xsl:template match=\"jpk:LiczbaZamowien\"> \n\t\t<xsl:copy>\n\t\t\t<xsl:value-of select=\"count(//jpk:ZamowienieWiersz)\" />\n\t\t</xsl:copy>\n\t</xsl:template>\n\t<xsl:template match=\"jpk:EUPLVATID\"> \n\t\t\t<jpk:NIP><xsl:value-of select=\". \" /></jpk:NIP>\n\t</xsl:template>\n\t<xsl:template match=\"jpk:IMPLVATID\"> \n\t\t\t<jpk:NIP><xsl:value-of select=\". \" /></jpk:NIP>\n\t</xsl:template>\n</xsl:stylesheet>"]
["XsltPrevalidated:"]
[null,"<xsl:stylesheet version=\"1.0\"\n  xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\"\n    xmlns:jpk=\"http://jpk.mf.gov.pl/wzor/2022/02/17/02171/\"\n  >\n\t<xsl:output method='xml' indent=\"yes\" encoding=\"UTF-8\"/>\n<!-- basic: identity copy: -->\n\t<xsl:template match=\"@*|node()\">\n\t\t<xsl:copy><xsl:apply-templates select=\"@*|node()\"/></xsl:copy>\n\t</xsl:template>  \n<!-- ewentualna zamiana NIP na numery OSS lub IOSS: -->\n\t<xsl:template match=\"jpk:NIP[starts-with(text(),'EU616')]\"> \n\t\t\t<jpk:EUPLVATID><xsl:value-of select=\". \" /></jpk:EUPLVATID>\n\t</xsl:template>\n\t<xsl:template match=\"jpk:NIP[starts-with(text(),'IM616')]\"> \n\t\t\t<jpk:IMPLVATID><xsl:value-of select=\". \" /></jpk:IMPLVATID>\n\t</xsl:template>\n</xsl:stylesheet>"]
["XsltOutput:"]
[null,"<xsl:stylesheet version=\"1.0\"\n  xmlns:xsl=\"http://www.w3.org/1999/XSL/Transform\"\n    xmlns:jpk=\"http://jpk.mf.gov.pl/wzor/2022/02/17/02171/\"\n  >\n\t<xsl:output method='xml' indent=\"yes\" encoding=\"UTF-8\"/>\n<!-- basic: identity copy: -->\n\t<xsl:template match=\"@*|node()\">\n\t\t<xsl:copy><xsl:apply-templates select=\"@*|node()\"/></xsl:copy>\n\t</xsl:template>  \n<!-- scalanie jpk:Zamowienie o tym samym numerze faktury: -->\n\t<xsl:template match=\"jpk:Zamowienie[not(jpk:P_2AZ=preceding-sibling::*/jpk:P_2AZ)]\"> <!-- Pierwsze elementy jpk:Zamowienie -->\n\t\t<xsl:copy>\n\t\t\t<xsl:apply-templates select=\"jpk:P_2AZ\"/>\n\t\t\t<xsl:variable name=\"P_2AZ\" select=\"jpk:P_2AZ\"/> <!-- Skopiuj wiersze zamówień z kolejnych elementów o tym samym numerze faktury (P_2AZ) -->\n\t\t\t<xsl:apply-templates select=\"jpk:WartoscZamowienia\"/>\n\t\t\t<xsl:apply-templates select=\"jpk:ZamowienieWiersz\"/> <!-- Skopiuj wiersz zamówienia z tego elementu -->\n\t\t\t<xsl:apply-templates select=\"following-sibling::*[jpk:P_2AZ=$P_2AZ]/jpk:ZamowienieWiersz\"/>\n\t\t</xsl:copy>\n\t</xsl:template>\n\t<xsl:template match=\"jpk:Zamowienie[jpk:P_2AZ=preceding-sibling::*/jpk:P_2AZ]\"/> <!-- Pomiń kolejne elementy jpk:Zamowienie o tym samym numerze faktury -->\n\t<xsl:template match=\"jpk:WartoscZamowienia\"> <!-- Wołana tylko dla pierwszego z kilku kolejnych elementów o tej samej nazwie -->\n\t\t<xsl:variable name=\"P_2AZ\" select=\"../jpk:P_2AZ\"/> <!-- Sumuj wiersze zamówień z kolejnych elementów o tym samym numerze faktury (P_2AZ) -->\n\t\t<xsl:copy>\n\t\t\t<xsl:value-of select=\"round( . +  sum(../following-sibling::jpk:Zamowienie[jpk:P_2AZ=$P_2AZ]/jpk:WartoscZamowienia)*100) div 100\" />\n\t\t</xsl:copy>\n\t</xsl:template>\n</xsl:stylesheet>"]