COMPANY:
RecordType;DBId;Name;CompanyTypeLabel;Status;Comment;URL;Mail;TaxVATNum;VATFrequency;Taxable;IBLCNum;RCNum;BusinessNum;LanguageName; IncDate;LastTaxFiling;LastVATReturn;LastBalance;MngPlace;Activity;SMDate;SMPlace;IsBank;SwiftCode;Telex;Category;LastAmendment;CompanyCurrency; ParValue;PaidInCapital;IssuedCapital;AuthCapital;MemoField |
Nr | Name | Type | Description |
---|---|---|---|
1 | RecordType | Long | Type of object to import. 1 is for company |
2 | DBId | Long | Database ID in DeMaSy. |
3 | Name | Char(75) | Company name |
4 | CompanyTypeLabel | Char(30) | Company type (S.A. / S.à r.l.,…) |
5 | Status | Char(50) | Status of the company |
6 | Comment | Char(255) | Comment (free text) |
7 | URL | Char(255) | URL of the company |
8 | Boolean | N/A | |
9 | TaxVATNum | Char(50) | VAT Number |
10 | VATFrequency | Integer | Periodicity of VAT Return: None = 0 / Weekly = 14 / Monthly = 13 / Quaterly = 16 / Yearly = 17 |
11 | Taxable | Boolean | Taxable (Y/N) |
12 | IBLCNum | Char(50) | Intracom VAT Number |
13 | RCNum | Char(50) | RC Number |
14 | BusinessNum | Char(50) | Business Authorization Number |
15 | LanguageName | Char(50) | Language |
16 | IncDate | Date/Time | Incorporation date (YYYYMMDD) |
17 | LastTaxFiling | Date/Time | Last Tax Filiing Date (YYYYMMDD) |
18 | LastVATReturn | Date/Time | Last VAT Return Date (YYYYMMDD) |
19 | LastBalance | Date/Time | Last Balance Sheet Date (YYYYMMDD) |
20 | MngPlace | Char(50) | Management Place |
21 | Activity | Char(50) | Sector of Activity |
22 | SMDate | Date/Time | Shareholders Meeting Date (YYYYMMDD) |
23 | SMPlace | Char(50) | Shareholders Meeting place |
24 | IsBank | Boolean | Bank (Y/N) |
25 | SwiftCode | Char(50) | Swift code if Bank |
26 | Telex | Char(50) | Telex |
27 | Category | Char(50) | Company category |
28 | LastAmendment | Date/Time | Last date of change of the articles of incorporation (YYYYMMDD) |
29 | CompanyCurrency | Char(10) | Capital currency |
30 | ParValue | Double | Nominal value of shares |
31 | PaidInCapital | Double | Paid in Capital amount |
32 | IssuedCapital | Double | Subscribed capital amount |
33 | AuthCapital | Double | Authorized capital amount |
34 | MemoField | Memo | Free memo |