ERP Internals/Data Tables/Time
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)