Diagrams


Table

MS-QBO Customer

Fields

# Name Type
1 Id Text250
2 SyncToken Text250
3 MetaData BLOB
4 MetaData CreateTime DateTime
5 MetaData LastUpdatedTime DateTime
6 Title Text15
7 GivenName Text25
8 MiddleName Text25
9 FamilyName Text25
10 Suffix Text10
11 DisplayName Text100
12 FullyQualifiedName Text250
13 CompanyName Text50
14 PrintOnCheckName Text110
15 Active Boolean
16 PrimaryPhone BLOB [Json]
17 AlternatePhone BLOB
18 Mobile BLOB
19 Fax BLOB
20 PrimaryEmailAddr BLOB [Json]
21 WebAddr BLOB
22 DefaultTaxCodeRef BLOB
23 Taxable Boolean
24 BillAddr BLOB [Json]
25 ShipAddr BLOB
26 Notes BLOB
27 Job Boolean
28 BillWithParent Boolean
29 ParentRef BLOB
30 Level Integer
31 SalesTermRef BLOB
32 PaymentMethodRef BLOB
33 Balance Decimal
34 OpenBalanceDate Date
35 BalanceWithJobs Decimal
36 CurrencyRef BLOB
37 PreferredDeliveryMethod Text250
38 ResaleNum Text16
39 All BLOB [Json]

Keys

# Fields
0 Id Clustered: Yes
1 MetaData LastUpdatedTime

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field