{"id":852,"date":"2012-08-03T09:27:51","date_gmt":"2012-08-03T07:27:51","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=852"},"modified":"2012-08-03T10:17:26","modified_gmt":"2012-08-03T08:17:26","slug":"r12-platnosci-xml-dla-platnosci","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=852","title":{"rendered":"R12 &#8211; P\u0142atno\u015bci &#8211; XML dla p\u0142atno\u015bci"},"content":{"rendered":"<p>Je\u017celi zaczniecie pisa\u0107 szablony do p\u0142atno\u015bci lub raporty bazuj\u0105ce na p\u0142atno\u015bciach to napotkacie problem z xmlem z danymi. Nie jak go wydoby\u0107, ale oracle daje rozwi\u0105zanie:<\/p>\n<p><!--more--><\/p>\n<pre lang=\"sql\">Select document\r\nFrom iby_trxn_documents\r\nWhere payment_instruction_id = '&lt;reference number on PPR&gt;'<\/pre>\n<pre lang=\"sql\">Select payment_instruction_id\r\nFrom iby_payments_all\r\nWhere paper_document_number = '&lt;check number&gt;'<\/pre>\n<p>Luko<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Je\u017celi zaczniecie pisa\u0107 szablony do p\u0142atno\u015bci lub raporty bazuj\u0105ce na p\u0142atno\u015bciach to napotkacie problem z xmlem z danymi. Nie jak go wydoby\u0107, ale oracle daje rozwi\u0105zanie:<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[149],"tags":[247,148],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/852"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=852"}],"version-history":[{"count":4,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/852\/revisions"}],"predecessor-version":[{"id":854,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/852\/revisions\/854"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}