{"id":1957,"date":"2014-07-11T10:49:51","date_gmt":"2014-07-11T09:49:51","guid":{"rendered":"http:\/\/help.sdna.lu\/?p=1957&lang=en"},"modified":"2020-07-30T14:00:38","modified_gmt":"2020-07-30T13:00:38","slug":"timereport-2","status":"publish","type":"post","link":"https:\/\/sdna.lu\/?p=1957","title":{"rendered":"TimeReport"},"content":{"rendered":"

TimeReport:<\/span><\/b><\/span><\/h3>\n\n\n\n
RecordType;DBId;EmployeeName;JobNumber;Date;TimeReportTypeName;FromTime;ToTime;Hours;ArticleNumber;
\nDescHours;Expenses;ACExpenses;DescExpenses;BillingRate;ACBillingRate;HourlyCost;ACHourlyCost;InvoiceTNumber;
\nInvoiceTDetailNumber;InvoicedType<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\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
Nr<\/th>\nName<\/th>\nType<\/th>\nDescription<\/th>\n<\/tr>\n
1<\/td>\nRecordType<\/span><\/td>\nLong<\/td>\nType of object to import. 69 is for timereport<\/td>\n<\/tr>\n
2<\/td>\nDBId<\/span><\/td>\nLong<\/td>\nDatabase Id in DeMaSy. It is displayed in Utilities<\/td>\n<\/tr>\n
3<\/td>\nEmployeeName<\/span><\/td>\nChar(75)<\/td>\nEmployee name<\/td>\n<\/tr>\n
4<\/td>\nJobNumber<\/span><\/td>\nChar(75)<\/td>\nJob number<\/td>\n<\/tr>\n
5<\/td>\nDate<\/span><\/td>\nDate\/Time<\/td>\nTimereport date<\/td>\n<\/tr>\n
6<\/td>\nTimeReportTypeName<\/span><\/td>\nChar(50)<\/td>\nTimereport type name<\/td>\n<\/tr>\n
7<\/td>\nFromTime<\/span><\/td>\nChar(8)<\/td>\nTimereport start time<\/td>\n<\/tr>\n
8<\/td>\nToTime<\/span><\/td>\nChar(8)<\/td>\nTimereport end time<\/td>\n<\/tr>\n
9<\/td>\nHours<\/span><\/td>\nDouble<\/td>\nHours<\/td>\n<\/tr>\n
10<\/td>\nArticleNumber<\/span><\/td>\nDouble<\/td>\nArticle number<\/td>\n<\/tr>\n
11<\/td>\nDescHours<\/span><\/td>\nChar(255)<\/td>\nDescription for hours<\/td>\n<\/tr>\n
12<\/td>\nExpenses<\/span><\/td>\nDouble<\/td>\nExpenses in capital currency<\/td>\n<\/tr>\n
13<\/td>\nACExpenses<\/span><\/td>\nDouble<\/td>\nExpenses in second capital currency<\/td>\n<\/tr>\n
14<\/td>\nDescExpenses<\/span><\/td>\nChar(255)<\/td>\nDescription for expenses<\/td>\n<\/tr>\n
15<\/td>\nBillingRate<\/span><\/td>\nDouble<\/td>\nHourly rate in the first capital currency<\/td>\n<\/tr>\n
16<\/td>\nACBillingRate<\/span><\/td>\nDouble<\/td>\nHourly rate in the second capital currency<\/td>\n<\/tr>\n
17<\/td>\nHourlyCost<\/span><\/td>\nDouble<\/td>\nHourly cost in the first capital currency<\/td>\n<\/tr>\n
18<\/td>\nACHourlyCost<\/span><\/td>\nDouble<\/td>\nHourly cost in the second capital currency<\/td>\n<\/tr>\n
19<\/td>\nInvoiceTNumber<\/span><\/td>\nChar(50)<\/td>\nClient invoice number<\/td>\n<\/tr>\n
20<\/td>\nInvoiceTDetailNumber<\/span><\/td>\nChar(50)<\/td>\nClient invoice number (detail)<\/td>\n<\/tr>\n
21<\/td>\nInvoicedType<\/span><\/td>\nInteger<\/td>\nReport status:
\n0 = Not billed
\n1 = Billed
\n2 = Waiting<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

TimeReport: RecordType;DBId;EmployeeName;JobNumber;Date;TimeReportTypeName;FromTime;ToTime;Hours;ArticleNumber; DescHours;Expenses;ACExpenses;DescExpenses;BillingRate;ACBillingRate;HourlyCost;ACHourlyCost;InvoiceTNumber; InvoiceTDetailNumber;InvoicedType Nr Name Type Description 1 RecordType Long Type of object to import. 69 is for timereport 2 DBId Long Database Id in DeMaSy. It is displayed in Utilities 3 EmployeeName Char(75) Employee name 4 JobNumber Char(75) Job number 5 Date Date\/Time Timereport date 6 TimeReportTypeName Char(50) Timereport type name 7 FromTime […]<\/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-1957","post","type-post","status-publish","format-standard","hentry","category-interface-utils"],"_links":{"self":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1957","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=1957"}],"version-history":[{"count":4,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1957\/revisions"}],"predecessor-version":[{"id":9343,"href":"https:\/\/sdna.lu\/index.php?rest_route=\/wp\/v2\/posts\/1957\/revisions\/9343"}],"wp:attachment":[{"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1957"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1957"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sdna.lu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1957"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}