{"id":1714,"date":"2014-06-27T10:25:46","date_gmt":"2014-06-27T09:25:46","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1714&#038;lang=en"},"modified":"2015-12-03T15:05:12","modified_gmt":"2015-12-03T14:05:12","slug":"timereport","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1714","title":{"rendered":"TimeReport"},"content":{"rendered":"<h3><b><span style=\"text-decoration: underline;\">TimeReport:<\/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;\">69<\/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. 69 is for timereport<\/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;EmployeeName&gt;&lt;\/EmployeeName&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Employee name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;JobNumber&gt;&lt;\/JobNumber&gt;<\/span><\/td>\n<td valign=\"top\">Char(75)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Job number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Date&gt;&lt;\/Date&gt;<\/span><\/td>\n<td valign=\"top\">Date\/Time<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Timereport date<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;TimeReportTypeName&gt;&lt;\/TimeReportTypeName&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Timereport type name<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;FromTime&gt;&lt;\/FromTime&gt;<\/span><\/td>\n<td valign=\"top\">Char(8)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Timereport start time<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ToTime&gt;&lt;\/ToTime&gt;<\/span><\/td>\n<td valign=\"top\">Char(8)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Timereport end time<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Hours&gt;&lt;\/Hours&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Hours<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ArticleNumber&gt;&lt;\/ArticleNumber&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Article number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;DescHours&gt;&lt;\/DescHours&gt;<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Description for hours<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;Expenses&gt;&lt;\/Expenses&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Expenses in capital currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ACExpenses&gt;&lt;\/ACExpenses&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Expenses in second capital currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;DescExpenses&gt;&lt;\/DescExpenses&gt;<\/span><\/td>\n<td valign=\"top\">Char(255)<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Description for expenses<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;BillingRate&gt;&lt;\/BillingRate&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Hourly rate in the first capital currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ACBillingRate&gt;&lt;\/ACBillingRate&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Hourly rate in the second capital currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;HourlyCost&gt;&lt;\/HourlyCost&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Hourly cost in the first capital currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;ACHourlyCost&gt;&lt;\/ACHourlyCost&gt;<\/span><\/td>\n<td valign=\"top\">Double<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Hourly cost in the second capital currency<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;InvoiceTNumber&gt;<br \/>\n&lt;\/InvoiceTNumber&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Client invoice number<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;InvoiceTDetailNumber&gt;&lt;\/InvoiceTDetailNumber&gt;<\/span><\/td>\n<td valign=\"top\">Char(50)<\/td>\n<td align=\"center\" valign=\"top\">N<\/td>\n<td valign=\"top\">Client invoice number (detail)<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\"><span style=\"color: #993300;\">&lt;InvoicedType&gt;&lt;\/InvoicedType&gt;<\/span><\/td>\n<td valign=\"top\">Integer<\/td>\n<td align=\"center\" valign=\"top\">Y<\/td>\n<td valign=\"top\">Report status:<br \/>\n0 = Not billed<br \/>\n1 = Billed<br \/>\n2 = Waiting<\/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=4886\">PDF version<\/a>\n","protected":false},"excerpt":{"rendered":"<p>TimeReport: Name Type Mandatory Description &lt;Record Type =&#8221;69&#8220;&gt; Long Y Type of object to import. 69 is for timereport &lt;DBId&gt;&lt;\/DBId&gt; Long Y Database Id in DeMaSy. It is displayed in Utilities &lt;EmployeeName&gt;&lt;\/EmployeeName&gt; Char(75) Y Employee name &lt;JobNumber&gt;&lt;\/JobNumber&gt; Char(75) Y Job number &lt;Date&gt;&lt;\/Date&gt; Date\/Time Y Timereport date &lt;TimeReportTypeName&gt;&lt;\/TimeReportTypeName&gt; Char(50) Y Timereport type name &lt;FromTime&gt;&lt;\/FromTime&gt; Char(8) N [&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,16,12],"class_list":["post-1714","post","type-post","status-publish","format-standard","hentry","category-utils","tag-interface","tag-timereport","tag-xml"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1714","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=1714"}],"version-history":[{"count":13,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1714\/revisions"}],"predecessor-version":[{"id":4887,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1714\/revisions\/4887"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}