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 |