AnsweredAssumed Answered

Help with Custom Object

Question asked by venkat1 on Jul 10, 2013
Latest reply on Jul 14, 2013 by Sergiu.Gavrila
Hi All,

we want to store the Time Sheet Approved time into a custom object because we want a report based on Approved time - Prtimesheet is overwritten by Posted tIme when the Post job is run at the end of the day .

So we decided to create a custom object with the Timesheet period,PRTIMEPERIODID,PRRESOURCEID,prApproved By,Approved Date,Approved Time etc.... nd later run a script before running the post job to update this custom object so even after running the post job we still have the approved Timesheet details

Question

1)Is this a right approach

2)When creating a custom object i'm thinking of using same data types as in PRTIMESHEET TABLE for field in custom object

How do i find the data types of different field in PRTIMESHEET Table

Thanks

Outcomes