ShopOrders: Exact Online Shop Orders

CADDrawingURL

string

CAD Drawing (URL)

☐

URL to CAD Drawing Specified on Manufacturing Bill of Material.

Costcenter

string(8)

Cost Center

☐

The cost center linked to the shop order.

CostcenterDescription

string(60)

Cost Center Description

☐

Description of Costcenter.

Costunit

string(8)

Cost Unit

☐

The cost unit linked to the shop order.

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 shop order.

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.

EntryDate

datetime

Entry Date

☐

Date on which the shop order was placed.

ID

guid

ID

☑

Primary key.

IsBatch

int16

☑

Does the material plan's item use batch numbers.

IsFractionAllowedItem

int16

Is Fraction Allowed on Item

☑

Indicates if fractions (for example 0.35) are allowed for quantities of the material plan's item.

IsInPlanning

int16

☑

Indicator that Shop order is in planning.

IsOnHold

int16

☑

Indicator if the Shop order is on hold.

IsReleased

int16

☑

Indicator that the Shop order has been released to production.

IsSerial

int16

☑

Does the material plan's item use serial numbers.

Item

guid

Item

☐

Reference to the item.

ItemCode

string(30)

Item Code

☐

Code of the item created by this shop order.

ItemDescription

string(60)

Item Description

☐

Description of the item created by this shop order.

ItemPictureUrl

string

☐

URL of the item created by this shop order.

ItemVersion

guid

Item Version

☐

Reference to ItemVersion.

ItemVersionDescription

string

Item Version Description

☐

Description of Item Version.

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

☐

Notes - only viewed internally.

PlannedDate

datetime

☐

Planned end date of this shop order.

PlannedQuantity

double

☐

Planned quantity.

PlannedStartDate

datetime

☐

Planned start date of this shop order.

ProducedQuantity

double

☐

Produced quantity.

ProductionLeadDays

int32

Production Lead Days

☑

Production lead days.

Project

guid

Project

☐

Reference to Project.

ProjectDescription

string(60)

Project Description

☐

Description of Project.

ReadyToShipQuantity

double

☐

Quantity ready to ship.

SalesOrderLineCount

int32

☑

Number of sales orders linked to this shop order.

SelectionCode

guid

Selection Code

☐

ID of Selection code.

SelectionCodeCode

string

☐

Code of Selection code.

SelectionCodeDescription

string

☐

Description of Selection code.

ShopOrderByProductPlanBackflushCount

int32

☑

Number of shop order by-product plans, which are backflushed, for this shop order.

ShopOrderByProductPlanCount

int32

☑

Number of shop order by-product plans for this shop order.

ShopOrderMain

guid

☐

Shop order main.

ShopOrderMainNumber

int32

☐

Shop order main number.

ShopOrderMaterialPlanBackflushCount

int32

☑

Number of shop order material plans, which are backflushed, for this shop order.

ShopOrderMaterialPlanCount

int32

☑

Number of shop order material plans for this shop order.

ShopOrderNumber

int32

☐

Unique number to indentify the shop order.

ShopOrderNumberString

string

☐

Unique number to indentify the shop order (as a string to allow OData filtering, e.g. $filter=substringof('123',ShopOrderNumberString) eq true.

ShopOrderParent

guid

☐

Shop order parent.

ShopOrderParentNumber

int32

☐

Shop order parent number.

ShopOrderRoutingStepPlanCount

int32

☑

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

☑

The count of material lines of this shop order, which have been linked to a sub order.

Type

int32

Type

☐

Overall status of the line: 9040 Regular.

Unit

string(8)

Unit

☐

Unit of the item created by this shop order.

UnitDescription

string(60)

Unit Description

☐

Unit description of the unit of the item created by this shop order.

Warehouse

guid

Warehouse

☐

Reference to the Warehouse associated with the Shop order.

YourRef

string(30)

Your Reference

☐

Your reference (of the customer).