TABLE DETAIL REFERENCE: TimeTracking

(Online VERSION)

>>

<<

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
TxnID	12	VARCHAR	36	True	False	False	False	%s
TimeCreated	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
TimeModified	11	TIMESTAMP	16	True	False	False	False	CCCC-MM-DDThh:mm:ssZ
EditSequence	12	VARCHAR	10	True	False	False	False	%s
TxnNumber	4	INTEGER	4	True	False	False	False	%11.0f
TxnDate	9	DATE	6	True	True	True	False	CCCC-MM-DD
EntityRefListID	12	VARCHAR	36	True	True	True	True	%s	Yes
EntityRefFullName	12	VARCHAR	1000	True	True	True	True	%s	Yes
CustomerRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
CustomerRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
ItemServiceRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ItemServiceRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
DepartmentRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
DepartmentRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
Rate	3	DECIMAL	18	True	True	True	False	%10.7f
DurationMinutes	4	INTEGER	4	True	True	True	True	PTnHnMnS
ClassRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
ClassRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
Notes	12	VARCHAR	4000	True	True	True	False	%s
BillableStatus	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
PayrollItemRefListID	12	VARCHAR	36	True	True	True	False	%s	Yes
PayrollItemRefFullName	12	VARCHAR	1000	True	True	True	False	%s	Yes
StartTime	11	TIMESTAMP	16	True	True	True	False	CCCC-MM-DDThh:mm:ssZ
EndTime	11	TIMESTAMP	16	True	True	True	False	CCCC-MM-DDThh:mm:ssZ
BreakHours	3	DECIMAL	18	True	True	True	False	%10.7f
BreakMinutes	3	DECIMAL	18	True	True	True	False	%10.7f
HoursInEmployeeTimeZone	-7	BIT	1	True	True	True	False	1 0 true false
Taxable	12	VARCHAR	23	True	True	True	False	Billable NotBillable HasBeenBilled
TimeZone	12	VARCHAR	1000	True	True	True	False	%s