Exact Online API Data Model
Operations: Exact Online Operations |
Catalog: ExactOnlineREST
Schema: Manufacturing
Primary Keys: ID
Label: Operations
The data in this table is partitioned per value of the Division column.
Can retrieve data and change data using insert, update and delete.
Select Exact Online API URL: /api/v1/{division}/manufacturing/Operations
Insert Exact Online API URL: /api/v1/{division}/manufacturing/Operations
Update Exact Online API URL: /api/v1/{division}/manufacturing/Operations
Delete Exact Online API URL: /api/v1/{division}/manufacturing/Operations
Exact Online API Metadata URL: /api/v1/{division}/manufacturing/$metadata
Field Selection Method: Required
Table Columns
The columns of the table Operations 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 or update.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
Code |
string |
Code |
☑ |
Code of the operation. |
Created |
datetime |
Created |
☐ |
Creation date. |
CreatedUtc |
datetime |
Created (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Creator |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Creator Full Name |
☐ |
Name of creator. |
Description |
string |
Description |
☐ |
Description of the operation. |
Division |
int32 |
Division |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(20) |
Division Chamber of Commerce Number |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Division IBAN Number |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Division Company Name |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Division RSIN Number |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Division VAT Number |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Division Wage Tax Number |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Division Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administration Name |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Subscription Holder Name |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(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. |
HasSuppliers |
int16 |
|
☐ |
Indicates if the operation has suppliers associated with it. |
ID |
guid |
ID |
☑ |
Primary key. |
Item |
guid |
Item |
☐ |
Reference to Items table. |
ItemDescription |
string(60) |
Item Description |
☐ |
Description of Item. |
Modified |
datetime |
Modified |
☐ |
Last modified date. |
ModifiedUtc |
datetime |
Modified (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Modifier |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Modified Full Name |
☐ |
Name of modifier. |
Notes |
string |
Notes |
☐ |
Extra remarks. |
Searchcode |
string(15) |
Search Code |
☐ |
Search code for the operation. |
Status |
int32 |
Status |
☐ |
Status of the operation. |
15-06-2022 19:32 Version 22.0.232-PROD+3445
