2024 is the year of the connector - vote here

Explore the ApprovalMax API data model

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

Try our interactive ERD Or, browse below

Pulling data from the ApprovalMax 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 ApprovalMax 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

Document

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DocumentName string - -
IsSystem boolean - -
Date string -
  • 15 May 2024 This date lacks a time component so is stored as a string
RequestID string - -
CompanyID string - -
Version int - -
Origin string - -
FriendlyName string - -
CurrencyCode string - -
CreatedAt datetime - -
ModifiedAt datetime - -
DecisionDate datetime - -
RequestStatus string - -

QuickBooksBill

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Paid boolean - -
VendorID string - -
VendorName string - -
TermName string - -
DepartmentName string - -
MailingAddress string - -
MessageToVendor string - -
Memo string - -
LineAmountType string - -
Balance decimal - -
Date string -
  • 15 May 2024 This date lacks a time component so is stored as a string
DueDate string -
  • 15 May 2024 This date lacks a time component so is stored as a string
SubTotal decimal - -
TotalTax decimal - -
DocumentNumber string - -
RequestID string - -
CompanyID string - -
Version int - -
Origin string - -
FriendlyName string - -
CurrencyCode string - -
CreatedAt datetime - -
ModifiedAt datetime - -
DecisionDate datetime - -
RequestStatus string - -

QuickBooksExpense

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
VendorID string - -
VendorName string - -
PayeeID string - -
PayeeName string - -
PayeeType string - -
PaymentAccountID string - -
PaymentAccountName string - -
PaymentType string - -
PaymentMethodID string - -
PaymentMethodName string - -
DepartmentName string - -
MailingAddress string - -
Memo string - -
LineAmountType string - -
Balance decimal - -
PaymentDate string -
  • 15 May 2024 This date lacks a time component so is stored as a string
SubTotal decimal - -
TotalTax decimal - -
DocumentNumber string - -
RequestID string - -
CompanyID string - -
Version int - -
Origin string - -
FriendlyName string - -
CurrencyCode string - -
CreatedAt datetime - -
ModifiedAt datetime - -
DecisionDate datetime - -
RequestStatus string - -

QuickBooksPurchaseOrder

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Paid boolean - -
VendorID string - -
VendorName string - -
TermName string - -
DepartmentName string - -
MailingAddress string - -
ShippingMethod string - -
ShippingAddress string - -
MessageToVendor string - -
Memo string - -
LineAmountType string - -
Balance decimal - -
AdditionalField1Name string - -
AdditionalField1Value string - -
AdditionalField2Name string - -
AdditionalField2Value string - -
AdditionalField3Name string - -
AdditionalField3Value string - -
Date string -
  • 15 May 2024 This date lacks a time component so is stored as a string
SubTotal decimal - -
TotalTax decimal - -
DocumentNumber string - -
RequestID string - -
CompanyID string - -
Version int - -
Origin string - -
FriendlyName string - -
CurrencyCode string - -
CreatedAt datetime - -
ModifiedAt datetime - -
DecisionDate datetime - -
RequestStatus string - -

Workflow

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
WorkflowID string - -
CompanyID string - -

XeroBatchPayment

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
BankAccountID string - -
BankAccount string - -
Code string - -
Reference string - -
Particulars string - -
Narrative string - -
Details string - -
PaymentDate string -
  • 15 May 2024 This date lacks a time component so is stored as a string
SubTotal decimal - -
TotalTax decimal - -
DocumentNumber string - -
RequestID string - -
CompanyID string - -
Version int - -
Origin string - -
FriendlyName string - -
CurrencyCode string - -
CreatedAt datetime - -
ModifiedAt datetime - -
DecisionDate datetime - -
RequestStatus string - -

XeroBill

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Paid boolean - -
ContactID string - -
Contact string - -
TaxType string - -
Reference string - -
AmountDue decimal - -
Date string -
  • 15 May 2024 This date lacks a time component so is stored as a string
DueDate string -
  • 15 May 2024 This date lacks a time component so is stored as a string
SubTotal decimal - -
TotalTax decimal - -
DocumentNumber string - -
RequestID string - -
CompanyID string - -
Version int - -
Origin string - -
FriendlyName string - -
CurrencyCode string - -
CreatedAt datetime - -
ModifiedAt datetime - -
DecisionDate datetime - -
RequestStatus string - -

XeroCreditNote

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Paid boolean - -
ContactID string - -
Contact string - -
TaxType string - -
Reference string - -
CreditNoteType string - -
Date string -
  • 15 May 2024 This date lacks a time component so is stored as a string
DueDate string -
  • 15 May 2024 This date lacks a time component so is stored as a string
SubTotal decimal - -
TotalTax decimal - -
DocumentNumber string - -
RequestID string - -
CompanyID string - -
Version int - -
Origin string - -
FriendlyName string - -
CurrencyCode string - -
CreatedAt datetime - -
ModifiedAt datetime - -
DecisionDate datetime - -
RequestStatus string - -

XeroPurchaseOrder

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Billed boolean - -
ContactID string - -
Contact string - -
TaxType string - -
Reference string - -
RemainingBalance decimal - -
Date string -
  • 15 May 2024 This date lacks a time component so is stored as a string
DeliveryDate string -
  • 15 May 2024 This date lacks a time component so is stored as a string
SubTotal decimal - -
TotalTax decimal - -
DocumentNumber string - -
RequestID string - -
CompanyID string - -
Version int - -
Origin string - -
FriendlyName string - -
CurrencyCode string - -
CreatedAt datetime - -
ModifiedAt datetime - -
DecisionDate datetime - -
RequestStatus string - -

XeroSalesInvoice

Documentation: https://public-api.approvalmax.com/swagger/index.html

Column Type Relates to Notes
RemoteID string - -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Paid boolean - -
ContactID string - -
Contact string - -
TaxType string - -
Reference string - -
Date string -
  • 15 May 2024 This date lacks a time component so is stored as a string
DueDate string -
  • 15 May 2024 This date lacks a time component so is stored as a string
SubTotal decimal - -
TotalTax decimal - -
DocumentNumber string - -
RequestID string - -
CompanyID string - -
Version int - -
Origin string - -
FriendlyName string - -
CurrencyCode string - -
CreatedAt datetime - -
ModifiedAt datetime - -
DecisionDate datetime - -
RequestStatus string - -

DocumentAttachment

Column Type Relates to Notes
RemoteID string - -
DocumentRemoteID string Document → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DocumentID string Document → RequestID -
AttachmentID string - -
FileName string - -
FileSize int - -

DocumentEvent

Column Type Relates to Notes
RemoteID string - -
DocumentRemoteID string Document → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DocumentID string Document → RequestID -
Iterator int - -
EventType string - -
EventDate datetime - -
FirstName string - -
LastName string - -
Comment string - -
IsSystem boolean - -
CommentID string - -
FileSize int - -

DocumentAdditionalInformation

Column Type Relates to Notes
RemoteID string - -
DocumentRemoteID string Document → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DocumentID string Document → RequestID -
AdditionalFieldName string - -
Value string - -

QuickBooksBillAttachment

Column Type Relates to Notes
RemoteID string - -
QuickBooksBillRemoteID string QuickBooksBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksBillID string QuickBooksBill → RequestID -
AttachmentID string - -
FileName string - -
FileSize int - -

QuickBooksBillEvent

Column Type Relates to Notes
RemoteID string - -
QuickBooksBillRemoteID string QuickBooksBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksBillID string QuickBooksBill → RequestID -
Iterator int - -
EventType string - -
EventDate datetime - -
FirstName string - -
LastName string - -
Comment string - -
IsSystem boolean - -
CommentID string - -
FileSize int - -

QuickBooksBillItemBasedLineItem

Column Type Relates to Notes
RemoteID string - -
QuickBooksBillRemoteID string QuickBooksBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
QuickBooksBillID string QuickBooksBill → RequestID -
LineItemID string - -
UnitPriceGross decimal - -
CatalogUnitPrice decimal - -
Amount decimal - -
CustomerID string - -
CustomerName string - -
Class string - -
TaxCode string - -
TaxCodeID string - -
IsBillable boolean - -
IsTaxable boolean - -
ItemID string - -
Item string - -
IsInventory boolean - -
Quantity decimal - -
UnitPrice decimal - -

QuickBooksBillAccountBasedLineItem

Column Type Relates to Notes
RemoteID string - -
QuickBooksBillRemoteID string QuickBooksBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
QuickBooksBillID string QuickBooksBill → RequestID -
LineItemID string - -
UnitPriceGross decimal - -
CatalogUnitPrice decimal - -
Amount decimal - -
CustomerID string - -
CustomerName string - -
Class string - -
TaxCode string - -
TaxCodeID string - -
IsBillable boolean - -
IsTaxable boolean - -
AccountID string - -
Account string - -

QuickBooksBillTaxComponent

Column Type Relates to Notes
RemoteID string - -
QuickBooksBillRemoteID string QuickBooksBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksBillID string QuickBooksBill → RequestID -
Iterator int - -
TaxPercent decimal - -
TaxAmount decimal - -
TaxableAmount decimal - -
Hidden boolean - -
TaxRateID string - -

QuickBooksExpenseAttachment

Column Type Relates to Notes
RemoteID string - -
QuickBooksExpenseRemoteID string QuickBooksExpense → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksExpenseID string QuickBooksExpense → RequestID -
AttachmentID string - -
FileName string - -
FileSize int - -

QuickBooksExpenseEvent

Column Type Relates to Notes
RemoteID string - -
QuickBooksExpenseRemoteID string QuickBooksExpense → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksExpenseID string QuickBooksExpense → RequestID -
Iterator int - -
EventType string - -
EventDate datetime - -
FirstName string - -
LastName string - -
Comment string - -
IsSystem boolean - -
CommentID string - -
FileSize int - -

QuickBooksExpenseItemBasedLineItem

Column Type Relates to Notes
RemoteID string - -
QuickBooksExpenseRemoteID string QuickBooksExpense → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
QuickBooksExpenseID string QuickBooksExpense → RequestID -
LineItemID string - -
UnitPriceGross decimal - -
CatalogUnitPrice decimal - -
Amount decimal - -
CustomerID string - -
CustomerName string - -
Class string - -
TaxCode string - -
TaxCodeID string - -
IsBillable boolean - -
IsTaxable boolean - -
ItemID string - -
Item string - -
IsInventory boolean - -
Quantity decimal - -
UnitPrice decimal - -

QuickBooksExpenseAccountBasedLineItem

Column Type Relates to Notes
RemoteID string - -
QuickBooksExpenseRemoteID string QuickBooksExpense → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
QuickBooksExpenseID string QuickBooksExpense → RequestID -
LineItemID string - -
UnitPriceGross decimal - -
CatalogUnitPrice decimal - -
Amount decimal - -
CustomerID string - -
CustomerName string - -
Class string - -
TaxCode string - -
TaxCodeID string - -
IsBillable boolean - -
IsTaxable boolean - -
AccountID string - -
Account string - -

QuickBooksExpenseTaxComponent

Column Type Relates to Notes
RemoteID string - -
QuickBooksExpenseRemoteID string QuickBooksExpense → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksExpenseID string QuickBooksExpense → RequestID -
Iterator int - -
TaxPercent decimal - -
TaxAmount decimal - -
TaxableAmount decimal - -
Hidden boolean - -
TaxRateID string - -

QuickBooksPurchaseOrderAttachment

Column Type Relates to Notes
RemoteID string - -
QuickBooksPurchaseOrderRemoteID string QuickBooksPurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksPurchaseOrderID string QuickBooksPurchaseOrder → RequestID -
AttachmentID string - -
FileName string - -
FileSize int - -

QuickBooksPurchaseOrderEvent

Column Type Relates to Notes
RemoteID string - -
QuickBooksPurchaseOrderRemoteID string QuickBooksPurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksPurchaseOrderID string QuickBooksPurchaseOrder → RequestID -
Iterator int - -
EventType string - -
EventDate datetime - -
FirstName string - -
LastName string - -
Comment string - -
IsSystem boolean - -
CommentID string - -
FileSize int - -

QuickBooksPurchaseOrderItemBasedLineItem

Column Type Relates to Notes
RemoteID string - -
QuickBooksPurchaseOrderRemoteID string QuickBooksPurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
QuickBooksPurchaseOrderID string QuickBooksPurchaseOrder → RequestID -
LineItemID string - -
UnitPriceGross decimal - -
CatalogUnitPrice decimal - -
Amount decimal - -
CustomerID string - -
CustomerName string - -
Class string - -
TaxCode string - -
TaxCodeID string - -
IsBillable boolean - -
IsTaxable boolean - -
ItemID string - -
Item string - -
IsInventory boolean - -
Quantity decimal - -
UnitPrice decimal - -

QuickBooksPurchaseOrderAccountBasedLineItem

Column Type Relates to Notes
RemoteID string - -
QuickBooksPurchaseOrderRemoteID string QuickBooksPurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
QuickBooksPurchaseOrderID string QuickBooksPurchaseOrder → RequestID -
LineItemID string - -
UnitPriceGross decimal - -
CatalogUnitPrice decimal - -
Amount decimal - -
CustomerID string - -
CustomerName string - -
Class string - -
TaxCode string - -
TaxCodeID string - -
IsBillable boolean - -
IsTaxable boolean - -
AccountID string - -
Account string - -

QuickBooksPurchaseOrderTaxComponent

Column Type Relates to Notes
RemoteID string - -
QuickBooksPurchaseOrderRemoteID string QuickBooksPurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksPurchaseOrderID string QuickBooksPurchaseOrder → RequestID -
Iterator int - -
TaxPercent decimal - -
TaxAmount decimal - -
TaxableAmount decimal - -
Hidden boolean - -
TaxRateID string - -

WorkflowAdditionalField

Column Type Relates to Notes
RemoteID string - -
WorkflowRemoteID string Workflow → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Name string - -
WorkflowID string Workflow → WorkflowID -
AdditionalFieldID string - -

WorkflowAdditionalFieldValue

Column Type Relates to Notes
RemoteID string - -
WorkflowAdditionalFieldRemoteID string WorkflowAdditionalField → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
AdditionalFieldID string WorkflowAdditionalField → AdditionalFieldID -
Value string - -

XeroBatchPaymentAttachment

Column Type Relates to Notes
RemoteID string - -
XeroBatchPaymentRemoteID string XeroBatchPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBatchPaymentID string XeroBatchPayment → RequestID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroBatchPaymentEvent

Column Type Relates to Notes
RemoteID string - -
XeroBatchPaymentRemoteID string XeroBatchPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBatchPaymentID string XeroBatchPayment → RequestID -
Iterator int - -
EventType string - -
EventDate datetime - -
FirstName string - -
LastName string - -
Comment string - -
IsSystem boolean - -
CommentID string - -
FileSize int - -

XeroBatchPaymentLineItem

Column Type Relates to Notes
RemoteID string - -
XeroBatchPaymentRemoteID string XeroBatchPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
XeroBatchPaymentID string XeroBatchPayment → RequestID -
Iterator int - -
ItemID string - -
Amount decimal - -
Account string - -
AccountCode string - -
AccountID string - -
Item string - -
ItemCode string - -
Quantity decimal - -
ItemPrice decimal - -
TaxCode string - -
TaxRate decimal - -
TaxRateEffective decimal - -
TaxRateString string - -

XeroBatchPaymentAllocation

Column Type Relates to Notes
RemoteID string - -
XeroBatchPaymentRemoteID string XeroBatchPayment → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBatchPaymentID string XeroBatchPayment → RequestID -
Iterator int - -
Amount decimal - -
FriendlyName string - -

XeroBillAttachment

Column Type Relates to Notes
RemoteID string - -
XeroBillRemoteID string XeroBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBillID string XeroBill → RequestID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroBillEvent

Column Type Relates to Notes
RemoteID string - -
XeroBillRemoteID string XeroBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBillID string XeroBill → RequestID -
Iterator int - -
EventType string - -
EventDate datetime - -
FirstName string - -
LastName string - -
Comment string - -
IsSystem boolean - -
CommentID string - -
FileSize int - -

XeroBillLineItem

Column Type Relates to Notes
RemoteID string - -
XeroBillRemoteID string XeroBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
XeroBillID string XeroBill → RequestID -
Iterator int - -
ItemID string - -
Amount decimal - -
Account string - -
AccountCode string - -
AccountID string - -
Item string - -
ItemCode string - -
Quantity decimal - -
ItemPrice decimal - -
TaxCode string - -
TaxRate decimal - -
TaxRateEffective decimal - -
TaxRateString string - -

XeroBillAllocation

Column Type Relates to Notes
RemoteID string - -
XeroBillRemoteID string XeroBill → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBillID string XeroBill → RequestID -
Iterator int - -
Amount decimal - -
FriendlyName string - -

XeroCreditNoteAttachment

Column Type Relates to Notes
RemoteID string - -
XeroCreditNoteRemoteID string XeroCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroCreditNoteID string XeroCreditNote → RequestID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroCreditNoteEvent

Column Type Relates to Notes
RemoteID string - -
XeroCreditNoteRemoteID string XeroCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroCreditNoteID string XeroCreditNote → RequestID -
Iterator int - -
EventType string - -
EventDate datetime - -
FirstName string - -
LastName string - -
Comment string - -
IsSystem boolean - -
CommentID string - -
FileSize int - -

XeroCreditNoteLineItem

Column Type Relates to Notes
RemoteID string - -
XeroCreditNoteRemoteID string XeroCreditNote → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
XeroCreditNoteID string XeroCreditNote → RequestID -
Iterator int - -
ItemID string - -
Amount decimal - -
Account string - -
AccountCode string - -
AccountID string - -
Item string - -
ItemCode string - -
Quantity decimal - -
ItemPrice decimal - -
TaxCode string - -
TaxRate decimal - -
TaxRateEffective decimal - -
TaxRateString string - -

XeroPurchaseOrderAttachment

Column Type Relates to Notes
RemoteID string - -
XeroPurchaseOrderRemoteID string XeroPurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroPurchaseOrderID string XeroPurchaseOrder → RequestID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroPurchaseOrderEvent

Column Type Relates to Notes
RemoteID string - -
XeroPurchaseOrderRemoteID string XeroPurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroPurchaseOrderID string XeroPurchaseOrder → RequestID -
Iterator int - -
EventType string - -
EventDate datetime - -
FirstName string - -
LastName string - -
Comment string - -
IsSystem boolean - -
CommentID string - -
FileSize int - -

XeroPurchaseOrderLineItem

Column Type Relates to Notes
RemoteID string - -
XeroPurchaseOrderRemoteID string XeroPurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
XeroPurchaseOrderID string XeroPurchaseOrder → RequestID -
Iterator int - -
ItemID string - -
Amount decimal - -
Account string - -
AccountCode string - -
AccountID string - -
Item string - -
ItemCode string - -
Quantity decimal - -
ItemPrice decimal - -
TaxCode string - -
TaxRate decimal - -
TaxRateEffective decimal - -
TaxRateString string - -

XeroPurchaseOrderAllocation

Column Type Relates to Notes
RemoteID string - -
XeroPurchaseOrderRemoteID string XeroPurchaseOrder → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroPurchaseOrderID string XeroPurchaseOrder → RequestID -
Iterator int - -
Amount decimal - -
FriendlyName string - -

XeroSalesInvoiceAttachment

Column Type Relates to Notes
RemoteID string - -
XeroSalesInvoiceRemoteID string XeroSalesInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroSalesInvoiceID string XeroSalesInvoice → RequestID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroSalesInvoiceEvent

Column Type Relates to Notes
RemoteID string - -
XeroSalesInvoiceRemoteID string XeroSalesInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroSalesInvoiceID string XeroSalesInvoice → RequestID -
Iterator int - -
EventType string - -
EventDate datetime - -
FirstName string - -
LastName string - -
Comment string - -
IsSystem boolean - -
CommentID string - -
FileSize int - -

XeroSalesInvoiceLineItem

Column Type Relates to Notes
RemoteID string - -
XeroSalesInvoiceRemoteID string XeroSalesInvoice → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
Description string - -
XeroSalesInvoiceID string XeroSalesInvoice → RequestID -
Iterator int - -
ItemID string - -
Amount decimal - -
Account string - -
AccountCode string - -
AccountID string - -
Item string - -
ItemCode string - -
Quantity decimal - -
ItemPrice decimal - -
TaxCode string - -
TaxRate decimal - -
TaxRateEffective decimal - -
TaxRateString string - -

DocumentEventCommentAttachment

Column Type Relates to Notes
RemoteID string - -
DocumentEventRemoteID string DocumentEvent → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
DocumentEventCommentID string DocumentEvent → CommentID -
AttachmentID string - -
FileName string - -
FileSize int - -

QuickBooksBillEventCommentAttachment

Column Type Relates to Notes
RemoteID string - -
QuickBooksBillEventRemoteID string QuickBooksBillEvent → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksBillEventCommentID string QuickBooksBillEvent → CommentID -
AttachmentID string - -
FileName string - -
FileSize int - -

QuickBooksExpenseEventCommentAttachment

Column Type Relates to Notes
RemoteID string - -
QuickBooksExpenseEventRemoteID string QuickBooksExpenseEvent → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksExpenseEventCommentID string QuickBooksExpenseEvent → CommentID -
AttachmentID string - -
FileName string - -
FileSize int - -

QuickBooksPurchaseOrderEventCommentAttachment

Column Type Relates to Notes
RemoteID string - -
QuickBooksPurchaseOrderEventRemoteID string QuickBooksPurchaseOrderEvent → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
QuickBooksPurchaseOrderEventCommentID string QuickBooksPurchaseOrderEvent → CommentID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroBatchPaymentEventCommentAttachment

Column Type Relates to Notes
RemoteID string - -
XeroBatchPaymentEventRemoteID string XeroBatchPaymentEvent → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBatchPaymentEventCommentID string XeroBatchPaymentEvent → CommentID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroBatchPaymentLineItemTracking

Column Type Relates to Notes
RemoteID string - -
XeroBatchPaymentLineItemRemoteID string XeroBatchPaymentLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBatchPaymentLineItemID string XeroBatchPaymentLineItem → RemoteID -
CategoryID string - -
CategoryName string - -
OptionID string - -
OptionName string - -

XeroBillEventCommentAttachment

Column Type Relates to Notes
RemoteID string - -
XeroBillEventRemoteID string XeroBillEvent → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBillEventCommentID string XeroBillEvent → CommentID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroBillLineItemTracking

Column Type Relates to Notes
RemoteID string - -
XeroBillLineItemRemoteID string XeroBillLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroBillLineItemID string XeroBillLineItem → RemoteID -
CategoryID string - -
CategoryName string - -
OptionID string - -
OptionName string - -

XeroCreditNoteEventCommentAttachment

Column Type Relates to Notes
RemoteID string - -
XeroCreditNoteEventRemoteID string XeroCreditNoteEvent → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroCreditNoteEventCommentID string XeroCreditNoteEvent → CommentID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroCreditNoteLineItemTracking

Column Type Relates to Notes
RemoteID string - -
XeroCreditNoteLineItemRemoteID string XeroCreditNoteLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroCreditNoteLineItemID string XeroCreditNoteLineItem → RemoteID -
CategoryID string - -
CategoryName string - -
OptionID string - -
OptionName string - -

XeroPurchaseOrderEventCommentAttachment

Column Type Relates to Notes
RemoteID string - -
XeroPurchaseOrderEventRemoteID string XeroPurchaseOrderEvent → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroPurchaseOrderEventCommentID string XeroPurchaseOrderEvent → CommentID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroPurchaseOrderLineItemTracking

Column Type Relates to Notes
RemoteID string - -
XeroPurchaseOrderLineItemRemoteID string XeroPurchaseOrderLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroPurchaseOrderLineItemID string XeroPurchaseOrderLineItem → RemoteID -
CategoryID string - -
CategoryName string - -
OptionID string - -
OptionName string - -

XeroSalesInvoiceEventCommentAttachment

Column Type Relates to Notes
RemoteID string - -
XeroSalesInvoiceEventRemoteID string XeroSalesInvoiceEvent → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroSalesInvoiceEventCommentID string XeroSalesInvoiceEvent → CommentID -
AttachmentID string - -
FileName string - -
FileSize int - -

XeroSalesInvoiceLineItemTracking

Column Type Relates to Notes
RemoteID string - -
XeroSalesInvoiceLineItemRemoteID string XeroSalesInvoiceLineItem → RemoteID -
WhenUpsertedIntoDataStore datetime - -
MirrorRemoteID int - -
IsDeleted boolean - -
WhenCreated datetime - -
WhenModified datetime - -
XeroSalesInvoiceLineItemID string XeroSalesInvoiceLineItem → RemoteID -
CategoryID string - -
CategoryName string - -
OptionID string - -
OptionName string - -

Need more?

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

Connect your own ApprovalMax data Querying ApprovalMax using regular SQL