{"id":1426,"date":"2014-05-21T13:37:59","date_gmt":"2014-05-21T12:37:59","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1426&#038;lang=en"},"modified":"2019-01-25T16:31:24","modified_gmt":"2019-01-25T15:31:24","slug":"invoice-payment","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1426","title":{"rendered":"Invoice Payment"},"content":{"rendered":"<h3><b><span style=\"text-decoration: underline;\">CLIENT\/SUPPLIER INVOICE PAYMENTS<br \/>\n<\/span><\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<th width=\"350\">Name<\/th>\n<th width=\"20\">Type<\/th>\n<th width=\"15\">Mandatory<\/th>\n<th width=\"250\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">&lt;<span style=\"color: #993300;\">Record<\/span> <span style=\"color: #0000ff;\">Type<\/span> =&#8221;<span style=\"color: #ff0000;\">26<\/span>&#8220;&gt;<\/td>\n<td>Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of object to import. 26 is for payment<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;DBId&gt;&lt;\/DBId&gt;<\/span><\/td>\n<td>Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Database ID in DeMaSy.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Ref&gt;&lt;\/Ref&gt;<\/span><\/td>\n<td>Char 255<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Internal reference<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Desc&gt;&lt;\/Desc&gt;<\/span><\/td>\n<td>Char 255<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Internal description<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Type&gt;&lt;\/Type&gt;<\/span><\/td>\n<td>Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type:<br \/>\n0 = Normal invoice payment<br \/>\n4 = Fees without VAT \/ 5 = Fees with VAT<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;InvoiceFNumber&gt;&lt;\/InvoiceFNumber&gt;<\/span><\/td>\n<td>Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Invoice number if supplier invoice<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;InvoiceTNumber&gt;&lt;\/InvoiceTNumber&gt;<\/span><\/td>\n<td>Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Invoice number if client invoice<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Date&gt;&lt;\/Date&gt;<\/span><\/td>\n<td>Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Payment Date (YYYYMMDD)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;PCurrency&gt;&lt;\/PCurrency&gt;<\/span><\/td>\n<td>Char(10)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Payment Currency (ISO code)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;PCyAmount&gt;&lt;\/PCyAmount&gt;<\/span><\/td>\n<td>Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Amount (payment currency)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Currency&gt;&lt;\/Currency&gt;<\/span><\/td>\n<td>Char(10)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Bank Currency (ISO code)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CurrencyRate&gt;&lt;\/CurrencyRate&gt;<\/span><\/td>\n<td>Double<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Currency rate between bank currency and capital currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CyAmount&gt;&lt;\/CyAmount&gt;<\/span><\/td>\n<td>Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Amount (bank currency)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Amount&gt;&lt;\/Amount&gt;<\/span><\/td>\n<td>Double<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Amount (capital currency)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Description&gt;&lt;\/Description&gt;<\/span><\/td>\n<td>Char(255)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;BankStatmentNumber&gt;&lt;\/BankStatmentNumber&gt;<\/span><\/td>\n<td>Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Bank Statement number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;BankAccountNumber&gt;&lt;\/BankAccountNumber&gt;<\/span><\/td>\n<td>Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Bank account number (IBAN)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;\/Record&gt;<\/span><\/td>\n<td align=\"center\" valign=\"top\"><\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">N\/A<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>To be noted that a payment with type 0 and bank statement number = 0 is considered as a wire transfer order.<br \/>\nSwift files sent to (wire transfer orders) or received (bank statements) from the bank (multiline) is dealt with the multiline wire transfer module.<\/p>\n<a href=\"https:\/\/sdna.lu\/?media_dl=6878\">PDF version<\/a>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CLIENT\/SUPPLIER INVOICE PAYMENTS Name Type Mandatory Description &lt;Record Type =&#8221;26&#8220;&gt; Long Y Type of object to import. 26 is for payment &lt;DBId&gt;&lt;\/DBId&gt; Long Y Database ID in DeMaSy. &lt;Ref&gt;&lt;\/Ref&gt; Char 255 N Internal reference &lt;Desc&gt;&lt;\/Desc&gt; Char 255 N Internal description &lt;Type&gt;&lt;\/Type&gt; Long Y Type: 0 = Normal invoice payment 4 = Fees without VAT \/ [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[15,64,12],"class_list":["post-1426","post","type-post","status-publish","format-standard","hentry","category-utils","tag-interface","tag-invoice-payment","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1426","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1426"}],"version-history":[{"count":26,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1426\/revisions"}],"predecessor-version":[{"id":6879,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1426\/revisions\/6879"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1426"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1426"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1426"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}