Documents: Exact Online Documents
insert update delete per partition webhook REST
- Catalog:
ExactOnlineREST - Schema:
Documents - Primary Keys:
ID - Label: Documents
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Changes arrive through the webhook topic Documents.
API Source
- Endpoint:
/api/v1/{division}/documents/Documents - Metadata:
/api/v1/{division}/documents/$metadata
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 5 |
| Full scan rows per minute | 7,200 |
| Point query rows per minute | 300 |
| Write rows per minute | 300 |
The result can be cached on the client.
Table Columns
The columns of the table Documents 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 |
|---|---|---|---|---|---|
Account |
guid |
Account | filters on the platform, writable | ID of the related account of this document. | |
Account |
varchar2 |
Account Code | filters on the platform, writable | Code of Account. | |
Account |
varchar2 |
Account Name | filters on the platform, writable | Name of account. | |
Amount |
double |
Amount Foreign Currency | filters on the platform, writable | Amount in the currency of the transaction. | |
Body |
varchar2 |
Body | filters on the platform, writable | Body of this document. | |
Category |
guid |
Category | filters on the platform, writable | ID of the category of this document. | |
Category |
varchar2 |
Category Description | filters on the platform, writable | Description of Category. | |
Contact |
guid |
Contact | filters on the platform, writable | ID of the related contact of this document. | |
Contact |
varchar2 |
Contact Full Name | filters on the platform, writable | Contact full name. | |
Contract |
guid |
itgen_eol_contractid | filters on the platform, writable | Contract ID. | |
Contract |
varchar2 |
itgen_eol_contractnumber | filters on the platform, writable | Contract number. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Created (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Creator Full Name | filters on the platform, writable | Name of creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency code. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Division Chamber of Commerce Number | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Division IBAN Number | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Division Company Name | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Division RSIN Number | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Division VAT Number | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Division Wage Tax Number | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Division Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administration Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Subscription Holder Name | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Subscription Holder Number | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Division Short Name | writable | Short name of the Exact Online division. | |
Document |
datetime |
Document Date | filters on the platform, writable | Entry date of the incoming document. | |
Document |
guid |
Document Folder | filters on the platform, writable | The Id of document folder. | |
Document |
varchar2 |
itgen_eol_documentfoldercode | filters on the platform, writable | The Code of document folder. | |
Document |
varchar2 |
itgen_eol_documentfolderdescription | filters on the platform, writable | The Decsription of document folder. | |
Document |
varchar2 |
Document View URL | writable | Url to view the document. | |
Expiry |
datetime |
Expiry Date | filters on the platform, writable | Expiry date of this document. | |
Financial |
guid |
itgen_eol_financialtransactionentryid | filters on the platform, writable | Reference to the transaction lines that make up the financial entry. | |
HID |
int32 |
HID | filters on the platform, writable | Human-readable ID, formatted as xx.xxx.xxx. Unique. May not be equal to zero. | |
Has |
char |
Has Empty Body | writable | Indicates that the document body is empty. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Inherit |
char |
Inherit Share | filters on the platform, writable | ||
Item |
guid |
Item | filters on the platform, writable | ||
Item |
varchar2 |
Item Code | filters on the platform | ||
Item |
varchar2 |
Item Description | filters on the platform | ||
Language |
varchar2 |
Language | filters on the platform, writable | The language code of the document. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modified (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Modified Full Name | filters on the platform, writable | Name of modifier. | |
Opportunity |
guid |
Opportunity | filters on the platform, writable | The opportunity linked to the document. | |
Project |
guid |
Project | filters on the platform, writable | The project linked to the document. | |
Project |
varchar2 |
Project Code | filters on the platform, writable | Code of project. | |
Project |
varchar2 |
Project Description | filters on the platform, writable | Description of project. | |
Proposed |
int16 |
Proposed Entry Status | filters on the platform, writable | ||
Sales |
int32 |
Sales Invoice Number | filters on the platform, writable | 'Our reference' of the transaction that belongs to this document. | |
Sales |
int32 |
Sales Order Number | filters on the platform, writable | Number of the sales order. | |
Scan |
int16 |
itgen_eol_scanservicestatus | filters on the platform | ||
Send |
int32 |
Send Method | filters on the platform, writable | Send method. | |
Shop |
int32 |
Shop Order Number | filters on the platform, writable | Number of the shop order. | |
Subject |
varchar2 |
Subject | filters on the platform, writable | Subject of this document. | |
Teams |
varchar2 |
itgen_eol_teamsmeetingid | filters on the platform, writable | ||
Type |
int32 |
Type | filters on the platform, writable | ID of the type of this document. | |
Type |
varchar2 |
Type Description | filters on the platform, writable | Description of Type. |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Documents_ |
Account |
Accounts.ID |
Key | |
Documents_ |
Contact |
Contacts.ID |
Key | |
Documents_ |
Contract |
EmploymentContracts.ID |
Key | |
Documents_ |
Creator |
Users. |
Key | |
Documents_ |
Currency |
Currencies.Code |
Key | |
Documents_ |
Document |
DocumentFolders.ID |
Key | |
Documents_ |
Modifier |
Users. |
Key | |
Documents_ |
Opportunity |
Opportunities.ID |
Key | |
Documents_ |
Project |
Projects.ID |
Key |
Referenced By
- CommunicationNotes
Document(Key) - Complaints
Document(Key) - Events
Document(Key) - ServiceRequests
Document(Key) - Tasks
Document(Key) - Contacts
IdentificationDocument(Key) - ContactsBulk
IdentificationDocument(Key) - ContactsRead
IdentificationDocument(Key) - OpportunityContactsRead
IdentificationDocument(Key) - Quotations
Document(Key) - QuotationsBulk
Document(Key) - ImportNotifications
Document(Key) - Payments
Document(Key) - PaymentsBulk
Document(Key) - Receivables
Document(Key) - ReceivablesBulk
Document(Key) - DocumentAttachmentFiles
Document(Key) - DocumentAttachments
Document(Key) - BankEntries
BankStatementDocument(Key) - BankEntryLines
Document(Key) - CashEntryLines
Document(Key) - TransactionLines
Document(Key) - TransactionLinesBulk
Document(Key) - Transactions
Document(Key) - GeneralJournalEntryLines
Document(Key) - ActiveEmployments
ContractDocument(Key) - EmploymentContracts
Document(Key) - PurchaseInvoices
Document(Key) - PurchaseEntries
Document(Key) - GoodsReceipts
Document(Key) - PurchaseOrders
Document(Key) - SalesEntries
Document(Key) - SalesInvoices
Document(Key) - SalesInvoicesBulk
Document(Key) - GoodsDeliveries
Document(Key) - GoodsDeliveriesBulk
Document(Key) - PlannedSalesReturns
Document(Key) - SalesOrders
Document(Key) - SalesOrdersBulk
Document(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: