# Documents: Exact Online Documents - 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. ## 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 | Documentation | |---|:---:|---|:---:|---| | `Account` | `guid` | Account | ☐ | ID of the related account of this document. | | `AccountCode` | `varchar2`(18) | Account Code | ☐ | Code of Account. | | `AccountName` | `varchar2`(50) | Account Name | ☐ | Name of account. | | `AmountFC` | `double` | Amount Foreign Currency | ☐ | Amount in the currency of the transaction. | | `Body` | `varchar2` | Body | ☐ | Body of this document. | | `Category` | `guid` | Category | ☐ | ID of the category of this document. | | `CategoryDescription` | `varchar2` | Category Description | ☐ | Description of Category. | | `Contact` | `guid` | Contact | ☐ | ID of the related contact of this document. | | `ContactFullName` | `varchar2`(240) | Contact Full Name | ☐ | Contact full name. | | `ContractID` | `guid` | | ☐ | Contract ID. | | `ContractNumber` | `varchar2` | | ☐ | Contract number. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `Currency` | `varchar2`(30) | Currency | ☐ | Currency code. | | `Division` | `int32` | Division | ☑ | Division code. | | `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. | | `DocumentDate` | `datetime` | Document Date | ☐ | Entry date of the incoming document. | | `DocumentFolder` | `guid` | Document Folder | ☐ | The Id of document folder. | | `DocumentFolderCode` | `varchar2` | | ☐ | The Code of document folder. | | `DocumentFolderDescription` | `varchar2` | | ☐ | The Decsription of document folder. | | `DocumentViewUrl` | `varchar2` | Document View URL | ☐ | Url to view the document. | | `ExpiryDate` | `datetime` | Expiry Date | ☐ | Expiry date of this document. | | `FinancialTransactionEntryID` | `guid` | | ☐ | Reference to the transaction lines that make up the financial entry. | | `HasEmptyBody` | `char` | Has Empty Body | ☑ | Indicates that the document body is empty. | | `HID` | `int32` | HID | ☐ | Human-readable ID, formatted as xx.xxx.xxx. Unique. May not be equal to zero. | | `ID` | `guid` | ID | ☑ | Primary key. | | `InheritShare` | `char` | Inherit Share | ☑ | | | `Item` | `guid` | Item | ☐ | | | `ItemCode` | `varchar2` | Item Code | ☐ | | | `ItemDescription` | `varchar2` | Item Description | ☐ | | | `Language` | `varchar2`(30) | Language | ☐ | The language code of the document. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. | | `Opportunity` | `guid` | Opportunity | ☐ | The opportunity linked to the document. | | `Project` | `guid` | Project | ☐ | The project linked to the document. | | `ProjectCode` | `varchar2`(20) | Project Code | ☐ | Code of project. | | `ProjectDescription` | `varchar2`(60) | Project Description | ☐ | Description of project. | | `ProposedEntryStatus` | `int16` | Proposed Entry Status | ☐ | | | `SalesInvoiceNumber` | `int32` | Sales Invoice Number | ☐ | 'Our reference' of the transaction that belongs to this document. | | `SalesOrderNumber` | `int32` | Sales Order Number | ☐ | Number of the sales order. | | `ScanServiceStatus` | `int16` | | ☐ | | | `SendMethod` | `int32` | Send Method | ☐ | Send method. | | `ShopOrderNumber` | `int32` | Shop Order Number | ☐ | Number of the shop order. | | `Subject` | `varchar2`(256) | Subject | ☐ | Subject of this document. | | `TeamsMeetingId` | `varchar2` | | ☐ | | | `Type` | `int32` | Type | ☐ | ID of the type of this document. | | `TypeDescription` | `varchar2`(240) | Type Description | ☐ | Description of Type. |