{"id":1902,"date":"2014-07-11T10:31:41","date_gmt":"2014-07-11T09:31:41","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1902&#038;lang=en"},"modified":"2020-07-30T13:52:04","modified_gmt":"2020-07-30T12:52:04","slug":"country-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1902","title":{"rendered":"Country"},"content":{"rendered":"<h3><span style=\"color: #ff0000;\"><b><span style=\"text-decoration: underline;\">Country:<\/span><\/b><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td valign=\"center\">RecordType;DBId;Name;Code;CountryZip;Nationality;CountryCurrency;CurrencyName;RateFreezeDate;UseCurrency;<br \/>\nRoundPos;RoundType<\/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. 50 is for country<\/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;\">Name<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Name of the country<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">4<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Code<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Code of the country<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">5<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CountryZip<\/span><\/td>\n<td valign=\"top\">Char(4)<\/td>\n<td valign=\"top\">Zip code for the country<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">6<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Nationality<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Nationality for this country<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">7<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CountryCurrency<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Currency of the country<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">8<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CurrencyName<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\">Name of the currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">9<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RateFreezeDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Date of the freeze rate<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">10<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">UseCurrency<\/span><\/td>\n<td valign=\"top\">Boolean<\/td>\n<td valign=\"top\">True if the currency can be used<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">11<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RoundPos<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td valign=\"top\">Number of decimals for the currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">12<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RoundType<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td valign=\"top\">Round type:<br \/>\n0 = no round<br \/>\n1 = 0,5 is not rounded<br \/>\n2 = 0,5 is rounded down<br \/>\n3 = 0,5 is rounded up<br \/>\n4 = rounded down<br \/>\n5 = rounded up<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Country: RecordType;DBId;Name;Code;CountryZip;Nationality;CountryCurrency;CurrencyName;RateFreezeDate;UseCurrency; RoundPos;RoundType Nr Name Type Description 1 RecordType Long Type of object to import. 50 is for country 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 Name Char(50) Name of the country 4 Code Char(10) Code of the country 5 CountryZip Char(4) Zip code for the country 6 Nationality [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-1902","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1902","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=1902"}],"version-history":[{"count":5,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1902\/revisions"}],"predecessor-version":[{"id":9317,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1902\/revisions\/9317"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}