{"id":1940,"date":"2014-07-11T10:45:32","date_gmt":"2014-07-11T09:45:32","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1940&lang=en"},"modified":"2020-10-19T09:16:08","modified_gmt":"2020-10-19T08:16:08","slug":"1940","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1940","title":{"rendered":"Person"},"content":{"rendered":"

Person:<\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;Title;FirstName;LastName;BDate;BPlace;Sex;Comment;URL;TaxVATNum;VATFrequency;IBLCNum;BusinessNum;PassportNum;
Profession;LanguageName;CivilStatus;NationalityName;LastVATReturn;LastTaxFiling;LastBalance;MemoField;IdentityCard<\/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\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. 2 is for person<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase ID in DeMaSy.<\/td>\n<\/tr>\n
3<\/td>\nTitle<\/span><\/td>\nChar(25)<\/td>\nTitle of the person<\/td>\n<\/tr>\n
4<\/td>\nFirstName<\/span><\/td>\nChar(30)<\/td>\nFirst name<\/td>\n<\/tr>\n
5<\/td>\nLastName<\/span><\/td>\nChar(45)<\/td>\nLast Name<\/td>\n<\/tr>\n
6<\/td>\nBDate<\/span><\/td>\nDate\/Time<\/td>\nBirth date (YYYYMMDD)<\/td>\n<\/tr>\n
7<\/td>\nBPlace<\/span><\/td>\nChar(30)<\/td>\nBirth place<\/td>\n<\/tr>\n
8<\/td>\nSex<\/span><\/td>\nChar(1)<\/td>\nSex (M\/F)<\/td>\n<\/tr>\n
9<\/td>\nComment<\/span><\/td>\nChar(255)<\/td>\nComment (free text)<\/td>\n<\/tr>\n
10<\/td>\nMail<\/td>\nBoolean<\/td>\nMailing list (Y\/N)<\/td>\n<\/tr>\n
11<\/td>\nURL<\/span><\/td>\nChar(255)<\/td>\nURL of web site of the person<\/td>\n<\/tr>\n
12<\/td>\nTaxVATNum<\/span><\/td>\nChar(50)<\/td>\nTax VAT number<\/td>\n<\/tr>\n
13<\/td>\nVATFrequency<\/span><\/td>\nInteger<\/td>\nFrequency of VAT:
1 = Yearly \/ 2 = Quaterly \/ 3 = Monthly<\/td>\n<\/tr>\n
14<\/td>\nIBLCNum<\/span><\/td>\nChar(50)<\/td>\nVAT Intracom Number<\/td>\n<\/tr>\n
15<\/td>\nBusinessNum<\/span><\/td>\nChar(50)<\/td>\nBusiness Authorization number<\/td>\n<\/tr>\n
16<\/td>\nPassportNum<\/span><\/td>\nChar(50)<\/td>\nPassport number<\/td>\n<\/tr>\n
17<\/td>\nProfession<\/span><\/td>\nChar(50)<\/td>\nProfession<\/td>\n<\/tr>\n
18<\/td>\nLanguageName<\/span><\/td>\nChar(50)<\/td>\nLanguage<\/td>\n<\/tr>\n
19<\/td>\nCivilStatus<\/span><\/td>\nChar(50)<\/td>\nMarital status<\/td>\n<\/tr>\n
20<\/td>\nNationalityName<\/span><\/td>\nChar(50)<\/td>\nNationality (ISO code)<\/td>\n<\/tr>\n
21<\/td>\nLastVATReturn<\/span><\/td>\nDate\/Time<\/td>\nLast VAT Date (YYYYMMDD)<\/td>\n<\/tr>\n
22<\/td>\nLastTaxFiling<\/span><\/td>\nDate\/Time<\/td>\nLast of tax Filling (YYYYMMDD)<\/td>\n<\/tr>\n
23<\/td>\nLastBalance<\/span><\/td>\nDate\/Time<\/td>\nLast balance sheet date (YYYYMMDD)<\/td>\n<\/tr>\n
24<\/td>\nMemoField<\/span><\/td>\nMemo<\/td>\nMemo<\/td>\n<\/tr>\n
25<\/td>\nIdentityCard<\/span><\/td>\nChar(50)<\/td>\nIdentity card number<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n

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

Person: RecordType;DBId;Title;FirstName;LastName;BDate;BPlace;Sex;Comment;URL;TaxVATNum;VATFrequency;IBLCNum;BusinessNum;PassportNum;Profession;LanguageName;CivilStatus;NationalityName;LastVATReturn;LastTaxFiling;LastBalance;MemoField;IdentityCard Nr Name Type Description 1 RecordType Long Type of object to import. 2 is for person 2 DBId Long Database ID in DeMaSy. 3 Title Char(25) Title of the person 4 FirstName Char(30) First name 5 LastName Char(45) Last Name 6 BDate Date\/Time Birth date (YYYYMMDD) 7 BPlace Char(30) Birth place 8 Sex […]<\/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-1940","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1940","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=1940"}],"version-history":[{"count":20,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1940\/revisions"}],"predecessor-version":[{"id":11101,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1940\/revisions\/11101"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1940"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1940"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1940"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}