JDBC Driver for Exact Online

Build 22.0.8462

ShopOrders

Usage information for the operation ShopOrders.rsd.

Columns

Name Type ReadOnly Description
ID [KEY] String True

The ID column for the table ShopOrders.

CADDrawingURL String False

The CADDrawingURL column for the table ShopOrders.

Costcenter String False

The Costcenter column for the table ShopOrders.

CostcenterDescription String False

The CostcenterDescription column for the table ShopOrders.

Costunit String False

The Costunit column for the table ShopOrders.

CostunitDescription String False

The CostunitDescription column for the table ShopOrders.

Created Datetime False

The Created column for the table ShopOrders.

Creator String False

The Creator column for the table ShopOrders.

CreatorFullName String False

The CreatorFullName column for the table ShopOrders.

Description String False

The Description column for the table ShopOrders.

Division Int False

The Division column for the table ShopOrders.

EntryDate Datetime False

The EntryDate column for the table ShopOrders.

IsBatch Int False

The IsBatch column for the table ShopOrders.

IsFractionAllowedItem Int False

The IsFractionAllowedItem column for the table ShopOrders.

IsInPlanning Int False

The IsInPlanning column for the table ShopOrders.

IsOnHold Int False

The IsOnHold column for the table ShopOrders.

IsReleased Int False

The IsReleased column for the table ShopOrders.

IsSerial Int False

The IsSerial column for the table ShopOrders.

Item String False

The Item column for the table ShopOrders.

ItemCode String False

The ItemCode column for the table ShopOrders.

ItemDescription String False

The ItemDescription column for the table ShopOrders.

ItemPictureUrl String False

The ItemPictureUrl column for the table ShopOrders.

ItemVersion String False

The ItemVersion column for the table ShopOrders.

ItemVersionDescription String False

The ItemVersionDescription column for the table ShopOrders.

Modified Datetime False

The Modified column for the table ShopOrders.

Modifier String False

The Modifier column for the table ShopOrders.

ModifierFullName String False

The ModifierFullName column for the table ShopOrders.

Notes String False

The Notes column for the table ShopOrders.

PlannedDate Datetime False

The PlannedDate column for the table ShopOrders.

PlannedQuantity Double False

The PlannedQuantity column for the table ShopOrders.

PlannedStartDate Datetime False

The PlannedStartDate column for the table ShopOrders.

ProducedQuantity Double False

The ProducedQuantity column for the table ShopOrders.

ProductionLeadDays Int False

The ProductionLeadDays column for the table ShopOrders.

Project String False

The Project column for the table ShopOrders.

ProjectDescription String False

The ProjectDescription column for the table ShopOrders.

ReadyToShipQuantity Double False

The ReadyToShipQuantity column for the table ShopOrders.

SalesOrderLineCount Int False

The SalesOrderLineCount column for the table ShopOrders.

ShopOrderByProductPlanBackflushCount Int False

The ShopOrderByProductPlanBackflushCount column for the table ShopOrders.

ShopOrderByProductPlanCount Int False

The ShopOrderByProductPlanCount column for the table ShopOrders.

ShopOrderMain String False

The ShopOrderMain column for the table ShopOrders.

ShopOrderMainNumber Int False

The ShopOrderMainNumber column for the table ShopOrders.

ShopOrderMaterialPlanBackflushCount Int False

The ShopOrderMaterialPlanBackflushCount column for the table ShopOrders.

ShopOrderMaterialPlanCount Int False

The ShopOrderMaterialPlanCount column for the table ShopOrders.

ShopOrderNumber Int False

The ShopOrderNumber column for the table ShopOrders.

ShopOrderNumberString String False

The ShopOrderNumberString column for the table ShopOrders.

ShopOrderParent String False

The ShopOrderParent column for the table ShopOrders.

ShopOrderParentNumber Int False

The ShopOrderParentNumber column for the table ShopOrders.

ShopOrderRoutingStepPlanCount Int False

The ShopOrderRoutingStepPlanCount column for the table ShopOrders.

Status Int False

The Status column for the table ShopOrders.

SubShopOrderCount Int False

The SubShopOrderCount column for the table ShopOrders.

Type Int False

The Type column for the table ShopOrders.

Unit String False

The Unit column for the table ShopOrders.

UnitDescription String False

The UnitDescription column for the table ShopOrders.

Warehouse String False

The Warehouse column for the table ShopOrders.

YourRef String False

The YourRef column for the table ShopOrders.

LinkedShopOrderMaterialPlans String False

The LinkedShopOrderMaterialPlans column for the table ShopOrders.

LinkedShopOrderRoutingStepPlans String False

The LinkedShopOrderRoutingStepPlans column for the table ShopOrders.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462