# SyncAccounts: Exact Online Accounts - Catalog: `ExactOnlineREST` - Schema: `Sync` - Primary Keys: `Timestamp` - Label: Accounts The data in this table is partitioned per value of the `Division` column. This is a read-only table. 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. ## Table Columns The columns of the table `SyncAccounts` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Accountant` | `guid` | Accountant | ☐ | | | `AccountManager` | `guid` | Account Manager | ☐ | | | `AccountManagerFullName` | `varchar2` | Account Manager Full Name | ☐ | | | `AccountManagerHID` | `int32` | Account Manager HID | ☐ | | | `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 | ☐ | | | `Blocked` | `char` | Blocked | ☐ | | | `BRIN` | `guid` | BRIN | ☐ | | | `BSN` | `varchar2` | Social Security Number | ☐ | | | `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 | ☐ | | | `Costcenter` | `varchar2` | Cost Centre | ☐ | | | `CostPaid` | `int16` | Cost Paid | ☑ | | | `Country` | `varchar2` | Country | ☐ | | | `CountryName` | `varchar2` | Country Name | ☐ | | | `Created` | `datetime` | Created | ☐ | | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | 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 | ☐ | | | `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 | ☑ | | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online 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 | ☐ | | | `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) | ☐ | 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 | ☐ | | | `RecepientOfCommissions` | `char` | Recipient of Commissions | ☐ | | | `Remarks` | `varchar2` | Remarks | ☐ | | | `Reseller` | `guid` | Reseller | ☐ | | | `RSIN` | `varchar2` | RSIN Number | ☐ | | | `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 | ☑ | | | `TradeName` | `varchar2` | Tradename | ☐ | | | `Type` | `varchar2` | Type | ☐ | | | `UniqueTaxpayerReference` | `varchar2` | Unique Taxpayer Reference | ☐ | | | `VATLiability` | `varchar2` | VAT Liability | ☐ | | | `VATNumber` | `varchar2` | VAT Number | ☐ | | | `Website` | `varchar2` | Website | ☐ | |