TABLE DETAIL REFERENCE: TimeTracking
(Online VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
TxnID12 VARCHAR 36TrueFalseFalseFalse%s
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 10TrueFalseFalseFalse%s
TxnNumber4 INTEGER 4TrueFalseFalseFalse%11.0f
TxnDate9 DATE 6TrueTrueTrueFalseCCCC-MM-DD
EntityRefListID12 VARCHAR 36TrueTrueTrueTrue%s Yes
EntityRefFullName12 VARCHAR 1000TrueTrueTrueTrue%s Yes
CustomerRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
CustomerRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
ItemServiceRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ItemServiceRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
DepartmentRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
DepartmentRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
Rate3 DECIMAL 18TrueTrueTrueFalse%10.7f
DurationMinutes4 INTEGER 4TrueTrueTrueTruePTnHnMnS
ClassRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
ClassRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
Notes12 VARCHAR 4000TrueTrueTrueFalse%s
BillableStatus12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
PayrollItemRefListID12 VARCHAR 36TrueTrueTrueFalse%s Yes
PayrollItemRefFullName12 VARCHAR 1000TrueTrueTrueFalse%s Yes
StartTime11 TIMESTAMP 16TrueTrueTrueFalseCCCC-MM-DDThh:mm:ssZ
EndTime11 TIMESTAMP 16TrueTrueTrueFalseCCCC-MM-DDThh:mm:ssZ
BreakHours3 DECIMAL 18TrueTrueTrueFalse%10.7f
BreakMinutes3 DECIMAL 18TrueTrueTrueFalse%10.7f
HoursInEmployeeTimeZone-7 BIT 1TrueTrueTrueFalse
1
0
true
false
Taxable12 VARCHAR 23TrueTrueTrueFalse
Billable
NotBillable
HasBeenBilled
TimeZone12 VARCHAR 1000TrueTrueTrueFalse%s