Host Table
| Column | Data type | Data type name | Length | Can be queried? | Can be updated? | Can be inserted? | Mandatory when inserting? | Format | Refers To | Version introduced in | Edition available in |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | 4 | INTEGER | 4 | True | False | False | False | FQID | 1.0 | US, CA, UK | |
| ProductName | 12 | VARCHAR | 255 | True | False | False | False | %s | 1.0 | US, CA, UK | |
| MajorVersion | 12 | VARCHAR | 5 | True | False | False | False | %s | 1.0 | US, CA, UK | |
| MinorVersion | 12 | VARCHAR | 5 | True | False | False | False | %s | 1.0 | US, CA, UK | |
| Country | 12 | VARCHAR | 2 | True | False | False | False | %s | 3.0 | US, CA, UK | |
| IsAutomaticLogin | -7 | BIT | 2 | True | False | False | False | 1 0 true false |
3.0 | US, CA, UK | |
| QBFileMode | 12 | VARCHAR | 10 | True | False | False | False | SingleUser MultiUser |
3.0 | US, CA, UK | |
| AccountMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| BillingRateMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| ClassMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| CustomerMsgMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| CustomerTypeMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| EntityMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| ItemMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| JobTypeMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| PaymentMethodMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| PayrollItemMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| PriceLevelMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| SalesRepMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| SalesTaxCodeMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| ShipMethodMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| TemplateMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| TermsMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| ToDoMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| VehicleMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK | ||||||
| VendorTypeMetaData_MaxCapacity | 4 | INTEGER | 9 | 6.0 | US, CA, UK |