{"id":1680,"date":"2014-06-26T16:03:38","date_gmt":"2014-06-26T15:03:38","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1680&#038;lang=en"},"modified":"2015-12-08T16:01:29","modified_gmt":"2015-12-08T15:01:29","slug":"lvat-return-eec","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1680","title":{"rendered":"LVAT Return EEC"},"content":{"rendered":"<h3><b><span style=\"text-decoration: underline;\">LVAT Return EEC:<\/span><\/b><\/h3>\n<table>\n<tbody>\n<tr>\n<th width=\"350px\">Name<\/th>\n<th width=\"20px\">Type<\/th>\n<th width=\"15px\">Mandatory<\/th>\n<th width=\"250px\">Description<\/th>\n<\/tr>\n<tr>\n<td valign=\"top\">&lt;<span style=\"color: #993300;\">Record<\/span> <span style=\"color: #0000ff;\">Type<\/span> =&#8221;<span style=\"color: #ff0000;\">64<\/span>&#8220;&gt;<\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Type of object to import. 64 is for LVAT Return<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;DBId&gt;&lt;\/DBId&gt;<\/span><\/td>\n<td valign=\"top\">Long<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Database Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;DBName&gt;&lt;\/DBName&gt;<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;LoginName&gt;&lt;\/LoginName&gt;<\/span><\/td>\n<td valign=\"top\">Char(30)<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Exported&gt;&lt;\/Exported&gt;<\/span><\/td>\n<td valign=\"top\">Boolean<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;From&gt;&lt;\/From&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;To&gt;&lt;\/To&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Number&gt;&lt;\/Number&gt;<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;CountryCode&gt;&lt;\/CountryCode&gt;<\/span><\/td>\n<td valign=\"top\">Char(10)<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;VATNumber&gt;&lt;\/VATNumber&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Year&gt;&lt;\/Year&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Trim&gt;&lt;\/Trim&gt;<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Type&gt;&lt;\/Type&gt;<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Sign&gt;&lt;\/Sign&gt;<\/span><\/td>\n<td valign=\"top\">Char(1)<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;TriangleOP&gt;&lt;\/TriangleOP&gt;<\/span><\/td>\n<td valign=\"top\">Boolean<\/td>\n<td align=\"center\" valign=\"top\">\/<\/td>\n<td valign=\"top\"><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;\/Record&gt;<\/span><\/td>\n<td valign=\"top\"><\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">End of block<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<a href=\"https:\/\/sdna.lu\/?media_dl=4939\">PDF version<\/a>\n","protected":false},"excerpt":{"rendered":"<p>LVAT Return EEC: Name Type Mandatory Description &lt;Record Type =&#8221;64&#8220;&gt; Long Y Type of object to import. 64 is for LVAT Return &lt;DBId&gt;&lt;\/DBId&gt; Long Y Database Id in DeMaSy. It is displayed in Utilities &lt;DBName&gt;&lt;\/DBName&gt; Char(255) \/ &lt;LoginName&gt;&lt;\/LoginName&gt; Char(30) \/ &lt;Exported&gt;&lt;\/Exported&gt; Boolean \/ &lt;From&gt;&lt;\/From&gt; Date\/Time \/ &lt;To&gt;&lt;\/To&gt; Date\/Time \/ &lt;Number&gt;&lt;\/Number&gt; Integer \/ &lt;CountryCode&gt;&lt;\/CountryCode&gt; Char(10) \/ [&hellip;]<\/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":[15,26,12],"class_list":["post-1680","post","type-post","status-publish","format-standard","hentry","category-utils","tag-interface","tag-lvat-return-eec","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1680","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=1680"}],"version-history":[{"count":9,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1680\/revisions"}],"predecessor-version":[{"id":4941,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1680\/revisions\/4941"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}