invantive documentation
Invantive Support ForumsLog In / Sign Up

SyncAccounts: Exact Online Accounts

read only per partition REST

  • Catalog: ExactOnlineREST
  • Schema: Sync
  • Primary Keys: Timestamp
  • Label: Accounts

The data in this table is partitioned per value of the Division column.

Can only retrieve data.

API Source

  • Endpoint: /api/v1/{division}/sync/CRM/Accounts
  • Metadata: /api/v1/{division}/sync/CRM/$metadata

Performance Characteristics

Characteristic Value
Average access latency (ms) 5
Full scan rows per minute 20,000
Point query rows per minute 300
Write rows per minute 300

The result can be cached on the client.

Table Columns

The columns of the table SyncAccounts are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
AccountManager guid Account Manager
AccountManagerFullName varchar2 Account Manager Full Name
AccountManagerHID int32 Account Manager HID
Accountant guid Accountant
ActivitySector guid Activity Sector
ActivitySubSector guid Activity Subsector
AddressLine1 varchar2(80) Address Line 1
AddressLine2 varchar2(80) Address Line 2
AddressLine3 varchar2(80) Address Line 3
AddressSource int16 Address Source
AutomaticProcessProposedEntry int16 Automatic Process Proposed Entry
BRIN guid BRIN
BSN varchar2 Social Security Number
Blocked char Blocked
BusinessType guid Business Type
CanDropShip char Can Drop Ship
ChamberOfCommerce varchar2(60) Chamber of Commerce
City varchar2 City
Classification varchar2 Classification
Classification1 guid Classification 1
Classification2 guid Classification 2
Classification3 guid Classification 3
Classification4 guid Classification 4
Classification5 guid Classification 5
Classification6 guid Classification 6
Classification7 guid Classification 7
Classification8 guid Classification 8
ClassificationDescription varchar2 Classification Description
Code varchar2 Code
CodeAtSupplier varchar2 Code at Supplier
CompanySize guid Company Size
ConsolidationScenario int16 Consolidation Scenario
ControlledDate datetime Date Checked
CostPaid int16 Cost Paid
Costcenter varchar2 Cost Centre
Country varchar2 Country
CountryName varchar2 Country Name
Created datetime Created
CreatedUtc datetime Created (UTC) writable Creation date in UTC.
Creator guid Creator
CreatorFullName varchar2 Creator Full Name
CreditLinePurchase double Credit Line for Purchase
CreditLineSales double Credit Line for Sales
Currency varchar2 Currency
CustomField varchar2 Custom Field
CustomerSince datetime Customer Since
DatevCreditorCode varchar2 DATEV Creditor Code
DatevDebtorCode varchar2 DATEV Debtor Code
DeliveryAdvice int16 Delivery Advice Delivery advice.
DiscountPurchase double Discount for Purchase
DiscountSales double Discount for Sales
Division int32 Division
DivisionCompanyCoCNumber varchar2(60) Division Chamber of Commerce Number writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Division IBAN Number writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) Division Company Name writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Division RSIN Number writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Division VAT Number writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) Division Wage Tax Number writable Wage tax number of the Exact Online division.
DivisionLabel varchar2(128) Division Label writable Label of the Exact Online division.
DivisionName varchar2(50) Administration Name writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) Subscription Holder Name writable Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionOwnerCompanyNumber varchar2(18) Subscription Holder Number writable Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.
DivisionShortName int64 Division Short Name writable Short name of the Exact Online division.
Document guid Document
DunsNumber varchar2 DUNS Number
EORINumber varchar2 EORI Number
Email varchar2 Email
EnableSalesPaymentLink char Enable Sales Payment Link
EndDate datetime End Date
EstablishedDate datetime Established Date
Fax varchar2 Fax
GLAP guid Accounts Payables General Ledger
GLAR guid Accounts Receivables General Ledger
GLAccountPurchase guid GL Account for Purchase
GLAccountSales guid GL Account for Sales
GlnNumber varchar2 GLN Number
HasWithholdingTaxSales char Has Withholding Tax Sales
ID guid ID
IgnoreDatevWarningMessage char Ignore DATEV Warning Message
IncotermAddressPurchase varchar2 Incoterm Address Purchase
IncotermAddressSales varchar2 Incoterm Address Sales
IncotermCodePurchase varchar2 Incoterm Code Purchase
IncotermCodeSales varchar2 Incoterm Code Sales
IncotermVersionPurchase int16 Incoterm Version Purchase
IncotermVersionSales int16 Incoterm Version Sales
IntraStatArea varchar2 Intrastat Area
IntraStatDeliveryTerm varchar2 Intrastat Delivery Term
IntraStatSystem varchar2 Intrastat System
IntraStatTransactionA varchar2 Intrastat Transaction A
IntraStatTransactionB varchar2 Intrastat Transaction B
IntraStatTransportMethod varchar2 Intrastat Transport Method
InvoiceAccount guid Invoice Account
InvoiceAttachmentType int32 Invoice Attachment Type
InvoicingMethod int32 Invoicing Method
IsAccountant int16 Is Accountant
IsAgency int16 Is Agency
IsAnonymised int16 Is Anonymised
IsBank char Is Bank
IsCompetitor int16 Is Competitor
IsExtraDuty char Is Extra Duty
IsMailing int16 Is Mailing
IsMember char Is Member
IsPilot char Is Pilot
IsPurchase char Is Purchase
IsReseller char Is Reseller
IsSales char Is Sales
IsSupplier char Is Supplier
Language varchar2 Language
LanguageDescription varchar2 Language Description
Latitude double Latitude
LeadPurpose guid Lead Purpose
LeadSource guid Lead Source
Logo blob Logo
LogoFileName varchar2 Logo File Name
LogoThumbnailUrl varchar2 Logo Thumbnail (URL)
LogoUrl varchar2 Logo (URL)
Longitude double Longitude
MainContact guid Main Contact
Modified datetime Modified
ModifiedUtc datetime Modified (UTC) writable Last modified date in UTC.
Modifier guid Modifier
ModifierFullName varchar2 Modified Full Name
Name varchar2 Name
OINNumber varchar2 OIN Number
Parent guid Parent
PayAsYouEarn varchar2 Pay-as-you-Earn
PaymentConditionPurchase varchar2 Payment Condition Purchase
PaymentConditionPurchaseDescription varchar2 Payment Condition Purchase Description
PaymentConditionSales varchar2 Payment Condition Sales
PeppolIdentifier varchar2 Peppol Identifier
PeppolIdentifierType int32 Peppol Identifier Type
Phone varchar2 Phone
PhoneExtension varchar2 Phone Extension
Postcode varchar2 Postal Code
PriceList guid Price List
PurchaseCurrency varchar2 Purchase Currency
PurchaseCurrencyDescription varchar2 Purchase Currency Description
PurchaseLeadDays int32 Purchase Lead Days
PurchaseVATCode varchar2 Purchase VAT Code
PurchaseVATCodeDescription varchar2 Purchase VAT Code Description
RSIN varchar2 RSIN Number
RecepientOfCommissions char Recipient of Commissions
Remarks varchar2 Remarks
Reseller guid Reseller
SalesCurrency varchar2 Sales Currency
SalesCurrencyDescription varchar2 Sales Currency Description
SalesTaxSchedule guid Sales Tax Schedule
SalesVATCode varchar2 Sales VAT Code
SalesVATCodeDescription varchar2 Sales VAT Code Description
SearchCode varchar2 Search Code
SecurityLevel int32 Security Level
SeparateInvPerProject int16 Separate Invoice per Project
SeparateInvPerSubscription int16 Separate Invoice per Subscription
ShippingLeadDays int32 Shipping Lead Days
ShippingMethod guid Shipping Method
ShowRemarkForSales char Show Remark for Sales Whether to show the remarks.
Source int16 Source
StartDate datetime Start Date
State varchar2 State
StateName varchar2 Province Name
Status varchar2 Status
StatusSince datetime Status Since
Timestamp int64 Timestamp filters on the platform
TradeName varchar2 Tradename
Type varchar2 Type
UniqueTaxpayerReference varchar2 Unique Taxpayer Reference
VATLiability varchar2 VAT Liability
VATNumber varchar2 VAT Number
Website varchar2 Website

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: