# AccountsIncremental: Exact Online Accounts (Incremental) - Catalog: `ExactOnlineREST` - Schema: `Incremental` - Primary Keys: `ID` - Label: Accounts (Incremental) The data in this table is partitioned per value of the `Division` column. This is a read-only view. The Exact Online API may not support changing the data or the Invantive UniversalSQL driver for Exact Online does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Exact Online API. ## View Columns The columns of the view `AccountsIncremental` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Accountant` | `guid` | Accountant | ☐ | | | `AccountManager` | `guid` | Account Manager | ☐ | | | `AccountManagerHID` | `int32` | Account Manager HID | ☐ | | | `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 | ☐ | | | `Blocked` | `char` | Blocked | ☐ | | | `BRIN` | `guid` | BRIN | ☐ | | | `BSN` | `varchar2` | Social Security Number | ☐ | | | `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 | ☐ | | | `Costcenter` | `varchar2` | Cost Centre | ☐ | | | `CostPaid` | `int16` | Cost Paid | ☑ | | | `Country` | `varchar2` | Country | ☐ | | | `Created` | `datetime` | Created | ☐ | | | `Creator` | `guid` | Creator | ☐ | | | `CreditLinePurchase` | `double` | Credit Line for Purchase | ☐ | | | `CreditLineSales` | `double` | Credit Line for Sales | ☐ | | | `Currency` | `varchar2` | Currency | ☐ | | | `CustomerSince` | `datetime` | Customer Since | ☐ | | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `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 | ☐ | | | `Email` | `varchar2` | Email | ☐ | | | `EnableSalesPaymentLink` | `char` | Enable Sales Payment Link | ☐ | | | `EndDate` | `datetime` | End Date | ☐ | | | `EORINumber` | `varchar2` | EORI Number | ☐ | | | `EstablishedDate` | `datetime` | Established Date | ☐ | | | `Fax` | `varchar2` | Fax | ☐ | | | `GLAccountPurchase` | `guid` | GL Account for Purchase | ☐ | | | `GLAccountSales` | `guid` | GL Account for Sales | ☐ | | | `GLAP` | `guid` | Accounts Payables General Ledger | ☐ | | | `GLAR` | `guid` | Accounts Receivables General Ledger | ☐ | | | `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 | ☐ | | | `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 | ☐ | | | `RecepientOfCommissions` | `char` | Recipient of Commissions | ☐ | | | `Remarks` | `varchar2` | Remarks | ☐ | | | `Reseller` | `guid` | Reseller | ☐ | | | `RSIN` | `varchar2` | RSIN Number | ☐ | | | `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 | ☐ | |