Accounts: Exact Online Accounts
insert update delete per partition webhook REST
- Catalogue :
ExactOnlineREST - Schéma :
CRM - Clés primaires :
ID - Label: Accounts
Les parties prenantes juridiques, telles que les clients, les fournisseurs et les prospects.
Les données de cette table sont partitionnées en fonction de la valeur de la colonne Division.
Permet de récupérer et de modifier des données à l'aide de insert, update et delete.
Résumé
Chaque contrepartie est enregistrée au maximum une fois en tant que compte. Leur type peut être déterminé à l’aide de plusieurs méthodes :
- 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'.
- Prospect: the column 'Status' has the value 'P' when the account is a prospect.
- Suspect: the column 'Status' has the value 'S' when the account is a suspect.
- Reseller: the column 'IsReseller' has the boolean value 'true'.
- Supplier: the column 'IsSupplier' has the boolean value 'true'.
- Accountant: the column 'IsAccountant' has the boolean value 'true'.
- Competitor: the column 'IsCompetitor' has the boolean value 'true'.
Les modifications sont transmises via le sujet de webhook Accounts.
Source de l'API
- Point de terminaison :
/api/v1/{division}/crm/Accounts - Métadonnées :
/api/v1/{division}/crm/$metadata
Caractéristiques de performance
| Characteristic | Value |
|---|---|
| Latence moyenne d'accès (ms) | 5 |
| Nombre de lignes par minute en mode de balayage complet | 7,200 |
| Nombre de lignes de requêtes ponctuelles par minute | 300 |
| Nombre d'enregistrements écrits par minute | 300 |
Le résultat peut être mis en cache côté client.
Colonnes de table
Les colonnes de la table Accounts sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Account |
guid |
Responsable de comptes | filters on the platform, writable | ID of the account manager. | |
Account |
varchar2 |
Nom complet du chargé de compte | writable | Name of the account manager. | |
Account |
int32 |
Responsable de compte HID | writable | Number of the account manager. | |
Accountant |
guid |
Accountant | filters on the platform, writable | Reference to the accountant of the customer.Conditions: The referred accountant must have value > 0 in the field IsAccountant. | |
Activity |
guid |
Secteur d'activité | writable | Reference to Activity sector of the account. | |
Activity |
guid |
Sous-secteur d'activité | writable | Reference to Activity sub-sector of the account. | |
Address |
varchar2 |
Adresse ligne 1 | filters on the platform, writable | Visit address first line. | |
Address |
varchar2 |
Adresse ligne 2 | filters on the platform, writable | Visit address second line. | |
Address |
varchar2 |
Adresse ligne 3 | filters on the platform, writable | Visit address third line. | |
Address |
int16 |
Source de l'adresse | filters on the platform, writable | ||
Automatic |
int16 |
Saisie automatique proposée par le processus | filters on the platform, writable | ||
BRIN |
guid |
BRIN | filters on the platform, writable | Obsolete. | |
BSN |
varchar2 |
Numéro de sécurité sociale | filters on the platform, writable | Citizen Service Number for the Netherlands. | |
Blocked |
char |
Blocked | filters on the platform, writable | Indicates if the account is blocked. | |
Business |
guid |
Type d'entreprise | writable | Reference to the business type of the account. | |
Can |
char |
Livraison directe possible | writable | Indicates the default for the possibility to drop ship when an item is linked to a supplier. | |
Chamber |
varchar2 |
Chambre de commerce | filters on the platform, writable | Chamber of commerce number. | |
City |
varchar2 |
City | filters on the platform, writable | Visit address City. | |
Classification |
varchar2 |
Classification | filters on the platform, writable | Obsolete. | |
Classification1 |
guid |
Classification 1 | filters on the platform, writable | Account classification 1. | |
Classification1 |
varchar2 |
Code de classification 1 | writable | Code of classification 1.See view Classifications. | |
Classification1 |
varchar2 |
Classification 1 - Description | writable | Description of classification 1.See view Classifications. | |
Classification2 |
guid |
Classification 2 | filters on the platform, writable | Account classification 2. | |
Classification2 |
varchar2 |
Code de classification 2 | writable | Code of classification 2.See view Classifications. | |
Classification2 |
varchar2 |
Classification 2 - Description | writable | Description of classification 2.See view Classifications. | |
Classification3 |
guid |
Classification 3 | filters on the platform, writable | Account classification 3. | |
Classification3 |
varchar2 |
Code de classification 3 | writable | Code of classification 3.See view Classifications. | |
Classification3 |
varchar2 |
Classification 3 - Description | writable | Description of classification 3.See view Classifications. | |
Classification4 |
guid |
Classification 4 | filters on the platform, writable | Account classification 4. | |
Classification4 |
varchar2 |
Code de classification 4 | writable | Code of classification 4.See view Classifications. | |
Classification4 |
varchar2 |
Classification 4 - Description | writable | Description of classification 4.See view Classifications. | |
Classification5 |
guid |
Classification 5 | filters on the platform, writable | Account classification 5. | |
Classification5 |
varchar2 |
Code de classification 5 | writable | Code of classification 5.See view Classifications. | |
Classification5 |
varchar2 |
Classification 5 - Description | writable | Description of classification 5.See view Classifications. | |
Classification6 |
guid |
Classification 6 | filters on the platform, writable | Account classification 6. | |
Classification6 |
varchar2 |
Code de classification 6 | writable | Code of classification 6.See view Classifications. | |
Classification6 |
varchar2 |
Classification 6 - Description | writable | Description of classification 6.See view Classifications. | |
Classification7 |
guid |
Classification 7 | filters on the platform, writable | Account classification 7. | |
Classification7 |
varchar2 |
Code de classification 7 | writable | Code of classification 7.See view Classifications. | |
Classification7 |
varchar2 |
Classification 7 - Description | writable | Description of classification 7.See view Classifications. | |
Classification8 |
guid |
Classification 8 | filters on the platform, writable | Account classification 8. | |
Classification8 |
varchar2 |
Code de classification 8 | writable | Code of classification 8.See view Classifications. | |
Classification8 |
varchar2 |
Classification 8 - Description | writable | Description of classification 8.See view Classifications. | |
Classification |
varchar2 |
Description de la classification | writable | Obsolete. | |
Code |
varchar2 |
Code | filters on the platform, writable | 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. | |
Code |
varchar2 |
Code chez le fournisseur | filters on the platform, writable | Code under which your own company is known at the account. | |
Company |
guid |
Taille de l'entreprise | writable | Reference to Company size of the account. | |
Consolidation |
int16 |
Scénario de consolidation | writable | 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. | |
Controlled |
datetime |
Date de vérification | writable | Date of the latest control of account data with external web service. | |
Cost |
int16 |
Coût payé | writable | Obsolete. | |
Costcenter |
varchar2 |
Centre de coûts | writable | Obsolete. | |
Costcenter |
varchar2 |
Description du centre de coûts | writable | Obsolete. | |
Country |
varchar2 |
Country | filters on the platform, writable | Country code. | |
Country |
varchar2 |
Nom du Pays | writable | Country name. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Créé | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Nom complet de l'auteur | writable | Name of creator. | |
Credit |
double |
Ligne de crédit pour les achats | writable | Maximum amount of credit for Purchase.If no value has been defined, there is no credit limit. | |
Credit |
double |
Ligne de crédit pour les ventes | writable | Maximum amount of credit for sales.If no value has been defined, there is no credit limit. | |
Currency |
varchar2 |
Currency | writable | Obsolete. | |
Custom |
varchar2 |
Champ personnalisé | filters on the platform, writable | ||
Customer |
datetime |
Client depuis | writable | Obsolete. | |
Datev |
varchar2 |
Code créancier DATEV | writable | DATEV creditor code for Germany legislation. | |
Datev |
varchar2 |
Code débiteur DATEV | writable | DATEV debtor code for Germany legislation. | |
Delivery |
int16 |
Informations sur la livraison | filtres disponibles sur la plateforme | ||
Discount |
double |
Remise à l'achat | writable | Default discount percentage for purchase.This is stored as a fraction. ie 5.5% is stored as .055. | |
Discount |
double |
Remise sur les ventes | writable | Default discount percentage for sales.This is stored as a fraction. ie 5.5% is stored as .055. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Numéro d'enregistrement à la Chambre de commerce de la division | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Numéro IBAN de la division | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division - Nom de l'entreprise | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numéro de division RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Numéro de TVA de la division | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Numéro d'identification fiscale de la division | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Étiquette de division | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nom de l'administration | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nom du titulaire de l'abonnement | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numéro d'abonné | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nom abrégé de la division | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | writable | Obsolete. | |
Duns |
varchar2 |
Numéro DUNS | writable | Obsolete. | |
EORI |
varchar2 |
Numéro EORI | writable | EORI number (United Kingdom). | |
Email |
varchar2 |
filters on the platform, writable | E-Mail address of the account. | ||
Enable |
char |
Activer le lien de paiement des ventes | filters on the platform, writable | ||
End |
datetime |
Date de fin | filters on the platform, writable | Determines in combination with the start date if the account is active.If the current date is > end date the account is inactive. | |
Established |
datetime |
Date de création | writable | RegistrationDate. | |
Fax |
varchar2 |
Fax | filters on the platform, writable | Fax number. | |
GLAP |
guid |
Comptabilité fournisseurs - Grand livre général | writable | Default GL account for Accounts Payable. | |
GLAR |
guid |
Comptabilité clients - Grand livre général | writable | Default GL account for Accounts Receivable. | |
GL |
guid |
Compte GL pour les achats | writable | Default (corporate) GL offset account for purchase (cost). | |
GL |
guid |
Compte GL des ventes | writable | Default (corporate) GL offset account for sales (revenue). | |
Gln |
varchar2 |
Numéro GLN | writable | 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. | |
Has |
char |
Ventes soumises à la retenue à la source | writable | Indicates whether a customer has withholding tax on sales. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Ignore |
char |
Ignorer le message d'avertissement DATEV | writable | Suppressed warning message when there is duplication on the DATEV code. | |
Incoterm |
varchar2 |
Incoterm : Adresse d'achat | filters on the platform, writable | ||
Incoterm |
varchar2 |
Incoterm : Adresse de vente | filters on the platform, writable | ||
Incoterm |
varchar2 |
Achat de codes Incoterm | filters on the platform, writable | ||
Incoterm |
varchar2 |
Code Incoterm « Ventes » | filters on the platform, writable | ||
Incoterm |
int16 |
Achat de la version Incoterm | filters on the platform, writable | ||
Incoterm |
int16 |
Ventes selon les Incoterms | filters on the platform, writable | ||
Intra |
varchar2 |
Zone Intrastat | writable | Intrastat Area. | |
Intra |
varchar2 |
Délai de transmission des données Intrastat | writable | Intrastat delivery method. | |
Intra |
varchar2 |
Système Intrastat | writable | System for Intrastat. | |
Intra |
varchar2 |
Transaction Intrastat A | writable | Transaction type A for Intrastat. | |
Intra |
varchar2 |
Transaction Intrastat B | writable | Transaction type B for Intrastat. | |
Intra |
varchar2 |
Mode de transport Intrastat | writable | Transport method for Intrastat. | |
Invoice |
guid |
Compte de facturation | filters on the platform, writable | ID of account to be invoiced instead of this account. | |
Invoice |
varchar2 |
Code de compte de facturation | writable | Code of InvoiceAccount. | |
Invoice |
varchar2 |
Nom du compte de facturation | writable | Name of InvoiceAccount. | |
Invoice |
int32 |
Type de pièce jointe à la facture | writable | Indicates which attachment types should be sent when a sales invoice is printed.Only values in related table with Invoice=1 are allowed. | |
Invoicing |
int32 |
Mode de facturation | writable | Method of sending for sales invoices.Values: 1: Paper, 2: EMail, 4: Mailbox (electronic exchange). | |
Is |
int16 |
est comptable | filters on the platform, writable | 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. | |
Is |
int16 |
Qu'est-ce que l'Agence ? | writable | Indicates whether the accounti is an agency. | |
Is |
int16 |
Est anonymisé | writable | Indicates whether the account is anonymised. | |
IsBank |
char |
Est-ce que la banque | writable | Obsolete. | |
Is |
int16 |
Est-ce un concurrent ? | writable | Indicates whether the account is a competitor. | |
Is |
char |
S'agit-il d'heures supplémentaires ? | writable | Indicates whether a customer is eligible for extra duty. | |
Is |
int16 |
Est-ce que l'envoi postal | writable | Indicates if the account is excluded from mailing marketing information. | |
Is |
char |
Est membre | writable | Obsolete. | |
Is |
char |
Est-ce que c'est Pilot ? | writable | Indicates whether the account is a pilot account. | |
Is |
char |
Est-ce un achat ? | writable | Obsolete. | |
Is |
char |
Est-il revendeur ? | filters on the platform, writable | Indicates whether the account is a reseller. | |
Is |
char |
Est-ce la vente ? | filters on the platform, writable | Indicates whether the account is allowed for sales. | |
Is |
char |
Est-il fournisseur ? | filters on the platform, writable | Indicates whether the account is a supplier. | |
Language |
varchar2 |
Language | writable | Code de langue. | |
Language |
varchar2 |
Description de la langue | writable | Language description. | |
Latitude |
double |
Latitude | writable | Latitude (used by Google maps). | |
Lead |
guid |
Objectif principal | writable | Reference to Lead Purpose of an account. | |
Lead |
guid |
Source Principale | writable | Reference to Lead Source of an account. | |
Logo |
blob |
Logo | writable | Bytes of the logo image. | |
Logo |
varchar2 |
Nom du fichier du logo | writable | The file name (without path, but with extension) of the image. | |
Logo |
varchar2 |
Vignette du logo (URL) | writable | Thumbnail url of the logo. | |
Logo |
varchar2 |
Logo (URL) | writable | Url to retrieve the logo. | |
Longitude |
double |
Longitude | writable | Longitude (used by Google maps). | |
Main |
guid |
Contact principal | filters on the platform, writable | Reference to main contact person. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modifié (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Nom complet modifié | writable | Name of modifier. | |
Name |
varchar2 |
Name | filters on the platform, writable | Account name. | |
OIN |
varchar2 |
Numéro OIN | writable | Dutch government identification number. | |
Parent |
guid |
Parent | filters on the platform, writable | ID of the parent account. | |
Pay |
varchar2 |
Pay-as-you-Earn | writable | Indicates the loan repayment plan for UK legislation. | |
Payment |
varchar2 |
Conditions de paiement - Achat | writable | Code of default payment condition for purchase. | |
Payment |
varchar2 |
Conditions de paiement Description de l'achat | writable | Description of PaymentConditionPurchase. | |
Payment |
varchar2 |
Conditions de paiement - Ventes | writable | Code of default payment condition for sales. | |
Payment |
varchar2 |
Conditions de paiement - Description des ventes | writable | Description of PaymentConditionSales. | |
Peppol |
varchar2 |
Identifiant Peppol | filters on the platform, writable | ||
Peppol |
int32 |
Type d'identifiant Peppol | filters on the platform, writable | ||
Phone |
varchar2 |
Phone | filters on the platform, writable | Numéro de téléphone. | |
Phone |
varchar2 |
Poste téléphonique | writable | Phone number extention. | |
Postcode |
varchar2 |
Code Postale | filters on the platform, writable | Visit address postcode. | |
Price |
guid |
Tarif | filters on the platform, writable | Default sales price list for account. | |
Purchase |
varchar2 |
Devise d'achat | writable | Currency of purchase. | |
Purchase |
varchar2 |
Devise d'achat - Description | writable | Description of purchase currency. | |
Purchase |
int32 |
Jours de prospection commerciale | writable | Indicates number of days required to receive a purchase.Acts as a default. | |
Purchase |
varchar2 |
Code TVA d'achat | writable | Default VAT code used for purchase entries. | |
Purchase |
varchar2 |
Code TVA d'achat - Description | writable | Description of Purchase VAT code. | |
RSIN |
varchar2 |
Numéro RSIN | filters on the platform, writable | Fiscal number for NL legislation. | |
Recepient |
char |
Bénéficiaire de commandes | writable | Define the relation that should be taken in the official document of the rewarding fiscal fiches Belcotax. | |
Remarks |
varchar2 |
Remarks | writable | Remarks. | |
Reseller |
guid |
Reseller | filters on the platform, writable | ID of the reseller account.Conditions: the target account must have the property IsReseller turned on. | |
Reseller |
varchar2 |
Code revendeur | writable | Code of Reseller. | |
Reseller |
varchar2 |
Nom du revendeur | writable | Name of Reseller. | |
Sales |
varchar2 |
Devise de vente | writable | Currency of Sales used for Time & Billing. | |
Sales |
varchar2 |
Devise de vente - Description | writable | Description of SalesCurrency. | |
Sales |
guid |
Barème de la taxe sur les ventes | writable | Obsolete. | |
Sales |
varchar2 |
Code du barème de la taxe sur les ventes | writable | Obsolete. | |
Sales |
varchar2 |
Description du barème de la taxe sur les ventes | writable | Obsolete. | |
Sales |
varchar2 |
Code TVA sur les ventes | writable | Default VAT code for a sales entry. | |
Sales |
varchar2 |
Code TVA des ventes Description | writable | Description of Sales VAT code. | |
Search |
varchar2 |
Code de recherche | filters on the platform, writable | Search code. | |
Security |
int32 |
Niveau de sécurité | writable | Security level (0 - 100). | |
Separate |
int16 |
Une facture distincte par projet | writable | Separate invoice per project (Time & Billing). | |
Separate |
int16 |
Facture distincte par abonnement | writable | 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. | |
Shipping |
int32 |
Délais d'expédition | writable | Indicates the number of days it takes to send goods to the customer.Acts as a default. | |
Shipping |
guid |
Mode d'expédition | writable | Default shipping method. | |
Show |
char |
Afficher la remarque relative aux ventes | writable | Indicates whether to display Ordered by account's remarks when creating a new sales order. | |
Source |
int16 |
Source | filters on the platform, writable | ||
Start |
datetime |
Date de début | filters on the platform, writable | Indicates in combination with the end date if the account is active. | |
State |
varchar2 |
State | writable | 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. | |
State |
varchar2 |
État | writable | Name of state/province. | |
Status |
varchar2 |
Status | filters on the platform, writable | 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. | |
Status |
datetime |
Statut depuis | writable | Obsolete. | |
Trade |
varchar2 |
Tradename | writable | Trade name can be registered and shown with the client (for all legislations). | |
Type |
varchar2 |
Type | filters on the platform, writable | Account type: Values: A = Relation, D = Division. | |
Unique |
varchar2 |
Référence fiscale unique | writable | Unique taxpayer reference for UK legislation. | |
VAT |
varchar2 |
Assujettissement à la TVA | writable | 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. | |
VAT |
varchar2 |
Numéro de TVA | filters on the platform, writable | The number under which the account is known at the Value Added Tax collection agency. | |
Website |
varchar2 |
Website | writable | Website of the account. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
Accounts_ |
Accountant |
Accounts.ID |
Key | |
Accounts_ |
Business |
BusinessTypes.ID |
Key | |
Accounts_ |
Creator |
Users. |
Key | |
Accounts_ |
GLAP |
GLAccounts.ID |
Key | |
Accounts_ |
GLAR |
GLAccounts.ID |
Key | |
Accounts_ |
GL |
GLAccounts.ID |
Key | |
Accounts_ |
GL |
GLAccounts.ID |
Key | |
Accounts_ |
Invoice |
Accounts.ID |
Key | |
Accounts_ |
Lead |
LeadPurposes.ID |
Key | |
Accounts_ |
Lead |
LeadSources.ID |
Key | |
Accounts_ |
Main |
Contacts.ID |
Key | |
Accounts_ |
Modifier |
Users. |
Key | |
Accounts_ |
Parent |
Accounts.ID |
Key | |
Accounts_ |
Price |
SalesPriceLists.ID |
Key | |
Accounts_ |
Reseller |
Accounts.ID |
Key | |
Accounts_ |
Shipping |
ShippingMethods.ID |
Key |
Référencée
- AccountInvolvedAccounts
Account(Key) - AccountInvolvedAccounts
InvolvedAccount(Key) - AccountOwners
Account(Key) - AccountOwners
OwnerAccount(Key) - CenterProfileDetails
Customer(Key) - CenterProfiles
Customer(Key) - ExcludedDivisions
Customer(Key) - InvolvedUsers
Account(Key) - SolutionLinks
Account(Key) - CommunicationNotes
Account(Key) - Complaints
Account(Key) - Events
Account(Key) - Messages
Account(Key) - ServiceRequests
Account(Key) - Tasks
Account(Key) - Assets
InvestmentAccount(Key) - Accounts
Accountant(Key) - Accounts
InvoiceAccount(Key) - Accounts
Parent(Key) - Accounts
Reseller(Key) - AccountsBulk
Accountant(Key) - AccountsBulk
InvoiceAccount(Key) - AccountsBulk
Parent(Key) - AccountsBulk
Reseller(Key) - Addresses
Account(Key) - AddressesBulk
Account(Key) - AddressesRead
Account(Key) - BankAccounts
Account(Key) - BankAccountsBulk
Account(Key) - BankAccountsRead
Account(Key) - Contacts
Account(Key) - ContactsBulk
Account(Key) - ContactsRead
Account(Key) - CrmDocuments
Account(Key) - HostingOpportunities
Account(Key) - HostingOpportunities
Accountant(Key) - HostingOpportunities
Reseller(Key) - HostingOpportunitiesRead
Account(Key) - HostingOpportunitiesRead
Accountant(Key) - HostingOpportunitiesRead
Reseller(Key) - Opportunities
Account(Key) - Opportunities
Accountant(Key) - Opportunities
Reseller(Key) - OpportunitiesRead
Account(Key) - OpportunitiesRead
Accountant(Key) - OpportunitiesRead
Reseller(Key) - OpportunityContactsRead
Account(Key) - Quotations
DeliveryAccount(Key) - Quotations
InvoiceAccount(Key) - Quotations
OrderAccount(Key) - QuotationsBulk
DeliveryAccount(Key) - QuotationsBulk
InvoiceAccount(Key) - QuotationsBulk
OrderAccount(Key) - AllocationRule
Account(Key) - BankLinks
CustomerId(Key) - DirectDebitMandates
Account(Key) - Payments
Account(Key) - PaymentsBulk
Account(Key) - Receivables
Account(Key) - ReceivablesBulk
Account(Key) - Documents
Account(Key) - DocumentsBulk
Account(Key) - PayablesList
AccountId(Key) - ReceivablesList
AccountId(Key) - BankEntryLines
Account(Key) - CashEntryLines
Account(Key) - TransactionLines
Account(Key) - TransactionLinesBulk
Account(Key) - GeneralJournalEntryLines
Account(Key) - DivisionClassValues
Customer(Key) - HrmDivisions
Customer(Key) - CustomerItems
Account(Key) - SalesItemPrices
Account(Key) - SalesItemPricesBulk
Account(Key) - SupplierItems
Supplier(Key) - Mailboxes
Account(Key) - OperationResources
Account(Key) - ShopOrderRoutingStepPlans
Account(Key) - Employees
Customer(Key) - CostTransactions
Account(Key) - CostTransactions
ProjectAccount(Key) - CostTransactions
SubscriptionAccount(Key) - PjtTimeTransactions
Account(Key) - PjtTimeTransactions
ProjectAccount(Key) - PjtTimeTransactions
SubscriptionAccount(Key) - ProjectAccountMutations
Account(Key) - ProjectPlanning
Account(Key) - ProjectPlanningRecurring
Account(Key) - Projects
Account(Key) - RecentCosts
AccountId(Key) - RecentHours
AccountId(Key) - PurchaseInvoices
Supplier(Key) - PurchaseEntries
Supplier(Key) - GoodsReceipts
Supplier(Key) - PurchaseOrders
DeliveryAccount(Key) - PurchaseOrders
Supplier(Key) - SalesEntries
Customer(Key) - SalesInvoices
DeliverTo(Key) - SalesInvoices
InvoiceTo(Key) - SalesInvoices
OrderedBy(Key) - SalesInvoicesBulk
DeliverTo(Key) - SalesInvoicesBulk
InvoiceTo(Key) - SalesInvoicesBulk
OrderedBy(Key) - DigitalOrderPickings
DeliveryAccount(Key) - GoodsDeliveries
DeliveryAccount(Key) - GoodsDeliveriesBulk
DeliveryAccount(Key) - PlannedSalesReturns
DeliveredTo(Key) - SalesOrders
DeliverTo(Key) - SalesOrders
InvoiceTo(Key) - SalesOrders
OrderedBy(Key) - SalesOrdersBulk
DeliverTo(Key) - SalesOrdersBulk
InvoiceTo(Key) - SalesOrdersBulk
OrderedBy(Key) - Subscriptions
InvoiceTo(Key) - Subscriptions
OrderedBy(Key) - GetCurrentDivision
Customer(Key) - GetMostRecentlyUsedDivisions
Customer(Key) - SystemDivisions
Customer(Key) - Users
Customer(Key) - VATCodes
Account(Key) - CustomerCooperations
Account(Key)
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :