Windsor brings all your Quickbooks data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Quickbooks Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| accounts__AccountSubType | TEXT | accounts.AccountSubType | accounts.AccountSubType | accounts |
| accounts__AccountType | TEXT | accounts.AccountType | accounts.AccountType | accounts |
| accounts__AcctNum | TEXT | accounts.AcctNum | accounts.AcctNum | accounts |
| accounts__Active | BOOLEAN | accounts.Active | accounts.Active | accounts |
| accounts__Classification | TEXT | accounts.Classification | accounts.Classification | accounts |
| accounts__CurrencyRef | OBJECT | accounts.CurrencyRef | accounts.CurrencyRef | accounts |
| accounts__CurrentBalance | NUMERIC | accounts.CurrentBalance | accounts.CurrentBalance | accounts |
| accounts__CurrentBalanceWithSubAccounts | NUMERIC | accounts.CurrentBalanceWithSubAccounts | accounts.CurrentBalanceWithSubAccounts | accounts |
| accounts__FullyQualifiedName | TEXT | accounts.FullyQualifiedName | accounts.FullyQualifiedName | accounts |
| accounts__Id | TEXT | accounts.Id | accounts.Id | accounts |
| accounts__MetaData | OBJECT | accounts.MetaData | accounts.MetaData | accounts |
| accounts__Name | TEXT | accounts.Name | accounts.Name | accounts |
| accounts__ParentRef | OBJECT | accounts.ParentRef | accounts.ParentRef | accounts |
| accounts__SubAccount | BOOLEAN | accounts.SubAccount | accounts.SubAccount | accounts |
| accounts__SyncToken | TEXT | accounts.SyncToken | accounts.SyncToken | accounts |
| accounts__domain | TEXT | accounts.domain | accounts.domain | accounts |
| accounts__sparse | BOOLEAN | accounts.sparse | accounts.sparse | accounts |
| bill_payments__APAccountRef | OBJECT | bill_payments.APAccountRef | bill_payments.APAccountRef | bill_payments |
| bill_payments__CheckPayment | OBJECT | bill_payments.CheckPayment | bill_payments.CheckPayment | bill_payments |
| bill_payments__CreditCardPayment | OBJECT | bill_payments.CreditCardPayment | bill_payments.CreditCardPayment | bill_payments |
| bill_payments__CurrencyRef | OBJECT | bill_payments.CurrencyRef | bill_payments.CurrencyRef | bill_payments |
| bill_payments__DepartmentRef | OBJECT | bill_payments.DepartmentRef | bill_payments.DepartmentRef | bill_payments |
| bill_payments__DocNumber | TEXT | bill_payments.DocNumber | bill_payments.DocNumber | bill_payments |
| bill_payments__ExchangeRate | NUMERIC | bill_payments.ExchangeRate | bill_payments.ExchangeRate | bill_payments |
| bill_payments__Id | TEXT | bill_payments.Id | bill_payments.Id | bill_payments |
| bill_payments__Line | OBJECT | bill_payments.Line | bill_payments.Line | bill_payments |
| bill_payments__MetaData | OBJECT | bill_payments.MetaData | bill_payments.MetaData | bill_payments |
| bill_payments__PayType | TEXT | bill_payments.PayType | bill_payments.PayType | bill_payments |
| bill_payments__SyncToken | TEXT | bill_payments.SyncToken | bill_payments.SyncToken | bill_payments |
| bill_payments__TotalAmt | NUMERIC | bill_payments.TotalAmt | bill_payments.TotalAmt | bill_payments |
| bill_payments__TxnDate | TEXT | bill_payments.TxnDate | bill_payments.TxnDate | bill_payments |
| bill_payments__VendorRef | OBJECT | bill_payments.VendorRef | bill_payments.VendorRef | bill_payments |
| bill_payments__domain | TEXT | bill_payments.domain | bill_payments.domain | bill_payments |
| bill_payments__sparse | BOOLEAN | bill_payments.sparse | bill_payments.sparse | bill_payments |
| bills__APAccountRef | OBJECT | bills.APAccountRef | bills.APAccountRef | bills |
| bills__Balance | NUMERIC | bills.Balance | bills.Balance | bills |
| bills__CurrencyRef | OBJECT | bills.CurrencyRef | bills.CurrencyRef | bills |
| bills__DepartmentRef | OBJECT | bills.DepartmentRef | bills.DepartmentRef | bills |
| bills__DocNumber | TEXT | bills.DocNumber | bills.DocNumber | bills |
| bills__DueDate | TEXT | bills.DueDate | bills.DueDate | bills |
| bills__ExchangeRate | NUMERIC | bills.ExchangeRate | bills.ExchangeRate | bills |
| bills__Id | TEXT | bills.Id | bills.Id | bills |
| bills__Line | OBJECT | bills.Line | bills.Line | bills |
| bills__LinkedTxn | OBJECT | bills.LinkedTxn | bills.LinkedTxn | bills |
| bills__MetaData | OBJECT | bills.MetaData | bills.MetaData | bills |
| bills__PrivateNote | TEXT | bills.PrivateNote | bills.PrivateNote | bills |
| bills__SalesTermRef | OBJECT | bills.SalesTermRef | bills.SalesTermRef | bills |
| bills__SyncToken | TEXT | bills.SyncToken | bills.SyncToken | bills |
| bills__TotalAmt | NUMERIC | bills.TotalAmt | bills.TotalAmt | bills |
| bills__TxnDate | TEXT | bills.TxnDate | bills.TxnDate | bills |
| bills__VendorRef | OBJECT | bills.VendorRef | bills.VendorRef | bills |
| bills__domain | TEXT | bills.domain | bills.domain | bills |
| bills__sparse | BOOLEAN | bills.sparse | bills.sparse | bills |
| budgets__Active | BOOLEAN | budgets.Active | budgets.Active | budgets |
| budgets__BudgetDetail | OBJECT | budgets.BudgetDetail | budgets.BudgetDetail | budgets |
| budgets__BudgetEntryType | TEXT | budgets.BudgetEntryType | budgets.BudgetEntryType | budgets |
| budgets__BudgetType | TEXT | budgets.BudgetType | budgets.BudgetType | budgets |
| budgets__EndDate | TEXT | budgets.EndDate | budgets.EndDate | budgets |
| budgets__Id | TEXT | budgets.Id | budgets.Id | budgets |
| budgets__MetaData | OBJECT | budgets.MetaData | budgets.MetaData | budgets |
| budgets__Name | TEXT | budgets.Name | budgets.Name | budgets |
| budgets__StartDate | TEXT | budgets.StartDate | budgets.StartDate | budgets |
| budgets__SyncToken | TEXT | budgets.SyncToken | budgets.SyncToken | budgets |
| budgets__domain | TEXT | budgets.domain | budgets.domain | budgets |
| classes__Active | BOOLEAN | classes.Active | classes.Active | classes |
| classes__FullyQualifiedName | TEXT | classes.FullyQualifiedName | classes.FullyQualifiedName | classes |
| classes__Id | TEXT | classes.Id | classes.Id | classes |
| classes__MetaData | OBJECT | classes.MetaData | classes.MetaData | classes |
| classes__Name | TEXT | classes.Name | classes.Name | classes |
| classes__ParentRef | OBJECT | classes.ParentRef | classes.ParentRef | classes |
| classes__SubClass | BOOLEAN | classes.SubClass | classes.SubClass | classes |
| classes__SyncToken | TEXT | classes.SyncToken | classes.SyncToken | classes |
| classes__domain | TEXT | classes.domain | classes.domain | classes |
| credit_memos__ApplyTaxAfterDiscount | BOOLEAN | credit_memos.ApplyTaxAfterDiscount | credit_memos.ApplyTaxAfterDiscount | credit_memos |
| credit_memos__Balance | NUMERIC | credit_memos.Balance | credit_memos.Balance | credit_memos |
| credit_memos__BillAddr | OBJECT | credit_memos.BillAddr | credit_memos.BillAddr | credit_memos |
| credit_memos__BillEmail | OBJECT | credit_memos.BillEmail | credit_memos.BillEmail | credit_memos |
| credit_memos__ClassRef | OBJECT | credit_memos.ClassRef | credit_memos.ClassRef | credit_memos |
| credit_memos__CurrencyRef | OBJECT | credit_memos.CurrencyRef | credit_memos.CurrencyRef | credit_memos |
| credit_memos__CustomField | OBJECT | credit_memos.CustomField | credit_memos.CustomField | credit_memos |
| credit_memos__CustomerMemo | OBJECT | credit_memos.CustomerMemo | credit_memos.CustomerMemo | credit_memos |
| credit_memos__CustomerRef | OBJECT | credit_memos.CustomerRef | credit_memos.CustomerRef | credit_memos |
| credit_memos__DocNumber | TEXT | credit_memos.DocNumber | credit_memos.DocNumber | credit_memos |
| credit_memos__EmailStatus | TEXT | credit_memos.EmailStatus | credit_memos.EmailStatus | credit_memos |
| credit_memos__ExchangeRate | NUMERIC | credit_memos.ExchangeRate | credit_memos.ExchangeRate | credit_memos |
| credit_memos__HomeTotalAmt | NUMERIC | credit_memos.HomeTotalAmt | credit_memos.HomeTotalAmt | credit_memos |
| credit_memos__Id | TEXT | credit_memos.Id | credit_memos.Id | credit_memos |
| credit_memos__Line | OBJECT | credit_memos.Line | credit_memos.Line | credit_memos |
| credit_memos__MetaData | OBJECT | credit_memos.MetaData | credit_memos.MetaData | credit_memos |
| credit_memos__PrintStatus | TEXT | credit_memos.PrintStatus | credit_memos.PrintStatus | credit_memos |
| credit_memos__RemainingCredit | NUMERIC | credit_memos.RemainingCredit | credit_memos.RemainingCredit | credit_memos |
| credit_memos__SalesTermRef | OBJECT | credit_memos.SalesTermRef | credit_memos.SalesTermRef | credit_memos |
| credit_memos__ShipAddr | OBJECT | credit_memos.ShipAddr | credit_memos.ShipAddr | credit_memos |
| credit_memos__SyncToken | TEXT | credit_memos.SyncToken | credit_memos.SyncToken | credit_memos |
| credit_memos__TotalAmt | NUMERIC | credit_memos.TotalAmt | credit_memos.TotalAmt | credit_memos |
| credit_memos__TxnDate | TEXT | credit_memos.TxnDate | credit_memos.TxnDate | credit_memos |
| credit_memos__TxnTaxDetail | OBJECT | credit_memos.TxnTaxDetail | credit_memos.TxnTaxDetail | credit_memos |
| credit_memos__domain | TEXT | credit_memos.domain | credit_memos.domain | credit_memos |
| credit_memos__sparse | BOOLEAN | credit_memos.sparse | credit_memos.sparse | credit_memos |
| customers__Active | BOOLEAN | customers.Active | customers.Active | customers |
| customers__Balance | NUMERIC | customers.Balance | customers.Balance | customers |
| customers__BalanceWithJobs | NUMERIC | customers.BalanceWithJobs | customers.BalanceWithJobs | customers |
| customers__BillAddr | OBJECT | customers.BillAddr | customers.BillAddr | customers |
| customers__BillWithParent | BOOLEAN | customers.BillWithParent | customers.BillWithParent | customers |
| customers__CompanyName | TEXT | customers.CompanyName | customers.CompanyName | customers |
| customers__CurrencyRef | OBJECT | customers.CurrencyRef | customers.CurrencyRef | customers |
| customers__DefaultTaxCodeRef | OBJECT | customers.DefaultTaxCodeRef | customers.DefaultTaxCodeRef | customers |
| customers__DisplayName | TEXT | customers.DisplayName | customers.DisplayName | customers |
| customers__FamilyName | TEXT | customers.FamilyName | customers.FamilyName | customers |
| customers__Fax | OBJECT | customers.Fax | customers.Fax | customers |
| customers__FullyQualifiedName | TEXT | customers.FullyQualifiedName | customers.FullyQualifiedName | customers |
| customers__GivenName | TEXT | customers.GivenName | customers.GivenName | customers |
| customers__Id | TEXT | customers.Id | customers.Id | customers |
| customers__Job | BOOLEAN | customers.Job | customers.Job | customers |
| customers__Level | NUMERIC | customers.Level | customers.Level | customers |
| customers__MetaData | OBJECT | customers.MetaData | customers.MetaData | customers |
| customers__MiddleName | TEXT | customers.MiddleName | customers.MiddleName | customers |
| customers__Mobile | OBJECT | customers.Mobile | customers.Mobile | customers |
| customers__ParentRef | OBJECT | customers.ParentRef | customers.ParentRef | customers |
| customers__PaymentMethodRef | OBJECT | customers.PaymentMethodRef | customers.PaymentMethodRef | customers |
| customers__PreferredDeliveryMethod | TEXT | customers.PreferredDeliveryMethod | customers.PreferredDeliveryMethod | customers |
| customers__PrimaryEmailAddr | OBJECT | customers.PrimaryEmailAddr | customers.PrimaryEmailAddr | customers |
| customers__PrimaryPhone | OBJECT | customers.PrimaryPhone | customers.PrimaryPhone | customers |
| customers__PrintOnCheckName | TEXT | customers.PrintOnCheckName | customers.PrintOnCheckName | customers |
| customers__ResaleNum | TEXT | customers.ResaleNum | customers.ResaleNum | customers |
| customers__SalesTermRef | OBJECT | customers.SalesTermRef | customers.SalesTermRef | customers |
| customers__ShipAddr | OBJECT | customers.ShipAddr | customers.ShipAddr | customers |
| customers__SyncToken | TEXT | customers.SyncToken | customers.SyncToken | customers |
| customers__Taxable | BOOLEAN | customers.Taxable | customers.Taxable | customers |
| customers__WebAddr | OBJECT | customers.WebAddr | customers.WebAddr | customers |
| customers__domain | TEXT | customers.domain | customers.domain | customers |
| customers__sparse | BOOLEAN | customers.sparse | customers.sparse | customers |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| departments__Active | BOOLEAN | departments.Active | departments.Active | departments |
| departments__FullyQualifiedName | TEXT | departments.FullyQualifiedName | departments.FullyQualifiedName | departments |
| departments__Id | TEXT | departments.Id | departments.Id | departments |
| departments__MetaData | OBJECT | departments.MetaData | departments.MetaData | departments |
| departments__Name | TEXT | departments.Name | departments.Name | departments |
| departments__ParentRef | OBJECT | departments.ParentRef | departments.ParentRef | departments |
| departments__SubDepartment | BOOLEAN | departments.SubDepartment | departments.SubDepartment | departments |
| departments__SyncToken | TEXT | departments.SyncToken | departments.SyncToken | departments |
| departments__domain | TEXT | departments.domain | departments.domain | departments |
| deposits__CashBack | OBJECT | deposits.CashBack | deposits.CashBack | deposits |
| deposits__CurrencyRef | OBJECT | deposits.CurrencyRef | deposits.CurrencyRef | deposits |
| deposits__DepartmentRef | OBJECT | deposits.DepartmentRef | deposits.DepartmentRef | deposits |
| deposits__DepositToAccountRef | OBJECT | deposits.DepositToAccountRef | deposits.DepositToAccountRef | deposits |
| deposits__ExchangeRate | NUMERIC | deposits.ExchangeRate | deposits.ExchangeRate | deposits |
| deposits__Id | TEXT | deposits.Id | deposits.Id | deposits |
| deposits__Line | OBJECT | deposits.Line | deposits.Line | deposits |
| deposits__MetaData | OBJECT | deposits.MetaData | deposits.MetaData | deposits |
| deposits__PrivateNote | TEXT | deposits.PrivateNote | deposits.PrivateNote | deposits |
| deposits__SyncToken | TEXT | deposits.SyncToken | deposits.SyncToken | deposits |
| deposits__TotalAmt | NUMERIC | deposits.TotalAmt | deposits.TotalAmt | deposits |
| deposits__TxnDate | TEXT | deposits.TxnDate | deposits.TxnDate | deposits |
| deposits__domain | TEXT | deposits.domain | deposits.domain | deposits |
| deposits__sparse | BOOLEAN | deposits.sparse | deposits.sparse | deposits |
| employees__Active | BOOLEAN | employees.Active | employees.Active | employees |
| employees__BillRate | NUMERIC | employees.BillRate | employees.BillRate | employees |
| employees__BillableTime | BOOLEAN | employees.BillableTime | employees.BillableTime | employees |
| employees__BirthDate | TEXT | employees.BirthDate | employees.BirthDate | employees |
| employees__DisplayName | TEXT | employees.DisplayName | employees.DisplayName | employees |
| employees__EmployeeNumber | TEXT | employees.EmployeeNumber | employees.EmployeeNumber | employees |
| employees__FamilyName | TEXT | employees.FamilyName | employees.FamilyName | employees |
| employees__Gender | TEXT | employees.Gender | employees.Gender | employees |
| employees__GivenName | TEXT | employees.GivenName | employees.GivenName | employees |
| employees__HiredDate | TEXT | employees.HiredDate | employees.HiredDate | employees |
| employees__Id | TEXT | employees.Id | employees.Id | employees |
| employees__MetaData | OBJECT | employees.MetaData | employees.MetaData | employees |
| employees__MiddleName | TEXT | employees.MiddleName | employees.MiddleName | employees |
| employees__Mobile | OBJECT | employees.Mobile | employees.Mobile | employees |
| employees__Organization | BOOLEAN | employees.Organization | employees.Organization | employees |
| employees__PrimaryAddr | OBJECT | employees.PrimaryAddr | employees.PrimaryAddr | employees |
| employees__PrimaryEmailAddr | OBJECT | employees.PrimaryEmailAddr | employees.PrimaryEmailAddr | employees |
| employees__PrimaryPhone | OBJECT | employees.PrimaryPhone | employees.PrimaryPhone | employees |
| employees__PrintOnCheckName | TEXT | employees.PrintOnCheckName | employees.PrintOnCheckName | employees |
| employees__ReleasedDate | TEXT | employees.ReleasedDate | employees.ReleasedDate | employees |
| employees__Suffix | TEXT | employees.Suffix | employees.Suffix | employees |
| employees__SyncToken | TEXT | employees.SyncToken | employees.SyncToken | employees |
| employees__Title | TEXT | employees.Title | employees.Title | employees |
| employees__domain | TEXT | employees.domain | employees.domain | employees |
| employees__sparse | BOOLEAN | employees.sparse | employees.sparse | employees |
| estimates__ApplyTaxAfterDiscount | BOOLEAN | estimates.ApplyTaxAfterDiscount | estimates.ApplyTaxAfterDiscount | estimates |
| estimates__BillAddr | OBJECT | estimates.BillAddr | estimates.BillAddr | estimates |
| estimates__BillEmail | OBJECT | estimates.BillEmail | estimates.BillEmail | estimates |
| estimates__CurrencyRef | OBJECT | estimates.CurrencyRef | estimates.CurrencyRef | estimates |
| estimates__CustomField | OBJECT | estimates.CustomField | estimates.CustomField | estimates |
| estimates__CustomerMemo | OBJECT | estimates.CustomerMemo | estimates.CustomerMemo | estimates |
| estimates__CustomerRef | OBJECT | estimates.CustomerRef | estimates.CustomerRef | estimates |
| estimates__DeliveryInfo | OBJECT | estimates.DeliveryInfo | estimates.DeliveryInfo | estimates |
| estimates__DocNumber | TEXT | estimates.DocNumber | estimates.DocNumber | estimates |
| estimates__EmailStatus | TEXT | estimates.EmailStatus | estimates.EmailStatus | estimates |
| estimates__ExchangeRate | NUMERIC | estimates.ExchangeRate | estimates.ExchangeRate | estimates |
| estimates__HomeTotalAmt | NUMERIC | estimates.HomeTotalAmt | estimates.HomeTotalAmt | estimates |
| estimates__Id | TEXT | estimates.Id | estimates.Id | estimates |
| estimates__Line | OBJECT | estimates.Line | estimates.Line | estimates |
| estimates__LinkedTxn | OBJECT | estimates.LinkedTxn | estimates.LinkedTxn | estimates |
| estimates__MetaData | OBJECT | estimates.MetaData | estimates.MetaData | estimates |
| estimates__PrintStatus | TEXT | estimates.PrintStatus | estimates.PrintStatus | estimates |
| estimates__ShipAddr | OBJECT | estimates.ShipAddr | estimates.ShipAddr | estimates |
| estimates__SyncToken | TEXT | estimates.SyncToken | estimates.SyncToken | estimates |
| estimates__TotalAmt | NUMERIC | estimates.TotalAmt | estimates.TotalAmt | estimates |
| estimates__TxnDate | TEXT | estimates.TxnDate | estimates.TxnDate | estimates |
| estimates__TxnStatus | TEXT | estimates.TxnStatus | estimates.TxnStatus | estimates |
| estimates__TxnTaxDetail | OBJECT | estimates.TxnTaxDetail | estimates.TxnTaxDetail | estimates |
| estimates__domain | TEXT | estimates.domain | estimates.domain | estimates |
| estimates__sparse | BOOLEAN | estimates.sparse | estimates.sparse | estimates |
| invoices__AllowIPNPayment | BOOLEAN | invoices.AllowIPNPayment | invoices.AllowIPNPayment | invoices |
| invoices__AllowOnlineACHPayment | BOOLEAN | invoices.AllowOnlineACHPayment | invoices.AllowOnlineACHPayment | invoices |
| invoices__AllowOnlineCreditCardPayment | BOOLEAN | invoices.AllowOnlineCreditCardPayment | invoices.AllowOnlineCreditCardPayment | invoices |
| invoices__AllowOnlinePayment | BOOLEAN | invoices.AllowOnlinePayment | invoices.AllowOnlinePayment | invoices |
| invoices__ApplyTaxAfterDiscount | BOOLEAN | invoices.ApplyTaxAfterDiscount | invoices.ApplyTaxAfterDiscount | invoices |
| invoices__Balance | NUMERIC | invoices.Balance | invoices.Balance | invoices |
| invoices__BillAddr | OBJECT | invoices.BillAddr | invoices.BillAddr | invoices |
| invoices__BillEmail | OBJECT | invoices.BillEmail | invoices.BillEmail | invoices |
| invoices__CurrencyRef | OBJECT | invoices.CurrencyRef | invoices.CurrencyRef | invoices |
| invoices__CustomField | OBJECT | invoices.CustomField | invoices.CustomField | invoices |
| invoices__CustomerMemo | OBJECT | invoices.CustomerMemo | invoices.CustomerMemo | invoices |
| invoices__CustomerRef | OBJECT | invoices.CustomerRef | invoices.CustomerRef | invoices |
| invoices__DeliveryInfo | OBJECT | invoices.DeliveryInfo | invoices.DeliveryInfo | invoices |
| invoices__DocNumber | TEXT | invoices.DocNumber | invoices.DocNumber | invoices |
| invoices__DueDate | TEXT | invoices.DueDate | invoices.DueDate | invoices |
| invoices__EmailStatus | TEXT | invoices.EmailStatus | invoices.EmailStatus | invoices |
| invoices__ExchangeRate | NUMERIC | invoices.ExchangeRate | invoices.ExchangeRate | invoices |
| invoices__HomeTotalAmt | NUMERIC | invoices.HomeTotalAmt | invoices.HomeTotalAmt | invoices |
| invoices__Id | TEXT | invoices.Id | invoices.Id | invoices |
| invoices__Line | OBJECT | invoices.Line | invoices.Line | invoices |
| invoices__LinkedTxn | OBJECT | invoices.LinkedTxn | invoices.LinkedTxn | invoices |
| invoices__MetaData | OBJECT | invoices.MetaData | invoices.MetaData | invoices |
| invoices__PrintStatus | TEXT | invoices.PrintStatus | invoices.PrintStatus | invoices |
| invoices__PrivateNote | TEXT | invoices.PrivateNote | invoices.PrivateNote | invoices |
| invoices__SalesTermRef | OBJECT | invoices.SalesTermRef | invoices.SalesTermRef | invoices |
| invoices__ShipAddr | OBJECT | invoices.ShipAddr | invoices.ShipAddr | invoices |
| invoices__SyncToken | TEXT | invoices.SyncToken | invoices.SyncToken | invoices |
| invoices__TotalAmt | NUMERIC | invoices.TotalAmt | invoices.TotalAmt | invoices |
| invoices__TxnDate | TEXT | invoices.TxnDate | invoices.TxnDate | invoices |
| invoices__TxnTaxDetail | OBJECT | invoices.TxnTaxDetail | invoices.TxnTaxDetail | invoices |
| invoices__domain | TEXT | invoices.domain | invoices.domain | invoices |
| invoices__sparse | BOOLEAN | invoices.sparse | invoices.sparse | invoices |
| items__Active | BOOLEAN | items.Active | items.Active | items |
| items__AssetAccountRef | OBJECT | items.AssetAccountRef | items.AssetAccountRef | items |
| items__Description | TEXT | items.Description | items.Description | items |
| items__ExpenseAccountRef | OBJECT | items.ExpenseAccountRef | items.ExpenseAccountRef | items |
| items__FullyQualifiedName | TEXT | items.FullyQualifiedName | items.FullyQualifiedName | items |
| items__Id | TEXT | items.Id | items.Id | items |
| items__IncomeAccountRef | OBJECT | items.IncomeAccountRef | items.IncomeAccountRef | items |
| items__InvStartDate | TEXT | items.InvStartDate | items.InvStartDate | items |
| items__MetaData | OBJECT | items.MetaData | items.MetaData | items |
| items__Name | TEXT | items.Name | items.Name | items |
| items__PurchaseCost | NUMERIC | items.PurchaseCost | items.PurchaseCost | items |
| items__PurchaseDesc | TEXT | items.PurchaseDesc | items.PurchaseDesc | items |
| items__QtyOnHand | NUMERIC | items.QtyOnHand | items.QtyOnHand | items |
| items__SyncToken | TEXT | items.SyncToken | items.SyncToken | items |
| items__Taxable | BOOLEAN | items.Taxable | items.Taxable | items |
| items__TrackQtyOnHand | BOOLEAN | items.TrackQtyOnHand | items.TrackQtyOnHand | items |
| items__Type | TEXT | items.Type | items.Type | items |
| items__UnitPrice | NUMERIC | items.UnitPrice | items.UnitPrice | items |
| items__domain | TEXT | items.domain | items.domain | items |
| items__sparse | BOOLEAN | items.sparse | items.sparse | items |
| journal_entries__Adjustment | BOOLEAN | journal_entries.Adjustment | journal_entries.Adjustment | journal_entries |
| journal_entries__CurrencyRef | OBJECT | journal_entries.CurrencyRef | journal_entries.CurrencyRef | journal_entries |
| journal_entries__DocNumber | TEXT | journal_entries.DocNumber | journal_entries.DocNumber | journal_entries |
| journal_entries__ExchangeRate | NUMERIC | journal_entries.ExchangeRate | journal_entries.ExchangeRate | journal_entries |
| journal_entries__Id | TEXT | journal_entries.Id | journal_entries.Id | journal_entries |
| journal_entries__Line | OBJECT | journal_entries.Line | journal_entries.Line | journal_entries |
| journal_entries__MetaData | OBJECT | journal_entries.MetaData | journal_entries.MetaData | journal_entries |
| journal_entries__PrivateNote | TEXT | journal_entries.PrivateNote | journal_entries.PrivateNote | journal_entries |
| journal_entries__SyncToken | TEXT | journal_entries.SyncToken | journal_entries.SyncToken | journal_entries |
| journal_entries__TaxRateRef | OBJECT | journal_entries.TaxRateRef | journal_entries.TaxRateRef | journal_entries |
| journal_entries__TxnDate | TEXT | journal_entries.TxnDate | journal_entries.TxnDate | journal_entries |
| journal_entries__TxnTaxDetail | OBJECT | journal_entries.TxnTaxDetail | journal_entries.TxnTaxDetail | journal_entries |
| journal_entries__domain | TEXT | journal_entries.domain | journal_entries.domain | journal_entries |
| journal_entries__sparse | BOOLEAN | journal_entries.sparse | journal_entries.sparse | journal_entries |
| payment_methods__Active | BOOLEAN | payment_methods.Active | payment_methods.Active | payment_methods |
| payment_methods__Id | TEXT | payment_methods.Id | payment_methods.Id | payment_methods |
| payment_methods__MetaData | OBJECT | payment_methods.MetaData | payment_methods.MetaData | payment_methods |
| payment_methods__Name | TEXT | payment_methods.Name | payment_methods.Name | payment_methods |
| payment_methods__SyncToken | TEXT | payment_methods.SyncToken | payment_methods.SyncToken | payment_methods |
| payment_methods__Type | TEXT | payment_methods.Type | payment_methods.Type | payment_methods |
| payment_methods__domain | TEXT | payment_methods.domain | payment_methods.domain | payment_methods |
| payment_methods__sparse | BOOLEAN | payment_methods.sparse | payment_methods.sparse | payment_methods |
| payments__ARAccountRef | OBJECT | payments.ARAccountRef | payments.ARAccountRef | payments |
| payments__CurrencyRef | OBJECT | payments.CurrencyRef | payments.CurrencyRef | payments |
| payments__CustomerRef | OBJECT | payments.CustomerRef | payments.CustomerRef | payments |
| payments__DepositToAccountRef | OBJECT | payments.DepositToAccountRef | payments.DepositToAccountRef | payments |
| payments__ExchangeRate | NUMERIC | payments.ExchangeRate | payments.ExchangeRate | payments |
| payments__Id | TEXT | payments.Id | payments.Id | payments |
| payments__Line | OBJECT | payments.Line | payments.Line | payments |
| payments__LinkedTxn | OBJECT | payments.LinkedTxn | payments.LinkedTxn | payments |
| payments__MetaData | OBJECT | payments.MetaData | payments.MetaData | payments |
| payments__PaymentMethodRef | OBJECT | payments.PaymentMethodRef | payments.PaymentMethodRef | payments |
| payments__PaymentRefNum | TEXT | payments.PaymentRefNum | payments.PaymentRefNum | payments |
| payments__PrivateNote | TEXT | payments.PrivateNote | payments.PrivateNote | payments |
| payments__ProcessPayment | BOOLEAN | payments.ProcessPayment | payments.ProcessPayment | payments |
| payments__SyncToken | TEXT | payments.SyncToken | payments.SyncToken | payments |
| payments__TotalAmt | NUMERIC | payments.TotalAmt | payments.TotalAmt | payments |
| payments__TxnDate | TEXT | payments.TxnDate | payments.TxnDate | payments |
| payments__UnappliedAmt | NUMERIC | payments.UnappliedAmt | payments.UnappliedAmt | payments |
| payments__domain | TEXT | payments.domain | payments.domain | payments |
| payments__sparse | BOOLEAN | payments.sparse | payments.sparse | payments |
| purchase_orders__APAccountRef | OBJECT | purchase_orders.APAccountRef | purchase_orders.APAccountRef | purchase_orders |
| purchase_orders__ClassRef | OBJECT | purchase_orders.ClassRef | purchase_orders.ClassRef | purchase_orders |
| purchase_orders__CurrencyRef | OBJECT | purchase_orders.CurrencyRef | purchase_orders.CurrencyRef | purchase_orders |
| purchase_orders__CustomField | OBJECT | purchase_orders.CustomField | purchase_orders.CustomField | purchase_orders |
| purchase_orders__DepartmentRef | OBJECT | purchase_orders.DepartmentRef | purchase_orders.DepartmentRef | purchase_orders |
| purchase_orders__DocNumber | TEXT | purchase_orders.DocNumber | purchase_orders.DocNumber | purchase_orders |
| purchase_orders__DueDate | TEXT | purchase_orders.DueDate | purchase_orders.DueDate | purchase_orders |
| purchase_orders__EmailStatus | TEXT | purchase_orders.EmailStatus | purchase_orders.EmailStatus | purchase_orders |
| purchase_orders__ExchangeRate | NUMERIC | purchase_orders.ExchangeRate | purchase_orders.ExchangeRate | purchase_orders |
| purchase_orders__Id | TEXT | purchase_orders.Id | purchase_orders.Id | purchase_orders |
| purchase_orders__Line | OBJECT | purchase_orders.Line | purchase_orders.Line | purchase_orders |
| purchase_orders__LinkedTxn | OBJECT | purchase_orders.LinkedTxn | purchase_orders.LinkedTxn | purchase_orders |
| purchase_orders__Memo | TEXT | purchase_orders.Memo | purchase_orders.Memo | purchase_orders |
| purchase_orders__MetaData | OBJECT | purchase_orders.MetaData | purchase_orders.MetaData | purchase_orders |
| purchase_orders__POStatus | TEXT | purchase_orders.POStatus | purchase_orders.POStatus | purchase_orders |
| purchase_orders__PrivateNote | TEXT | purchase_orders.PrivateNote | purchase_orders.PrivateNote | purchase_orders |
| purchase_orders__SalesTermRef | OBJECT | purchase_orders.SalesTermRef | purchase_orders.SalesTermRef | purchase_orders |
| purchase_orders__ShipAddr | OBJECT | purchase_orders.ShipAddr | purchase_orders.ShipAddr | purchase_orders |
| purchase_orders__ShipTo | OBJECT | purchase_orders.ShipTo | purchase_orders.ShipTo | purchase_orders |
| purchase_orders__SyncToken | TEXT | purchase_orders.SyncToken | purchase_orders.SyncToken | purchase_orders |
| purchase_orders__TotalAmt | NUMERIC | purchase_orders.TotalAmt | purchase_orders.TotalAmt | purchase_orders |
| purchase_orders__TxnDate | TEXT | purchase_orders.TxnDate | purchase_orders.TxnDate | purchase_orders |
| purchase_orders__TxnTaxDetail | OBJECT | purchase_orders.TxnTaxDetail | purchase_orders.TxnTaxDetail | purchase_orders |
| purchase_orders__VendorAddr | OBJECT | purchase_orders.VendorAddr | purchase_orders.VendorAddr | purchase_orders |
| purchase_orders__VendorRef | OBJECT | purchase_orders.VendorRef | purchase_orders.VendorRef | purchase_orders |
| purchase_orders__domain | TEXT | purchase_orders.domain | purchase_orders.domain | purchase_orders |
| purchase_orders__sparse | BOOLEAN | purchase_orders.sparse | purchase_orders.sparse | purchase_orders |
| purchases__AccountRef | OBJECT | purchases.AccountRef | purchases.AccountRef | purchases |
| purchases__Credit | BOOLEAN | purchases.Credit | purchases.Credit | purchases |
| purchases__CurrencyRef | OBJECT | purchases.CurrencyRef | purchases.CurrencyRef | purchases |
| purchases__DocNumber | TEXT | purchases.DocNumber | purchases.DocNumber | purchases |
| purchases__EntityRef | OBJECT | purchases.EntityRef | purchases.EntityRef | purchases |
| purchases__ExchangeRate | NUMERIC | purchases.ExchangeRate | purchases.ExchangeRate | purchases |
| purchases__Id | TEXT | purchases.Id | purchases.Id | purchases |
| purchases__Line | OBJECT | purchases.Line | purchases.Line | purchases |
| purchases__MetaData | OBJECT | purchases.MetaData | purchases.MetaData | purchases |
| purchases__PaymentType | TEXT | purchases.PaymentType | purchases.PaymentType | purchases |
| purchases__PrintStatus | TEXT | purchases.PrintStatus | purchases.PrintStatus | purchases |
| purchases__PrivateNote | TEXT | purchases.PrivateNote | purchases.PrivateNote | purchases |
| purchases__PurchaseEx | OBJECT | purchases.PurchaseEx | purchases.PurchaseEx | purchases |
| purchases__RemitToAddr | OBJECT | purchases.RemitToAddr | purchases.RemitToAddr | purchases |
| purchases__SyncToken | TEXT | purchases.SyncToken | purchases.SyncToken | purchases |
| purchases__TotalAmt | NUMERIC | purchases.TotalAmt | purchases.TotalAmt | purchases |
| purchases__TxnDate | TEXT | purchases.TxnDate | purchases.TxnDate | purchases |
| purchases__domain | TEXT | purchases.domain | purchases.domain | purchases |
| purchases__sparse | BOOLEAN | purchases.sparse | purchases.sparse | purchases |
| refund_receipts__ApplyTaxAfterDiscount | BOOLEAN | refund_receipts.ApplyTaxAfterDiscount | refund_receipts.ApplyTaxAfterDiscount | refund_receipts |
| refund_receipts__Balance | NUMERIC | refund_receipts.Balance | refund_receipts.Balance | refund_receipts |
| refund_receipts__BillAddr | OBJECT | refund_receipts.BillAddr | refund_receipts.BillAddr | refund_receipts |
| refund_receipts__BillEmail | OBJECT | refund_receipts.BillEmail | refund_receipts.BillEmail | refund_receipts |
| refund_receipts__CurrencyRef | OBJECT | refund_receipts.CurrencyRef | refund_receipts.CurrencyRef | refund_receipts |
| refund_receipts__CustomField | OBJECT | refund_receipts.CustomField | refund_receipts.CustomField | refund_receipts |
| refund_receipts__CustomerMemo | OBJECT | refund_receipts.CustomerMemo | refund_receipts.CustomerMemo | refund_receipts |
| refund_receipts__CustomerRef | OBJECT | refund_receipts.CustomerRef | refund_receipts.CustomerRef | refund_receipts |
| refund_receipts__DepositToAccountRef | OBJECT | refund_receipts.DepositToAccountRef | refund_receipts.DepositToAccountRef | refund_receipts |
| refund_receipts__DocNumber | TEXT | refund_receipts.DocNumber | refund_receipts.DocNumber | refund_receipts |
| refund_receipts__ExchangeRate | NUMERIC | refund_receipts.ExchangeRate | refund_receipts.ExchangeRate | refund_receipts |
| refund_receipts__HomeTotalAmt | NUMERIC | refund_receipts.HomeTotalAmt | refund_receipts.HomeTotalAmt | refund_receipts |
| refund_receipts__Id | TEXT | refund_receipts.Id | refund_receipts.Id | refund_receipts |
| refund_receipts__Line | OBJECT | refund_receipts.Line | refund_receipts.Line | refund_receipts |
| refund_receipts__MetaData | OBJECT | refund_receipts.MetaData | refund_receipts.MetaData | refund_receipts |
| refund_receipts__PaymentMethodRef | OBJECT | refund_receipts.PaymentMethodRef | refund_receipts.PaymentMethodRef | refund_receipts |
| refund_receipts__PrintStatus | TEXT | refund_receipts.PrintStatus | refund_receipts.PrintStatus | refund_receipts |
| refund_receipts__SyncToken | TEXT | refund_receipts.SyncToken | refund_receipts.SyncToken | refund_receipts |
| refund_receipts__TotalAmt | NUMERIC | refund_receipts.TotalAmt | refund_receipts.TotalAmt | refund_receipts |
| refund_receipts__TxnDate | TEXT | refund_receipts.TxnDate | refund_receipts.TxnDate | refund_receipts |
| refund_receipts__TxnTaxDetail | OBJECT | refund_receipts.TxnTaxDetail | refund_receipts.TxnTaxDetail | refund_receipts |
| refund_receipts__domain | TEXT | refund_receipts.domain | refund_receipts.domain | refund_receipts |
| refund_receipts__sparse | BOOLEAN | refund_receipts.sparse | refund_receipts.sparse | refund_receipts |
| sales_receipts__ApplyTaxAfterDiscount | BOOLEAN | sales_receipts.ApplyTaxAfterDiscount | sales_receipts.ApplyTaxAfterDiscount | sales_receipts |
| sales_receipts__Balance | NUMERIC | sales_receipts.Balance | sales_receipts.Balance | sales_receipts |
| sales_receipts__BillAddr | OBJECT | sales_receipts.BillAddr | sales_receipts.BillAddr | sales_receipts |
| sales_receipts__BillEmail | OBJECT | sales_receipts.BillEmail | sales_receipts.BillEmail | sales_receipts |
| sales_receipts__CurrencyRef | OBJECT | sales_receipts.CurrencyRef | sales_receipts.CurrencyRef | sales_receipts |
| sales_receipts__CustomField | OBJECT | sales_receipts.CustomField | sales_receipts.CustomField | sales_receipts |
| sales_receipts__CustomerMemo | OBJECT | sales_receipts.CustomerMemo | sales_receipts.CustomerMemo | sales_receipts |
| sales_receipts__CustomerRef | OBJECT | sales_receipts.CustomerRef | sales_receipts.CustomerRef | sales_receipts |
| sales_receipts__DepositToAccountRef | OBJECT | sales_receipts.DepositToAccountRef | sales_receipts.DepositToAccountRef | sales_receipts |
| sales_receipts__DocNumber | TEXT | sales_receipts.DocNumber | sales_receipts.DocNumber | sales_receipts |
| sales_receipts__EmailStatus | TEXT | sales_receipts.EmailStatus | sales_receipts.EmailStatus | sales_receipts |
| sales_receipts__ExchangeRate | NUMERIC | sales_receipts.ExchangeRate | sales_receipts.ExchangeRate | sales_receipts |
| sales_receipts__HomeTotalAmt | NUMERIC | sales_receipts.HomeTotalAmt | sales_receipts.HomeTotalAmt | sales_receipts |
| sales_receipts__Id | TEXT | sales_receipts.Id | sales_receipts.Id | sales_receipts |
| sales_receipts__Line | OBJECT | sales_receipts.Line | sales_receipts.Line | sales_receipts |
| sales_receipts__LinkedTxn | OBJECT | sales_receipts.LinkedTxn | sales_receipts.LinkedTxn | sales_receipts |
| sales_receipts__MetaData | OBJECT | sales_receipts.MetaData | sales_receipts.MetaData | sales_receipts |
| sales_receipts__PaymentMethodRef | OBJECT | sales_receipts.PaymentMethodRef | sales_receipts.PaymentMethodRef | sales_receipts |
| sales_receipts__PaymentRefNum | TEXT | sales_receipts.PaymentRefNum | sales_receipts.PaymentRefNum | sales_receipts |
| sales_receipts__PrintStatus | TEXT | sales_receipts.PrintStatus | sales_receipts.PrintStatus | sales_receipts |
| sales_receipts__ShipAddr | OBJECT | sales_receipts.ShipAddr | sales_receipts.ShipAddr | sales_receipts |
| sales_receipts__SyncToken | TEXT | sales_receipts.SyncToken | sales_receipts.SyncToken | sales_receipts |
| sales_receipts__TotalAmt | NUMERIC | sales_receipts.TotalAmt | sales_receipts.TotalAmt | sales_receipts |
| sales_receipts__TxnDate | TEXT | sales_receipts.TxnDate | sales_receipts.TxnDate | sales_receipts |
| sales_receipts__TxnTaxDetail | OBJECT | sales_receipts.TxnTaxDetail | sales_receipts.TxnTaxDetail | sales_receipts |
| sales_receipts__domain | TEXT | sales_receipts.domain | sales_receipts.domain | sales_receipts |
| sales_receipts__sparse | BOOLEAN | sales_receipts.sparse | sales_receipts.sparse | sales_receipts |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| tax_agencies__DisplayName | TEXT | tax_agencies.DisplayName | tax_agencies.DisplayName | tax_agencies |
| tax_agencies__Id | TEXT | tax_agencies.Id | tax_agencies.Id | tax_agencies |
| tax_agencies__MetaData | OBJECT | tax_agencies.MetaData | tax_agencies.MetaData | tax_agencies |
| tax_agencies__SyncToken | TEXT | tax_agencies.SyncToken | tax_agencies.SyncToken | tax_agencies |
| tax_agencies__TaxRegistrationNumber | TEXT | tax_agencies.TaxRegistrationNumber | tax_agencies.TaxRegistrationNumber | tax_agencies |
| tax_agencies__TaxTrackedOnPurchases | BOOLEAN | tax_agencies.TaxTrackedOnPurchases | tax_agencies.TaxTrackedOnPurchases | tax_agencies |
| tax_agencies__TaxTrackedOnSales | BOOLEAN | tax_agencies.TaxTrackedOnSales | tax_agencies.TaxTrackedOnSales | tax_agencies |
| tax_agencies__domain | TEXT | tax_agencies.domain | tax_agencies.domain | tax_agencies |
| tax_agencies__sparse | BOOLEAN | tax_agencies.sparse | tax_agencies.sparse | tax_agencies |
| tax_codes__Active | BOOLEAN | tax_codes.Active | tax_codes.Active | tax_codes |
| tax_codes__Description | TEXT | tax_codes.Description | tax_codes.Description | tax_codes |
| tax_codes__Hidden | BOOLEAN | tax_codes.Hidden | tax_codes.Hidden | tax_codes |
| tax_codes__Id | TEXT | tax_codes.Id | tax_codes.Id | tax_codes |
| tax_codes__MetaData | OBJECT | tax_codes.MetaData | tax_codes.MetaData | tax_codes |
| tax_codes__Name | TEXT | tax_codes.Name | tax_codes.Name | tax_codes |
| tax_codes__PurchaseTaxRateList | OBJECT | tax_codes.PurchaseTaxRateList | tax_codes.PurchaseTaxRateList | tax_codes |
| tax_codes__SalesTaxRateList | OBJECT | tax_codes.SalesTaxRateList | tax_codes.SalesTaxRateList | tax_codes |
| tax_codes__SyncToken | TEXT | tax_codes.SyncToken | tax_codes.SyncToken | tax_codes |
| tax_codes__TaxGroup | BOOLEAN | tax_codes.TaxGroup | tax_codes.TaxGroup | tax_codes |
| tax_codes__Taxable | BOOLEAN | tax_codes.Taxable | tax_codes.Taxable | tax_codes |
| tax_codes__domain | TEXT | tax_codes.domain | tax_codes.domain | tax_codes |
| tax_codes__sparse | BOOLEAN | tax_codes.sparse | tax_codes.sparse | tax_codes |
| tax_rates__Active | BOOLEAN | tax_rates.Active | tax_rates.Active | tax_rates |
| tax_rates__AgencyRef | OBJECT | tax_rates.AgencyRef | tax_rates.AgencyRef | tax_rates |
| tax_rates__Description | TEXT | tax_rates.Description | tax_rates.Description | tax_rates |
| tax_rates__DisplayType | TEXT | tax_rates.DisplayType | tax_rates.DisplayType | tax_rates |
| tax_rates__EffectiveTaxRate | TEXT | tax_rates.EffectiveTaxRate | tax_rates.EffectiveTaxRate | tax_rates |
| tax_rates__Id | TEXT | tax_rates.Id | tax_rates.Id | tax_rates |
| tax_rates__MetaData | OBJECT | tax_rates.MetaData | tax_rates.MetaData | tax_rates |
| tax_rates__Name | TEXT | tax_rates.Name | tax_rates.Name | tax_rates |
| tax_rates__RateValue | NUMERIC | tax_rates.RateValue | tax_rates.RateValue | tax_rates |
| tax_rates__SpecialTaxType | TEXT | tax_rates.SpecialTaxType | tax_rates.SpecialTaxType | tax_rates |
| tax_rates__SyncToken | TEXT | tax_rates.SyncToken | tax_rates.SyncToken | tax_rates |
| tax_rates__domain | TEXT | tax_rates.domain | tax_rates.domain | tax_rates |
| tax_rates__sparse | BOOLEAN | tax_rates.sparse | tax_rates.sparse | tax_rates |
| terms__Active | BOOLEAN | terms.Active | terms.Active | terms |
| terms__DayOfMonthDue | NUMERIC | terms.DayOfMonthDue | terms.DayOfMonthDue | terms |
| terms__DiscountDayOfMonth | NUMERIC | terms.DiscountDayOfMonth | terms.DiscountDayOfMonth | terms |
| terms__DiscountDays | NUMERIC | terms.DiscountDays | terms.DiscountDays | terms |
| terms__DiscountPercent | NUMERIC | terms.DiscountPercent | terms.DiscountPercent | terms |
| terms__DueDays | NUMERIC | terms.DueDays | terms.DueDays | terms |
| terms__DueNextMonthDays | NUMERIC | terms.DueNextMonthDays | terms.DueNextMonthDays | terms |
| terms__Id | TEXT | terms.Id | terms.Id | terms |
| terms__MetaData | OBJECT | terms.MetaData | terms.MetaData | terms |
| terms__Name | TEXT | terms.Name | terms.Name | terms |
| terms__SyncToken | TEXT | terms.SyncToken | terms.SyncToken | terms |
| terms__Type | TEXT | terms.Type | terms.Type | terms |
| terms__domain | TEXT | terms.domain | terms.domain | terms |
| terms__sparse | BOOLEAN | terms.sparse | terms.sparse | terms |
| time_activities__BillableStatus | TEXT | time_activities.BillableStatus | time_activities.BillableStatus | time_activities |
| time_activities__CustomerRef | OBJECT | time_activities.CustomerRef | time_activities.CustomerRef | time_activities |
| time_activities__Description | TEXT | time_activities.Description | time_activities.Description | time_activities |
| time_activities__EmployeeRef | OBJECT | time_activities.EmployeeRef | time_activities.EmployeeRef | time_activities |
| time_activities__HourlyRate | NUMERIC | time_activities.HourlyRate | time_activities.HourlyRate | time_activities |
| time_activities__Hours | NUMERIC | time_activities.Hours | time_activities.Hours | time_activities |
| time_activities__Id | TEXT | time_activities.Id | time_activities.Id | time_activities |
| time_activities__ItemRef | OBJECT | time_activities.ItemRef | time_activities.ItemRef | time_activities |
| time_activities__MetaData | OBJECT | time_activities.MetaData | time_activities.MetaData | time_activities |
| time_activities__Minutes | NUMERIC | time_activities.Minutes | time_activities.Minutes | time_activities |
| time_activities__NameOf | TEXT | time_activities.NameOf | time_activities.NameOf | time_activities |
| time_activities__SyncToken | TEXT | time_activities.SyncToken | time_activities.SyncToken | time_activities |
| time_activities__Taxable | BOOLEAN | time_activities.Taxable | time_activities.Taxable | time_activities |
| time_activities__TxnDate | TEXT | time_activities.TxnDate | time_activities.TxnDate | time_activities |
| time_activities__domain | TEXT | time_activities.domain | time_activities.domain | time_activities |
| time_activities__sparse | BOOLEAN | time_activities.sparse | time_activities.sparse | time_activities |
| today | DATE | Today | Today's date | |
| transfers__Amount | NUMERIC | transfers.Amount | transfers.Amount | transfers |
| transfers__CurrencyRef | OBJECT | transfers.CurrencyRef | transfers.CurrencyRef | transfers |
| transfers__ExchangeRate | NUMERIC | transfers.ExchangeRate | transfers.ExchangeRate | transfers |
| transfers__FromAccountRef | OBJECT | transfers.FromAccountRef | transfers.FromAccountRef | transfers |
| transfers__Id | TEXT | transfers.Id | transfers.Id | transfers |
| transfers__MetaData | OBJECT | transfers.MetaData | transfers.MetaData | transfers |
| transfers__PrivateNote | TEXT | transfers.PrivateNote | transfers.PrivateNote | transfers |
| transfers__SyncToken | TEXT | transfers.SyncToken | transfers.SyncToken | transfers |
| transfers__ToAccountRef | OBJECT | transfers.ToAccountRef | transfers.ToAccountRef | transfers |
| transfers__TxnDate | TEXT | transfers.TxnDate | transfers.TxnDate | transfers |
| transfers__domain | TEXT | transfers.domain | transfers.domain | transfers |
| vendor_credits__APAccountRef | OBJECT | vendor_credits.APAccountRef | vendor_credits.APAccountRef | vendor_credits |
| vendor_credits__CurrencyRef | OBJECT | vendor_credits.CurrencyRef | vendor_credits.CurrencyRef | vendor_credits |
| vendor_credits__DepartmentRef | OBJECT | vendor_credits.DepartmentRef | vendor_credits.DepartmentRef | vendor_credits |
| vendor_credits__DocNumber | TEXT | vendor_credits.DocNumber | vendor_credits.DocNumber | vendor_credits |
| vendor_credits__ExchangeRate | NUMERIC | vendor_credits.ExchangeRate | vendor_credits.ExchangeRate | vendor_credits |
| vendor_credits__Id | TEXT | vendor_credits.Id | vendor_credits.Id | vendor_credits |
| vendor_credits__Line | OBJECT | vendor_credits.Line | vendor_credits.Line | vendor_credits |
| vendor_credits__MetaData | OBJECT | vendor_credits.MetaData | vendor_credits.MetaData | vendor_credits |
| vendor_credits__SyncToken | TEXT | vendor_credits.SyncToken | vendor_credits.SyncToken | vendor_credits |
| vendor_credits__TotalAmt | NUMERIC | vendor_credits.TotalAmt | vendor_credits.TotalAmt | vendor_credits |
| vendor_credits__TxnDate | TEXT | vendor_credits.TxnDate | vendor_credits.TxnDate | vendor_credits |
| vendor_credits__VendorRef | OBJECT | vendor_credits.VendorRef | vendor_credits.VendorRef | vendor_credits |
| vendor_credits__domain | TEXT | vendor_credits.domain | vendor_credits.domain | vendor_credits |
| vendors__AcctNum | TEXT | vendors.AcctNum | vendors.AcctNum | vendors |
| vendors__Active | BOOLEAN | vendors.Active | vendors.Active | vendors |
| vendors__Balance | NUMERIC | vendors.Balance | vendors.Balance | vendors |
| vendors__BillAddr | OBJECT | vendors.BillAddr | vendors.BillAddr | vendors |
| vendors__CompanyName | TEXT | vendors.CompanyName | vendors.CompanyName | vendors |
| vendors__CurrencyRef | OBJECT | vendors.CurrencyRef | vendors.CurrencyRef | vendors |
| vendors__DisplayName | TEXT | vendors.DisplayName | vendors.DisplayName | vendors |
| vendors__FamilyName | TEXT | vendors.FamilyName | vendors.FamilyName | vendors |
| vendors__Fax | OBJECT | vendors.Fax | vendors.Fax | vendors |
| vendors__GivenName | TEXT | vendors.GivenName | vendors.GivenName | vendors |
| vendors__Id | TEXT | vendors.Id | vendors.Id | vendors |
| vendors__MetaData | OBJECT | vendors.MetaData | vendors.MetaData | vendors |
| vendors__MiddleName | TEXT | vendors.MiddleName | vendors.MiddleName | vendors |
| vendors__Mobile | OBJECT | vendors.Mobile | vendors.Mobile | vendors |
| vendors__PrimaryEmailAddr | OBJECT | vendors.PrimaryEmailAddr | vendors.PrimaryEmailAddr | vendors |
| vendors__PrimaryPhone | OBJECT | vendors.PrimaryPhone | vendors.PrimaryPhone | vendors |
| vendors__PrintOnCheckName | TEXT | vendors.PrintOnCheckName | vendors.PrintOnCheckName | vendors |
| vendors__Suffix | TEXT | vendors.Suffix | vendors.Suffix | vendors |
| vendors__SyncToken | TEXT | vendors.SyncToken | vendors.SyncToken | vendors |
| vendors__TaxIdentifier | TEXT | vendors.TaxIdentifier | vendors.TaxIdentifier | vendors |
| vendors__TermRef | OBJECT | vendors.TermRef | vendors.TermRef | vendors |
| vendors__Title | TEXT | vendors.Title | vendors.Title | vendors |
| vendors__Vendor1099 | BOOLEAN | vendors.Vendor1099 | vendors.Vendor1099 | vendors |
| vendors__WebAddr | OBJECT | vendors.WebAddr | vendors.WebAddr | vendors |
| vendors__domain | TEXT | vendors.domain | vendors.domain | vendors |