Jump to content

ERP Internals/Data Tables/Time

From Wikibooks, open books for an open world

This table contains one record for every separate billable time segment.

Used by: Time Billing

Key: Transaction Number

Fields:

  • Transaction Number (a unique number assigned by the ERP package)
  • Employee Number
  • Job Number
  • Customer Number
  • Date
  • Start Time
  • Stop Time
  • Hours (Stop Time - Start Time / 60)
  • Rate
  • Amount (Hours x Rate)