| 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 |
