invantive documentation
Invantive Support ForumsLog In / Sign Up

AccountsIncremental: Exact Online Accounts (Incremental)

popular read only per partition

  • Catalog: ExactOnlineREST
  • Schema: Incremental
  • Primary Keys: ID
  • Label: Accounts (Incremental)

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

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 426
Full scan rows per minute 12,900
Point query rows per minute 138

The result can be cached on the client.

Table Columns

The columns of the table AccountsIncremental 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
AccountManagerHID int32 Account Manager HID
Accountant guid Accountant
ActivitySector guid Activity Sector
ActivitySubSector guid Activity Subsector
AddressLine1 varchar2 Address Line 1
AddressLine2 varchar2 Address Line 2
AddressLine3 varchar2 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 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
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
Created datetime Created
Creator guid Creator
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
Document guid Document
DunsNumber varchar2 DUNS Number
EORINumber varchar2 EORI Number
Email varchar2 Email
EnableSalesPaymentLink char Enable Sales Payment Link filters on the platform, writable
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 filters on the platform
IncotermAddressSales varchar2 Incoterm Address Sales filters on the platform
IncotermCodePurchase varchar2 Incoterm Code Purchase filters on the platform
IncotermCodeSales varchar2 Incoterm Code Sales filters on the platform
IncotermVersionPurchase int16 Incoterm Version Purchase filters on the platform
IncotermVersionSales int16 Incoterm Version Sales filters on the platform
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
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
Modifier guid Modifier
Name varchar2 Name
OINNumber varchar2 OIN Number
Parent guid Parent
PayAsYouEarn varchar2 Pay-as-you-Earn
PaymentConditionPurchase varchar2 Payment Condition Purchase
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
PurchaseLeadDays int32 Purchase Lead Days
PurchaseVATCode varchar2 Purchase VAT Code
RSIN varchar2 RSIN Number
RecepientOfCommissions char Recipient of Commissions
Remarks varchar2 Remarks
Reseller guid Reseller
SalesCurrency varchar2 Sales Currency
SalesTaxSchedule guid Sales Tax Schedule
SalesVATCode varchar2 Sales VAT Code
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
Status varchar2 Status
StatusSince datetime Status Since
Timestamp int64 Timestamp
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: