TimeTracking

Create, update, delete, and query Reckon Time Tracking events.

Table Specific Information

This table has a Custom Fields column. See the Custom Fields page for more information.

Select

By default, SupportEnhancedSQL is set to true, and the following will be honored if present. Other filters will be executed client side. If SupportEnhancedSQL is set to false, only the following filters will be honored.

Reckon allows only a small subset of columns to be used in the WHERE clause of a SELECT query. These columns can only be used with the equals or = comparison. The available columns for TimeTracking entries are Id, TimeModified, Date, EmployeeName, and EmployeeId. TimeModified and Date may be used with the >, >=, <, <=, or = conditions and may be used twice to specify a range. ReferenceNumber may be used with the = or LIKE conditions to establish a starts-with, ends-with, or contains syntax. For example:

SELECT * FROM TimeTracking WHERE TimeModified > '1/1/2011' AND TimeModified < '2/1/2011' AND ReferenceNumber LIKE '%12345%'

Insert

To insert a TimeTracking entry, specify the Employee and Duration columns.

Columns


Name	Type	ReadOnly	References	Description
ID [KEY]	String	True		An Id is an alphanumerical identifier assigned by the server whenever an object is added to Reckon. It is guaranteed to be unique across all objects of the same type.
BillableStatus	String	False		The billing status of this line item. If the billing status is empty (that is, if no billing status appears in Reckon), then no BillableStatus value will be returned. The allowed values are Empty, Billable, NotBillable, HasBeenBilled.
Date	Date	False		The date of the transaction. The standard formatting for dates is YYYY-MM-DD; i.e., September 2, 2002 is formatted as 2002-09-02. When getting the value of a date property, the date will always be in this format. This is required to have a value when inserting.
CustomerName	String	False	Customers.FullName	The Customer property indicates the customer who has purchased goods or services from the company. This is required to have a value when inserting if CustomerID is empty and BillableStatus is not NotBillable.
CustomerId	String	False	Customers.ID	The Customer property indicates the customer who has purchased goods or services from the company. This is required to have a value when inserting if CustomerName is empty and BillableStatus is not NotBillable.
Duration	String	False		The duration of time being tracked. Time is represented in hours followed by minutes, with the character ':' (colon) separating them. For instance, two hours and thirty minutes is represented as '2:30'.
EmployeeName	String	False	Employees.Name	A reference to the employee or subcontractor whose time is being tracked. The person is typically an employee but may be a vendor or defined in an other-name record as well. This is required to have a value when inserting if EmployeeId is empty.
EmployeeId	String	False	Employees.ID	A reference to the employee or subcontractor whose time is being tracked. The person is typically an employee but may be a vendor or defined in an other-name record as well. This is required to have a value when inserting if EmployeeName is empty.
Notes	String	False		Notes about this transaction.
Class	String	False	Class.FullName	A reference to the class of the transaction.
ClassId	String	False	Class.ID	A reference to the class of the transaction.
PayrollWageItemName	String	False	PayrollWageItems.Name	A payment scheme, such as Regular Pay, Overtime Pay, etc. This property may only be specified if (1) the employee specified refers to an employee, and not a vendor or subcontractor, and (2) the 'Use time data to create paychecks' option is selected for this employee (from within the Reckon UI.)
PayrollWageItemId	String	False	PayrollWageItems.ID	A payment scheme, such as Regular Pay, Overtime Pay, etc. This property may only be specified if (1) the employee specified refers to an employee, and not a vendor or subcontractor, and (2) the 'Use time data to create paychecks' option is selected for this employee from within the Reckon UI.
ServiceItemName	String	False	Items.Name	The type of work being performed. If a Customer is not specified, ServiceItem is not needed. If BillableStatus is set to Billable, then both ServiceItem and Customer are required. This is required to have a value when inserting if ServiceItemID is empty.
ServiceItemId	String	False	Items.ID	The type of work being performed. If a Customer is not specified, ServiceItem is not needed. If BillableStatus is set to Billable, then both ServiceItem and Customer are required. This is required to have a value when inserting if ServiceItemName is empty.
CustomFields	String	False		Custom fields returned from Reckon and formatted into XML.
EditSequence	String	True		An identifier used for versioning for this copy of the object.
TimeModified	Datetime	True		When the time-tracking event was last modified.
TimeCreated	Datetime	True		When the time-tracking event was created.

Pseudo-Columns

Pseudo Column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.