{"id":11165,"date":"2021-01-24T10:29:31","date_gmt":"2021-01-24T09:29:31","guid":{"rendered":"https:\/\/sdna.lu\/?p=11165"},"modified":"2021-01-24T13:42:40","modified_gmt":"2021-01-24T12:42:40","slug":"currency-rate-3","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=11165","title":{"rendered":"Currency rate"},"content":{"rendered":"<h3><span style=\"color: #ff0000;\"><b><span style=\"text-decoration: underline;\">Currency rate:<\/span><\/b><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td valign=\"center\">RecordType;DBId;StartDate;EndDate;OrgCurrency;DestCurrency;Value;BuyValue;SellValue;InputValue;Invert;RoundPos<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Nr<\/th>\n<th width=\"250\">Name<\/th>\n<th width=\"20\">Type<\/th>\n<th width=\"350\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">1<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RecordType<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Type of object to import. 51 is for currency rates<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">2<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">DBId<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">3<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">StartDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Date of exchange rate<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">4<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">EndDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Date at which the exchange rate is no longer valid.<br>If no date is given, DeMaSy will fit it in automatically.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">5<\/td>\n<td valign=\"top\">OrgCurrency<\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Reference currency \u2013 ISO code.<br>Currency against which all the rates are expressed. Has to be the same for all the rates provided.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">6<\/td>\n<td valign=\"top\">DestCurrency<\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Currency for which rate is provided \u2013 ISO code<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">7<\/td>\n<td valign=\"top\">Value<\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">The currency rate<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">8<\/td>\n<td valign=\"top\">BuyValue<\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Exchange rate \u2013 buy<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">9<\/td>\n<td valign=\"top\">SellValue<\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Exchange rate \u2013 sell<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">10<\/td>\n<td valign=\"top\">InputValue<\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Exchange rate (average value between buy and sell values if provided)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">11<\/td>\n<td valign=\"top\">Invert<\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Exchange rate is to be inverted. Give -1 as value.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">12<\/td>\n<td valign=\"top\">RoundPos<\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Number of decimals<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Currency rate: RecordType;DBId;StartDate;EndDate;OrgCurrency;DestCurrency;Value;BuyValue;SellValue;InputValue;Invert;RoundPos Nr Name Type Description 1 RecordType Long Type of object to import. 51 is for currency rates 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 StartDate Date\/Time Date of exchange rate 4 EndDate Date\/Time Date at which the exchange rate is no longer valid.If no date is [&hellip;]<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[42,15,485],"class_list":["post-11165","post","type-post","status-publish","format-standard","hentry","category-interface-utils","tag-currency-rate","tag-interface","tag-text-interface"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/11165","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\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=11165"}],"version-history":[{"count":4,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/11165\/revisions"}],"predecessor-version":[{"id":11183,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/11165\/revisions\/11183"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=11165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=11165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=11165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}