Diagrams


Table

MS-QBO Customer

Fields

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

Keys

# Fields
0 Id (Id) Clustered: Yes
1 MetaData LastUpdatedTime (MetaData LastUpdatedTime)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field