Diagrams


Table

MS-QBO Item

Fields

# Name Type
1 Id Text250
2 SyncToken Text250
3 MetaData BLOB
4 MetaData CreateTime DateTime
5 MetaData LastUpdatedTime DateTime
6 Name Text100
7 Sku Text100
8 Description BLOB
9 Active Boolean
10 SubItem Boolean
11 ParentRef BLOB
12 Level Integer
13 FullyQualifiedName Text250
14 Taxable Boolean
15 SalesTaxIncluded Boolean
16 UnitPrice Decimal
17 Type Text250
18 IncomeAccountRef BLOB
19 ExpenseAccountRef BLOB
20 PurchaseDesc Text30
21 PurchaseTaxIncluded Boolean
22 PurchaseCost Decimal
23 AssetAccountRef BLOB
24 TrackQtyOnHand Boolean
25 InvStartDate Date
26 QtyOnHand Decimal
27 SalesTaxCodeRef BLOB
28 PurchaseTaxCodeRef BLOB
29 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