Exact Online API Data Model
Workcenters: Exact Online Workcenter |
Catalog: ExactOnlineREST
Schema: Manufacturing
Primary Keys: ID
Label: Workcenter
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/Workcenters
Insert Exact Online API URL: /api/v1/{division}/manufacturing/Workcenters
Update Exact Online API URL: /api/v1/{division}/manufacturing/Workcenters
Delete Exact Online API URL: /api/v1/{division}/manufacturing/Workcenters
Exact Online API Metadata URL: /api/v1/{division}/manufacturing/$metadata
Field Selection Method: Required
Table Columns
The columns of the table Workcenters 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 |
|---|---|---|---|---|
Capacity |
int32 |
|
☐ |
Capacity of the work center. |
Code |
string |
Code |
☑ |
Code of the work center. |
Costcenter |
string(8) |
Cost Center |
☐ |
Reference to CostCenters. |
CostcenterDescription |
string(60) |
Cost Center Description |
☐ |
Description of Costcenter. |
Costunit |
string(8) |
Cost Unit |
☐ |
Reference to CostUnits. |
CostunitDescription |
string(60) |
Cost Unit Description |
☐ |
Description of Costunit. |
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 work center. |
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. |
GeneralBurdenRate |
double |
|
☐ |
General burden rate. |
ID |
guid |
ID |
☑ |
Primary key. |
IsLaborBurdenPercent |
int16 |
|
☑ |
Indicates if labor burden is calculated as a percentage or amount. |
LaborBurdenRate |
double |
|
☐ |
Labor burden rate. |
MachineBurdenRate |
double |
|
☐ |
Machine burden rate. |
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 |
☐ |
Remarks. |
ProductionArea |
guid |
Production Area |
☐ |
Area to which the work center belongs. |
RunLaborRate |
double |
|
☐ |
Run labor rate. |
SearchCode |
string(15) |
Search Code |
☐ |
Search code of the work center. |
SetupLaborRate |
double |
|
☐ |
Setup labor rate. |
Status |
int32 |
Status |
☐ |
Reference to WorkcenterStatus. |
Type |
int32 |
Type |
☐ |
Reference to WorkcenterTypes. |
15-06-2022 19:32 Version 22.0.232-PROD+3445
