Details:Employee

TABLE DETAIL REFERENCE: Employee

(POS VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE
ListID	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
City	12	VARCHAR	31	True	True	True	False	%s
CommissionPercent	3	DECIMAL	15	True	True	True	False	%7.5f
Country	12	VARCHAR	31	True	True	True	False	%s
Email	12	VARCHAR	99	True	True	True	False	%s
FirstName	12	VARCHAR	30	True	True	True	False	%s
LastName	12	VARCHAR	30	True	True	True	False	%s
LoginName	12	VARCHAR	20	True	True	True	True	%s
Notes	12	VARCHAR	245	True	True	True	False	%s
Phone	12	VARCHAR	40	True	True	True	False	%s
Phone2	12	VARCHAR	40	True	True	True	False	%s
Phone3	12	VARCHAR	40	True	True	True	False	%s
Phone4	12	VARCHAR	40	True	True	True	False	%s
PostalCode	12	VARCHAR	13	True	True	True	False	%s
State	12	VARCHAR	21	True	True	True	False	%s
Street	12	VARCHAR	41	True	True	True	False	%s
CustomFieldOther	12	VARCHAR	30	True	False	False	False	%s

QODBC.com Tools for QuickBooks