{"id":1437,"date":"2014-05-23T10:59:37","date_gmt":"2014-05-23T09:59:37","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1437&#038;lang=en"},"modified":"2021-01-25T16:29:55","modified_gmt":"2021-01-25T15:29:55","slug":"address","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1437","title":{"rendered":"Address"},"content":{"rendered":"<h3><b><span style=\"text-decoration: underline;\">Address:<\/span><\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<th width=\"350px\">Name<\/th>\n<th width=\"20px\">Type<\/th>\n<th width=\"15px\">Mandatory<\/th>\n<th width=\"250px\">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;\">3<\/span>&#8220;&gt;<\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of object to import. 3 is for Address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;DBId&gt;&lt;\/DBId&gt;<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CompanyName&gt;&lt;\/ CompanyName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Name of the company linked to the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;PersonName&gt;&lt;\/PersonName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Name of the person linked to the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;AddressType&gt;&lt;\/AddressType&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;HouseNum&gt;&lt;\/HouseNum&gt;<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Number of the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Street&gt;&lt;\/Street&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Street of the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Building&gt;&lt;\/Building&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Building of the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Locality&gt;&lt;\/Locality&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Locality of the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;PostalCode&gt;&lt;\/PostalCode&gt;<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Postal code of the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CountryName&gt;&lt;\/CountryName&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Country of the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CountryCode&gt;&lt;\/CountryCode&gt;<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Code of the country<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;RegionName&gt;&lt;\/RegionName&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Region of the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;StartDate&gt;&lt;\/StartDate&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">First day to use this address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;EndDate&gt;&lt;\/EndDate&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Last day to use this address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Comment&gt;&lt;\/Comment&gt;<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Comment on the address<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;OrgAddressName&gt;&lt;\/OrgAddressName&gt;<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Name of commercial domicile<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;OwnerCompanyName&gt;&lt;\/OwnerCompanyName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Name of the Owner Company<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;OwnerPersonName&gt;&lt;\/OwnerPersonName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Name of the Owner Person<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;\/Record&gt;<\/span><\/td>\n<td valign=\"top\">\u00a0<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">End of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><a href=\"https:\/\/sdna.lu\/?media_dl=11214\">PDF version<\/a><br \/><a href=\"https:\/\/sdna.lu\/?media_dl=11206\">Excel version<\/a><\/p>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Address: Name Type Mandatory Description &lt;Record Type =&#8221;3&#8220;&gt; Long Y Type of object to import. 3 is for Address &lt;DBId&gt;&lt;\/DBId&gt; Long Y Database Id in DeMaSy. It is displayed in Utilities &lt;CompanyName&gt;&lt;\/ CompanyName&gt; Char(75) Y Name of the company linked to the address &lt;PersonName&gt;&lt;\/PersonName&gt; Char(75) Y Name of the person linked to the address &lt;AddressType&gt;&lt;\/AddressType&gt; [&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":[62,15,12],"class_list":["post-1437","post","type-post","status-publish","format-standard","hentry","category-utils","tag-address","tag-interface","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1437","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=1437"}],"version-history":[{"count":16,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1437\/revisions"}],"predecessor-version":[{"id":11218,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1437\/revisions\/11218"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}