Diagrams


Table

MS-QBO Invoice

Fields

# Name Type
1 Id Text250
2 SyncToken Text250
3 MetaData BLOB
4 MetaData CreateTime DateTime
5 MetaData LastUpdatedTime DateTime
6 CustomField BLOB
7 DocNumber Text21
8 TxnDate Date
9 DepartmentRef BLOB
10 CurrencyRef BLOB
11 ExchangeRate Decimal
12 PrivateNote BLOB
13 LinkedTxn BLOB
14 Line BLOB
15 TxnTaxDetail BLOB
16 CustomerRef BLOB
17 CustomerMemo BLOB
18 BillAddr BLOB
19 ShipAddr BLOB
20 ClassRef BLOB
21 SalesTermRef BLOB
22 DueDate Date
23 GlobalTaxCalculation BLOB
24 ShipMethodRef BLOB
25 ShipDate Date
26 TrackingNum Text250
27 TotalAmt Decimal
28 HomeTotalAmt Decimal
29 ApplyTaxAfterDiscount Boolean
30 PrintStatus Text13
31 EmailStatus Text10
32 BillEmail BLOB
33 DeliveryInfo Text250
34 Balance Decimal
35 HomeBalance Decimal
36 TxnSource Text250
37 Deposit Text30

Keys

# Fields
0 Id Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field