Timesheet

Summary

Timesheets (specifically unposted time) is a form of Committed costs. This fact is generally used to report unposted time, but can also be used to compare the original timesheet to the final actual posting including adjustments.

Dynamics 365 Menu Item(s)

• Project management and accounting > Timesheets > All timesheets

Legacy data model’s data entities

• PMBI_deFACTTimesheet
• PMBI_deFACTTimesheetv2

New data model’s data entities

• PMBI_TSTimeSheetTransEntity
• PMBI_TSTimesheetLineWeekEntity
• PMBI_TSTimesheetTableEntity
• PMBI_TSTimesheetLineEntity
• PMBI_ProjTableEntity
• FNBI_HcmWorkerEntity
• FNBI_LedgerEntity
• PMBI_EnumsTableEntity
• PMBI_ProjEmplTransEntity
• PMBI_PMIPUtilizationTypeTransEntity
• FNBI_SqlDictionaryEntity
• PMBI_ProjInvoiceTable

Synapse link approach tables

• TSTimeSheetTrans
• TSTimesheetLineWeek
• TSTimesheetTable
• TSTimesheetLine
• ProjTable
• HcmWorker
• Ledger
• PMBIENUMSTABLE
• ProjEmplTrans
• PMIPUtilizationTypeTrans
• SqlDictionary
• ProjInvoiceTable
  

Field level functional description

• ApprovalStatus: The current approval status of the timesheet (e.g., submitted, approved, rejected).
• ExternalComment: Comments or notes intended for external stakeholders or reviewers of the timesheet.
• InternalComment: Comments or notes intended for internal use within the organization regarding the timesheet.
• IsIntercompany: Indicates whether the timesheet entry involves intercompany transactions (typically a yes/no or true/false value).
• LinePropertyId: The identifier for the line property associated with the timesheet entry, which may indicate billing or cost characteristics.
• PeriodFrom: The start date of the timesheet period.
• PeriodTo: The end date of the timesheet period.
• TimeSheet_DataAreaID: The identifier for the legal entity or company associated with the timesheet entry.
• TimeSheetCostPrice: The cost price associated with the timesheet entry.
• TimeSheetCostPrice_Currency: The currency code for the cost price in the timesheet entry.
• TimeSheetNBR: The unique number or identifier for the timesheet.
• TimeSheetPostingStatus: The posting status of the timesheet (e.g., posted, unposted).
• TimeSheetProjCompanySalesPrice: The sales price for the project company associated with the timesheet entry.
• TimeSheetProjCompanySalesPrice_Currency: The currency code for the project company sales price.
• TimeSheetTransferPrice: The transfer price associated with the timesheet entry.
• TimeSheetTransferPrice_Currency: The currency code for the transfer price in the timesheet entry.
• TSTimesheetTransTransID: The unique identifier for the timesheet transaction.
• TransferPrice: The transfer price value for the timesheet entry.