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
ID4 INTEGER 4TrueFalseFalseFalseFQID Yes
ProductName12 VARCHAR 255TrueFalseFalseFalse%s
MajorVersion12 VARCHAR 5TrueFalseFalseFalse%s
MinorVersion12 VARCHAR 5TrueFalseFalseFalse%s
Country12 VARCHAR 2TrueFalseFalseFalse%s
IsAutomaticLogin-7 BIT 1TrueFalseFalseFalse
1
0
true
false
QBFileMode12 VARCHAR 10TrueFalseFalseFalse
SingleUser
MultiUser
QODBCMajorVersion12 VARCHAR 5TrueFalseFalseFalseQODBCMajorVersion
QODBCMinorVersion12 VARCHAR 5TrueFalseFalseFalseQODBCMinorVersion
QODBCBuildNumber12 VARCHAR 5TrueFalseFalseFalseQODBCBuildNumber
QODBCRegion12 VARCHAR 5TrueFalseFalseFalseQODBCRegion
QODBCSerialNo12 VARCHAR 12TrueFalseFalseFalseQODBCSerialNo
QODBCEdition12 VARCHAR 50TrueFalseFalseFalseQODBCEdition
QODBCEditionQBES12 VARCHAR 50TrueFalseFalseFalseQODBCEditionQBES
QODBCEditionRunning12 VARCHAR 50TrueFalseFalseFalseQODBCEditionRunning
AccountMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
BillingRateMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
ClassMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerMsgMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
CustomerTypeMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
EntityMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
ItemMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
JobTypeMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
PaymentMethodMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
PayrollItemMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
PriceLevelMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
SalesRepMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
SalesTaxCodeMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
ShipMethodMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
TemplateMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
TermsMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
ToDoMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
VehicleMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f
VendorTypeMetaDataMaxCapacity4 INTEGER 4TrueFalseFalseFalse%11.0f