Explore the Sage Accounting API data model

See how the various Sage Accounting endpoints relate to each other, using our handy Entity Relationship Diagram

Try our interactive ERD Or, browse below

Pulling data from the Sage Accounting API is only the first part of your reporting. You also need to understand the relationships between different endpoints - something that APIs typically fail to convey.

At SyncHub, we not only sync your Sage Accounting API endpoints down into a reportable format, we also describe their relationships (e.g. in terms of foreign keys) so that you can quickly get a grasp of your data and how it fits together. This page is intended as technical documentation of these relationships.

Endpoints

Address

Documentation: https://developer.sage.com/accounting/reference/contacts/#tag/Addresses

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
AddressLine1 string - -
AddressLine2 string - -
City string - -
PostalCode string - -
Region string - -
IsMainAddress boolean - -
IsPreferredAddress boolean - -
CountryID string Country → ID -
ContactID string Contact → ID -
AddressTypeID string AddressType → ID -
CountryGroupID string -
  • 28 Jan 2026 Foreign Key - Refers to `CountryGroup` (not implemented, no useful data available).
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

AddressRegion

Documentation: https://developer.sage.com/accounting/reference/contacts/#tag/Address-Regions

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Code string - -
DisplayedAs string - -

AddressType

Documentation: https://developer.sage.com/accounting/reference/contacts/#tag/Address-Types

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DisplayedAs string - -

Attachment

Documentation: https://developer.sage.com/accounting/reference/attachments/#tag/Attachments

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
MimeType string - -
FileExtension string - -
FileSize long - -
FileName string - -
FilePath string - -
IsPublic boolean - -
TransactionID string Transaction → ID -
AttachmentContextTypeID string -
  • 2 Feb 2026 Foreign Key - Refers to `AttachmentContextType` (not implemented, no useful data available).
BankTransferID string BankTransfer → ID -
ContactID string Contact → ID -
JournalID string Journal → ID -
OtherPaymentID string OtherPayment → ID -
PurchaseCreditNoteID string PurchaseCreditNote → ID -
PurchaseInvoiceID string PurchaseInvoice → ID -
SalesCreditNoteID string SalesCreditNote → ID -
SalesEstimateID string SalesEstimate → ID -
SalesInvoiceID string SalesInvoice → ID -
SalesQuoteID string SalesQuote → ID -
BusinessID string -
  • 2 Feb 2026 Foreign Key - Refers to 'Business' (not implemented).
SalesCorrectiveInvoiceID string - -
PurchaseCorrectiveInvoiceID string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

BankAccount

Documentation: https://developer.sage.com/accounting/reference/banking/#tag/Bank-Accounts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
IsActive boolean - -
Balance decimal - -
NominalCode int - -
Editable boolean - -
Deletable boolean - -
GifiCode long - -
BankAccountDetailsAccountName string - -
BankAccountDetailsAccountNumber string - -
BankAccountDetailsSortCode string - -
BankAccountDetailsBic string - -
BankAccountDetailsIban string - -
LedgerAccountID string LedgerAccount → ID -
BankAccountTypeID string BankAccountType → ID -
MainAddressID string Address → ID -
MainContactPersonID string ContactPerson → ID -
DefaultPaymentMethodID string PaymentMethod → ID -
CurrencyID string Currency → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

BankAccountType

Documentation: https://developer.sage.com/accounting/reference/banking/#tag/Bank-Account-Types

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DisplayedAs string - -

BankDeposit

Documentation: https://developer.sage.com/accounting/reference/banking/#tag/Bank-Deposits

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
Reference string - -
CashAmount decimal - -
ChequeAmount decimal - -
TotalAmount decimal - -
TransactionID string Transaction → ID -
FromBankAccountID string BankAccount → ID -
ToBankAccountID string BankAccount → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

BankOpeningBalance

Documentation: https://developer.sage.com/accounting/reference/opening-balances/#tag/Bank-Opening-Balances

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
Debit decimal - -
Credit decimal - -
TransactionID string Transaction → ID -
BankAccountID string BankAccount → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

BankReconciliation

Documentation: https://developer.sage.com/accounting/reference/banking/#tag/Bank-Reconciliations

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
StatementDate datetime - -
StatementEndBalance decimal - -
Reference string - -
TotalReceived decimal - -
TotalPaid decimal - -
StartingBalance decimal - -
ClosingBalance decimal - -
ReconciledBalance decimal - -
BalanceDifference decimal - -
BankAccountID string BankAccount → ID -
StatusID string -
  • 30 Jan 2026 Foreign Key - Refers to `ArtefactStatus` (not implemented, no useful data available).
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

BankTransfer

Documentation: https://developer.sage.com/accounting/reference/banking/#tag/Bank-Transfers

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Date datetime - -
Reference string - -
Amount decimal - -
Editable boolean - -
TransactionID string Transaction → ID -
FromBankAccountID string BankAccount → ID -
ToBankAccountID string BankAccount → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

ChartOfAccounts

Documentation: https://developer.sage.com/accounting/reference/accounting-setup/#tag/Coa-Accounts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
LedgerAccountGroupID string -
  • 2 Feb 2026 Foreign Key - Refers to 'LedgerAccountGroup' (not implemented)
LedgerAccountTypeID string -
  • 2 Feb 2026 Foreign Key - Refers to 'LedgerAccountType' (not implemented, no useful data available).
LedgerAccountClassificationID string -
  • 2 Feb 2026 Foreign Key - Refers to 'LedgerAccountClassification' (not implemented, no useful data available).
TaxRateID string TaxRate → ID -
ControlName string - -
NominalCode long - -
FixedTaxRate boolean - -
CisMaterials boolean - -
CisLabour boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

ChartOfAccountsTemplate

Documentation: https://developer.sage.com/accounting/reference/accounting-setup/#tag/Coa-Templates

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
CountryID string Country → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

Contact

Documentation: https://developer.sage.com/accounting/reference/contacts/#tag/Contacts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
Reference string - -
TaxNumber string - -
Notes string - -
Locale string - -
CreditLimit decimal - -
CreditDays int - -
CreditTerms string - -
CreditTermsAndConditions string - -
SourceGuid string - -
RegisteredNumber string - -
Deletable boolean - -
Email string - -
TaxCalculation string - -
GdprObfuscated boolean - -
System boolean - -
CisRegistered boolean - -
RctRegistered boolean - -
NiBased boolean - -
IsActive boolean - -
GbBased boolean - -
DestinationVatBlocking boolean - -
MandateActive boolean - -
SendStatements boolean - -
Balance decimal - -
HasUnfinishedRecurringInvoices boolean - -
DefaultSalesTaxRateID string TaxRate → ID -
DefaultSalesLedgerAccountID string LedgerAccount → ID -
MainAddressID string Address → ID -
PreferredAddressID string Address → ID -
DeliveryAddressID string Address → ID -
MainContactPersonID string ContactPerson → ID -
PreferredContactPersonID string ContactPerson → ID -
BankAccountDetailsAccountName string - -
BankAccountDetailsAccountNumber string - -
BankAccountDetailsSortCode string - -
BankAccountDetailsBic string - -
BankAccountDetailsIban string - -
ProductSalesPriceTypeID string ProductSalesPriceType → ID -
CurrencyID string Currency → ID -
TaxTreatmentHomeTax boolean - -
TaxTreatmentEuTaxRegistered boolean - -
TaxTreatmentEuNotTaxRegistered boolean - -
TaxTreatmentRestOfWorldTax boolean - -
TaxTreatmentIsImporter boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

ContactAllocation

Documentation: https://developer.sage.com/accounting/reference/payments/#tag/Contact-Allocations

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
TransactionID string Contact → ID -
ContactID string Contact → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

ContactOpeningBalance

Documentation: https://developer.sage.com/accounting/reference/opening-balances/#tag/Contact-Opening-Balances

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
Reference string - -
Details string - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
ExchangeRate decimal - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
TaxRateID string TaxRate → ID -
TransactionID string Transaction → ID -
ContactOpeningBalanceTypeID string -
  • 28 Jan 2026 Foreign Key - Refers to `ContactOpeningBalanceType` (not implemented, no useful data available).
ContactID string Contact → ID -
CurrencyID string Currency → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

ContactPayment

Documentation: https://developer.sage.com/accounting/reference/payments/#tag/Contact-Payments

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
ExchangeRate decimal - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
BaseCurrencyCurrencyCharge decimal - -
Reference string - -
Editable boolean - -
TaxRateID string TaxRate → ID -
TransactionID string Transaction → ID -
PaymentMethodID string PaymentMethod → ID -
ContactID string Contact → ID -
BankAccountID string BankAccount → ID -
CurrencyID string Currency → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

ContactPerson

Documentation: https://developer.sage.com/accounting/reference/contacts/#tag/Contact-People

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
JobTitle string - -
Telephone string - -
Mobile string - -
Email string - -
Fax string - -
IsMainContact boolean - -
IsPreferredContact boolean - -
AddressID string Address → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

Country

Documentation: https://developer.sage.com/accounting/reference/contacts/#tag/Countries

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DisplayedAs string - -

Currency

Documentation: https://developer.sage.com/accounting/reference/currencies/#tag/Currencies

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DisplayedAs string - -

Journal

Documentation: https://developer.sage.com/accounting/reference/accounting/#tag/Journals

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Date datetime - -
Reference string - -
Total decimal - -
Migrated boolean - -
TransactionID string Transaction → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

LedgerAccount

Documentation: https://developer.sage.com/accounting/reference/accounting-setup/#tag/Ledger-Accounts

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Name string - -
DisplayName string - -
IncludedInChart boolean - -
NominalCode int - -
FixedTaxRate boolean - -
VisibleInBanking boolean - -
VisibleInExpenses boolean - -
VisibleInJournals boolean - -
VisibleInOtherPayments boolean - -
VisibleInOtherReceipts boolean - -
VisibleInReporting boolean - -
VisibleInSales boolean - -
UiVisible boolean - -
BankAttached boolean - -
IsControlAccount boolean - -
ControlName string - -
TaxRecoverable boolean - -
RecoverablePercentage decimal - -
CisMaterials boolean - -
TaxInstalment boolean - -
CisLabour boolean - -
GifiCode long - -
TaxRateID string TaxRate → ID -
LedgerAccountGroupID string -
  • 2 Feb 2026 Foreign Key - Refers to 'LedgerAccountGroup' (not implemented)
LedgerAccountTypeID string -
  • 2 Feb 2026 Foreign Key - Refers to 'LedgerAccountType' (not implemented, no useful data available).
LedgerAccountClassificationID string -
  • 2 Feb 2026 Foreign Key - Refers to 'LedgerAccountClassification' (not implemented, no useful data available).
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

LedgerAccountOpeningBalance

Documentation: https://developer.sage.com/accounting/reference/opening-balances/#tag/Ledger-Account-Opening-Balances

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Details string - -
Debit decimal - -
Credit decimal - -
LedgerAccountID string LedgerAccount → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

LedgerAccountType

Documentation: https://developer.sage.com/accounting/reference/accounting-setup/#tag/Ledger-Account-Types

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DisplayedAs string - -

LedgerEntry

Documentation: https://developer.sage.com/accounting/reference/accounting/#tag/Ledger-Entries

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Deleted boolean - -
Date datetime - -
Credit decimal - -
Debit decimal - -
LedgerAccountID string LedgerAccount → ID -
TransactionID string Transaction → ID -
ContactID string Contact → ID -
TaxRateID string TaxRate → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

OtherPayment

Documentation: https://developer.sage.com/accounting/reference/payments/#tag/Other-Payments

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
BaseCurrencyTotalItcAmount decimal - -
TotalItcAmount decimal - -
BaseCurrencyTotalItrAmount decimal - -
TotalItrAmount decimal - -
PartRecoverable boolean - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
Reference string - -
Editable boolean - -
Deletable boolean - -
WithholdingTaxRate decimal - -
WithholdingTaxAmount decimal - -
TransactionID string Transaction → ID -
PaymentMethodID string PaymentMethod → ID -
ContactID string Contact → ID -
BankAccountID string BankAccount → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

PaymentMethod

Documentation: https://developer.sage.com/accounting/reference/payments/#tag/Payment-Methods

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DisplayedAs string - -

Product

Documentation: https://developer.sage.com/accounting/reference/products-services/#tag/Products

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Active boolean - -
Deletable boolean - -
Deactivatable boolean - -
UsedOnRecurringInvoice boolean - -
ItemCode string - -
Notes string - -
CostPrice decimal - -
SourceGuid string - -
PurchaseDescription string - -
SalesLedgerAccountID string LedgerAccount → ID -
SalesTaxRateID string TaxRate → ID -
PurchaseLedgerAccountID string LedgerAccount → ID -
UsualSupplierID string Contact → ID -
PurchaseTaxRateID string TaxRate → ID -
CatalogItemTypeID string -
  • 30 Jan 2026 Foreign Key - Refers to `CatalogItemType` (not implemented, no useful data available).
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

ProductSalesPriceType

Documentation: https://developer.sage.com/accounting/reference/products-services/#tag/Product-Sales-Price-Types

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Active boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

ProductStockItem

Documentation: https://developer.sage.com/accounting/reference/products-services/#tag/Stock-Items

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
ProductID string Product → ID -
DisplayedAs string - -
CreatedAt datetime - -
UpdatedAt datetime - -
ReorderLevel decimal - -
ReorderQuantity decimal - -
Location string - -
Barcode string - -
SupplierPartNumber string - -
Weight decimal - -
MeasurementUnit string - -
WeightConverted decimal - -
QuantityInStock decimal - -
LastCostPrice decimal - -
LastCostPriceStockValue decimal - -
AverageCostPrice decimal - -
AverageCostPriceStockValue decimal - -
CostPriceLastUpdated datetime - -

PurchaseCreditNote

Documentation: https://developer.sage.com/accounting/reference/invoicing-purchases/#tag/Purchase-Credit-Notes

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
Editable boolean - -
VatReverseCharge boolean - -
RaisedByUser string - -
PostponedAccounting boolean - -
Import boolean - -
VatExemptConsignment boolean - -
IsCis boolean - -
CisApplicableAmount decimal - -
BaseCurrencyCisApplicableAmount decimal - -
TotalAfterCisDeduction decimal - -
BaseCurrencyTotalAfterCisDeduction decimal - -
HasCisLabour boolean - -
HasCisMaterials boolean - -
IsRct boolean - -
RctSiteNumber string - -
BaseCurrencyTotalItcAmount decimal - -
TotalItcAmount decimal - -
BaseCurrencyTotalItrAmount decimal - -
TotalItrAmount decimal - -
PartRecoverable boolean - -
ContactName string - -
ContactReference string - -
Reference string - -
VendorReference string - -
Notes string - -
TotalQuantity decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
TotalPaid decimal - -
OutstandingAmount decimal - -
ExchangeRate decimal - -
InverseExchangeRate decimal - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
BaseCurrencyOutstandingAmount decimal - -
LastPaid string - -
TaxReconciled boolean - -
Migrated boolean - -
TaxCalculationMethod string - -
WithholdingTaxRate decimal - -
WithholdingTaxAmount decimal - -
BaseCurrencyWithholdingTaxAmount decimal - -
VoidReason string - -
TransactionID string Transaction → ID -
ContactID string Contact → ID -
CurrencyID string Currency → ID -
StatusID string -
  • 30 Jan 2026 Foreign Key - Refers to `ArtefactStatus` (not implemented, no useful data available).
TaxAddressRegionID string - -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

PurchaseInvoice

Documentation: https://developer.sage.com/accounting/reference/invoicing-purchases/#tag/Purchase-Invoices

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Editable boolean - -
VatReverseCharge boolean - -
RaisedByUser string - -
PostponedAccounting boolean - -
Import boolean - -
VatExemptConsignment boolean - -
IsCis boolean - -
CisApplicableAmount decimal - -
BaseCurrencyCisApplicableAmount decimal - -
TotalAfterCisDeduction decimal - -
BaseCurrencyTotalAfterCisDeduction decimal - -
HasCisLabour boolean - -
HasCisMaterials boolean - -
IsRct boolean - -
RctSiteNumber string - -
BaseCurrencyTotalItcAmount decimal - -
TotalItcAmount decimal - -
BaseCurrencyTotalItrAmount decimal - -
TotalItrAmount decimal - -
PartRecoverable boolean - -
ContactName string - -
ContactReference string - -
Date datetime - -
DueDate datetime - -
Reference string - -
VendorReference string - -
Notes string - -
TotalQuantity decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
TotalPaid decimal - -
OutstandingAmount decimal - -
ExchangeRate decimal - -
InverseExchangeRate decimal - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
BaseCurrencyOutstandingAmount decimal - -
VoidReason string - -
LastPaid string - -
TaxAddressRegion string - -
WithholdingTaxRate decimal - -
WithholdingTaxAmount decimal - -
BaseCurrencyWithholdingTaxAmount decimal - -
TaxReconciled boolean - -
Migrated boolean - -
TaxCalculationMethod string - -
TransactionID string Transaction → ID -
ContactID string Contact → ID -
CurrencyID string Currency → ID -
StatusID string -
  • 30 Jan 2026 Foreign Key - Refers to `ArtefactStatus` (not implemented, no useful data available).
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

SalesCreditNote

Documentation: https://developer.sage.com/accounting/reference/invoicing-sales/#tag/Sales-Credit-Notes

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
Editable boolean - -
VatReverseCharge boolean - -
RaisedByUser string - -
TaxCalculationMethod string - -
DestinationConsignment boolean - -
DestinationVatRatesInUse boolean - -
IsCis boolean - -
CisApplicableAmount decimal - -
BaseCurrencyCisApplicableAmount decimal - -
TotalAfterCisDeduction decimal - -
BaseCurrencyTotalAfterCisDeduction decimal - -
HasCisLabour boolean - -
HasCisMaterials boolean - -
IsRct boolean - -
RctSiteNumber string - -
CreditNoteNumberPrefix string - -
CreditNoteNumber string - -
ContactName string - -
ContactReference string - -
Reference string - -
MainAddressFreeForm string - -
DeliveryAddressFreeForm string - -
Notes string - -
TermsAndConditions string - -
ShippingNetAmount decimal - -
ShippingTaxAmount decimal - -
TotalQuantity decimal - -
ShippingTotalAmount decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
TotalPaid decimal - -
OutstandingAmount decimal - -
ExchangeRate decimal - -
InverseExchangeRate decimal - -
BaseCurrencyShippingNetAmount decimal - -
BaseCurrencyShippingTaxAmount decimal - -
BaseCurrencyShippingTotalAmount decimal - -
TotalDiscountAmount decimal - -
BaseCurrencyTotalDiscountAmount decimal - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
BaseCurrencyOutstandingAmount decimal - -
LastPaid string - -
TaxAddressRegion string - -
TaxReconciled boolean - -
Migrated boolean - -
WithholdingTaxRate decimal - -
WithholdingTaxAmount decimal - -
BaseCurrencyWithholdingTaxAmount decimal - -
TransactionID string Transaction → ID -
ContactID string Contact → ID -
MainAddressID string Address → ID -
DeliveryAddressID string Address → ID -
ShippingTaxRateID string TaxRate → ID -
CurrencyID string Currency → ID -
StatusID string -
  • 30 Jan 2026 Foreign Key - Refers to `ArtefactStatus` (not implemented, no useful data available).
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

SalesEstimate

Documentation: https://developer.sage.com/accounting/reference/invoicing-sales/#tag/Sales-Estimates

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
ExpiryDate datetime - -
Editable boolean - -
VatReverseCharge boolean - -
RaisedByUser string - -
TaxCalculationMethod string - -
DestinationConsignment boolean - -
DestinationVatRatesInUse boolean - -
IsRct boolean - -
RctSiteNumber string - -
EstimateNumberPrefix string - -
EstimateNumber string - -
ContactName string - -
ContactReference string - -
Reference string - -
MainAddressFreeForm string - -
DeliveryAddressFreeForm string - -
Notes string - -
TermsAndConditions string - -
ShippingNetAmount decimal - -
ShippingTaxAmount decimal - -
ShippingTotalAmount decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
ExchangeRate decimal - -
InverseExchangeRate decimal - -
BaseCurrencyShippingNetAmount decimal - -
BaseCurrencyShippingTaxAmount decimal - -
BaseCurrencyShippingTotalAmount decimal - -
TotalQuantity decimal - -
TotalDiscountAmount decimal - -
BaseCurrencyTotalDiscountAmount decimal - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
PaymentsAllocationsTotalAmount decimal - -
PaymentsAllocationsTotalDiscount decimal - -
TotalPaid decimal - -
Sent boolean - -
SentByEmail boolean - -
ScheduledStartDate datetime - -
ScheduledFinishDate datetime - -
TaxAddressRegion string - -
WithholdingTaxRate decimal - -
WithholdingTaxAmount decimal - -
BaseCurrencyWithholdingTaxAmount decimal - -
TaxReconciled boolean - -
Invoice string - -
ContactID string Contact → ID -
MainAddressID string Address → ID -
DeliveryAddressID string Address → ID -
ShippingTaxRateID string TaxRate → ID -
CurrencyID string Currency → ID -
StatusID string -
  • 30 Jan 2026 Foreign Key - Refers to `ArtefactStatus` (not implemented, no useful data available).
ProfitAnalysisTotalCost decimal - -
ProfitAnalysisTotalSale decimal - -
ProfitAnalysisTotalProfit decimal - -
ProfitAnalysisTotalProfitPercentage decimal - -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

SalesInvoice

Documentation: https://developer.sage.com/accounting/reference/invoicing-sales/#tag/Sales-Invoices

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
DueDate datetime - -
Editable boolean - -
VatReverseCharge boolean - -
RaisedByUser string - -
TaxCalculationMethod string - -
DestinationConsignment boolean - -
DestinationVatRatesInUse boolean - -
IsCis boolean - -
CisApplicableAmount decimal - -
BaseCurrencyCisApplicableAmount decimal - -
TotalAfterCisDeduction decimal - -
BaseCurrencyTotalAfterCisDeduction decimal - -
HasCisLabour boolean - -
HasCisMaterials boolean - -
IsRct boolean - -
RctSiteNumber string - -
InvoiceNumberPrefix string - -
InvoiceNumber string - -
ContactName string - -
ContactReference string - -
Reference string - -
MainAddressFreeForm string - -
DeliveryAddressFreeForm string - -
Notes string - -
TermsAndConditions string - -
ShippingNetAmount decimal - -
ShippingTaxAmount decimal - -
ShippingTotalAmount decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
TotalPaid decimal - -
OutstandingAmount decimal - -
ExchangeRate decimal - -
InverseExchangeRate decimal - -
BaseCurrencyShippingNetAmount decimal - -
BaseCurrencyShippingTaxAmount decimal - -
BaseCurrencyShippingTotalAmount decimal - -
TotalQuantity decimal - -
TotalDiscountAmount decimal - -
BaseCurrencyTotalDiscountAmount decimal - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
BaseCurrencyOutstandingAmount decimal - -
Sent boolean - -
SentByEmail boolean - -
VoidReason string - -
LastPaid string - -
OriginalQuoteEstimate string - -
TaxAddressRegion string - -
DeliveryPerformanceDate string - -
WithholdingTaxRate decimal - -
WithholdingTaxAmount decimal - -
BaseCurrencyWithholdingTaxAmount decimal - -
TaxReconciled boolean - -
Migrated boolean - -
PasPaymentSubmission string - -
TransactionID string Transaction → ID -
ContactID string Contact → ID -
MainAddressID string Address → ID -
DeliveryAddressID string Address → ID -
ShippingTaxRateID string TaxRate → ID -
CurrencyID string Currency → ID -
StatusID string -
  • 30 Jan 2026 Foreign Key - Refers to `ArtefactStatus` (not implemented, no useful data available).
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

SalesQuote

Documentation: https://developer.sage.com/accounting/reference/invoicing-sales/#tag/Sales-Quotes

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
ExpiryDate datetime - -
Editable boolean - -
VatReverseCharge boolean - -
RaisedByUser string - -
TaxCalculationMethod string - -
DestinationConsignment boolean - -
DestinationVatRatesInUse boolean - -
IsRct boolean - -
RctSiteNumber string - -
QuoteNumberPrefix string - -
QuoteNumber string - -
Reference string - -
MainAddressFreeForm string - -
DeliveryAddressFreeForm string - -
Notes string - -
TermsAndConditions string - -
ShippingNetAmount decimal - -
ShippingTaxAmount decimal - -
ShippingTotalAmount decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
ExchangeRate decimal - -
InverseExchangeRate decimal - -
BaseCurrencyShippingNetAmount decimal - -
BaseCurrencyShippingTaxAmount decimal - -
BaseCurrencyShippingTotalAmount decimal - -
TotalQuantity decimal - -
TotalDiscountAmount decimal - -
BaseCurrencyTotalDiscountAmount decimal - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
PaymentsAllocationsTotalAmount decimal - -
PaymentsAllocationsTotalDiscount decimal - -
TotalPaid decimal - -
Sent boolean - -
SentByEmail boolean - -
ScheduledStartDate datetime - -
ScheduledFinishDate datetime - -
WithholdingTaxRate decimal - -
WithholdingTaxAmount decimal - -
BaseCurrencyWithholdingTaxAmount decimal - -
TaxReconciled boolean - -
InvoiceID string SalesInvoice → ID -
ContactID string Contact → ID -
MainAddressID string Address → ID -
DeliveryAddressID string Address → ID -
ShippingTaxRateID string TaxRate → ID -
CurrencyID string Currency → ID -
StatusID string -
  • 30 Jan 2026 Foreign Key - Refers to `ArtefactStatus` (not implemented, no useful data available).
ProfitAnalysisTotalCost decimal - -
ProfitAnalysisTotalSale decimal - -
ProfitAnalysisTotalProfit decimal - -
ProfitAnalysisTotalProfitPercentage decimal - -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

Service

Documentation: https://developer.sage.com/accounting/reference/products-services/#tag/Services

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
Deletable boolean - -
Deactivatable boolean - -
UsedOnRecurringInvoice boolean - -
ItemCode string - -
Notes string - -
SourceGuid string - -
PurchaseDescription string - -
UsualSupplier string - -
Active boolean - -
CostPrice decimal - -
OssService boolean - -
SalesLedgerAccountID string LedgerAccount → ID -
PurchaseLedgerAccountID string LedgerAccount → ID -
SalesTaxRateID string TaxRate → ID -
PurchaseTaxRateID string TaxRate → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

ServiceRateType

Documentation: https://developer.sage.com/accounting/reference/products-services/#tag/Service-Rate-Types

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Active boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

StockMovement

Documentation: https://developer.sage.com/accounting/reference/products-services/#tag/Stock-Movements

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Date datetime - -
MovementNumber int - -
CostPrice decimal - -
Quantity decimal - -
Details string - -
Reference string - -
StockItemID string Product → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

TaxRate

Documentation: https://developer.sage.com/accounting/reference/taxes/#tag/Tax-Rates

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Type string - -
NameFormatted string - -
Agency string - -
IsVisible boolean - -
Retailer boolean - -
Editable boolean - -
Deletable boolean - -
IsCombinedRate boolean - -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

Transaction

Documentation: https://developer.sage.com/accounting/reference/accounting/#tag/Transactions

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Deleted boolean - -
Date datetime - -
Reference string - -
Total decimal - -
TotalInTransactionCurrency decimal - -
AuditTrailID int - -
NumberOfAttachments int - -
ContactID string Contact → ID -
OriginBankOpeningBalanceID string BankOpeningBalance → ID -
OriginBankTransferID string BankTransfer → ID -
OriginCustomerAllocationID string ContactAllocation → ID -
OriginCustomerPaymentID string ContactPayment → ID -
OriginBankDepositID string BankDeposit → ID -
OriginJournalID string Journal → ID -
OriginOtherPaymentID string OtherPayment → ID -
OriginPurchaseInvoiceID string PurchaseInvoice → ID -
OriginPurchaseCreditNoteID string PurchaseCreditNote → ID -
OriginSalesCreditNoteID string SalesCreditNote → ID -
OriginSalesInvoiceID string SalesInvoice → ID -
OriginVendorAllocationID string ContactAllocation → ID -
OriginVendorPaymentID string ContactPayment → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

TransactionType

Documentation: https://developer.sage.com/accounting/reference/accounting/#tag/Transaction-Types

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
DisplayedAs string - -

ContactType

Column Type Relates to Notes
RemoteID string - -
ContactRemoteID string Contact → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
ContactID string Contact → ID -

ContactAllocationArtefact

Column Type Relates to Notes
RemoteID string - -
ContactAllocationRemoteID string ContactAllocation → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
ContactAllocationID string ContactAllocation → ID -
Amount decimal - -
PurchaseInvoiceID string PurchaseInvoice → ID -
PurchaseCreditNoteID string PurchaseCreditNote → ID -
SalesInvoiceID string SalesInvoice → ID -
SalesCreditNoteID string SalesCreditNote → ID -
ContactPaymentID string ContactPayment → ID -

ContactPaymentAllocatedArtefact

Column Type Relates to Notes
RemoteID string - -
ContactPaymentRemoteID string ContactPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
ContactPaymentID string ContactPayment → ID -
ArtefactID string ContactAllocationArtefact → ID -
Amount decimal - -
Discount decimal - -

ContactPersonType

Column Type Relates to Notes
RemoteID string - -
ContactPersonRemoteID string ContactPerson → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
ContactPersonID string ContactPerson → ID -

JournalLine

Column Type Relates to Notes
RemoteID string - -
JournalRemoteID string Journal → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
JournalID string Journal → ID -
Details string - -
Debit decimal - -
Credit decimal - -
IncludeOnTaxReturn boolean - -
TaxReconciled boolean - -
Cleared boolean - -
BankReconciled boolean - -
LedgerAccountID string LedgerAccount → ID -
JournalLineForeignCurrencyCurrencyDebit decimal - -
JournalLineForeignCurrencyCurrencyCredit decimal - -
JournalLineForeignCurrencyExchangeRate decimal - -

OtherPaymentLine

Column Type Relates to Notes
RemoteID string - -
OtherPaymentRemoteID string OtherPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
OtherPaymentID string OtherPayment → ID -
LedgerAccountID string LedgerAccount → ID -
TaxRateID string TaxRate → ID -
Details string - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
IsPurchaseForResale boolean - -
TradeOfAsset boolean - -
GstAmount decimal - -
PstAmount decimal - -
TaxRecoverable boolean - -
DisplayedAs string - -

ProductSalesPrice

Column Type Relates to Notes
RemoteID string - -
ProductRemoteID string Product → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
ProductID string Product → ID -
PriceName string - -
Price decimal - -
PriceIncludesTax boolean - -
ProductSalesPriceTypeID string ProductSalesPriceType → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

PurchaseCreditNoteLine

Column Type Relates to Notes
RemoteID string - -
PurchaseCreditNoteRemoteID string PurchaseCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
PurchaseCreditNoteID string PurchaseCreditNote → ID -
IsPurchaseForResale boolean - -
ProductID string Product → ID -
ServiceID string Service → ID -
LedgerAccountID string LedgerAccount → ID -
TradeOfAsset boolean - -
Quantity decimal - -
UnitPrice decimal - -
NetAmount decimal - -
TaxRateID string TaxRate → ID -
TaxAmount decimal - -
TotalAmount decimal - -
BaseCurrencyUnitPrice decimal - -
UnitPriceIncludesTax boolean - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
EuGoodsServicesType string - -
GstAmount decimal - -
PstAmount decimal - -
TaxRecoverable boolean - -
DisplayedAs string - -

PurchaseCreditNotePaymentAllocation

Column Type Relates to Notes
RemoteID string - -
PurchaseCreditNoteRemoteID string PurchaseCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseCreditNoteID string PurchaseCreditNote → ID -
LineNumber int - -
Date datetime - -
Type string - -
Reference string - -
Amount decimal - -
WithholdingTaxAmount decimal - -
Discount decimal - -
StripeTransactionID string - -
DisplayedAs string - -
NegativePayment boolean - -
PasPayment boolean - -
ContactAllocationID string ContactAllocation → ID -
ArtefactID string ContactAllocationArtefact → ID -
ContactPaymentID string ContactPayment → ID -

PurchaseInvoiceLine

Column Type Relates to Notes
RemoteID string - -
PurchaseInvoiceRemoteID string PurchaseInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
PurchaseInvoiceID string PurchaseInvoice → ID -
IsPurchaseForResale boolean - -
ProductID string Product → ID -
ServiceID string Service → ID -
LedgerAccountID string LedgerAccount → ID -
TradeOfAsset boolean - -
Quantity decimal - -
UnitPrice decimal - -
NetAmount decimal - -
TaxRateID string TaxRate → ID -
TaxAmount decimal - -
TotalAmount decimal - -
BaseCurrencyUnitPrice decimal - -
UnitPriceIncludesTax boolean - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
EuGoodsServicesType string - -
GstAmount decimal - -
PstAmount decimal - -
TaxRecoverable boolean - -
DisplayedAs string - -

PurchaseInvoicePaymentAllocation

Column Type Relates to Notes
RemoteID string - -
PurchaseInvoiceRemoteID string PurchaseInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
PurchaseInvoiceID string PurchaseInvoice → ID -
LineNumber int - -
Date datetime - -
Type string - -
Reference string - -
Amount decimal - -
WithholdingTaxAmount decimal - -
Discount decimal - -
StripeTransactionID string - -
DisplayedAs string - -
NegativePayment boolean - -
PasPayment boolean - -
ContactPaymentID string ContactPayment → ID -
ContactAllocationID string ContactAllocation → ID -
ArtefactID string ContactAllocationArtefact → ID -

SalesCreditNoteLine

Column Type Relates to Notes
RemoteID string - -
SalesCreditNoteRemoteID string SalesCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
SalesCreditNoteID string SalesCreditNote → ID -
TradeOfAsset boolean - -
Quantity decimal - -
UnitPrice decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
BaseCurrencyUnitPrice decimal - -
UnitPriceIncludesTax boolean - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
EuGoodsServicesType string - -
DiscountAmount decimal - -
BaseCurrencyDiscountAmount decimal - -
DiscountPercentage decimal - -
EuSalesDescription string - -
ProductID string Product → ID -
ServiceID string Service → ID -
LedgerAccountID string LedgerAccount → ID -
TaxRateID string TaxRate → ID -
DisplayedAs string - -

SalesCreditNotePaymentAllocation

Column Type Relates to Notes
RemoteID string - -
SalesCreditNoteRemoteID string SalesCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SalesCreditNoteID string SalesCreditNote → ID -
LineNumber int - -
Date datetime - -
Type string - -
Reference string - -
Amount decimal - -
DisplayedAs string - -
NegativePayment boolean - -
PasPayment boolean - -
ContactAllocationID string ContactAllocation → ID -
ArtefactID string ContactAllocationArtefact → ID -
ContactPaymentID string ContactPayment → ID -

SalesEstimateProfitLineBreakdown

Column Type Relates to Notes
RemoteID string - -
SalesEstimateRemoteID string SalesEstimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
SalesEstimateID string SalesEstimate → ID -
LineNumber int - -
TotalCost decimal - -
TotalSale decimal - -
Profit decimal - -
ProfitPercentage decimal - -

SalesEstimateLine

Column Type Relates to Notes
RemoteID string - -
SalesEstimateRemoteID string SalesEstimate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
SalesEstimateID string SalesEstimate → ID -
TradeOfAsset boolean - -
Quantity decimal - -
UnitPrice decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
BaseCurrencyUnitPrice decimal - -
UnitPriceIncludesTax boolean - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
EuGoodsServicesType string - -
DiscountAmount decimal - -
BaseCurrencyDiscountAmount decimal - -
DiscountPercentage decimal - -
EuSalesDescription string - -
ProductID string Product → ID -
ServiceID string Service → ID -
LedgerAccountID string LedgerAccount → ID -
TaxRateID string TaxRate → ID -
DisplayedAs string - -

SalesInvoiceLine

Column Type Relates to Notes
RemoteID string - -
SalesInvoiceRemoteID string SalesInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
SalesInvoiceID string SalesInvoice → ID -
TradeOfAsset boolean - -
Quantity decimal - -
UnitPrice decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
BaseCurrencyUnitPrice decimal - -
UnitPriceIncludesTax boolean - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
EuGoodsServicesType string - -
DiscountAmount decimal - -
BaseCurrencyDiscountAmount decimal - -
DiscountPercentage decimal - -
EuSalesDescription string - -
ProductID string Product → ID -
ServiceID string Service → ID -
LedgerAccountID string LedgerAccount → ID -
TaxRateID string TaxRate → ID -
DisplayedAs string - -

SalesInvoicePaymentAllocation

Column Type Relates to Notes
RemoteID string - -
SalesInvoiceRemoteID string SalesInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
SalesInvoiceID string SalesInvoice → ID -
LineNumber int - -
Date datetime - -
Type string - -
Reference string - -
Amount decimal - -
DisplayedAs string - -
NegativePayment boolean - -
PasPayment boolean - -
ContactAllocationID string ContactAllocation → ID -
ArtefactID string ContactAllocationArtefact → ID -
ContactPaymentID string ContactPayment → ID -

SalesQuoteProfitLineBreakdown

Column Type Relates to Notes
RemoteID string - -
SalesQuoteRemoteID string SalesQuote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
SalesQuoteID string SalesQuote → ID -
LineNumber int - -
TotalCost decimal - -
TotalSale decimal - -
Profit decimal - -
ProfitPercentage decimal - -

SalesQuoteLine

Column Type Relates to Notes
RemoteID string - -
SalesQuoteRemoteID string SalesQuote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
Description string - -
SalesQuoteID string SalesQuote → ID -
TradeOfAsset boolean - -
Quantity decimal - -
UnitPrice decimal - -
NetAmount decimal - -
TaxAmount decimal - -
TotalAmount decimal - -
BaseCurrencyUnitPrice decimal - -
UnitPriceIncludesTax boolean - -
BaseCurrencyNetAmount decimal - -
BaseCurrencyTaxAmount decimal - -
BaseCurrencyTotalAmount decimal - -
DiscountAmount decimal - -
BaseCurrencyDiscountAmount decimal - -
DiscountPercentage decimal - -
ProductID string Product → ID -
ServiceID string Service → ID -
LedgerAccountID string LedgerAccount → ID -
TaxRateID string TaxRate → ID -
DisplayedAs string - -

ServiceSaleRate

Column Type Relates to Notes
RemoteID string - -
ServiceRemoteID string Service → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
ID string - -
ServiceID string Service → ID -
RateName string - -
Rate decimal - -
RateIncludesTax boolean - -
ServiceRateTypeID string ServiceRateType → ID -
CreatedAt datetime - -
UpdatedAt datetime - -
DisplayedAs string - -

TaxRatePercentage

Column Type Relates to Notes
RemoteID string - -
TaxRateRemoteID string TaxRate → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
TaxRateID string TaxRate → ID -
LineNumber int - -
Percentage decimal - -
FromDate datetime - -
ToDate datetime - -

Need more?

SyncHub lives and breathes APIs and data. Keep exploring using the links below.

Connect your own Sage Accounting data Querying Sage Accounting using regular SQL