# AccountsBulk: Exact Online Accounts Legal counter parties such as customers, suppliers and prospects. ## Documentation: Each counter party is registered at most once as an account. Their type can be determined using a number of methods:chr(13) || chr(10) || chr(13) || chr(10)- Customer: the column 'Status' has the value 'C' when the account is a customer. The meaning of the status codes is described in the table 'AccountCustomerStatuses'.chr(13) || chr(10) || chr(13) || chr(10)- Prospect: the column 'Status' has the value 'P' when the account is a prospect.chr(13) || chr(10) || chr(13) || chr(10)- Suspect: the column 'Status' has the value 'S' when the account is a suspect.chr(13) || chr(10) || chr(13) || chr(10)- Reseller: the column 'IsReseller' has the boolean value 'true'.chr(13) || chr(10) || chr(13) || chr(10)- Supplier: the column 'IsSupplier' has the boolean value 'true'.chr(13) || chr(10) || chr(13) || chr(10)- Accountant: the column 'IsAccountant' has the boolean value 'true'.chr(13) || chr(10) || chr(13) || chr(10)- Competitor: the column 'IsCompetitor' has the boolean value 'true'. - Catalog: `ExactOnlineREST` - Schema: `CRM` - Primary Keys: `ID` - 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 `AccountsBulk` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Accountant` | `guid` | Accountant | ☐ | Reference to the accountant of the customer. Conditions: The referred accountant must have value > 0 in the field IsAccountant. | | `AccountManager` | `guid` | Account Manager | ☐ | ID of the account manager. | | `AccountManagerFullName` | `varchar2` | Account Manager Full Name | ☐ | Name of the account manager. | | `AccountManagerHID` | `int32` | Account Manager HID | ☐ | Number of the account manager. | | `ActivitySector` | `guid` | Activity Sector | ☐ | Reference to Activity sector of the account. | | `ActivitySubSector` | `guid` | Activity Subsector | ☐ | Reference to Activity sub-sector of the account. | | `AddressLine1` | `varchar2`(80) | Address Line 1 | ☐ | Visit address first line. | | `AddressLine2` | `varchar2`(80) | Address Line 2 | ☐ | Visit address second line. | | `AddressLine3` | `varchar2`(80) | Address Line 3 | ☐ | Visit address third line. | | `AddressSource` | `int16` | Address Source | ☐ | | | `AutomaticProcessProposedEntry` | `int16` | Automatic Process Proposed Entry | ☐ | | | `Blocked` | `char` | Blocked | ☐ | Indicates if the account is blocked. | | `BRIN` | `guid` | BRIN | ☐ | Obsolete. | | `BSN` | `varchar2` | Social Security Number | ☐ | Citizen Service Number for the Netherlands. | | `BusinessType` | `guid` | Business Type | ☐ | Reference to the business type of the account. | | `CanDropShip` | `char` | Can Drop Ship | ☐ | Indicates the default for the possibility to drop ship when an item is linked to a supplier. | | `ChamberOfCommerce` | `varchar2`(60) | Chamber of Commerce | ☐ | Chamber of commerce number. | | `City` | `varchar2` | City | ☐ | Visit address City. | | `Classification` | `varchar2` | Classification | ☐ | Obsolete. | | `Classification1` | `guid` | Classification 1 | ☐ | Account classification 1. | | `Classification1Code` | `varchar2` | Classification 1 Code | ☐ | Code of classification 1. See view Classifications. | | `Classification1Description` | `varchar2` | Classification 1 Description | ☐ | Description of classification 1. See view Classifications. | | `Classification2` | `guid` | Classification 2 | ☐ | Account classification 2. | | `Classification2Code` | `varchar2` | Classification 2 Code | ☐ | Code of classification 2. See view Classifications. | | `Classification2Description` | `varchar2` | Classification 2 Description | ☐ | Description of classification 2. See view Classifications. | | `Classification3` | `guid` | Classification 3 | ☐ | Account classification 3. | | `Classification3Code` | `varchar2` | Classification 3 Code | ☐ | Code of classification 3. See view Classifications. | | `Classification3Description` | `varchar2` | Classification 3 Description | ☐ | Description of classification 3. See view Classifications. | | `Classification4` | `guid` | Classification 4 | ☐ | Account classification 4. | | `Classification4Code` | `varchar2` | Classification 4 Code | ☐ | Code of classification 4. See view Classifications. | | `Classification4Description` | `varchar2` | Classification 4 Description | ☐ | Description of classification 4. See view Classifications. | | `Classification5` | `guid` | Classification 5 | ☐ | Account classification 5. | | `Classification5Code` | `varchar2` | Classification 5 Code | ☐ | Code of classification 5. See view Classifications. | | `Classification5Description` | `varchar2` | Classification 5 Description | ☐ | Description of classification 5. See view Classifications. | | `Classification6` | `guid` | Classification 6 | ☐ | Account classification 6. | | `Classification6Code` | `varchar2` | Classification 6 Code | ☐ | Code of classification 6. See view Classifications. | | `Classification6Description` | `varchar2` | Classification 6 Description | ☐ | Description of classification 6. See view Classifications. | | `Classification7` | `guid` | Classification 7 | ☐ | Account classification 7. | | `Classification7Code` | `varchar2` | Classification 7 Code | ☐ | Code of classification 7. See view Classifications. | | `Classification7Description` | `varchar2` | Classification 7 Description | ☐ | Description of classification 7. See view Classifications. | | `Classification8` | `guid` | Classification 8 | ☐ | Account classification 8. | | `Classification8Code` | `varchar2` | Classification 8 Code | ☐ | Code of classification 8. See view Classifications. | | `Classification8Description` | `varchar2` | Classification 8 Description | ☐ | Description of classification 8. See view Classifications. | | `ClassificationDescription` | `varchar2` | Classification Description | ☐ | Obsolete. | | `Code` | `varchar2` | Code | ☐ | Unique key, fixed length numeric string with leading spaces, length 18. IMPORTANT: When you use OData $filter on this field you have to make sure the filter parameter contains the leading spaces. | | `CodeAtSupplier` | `varchar2` | Code at Supplier | ☐ | Code under which your own company is known at the account. | | `CompanySize` | `guid` | Company Size | ☐ | Reference to Company size of the account. | | `ConsolidationScenario` | `int16` | Consolidation Scenario | ☐ | Consolidation scenario (Time & Billing). Values: 0 = No consolidation, 1 = Item, 2 = Item + Project, 3 = Item + Employee, 4 = Item + Employee + Project, 5 = Project + WBS + Item, 6 = Project + WBS + Item + Employee. Item means in this case including Unit and Price, these also have to be the same to consolidate. | | `ControlledDate` | `datetime` | Date Checked | ☐ | Date of the latest control of account data with external web service. | | `Costcenter` | `varchar2` | Cost Centre | ☐ | Obsolete. | | `CostcenterDescription` | `varchar2` | Cost Centre Description | ☐ | Obsolete. | | `CostPaid` | `int16` | Cost Paid | ☐ | Obsolete. | | `Country` | `varchar2` | Country | ☐ | Country code. | | `CountryName` | `varchar2` | Country Name | ☐ | Country name. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2` | Creator Full Name | ☐ | Name of creator. | | `CreditLinePurchase` | `double` | Credit Line for Purchase | ☐ | Maximum amount of credit for Purchase. If no value has been defined, there is no credit limit. | | `CreditLineSales` | `double` | Credit Line for Sales | ☐ | Maximum amount of credit for sales. If no value has been defined, there is no credit limit. | | `Currency` | `varchar2` | Currency | ☐ | Obsolete. | | `CustomerSince` | `datetime` | Customer Since | ☐ | Obsolete. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `DatevCreditorCode` | `varchar2` | DATEV Creditor Code | ☐ | DATEV creditor code for Germany legislation. | | `DatevDebtorCode` | `varchar2` | DATEV Debtor Code | ☐ | DATEV debtor code for Germany legislation. | | `DeliveryAdvice` | `int16` | Delivery Advice | ☐ | | | `DiscountPurchase` | `double` | Discount for Purchase | ☐ | Default discount percentage for purchase. This is stored as a fraction. ie 5.5% is stored as .055. | | `DiscountSales` | `double` | Discount for Sales | ☐ | Default discount percentage for sales. This is stored as a fraction. ie 5.5% is stored as .055. | | `Division` | `int32` | Division ID | ☑ | Unique number of the Exact Online 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 | ☐ | Obsolete. | | `DunsNumber` | `varchar2` | DUNS Number | ☐ | Obsolete. | | `Email` | `varchar2` | Email | ☐ | E-Mail address of the account. | | `EnableSalesPaymentLink` | `char` | Enable Sales Payment Link | ☐ | | | `EndDate` | `datetime` | End Date | ☐ | Determines in combination with the start date if the account is active. If the current date is > end date the account is inactive. | | `EORINumber` | `varchar2` | EORI Number | ☐ | EORI number (United Kingdom). | | `EstablishedDate` | `datetime` | Established Date | ☐ | RegistrationDate. | | `Fax` | `varchar2` | Fax | ☐ | Fax number. | | `GLAccountPurchase` | `guid` | GL Account for Purchase | ☐ | Default (corporate) GL offset account for purchase (cost). | | `GLAccountSales` | `guid` | GL Account for Sales | ☐ | Default (corporate) GL offset account for sales (revenue). | | `GLAP` | `guid` | Accounts Payables General Ledger | ☐ | Default GL account for Accounts Payable. | | `GLAR` | `guid` | Accounts Receivables General Ledger | ☐ | Default GL account for Accounts Receivable. | | `GlnNumber` | `varchar2` | GLN Number | ☐ | Global Location Number can be used by companies to identify their locations, giving them complete flexibility to identify any type or level of location required. | | `HasWithholdingTaxSales` | `char` | Has Withholding Tax Sales | ☐ | Indicates whether a customer has withholding tax on sales. | | `ID` | `guid` | ID | ☑ | Primary key. | | `IgnoreDatevWarningMessage` | `char` | Ignore DATEV Warning Message | ☑ | Suppressed warning message when there is duplication on the DATEV code. | | `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 | ☐ | Intrastat Area. | | `IntraStatDeliveryTerm` | `varchar2` | Intrastat Delivery Term | ☐ | Intrastat delivery method. | | `IntraStatSystem` | `varchar2` | Intrastat System | ☐ | System for Intrastat. | | `IntraStatTransactionA` | `varchar2` | Intrastat Transaction A | ☐ | Transaction type A for Intrastat. | | `IntraStatTransactionB` | `varchar2` | Intrastat Transaction B | ☐ | Transaction type B for Intrastat. | | `IntraStatTransportMethod` | `varchar2` | Intrastat Transport Method | ☐ | Transport method for Intrastat. | | `InvoiceAccount` | `guid` | Invoice Account | ☐ | ID of account to be invoiced instead of this account. | | `InvoiceAccountCode` | `varchar2` | Invoice Account Code | ☐ | Code of InvoiceAccount. | | `InvoiceAccountName` | `varchar2` | Invoice Account Name | ☐ | Name of InvoiceAccount. | | `InvoiceAttachmentType` | `int32` | Invoice Attachment Type | ☐ | Indicates which attachment types should be sent when a sales invoice is printed. Only values in related table with Invoice=1 are allowed. | | `InvoicingMethod` | `int32` | Invoicing Method | ☐ | Method of sending for sales invoices. Values: 1: Paper, 2: EMail, 4: Mailbox (electronic exchange). | | `IsAccountant` | `int16` | Is Accountant | ☑ | Indicates whether the account is an accountant. Values: 0 = No accountant, 1 = True, but accountant doesn't want his name to be published in the list of accountants, 2 = True, and accountant is published in the list of accountants. | | `IsAgency` | `int16` | Is Agency | ☑ | Indicates whether the accounti is an agency. | | `IsAnonymised` | `int16` | Is Anonymised | ☑ | Indicates whtether the account is anonymised. | | `IsBank` | `char` | Is Bank | ☐ | Obsolete. | | `IsCompetitor` | `int16` | Is Competitor | ☑ | Indicates whether the account is a competitor. | | `IsExtraDuty` | `char` | Is Extra Duty | ☐ | Indicates whether a customer is eligible for extra duty. | | `IsMailing` | `int16` | Is Mailing | ☑ | Indicates if the account is excluded from mailing marketing information. | | `IsMember` | `char` | Is Member | ☐ | Obsolete. | | `IsPilot` | `char` | Is Pilot | ☐ | Indicates whether the account is a pilot account. | | `IsPurchase` | `char` | Is Purchase | ☐ | Obsolete. | | `IsReseller` | `char` | Is Reseller | ☐ | Indicates whether the account is a reseller. | | `IsSales` | `char` | Is Sales | ☐ | Indicates whether the account is allowed for sales. | | `IsSupplier` | `char` | Is Supplier | ☐ | Indicates whether the account is a supplier. | | `Language` | `varchar2` | Language | ☐ | Language code. | | `LanguageDescription` | `varchar2` | Language Description | ☐ | Language description. | | `Latitude` | `double` | Latitude | ☐ | Latitude (used by Google maps). | | `LeadPurpose` | `guid` | Lead Purpose | ☐ | Reference to Lead purpose of an account. | | `LeadSource` | `guid` | Lead Source | ☐ | Reference to Lead source of an account. | | `Logo` | `blob` | Logo | ☐ | Bytes of the logo image. | | `LogoFileName` | `varchar2` | Logo File Name | ☐ | The file name (without path, but with extension) of the image. | | `LogoThumbnailUrl` | `varchar2` | Logo Thumbnail (URL) | ☐ | Thumbnail url of the logo. | | `LogoUrl` | `varchar2` | Logo (URL) | ☐ | Url to retrieve the logo. | | `Longitude` | `double` | Longitude | ☐ | Longitude (used by Google maps). | | `MainContact` | `guid` | Main Contact | ☐ | Reference to main contact person. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2` | Modified Full Name | ☐ | Name of modifier. | | `Name` | `varchar2` | Name | ☐ | Account name. | | `OINNumber` | `varchar2` | OIN Number | ☐ | Dutch government identification number. | | `Parent` | `guid` | Parent | ☐ | ID of the parent account. | | `PayAsYouEarn` | `varchar2` | Pay-as-you-Earn | ☐ | Indicates the loan repayment plan for UK legislation. | | `PaymentConditionPurchase` | `varchar2` | Payment Condition Purchase | ☐ | Code of default payment condition for purchase. | | `PaymentConditionPurchaseDescription` | `varchar2` | Payment Condition Purchase Description | ☐ | Description of PaymentConditionPurchase. | | `PaymentConditionSales` | `varchar2` | Payment Condition Sales | ☐ | Code of default payment condition for sales. | | `PaymentConditionSalesDescription` | `varchar2` | Payment Condition Sales Description | ☐ | Description of PaymentConditionSales. | | `PeppolIdentifier` | `varchar2` | Peppol Identifier | ☐ | | | `PeppolIdentifierType` | `int32` | Peppol Identifier Type | ☐ | | | `Phone` | `varchar2` | Phone | ☐ | Phone number. | | `PhoneExtension` | `varchar2` | Phone Extension | ☐ | Phone number extention. | | `Postcode` | `varchar2` | Postal Code | ☐ | Visit address postcode. | | `PriceList` | `guid` | Price List | ☐ | Default sales price list for account. | | `PurchaseCurrency` | `varchar2` | Purchase Currency | ☐ | Currency of purchase. | | `PurchaseCurrencyDescription` | `varchar2` | Purchase Currency Description | ☐ | Description of PurchaseCurrency. | | `PurchaseLeadDays` | `int32` | Purchase Lead Days | ☐ | Indicates number of days required to receive a purchase. Acts as a default. | | `PurchaseVATCode` | `varchar2` | Purchase VAT Code | ☐ | Default VAT code used for purchase entries. | | `PurchaseVATCodeDescription` | `varchar2` | Purchase VAT Code Description | ☐ | Description of PurchaseVATCode. | | `RecepientOfCommissions` | `char` | Recipient of Commissions | ☐ | Define the relation that should be taken in the official document of the rewarding fiscal fiches Belcotax. | | `Remarks` | `varchar2` | Remarks | ☐ | Remarks. | | `Reseller` | `guid` | Reseller | ☐ | ID of the reseller account. Conditions: the target account must have the property IsReseller turned on. | | `ResellerCode` | `varchar2` | Reseller Code | ☐ | Code of Reseller. | | `ResellerName` | `varchar2` | Reseller Name | ☐ | Name of Reseller. | | `RSIN` | `varchar2` | RSIN Number | ☐ | Fiscal number for NL legislation. | | `SalesCurrency` | `varchar2` | Sales Currency | ☐ | Currency of Sales used for Time & Billing. | | `SalesCurrencyDescription` | `varchar2` | Sales Currency Description | ☐ | Description of SalesCurrency. | | `SalesTaxSchedule` | `guid` | Sales Tax Schedule | ☐ | Obsolete. | | `SalesTaxScheduleCode` | `varchar2` | Sales Tax Schedule Code | ☐ | Obsolete. | | `SalesTaxScheduleDescription` | `varchar2` | Sales Tax Schedule Description | ☐ | Obsolete. | | `SalesVATCode` | `varchar2` | Sales VAT Code | ☐ | Default VAT code for a sales entry. | | `SalesVATCodeDescription` | `varchar2` | Sales VAT Code Description | ☐ | Description of SalesVATCode. | | `SearchCode` | `varchar2` | Search Code | ☐ | Search code. | | `SecurityLevel` | `int32` | Security Level | ☐ | Security level (0 - 100). | | `SeparateInvPerProject` | `int16` | Separate Invoice per Project | ☑ | Separate invoice per project (Time & Billing). | | `SeparateInvPerSubscription` | `int16` | Separate Invoice per Subscription | ☑ | Indicates how invoices are generated from subscriptions. 0 = subscriptions belonging to the same customer are combined in a single invoice. 1 = each subscription results in one invoice. In both cases, each individual subscription line results in one invoice line. | | `ShippingLeadDays` | `int32` | Shipping Lead Days | ☐ | Indicates the number of days it takes to send goods to the customer. Acts as a default. | | `ShippingMethod` | `guid` | Shipping Method | ☐ | Default shipping method. | | `ShowRemarkForSales` | `char` | Show Remark for Sales | ☐ | Indicates whether to display Ordered by account's remarks when creating a new sales order. | | `Source` | `int16` | Source | ☐ | | | `StartDate` | `datetime` | Start Date | ☐ | Indicates in combination with the end date if the account is active. | | `State` | `varchar2` | State | ☐ | State/Province/County code When changing the Country and the State is filled, the State must be assigned with a valid value from the selected country or set to empty. | | `StateName` | `varchar2` | Province Name | ☐ | Name of State. | | `Status` | `varchar2` | Status | ☐ | If the status field is filled this means the account is a customer. The value indicates the customer status. Possible values: A=None, S=Suspect, P=Prospect, C=Customer. | | `StatusSince` | `datetime` | Status Since | ☐ | Obsolete. | | `TradeName` | `varchar2` | Tradename | ☐ | Trade name can be registered and shown with the client (for all legislations). | | `Type` | `varchar2` | Type | ☐ | Account type: Values: A = Relation, D = Division. | | `UniqueTaxpayerReference` | `varchar2` | Unique Taxpayer Reference | ☐ | Unique taxpayer reference for UK legislation. | | `VATLiability` | `varchar2` | VAT Liability | ☐ | Indicates the VAT status of an account to be able to identify the relation that should be selected in the VAT debtor listing in Belgium. | | `VATNumber` | `varchar2` | VAT Number | ☐ | The number under which the account is known at the Value Added Tax collection agency. | | `Website` | `varchar2` | Website | ☐ | Website of the account. |