{"id":1854,"date":"2014-07-11T10:11:46","date_gmt":"2014-07-11T09:11:46","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1854&lang=en"},"modified":"2021-01-25T15:16:30","modified_gmt":"2021-01-25T14:16:30","slug":"address-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1854","title":{"rendered":"Address"},"content":{"rendered":"

Address:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;CompanyName;PersonName;AddressType;HouseNum;Street;Building;Locality;PostalCode;CountryCode;
RegionName;StartDate;EndDate;Comment;OrgAddressName;OwnerCompanyName;OwnerPersonName<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 3 is for Address<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
3<\/td>\nCompanyName<\/span><\/td>\nChar(75)<\/td>\nName of the company linked to the address<\/td>\n<\/tr>\n
4<\/td>\nPersonName<\/span><\/td>\nChar(75)<\/td>\nName of the person linked to the address<\/td>\n<\/tr>\n
5<\/td>\nAddressType<\/span><\/td>\nChar(50)<\/td>\nType of address<\/td>\n<\/tr>\n
6<\/td>\nHouseNum<\/span><\/td>\nChar(10)<\/td>\nNumber of the address<\/td>\n<\/tr>\n
7<\/td>\nStreet<\/span><\/td>\nChar(50)<\/td>\nStreet of the address<\/td>\n<\/tr>\n
8<\/td>\nBuilding<\/span><\/td>\nChar(50)<\/td>\nBuilding of the address<\/td>\n<\/tr>\n
9<\/td>\nLocality<\/span><\/td>\nChar(75)<\/td>\nLocality of the address<\/td>\n<\/tr>\n
10<\/td>\nPostalCode<\/span><\/td>\nChar(10)<\/td>\nPostal code of the address<\/td>\n<\/tr>\n
11<\/td>\nCountryName<\/span><\/td>\nChar(50)<\/td>\nCountry of the address<\/td>\n<\/tr>\n
12<\/td>\nCountryCode<\/span><\/td>\nChar(10)<\/td>\nCode of the country<\/td>\n<\/tr>\n
13<\/td>\nRegionName<\/span><\/td>\nChar(50)<\/td>\nRegion of the address<\/td>\n<\/tr>\n
14<\/td>\nStartDate<\/span><\/td>\nDate\/Time<\/td>\nFirst day to use this address<\/td>\n<\/tr>\n
15<\/td>\nEndDate<\/span><\/td>\nDate\/Time<\/td>\nLast day to use this address<\/td>\n<\/tr>\n
16<\/td>\nComment<\/span><\/td>\nChar(255)<\/td>\nComment on the address<\/td>\n<\/tr>\n
17<\/td>\nOrgAddressName<\/span><\/td>\nChar(255)<\/td>\nName of commercial domicile<\/td>\n<\/tr>\n
18<\/td>\nOwnerCompanyName<\/span><\/td>\nChar(75)<\/td>\nName of the Owner Company<\/td>\n<\/tr>\n
19<\/td>\nOwnerPersonName<\/span><\/td>\nChar(75)<\/td>\nName of the Owner Person<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Address: RecordType;DBId;CompanyName;PersonName;AddressType;HouseNum;Street;Building;Locality;PostalCode;CountryCode;RegionName;StartDate;EndDate;Comment;OrgAddressName;OwnerCompanyName;OwnerPersonName Nr Name Type Description 1 RecordType Long Type of object to import. 3 is for Address 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 CompanyName Char(75) Name of the company linked to the address 4 PersonName Char(75) Name of the person linked to the address 5 AddressType Char(50) […]<\/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-1854","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1854","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=1854"}],"version-history":[{"count":11,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1854\/revisions"}],"predecessor-version":[{"id":11198,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1854\/revisions\/11198"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}