Windsor brings all your Xero data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure, Azure MS SQL
Xero Field Reference
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| accounts__accountid | TEXT | accounts.AccountID | accounts.AccountID | accounts |
| accounts__bankaccountnumber | TEXT | accounts.BankAccountNumber | accounts.BankAccountNumber | accounts |
| accounts__bankaccounttype | TEXT | accounts.BankAccountType | accounts.BankAccountType | accounts |
| accounts__class | TEXT | accounts.Class | accounts.Class | accounts |
| accounts__code | TEXT | accounts.Code | accounts.Code | accounts |
| accounts__currencycode | TEXT | accounts.CurrencyCode | accounts.CurrencyCode | accounts |
| accounts__description | TEXT | accounts.Description | accounts.Description | accounts |
| accounts__enablepaymentstoaccount | BOOLEAN | accounts.EnablePaymentsToAccount | accounts.EnablePaymentsToAccount | accounts |
| accounts__hasattachments | BOOLEAN | accounts.HasAttachments | accounts.HasAttachments | accounts |
| accounts__name | TEXT | accounts.Name | accounts.Name | accounts |
| accounts__reportingcode | TEXT | accounts.ReportingCode | accounts.ReportingCode | accounts |
| accounts__reportingcodename | TEXT | accounts.ReportingCodeName | accounts.ReportingCodeName | accounts |
| accounts__showinexpenseclaims | BOOLEAN | accounts.ShowInExpenseClaims | accounts.ShowInExpenseClaims | accounts |
| accounts__status | TEXT | accounts.Status | accounts.Status | accounts |
| accounts__systemaccount | TEXT | accounts.SystemAccount | accounts.SystemAccount | accounts |
| accounts__taxtype | TEXT | accounts.TaxType | accounts.TaxType | accounts |
| accounts__type | TEXT | accounts.Type | accounts.Type | accounts |
| accounts__updateddateutc | DATE | accounts.UpdatedDateUTC | accounts.UpdatedDateUTC | accounts |
| bank_transactions__bankaccount | OBJECT | bank_transactions.BankAccount | bank_transactions.BankAccount | bank_transactions |
| bank_transactions__banktransactionid | TEXT | bank_transactions.BankTransactionID | bank_transactions.BankTransactionID | bank_transactions |
| bank_transactions__contact | OBJECT | bank_transactions.Contact | bank_transactions.Contact | bank_transactions |
| bank_transactions__currencycode | TEXT | bank_transactions.CurrencyCode | bank_transactions.CurrencyCode | bank_transactions |
| bank_transactions__currencyrate | NUMERIC | bank_transactions.CurrencyRate | bank_transactions.CurrencyRate | bank_transactions |
| bank_transactions__date | DATE | bank_transactions.Date | bank_transactions.Date | bank_transactions |
| bank_transactions__datestring | TEXT | bank_transactions.DateString | bank_transactions.DateString | bank_transactions |
| bank_transactions__externallinkprovidername | TEXT | bank_transactions.ExternalLinkProviderName | bank_transactions.ExternalLinkProviderName | bank_transactions |
| bank_transactions__hasattachments | BOOLEAN | bank_transactions.HasAttachments | bank_transactions.HasAttachments | bank_transactions |
| bank_transactions__isreconciled | BOOLEAN | bank_transactions.IsReconciled | bank_transactions.IsReconciled | bank_transactions |
| bank_transactions__lineamounttypes | TEXT | bank_transactions.LineAmountTypes | bank_transactions.LineAmountTypes | bank_transactions |
| bank_transactions__lineitems | OBJECT | bank_transactions.LineItems | bank_transactions.LineItems | bank_transactions |
| bank_transactions__overpaymentid | TEXT | bank_transactions.OverpaymentID | bank_transactions.OverpaymentID | bank_transactions |
| bank_transactions__prepaymentid | TEXT | bank_transactions.PrepaymentID | bank_transactions.PrepaymentID | bank_transactions |
| bank_transactions__reference | TEXT | bank_transactions.Reference | bank_transactions.Reference | bank_transactions |
| bank_transactions__status | TEXT | bank_transactions.Status | bank_transactions.Status | bank_transactions |
| bank_transactions__subtotal | NUMERIC | bank_transactions.SubTotal | bank_transactions.SubTotal | bank_transactions |
| bank_transactions__total | NUMERIC | bank_transactions.Total | bank_transactions.Total | bank_transactions |
| bank_transactions__totaltax | NUMERIC | bank_transactions.TotalTax | bank_transactions.TotalTax | bank_transactions |
| bank_transactions__type | TEXT | bank_transactions.Type | bank_transactions.Type | bank_transactions |
| bank_transactions__updateddateutc | DATE | bank_transactions.UpdatedDateUTC | bank_transactions.UpdatedDateUTC | bank_transactions |
| bank_transactions__url | TEXT | bank_transactions.Url | bank_transactions.Url | bank_transactions |
| bank_transfers__amount | NUMERIC | bank_transfers.Amount | bank_transfers.Amount | bank_transfers |
| bank_transfers__banktransferid | TEXT | bank_transfers.BankTransferID | bank_transfers.BankTransferID | bank_transfers |
| bank_transfers__createddateutc | DATE | bank_transfers.CreatedDateUTC | bank_transfers.CreatedDateUTC | bank_transfers |
| bank_transfers__createddateutcstring | TEXT | bank_transfers.CreatedDateUTCString | bank_transfers.CreatedDateUTCString | bank_transfers |
| bank_transfers__currencyrate | NUMERIC | bank_transfers.CurrencyRate | bank_transfers.CurrencyRate | bank_transfers |
| bank_transfers__date | DATE | bank_transfers.Date | bank_transfers.Date | bank_transfers |
| bank_transfers__datestring | TEXT | bank_transfers.DateString | bank_transfers.DateString | bank_transfers |
| bank_transfers__frombankaccount | OBJECT | bank_transfers.FromBankAccount | bank_transfers.FromBankAccount | bank_transfers |
| bank_transfers__frombanktransactionid | TEXT | bank_transfers.FromBankTransactionID | bank_transfers.FromBankTransactionID | bank_transfers |
| bank_transfers__hasattachments | BOOLEAN | bank_transfers.HasAttachments | bank_transfers.HasAttachments | bank_transfers |
| bank_transfers__tobankaccount | OBJECT | bank_transfers.ToBankAccount | bank_transfers.ToBankAccount | bank_transfers |
| bank_transfers__tobanktransactionid | TEXT | bank_transfers.ToBankTransactionID | bank_transfers.ToBankTransactionID | bank_transfers |
| branding_themes__brandingthemeid | TEXT | branding_themes.BrandingThemeID | branding_themes.BrandingThemeID | branding_themes |
| branding_themes__createddateutc | DATE | branding_themes.CreatedDateUTC | branding_themes.CreatedDateUTC | branding_themes |
| branding_themes__name | TEXT | branding_themes.Name | branding_themes.Name | branding_themes |
| branding_themes__sortorder | NUMERIC | branding_themes.SortOrder | branding_themes.SortOrder | branding_themes |
| contact_groups__contactgroupid | TEXT | contact_groups.ContactGroupID | contact_groups.ContactGroupID | contact_groups |
| contact_groups__hasvalidationerrors | BOOLEAN | contact_groups.HasValidationErrors | contact_groups.HasValidationErrors | contact_groups |
| contact_groups__name | TEXT | contact_groups.Name | contact_groups.Name | contact_groups |
| contact_groups__status | TEXT | contact_groups.Status | contact_groups.Status | contact_groups |
| contacts__accountnumber | TEXT | contacts.AccountNumber | contacts.AccountNumber | contacts |
| contacts__accountspayabletaxtype | TEXT | contacts.AccountsPayableTaxType | contacts.AccountsPayableTaxType | contacts |
| contacts__accountsreceivabletaxtype | TEXT | contacts.AccountsReceivableTaxType | contacts.AccountsReceivableTaxType | contacts |
| contacts__addresses | OBJECT | contacts.Addresses | contacts.Addresses | contacts |
| contacts__attachments | OBJECT | contacts.Attachments | contacts.Attachments | contacts |
| contacts__balances | OBJECT | contacts.Balances | contacts.Balances | contacts |
| contacts__bankaccountdetails | TEXT | contacts.BankAccountDetails | contacts.BankAccountDetails | contacts |
| contacts__batchpayments | OBJECT | contacts.BatchPayments | contacts.BatchPayments | contacts |
| contacts__brandingtheme | OBJECT | contacts.BrandingTheme | contacts.BrandingTheme | contacts |
| contacts__contactgroups | OBJECT | contacts.ContactGroups | contacts.ContactGroups | contacts |
| contacts__contactid | TEXT | contacts.ContactID | contacts.ContactID | contacts |
| contacts__contactnumber | TEXT | contacts.ContactNumber | contacts.ContactNumber | contacts |
| contacts__contactpersons | OBJECT | contacts.ContactPersons | contacts.ContactPersons | contacts |
| contacts__contactstatus | TEXT | contacts.ContactStatus | contacts.ContactStatus | contacts |
| contacts__defaultcurrency | TEXT | contacts.DefaultCurrency | contacts.DefaultCurrency | contacts |
| contacts__discount | NUMERIC | contacts.Discount | contacts.Discount | contacts |
| contacts__emailaddress | TEXT | contacts.EmailAddress | contacts.EmailAddress | contacts |
| contacts__firstname | TEXT | contacts.FirstName | contacts.FirstName | contacts |
| contacts__hasattachments | BOOLEAN | contacts.HasAttachments | contacts.HasAttachments | contacts |
| contacts__hasvalidationerrors | BOOLEAN | contacts.HasValidationErrors | contacts.HasValidationErrors | contacts |
| contacts__iscustomer | BOOLEAN | contacts.IsCustomer | contacts.IsCustomer | contacts |
| contacts__issupplier | BOOLEAN | contacts.IsSupplier | contacts.IsSupplier | contacts |
| contacts__lastname | TEXT | contacts.LastName | contacts.LastName | contacts |
| contacts__name | TEXT | contacts.Name | contacts.Name | contacts |
| contacts__paymentterms | OBJECT | contacts.PaymentTerms | contacts.PaymentTerms | contacts |
| contacts__phones | OBJECT | contacts.Phones | contacts.Phones | contacts |
| contacts__purchasesdefaultaccountcode | TEXT | contacts.PurchasesDefaultAccountCode | contacts.PurchasesDefaultAccountCode | contacts |
| contacts__purchasestrackingcategories | OBJECT | contacts.PurchasesTrackingCategories | contacts.PurchasesTrackingCategories | contacts |
| contacts__salesdefaultaccountcode | TEXT | contacts.SalesDefaultAccountCode | contacts.SalesDefaultAccountCode | contacts |
| contacts__salestrackingcategories | OBJECT | contacts.SalesTrackingCategories | contacts.SalesTrackingCategories | contacts |
| contacts__skypeusername | TEXT | contacts.SkypeUserName | contacts.SkypeUserName | contacts |
| contacts__taxnumber | TEXT | contacts.TaxNumber | contacts.TaxNumber | contacts |
| contacts__trackingcategoryname | TEXT | contacts.TrackingCategoryName | contacts.TrackingCategoryName | contacts |
| contacts__trackingcategoryoption | TEXT | contacts.TrackingCategoryOption | contacts.TrackingCategoryOption | contacts |
| contacts__updateddateutc | DATE | contacts.UpdatedDateUTC | contacts.UpdatedDateUTC | contacts |
| contacts__validationerrors | OBJECT | contacts.ValidationErrors | contacts.ValidationErrors | contacts |
| contacts__website | TEXT | contacts.Website | contacts.Website | contacts |
| contacts__xeronetworkkey | TEXT | contacts.XeroNetworkKey | contacts.XeroNetworkKey | contacts |
| credit_notes__allocations | OBJECT | credit_notes.Allocations | credit_notes.Allocations | credit_notes |
| credit_notes__appliedamount | NUMERIC | credit_notes.AppliedAmount | credit_notes.AppliedAmount | credit_notes |
| credit_notes__brandingthemeid | TEXT | credit_notes.BrandingThemeID | credit_notes.BrandingThemeID | credit_notes |
| credit_notes__contact | OBJECT | credit_notes.Contact | credit_notes.Contact | credit_notes |
| credit_notes__creditnoteid | TEXT | credit_notes.CreditNoteID | credit_notes.CreditNoteID | credit_notes |
| credit_notes__creditnotenumber | TEXT | credit_notes.CreditNoteNumber | credit_notes.CreditNoteNumber | credit_notes |
| credit_notes__currencycode | TEXT | credit_notes.CurrencyCode | credit_notes.CurrencyCode | credit_notes |
| credit_notes__currencyrate | NUMERIC | credit_notes.CurrencyRate | credit_notes.CurrencyRate | credit_notes |
| credit_notes__date | DATE | credit_notes.Date | credit_notes.Date | credit_notes |
| credit_notes__datestring | TEXT | credit_notes.DateString | credit_notes.DateString | credit_notes |
| credit_notes__duedate | TEXT | credit_notes.DueDate | credit_notes.DueDate | credit_notes |
| credit_notes__duedatestring | TEXT | credit_notes.DueDateString | credit_notes.DueDateString | credit_notes |
| credit_notes__fullypaidondate | DATE | credit_notes.FullyPaidOnDate | credit_notes.FullyPaidOnDate | credit_notes |
| credit_notes__hasattachments | BOOLEAN | credit_notes.HasAttachments | credit_notes.HasAttachments | credit_notes |
| credit_notes__id | TEXT | credit_notes.ID | credit_notes.ID | credit_notes |
| credit_notes__lineamounttypes | TEXT | credit_notes.LineAmountTypes | credit_notes.LineAmountTypes | credit_notes |
| credit_notes__lineitems | OBJECT | credit_notes.LineItems | credit_notes.LineItems | credit_notes |
| credit_notes__reference | TEXT | credit_notes.Reference | credit_notes.Reference | credit_notes |
| credit_notes__remainingcredit | NUMERIC | credit_notes.RemainingCredit | credit_notes.RemainingCredit | credit_notes |
| credit_notes__senttocontact | BOOLEAN | credit_notes.SentToContact | credit_notes.SentToContact | credit_notes |
| credit_notes__status | TEXT | credit_notes.Status | credit_notes.Status | credit_notes |
| credit_notes__subtotal | NUMERIC | credit_notes.SubTotal | credit_notes.SubTotal | credit_notes |
| credit_notes__total | NUMERIC | credit_notes.Total | credit_notes.Total | credit_notes |
| credit_notes__totaltax | NUMERIC | credit_notes.TotalTax | credit_notes.TotalTax | credit_notes |
| credit_notes__type | TEXT | credit_notes.Type | credit_notes.Type | credit_notes |
| credit_notes__updateddateutc | DATE | credit_notes.UpdatedDateUTC | credit_notes.UpdatedDateUTC | credit_notes |
| currencies__code | TEXT | currencies.Code | currencies.Code | currencies |
| currencies__description | TEXT | currencies.Description | currencies.Description | currencies |
| datasource | TEXT | Data Source | The name of the Windsor connector returning the row | |
| employees__employeeid | TEXT | employees.EmployeeID | employees.EmployeeID | employees |
| employees__externallink | TEXT | employees.ExternalLink | employees.ExternalLink | employees |
| employees__firstname | TEXT | employees.FirstName | employees.FirstName | employees |
| employees__lastname | TEXT | employees.LastName | employees.LastName | employees |
| employees__status | TEXT | employees.Status | employees.Status | employees |
| employees__updateddateutc | DATE | employees.UpdatedDateUTC | employees.UpdatedDateUTC | employees |
| invoices__amountcredited | NUMERIC | invoices.AmountCredited | invoices.AmountCredited | invoices |
| invoices__amountdue | NUMERIC | invoices.AmountDue | invoices.AmountDue | invoices |
| invoices__amountpaid | NUMERIC | invoices.AmountPaid | invoices.AmountPaid | invoices |
| invoices__brandingthemeid | TEXT | invoices.BrandingThemeID | invoices.BrandingThemeID | invoices |
| invoices__contact | OBJECT | invoices.Contact | invoices.Contact | invoices |
| invoices__creditnotes | OBJECT | invoices.CreditNotes | invoices.CreditNotes | invoices |
| invoices__currencycode | TEXT | invoices.CurrencyCode | invoices.CurrencyCode | invoices |
| invoices__currencyrate | NUMERIC | invoices.CurrencyRate | invoices.CurrencyRate | invoices |
| invoices__date | TEXT | invoices.Date | invoices.Date | invoices |
| invoices__datestring | TEXT | invoices.DateString | invoices.DateString | invoices |
| invoices__duedate | TEXT | invoices.DueDate | invoices.DueDate | invoices |
| invoices__duedatestring | TEXT | invoices.DueDateString | invoices.DueDateString | invoices |
| invoices__expectedpaymentdate | DATE | invoices.ExpectedPaymentDate | invoices.ExpectedPaymentDate | invoices |
| invoices__expectedpaymentdatestring | TEXT | invoices.ExpectedPaymentDateString | invoices.ExpectedPaymentDateString | invoices |
| invoices__fullypaidondate | DATE | invoices.FullyPaidOnDate | invoices.FullyPaidOnDate | invoices |
| invoices__hasattachments | BOOLEAN | invoices.HasAttachments | invoices.HasAttachments | invoices |
| invoices__haserrors | BOOLEAN | invoices.HasErrors | invoices.HasErrors | invoices |
| invoices__invoiceid | TEXT | invoices.InvoiceID | invoices.InvoiceID | invoices |
| invoices__invoicenumber | TEXT | invoices.InvoiceNumber | invoices.InvoiceNumber | invoices |
| invoices__isdiscounted | BOOLEAN | invoices.IsDiscounted | invoices.IsDiscounted | invoices |
| invoices__lineamounttypes | TEXT | invoices.LineAmountTypes | invoices.LineAmountTypes | invoices |
| invoices__lineitems | OBJECT | invoices.LineItems | invoices.LineItems | invoices |
| invoices__overpayments | OBJECT | invoices.Overpayments | invoices.Overpayments | invoices |
| invoices__payments | OBJECT | invoices.Payments | invoices.Payments | invoices |
| invoices__plannedpaymentdate | DATE | invoices.PlannedPaymentDate | invoices.PlannedPaymentDate | invoices |
| invoices__plannedpaymentdatestring | TEXT | invoices.PlannedPaymentDateString | invoices.PlannedPaymentDateString | invoices |
| invoices__prepayments | OBJECT | invoices.Prepayments | invoices.Prepayments | invoices |
| invoices__reference | TEXT | invoices.Reference | invoices.Reference | invoices |
| invoices__senttocontact | BOOLEAN | invoices.SentToContact | invoices.SentToContact | invoices |
| invoices__status | TEXT | invoices.Status | invoices.Status | invoices |
| invoices__subtotal | NUMERIC | invoices.SubTotal | invoices.SubTotal | invoices |
| invoices__total | NUMERIC | invoices.Total | invoices.Total | invoices |
| invoices__totaldiscount | NUMERIC | invoices.TotalDiscount | invoices.TotalDiscount | invoices |
| invoices__totaltax | NUMERIC | invoices.TotalTax | invoices.TotalTax | invoices |
| invoices__type | TEXT | invoices.Type | invoices.Type | invoices |
| invoices__updateddateutc | DATE | invoices.UpdatedDateUTC | invoices.UpdatedDateUTC | invoices |
| invoices__url | TEXT | invoices.Url | invoices.Url | invoices |
| items__code | TEXT | items.Code | items.Code | items |
| items__description | TEXT | items.Description | items.Description | items |
| items__inventoryassetaccountcode | TEXT | items.InventoryAssetAccountCode | items.InventoryAssetAccountCode | items |
| items__ispurchased | BOOLEAN | items.IsPurchased | items.IsPurchased | items |
| items__issold | BOOLEAN | items.IsSold | items.IsSold | items |
| items__istrackedasinventory | BOOLEAN | items.IsTrackedAsInventory | items.IsTrackedAsInventory | items |
| items__itemid | TEXT | items.ItemID | items.ItemID | items |
| items__name | TEXT | items.Name | items.Name | items |
| items__purchasedescription | TEXT | items.PurchaseDescription | items.PurchaseDescription | items |
| items__purchasedetails | OBJECT | items.PurchaseDetails | items.PurchaseDetails | items |
| items__quantityonhand | NUMERIC | items.QuantityOnHand | items.QuantityOnHand | items |
| items__salesdetails | OBJECT | items.SalesDetails | items.SalesDetails | items |
| items__totalcostpool | NUMERIC | items.TotalCostPool | items.TotalCostPool | items |
| items__updateddateutc | DATE | items.UpdatedDateUTC | items.UpdatedDateUTC | items |
| manual_journals__date | DATE | manual_journals.Date | manual_journals.Date | manual_journals |
| manual_journals__hasattachments | BOOLEAN | manual_journals.HasAttachments | manual_journals.HasAttachments | manual_journals |
| manual_journals__journallines | OBJECT | manual_journals.JournalLines | manual_journals.JournalLines | manual_journals |
| manual_journals__lineamounttypes | TEXT | manual_journals.LineAmountTypes | manual_journals.LineAmountTypes | manual_journals |
| manual_journals__manualjournalid | TEXT | manual_journals.ManualJournalID | manual_journals.ManualJournalID | manual_journals |
| manual_journals__narration | TEXT | manual_journals.Narration | manual_journals.Narration | manual_journals |
| manual_journals__showoncashbasisreports | BOOLEAN | manual_journals.ShowOnCashBasisReports | manual_journals.ShowOnCashBasisReports | manual_journals |
| manual_journals__status | TEXT | manual_journals.Status | manual_journals.Status | manual_journals |
| manual_journals__updateddateutc | DATE | manual_journals.UpdatedDateUTC | manual_journals.UpdatedDateUTC | manual_journals |
| manual_journals__url | TEXT | manual_journals.Url | manual_journals.Url | manual_journals |
| organisations__addresses | OBJECT | organisations.Addresses | organisations.Addresses | organisations |
| organisations__apikey | TEXT | organisations.APIKey | organisations.APIKey | organisations |
| organisations__basecurrency | TEXT | organisations.BaseCurrency | organisations.BaseCurrency | organisations |
| organisations__countrycode | TEXT | organisations.CountryCode | organisations.CountryCode | organisations |
| organisations__createddateutc | DATE | organisations.CreatedDateUTC | organisations.CreatedDateUTC | organisations |
| organisations__defaultpurchasestax | TEXT | organisations.DefaultPurchasesTax | organisations.DefaultPurchasesTax | organisations |
| organisations__defaultsalestax | TEXT | organisations.DefaultSalesTax | organisations.DefaultSalesTax | organisations |
| organisations__endofyearlockdate | DATE | organisations.EndOfYearLockDate | organisations.EndOfYearLockDate | organisations |
| organisations__externallinks | OBJECT | organisations.ExternalLinks | organisations.ExternalLinks | organisations |
| organisations__financialyearendday | NUMERIC | organisations.FinancialYearEndDay | organisations.FinancialYearEndDay | organisations |
| organisations__financialyearendmonth | NUMERIC | organisations.FinancialYearEndMonth | organisations.FinancialYearEndMonth | organisations |
| organisations__isdemocompany | BOOLEAN | organisations.IsDemoCompany | organisations.IsDemoCompany | organisations |
| organisations__legalname | TEXT | organisations.LegalName | organisations.LegalName | organisations |
| organisations__lineofbusiness | TEXT | organisations.LineOfBusiness | organisations.LineOfBusiness | organisations |
| organisations__name | TEXT | organisations.Name | organisations.Name | organisations |
| organisations__organisationentitytype | TEXT | organisations.OrganisationEntityType | organisations.OrganisationEntityType | organisations |
| organisations__organisationid | TEXT | organisations.OrganisationID | organisations.OrganisationID | organisations |
| organisations__organisationstatus | TEXT | organisations.OrganisationStatus | organisations.OrganisationStatus | organisations |
| organisations__organisationtype | TEXT | organisations.OrganisationType | organisations.OrganisationType | organisations |
| organisations__paymentterms | OBJECT | organisations.PaymentTerms | organisations.PaymentTerms | organisations |
| organisations__paystax | BOOLEAN | organisations.PaysTax | organisations.PaysTax | organisations |
| organisations__periodlockdate | DATE | organisations.PeriodLockDate | organisations.PeriodLockDate | organisations |
| organisations__phones | OBJECT | organisations.Phones | organisations.Phones | organisations |
| organisations__registrationnumber | TEXT | organisations.RegistrationNumber | organisations.RegistrationNumber | organisations |
| organisations__salestaxbasis | TEXT | organisations.SalesTaxBasis | organisations.SalesTaxBasis | organisations |
| organisations__salestaxperiod | TEXT | organisations.SalesTaxPeriod | organisations.SalesTaxPeriod | organisations |
| organisations__shortcode | TEXT | organisations.ShortCode | organisations.ShortCode | organisations |
| organisations__taxnumber | TEXT | organisations.TaxNumber | organisations.TaxNumber | organisations |
| organisations__timezone | TEXT | organisations.Timezone | organisations.Timezone | organisations |
| organisations__version | TEXT | organisations.Version | organisations.Version | organisations |
| overpayments__allocations | OBJECT | overpayments.Allocations | overpayments.Allocations | overpayments |
| overpayments__appliedamount | NUMERIC | overpayments.AppliedAmount | overpayments.AppliedAmount | overpayments |
| overpayments__contact | OBJECT | overpayments.Contact | overpayments.Contact | overpayments |
| overpayments__currencycode | TEXT | overpayments.CurrencyCode | overpayments.CurrencyCode | overpayments |
| overpayments__currencyrate | NUMERIC | overpayments.CurrencyRate | overpayments.CurrencyRate | overpayments |
| overpayments__date | DATE | overpayments.Date | overpayments.Date | overpayments |
| overpayments__datestring | TEXT | overpayments.DateString | overpayments.DateString | overpayments |
| overpayments__hasattachments | BOOLEAN | overpayments.HasAttachments | overpayments.HasAttachments | overpayments |
| overpayments__id | TEXT | overpayments.ID | overpayments.ID | overpayments |
| overpayments__lineamounttypes | TEXT | overpayments.LineAmountTypes | overpayments.LineAmountTypes | overpayments |
| overpayments__lineitems | OBJECT | overpayments.LineItems | overpayments.LineItems | overpayments |
| overpayments__overpaymentid | TEXT | overpayments.OverpaymentID | overpayments.OverpaymentID | overpayments |
| overpayments__payments | OBJECT | overpayments.Payments | overpayments.Payments | overpayments |
| overpayments__reference | TEXT | overpayments.Reference | overpayments.Reference | overpayments |
| overpayments__remainingcredit | NUMERIC | overpayments.RemainingCredit | overpayments.RemainingCredit | overpayments |
| overpayments__status | TEXT | overpayments.Status | overpayments.Status | overpayments |
| overpayments__subtotal | NUMERIC | overpayments.SubTotal | overpayments.SubTotal | overpayments |
| overpayments__total | NUMERIC | overpayments.Total | overpayments.Total | overpayments |
| overpayments__totaltax | NUMERIC | overpayments.TotalTax | overpayments.TotalTax | overpayments |
| overpayments__type | TEXT | overpayments.Type | overpayments.Type | overpayments |
| overpayments__updateddateutc | DATE | overpayments.UpdatedDateUTC | overpayments.UpdatedDateUTC | overpayments |
| payments__account | OBJECT | payments.Account | payments.Account | payments |
| payments__amount | NUMERIC | payments.Amount | payments.Amount | payments |
| payments__bankamount | NUMERIC | payments.BankAmount | payments.BankAmount | payments |
| payments__batchpaymentid | TEXT | payments.BatchPaymentID | payments.BatchPaymentID | payments |
| payments__creditnote | OBJECT | payments.CreditNote | payments.CreditNote | payments |
| payments__currencyrate | NUMERIC | payments.CurrencyRate | payments.CurrencyRate | payments |
| payments__date | DATE | payments.Date | payments.Date | payments |
| payments__hasaccount | BOOLEAN | payments.HasAccount | payments.HasAccount | payments |
| payments__hasvalidationerrors | BOOLEAN | payments.HasValidationErrors | payments.HasValidationErrors | payments |
| payments__invoice | OBJECT | payments.Invoice | payments.Invoice | payments |
| payments__isreconciled | BOOLEAN | payments.IsReconciled | payments.IsReconciled | payments |
| payments__overpayment | OBJECT | payments.Overpayment | payments.Overpayment | payments |
| payments__paymentid | TEXT | payments.PaymentID | payments.PaymentID | payments |
| payments__paymenttype | TEXT | payments.PaymentType | payments.PaymentType | payments |
| payments__prepayments | OBJECT | payments.Prepayments | payments.Prepayments | payments |
| payments__reference | TEXT | payments.Reference | payments.Reference | payments |
| payments__status | TEXT | payments.Status | payments.Status | payments |
| payments__updateddateutc | DATE | payments.UpdatedDateUTC | payments.UpdatedDateUTC | payments |
| prepayments__allocations | OBJECT | prepayments.Allocations | prepayments.Allocations | prepayments |
| prepayments__appliedamount | NUMERIC | prepayments.AppliedAmount | prepayments.AppliedAmount | prepayments |
| prepayments__contact | OBJECT | prepayments.Contact | prepayments.Contact | prepayments |
| prepayments__currencycode | TEXT | prepayments.CurrencyCode | prepayments.CurrencyCode | prepayments |
| prepayments__currencyrate | NUMERIC | prepayments.CurrencyRate | prepayments.CurrencyRate | prepayments |
| prepayments__date | DATE | prepayments.Date | prepayments.Date | prepayments |
| prepayments__datestring | TEXT | prepayments.DateString | prepayments.DateString | prepayments |
| prepayments__hasattachments | BOOLEAN | prepayments.HasAttachments | prepayments.HasAttachments | prepayments |
| prepayments__id | TEXT | prepayments.ID | prepayments.ID | prepayments |
| prepayments__lineamounttypes | TEXT | prepayments.LineAmountTypes | prepayments.LineAmountTypes | prepayments |
| prepayments__lineitems | OBJECT | prepayments.LineItems | prepayments.LineItems | prepayments |
| prepayments__payments | OBJECT | prepayments.Payments | prepayments.Payments | prepayments |
| prepayments__prepaymentid | TEXT | prepayments.PrepaymentID | prepayments.PrepaymentID | prepayments |
| prepayments__reference | TEXT | prepayments.Reference | prepayments.Reference | prepayments |
| prepayments__remainingcredit | NUMERIC | prepayments.RemainingCredit | prepayments.RemainingCredit | prepayments |
| prepayments__status | TEXT | prepayments.Status | prepayments.Status | prepayments |
| prepayments__subtotal | NUMERIC | prepayments.SubTotal | prepayments.SubTotal | prepayments |
| prepayments__total | NUMERIC | prepayments.Total | prepayments.Total | prepayments |
| prepayments__totaltax | NUMERIC | prepayments.TotalTax | prepayments.TotalTax | prepayments |
| prepayments__type | TEXT | prepayments.Type | prepayments.Type | prepayments |
| prepayments__updateddateutc | DATE | prepayments.UpdatedDateUTC | prepayments.UpdatedDateUTC | prepayments |
| purchase_orders__attentionto | TEXT | purchase_orders.AttentionTo | purchase_orders.AttentionTo | purchase_orders |
| purchase_orders__brandingthemeid | TEXT | purchase_orders.BrandingThemeID | purchase_orders.BrandingThemeID | purchase_orders |
| purchase_orders__contact | OBJECT | purchase_orders.Contact | purchase_orders.Contact | purchase_orders |
| purchase_orders__currencycode | TEXT | purchase_orders.CurrencyCode | purchase_orders.CurrencyCode | purchase_orders |
| purchase_orders__currencyrate | NUMERIC | purchase_orders.CurrencyRate | purchase_orders.CurrencyRate | purchase_orders |
| purchase_orders__date | DATE | purchase_orders.Date | purchase_orders.Date | purchase_orders |
| purchase_orders__datestring | TEXT | purchase_orders.DateString | purchase_orders.DateString | purchase_orders |
| purchase_orders__deliveryaddress | TEXT | purchase_orders.DeliveryAddress | purchase_orders.DeliveryAddress | purchase_orders |
| purchase_orders__deliverydate | DATE | purchase_orders.DeliveryDate | purchase_orders.DeliveryDate | purchase_orders |
| purchase_orders__deliverydatestring | TEXT | purchase_orders.DeliveryDateString | purchase_orders.DeliveryDateString | purchase_orders |
| purchase_orders__deliveryinstructions | TEXT | purchase_orders.DeliveryInstructions | purchase_orders.DeliveryInstructions | purchase_orders |
| purchase_orders__expectedarrivaldate | DATE | purchase_orders.ExpectedArrivalDate | purchase_orders.ExpectedArrivalDate | purchase_orders |
| purchase_orders__expectedarrivaldatestring | TEXT | purchase_orders.ExpectedArrivalDateString | purchase_orders.ExpectedArrivalDateString | purchase_orders |
| purchase_orders__hasattachments | BOOLEAN | purchase_orders.HasAttachments | purchase_orders.HasAttachments | purchase_orders |
| purchase_orders__haserrors | BOOLEAN | purchase_orders.HasErrors | purchase_orders.HasErrors | purchase_orders |
| purchase_orders__isdiscounted | BOOLEAN | purchase_orders.IsDiscounted | purchase_orders.IsDiscounted | purchase_orders |
| purchase_orders__lineamounttypes | TEXT | purchase_orders.LineAmountTypes | purchase_orders.LineAmountTypes | purchase_orders |
| purchase_orders__lineitems | OBJECT | purchase_orders.LineItems | purchase_orders.LineItems | purchase_orders |
| purchase_orders__purchaseorderid | TEXT | purchase_orders.PurchaseOrderID | purchase_orders.PurchaseOrderID | purchase_orders |
| purchase_orders__purchaseordernumber | TEXT | purchase_orders.PurchaseOrderNumber | purchase_orders.PurchaseOrderNumber | purchase_orders |
| purchase_orders__reference | TEXT | purchase_orders.Reference | purchase_orders.Reference | purchase_orders |
| purchase_orders__senttocontact | BOOLEAN | purchase_orders.SentToContact | purchase_orders.SentToContact | purchase_orders |
| purchase_orders__status | TEXT | purchase_orders.Status | purchase_orders.Status | purchase_orders |
| purchase_orders__subtotal | NUMERIC | purchase_orders.SubTotal | purchase_orders.SubTotal | purchase_orders |
| purchase_orders__telephone | TEXT | purchase_orders.Telephone | purchase_orders.Telephone | purchase_orders |
| purchase_orders__total | NUMERIC | purchase_orders.Total | purchase_orders.Total | purchase_orders |
| purchase_orders__totaldiscount | NUMERIC | purchase_orders.TotalDiscount | purchase_orders.TotalDiscount | purchase_orders |
| purchase_orders__totaltax | NUMERIC | purchase_orders.TotalTax | purchase_orders.TotalTax | purchase_orders |
| purchase_orders__type | TEXT | purchase_orders.Type | purchase_orders.Type | purchase_orders |
| purchase_orders__updateddateutc | DATE | purchase_orders.UpdatedDateUTC | purchase_orders.UpdatedDateUTC | purchase_orders |
| repeating_invoices__brandingthemeid | TEXT | repeating_invoices.BrandingThemeID | repeating_invoices.BrandingThemeID | repeating_invoices |
| repeating_invoices__contact | OBJECT | repeating_invoices.Contact | repeating_invoices.Contact | repeating_invoices |
| repeating_invoices__currencycode | TEXT | repeating_invoices.CurrencyCode | repeating_invoices.CurrencyCode | repeating_invoices |
| repeating_invoices__hasattachments | BOOLEAN | repeating_invoices.HasAttachments | repeating_invoices.HasAttachments | repeating_invoices |
| repeating_invoices__id | TEXT | repeating_invoices.ID | repeating_invoices.ID | repeating_invoices |
| repeating_invoices__lineamounttypes | TEXT | repeating_invoices.LineAmountTypes | repeating_invoices.LineAmountTypes | repeating_invoices |
| repeating_invoices__lineitems | OBJECT | repeating_invoices.LineItems | repeating_invoices.LineItems | repeating_invoices |
| repeating_invoices__reference | TEXT | repeating_invoices.Reference | repeating_invoices.Reference | repeating_invoices |
| repeating_invoices__repeatinginvoiceid | TEXT | repeating_invoices.RepeatingInvoiceID | repeating_invoices.RepeatingInvoiceID | repeating_invoices |
| repeating_invoices__schedule | OBJECT | repeating_invoices.Schedule | repeating_invoices.Schedule | repeating_invoices |
| repeating_invoices__status | TEXT | repeating_invoices.Status | repeating_invoices.Status | repeating_invoices |
| repeating_invoices__subtotal | NUMERIC | repeating_invoices.SubTotal | repeating_invoices.SubTotal | repeating_invoices |
| repeating_invoices__total | NUMERIC | repeating_invoices.Total | repeating_invoices.Total | repeating_invoices |
| repeating_invoices__totaldiscount | NUMERIC | repeating_invoices.TotalDiscount | repeating_invoices.TotalDiscount | repeating_invoices |
| repeating_invoices__totaltax | NUMERIC | repeating_invoices.TotalTax | repeating_invoices.TotalTax | repeating_invoices |
| repeating_invoices__type | TEXT | repeating_invoices.Type | repeating_invoices.Type | repeating_invoices |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| tax_rates__canapplytoassets | BOOLEAN | tax_rates.CanApplyToAssets | tax_rates.CanApplyToAssets | tax_rates |
| tax_rates__canapplytoequity | BOOLEAN | tax_rates.CanApplyToEquity | tax_rates.CanApplyToEquity | tax_rates |
| tax_rates__canapplytoexpenses | BOOLEAN | tax_rates.CanApplyToExpenses | tax_rates.CanApplyToExpenses | tax_rates |
| tax_rates__canapplytoliabilities | BOOLEAN | tax_rates.CanApplyToLiabilities | tax_rates.CanApplyToLiabilities | tax_rates |
| tax_rates__canapplytorevenue | BOOLEAN | tax_rates.CanApplyToRevenue | tax_rates.CanApplyToRevenue | tax_rates |
| tax_rates__displaytaxrate | NUMERIC | tax_rates.DisplayTaxRate | tax_rates.DisplayTaxRate | tax_rates |
| tax_rates__effectiverate | NUMERIC | tax_rates.EffectiveRate | tax_rates.EffectiveRate | tax_rates |
| tax_rates__name | TEXT | tax_rates.Name | tax_rates.Name | tax_rates |
| tax_rates__reporttaxtype | TEXT | tax_rates.ReportTaxType | tax_rates.ReportTaxType | tax_rates |
| tax_rates__status | TEXT | tax_rates.Status | tax_rates.Status | tax_rates |
| tax_rates__taxcomponents | OBJECT | tax_rates.TaxComponents | tax_rates.TaxComponents | tax_rates |
| tax_rates__taxtype | TEXT | tax_rates.TaxType | tax_rates.TaxType | tax_rates |
| today | DATE | Today | Today's date | |
| tracking_categories__name | TEXT | tracking_categories.Name | tracking_categories.Name | tracking_categories |
| tracking_categories__option | TEXT | tracking_categories.Option | tracking_categories.Option | tracking_categories |
| tracking_categories__options | OBJECT | tracking_categories.Options | tracking_categories.Options | tracking_categories |
| tracking_categories__status | TEXT | tracking_categories.Status | tracking_categories.Status | tracking_categories |
| tracking_categories__trackingcategoryid | TEXT | tracking_categories.TrackingCategoryID | tracking_categories.TrackingCategoryID | tracking_categories |
| tracking_categories__trackingcategoryname | TEXT | tracking_categories.TrackingCategoryName | tracking_categories.TrackingCategoryName | tracking_categories |
| tracking_categories__trackingoptionid | TEXT | tracking_categories.TrackingOptionID | tracking_categories.TrackingOptionID | tracking_categories |
| tracking_categories__trackingoptionname | TEXT | tracking_categories.TrackingOptionName | tracking_categories.TrackingOptionName | tracking_categories |
| users__emailaddress | TEXT | users.EmailAddress | users.EmailAddress | users |
| users__firstname | TEXT | users.FirstName | users.FirstName | users |
| users__issubscriber | BOOLEAN | users.IsSubscriber | users.IsSubscriber | users |
| users__lastname | TEXT | users.LastName | users.LastName | users |
| users__organisationrole | TEXT | users.OrganisationRole | users.OrganisationRole | users |
| users__updateddateutc | DATE | users.UpdatedDateUTC | users.UpdatedDateUTC | users |
| users__userid | TEXT | users.UserID | users.UserID | users |
| users__validationerrors | OBJECT | users.ValidationErrors | users.ValidationErrors | users |