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 |