{"id":1872,"date":"2014-07-11T10:22:14","date_gmt":"2014-07-11T09:22:14","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1872&#038;lang=en"},"modified":"2020-07-30T13:47:27","modified_gmt":"2020-07-30T12:47:27","slug":"capital-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1872","title":{"rendered":"Capital"},"content":{"rendered":"<h3><span style=\"color: #ff0000;\"><b><span style=\"text-decoration: underline;\">Capital:<\/span><\/b><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td valign=\"center\">RecordType;DBId;CompanyName;PersonName;ArticleName;CurrencyName;PaymentCurrencyName;FromDate;<br \/>\nToDate;ValueDate;SettlementDate;Type;ShareType;CapitalTypeName;CapitalShareTypeName;ShareClass;ShareBN;<br \/>\nShareNumber;ShareCompanyName;SharePersonName;ShareStockExchangeName;RegisterNumber;RegisterSigned;<br \/>\nCertificateDelivered;Fees;Payment;CyPayment;PaymentCurrencyRate;NomValue;ACNomValue;NomAmount;<br \/>\nACNomAmount;Total;SharePremium;PaidInPercent;PaidInAmount;ACPaidInAmount;Description;DistributorCompanyName;<br \/>\nDistributorPersonName;OrgDBId;OrgId<\/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. 42 is for capital<\/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. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">3<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CompanyName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">4<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PersonName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">5<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ArticleName<\/span><\/td>\n<td valign=\"top\">Char(100)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">6<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CurrencyName<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">7<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PaymentCurrencyName<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">8<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">FromDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">9<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ToDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">10<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ValueDate<br \/>\n<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">11<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">SettlementDate<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">12<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Type<\/span><\/td>\n<td valign=\"top\">Short<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">13<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ShareType<\/span><\/td>\n<td valign=\"top\">Short<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">14<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CapitalTypeName<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">15<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CapitalShareTypeName<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">16<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ShareClass<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">17<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ShareBN<br \/>\n<\/span><\/td>\n<td valign=\"top\">Short<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">18<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ShareNumber<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">19<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ShareCompanyName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">20<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CurrencyName<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">21<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">SharePersonName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">22<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ShareStockExchangeName<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">23<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RegisterNumber<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">24<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">RegisterSigned<\/span><\/td>\n<td valign=\"top\">Boolean<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">25<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CertificateDelivered<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">26<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Fees<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">27<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PaymentCurrencyName<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">28<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Payment<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">29<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">CyPayment<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">30<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PaymentCurrencyRate<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">31<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">NomValue<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">32<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ACNomValue<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">33<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">NomAmount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">34<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ACNomAmount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">35<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Total<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">36<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">SharePremium<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">37<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PaidInPercent<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">38<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">PaidInAmount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">39<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">ACPaidInAmount<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">40<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">Description<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">41<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">DistributorCompanyName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\">42<\/td>\n<td valign=\"top\"><span style=\"color: #993300;\">DistributorPersonName<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Capital: RecordType;DBId;CompanyName;PersonName;ArticleName;CurrencyName;PaymentCurrencyName;FromDate; ToDate;ValueDate;SettlementDate;Type;ShareType;CapitalTypeName;CapitalShareTypeName;ShareClass;ShareBN; ShareNumber;ShareCompanyName;SharePersonName;ShareStockExchangeName;RegisterNumber;RegisterSigned; CertificateDelivered;Fees;Payment;CyPayment;PaymentCurrencyRate;NomValue;ACNomValue;NomAmount; ACNomAmount;Total;SharePremium;PaidInPercent;PaidInAmount;ACPaidInAmount;Description;DistributorCompanyName; DistributorPersonName;OrgDBId;OrgId Nr Name Type Description 1 RecordType Long Type of object to import. 42 is for capital 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 CompanyName Char(75) 4 PersonName Char(75) 5 ArticleName Char(100) 6 CurrencyName Char(30) 7 PaymentCurrencyName Char(30) 8 FromDate Date\/Time 9 ToDate [&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-1872","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1872","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=1872"}],"version-history":[{"count":5,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1872\/revisions"}],"predecessor-version":[{"id":9301,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1872\/revisions\/9301"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1872"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1872"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1872"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}