{"id":1966,"date":"2014-07-11T11:02:05","date_gmt":"2014-07-11T10:02:05","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1966&#038;lang=en"},"modified":"2020-10-15T09:37:22","modified_gmt":"2020-10-15T08:37:22","slug":"1966","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1966","title":{"rendered":"Company"},"content":{"rendered":"<h3><span style=\"text-decoration: underline; color: #ff0000;\"><b>COMPANY:<\/b><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td valign=\"center\">RecordType;DBId;Name;CompanyTypeLabel;Status;Comment;URL;Mail;TaxVATNum;VATFrequency;Taxable;IBLCNum;RCNum;BusinessNum;LanguageName;<br>IncDate;LastTaxFiling;LastVATReturn;LastBalance;MngPlace;Activity;SMDate;SMPlace;IsBank;SwiftCode;Telex;Category;LastAmendment;CompanyCurrency;<br>ParValue;PaidInCapital;IssuedCapital;AuthCapital;MemoField<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<table>\n<tbody>\n<tr>\n<th width=\"10\">Nr<\/th>\n<th width=\"250\">Name<\/th>\n<th width=\"20\">Type<\/th>\n<th width=\"350\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">1<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RecordType<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Type of object to import. 1 is for company<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">2<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">DBId<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td valign=\"top\">Database ID in DeMaSy.<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">3<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Name<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\">Company name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">4<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CompanyTypeLabel<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\">Company type (S.A. \/ S.\u00e0 r.l.,&#8230;)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">5<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Status<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Status of the company<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">6<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Comment<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td valign=\"top\">Comment (free text)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">7<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">URL<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td valign=\"top\">URL of the company<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">8<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Mail<\/span><\/td>\n<td valign=\"top\">Boolean<\/td>\n<td valign=\"top\">N\/A<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">9<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">TaxVATNum<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">VAT Number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">10<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">VATFrequency<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td valign=\"top\">Periodicity of VAT Return:<br>None = 0 \/ Weekly = 14 \/ Monthly = 13 \/ Quaterly = 16 \/ Yearly = 17&nbsp;<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">11<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Taxable<\/span><\/td>\n<td valign=\"top\">Boolean<\/td>\n<td valign=\"top\">Taxable (Y\/N)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">12<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">IBLCNum<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Intracom VAT Number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">13<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RCNum<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">RC Number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">14<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">BusinessNum<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Business Authorization Number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">15<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">LanguageName<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Language<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">16<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">IncDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Incorporation date (YYYYMMDD)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">17<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">LastTaxFiling<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Last Tax Filiing Date (YYYYMMDD)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">18<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">LastVATReturn<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Last VAT Return Date (YYYYMMDD)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">19<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">LastBalance<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Last Balance Sheet Date (YYYYMMDD)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">20<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">MngPlace<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Management Place<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">21<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Activity<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Sector of Activity<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">22<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">SMDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Shareholders Meeting Date (YYYYMMDD)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">23<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">SMPlace<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Shareholders Meeting place<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">24<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">IsBank<\/span><\/td>\n<td valign=\"top\">Boolean<\/td>\n<td valign=\"top\">Bank (Y\/N)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">25<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">SwiftCode<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Swift code if Bank<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">26<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Telex<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Telex<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">27<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Category<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\">Company category<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">28<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">LastAmendment<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\">Last date of change of the articles of incorporation (YYYYMMDD)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">29<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CompanyCurrency<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td valign=\"top\">Capital currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">30<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ParValue<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Nominal value of shares<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">31<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PaidInCapital<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Paid in Capital amount<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">32<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">IssuedCapital<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Subscribed capital amount<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">33<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">AuthCapital<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\">Authorized capital amount<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">34<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">MemoField<\/span><\/td>\n<td valign=\"top\">Memo<\/td>\n<td valign=\"top\">Free memo<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>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.\u00e0 r.l.,&#8230;) 5 Status Char(50) Status of the company 6 Comment Char(255) Comment (free text) 7 URL Char(255) [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[237],"tags":[],"class_list":["post-1966","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1966","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1966"}],"version-history":[{"count":26,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1966\/revisions"}],"predecessor-version":[{"id":11081,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1966\/revisions\/11081"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}