ShopOrders: Exact Online Werkorders |
Catalogus: ExactOnlineREST
Schema: Manufacturing
Primaire Sleutels: ID
Label: Werkorders
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Kan gegevens ophalen en wijzigen met behulp van toevoegen, bijwerken en verwijderen.
Tabelkolommen
De kolommen van de tabel ShopOrders worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
CADDrawingURL |
string |
CAD-tekening (URL) |
☐ |
URL to CAD Drawing Specified on Manufacturing Bill of Material. |
Costcenter |
string(8) |
Kostenplaats |
☐ |
The cost center linked to the shop order. |
CostcenterDescription |
string(60) |
Kostenplaats Omschrijving |
☐ |
Description of Costcenter. |
Costunit |
string(8) |
Kostendrager |
☐ |
The cost unit linked to the shop order. |
CostunitDescription |
string(60) |
Kostendrager Omschrijving |
☐ |
Description of Costunit. |
Created |
datetime |
Gemaakt |
☐ |
Creation date. |
CreatedUtc |
datetime |
Aangemaakt (UTC) |
☐ |
Creation date in UTC. |
Creator |
guid |
Aanmaker |
☐ |
User ID of creator. |
CreatorFullName |
string(240) |
Aanmaker Volledige Naam |
☐ |
Name of creator. |
Description |
string |
Omschrijving |
☐ |
Description of the shop order. |
Division |
int32 |
Divisie |
☐ |
Division code. |
DivisionCompanyCoCNumber |
string(60) |
Divisie Kamer van Koophandel Nummer |
☐ |
Chamber of commerce number of the Exact Online division. |
DivisionCompanyIBANNumber |
string(50) |
Divisie IBAN Nummer |
☐ |
IBAN number of the Exact Online division. |
DivisionCompanyName |
string(50) |
Divisie Bedrijfsnaam |
☑ |
Company name of the Exact Online division. |
DivisionCompanyRSINNumber |
string(9) |
Divisie RSIN Nummer |
☐ |
RSIN number of the Exact Online division. |
DivisionCompanyVATNumber |
string(35) |
Divisie BTW Nummer |
☐ |
VAT number of the Exact Online division. |
DivisionCompanyWageTaxNumber |
string(60) |
Divisie Loonbelastingnummer |
☐ |
Wage tax number of the Exact Online division. |
DivisionLabel |
string(128) |
Divisie Label |
☑ |
Label of the Exact Online division. |
DivisionName |
string(50) |
Administratie Naam |
☑ |
Name of the Exact Online division. |
DivisionOwnerCompanyName |
string(50) |
Naam Abonnementhouder |
☑ |
Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionOwnerCompanyNumber |
string(18) |
Abonnementhoudernummer |
☑ |
Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
DivisionShortName |
int64 |
Divisie Korte Naam |
☑ |
Short name of the Exact Online division. |
EntryDate |
datetime |
Boekdatum |
☐ |
Date on which the shop order was placed. |
ID |
guid |
ID |
☑ |
Primary key. |
IsBatch |
int16 |
Is Batch |
☑ |
Does the material plan's item use batch numbers. |
IsFractionAllowedItem |
int16 |
Is Fraction Toegestaan op Artikel |
☑ |
Indicates if fractions (for example 0.35) are allowed for quantities of the material plan's item. |
IsInPlanning |
int16 |
Is in Planning |
☑ |
Indicator that Shop order is in planning. |
IsOnHold |
int16 |
Staat in de Wacht |
☑ |
Indicator if the Shop order is on hold. |
IsReleased |
int16 |
Is Vrijgegeven |
☑ |
Indicator that the Shop order has been released to production. |
IsSerial |
int16 |
Is Serieel |
☑ |
Does the material plan's item use serial numbers. |
Item |
guid |
Artikel |
☐ |
Reference to the item. |
ItemBarcode |
string |
Artikelbarcode |
☐ |
|
ItemCode |
string(30) |
Artikelcode |
☐ |
Code of the item created by this shop order. |
ItemDescription |
string(255) |
Artikelomschrijving |
☐ |
Description of the item created by this shop order. |
ItemPictureUrl |
string |
Artikelafbeelding (URL) |
☐ |
URL of the item created by this shop order. |
ItemVersion |
guid |
Artikelversie |
☐ |
Reference to ItemVersion. |
ItemVersionDescription |
string |
Artikelversie Omschrijving |
☐ |
Description of Item Version. |
Modified |
datetime |
Gewijzigd |
☐ |
Last modified date. |
ModifiedUtc |
datetime |
Gewijzigd (UTC) |
☐ |
Last modified date in UTC. |
Modifier |
guid |
Wijziger |
☐ |
User ID of modifier. |
ModifierFullName |
string(240) |
Gewijzigd Volledige Naam |
☐ |
Name of modifier. |
Notes |
string |
Notities |
☐ |
Notes - only viewed internally. |
PlannedDate |
datetime |
Geplande Datum |
☐ |
Planned end date of this shop order. |
PlannedQuantity |
double |
Geplande Hoeveelheid |
☐ |
Planned quantity. |
PlannedStartDate |
datetime |
Geplande Startdatum |
☐ |
Planned start date of this shop order. |
ProducedQuantity |
double |
Geproduceerd Aantal |
☐ |
Produced quantity. |
ProductionLeadDays |
int32 |
Productie Aanloopdagen |
☑ |
Production lead days. |
Project |
guid |
Project |
☐ |
Reference to Project. |
ProjectDescription |
string(60) |
Projectomschrijving |
☐ |
Description of Project. |
ReadyToShipQuantity |
double |
Klaar voor Verzending Hoeveelheid |
☐ |
Quantity ready to ship. |
SalesOrderLineCount |
int32 |
Aantal Verkooporderregels |
☑ |
Number of sales orders linked to this shop order. |
SelectionCode |
guid |
Selectiecode |
☐ |
ID of Selection code. |
SelectionCodeCode |
string |
Selectiecode |
☐ |
Code of Selection code. |
SelectionCodeDescription |
string |
{res:itgen_eol_selectioncodedescription} |
☐ |
Description of Selection code. |
ShopOrderByProductPlanBackflushCount |
int32 |
{res:itgen_eol_shoporderbyproductplanbackflushcount} |
☑ |
Number of shop order by-product plans, which are backflushed, for this shop order. |
ShopOrderByProductPlanCount |
int32 |
{res:itgen_eol_shoporderbyproductplancount} |
☑ |
Number of shop order by-product plans for this shop order. |
ShopOrderMain |
guid |
Hoofd Productieorder |
☐ |
Shop order main. |
ShopOrderMainNumber |
int32 |
Hoofd Productieordernummer |
☐ |
Shop order main number. |
ShopOrderMaterialPlanBackflushCount |
int32 |
{res:itgen_eol_shopordermaterialplanbackflushcount} |
☑ |
Number of shop order material plans, which are backflushed, for this shop order. |
ShopOrderMaterialPlanCount |
int32 |
{res:itgen_eol_shopordermaterialplancount} |
☑ |
Number of shop order material plans for this shop order. |
ShopOrderMaterialPlansNonIssuedByproductsCount |
int32 |
{res:itgen_eol_shopordermaterialplansnonissuedbyproductscount} |
☑ |
|
ShopOrderMaterialPlansNonIssuedMaterialsCount |
int32 |
{res:itgen_eol_shopordermaterialplansnonissuedmaterialscount} |
☑ |
|
ShopOrderNumber |
int32 |
Productieordernummer |
☐ |
Unique number to indentify the shop order. |
ShopOrderNumberString |
string |
{res:itgen_eol_shopordernumberstring} |
☐ |
Unique number to indentify the shop order (as a string to allow OData filtering, e.g. $filter=substringof('123',ShopOrderNumberString) eq true. |
ShopOrderParent |
guid |
Ouder Productieorder |
☐ |
Shop order parent. |
ShopOrderParentNumber |
int32 |
{res:itgen_eol_shoporderparentnumber} |
☐ |
Shop order parent number. |
ShopOrderRoutingStepPlanCount |
int32 |
{res:itgen_eol_shoporderroutingstepplancount} |
☑ |
Number of shop order routing step plans for this shop order. |
Status |
int32 |
Status |
☐ |
Indicates the type of Shop Order: 10 Open, 20 In process, 30 Finished, 40 Completed. |
SubShopOrderCount |
int32 |
Sub-productie-order Telling |
☑ |
The count of material lines of this shop order, which have been linked to a sub order. |
Type |
int32 |
Soort |
☐ |
Overall status of the line: 9040 Regular. |
Unit |
string(8) |
Unit |
☐ |
Unit of the item created by this shop order. |
UnitDescription |
string(60) |
Omschrijving Unit |
☐ |
Unit description of the unit of the item created by this shop order. |
Warehouse |
guid |
Magazijn |
☐ |
Reference to the Warehouse associated with the Shop order. |
WarehouseCode |
string |
Magazijncode |
☐ |
|
WarehouseDescription |
string |
Magazijnomschrijving |
☐ |
|
YourRef |
string(30) |
Uw Referentie |
☐ |
Your reference (of the customer). |
24-06-2025 18:54 Versie 24.1.116-BETA+5455