Company

COMPANY

Name Type Mandatory Description
<Record Type =”1“> Long Y Type of object to import. 1 is for company
<DBId></DBId> Long Y Database ID in DeMaSy.
<CompanyId></CompanyId> Integer N Company Id (if entered, prior search criteria, before name, to identify Company)
<Name></Name> Char(75) Y Company name
<CompanyTypeLabel> </CompanyTypeLabel> Char(30) N Company type (S.A. / S.à r.l.,…)
<Telephone1></Telephone1> Char(83) N Phone number 1
<Telephone2></Telephone2> Char(83) N Phone number 2
<Fax></Fax> Char(83) N Fax number
<Reception></Reception> Char(10) N Reception phone extension
<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)
<MailCountry></MailCountry> Char(10) N ISO country code (Mail address) 2 positions
<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)
<LegalCountry></LegalCountry> Char(10) N ISO country code (Legal address) 2 positions
<Comment></Comment> Char(255) N Comment (free text)
<EMail></EMail> Char(255) N Email of the company
<URL></URL> Char(255) N URL of the company
<Mail></Mail> Boolean N Included in Mailing List (Y/N)
<TaxVATNum></TaxVATNum> Char(50) N VAT Number
<VATFrequency></VATFrequency> Integer N Periodicity of VAT Return:
None = 0 / Weekly = 14 / Monthly = 13 / Quaterly = 16 / Yearly = 17
<Taxable></Taxable> Boolean N Taxable (Y/N)
<IBLCNum></IBLCNum> Char(50) N Intracom VAT Number
<RCNum></RCNum> Char(50) N RC Number
<BusinessNum></BusinessNum> Char(50) N Business Authorization Number
<LanguageName></LanguageName> Char(50) N Language
<IncDate></IncDate> Date/Time N Incorporation date (YYYYMMDD)
<LastTaxFiling></LastTaxFiling> Date/Time N Last Tax Filiing Date (YYYYMMDD)
<LastVATReturn></LastVATReturn> Date/Time N Last VAT Return Date (YYYYMMDD)
<LastBalance></LastBalance> Date/Time N Last Balance Sheet Date (YYYYMMDD)
<LastBalanceFiled></LastBalanceFiled> Date/Time N Last Balance Filed Sheet (YYYYMMDD)
<MngPlace></MngPlace> Char(50) N Management Place
<Activity></Activity> Char(50) N Sector of Activity
<SMDate></SMDate> Date/Time N Shareholders Meeting Date (YYYYMMDD)
<SMPlace></SMPlace> Char(50) N Shareholders Meeting place
<IsBank></IsBank> Boolean N Bank (Y/N)
<SwiftCode></SwiftCode> Char(50) N Swift code if Bank
<Telex></Telex> Char(50) N Telex
<LastAmendment></LastAmendment> Date/Time N Last date of change of the articles of incorporation (YYYYMMDD)
<CompanyCurrency></CompanyCurrency> Char(10) N Capital currency
<ParValue></ParValue> Double N Nominal value of shares
<PaidInCapital></PaidInCapital> Double N Paid in Capital amount
<IssuedCapital></IssuedCapital> Double N Subscribed capital amount
<AuthCapital></AuthCapital> Double N Authorized capital amount
<MemoField></MemoField> Memo N Free memo
<Status></Status> Char(50) N Status of the company
<Category></Category> Char(50) N Company category
<CorporateTaxDueDate></CorporateTaxDueDate> Date/Time N Corporate tax due date (YYYYMMDD)
<Reservation></Reservation> Integer N Reserved for Sale (Y/N)
<JuridictionCountry></JuridictionCountry> Char(255) N Jurisdiction country (ISO code 2 positions)
<AnnualAccountDueDate></AnnualAccountDueDate> Date/Time N Annual Account Due date (YYYYMMDD)
<MFSAReturnDueDate></MFSAReturnDueDate> Date/Time N MFSA Return Due date (YYYYMMDD)
<MFSAReturnSendDate></MFSAReturnSendDate> Date/Time N MFSA Return Send date (YYYYMMDD)
<FirstYearEnd></FirstYearEnd> Date/Time N First year-end (YYYYMMDD)
<FirstYearOfAssessment></FirstYearOfAssessment> Date/Time N First year of Assessment (YYYYMMDD)
<TaxOffice></TaxOffice> Char(255) N Tax office
<GLPeriodStartDate></GLPeriodStartDate> Date/Time N Accounting period start date (YYYYMMDD)
<GLPeriodEndDate></GLPeriodEndDate> Date/Time N Accounting period end date (YYYYMMDD)
<LEINumber></LEINumber> Char(30) N LEI Number
<RepeatFrequency></RepeatFrequency> Short N JANUARY = 1
FEBRUARY = 2
MARCH = 3
APRIL = 4
MAY = 5
JUNE = 6
JULY = 7
AUGUST = 8
SEPTEMBER = 9
OCTOBER = 10
NOVEMBER = 11
DECEMBER = 12
MONTHLY = 13
WEEKLY = 14
DAILY = 15
QUARTERLY = 16
YEARLY = 17
SEMIANNUALLY = 18
<RepeatNumber></RepeatNumber> Short N FIRST = 1
SECOND = 2
THIRD = 3
FOURTH = 4
LAST = 5
<RepeatTime></RepeatTime> Date/Time N Time (00:00:00)
<RepeatType></RepeatType> Short N MONDAY = 1
TUESDAY = 2
WEDNESDAY = 3
THURSDAY = 4
FRIDAY = 5
SATURDAY = 6
SUNDAY = 7
</Record> Y End of block

PDF version
Excel version