Person

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
<FirstName></FirstName> Char(30) Y First name
<LastName></LastName> Char(45) Y Last Name
<Telephone1></Telephone1> Char(83) N Phone number 1
<Telephone2></Telephone2> Char(83) N Phone number 2
<Fax></Fax> Char(83) N Fax number
<MailHouseNum></MailHouseNum> Char(10) N House number (Mail address)
<MailStreet></MailStreet> Char(50) N Street (Mail address)
<MailBuilding></MailBuilding> Char(50) N Building (Mail address)
<MailLocality></MailLocality> Char(75) N Locality (Mail address)
<MailPostalCode></MailPostalCode> Char(10) N Postal code (Mail address)
<MailCountryCodeOld></MailCountryCodeOld> Char(10) N Old ISO Country code (Mail address)
<MailCountryCode></MailCountryCode> Char(10) N ISO Country code (Mail address)
<LegalHouseNum></LegalHouseNum> Char(10) N House Number (Legal address)
<LegalStreet></LegalStreet> Char(50) N Street (Legal address)
<LegalBuilding></LegalBuilding> Char(50) N Building (Legal address)
<LegalLocality></LegalLocality> Char(75) N Locality (Legal address)
<LegalPostalCode></LegalPostalCode> Char(10) N Postal code (Legal address)
<LegalCountryCode></LegalCountryCode> Char(10) N ISO Country code (legal address)
<EMail></EMail> Char(255) N Email of the person
<BDate></BDate> Date/Time N Birth date (YYYYMMDD)
<BPlace></BPlace> Char(30) N Birth place
<DDate></DDate> Date/Time N Death date (YYYYMMDD)
<DPlace></DPlace> Char(30) N Death place
<Sex></Sex> Char(1) N Sex (M/F)
<Comment></Comment> Char(255) N Comment (free text)
<Mail></Mail> Boolean Y Mailing list (Y/N)
<URL></URL> Char(255) N URL of web site of the person
<TaxVATNum></TaxVATNum> Char(50) N Tax VAT number
<VATFrequency></VATFrequency> Integer N Frequency of VAT:
1 = Yearly / 2 = Quaterly / 3 = Monthly
<IBLCNum></IBLCNum> Char(50) N VAT Intracom Number
<BusinessNum></BusinessNum> Char(50) N Business Authorization number
<PassportNum></PassportNum> Char(50) N Passport number
<PassportNumEndDate></PassportNumEndDate> Date N Passport number end date
<Profession></Profession> Char(50) N Profession
<LanguageName></LanguageName> Char(50) N Language
<CivilStatus></CivilStatus> Char(50) N Marital status
<NationalityName></NationalityName> Char(50) N Nationality (ISO code)
<NationalityNameOld></NationalityNameOld> Char(50) N Old Nationality (ISO code)
<LastVATReturn></LastVATReturn> Date/Time N Last VAT Date (YYYYMMDD)
<LastTaxFiling></LastTaxFiling> Date/Time N Last of tax Filling (YYYYMMDD)
<LastBalance></LastBalance> Date/Time N Last balance sheet date (YYYYMMDD)
<MemoField></MemoField> Memo N Memo
<Status></Status> Char(50) N Status
<IdentityCard></IdentityCard> Char(50) N Identity card number
<TaxVATNumRegisterDate></TaxVATNumRegisterDate> Date N Tax VAT number registration date
<PeriodicVATDeadline></PeriodicVATDeadline> Double N Periodic VAT deadline
<FileNumber></FileNumber> Char(25) N File number
<TIN></TIN> Char(50) N TIN
</Record> Y End of block

PDF version
Excel version