Details:HostMetaData

TABLE DETAIL REFERENCE: HostMetaData

(Australia ,New Zealand,Singapore Southeast Asia VERSION)

FIELD NAME	TYPE	TYPENAME	LENGTH	QUERYABLE	UPDATEABLE	INSERTABLE	REQUIRED ON INSERT	VALIDATE	RELATES TO
ID	4	INTEGER	4	True	False	False	False	FQID	Yes
ProductName	12	VARCHAR	255	True	False	False	False	%s
MajorVersion	12	VARCHAR	5	True	False	False	False	%s
MinorVersion	12	VARCHAR	5	True	False	False	False	%s
Country	12	VARCHAR	2	True	False	False	False	%s
IsAutomaticLogin	-7	BIT	1	True	False	False	False	1 0 true false
QBFileMode	12	VARCHAR	10	True	False	False	False	SingleUser MultiUser
QODBCMajorVersion	12	VARCHAR	5	True	False	False	False	QODBCMajorVersion
QODBCMinorVersion	12	VARCHAR	5	True	False	False	False	QODBCMinorVersion
QODBCBuildNumber	12	VARCHAR	5	True	False	False	False	QODBCBuildNumber
QODBCRegion	12	VARCHAR	5	True	False	False	False	QODBCRegion
QODBCSerialNo	12	VARCHAR	12	True	False	False	False	QODBCSerialNo
QODBCEdition	12	VARCHAR	50	True	False	False	False	QODBCEdition
QODBCEditionQBES	12	VARCHAR	50	True	False	False	False	QODBCEditionQBES
QODBCEditionRunning	12	VARCHAR	50	True	False	False	False	QODBCEditionRunning
AccountMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
BillingRateMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
ClassMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
CustomerMsgMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
CustomerTypeMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
EntityMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
ItemMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
JobTypeMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
PaymentMethodMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
PayrollItemMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
PriceLevelMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
SalesRepMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
SalesTaxCodeMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
ShipMethodMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
TemplateMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
TermsMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
ToDoMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
VehicleMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f
VendorTypeMetaDataMaxCapacity	4	INTEGER	4	True	False	False	False	%11.0f

QODBC.com Tools for QuickBooks