Details:InventorySite

TABLE DETAIL REFERENCE: InventorySite

(USA 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
EditSequence	12	VARCHAR	16	True	False	False	False	%s
Name	12	VARCHAR	31	True	True	True	True	%s
IsActive	-7	BIT	1	True	True	True	False	1 0 true false
ParentSiteRefListID	12	VARCHAR	36	True	True	True	False	%s
ParentSiteRefFullName	12	VARCHAR	209	True	True	True	False	%s
IsDefaultSite	-7	BIT	1	True	True	True	False	1 0 true false
SiteDesc	12	VARCHAR	100	True	True	True	True	%s
Contact	12	VARCHAR	41	True	True	True	True	%s
Phone	12	VARCHAR	21	True	True	True	True	%s
Fax	12	VARCHAR	21	True	True	True	True	%s
Email	12	VARCHAR	1024	True	True	True	True	%s
SiteAddressAddr1	12	VARCHAR	41	True	True	True	True	%s
SiteAddressAddr2	12	VARCHAR	41	True	True	True	True	%s
SiteAddressAddr3	12	VARCHAR	41	True	True	True	True	%s
SiteAddressAddr4	12	VARCHAR	41	True	True	True	True	%s
SiteAddressAddr5	12	VARCHAR	41	True	True	True	True	%s
SiteAddressCity	12	VARCHAR	31	True	True	True	True	%s
SiteAddressState	12	VARCHAR	21	True	True	True	True	%s
SiteAddressPostalCode	12	VARCHAR	13	True	True	True	True	%s
SiteAddressCountry	12	VARCHAR	31	True	True	True	True	%s
SiteAddressBlockAddr1	12	VARCHAR	41	True	True	True	True	%s
SiteAddressBlockAddr2	12	VARCHAR	41	True	True	True	True	%s
SiteAddressBlockAddr3	12	VARCHAR	41	True	True	True	True	%s
SiteAddressBlockAddr4	12	VARCHAR	41	True	True	True	True	%s
SiteAddressBlockAddr5	12	VARCHAR	41	True	True	True	True	%s

QODBC.com Tools for QuickBooks