{"id":1689,"date":"2014-06-27T07:59:50","date_gmt":"2014-06-27T06:59:50","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1689&lang=en"},"modified":"2020-11-12T10:17:36","modified_gmt":"2020-11-12T09:17:36","slug":"1689","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1689","title":{"rendered":"Person"},"content":{"rendered":"

PERSON<\/b><\/span><\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nType<\/th>\nMandatory<\/th>\nDescription<\/th>\n<\/tr>\n
<Record Type<\/span><\/span> =”2<\/span>“><\/td>\nLong<\/td>\nY<\/td>\nType of object to import. 2 is for person<\/td>\n<\/tr>\n
<DBId><\/DBId><\/span><\/td>\nLong<\/td>\nY<\/td>\nDatabase ID in DeMaSy.<\/td>\n<\/tr>\n
<PersonId><\/PersonId><\/span><\/td>\nLong<\/td>\nN<\/td>\nPerson Id (if entered, prior search criteria, before name, to identify Person)<\/td>\n<\/tr>\n
<Name><\/Name><\/span><\/td>\nChar(75)<\/td>\nY<\/td>\nName of the person<\/td>\n<\/tr>\n
<Title><\/Title><\/span><\/td>\nChar(25)<\/td>\nY<\/td>\nTitle of the person<\/td>\n<\/tr>\n
<FirstName><\/FirstName><\/span><\/td>\nChar(30)<\/td>\nY<\/td>\nFirst name<\/td>\n<\/tr>\n
<LastName><\/LastName><\/span><\/td>\nChar(45)<\/td>\nY<\/td>\nLast Name<\/td>\n<\/tr>\n
<Telephone1><\/Telephone1><\/span><\/td>\nChar(83)<\/td>\nN<\/td>\nPhone number 1<\/td>\n<\/tr>\n
<Telephone2><\/Telephone2><\/span><\/td>\nChar(83)<\/td>\nN<\/td>\nPhone number 2<\/td>\n<\/tr>\n
<Fax><\/Fax><\/span><\/td>\nChar(83)<\/td>\nN<\/td>\nFax number<\/td>\n<\/tr>\n
<MailHouseNum><\/MailHouseNum><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nHouse number (Mail address)<\/td>\n<\/tr>\n
<MailStreet><\/MailStreet><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nStreet (Mail address)<\/td>\n<\/tr>\n
<MailBuilding><\/MailBuilding><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nBuilding (Mail address)<\/td>\n<\/tr>\n
<MailLocality><\/MailLocality><\/span><\/td>\nChar(75)<\/td>\nN<\/td>\nLocality (Mail address)<\/td>\n<\/tr>\n
<MailPostalCode><\/MailPostalCode><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nPostal code (Mail address)<\/td>\n<\/tr>\n
<MailCountryCodeOld><\/MailCountryCodeOld><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nOld ISO Country code (Mail address)<\/td>\n<\/tr>\n
<MailCountryCode><\/MailCountryCode><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nISO Country code (Mail address)<\/td>\n<\/tr>\n
<LegalHouseNum><\/LegalHouseNum><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nHouse Number (Legal address)<\/td>\n<\/tr>\n
<LegalStreet><\/LegalStreet><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nStreet (Legal address)<\/td>\n<\/tr>\n
<LegalBuilding><\/LegalBuilding><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nBuilding (Legal address)<\/td>\n<\/tr>\n
<LegalLocality><\/LegalLocality><\/span><\/td>\nChar(75)<\/td>\nN<\/td>\nLocality (Legal address)<\/td>\n<\/tr>\n
<LegalPostalCode><\/LegalPostalCode><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nPostal code (Legal address)<\/td>\n<\/tr>\n
<LegalCountryCode><\/LegalCountryCode><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nISO Country code (legal address)<\/td>\n<\/tr>\n
<EMail><\/EMail><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nEmail of the person<\/td>\n<\/tr>\n
<BDate><\/BDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nBirth date (YYYYMMDD)<\/td>\n<\/tr>\n
<BPlace><\/BPlace><\/span><\/td>\nChar(30)<\/td>\nN<\/td>\nBirth place<\/td>\n<\/tr>\n
<DDate><\/DDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nDeath date (YYYYMMDD)<\/td>\n<\/tr>\n
<DPlace><\/DPlace><\/span><\/td>\nChar(30)<\/td>\nN<\/td>\nDeath place<\/td>\n<\/tr>\n
<Sex><\/Sex><\/span><\/td>\nChar(1)<\/td>\nN<\/td>\nSex (M\/F)<\/td>\n<\/tr>\n
<Comment><\/Comment><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nComment (free text)<\/td>\n<\/tr>\n
<Mail><\/Mail><\/span><\/td>\nBoolean<\/td>\nY<\/td>\nMailing list (Y\/N)<\/td>\n<\/tr>\n
<URL><\/URL><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nURL of web site of the person<\/td>\n<\/tr>\n
<TaxVATNum><\/TaxVATNum><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nTax VAT number<\/td>\n<\/tr>\n
<VATFrequency><\/VATFrequency><\/span><\/td>\nInteger<\/td>\nN<\/td>\nFrequency of VAT:
\n1 = Yearly \/ 2 = Quaterly \/ 3 = Monthly<\/td>\n<\/tr>\n
<IBLCNum><\/IBLCNum><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nVAT Intracom Number<\/td>\n<\/tr>\n
<BusinessNum><\/BusinessNum><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nBusiness Authorization number<\/td>\n<\/tr>\n
<PassportNum><\/PassportNum><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nPassport number<\/td>\n<\/tr>\n
<PassportNumEndDate><\/PassportNumEndDate><\/span><\/td>\nDate<\/td>\nN<\/td>\nPassport number end date<\/td>\n<\/tr>\n
<Profession><\/Profession><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nProfession<\/td>\n<\/tr>\n
<LanguageName><\/LanguageName><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nLanguage<\/td>\n<\/tr>\n
<CivilStatus><\/CivilStatus><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nMarital status<\/td>\n<\/tr>\n
<NationalityName><\/NationalityName><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nNationality (ISO code)<\/td>\n<\/tr>\n
<NationalityNameOld><\/NationalityNameOld><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nOld Nationality (ISO code)<\/td>\n<\/tr>\n
<LastVATReturn><\/LastVATReturn><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nLast VAT Date (YYYYMMDD)<\/td>\n<\/tr>\n
<LastTaxFiling><\/LastTaxFiling><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nLast of tax Filling (YYYYMMDD)<\/td>\n<\/tr>\n
<LastBalance><\/LastBalance><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nLast balance sheet date (YYYYMMDD)<\/td>\n<\/tr>\n
<MemoField><\/MemoField><\/span><\/td>\nMemo<\/td>\nN<\/td>\nMemo<\/td>\n<\/tr>\n
<Status><\/Status><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nStatus<\/td>\n<\/tr>\n
<IdentityCard><\/IdentityCard><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nIdentity card number<\/td>\n<\/tr>\n
<TaxVATNumRegisterDate><\/TaxVATNumRegisterDate><\/span><\/td>\nDate<\/td>\nN<\/td>\nTax VAT number registration date<\/td>\n<\/tr>\n
<PeriodicVATDeadline><\/PeriodicVATDeadline><\/span><\/td>\nDouble<\/td>\nN<\/td>\nPeriodic VAT deadline<\/td>\n<\/tr>\n
<FileNumber><\/FileNumber><\/span><\/td>\nChar(25)<\/td>\nN<\/td>\nFile number<\/td>\n<\/tr>\n
<TIN><\/TIN><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nTIN<\/td>\n<\/tr>\n
<\/Record><\/span><\/td>\n<\/td>\nY<\/td>\nEnd of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

PDF version<\/a>
\nExcel version<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

PERSON Name Type Mandatory Description <Record Type =”2“> Long Y Type of object to import. 2 is for person <DBId><\/DBId> Long Y Database ID in DeMaSy. <PersonId><\/PersonId> Long N Person Id (if entered, prior search criteria, before name, to identify Person) <Name><\/Name> Char(75) Y Name of the person <Title><\/Title> Char(25) Y Title of the person […]<\/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,429,12],"class_list":["post-1689","post","type-post","status-publish","format-standard","hentry","category-utils","tag-interface","tag-person","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1689","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=1689"}],"version-history":[{"count":39,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1689\/revisions"}],"predecessor-version":[{"id":11122,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1689\/revisions\/11122"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}