{"id":1424,"date":"2014-05-21T13:35:38","date_gmt":"2014-05-21T12:35:38","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1424&lang=en"},"modified":"2019-06-06T13:41:54","modified_gmt":"2019-06-06T12:41:54","slug":"company","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1424","title":{"rendered":"Company"},"content":{"rendered":"

COMPANY<\/b><\/span><\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Name<\/th>\nType<\/th>\nMandatory<\/th>\nDescription<\/th>\n<\/tr>\n
<Record Type<\/span><\/span> =”1<\/span>“><\/td>\nLong<\/td>\nY<\/td>\nType of object to import. 1 is for company<\/td>\n<\/tr>\n
<DBId><\/DBId><\/span><\/td>\nLong<\/td>\nY<\/td>\nDatabase ID in DeMaSy.<\/td>\n<\/tr>\n
<CompanyId><\/CompanyId><\/span><\/td>\nInteger<\/td>\nN<\/td>\nCompany Id (if entered, prior search criteria, before name, to identify Company)<\/td>\n<\/tr>\n
<Name><\/Name><\/span><\/td>\nChar(75)<\/td>\nY<\/td>\nCompany name<\/td>\n<\/tr>\n
<CompanyTypeLabel> <\/CompanyTypeLabel><\/span><\/td>\nChar(30)<\/td>\nN<\/td>\nCompany type (S.A. \/ S.\u00e0 r.l.,…)<\/td>\n<\/tr>\n
<Telephone1><\/Telephone1><\/span><\/td>\nChar(83)<\/td>\nN<\/td>\nPhone number 1<\/td>\n<\/tr>\n
<Telephone2><\/Telephone2><\/span><\/td>\nChar(83)<\/td>\nN<\/td>\nPhone number 2<\/td>\n<\/tr>\n
<Fax><\/Fax><\/span><\/td>\nChar(83)<\/td>\nN<\/td>\nFax number<\/td>\n<\/tr>\n
<Reception><\/Reception><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nReception phone extension<\/td>\n<\/tr>\n
<MailHouseNum><\/MailHouseNum><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nHouse number (Mail address)<\/td>\n<\/tr>\n
<MailStreet><\/MailStreet><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nStreet (Mail address)<\/td>\n<\/tr>\n
<MailBuilding><\/MailBuilding><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nBuilding (Mail address)<\/td>\n<\/tr>\n
<MailLocality><\/MailLocality><\/span><\/td>\nChar(75)<\/td>\nN<\/td>\nLocality (Mail address)<\/td>\n<\/tr>\n
<MailPostalCode><\/MailPostalCode><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nPostal code (Mail address)<\/td>\n<\/tr>\n
<MailCountry><\/MailCountry><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nISO country code (Mail address)\u00a02 positions<\/span><\/td>\n<\/tr>\n
<LegalHouseNum><\/LegalHouseNum><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nHouse number (Legal\u00a0 address)<\/td>\n<\/tr>\n
<LegalStreet><\/LegalStreet><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nStreet (Legal address)<\/td>\n<\/tr>\n
<LegalBuilding><\/LegalBuilding><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nBuilding (Legal address)<\/td>\n<\/tr>\n
<LegalLocality><\/LegalLocality><\/span><\/td>\nChar(75)<\/td>\nN<\/td>\nLocality (Legal address)<\/td>\n<\/tr>\n
<LegalPostalCode><\/LegalPostalCode><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nPostal code (Legal address)<\/td>\n<\/tr>\n
<LegalCountry><\/LegalCountry><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nISO country code (Legal address)\u00a02 position<\/span>s<\/td>\n<\/tr>\n
<Comment><\/Comment><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nComment (free text)<\/td>\n<\/tr>\n
<EMail><\/EMail><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nEmail of the company<\/td>\n<\/tr>\n
<URL><\/URL><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nURL of the company<\/td>\n<\/tr>\n
<Mail><\/Mail><\/td>\nBoolean<\/td>\nN<\/td>\nIncluded in Mailing List (Y\/N)<\/td>\n<\/tr>\n
<TaxVATNum><\/TaxVATNum><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nVAT Number<\/td>\n<\/tr>\n
<VATFrequency><\/VATFrequency><\/span><\/td>\nInteger<\/td>\nN<\/td>\nPeriodicity of VAT Return:
\nNone = 0 \/ Weekly = 14 \/ Monthly = 13 \/ Quaterly = 16 \/ Yearly = 17<\/td>\n<\/tr>\n
<Taxable><\/Taxable><\/span><\/td>\nBoolean<\/td>\nN<\/td>\nTaxable (Y\/N)<\/td>\n<\/tr>\n
<IBLCNum><\/IBLCNum><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nIntracom VAT Number<\/td>\n<\/tr>\n
<RCNum><\/RCNum><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nRC Number<\/td>\n<\/tr>\n
<BusinessNum><\/BusinessNum><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nBusiness Authorization Number<\/td>\n<\/tr>\n
<LanguageName><\/LanguageName><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nLanguage<\/td>\n<\/tr>\n
<IncDate><\/IncDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nIncorporation date (YYYYMMDD)<\/td>\n<\/tr>\n
<LastTaxFiling><\/LastTaxFiling><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nLast Tax Filiing Date (YYYYMMDD)<\/td>\n<\/tr>\n
<LastVATReturn><\/LastVATReturn><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nLast VAT Return Date (YYYYMMDD)<\/td>\n<\/tr>\n
<LastBalance><\/LastBalance><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nLast Balance Sheet Date (YYYYMMDD)<\/td>\n<\/tr>\n
<LastBalanceFiled><\/LastBalanceFiled><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nLast Balance Filed Sheet (YYYYMMDD)<\/td>\n<\/tr>\n
<MngPlace><\/MngPlace><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nManagement Place<\/td>\n<\/tr>\n
<Activity><\/Activity><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nSector of Activity<\/td>\n<\/tr>\n
<SMDate><\/SMDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nShareholders Meeting Date (YYYYMMDD)<\/td>\n<\/tr>\n
<SMPlace><\/SMPlace><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nShareholders Meeting place<\/td>\n<\/tr>\n
<IsBank><\/IsBank><\/span><\/td>\nBoolean<\/td>\nN<\/td>\nBank (Y\/N)<\/td>\n<\/tr>\n
<SwiftCode><\/SwiftCode><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nSwift code if Bank<\/td>\n<\/tr>\n
<Telex><\/Telex><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nTelex<\/td>\n<\/tr>\n
<LastAmendment><\/LastAmendment><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nLast date of change of the articles of incorporation (YYYYMMDD)<\/td>\n<\/tr>\n
<CompanyCurrency><\/CompanyCurrency><\/span><\/td>\nChar(10)<\/td>\nN<\/td>\nCapital currency<\/td>\n<\/tr>\n
<ParValue><\/ParValue><\/span><\/td>\nDouble<\/td>\nN<\/td>\nNominal value of shares<\/td>\n<\/tr>\n
<PaidInCapital><\/PaidInCapital><\/span><\/td>\nDouble<\/td>\nN<\/td>\nPaid in Capital amount<\/td>\n<\/tr>\n
<IssuedCapital><\/IssuedCapital><\/span><\/td>\nDouble<\/td>\nN<\/td>\nSubscribed capital amount<\/td>\n<\/tr>\n
<AuthCapital><\/AuthCapital><\/span><\/td>\nDouble<\/td>\nN<\/td>\nAuthorized capital amount<\/td>\n<\/tr>\n
<MemoField><\/MemoField><\/span><\/td>\nMemo<\/td>\nN<\/td>\nFree memo<\/td>\n<\/tr>\n
<Status><\/Status><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nStatus of the company<\/td>\n<\/tr>\n
<Category><\/Category><\/span><\/td>\nChar(50)<\/td>\nN<\/td>\nCompany category<\/td>\n<\/tr>\n
<CorporateTaxDueDate><\/CorporateTaxDueDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nCorporate tax due date (YYYYMMDD)<\/td>\n<\/tr>\n
<Reservation><\/Reservation><\/span><\/td>\nInteger<\/td>\nN<\/td>\nReserved for Sale (Y\/N)<\/td>\n<\/tr>\n
<JuridictionCountry><\/JuridictionCountry><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nJurisdiction country (ISO code 2 positions)<\/td>\n<\/tr>\n
<AnnualAccountDueDate><\/AnnualAccountDueDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nAnnual Account Due date (YYYYMMDD)<\/td>\n<\/tr>\n
<MFSAReturnDueDate><\/MFSAReturnDueDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nMFSA Return Due date (YYYYMMDD)<\/td>\n<\/tr>\n
<MFSAReturnSendDate><\/MFSAReturnSendDate><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nMFSA Return Send date (YYYYMMDD)<\/td>\n<\/tr>\n
<FirstYearEnd><\/FirstYearEnd><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nFirst year-end (YYYYMMDD)<\/td>\n<\/tr>\n
<FirstYearOfAssessment><\/FirstYearOfAssessment><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nFirst year of Assessment (YYYYMMDD)<\/td>\n<\/tr>\n
<TaxOffice><\/TaxOffice><\/span><\/td>\nChar(255)<\/td>\nN<\/td>\nTax office<\/td>\n<\/tr>\n
<GLPeriodStartDate><\/GLPeriodStartDate><\/span><\/td>\nDate\/Time<\/span><\/td>\nN<\/td>\nAccounting period start date (YYYYMMDD)<\/td>\n<\/tr>\n
<GLPeriodEndDate><\/GLPeriodEndDate><\/span><\/td>\nDate\/Time<\/span><\/td>\nN<\/td>\nAccounting period end date (YYYYMMDD)<\/td>\n<\/tr>\n
<LEINumber><\/LEINumber><\/span><\/td>\nChar(30)<\/td>\nN<\/td>\nLEI Number<\/td>\n<\/tr>\n
<RepeatFrequency><\/RepeatFrequency><\/span><\/td>\nShort<\/td>\nN<\/td>\nJANUARY = 1
\nFEBRUARY = 2
\nMARCH = 3
\nAPRIL = 4
\nMAY = 5
\nJUNE = 6
\nJULY = 7
\nAUGUST = 8
\nSEPTEMBER = 9
\nOCTOBER = 10
\nNOVEMBER = 11
\nDECEMBER = 12
\nMONTHLY = 13
\nWEEKLY = 14
\nDAILY = 15
\nQUARTERLY = 16
\nYEARLY = 17
\nSEMIANNUALLY = 18<\/td>\n<\/tr>\n
<RepeatNumber><\/RepeatNumber><\/span><\/td>\nShort<\/td>\nN<\/td>\nFIRST = 1
\nSECOND = 2
\nTHIRD = 3
\nFOURTH = 4
\nLAST = 5<\/td>\n<\/tr>\n
<RepeatTime><\/RepeatTime><\/span><\/td>\nDate\/Time<\/td>\nN<\/td>\nTime (00:00:00)<\/td>\n<\/tr>\n
<RepeatType><\/RepeatType><\/span><\/td>\nShort<\/td>\nN<\/td>\nMONDAY = 1
\nTUESDAY = 2
\nWEDNESDAY = 3
\nTHURSDAY = 4
\nFRIDAY = 5
\nSATURDAY = 6
\nSUNDAY = 7<\/td>\n<\/tr>\n
<\/Record><\/span><\/td>\n<\/td>\nY<\/td>\nEnd of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

PDF version<\/a>
\nExcel version<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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.\u00e0 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[434,15,12],"class_list":["post-1424","post","type-post","status-publish","format-standard","hentry","category-utils","tag-company","tag-interface","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1424","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=1424"}],"version-history":[{"count":49,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1424\/revisions"}],"predecessor-version":[{"id":7166,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1424\/revisions\/7166"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1424"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1424"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1424"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}