I am again working on the possibility of implementing Timecards for us and then send the time to our internal Time Tracking system.
To be able to do this I need Activity assigned to each timecard entry. I added Activity as a Task field and then added it to the My Timecard view and did not make the field read only. So I am able to change the Activity code in my timecard.
However I do not see the field in my oData TimesheetLineActualDataset table. Why and can I add it?
Also given I may need to merge Activity from the Task Table with my TimesheetLineActualDataset table, is there a good view of the overall odata schema to show me how the tables are related … how they can be joined?