Pages

name	cloudParentPage	type	description	hint
Administration		base	Administration	Administration
AdminParameters	SystemManagement	base	System Parameters	Parameters of I-Plan system specific to it's proper functioning.
Analytics		base	Analytics	Analytics
AreasManagement	UserManagement	base	Role Management	Create and Modify pages and actions access assigned to specific user roles.
BSMPComparison	ProductionPlan	base	Live Schedule Comparison
BSOGantt	ProductionPlan	base	Schedule Optimiser	Schedule Optimiser
CampaignEditor	ProductionPlan	base	Production Plan Gantt	Production Plan Gantt
ChangeExpiredPassword		supp	Change Expired Password	Change Expired Password
CloudConfiguration	Modeling	base	Configuration	Configuration
Customers2	CloudConfiguration	base	Locations	View and Edit customers in system.
CyclePlan	ProductionPlan	base	Cycle Plan
Dashboard	Analytics	base	Dashboard	Dashboard
DemandPlanning		base	Demand	DemandPlanning
DemandPlanningOrdersByInquiry	DemandPlanning	base	Order Inquiry	View Orders By Inquiry
EventsLog	SystemManagement	base	Processes, Events, Jobs, Tasks	View log of system and user-specific events.
ExternalFixedSources	CloudConfiguration	base	External Fixed Sources	External Fixed Sources
externalMessages	SystemManagement	base	Messages	messages
ExternalSuppliers	SASupplyPlanningReference	base	External Fixed Sources
ForecastAnalysis	DemandPlanning	base	Forecast Analysis	Forecast Analysis
ForecastChanges	DemandPlanning	base	Audit	view forecast changes
ForecastCollaboration	DemandPlanning	base	Forecasting	Forecast CollaborationView
ForecastCollaboration
ForecastingView	DemandPlanning	base	Forecasting View	Forecast Collaboration View
ForecastMethods	CloudConfiguration	base	Forecast Methods	View, Create and Edit forecast methods, modify method-specific parameters.
HierarchiesConfig	Modeling	base	Characteristics	Characteristics Config
HomePage		supp	Home	I-Plan Home page
init	SystemManagement	base	System Actions	System Actions
InteractiveSQL	SystemManagement	base	Interactive SQL query	Interactive SQL query
InventoryPlanning		base	Inventory	InventoryPlanning
LiveAllocation	SASupplyPlanning	base	Demand Control	Demand Control
LiveAllocationChanges	SASupplyPlanning	base	Demand Control Audit	Changes in demand control
MandatorySettings	SASupplyPlanningReference	base	Mandatory Settings	Mandatory Settings for Scenario Analysis
MFASetup		supp	Multi-factor authentication setup	Multi-factor authentication setup page
MinimumAllocations	DemandPlanning	base	Minimum allocation	Minimum market allocation in SNO
Modeling		base	Model	Modeling
MPExcludeFromPrenetting	SASupplyPlanningReference	base	Exclude SKUs from Prenetting	Exclude SKUs from Prenetting
NavigationsConfig	Modeling	base	Navigations	Navigations Config
ObsoleteData	SystemManagement	base	Obsolete Data	Obsolete Data
OnHandStock	InventoryPlanning	base	On-Hand Stock	On-Hand Stock
OrderMaintenance2	InventoryPlanning	base	Reserved Order Maintenance	Reserved Order Maintenance
OrdersByInquiry	InventoryPlanning	base	Order Inquiry	View Orders By Inquiry
Prices	CloudConfiguration	base	Prices	Show price rules
ProductionOptimisation	ProductionPlanning	base	Production Optimisation	Production Optimisation
ProductionOrders	ProductionPlan	base	Production Orders	View pending orders, assign them to runs and initiate firm order creation process.
ProductionPlan	ProductionPlanning	base	Production Plan	Production Plan
ProductionPlanning		base	Production	Production Planning
Products	CloudConfiguration	base	Products	View, Create and Edit materials.
ProgramTemplates	ProductionOptimisation	base	Program Templates	Displays the list of templates for the selected workcentre type (PM or FL).
QuickReports	Analytics	base	Quick Reports	Quick Reports
Reasons	CloudConfiguration	base	Reason codes	view reasons list
ReportBuilder	Analytics	base	Reports	Report Builder
Reporting	UserManagement	base	Reporting	Create and Modify data sources and reports, widgets, filters.
SACyclePlan	ScenarioAnalysis	base	Scenario Cycle Plan
SADemand	ScenarioAnalysis	base	Scenario Demand	Scenario Analysis - Demand View
SAForecasting	ScenarioSettings	base	Forecast	View forecast, edit values and release them.
SAProductSubstitutions	ScenarioSettings	base	SA Product Substitutions	Scenario Analysis - Product Substitutions
SAReference	ScenarioSettings	base	SA Reference	Scenario Analysis - Reference View
SAShutdowns	ScenarioSettings	base	Workcentre Shutdowns	Show SA workcentre shuts
SASNPStock	ScenarioAnalysis	base	SNP Stock
SASourcing	ScenarioAnalysis	base	Scenario Source	Scenario Analysis - Sourcing View
SASupplyPlanning	SupplyPlanning	base	Demand Control	Demand Control
SASupplyPlanningReference	SupplyPlanning	base	Reference	SA reference settings
ScenarioAnalysis	SupplyPlanning	base	Scenario Analysis	Scenario Analysis
Scenarios	ScenarioSettings	base	Scenarios	Scenarios
ScenarioSettings	SupplyPlanning	base	Scenario Settings	Scenario Settings
SessionsManagement	SASupplyPlanningReference	base	Session Management	Scenario Session Management
SimpleDemandControl	SASupplyPlanning	base	Supply Based Demand Control	Supply Based Demand Control
Sites	CloudConfiguration	base	Sites	Manage sites
Sites
SKU	CloudConfiguration	base	SKU	View stock keeping units
SourcingNetwork	Modeling	base	Sourcing Network	View sourcing network for a selected material or location.
SourcingRules	CloudConfiguration	base	Sourcing Rules	Sourcing Rules
SQLNoteBook	SystemManagement	base	SQL NoteBook	SQL NoteBook
StartScenario	ScenarioAnalysis	supp	Start Scenario	start scenario
StockMonitoring2	InventoryPlanning	base	Stock Monitoring	Stock Monitoring
StockReservation2	InventoryPlanning	base	Stock Reservation	view and maintain the consignment stock levels.
SupercessionRules	CloudConfiguration	base	Supersession and Substitution	Supersession and Substitution
SupplyPlanning		base	Supply	Supply Planning
SystemManagement	Administration	base	System Management	System Management
SystemSettings	Administration	base	System Settings	System Settings
Templates	Modeling	base	Data Loading	Create and edit models
Transportation	CloudConfiguration	base	Transport and Calendars	Transport and Calendars
Units	CloudConfiguration	base	Units, Currencies	Manage system units, currencies and exchange rates
UserManagement	Administration	base	User Management	User Management
UserNotifications		supp	Notifications	User Notifications page
UserSettings		base	User settings	User settings
UsersManagement	UserManagement	base	Users Management	Create, View, Edit and Disable users of I-Plan system. Switch to browsing and editing the roles assigned to a selected user.

top

AdministrationNo gridstop

AdminParametersNo gridstop

AnalyticsNo gridstop

AreasManagement

ActionRoles

field caption type transformColumn transformFormat transformable showTotal Id Integer RoleDescription Role String Assigned Assigned Integer

AreaPageActions

field caption type transformColumn transformFormat transformable showTotal Id Integer PagePath Area String PageDescription Page String ActionDescription Action String

DataSourcesForRole

field caption type transformColumn transformFormat transformable showTotal Id Integer Title Data Source String Description Description String Type Type String

PageActions

field caption type transformColumn transformFormat transformable showTotal Id Integer PagePath Page String ActionDescription Action String

Roles

field caption type transformColumn transformFormat transformable showTotal Id Integer RoleDescription Role String IsAdmin Is Admin Integer

RolesActions

field caption type transformColumn transformFormat transformable showTotal Id Integer PagePath Page String ActionDescription Action String Assigned Assigned Integer

RolesDataSources

field caption type transformColumn transformFormat transformable showTotal Id Integer Title Title String Description Description String Type Type String Assigned Assigned Integer

RolesWidgets

field caption type transformColumn transformFormat transformable showTotal Id Integer WidgetDescription Description String Assigned Assigned Integer

SystemDataSources

field caption type transformColumn transformFormat transformable showTotal Id Integer DataSourceDescription Data Source String

SystemRoles

field caption type transformColumn transformFormat transformable showTotal Id Integer RoleName Role String

WidgetsForRole

field caption type transformColumn transformFormat transformable showTotal Id Integer Title Data Source String Description Description String

top

BSMPComparison

BSMPComparison

field caption type transformColumn transformFormat transformable showTotal Id Integer Period Period Month yes {0:yyyy-MM-dd} TotalAllocation Total Allocation Decimal yes yes RunCapacity Run Capacity Decimal yes yes Difference Difference Decimal yes yes CumulativeTotalAllocation Cumulative Total Allocation Decimal yes yes CumulativeRunCapacity Cumulative Run Capacity Decimal yes yes CumulativeDifference Cumulative Difference Decimal yes yes AllocationToOrders Allocation To firm orders Decimal yes yes AllocationToForecast Allocation To remaining forecasts Decimal yes yes FirmOrders Runs Firm orders Decimal yes yes TentativeOrders Runs Tentative orders Decimal yes yes FreeCapacity Runs Available capacity Decimal yes yes

top

BSOGantt

BSODemandAnalysis BSO Demand Analysis

field caption type transformColumn transformFormat transformable showTotal GradeCode Properties String OriginalAllocationsDuration Original Allocation, Duration TimeSpan yes OriginalAllocationsWeight Original Allocation, Weight Decimal yes OrdersDuration Orders, Duration TimeSpan yes OrdersWeight Orders, Weight Decimal yes RemainingAllocationsDuration Remaining Allocation, Duration TimeSpan yes RemainingAllocationsWeight Remaining Allocation, Weight Decimal yes NominalDuration Template Duration, Nominal TimeSpan yes AdjustedDuration Template Duration, Adjusted TimeSpan yes OptimizedDuration Optimized, Duration TimeSpan yes OptimizedWeight Optimized, Weight Decimal yes

BSODemands BSO Demands

field caption type transformColumn transformFormat transformable showTotal IsOrder integer OrderId integer customer Demand String type Demand Type String customer2 Customer String ordercode Order Code String linenocode Order Line Number String quantity Weight Decimal yes duration Duration (days hrs:min) TimeSpan yes due DueDate DateTime completion Completion Date DateTime RequestedDate Requested Date Date DeliveryDate Delivery Date Date DespatchDate Despatch Date Date lateness Lateness (days hrs:min) TimeSpan CorrespondRunName Linked Run String

BSOPrograms BSO Programs

field caption type transformColumn transformFormat transformable showTotal Id Integer ProgramTemplateId Integer StartDate Start Date DateTime FinishDate Finish Date DateTime ProgramName Program String RunsAssigned No of runs Integer OppRunLength Opp. Run Length TimeSpan FixOppRuns Fix Opp. runs Integer FirstRunProperties First run String LastRunProperties Last run String Duration Nominal Duration TimeSpan DurationAdj Adjusted Duration TimeSpan ShutLength Shut Length TimeSpan AllowIdleForShut Allow Idle for Shut Integer EarlyFixedPenalty Shut fixed early penalty Decimal DailyEarlyPenalty Shut daily early penalty Decimal LateFixedPenalty Shut fixed late penalty Decimal DailyLatePenalty Shut daily late penalty Decimal FirstRunMandatory First Run Mandatory Integer LastRunMandatory Last Run Mandatory Integer

DemandBalance

field caption type transformColumn transformFormat transformable showTotal WorkcentreName Source String SourceMonth Period Month yes {0:yyyy-MM-dd} duration Demand TimeSpan yes yes

DetailRunInventory

field caption type transformColumn transformFormat transformable showTotal Id integer Period Period Date yes {0:yyyy-MM-dd} Inventory Inventory Decimal yes Production Production Decimal yes Allocation Allocation Decimal yes

OptimizedRuns Optimized Runs

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkCentreId PositionNo Integer GradeId Integer IsLiveRun Integer IsReadonly Integer IsFrozen Integer IsWkcReadonly Integer WorkCentreName WorkCentre Name String RunCode Run Code String StartDate Start DateTime FinishDate Finish DateTime TargetStartDate Target DateTime SwitchoverDuration Switchover Duration TimeSpan ShutDuration Shut Duration TimeSpan RunType Run Type String Properties Run Properties String Rate Rate Decimal Capacity Capacity Decimal true OrdersWeight Firm Orders Decimal true AvailableCapacity Available Decimal true AllocationsWeight Allocations Decimal true FreeCapacity Free Capacity Decimal true Duration Duration TimeSpan OrdersDuration Firm Orders Duration TimeSpan AvailableDuration Available Duration TimeSpan AllocationsDuration Allocations Duration TimeSpan FreeDuration Free Duration TimeSpan

RevisedAllocations2

field caption type transformColumn transformFormat transformable showTotal Id integer Period Period Month yes {0:yyyy-MM-dd} Revised Revised Allocation Decimal yes yes

RunInventory

field caption type transformColumn transformFormat transformable showTotal Id integer SafetyStock Safety Stock Decimal Period Period Date yes {0:yyyy-MM-dd} Inventory Inventory Decimal yes

WorkCentresBSOProgramTemplates WorkCentres BSO Program Templates

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkCentreName Name String State State String

top

CampaignEditor

AlternateRuns Alternate Runs

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteName Site Name String WorkCentreName WorkCentre Name String RunCode Run Code String RunStart Run Start DateTime RunEnd Run End DateTime Capacity Capacity Decimal FreeCapacity Free Decimal Duration Duration TimeSpan AvailableDuration Free Duration TimeSpan

AutoCreateOrders

field caption type transformColumn transformFormat transformable showTotal OrderCode Order Code String LineNoCode Order Line Number String LocationName Customer String MaterialName Product String MaterialCode Material Code String Status Status String UnitDesc Unit String Quantity Quantity Decimal yes Weight Weight Decimal yes DespatchDate Despatch Date Date DeliveryDate Delivery Date Date Transport Transport String SkuId Integer ConsignmentId Integer JourneyId Integer StatusId Integer UnitId Integer

MoveOrderRuns Move Orders: Runs

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteName Site Name String WorkcentreTypeDesc WorkCentre Type String WorkCentreName WorkCentre Name String BlockCode Block Code String RunCode Run Code String RunProducts Run Product String RunStart Run Start DateTime RunEnd Run End DateTime Capacity Capacity Decimal FreeCapacity Free Decimal Duration Duration TimeSpan AvailableDuration Free Duration TimeSpan

PreTrimSolutions

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreName Workcentre String BlockCode Block String RunCode Run String UserName User String InsertDate Solution Date DateTime TrimQty Trimmed Qty Decimal TrimLossQty Trim Loss Qty Decimal TrimLossPercentage Trim Loss % Decimal

ProdGanttOrders Orders

field caption type transformColumn transformFormat transformable showTotal SkuId Integer ConsignmentId Integer Id Integer NonManipulated Integer IsCustomer Integer Replenished Integer OrderOperationId Integer IsRemovable Integer MaterialRunId Integer IsFilterSelected Integer WorkcentreTypeDesc Workcentre Type String WorkcentreName Workcentre String BlockCode Block Code String RunCode Run Code String RunProperties Run Properties String OrderCode Order Code String LineNoCode Order Line No String LocationName Customer String ToConsignmentLocationName Consignment Customer String Status Order Line Status String OrderProductCode Order Product,Code String OrderProductName Order Product,Name String ProductProperties String WeightTentative Sales Weight,Tentative Decimal yes WeightFirm Sales Weight,Firm Decimal yes AllocatedStock Sales Weight,Allocated Stock Decimal yes DeliveredWeight Sales Weight,Delivered Decimal yes QuantityTentative Sales Quantity,Tentative Integer yes QuantityFirm Sales Quantity,Firm Integer yes AllocatedStockQuantity Sales Quantity,Allocated Stock Decimal yes DeliveredQuantity Sales Quantity,Delivered Decimal yes UnitName Sales Quantity,Unit String DespatchDate Despatch Date Date DeliveryDate Delivery Date Date ConfirmedDate Confirmed Date Date FullyAllocatedDate Confirm Availability Date Date RequestedDate Requested Date Date ProductionStartDate Production Start Date Date Transport Transport String Priority Priority ReasonId Reason Code IsPaymentHold Payment Hold Integer OperationNo Operation No OrderOperationStatus Operation Status String ProductionProductCode Production Product,Code String ProductionProductName Production Product,Name String OperationWeightTotal Production Weight,Total Decimal yes OperationWeightRemaining Production Weight,Remaining Decimal yes OperationQuantityTotal Production Quantity,Total Integer yes OperationQuantityRemaining Production Quantity,Remaining Integer yes OperationUnitName Production Quantity,Unit String OperationDurationTotal Production Duration,Total TimeSpan yes OperationDurationRemaining Production Duration,Remaining TimeSpan yes

top

ChangeExpiredPasswordNo gridstop

CloudConfigurationNo gridstop

Customers2

Companies Companies

field caption type transformColumn transformFormat transformable showTotal Id Integer CompanyName Name String CompanyCode Code String Internal Is Internal Integer GroupReplenishedLocations Group Replenished Locations Integer CustomerRankDesc Rank String SafetyStockMethodDesc Safety Stock String

CustomerRanks Customer Ranks

field caption type transformColumn transformFormat transformable showTotal Id Integer CustomerRankName Name String CustomerRankDesc Description String Priority Priority Integer DisplayInForecast Display in Forecast Integer

ForecastRanges Forecast Ranges

field caption type transformColumn transformFormat transformable showTotal Id Integer RangeName Name String

ForecastRangeValues Forecast Range values

field caption type transformColumn transformFormat transformable showTotal Id Integer DayFrom Day From Integer DayTo Day To Integer Percentage Percentage Integer

FrozenEditingPeriods Frozen editing periods

field caption type transformColumn transformFormat transformable showTotal CharacteristicsValue String CharacteristicsKey String FrozenPeriod Freeze periods (months) Integer

Hierarchies Hierarchies

field caption type transformColumn transformFormat transformable showTotal Id Integer Latitude Latitude String Longitude Longitude String

Locations Locations

field caption type transformColumn transformFormat transformable showTotal Id Integer HasWorkcentre Integer LocationName Name String LocationCode Code String LocationStatus Status Capacity Capacity Decimal AllocatedStock Allocated Stock Integer OrderAutoConfirmPeriod Order auto confirm period Integer DefaultCustomerForecast Default customer forecast CompanyId Company CalendarId Calendar CustomerRankId Rank SafetyStockMethodId Safety stock method TransportLocationId Transport Location StockLocationId Stock Location WarehouseLocationId Warehouse Location SiteId Site CurrencyId Currency ForecastRangeId Forecast Range UseTradingDays Use Trading Days Integer ReplacedLocations Replaced Locations String ReplacedByLocation New Location Code String

OperationTypes Operation Types

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreTypeId Integer OperationTypeName Name String ApplyCyclePlan Apply Cycle Plan integer

OrderBookTypes Order book types

field caption type transformColumn transformFormat transformable showTotal OrderBookTypeName Type Name String ChangingDeliveryDates Allow change dispatch/delivery dates integer

WorkcentreTypes Workcentre Types

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreTypeName Name String WorkcentreTypeDesc Description String IsProductionSource Is Production Source Integer SupplierType SupplierType String OrderNo Order No Integer StageDelayHours Fixed Stage delay (days : hours) TimeSpanDayHour MaxStageDelayHours Max Stage delay (days : hours) TimeSpanDayHour BSOptimisation BS optimisation integer BSONextCampaign BS next optimisation integer IncludeAllocationMessages Include into allocation messages integer

top

CyclePlanNo gridstop

Dashboard

DemandPlanningProgress

field caption type transformColumn transformFormat transformable showTotal Value String CE CE % Decimal FE FE % Decimal CO CO % Decimal

LiveAllocationsProgress

field caption type transformColumn transformFormat transformable showTotal GroupLevel String HierarchyLevel HierarchyLevel String PropertyLevel PropertyLevel String ADJUSTEDITEMSPERCENTAGE Adj.Items % Decimal ADJUSTEDVOLUMEPERCENTAGE Adj.Volume % Decimal ORDERS Orders Decimal ORIGINALALLOCATION Original Allocation Decimal CURRENTALLOCATION Current Allocation Decimal

SupplyPlanningProgress

field caption type transformColumn transformFormat transformable showTotal Id Id Integer ScenarioSessionId Integer SCENARIONAME Scenario String ISRELEASED Released Integer CONSTRAINEDDEMAND Allocation Decimal UNALLOCATEDFORECAST Unallocated Decimal REVENUE Revenue Decimal MARGIN Margin Decimal PenaliseDowntime Penalise Downtime String UseMinAllocation Use Min. Allocation String DIFFERENCEFG Max.weeks to produce early Integer DIFFERENCEFGREPLENISHED Max.weeks to produce early (replenished) Integer DIFFERENCESFG Max.weeks to finishing Integer

top

DemandPlanningNo gridstop

DemandPlanningOrdersByInquiry

OrderInputMaterials Order Input Materials

field caption type transformColumn transformFormat transformable showTotal OperationNo Operation No String OperationTypeName Operation Type String WorkcentreName Workcentre String WorkcentreCode Workcentre code String Quantity Quantity Decimal RemainingQuantity Remaining Quantity Decimal MaterialName Input Material name String MaterialCode Input Material code String

OrderOperations OrderOperations

field caption type transformColumn transformFormat transformable showTotal Id Integer MaterialRunId Integer OrderLineId Integer OperationNo Operation No String WorkcentreName Workcentre String BlockRunCode Run,Code String StartDate Run,Start Date DateTime FinishDate Run,Finish Date DateTime StartTime Operation,Start Time DateTime FinishTime Operation,Finish Time DateTime Weight Weight Decimal WeightComplete Weight Complete Decimal OperationDuration Duration TimeSpan Rate Operation rate Decimal ProcessDuration Process duration TimeSpan OrderLineStatusName Status String MaterialCode Production Product,Code String MaterialName Production Product,Name String

OrdersInquiry OrdersInquiry

field caption type transformColumn transformFormat transformable showTotal Id Integer LineNoCode Line No String OrderCode Order Code String OrderType Order Type String AlternateCode1 Alternate Code 1 String AlternateCode2 Alternate Code 2 String OrderLineStatusName Status String Quantity Quantity Decimal SourceQuantity Source Quantity Decimal RemainingQuantity Remaining Quantity Decimal AllocatedStock Allocated Stock Decimal DeliveredQuantity Delivered Quantity Decimal Price Price Decimal RequestedDate Requested Date Date ConfirmedDate Confirmed Date Date FullyAllocatedDate Confirm Availability Date Date DeliveryDate Delivery Date Date DespatchDate Despatch Date Date ProductionDate Production Date Date FinishingSite Finishing Site String LocationCode Customer Code String LocationName Customer Name String DestinationLocationCode Destination Code String DestinationLocationName Destination String MaterialCode Product Code String MaterialName Product String ProductProperties String SourceCSCustomerCode Source Consignment Customer Code String SourceCSCustomer Source Consignment Customer String DestinationCSCustomerCode Destination Consignment Customer Code String DestinationCSCustomer Destination Consignment Customer String Source Source String Lateness Lateness Integer AllowSubstitution Allow Substitution Integer ExMillDate Ex Mill Date Date PMRun Run String IsPaymentHold Payment Hold Integer ReasonId Reason Code Priority Priority Integer CreateUser Created by User String CreateDate Created at DateTime UpdateUser Updated by User String UpdateDate Updated at DateTime

top

EventsLog

AggregatedEvents

field caption type transformColumn transformFormat transformable showTotal DateFrom Date From Date EventName Event Name string FormattedDescription Description string Quantity Quantity string

EngineStorageFiles

field caption type transformColumn transformFormat transformable showTotal Path string Date Date DateTime Type Type string FileName File Name string UserName User Name string Extra Extra info string

EventsLog

field caption type transformColumn transformFormat transformable showTotal Dateappearence Date DateTime Tier Tier string EventName Event Name string UserName User Name string EventTypeName Event Type String FormattedDescription Description string DescriptionForDeveloper Description for developers string

JobResults

field caption type transformColumn transformFormat transformable showTotal Description Description String CurrentState Current State Integer Total Total State Integer

Jobs

field caption type transformColumn transformFormat transformable showTotal Id Integer SystemProcessId Integer JobType Job Type String FileName File Name String IsFinished Is Finished Integer UserName User string InsertDate Created DateTime FinishDate Finished DateTime FailedReason Failed Reason string

Processes

field caption type transformColumn transformFormat transformable showTotal Id Integer SystemProcessId Integer Status Integer ProcessName Name string ProcessType Type string Started Started DateTime Finished Finished DateTime Duration Duration TimeSpan UserName User string ProcessStatusName Status string FailedReason Failed Reason string

ProcessLog

field caption type transformColumn transformFormat transformable showTotal Stamp Stamp DateTime Difference Difference (secs) Integer DifferenceFromStart From start (minutes) TimeSpan Action Action String Description Description string

ProcessResults

field caption type transformColumn transformFormat transformable showTotal Description Description String Value Value String

Tasks

field caption type transformColumn transformFormat transformable showTotal Id Integer TaskName Name String Executable Executable String Description Description String IsSystemTask Is System Integer DaysToKeepLogs Days to keep logs Integer IsActive Is Active Integer

top

ExternalFixedSources

SitesWorkCentreGrid Sites WorkCentre

field caption type transformColumn transformFormat transformable showTotal WorkCentreId Integer SiteName Site Name String SiteCode Site Code String WorkCentreName Work Centre Name String WorkCentreCode Work Centre Code String

top

externalMessages

AggregatedMessages

field caption type transformColumn transformFormat transformable showTotal StartedAt Date Date TopElement TopElement String Direction Direction string FailedMessages Failed Message string SuccessFulMessages Successful Message string

AllMessagesLog

field caption type transformColumn transformFormat transformable showTotal Id Integer Direction Direction string TopElement Top Element string Code Message Code string StartedAt Start Time DateTime FinishedAt Finish Time DateTime SourceDestination Source Destination string ContentType Content Type string UserName User Name string IsFailed Is Failed Integer

DDQRequests

field caption type transformColumn transformFormat transformable showTotal Id Integer Sender Sender string HeaderCodes Header Codes string OriginalHeaderCodes Original Header Codes string NoOfHeaders Headers No Integer NoOfLines Lines No Integer NoOfSuccessfulLines Successful Lines No Integer RequestCodes Request Codes string LocationCodes Location Codes string ProductCodes Product Codes string InquiryMethodCodes Inquiry Method Codes string RequestStatuses Statuses string TimeStamp Time Stamp DateTime

DDQTasks

field caption type transformColumn transformFormat transformable showTotal Id Integer HeaderCode Header Code string LineCode Line Code string InquiryMethodCode Inquiry Method string RequestStatus Status string LocationCode Location Code string ProductCode Product Code string Quantity Quantity Decimal UnitName Unit string RequestDate Request Date DateTime LateDays Late, days Integer

FailedMessages

field caption type transformColumn transformFormat transformable showTotal StartTime Date Date TopElement TopElement String Direction Direction string FailedMessages Failed Message string

FailedMessagesLog

field caption type transformColumn transformFormat transformable showTotal Id Integer IsSelected Integer Direction Direction string TopElement Top Element string Code Message Code string TimeStamp Time Stamp DateTime StartTime Start Time DateTime FinishTime Finish Time DateTime IsFailed Is Failed Integer Error Error string

MessagesLog

field caption type transformColumn transformFormat transformable showTotal Id Integer Direction Direction string TopElement Top Element string Code Message Code string TimeStamp Time Stamp DateTime StartTime Start Time DateTime FinishTime Finish Time DateTime IsFailed Is Failed Integer Error Error string

UnprocessedMessages

field caption type transformColumn transformFormat transformable showTotal Stamp Stamp DateTime OriginalStamp Original Stamp DateTime Guid GUID string ElementName Element string RoleDescription Security Role string QueueType Queue Type String ErrorText Error Message string Message Message Source string

top

ExternalSuppliers

ExternalFixedSources External Fixed Sources

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer WorkcentreName Workcentre String DateFrom Date From Date DateTo Date To Date Capacity Capacity Decimal PeriodType Period Type String

top

ForecastAnalysisNo gridstop

ForecastChanges

CollaborationChanges Forecast changes

field caption type transformColumn transformFormat transformable showTotal UserName User Name string SnapshotName Snapshot Name string ForecastPeriod Date Date WeekNum Week Integer InitValue Value, Original Decimal LastValue Value, New Decimal UnitName Unit string Operation Operation string ForecastStatusName Forecast Status string ForecastComment Comment string ReasonDescription Reason string UpdateDate Update Date DateTime CommentLink CommentLink string

SMIForecast SMI Forecasting

field caption type transformColumn transformFormat transformable showTotal ForecastStatusId Integer Id Integer DateFromMonth Month yes {0:yyyy-MM-dd} WeekOfYear String yes {0} Forecast Decimal yes yes WeeklyForecast Decimal yes yes

top

ForecastCollaborationNo gridstop

ForecastCollaboration

AdjustedHistory Forecast history

field caption type transformColumn transformFormat transformable showTotal Id String Month Month String DateFrom Year Year yes {0:yyyy} History History Decimal yes yes Adjusted Adjusted History Decimal yes yes ForecastEvents Event String yes yes

ForecastCollaboration Monthly Forecasting

field caption type transformColumn transformFormat transformable showTotal Id Integer ForecastStatusId Integer Status Status String WarningCssClass String History1 Year ago Decimal yes History8 12m average Decimal yes History4 6m average Decimal yes History2 3m average Decimal yes History6 3 months ago Decimal yes History5 2 months ago Decimal yes History3 Month ago Decimal yes History7 YTM Decimal yes MTD MTD Decimal yes CurrentForecast Current Month Decimal yes SystemTotal Period Total,System Decimal yes CustomerTotal Period Total,Customer Decimal yes FinalTotal Period Total,Final Decimal yes ForecastTotal Period Total,Forecast Decimal yes OrdersTotal Period Total,Orders Decimal yes AllocationsTotal Period Total,Current Allocations Decimal yes ForecastAllocationTotal Period Total,Forecast Allocation Decimal yes BudgetTotal Period Total,Budget Decimal yes NominalCostTotal Period Total,Total Nominal Cost Decimal yes ValueAddTotal Period Total,Total Value Add Decimal yes RevenueTotal Period Total,Total Revenue Decimal yes Period Period Month yes {0:yyyy-MM-dd} System System Decimal yes yes Customer Customer Decimal yes yes Final Final Decimal yes yes Forecast Forecast Decimal yes yes ForecastAllocation Forecast allocation Decimal yes yes Orders Orders Decimal yes yes Allocations Current Allocations Decimal yes yes Budget Budget Decimal yes yes SystemPrice Price,System Decimal yes Price Price,Forecasted Decimal yes Revenue Revenue Decimal yes yes NominalCost Nominal Cost Decimal yes TotalNominalCost Total Nominal Cost Decimal yes yes ValueAdd Value Add Decimal yes TotalValueAdd Total Value Add Decimal yes yes

ForecastCollaborationComparison Comparison

field caption type transformColumn transformFormat transformable showTotal Id String Month Month String Period Period Year yes {0:yyyy} Weight History Decimal yes yes AdjustedWeight Adjusted History Decimal yes yes AllHistory All History Decimal yes yes FittedHistory Fitted History Decimal yes yes OriginalSystem First pass forecast Decimal yes yes System Second pass forecast Decimal yes yes Customer Customer Decimal yes yes Final Final Decimal yes yes Budget Budget Decimal yes yes Orders Orders Decimal yes yes

ForecastCollaboration-Orders Order Lines

field caption type transformColumn transformFormat transformable showTotal Id Integer OrderLineId Integer OrderCode Order Code String lineNoCode Line No String Direction Direction String Destination Destination string Source Source string MaterialCode Material Code string DeliveryDate Delivery Date Date DespatchDate Despatch Date Date FinalWeight Weight decimal OrderLineStatusName Status String

ForecastCollaboration-OrdersFragment Order Lines Fragment

field caption type transformColumn transformFormat transformable showTotal Id Integer OrderLineId Integer DeliveryDate Delivery Date Date DespatchDate Despatch Date Date FinalWeight Weight decimal OrderLineStatusName Status String

ForecastCollaborationStatistic Forecast Statistics

field caption type transformColumn transformFormat transformable showTotal WarningCssClass String Historicdatamean Historic Data Mean Decimal Standarddeviation Standard Deviation Decimal Variance CoV % Decimal AdjustedRSquare AdjustedRSquare Decimal FinalTrend Final Trend Decimal MAPE MAPE Decimal ZMAPE ZMAPE Decimal SMAPE SMAPE Decimal MPE MPE Decimal MAD MAD Decimal RMSE RMSE % Decimal MTDFF MTDFF % Decimal MTDCF MTDCF % Decimal OrdersVsFinalForecast Orders Vs FF Decimal ForecastMethod Forecast Method String Seasonality Seasonality String Trend Trend String GroupForecastMethod Group Forecast Method String GroupSeasonality Group Seasonality String GroupTrend Group Trend String UsedExternalTrends Significant external trends String

ForecastFinancialFragment

field caption type transformColumn transformFormat transformable showTotal DateFrom Month yes {0:yyyy-MM-dd} Forecast Decimal yes ForecastAllocation Decimal yes Price Decimal yes Revenue Decimal yes NominalCost Decimal yes TotalNominalCost Decimal yes ValueAdd Decimal yes TotalValueAdd Decimal yes

ForecastSnapshot Forecast Snapshot

field caption type transformColumn transformFormat transformable showTotal Id Integer ForecastStatusId Integer Status Status String ForecastTotal Period Total,Forecast Decimal yes BudgetTotal Period Total,Budget Decimal yes Period Period Month yes {0:yyyy-MM-dd} Forecast Forecast, Forecast Decimal yes yes Budget Forecast, Budget Decimal yes yes SystemPrice Forecast,System Price Decimal yes Price Forecast,Forecasted Price Decimal yes Revenue Forecast,Revenue Decimal yes yes NominalCost Forecast,Nominal Cost Decimal yes TotalNominalCost Forecast,Total Nominal Cost Decimal yes yes ValueAdd Forecast,Value Add Decimal yes TotalValueAdd Forecast,Total Value Add Decimal yes yes Allocated Allocated, Allocated Decimal yes yes AllocatedRevenue Allocated, Revenue Decimal yes yes AllocatedTotalCost Allocated, Total Cost Decimal yes yes AllocatedValueAdd Allocated, Total Value Add Decimal yes yes Unallocated Unallocated, Unallocated Decimal yes yes UnallocatedRevenue Unallocated, Revenue Decimal yes yes UnallocatedTotalCost Unallocated, Total Cost Decimal yes yes UnallocatedValueAdd Unallocated, Total Value Add Decimal yes yes

ForecastSnapshots Forecast snapshots list

field caption type transformColumn transformFormat transformable showTotal Id Integer UnconstrainedSnapshotId Integer Name Name String Description Description String IsShowOnGraph Show on the graph Integer IsBudget Is a budget Integer StartDate Start Date Date FinishDate Finish Date Date

HistoryEventRules History event rules

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Month Date ForecastEventName Forecast event String RuleWeighting Rule Weighting Integer Characteristics Characteristics String

WeeklyForecastCollaboration Weekly Forecasting

field caption type transformColumn transformFormat transformable showTotal Id Integer ForecastStatusId Integer Status Status String WarningCssClass String SystemTotal Period Total,System Decimal yes CustomerTotal Period Total,Customer Decimal yes FinalTotal Period Total,Final Decimal yes ForecastTotal Period Total,Forecast Decimal yes OrdersTotal Period Total,Orders Decimal yes Period Period Month yes {0:yyyy-MM-dd} System System Decimal yes yes Customer Customer Decimal yes yes Final Final Decimal yes yes Forecast Forecast Decimal yes yes Orders Orders Decimal yes yes

WeeklyForecastFragment

field caption type transformColumn transformFormat transformable showTotal DateFrom Month yes {0:yyyy-MM-dd} Forecast Decimal yes

WeeklyForecastSnapshot Weekly Forecast Snapshot

field caption type transformColumn transformFormat transformable showTotal Id Integer ForecastStatusId Integer Status Status String ForecastTotal Period Total,Forecast Decimal yes BudgetTotal Period Total,Budget Decimal yes Period Period Week yes {0:yyyy-MM-dd} Forecast Forecast Decimal yes yes Budget Forecast, Budget Decimal yes yes Allocated Allocated Decimal yes yes Unallocated Unallocated Decimal yes yes

top

ForecastingView

DailyDistribution Daily Distribution

field caption type transformColumn transformFormat transformable showTotal DateFrom Date Date Forecast Daily Forecast Decimal yes

ForecastSampleComparison Forecast Sample values

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Period Month yes {0:yyyy-MM-dd} ForecastMethodName MethodName String Weight Weight Decimal yes

ForecastSamples Forecast Samples

field caption type transformColumn transformFormat transformable showTotal Id Integer ReportFilterId Integer ForecastSampleName Name String HistoryStartDate History Start Month Month StartDate Start Month Month FinishDate Finish Month Month FilterValues Filter String Methods Methods String

ForecastSampleStatistic Forecast Sample Statistics

field caption type transformColumn transformFormat transformable showTotal Id Integer MethodName Method Name String ForecastMethodName Forecast Method String ymean History Mean Decimal ysdev Std. Deviation Decimal adjrsq Adj. RSquared Decimal MAPE MAPE Decimal SMAPE SMAPE Decimal MAD MAD Decimal RMSErr RMSE Decimal sigma Std. Forecast Error Decimal ErrorStdDev Std. Deviation Error Decimal UsedExternalTrends Significant external trends String

ForecastSampleValues Forecast Sample values

field caption type transformColumn transformFormat transformable showTotal Id Integer ForecastMethodName MethodName String DateFrom Period Month yes {0:yyyy-MM-dd} Forecast Forecast Decimal yes

ForecastView Forecasting View

field caption type transformColumn transformFormat transformable showTotal Id Integer WarningCssClass String ForecastStatusId Integer Status Status String History1 Year ago Decimal yes History8 12m average Decimal yes History4 6m average Decimal yes History2 3m average Decimal yes History6 3 months ago Decimal yes History5 2 months ago Decimal yes History3 Month ago Decimal yes History7 YTM Decimal yes MTD MTD Decimal yes DateFrom Period Month yes {0:yyyy-MM-dd} System System Decimal yes yes Customer Customer Decimal yes yes Final Final Decimal yes yes Orders Orders Decimal yes yes Budget Budget Decimal yes yes CustomerVsSystem Customer vs System Decimal yes SystemVsFinal System vs Final Decimal yes CustomerVsFinal Customer vs Final Decimal yes Historicdatamean Historic Data Mean Decimal Standarddeviation Standard Deviation Decimal Variance CoV % Decimal AdjustedRSquare AdjustedRSquare Decimal FinalTrend Final Trend Decimal MAPE MAPE Decimal ZMAPE ZMAPE Decimal SMAPE SMAPE Decimal MPE MPE Decimal MAD MAD Decimal RMSE RMSE % Decimal MTDFF MTDFF % Decimal MTDCF MTDCF % Decimal OrdersVsFinalForecast Orders Vs FF Decimal ForecastMethod Forecast Method String Seasonality Seasonality String Trend Trend String GroupForecastMethod Group Forecast Method String GroupSeasonality Group Seasonality String GroupTrend Group Trend String

top

ForecastMethods

ForecastEventRules ForecastEventRules

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Month Date ForecastEventName Forecast event String RuleWeighting Rule Weighting Integer Characteristics Characteristics String

ForecastEventTypes Forecast event types

field caption type transformColumn transformFormat transformable showTotal Id Integer IsUsed Integer ForecastEventName Event name String

ForecastMethods ForecastMethods

field caption type transformColumn transformFormat transformable showTotal Id Integer ForecastMethodDesc Method name String ForecastMethodTypeDesc Type String IsInternal Is Internal Integer

ForecastPatterns ForecastPatterns

field caption type transformColumn transformFormat transformable showTotal Id Integer IsUsed Integer ForecastPatternName Trend name String StartDate Start Date Date

ForecastPatternValues ForecastPatternValues

field caption type transformColumn transformFormat transformable showTotal Id Order No Integer Value Value Decimal

top

HierarchiesConfig

OrderInformationCategories

field caption type transformColumn transformFormat transformable showTotal CategoryInfo Category String ItemType Item String IsSelected Is Selected Integer IsEditable Is Editable Integer

top

HomePage

OverUnderMAPE Forecast Bias

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Period Month yes {0:yyyy-MM-dd} System System Decimal yes yes Customer Customer Decimal yes yes Final Final Decimal yes yes History History Decimal yes yes SMAPE System MAPE Decimal yes CMAPE Customer MAPE Decimal yes FMAPE Final MAPE Decimal yes

top

initNo gridstop

InteractiveSQLNo gridstop

InventoryPlanningNo gridstop

LiveAllocation

AllocationSnapshots Allocation snapshots list

field caption type transformColumn transformFormat transformable showTotal Id Integer Name Name String Description Description String StartDate Start Date Date FinishDate Finish Date Date

LiveAllocation Demand Control

field caption type transformColumn transformFormat transformable showTotal Id Integer BackOrders Back Orders Decimal yes Period Period Month yes {0:yyyy-MM-dd} Forecast Forecast Decimal yes yes ForecastTotal Period Total,Forecast Decimal yes Indicatives Indicatives Decimal yes yes IndicativesTotal Period Total,Indicatives Decimal yes OriginalAllocation Original Allocation Decimal yes yes OriginalAllocationTotal Period Total,Original Allocation Decimal yes CurrentAllocation Current Allocation Decimal yes yes CurrentAllocationTotal Period Total,Current Allocation Decimal yes Orders Orders Decimal yes yes OrdersTotal Period Total,Orders Decimal yes RemainingAllocation Remaining Allocation Decimal yes yes RemainingAllocationTotal Period Total,Remaining Allocation Decimal yes UnallocatedOrders Unallocated Orders Decimal yes yes UnallocatedOrdersTotal Period Total,Unallocated Orders Decimal yes Unallocated Unallocated Forecast Decimal yes yes UnallocatedTotal Period Total,Unallocated Forecast Decimal yes MTDHistory MTD History Decimal yes yes MTDHistoryTotal Period Total,MTD History Decimal yes

LiveAllocationDemands Allocation Demands

field caption type transformColumn transformFormat transformable showTotal Description Description String Period Period Month Allocation Allocation Decimal yes Orders Orders Decimal yes UnallocatedOrders Unallocated Orders Decimal yes

LiveAllocation-Orders Order Lines

field caption type transformColumn transformFormat transformable showTotal Id Integer OrderLineId Integer OrderCode Order Code String lineNoCode Line No String Direction Direction String Destination Destination string Source Source string MaterialCode Material Code string DeliveryDate Delivery Date Date DespatchDate Despatch Date Date FinalWeight Weight decimal OrderLineStatusName Status string

LiveAllocationSources Allocation Sources

field caption type transformColumn transformFormat transformable showTotal SourcePeriod Source Period Month WorkcentreName Source String WorkCentreTypeDesc Stage String OperationTypeName Operation Type String Allocation Allocation Decimal yes Orders Orders Decimal yes UnallocatedOrders Unallocated Orders Decimal yes

LiveAllocationStatistics Demand Control Statistics

field caption type transformColumn transformFormat transformable showTotal Id Integer AllocationMTD Allocation vs MTD Decimal IndicativesMTD Indicatives vs MTD Decimal AllocationOrders Allocation vs Orders Decimal IndicativesOrders Indicatives vs Orders Decimal

LiveAllocationTransportation Transportation

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Period Month yes {0:yyyy-MM-dd} MinCapacity Min Capacity Decimal yes yes MaxCapacity Max Capacity Decimal yes yes Allocation Allocation Decimal yes yes Orders Orders Decimal yes yes AllocatedDemand Allocated Demand Decimal yes yes RemainingCapacity Remaining Capacity Decimal yes yes

ProjectedInventory Projected Inventory

field caption type transformColumn transformFormat transformable showTotal DateFrom Period Date SiteName Site String yes Opening Opening Decimal yes ProductionOrders Production Decimal yes Deliveries Deliveries Decimal yes Closing Closing Decimal yes

SiteInventory

field caption type transformColumn transformFormat transformable showTotal Id Decimal DateFrom Period Month yes {0:yyyy-MM-dd} Opening Opening Decimal yes yes Produced Confirmed Production Decimal yes yes Incoming STO Incoming Decimal yes yes UnallocatedRunCapacity Unallocated capacity Decimal yes yes RemainingAllocation Remaining Allocation Decimal yes yes Dispatched Customer Orders Decimal yes yes Outgoing STO Outgoing Decimal yes yes Closing Closing Decimal yes yes

SkuAllocationBySite Sku Allocation by site

field caption type transformColumn transformFormat transformable showTotal SiteCode Site Code String SiteName Site Name String Allocation Allocation Decimal

SkuAllocations Sku Allocations

field caption type transformColumn transformFormat transformable showTotal SiteMaterialUsageId Integer MessageLocationCode String MessageProductCode String MessageEndUseCode String MessageEndCustomerCode String CheckBox Integer LocationCode Location Code String LocationName Location Name String MaterialCode Product Code String MaterialName Product Name String EndCustomerName End Customer Name String EndCustomerCode End Customer Code String EndUseCode EndUse Code String EndUseDescription EndUse Description String MtdHistory MTD History Decimal true MtdAllocation Mtd Allocation Decimal true Proposal Proposal Decimal true Difference Difference Decimal true Allocation Allocation Decimal true DateFrom Month Month yes {0:yyyy-MM-dd} MonthlyAllocation Monthly Allocation Decimal true true

SnapshotAllocation Snapshot Allocation

field caption type transformColumn transformFormat transformable showTotal Id Integer Period Period Month yes {0:yyyy-MM-dd} Allocation Allocation Decimal yes yes

SupplierInventory Supplier Inventory

field caption type transformColumn transformFormat transformable showTotal Id Integer BackOrders Back Orders Decimal yes OHStock OH Stock Decimal yes Consumption Consumption Decimal yes MTDHistory MTD History Decimal yes DateFrom Period Month yes {0:yyyy-MM-dd} Indicatives Indicatives Decimal yes yes OriginalAllocation Original Allocation Decimal yes yes CurrentAllocation Current Allocation Decimal yes yes Orders Orders Decimal yes yes

top

LiveAllocationChanges

LiveAllocationChanges

field caption type transformColumn transformFormat transformable showTotal UserName User Name string DeliveryMonth Delivery Month Month DeliveryWeek Delivery Week Date SourceMonth Source Month Month SourceWeek Source Week Date Period Period String InitValue Value, Original Decimal LastValue Value, New Decimal UnitName Unit string AllocationComment Comment string Reason Reason string UpdateDate Update Date DateTime CommentLink CommentLink string

top

MandatorySettings

MandatorySettings

field caption type transformColumn transformFormat transformable showTotal Id Id Integer

top

MFASetupNo gridstop

MinimumAllocations

MinimumAllocation

field caption type transformColumn transformFormat transformable showTotal Id Id Integer Allocation Min Allocation Decimal

top

ModelingNo gridstop

MPExcludeFromPrenettingNo gridstop

NavigationsConfigNo gridstop

ObsoleteData

PurgeObsoleteData

field caption type transformColumn transformFormat transformable showTotal Id Integer Name Name String Description Description String Period Period to keep logs Integer PeriodType Period Type String LastAnalyzed Last Analyzed DateTime ObsoleteEntries Obsolete entries Integer

top

OnHandStock

OnHandMovements

field caption type transformColumn transformFormat transformable showTotal id Integer OrderCode Order Number string LineNoCode Line Number string OrderType Order type string FinalWeight Order Quantity decimal DeliveryCode Delivery Number string Direction Direction string Source Source / Destination string MovementDate Movement Date Date DispatchDate Dispatch Date Date RequestedDate Requested Date Date DeliveryDate Delivery Date Date Quantity Quantity decimal yes MovementType Movement Type string Status Status string

OnHandStock On-Hand Stock

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteMaterialUsageId Integer ConsignmentLocationId Integer MaterialCode Product Code String MaterialName Product Name String LocationCode Warehouse Code String LocationName Warehouse Name String ConsignmentCustomerCode Customer Code String ConsignmentCustomerName Customer Name String ProductProperties String InitialOpening Initial Opening Decimal true ActualIn Actual,In Decimal true ActualOut Actual,Out Decimal true OnHandStock On-Hand Stock Decimal true AllocatedStock Allocated Stock Decimal true OnHandStockAvailable On-Hand Available Stock Decimal true InitialOrdersIn Planned,Incoming Decimal true InitialOrdersOut Planned,Outgoing Decimal true DateFrom Date Date yes {0:yyyy-MM-dd} Opening Opening Decimal yes OrdersIn Planned,Incoming Decimal yes OrdersOut Planned,Outgoing Decimal yes Closing Closing Decimal yes MinClosing Min. Closing Decimal yes

top

OrderMaintenance2

AmendConsignmentOrders Amend consignment orders

field caption type transformColumn transformFormat transformable showTotal Id Integer OrderLineId Integer SkuId Integer MaterialRunId Integer OriginalWeight Decimal Modified Integer LineNo Line No String MaterialCode Product String IsForecasted Is Forecasted Integer Quantity Quantity Decimal Weight Weight Decimal BlockRunCode RunCode String Capacity Run Capacity Decimal AvailableCapacity Available Capacity Decimal TotalOrderWeight Total Order Weight Decimal FreeCapacity Remaining Capacity Decimal ForDelete Is Removed Integer

ConsignmentReplenishmentOrders Consignment orders from excel

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreCode Workcentre Code String BlockCode Block Code String RunCode Run Code String ProductCode Product String CustomerCode Customer String Quantity Quantity Decimal Unit Unit String RunCapacity Run Capacity Decimal RunAvailableCapacity Available Capacity Decimal RunRemainingCapacity Remaining Capacity Decimal IsValid Is Valid Boolean ErrorMessages Errors String

OrderMaintenance Order Maintenance

field caption type transformColumn transformFormat transformable showTotal Id Integer SkuId Integer CustomerId Integer OrderLineId Integer MaterialRunId Integer OrderBookId Integer OriginalWeight Decimal AlternateCode2 String OrderNo Order No String LineNo Line No String Warehouse Warehouse String Customer Customer String Product Product String Quantity Quantity Decimal Weight Weight Decimal DeliveryDate Delivery Date Date Source Source String FreeCapacity Free Capacity Decimal CreateUserName Create User String CreateDateTime Create Date Time DateTime UpdateUserName Update User String UpdateDateTime Update Date Time DateTime

top

OrdersByInquiry

Deliveries Deliveries

field caption type transformColumn transformFormat transformable showTotal Id Integer DeliveryCode Delivery Code String AlternativeKey Alternative Key String ShipDate Ship Date DateTime DueDate Due Date DateTime ReceivedDate Received Date DateTime OriginalWeight Original Weight Decimal Weight Weight Decimal SourceWeight Source Weight Decimal StatusName Status String ReATPOrderCode ReATP OrderCode String ReATPOrderLine ReATP OrderLine String CreateUser Create User String CreateDate Create Date DateTime UpdateUser Update User String UpdateDate Update Date DateTime

OrderInputMaterials Order Input Materials

field caption type transformColumn transformFormat transformable showTotal OperationNo Operation No String OperationTypeName Operation Type String WorkcentreName Workcentre String WorkcentreCode Workcentre code String Quantity Quantity Decimal RemainingQuantity Remaining Quantity Decimal MaterialName Input Material name String MaterialCode Input Material code String

OrderOperations Order Operations

field caption type transformColumn transformFormat transformable showTotal Id Integer MaterialRunId Integer OrderLineId Integer OperationNo Operation No String WorkcentreName Workcentre String BlockRunCode Run,Code String StartDate Run,Start Date DateTime FinishDate Run,Finish Date DateTime StartTime Operation,Start Time DateTime FinishTime Operation,Finish Time DateTime Weight Quantity Decimal WeightComplete Quantity Complete Decimal OperationDuration Duration TimeSpan Rate Operation Rate Decimal ProcessDuration Process duration TimeSpan OrderLineStatusName Status String MaterialCode Production Product,Code String MaterialName Production Product,Name String

OrdersInquiry Orders Inquiry

field caption type transformColumn transformFormat transformable showTotal Id Integer LineNoCode Line No String OrderCode Order Code String OrderType Order Type String AlternateCode1 Alternate Code 1 String AlternateCode2 Alternate Code 2 String OrderLineStatusName Status String Quantity Quantity Decimal SourceQuantity Source Quantity Decimal RemainingQuantity Remaining Quantity Decimal AllocatedStock Allocated Stock Decimal DeliveredQuantity Delivered Quantity Decimal Price Price Decimal RequestedDate Requested Date Date ConfirmedDate Confirmed Date Date FullyAllocatedDate Confirm Availability Date Date DeliveryDate Delivery Date Date DespatchDate Despatch Date Date ProductionDate Production Date Date ProductionStartDate Production Start Date Date FinishingSite Finishing Site String LocationCode Customer Code String LocationName Customer Name String DestinationLocationCode Destination Code String DestinationLocationName Destination String MaterialCode Product Code String MaterialName Product String ProductProperties String SourceCSCustomerCode Source Consignment Customer Code String SourceCSCustomer Source Consignment Customer String DestinationCSCustomerCode Destination Consignment Customer Code String DestinationCSCustomer Destination Consignment Customer String Source Source String Lateness Lateness Integer AllowSubstitution Allow Substitution Integer ExMillDate Ex Mill Date Date PMRun Run String IsPaymentHold Payment Hold Integer ReasonId Reason Code Priority Priority Integer CreateUser Created by User String CreateDate Created at DateTime UpdateUser Updated by User String UpdateDate Updated at DateTime

ProductionUpdate Production Update

field caption type transformColumn transformFormat transformable showTotal Id Integer OrderOperationId Order Operation Id String ProductionDate Production Date Date {0:yyyy-MM-dd} Quantity Quantity Decimal QuantityType Quantity Type String UpdateDate Update Date DateTime {0:yyyy-MM-dd HH:mm}

top

Prices

ExplainedNominalCosts Explained NominalCosts

field caption type transformColumn transformFormat transformable showTotal Id Integer Description Rule properties String Effective Effective Date Priority Priority Integer Cost Cost Decimal

ExplainedPrices Explained Prices

field caption type transformColumn transformFormat transformable showTotal Id Integer Description Rule properties String Effective Effective Date Priority Priority Integer Price Price Decimal CurrencyName Currency String

NominalCostRules NominalCostRules

field caption type transformColumn transformFormat transformable showTotal Id Integer Effective Effective Date Cost Cost Decimal RuleWeighting Rule Weighting Integer CurrencyName Currency String

NominalCosts NominalCosts

field caption type transformColumn transformFormat transformable showTotal SiteMaterialUsageId Integer LocationName Location String MaterialName Material String EndUse EndUse String EndCustomer EndCustomer String DateFrom Effective Date Cost Cost Decimal CurrencyName Currency String

PriceRules PriceRules

field caption type transformColumn transformFormat transformable showTotal Id Integer Effective Effective Date Price Price Decimal RuleWeighting Rule Weighting Integer CurrencyName Currency String IsActive Is Active Integer

Prices Prices

field caption type transformColumn transformFormat transformable showTotal SiteMaterialUsageId Integer LocationName Location String LocationCode Location Code String MaterialName Material String MaterialCode Material Code String EndUse EndUse String EndUseCode EndUse Code String EndCustomer EndCustomer String EndCustomerCode EndCustomer Code String DateFrom From Date DateTo To Date Price Price Decimal CurrencyName Currency String RulePrice Rule Price Decimal RuleCurrencyName Rule Currency String IsActive Is Active Integer Note Note

top

ProductionOptimisationNo gridstop

ProductionOrders

LiveCampaignOrders Orders

field caption type transformColumn transformFormat transformable showTotal SkuId Integer ConsignmentId Integer Id Integer NonManipulated Integer IsCustomer Integer Replenished Integer OrderOperationId Integer IsRemovable Integer MaterialRunId Integer IsFilterSelected Integer OrderCode Order Code String LineNoCode Order Line No String LocationName Customer String ToConsignmentLocationName Consignment Customer String Status Order Line Status String OrderProductCode Order Product,Code String OrderProductName Order Product,Name String ProductProperties String WeightTentative Sales Weight,Tentative Decimal yes WeightFirm Sales Weight,Firm Decimal yes AllocatedStock Sales Weight,Allocated Stock Decimal yes DeliveredWeight Sales Weight,Delivered Decimal yes QuantityTentative Sales Quantity,Tentative Integer yes QuantityFirm Sales Quantity,Firm Integer yes UnitName Sales Quantity,Unit String AllocatedStockQuantity Sales Quantity,Allocated Stock Decimal yes DeliveredQuantity Sales Quantity,Delivered Decimal yes DespatchDate Despatch Date Date DeliveryDate Delivery Date Date ConfirmedDate Confirmed Date Date FullyAllocatedDate Confirm Availability Date Date RequestedDate Requested Date Date ProductionStartDate Production Start Date Date Transport Transport String Priority Priority ReasonId Reason Code IsPaymentHold Payment Hold Integer OperationNo Operation No OrderOperationStatus Operation Status String ProductionProductCode Production Product,Code String ProductionProductName Production Product,Name String OperationWeightTotal Production Weight,Total Decimal yes OperationWeightRemaining Production Weight,Remaining Decimal yes OperationQuantityTotal Production Quantity,Total Integer yes OperationQuantityRemaining Production Quantity,Remaining Integer yes OperationUnitName Production Quantity,Unit String OperationDurationTotal Production Duration,Total TimeSpan yes OperationDurationRemaining Production Duration,Remaining TimeSpan yes

ParseOrders Parse Orders

field caption type transformColumn transformFormat transformable showTotal Id Integer MaterialCode Material Code String Weight Weight Decimal Quantity Quantity Decimal CustomerCode Customer Code String Status Status String JourneyId Integer StatusId Integer SkuId Integer ConsignmentId Integer IsFailed Integer

ProductionRuns Production Runs

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkCentreCode WorkCentre Code String WorkCentreName WorkCentre Name String RunCode Run Code String StartDate Start DateTime FinishDate Finish DateTime ProductionUpdateTimeStamp Production update time DateTime TargetStartDate Target DateTime RunType Run Type String SwitchoverDuration Switchover Duration TimeSpan Properties Run Properties String ProcessRate Process Rate Decimal NominalCapacity Nominal Capacity Decimal RunCapacity Capacity Decimal FirmOrders Firm Orders Decimal AvailableCapacity Available Decimal TentativeOrders Tentative Orders Decimal FreeCapacity Free Capacity Decimal RunDuration Duration TimeSpan ShutDuration Shut Duration TimeSpan FirmOrdersDuration Firm Orders Duration TimeSpan AvailableDuration Available Duration TimeSpan TentativeOrdersDuration Tentative Orders Duration TimeSpan FreeDuration Free Duration TimeSpan RunStatusName Status String RunStatusCode String

UploadedProductionOrders Uploaded Production Orders

field caption type transformColumn transformFormat transformable showTotal MaterialRunId Integer UnitId Integer LocationId Integer WorkCentreId Integer FinishDate DateTime SiteId Integer DueDate DateTime WarehouseCode Destination String ProductCode Material Code String Quantity Quantity Decimal IsOverbooked Is Overbooked Boolean IsValid Is Valid Boolean ErrorMessages Errors String

top

ProductionPlanNo gridstop

ProductionPlanningNo gridstop

Products

BOM BOM

field caption type transformColumn transformFormat transformable showTotal Id Integer BOMCode BOM Code String

CoProducts CoProduct

field caption type transformColumn transformFormat transformable showTotal Id Integer CoProductMaterialId Integer MaterialName CoProductName MaterialCode CoProductCode String Percentage Percentage Decimal PricePercentage PricePercentage Decimal

CycleTypes Cycle types

field caption type transformColumn transformFormat transformable showTotal Id Integer DetailId Integer Priority Priority String Frequency Frequency (weeks) Integer WeekTolerance Week Tolerance Integer ProducingDay ProducingDay Integer GroupName Group String FixedPeriodInWeeks Fixed Period In Weeks Integer

DerivedCharacteristicRules Derived Characteristics Rules

field caption type transformColumn transformFormat transformable showTotal Id Integer ReportFilterId Integer CharacteristicName Characteristic Name String CharacteristicValue Characteristic Value String RuleWeighting Rule Weighting Integer Filter Filter String

EndUses End uses

field caption type transformColumn transformFormat transformable showTotal Id Integer EndUseCode Code String EndUseDescription Description String

OperationTypeConversions Operation Type Conversions

field caption type transformColumn transformFormat transformable showTotal Id Integer OperationTypeId Integer InputUnitId Integer OutputUnitId Integer OperationTypeName Operation Type String InputUnitDescription Input Unit String OutputUnitDescription Output Unit String Multiplier Multiplier Decimal Divider Divider Decimal

ProductCharacteristics Product Characteristics

field caption type transformColumn transformFormat transformable showTotal Id Integer

ProductionConfigurationBom Production Configuration Bom

field caption type transformColumn transformFormat transformable showTotal Id Integer BomId Integer MaterialId Integer OperationTypeId Integer WorkCentreTypeId Integer InputUnitId Integer OutputUnitId Integer BomCode BOM Code String MaterialCode Material Code String MaterialName Material Name String OperationTypeName Operation Type Name String WorkCentreTypeDesc Workcentre Type Description String InputUnit Input Unit String OutputUnit Output Unit String Multiplier Multiplier Decimal Divider Divider Decimal

ProductionConfigurations Production Configurations

field caption type transformColumn transformFormat transformable showTotal Id Integer ProductRouteId Integer BomId Integer ProductRouteName Route Name String Site Site String Preferred Preferred Boolean BomCode BOM Code String

ProductionConfigurationStages Production Configuration stages

field caption type transformColumn transformFormat transformable showTotal Id Integer OperationTypeId Integer WorkcentreTypeId Integer ValidSourcesId String PrimaryValidSourcesId String OperationTypeConversionId String OrderNo Order No Integer StageCode Stage Code String OperationTypeName Operation Type String WorkcentreTypeName Workcentre Type String ApplyCyclePlan Apply Cycle Plan Integer StoreOutput Store Output Integer CreateCampaign Create Campaign Integer InputUnitId Input Unit OutputUnitId Output Unit Multiplier Multiplier Decimal Divider Divider Decimal ValidSources Valid Sources String PrimaryValidSources Primary Valid Sources String isLastCoProductStage Is Last Coproduct stage Integer

ProductRoutes Product routes

field caption type transformColumn transformFormat transformable showTotal Id Integer IsUsed Integer ProductRouteName Name String

ProductRouteStages Product route stages

field caption type transformColumn transformFormat transformable showTotal Id Integer ProductRouteId Integer OrderNo Stage No Integer StageCode Code String OperationTypeId Operation Type StoreOutPut StoreOutput Boolean CreateCampaign Create Campaign Boolean

Products Products

field caption type transformColumn transformFormat transformable showTotal Id Integer IsCoProduct Integer MaterialCode Code String MaterialName Name String MaterialTypeName Type String ProductRoutes Product Routes String SourceMaterialName Source Material String SourceMaterialTypeName Source Material Type String ForecastStartDate Forecast Start Date Date ForecastFinishDate Forecast Finish Date Date ReplenishmentStartDate Replenishment Start Date Date ReplenishmentFinishDate Replenishment Finish Date Date

ProductSubstitutions Product substitutions

field caption type transformColumn transformFormat transformable showTotal Id Integer MaterialTypeName Material Type String OriginalSiteName Original Site String SubstitutionSiteName Substitution Site String IsActive Is Active Integer IncludeFilter Customer,Include String ExcludeFilter Customer,Exclude String

ProductUnits Product units

field caption type transformColumn transformFormat transformable showTotal Id Integer IsEditable Integer UnitId Unit Dividend Dividend Decimal Divisor Divisor Decimal

top

ProgramTemplates

BSOProgramTemplates Program templates

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkCentreTypeDesc WorkCentreType String ProgramName Name String IsWeightUse Use Weight Integer AutoSizeRunDuration Capacity, Auto-size run Integer Duration Capacity, Duration TimeSpan Weight Capacity, Weight Decimal FixOppRuns Fix Opp. Runs Integer OppRunDuration Opp. Run Duration TimeSpan Assigned Assigned to Workcentres String WorkCentreTypeId Integer IsReadOnly Integer

top

QuickReportsNo gridstop

Reasons

Reasons

field caption type transformColumn transformFormat transformable showTotal Id Id Integer Reason Code String ReasonType Type String ReasonDescription Description String Used Used Integer

top

ReportBuilder

DataSourceFieldGroups

field caption type transformColumn transformFormat transformable showTotal FieldGroup Field Group String

DataSourceFields

field caption type transformColumn transformFormat transformable showTotal Id Integer OrderNo Integer ExcelFieldName String DataSourceId Integer Editable Integer EntityTypeClass String EntityTypeColor String Included Included Integer Name Field Name String Description Description String DataType Data Type String EntityType Entity Type String UnitTypeId Unit Type Integer UnitId Unit Integer IsCurrency Is Currency Integer IsMandatory Is Mandatory Integer

DataSources

field caption type transformColumn transformFormat transformable showTotal Id Integer Title Data Source String Description Description String

PersonalReports

field caption type transformColumn transformFormat transformable showTotal Id Integer ReportName Title String DataSourceName Data Source String IsPublished Published Integer IsLocked Locked Integer DefaultFilter Default Filter String IsMandatoryFilter Filter Mandatory Integer IsAssignRole Integer

SharedReports

field caption type transformColumn transformFormat transformable showTotal Id Integer Title Title String Description Description String UserName Author String DefaultFilter Default Filter String

top

Reporting

AdminDataSources

field caption type transformColumn transformFormat transformable showTotal Id Integer UserId UserId Integer Title Title String Description Description String Category Category String Creator Creator String AccessRights Access Rights level String CurrencyDateField Currency Date Field String AllowProductUnits Allow Product units Integer Roles Assigned Roles String

AssignedReportColumns

field caption type transformColumn transformFormat transformable showTotal Name String Assigned Assigned Integer Description Fields String DataType String

AssignedReportRoles

field caption type transformColumn transformFormat transformable showTotal Id Integer RoleName Role String Assigned Assigned Integer

DataSourcesRoles

field caption type transformColumn transformFormat transformable showTotal Id Integer RoleDescription Role String Assigned Assigned Integer

ReportFilters

field caption type transformColumn transformFormat transformable showTotal Id Integer Name Name String IsShared Shared Integer UserName User String Tooltip Criteria String

RoleDataSources

field caption type transformColumn transformFormat transformable showTotal Id Integer Title Report String Assigned Assigned Integer

RoleReports

field caption type transformColumn transformFormat transformable showTotal Id Integer Assigned Assigned Integer Title Report String Owner Owner String

SystemReports

field caption type transformColumn transformFormat transformable showTotal Id Integer Title Report String Owner Owner String

WidgetRoles

field caption type transformColumn transformFormat transformable showTotal Id Integer RoleDescription Role String Assigned Assigned Integer

top

SACyclePlanNo gridstop

SADemand

OldSADemandAnalysis SA Demand Analysis

field caption type transformColumn transformFormat transformable showTotal SnpItemId Id Integer Description Description String DateFrom Date Date SiteName Site string WorkCentreName PM string Reasons Problem String HasInitialSource Has Initial Source integer HasRoute Has Route integer HasRate Has Rate integer HasCost Has Cost integer HasPrice Has Price integer IsMandatoryDemand Is Mandatory integer IsProfitable Is Profitable integer HasCapacity Has Available Capacity integer Price Price decimal Cost Production Cost decimal RouteType Route Type String TransportCost Transport Cost decimal TimePeriod Transport Time integer MarginPerHour Margin per hour decimal Demand Demand decimal Allocation Allocation decimal

SADemand SA Demand

field caption type transformColumn transformFormat transformable showTotal Id Integer AllocationStatusCssClass String Forecast Demand,Forecast Decimal yes yes FirmOrders Demand,Orders Decimal yes yes DemandNettedForecast Demand,Netted Forecast Decimal yes yes Price Demand,Price Decimal yes no AllocationNettedForecast Allocation,Netted Forecast Decimal yes yes AllocationAllocated Allocation,Allocated Decimal yes yes UnallocatedForecast Allocation,Unallocated Decimal yes yes Revenue Revenue Decimal yes yes Cost Cost Decimal yes yes Margin Margin Decimal yes yes UnallocatedRevenue Unallocated Revenue Decimal yes yes MarginWeight Margin / Weight Decimal yes yes DateFrom Period Month yes {0:yyyy-MM-dd}

SADemandAnalysis SA Demand Analysis

field caption type transformColumn transformFormat transformable showTotal SnpItemId Integer ProductionConfigurationId Integer Description Description String ProductRoute Production Configuration String DateFrom Date Date ReasonName Reason String Demand Demand decimal Allocation Allocation decimal CycleFrequency Cycle Frequency Integer FirstDeliveryPeriod First Delivery Period Date Price Price decimal Cost Production Cost decimal TransportCost Transport Cost decimal LeadTime Transport Time integer MarginPerHour Margin per hour decimal IsMandatory Is Mandatory integer IsProfitable Is Profitable integer HasRates Has Rate integer HasCosts Has Cost integer HasPrice Has Price integer HasCapacity Has Available Capacity integer

SADemandAnalysisSources SA Demand Analysis Sources

field caption type transformColumn transformFormat transformable showTotal SnpItemId Id Integer SiteName Site string WorkcentreName Workcentre string OperationTypeName Operation Type string HasSite Has Site integer HasRoute Has transport route integer HasRate Has Rate integer HasCost Has Cost integer HasCapacity Has Available Capacity integer HasValidSource Is Valid Source integer Rate Rate Decimal Cost Cost Decimal Description Reason String

SADemandBySource SA Demand by Source

field caption type transformColumn transformFormat transformable showTotal Id Integer SourceDate Source Period Month Allocation Allocation Decimal yes Orders Orders Decimal yes TotalWeight Total Weight Decimal yes DemandDate Demand Period Month yes {0:yyyy-MM-dd}

SADemandSNPAnalysisSources SA Demand SNP Analysis Sources

field caption type transformColumn transformFormat transformable showTotal ChainNo Variant Integer SiteName Site string WorkcentreName Workcentre string OperationTypeName Operation Type string SourceDate SourcePeriod string Rate Rate Decimal Cost Cost Decimal

SADemandSources SA Demand Sources

field caption type transformColumn transformFormat transformable showTotal SourcePeriod Source Period Month Source Source String SourceGrade Source properties String IsSubstituted Is Substituted Integer OperationTypeName Operation Type String WorkCentreTypeDesc Stage String ConstrainedForecast Constrained Forecast Decimal yes ConstrainedDemand Constrained Demand Decimal yes FirmOrders Orders Decimal yes RemainingFirmOrders Remaining Orders Decimal yes ProductionCost Production Cost Decimal yes TransportCost Transport Cost Decimal yes InventoryCost Inventory Cost Decimal yes TotalCost Total Cost Decimal yes

SADemandWarehouses SA Demand Warehouses

field caption type transformColumn transformFormat transformable showTotal Id Integer AllocationStatusCssClass String Inventory Stock recovery Decimal yes yes InventoryDeficit Inventory Deficit Decimal yes yes DemandNettedForecast Demand Decimal yes yes AllocationAllocated Allocated Decimal yes yes UnallocatedForecast Unallocated Decimal yes yes Price Price Decimal yes no Revenue Revenue Decimal yes yes Cost Cost Decimal yes yes Margin Margin Decimal yes yes UnallocatedRevenue Unallocated Revenue Decimal yes yes MarginWeight Margin / Weight Decimal yes yes DateFrom Period Month yes {0:yyyy-MM-dd}

SASNPDemandAnalysis SA SNP Demand Analysis

field caption type transformColumn transformFormat transformable showTotal SnpItemId Integer Description Description String DateFrom Date Date ReasonName Reason String Demand Demand decimal Allocation Allocation decimal FirstDeliveryDate First Delivery Period Date Price Price decimal TotalCost Min. Total Cost decimal TransportCost Min. Transport Cost decimal TransportTime Min. Transport Time integer IsMandatory Is Mandatory integer

top

SAForecasting

SAForecasting SA Forecasting

field caption type transformColumn transformFormat transformable showTotal Id Integer Period Period Month yes {0:yyyy-MM-dd} System Original Decimal yes yes Customer Scenario Decimal yes yes MandatoryDemand Min. Allocation Decimal yes yes Price Price Decimal yes

top

SAProductSubstitutions

SAProductSubstitutionPeriods Scenario product substitutions

field caption type transformColumn transformFormat transformable showTotal DateFrom Period Date IsActive IsActive Integer

SASubstitutionConstraints Scenario substitution constraints

field caption type transformColumn transformFormat transformable showTotal Id Integer OriginalSiteId Integer SubstitutionSiteId Integer OriginalSiteName Original Site String SubstitutionSiteName Substitution Site String StartPeriod Period Date yes {0:yyyy-MM-dd} Weight Weight Decimal yes

ScenarioProductSubstitutions Scenario product substitutions

field caption type transformColumn transformFormat transformable showTotal Id Integer MaterialTypeName Material Type String OriginalSiteName Original Site String SubstitutionSiteName Substitution Site String IncludeFilter Customer,Include String ExcludeFilter Customer,Exclude String IsRuleActive Active Integer DateFrom Period Date yes {0:yyyy-MM-dd} IsActive Active Integer yes

top

SAReference

ScenarioCycleFrequency SA Cycle Frequency

field caption type transformColumn transformFormat transformable showTotal Id Integer CycleType Cycle Type String Frequency Frequency Integer FixedPeriodInWeeks Fixed Period In Weeks Integer MaxOrderPeriodFixed Max Order Period Fixed Week MinOrderPeriodPostFixed Min Order Period Post Fixed Week MaxRunPeriod Max Run Period Week ScenarioFixedPeriodDate Scenario Fixed Period Week Week CycleFixedPeriodDate Cycle Fixed Period Week Week FirstPeriodDate First Week Week DateFrom DateFrom Week yes {0:yyyy-MM-dd} HasOrder Has Order String yes HasRun Has Run String yes IsActive Is Prod. Period String yes

ScenarioCycleTypes SA Cycle Types

field caption type transformColumn transformFormat transformable showTotal Id Integer Priority Priority String Frequency Frequency Integer WeekTolerance Week Tolerance Integer ProducingDay ProducingDay Integer GroupName Group String FixedPeriodInWeeks Fixed Period In Weeks Integer

ScenarioHoldingCosts SA Holding Costs

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteName Site Name String DateFrom DateFrom Week yes {0:yyyy-MM-dd} HoldingCost Holding Cost Decimal yes

ScenarioInitialSources Initial Sources

field caption type transformColumn transformFormat transformable showTotal Id Integer DetailId Integer WorkCentres Workcentres String Sites Sites String

ScenarioMasterRoutes Master Routes

field caption type transformColumn transformFormat transformable showTotal Id Integer MasterRouteId Integer ScenarioId Integer FromSiteId Integer ScenarioSessionId Integer DetailId Integer SiteName From Site String RuleWeighting Rule Weighting Integer TimePeriod Duration Integer Cost Cost Decimal MinCapacity Min. Capacity Decimal MaxCapacity Max. Capacity Decimal IsActive Is Active Integer

ScenarioMaterialRuns SA Material Runs

field caption type transformColumn transformFormat transformable showTotal WorkCentreName WorkCentre String WorkCentreCode WorkCentre Code String BlockRunCode BlockRun Code String StartDate Start Date DateTime FinishDate Finish Date DateTime CycleType Cycle Type String IsFixed Is Fixed Integer IsActive Is Active Integer

ScenarioProductionCosts SA Holding Costs

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer DetailId Integer OperationTypeId Integer WorkcentreName Workcentre String OperationTypeName Operation Type String DateFrom DateFrom Week yes {0:yyyy-MM-dd} Cost Production Cost Decimal yes

ScenarioProductionRates SA Production Rates

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer DetailId Integer OperationTypeId Integer SiteName Site Name String WorkCentreName WorkCentre Name String OperationTypeName Operation Type String DateFrom DateFrom Week yes {0:yyyy-MM-dd} Rate Rate Decimal yes TimeEfficiency Time Efficiency Decimal yes MaterialEfficiency Material Efficiency Decimal yes EffectiveRate Effective Rate Decimal yes

ScenarioSafetyStock SA safety stock

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteId Integer SiteName Site String DateFrom DateFrom Week yes {0:yyyy-MM-dd} Percentage Percentage Decimal yes

ScenarioTimeEfficiency Workcentre time efficiency

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer SiteName Site Name String WorkcentreName Workcentre Name String DateFrom DateFrom Week yes {0:yyyy-MM-dd} RoughTimeEfficiency Machine Time Efficiency Decimal yes

ScenarioTransportRoutes Master Routes

field caption type transformColumn transformFormat transformable showTotal Id Integer TransportRouteId Integer ScenarioId Integer FromSiteId Integer ToSiteId Integer ScenarioSessionId Integer IsActive Active Integer FromSiteName From Site String ToSiteName To Site String TimePeriod Duration Integer Cost Cost Decimal MaxCapacity Max. Capacity Decimal

ScenarioWorkCentreParameters SA WorkCentre Parameters

field caption type transformColumn transformFormat transformable showTotal WorkCentreId Integer SiteName Site Name String WorkCentreName WorkCentre Name String ExcludeFromSA Exclude from SA Scenarios Integer IdleCost Idle Time Cost Decimal

top

SAShutdowns

SAWorkcentreShuts Workcentre shuts

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteName Site String WorkcentreName Workcentre String StartDate Start Date DateTime FinishDate Finish Date DateTime ShutCode Code String Description Description String

UploadSAWorkcentreShutsGrid Workcentre shuts

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer WorkCentreCode WorkCentreCode String StartDate Start Date String FinishDate Finish Date String ShutCode Code String Description Description String IsValid Is Valid Boolean ErrorMessages Errors String

top

SASNPStock

SASkuInventorySourcing SA Inventory Sourcing

field caption type transformColumn transformFormat transformable showTotal Id Integer LocationName Location Name String LocationCode Location Code String MaterialName Product Name String MaterialCode Product Code String Replenished Replenished String DateFrom Period Month yes {0:yyyy-MM-dd} InitialInventory Initial Inventory Decimal yes yes Stock Stock Decimal yes yes SafetyStock Safety Stock Decimal yes yes Deficit Deficit/Surplus Decimal yes yes InventoryDeficit Inventory Deficit Decimal yes yes Allocation Consumed stock Decimal yes yes RestoredAllocation Restored stock Decimal yes yes IsProductionPeriod Production period Integer yes

top

SASourcing

SAInventorySourcing SA Inventory Sourcing

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Period Month yes {0:yyyy-MM-dd} Capacity Capacity Decimal yes yes TotalInventory Total Inventory Decimal yes yes AvailableInventory Available Inventory Decimal yes yes SafetyStock Safety Stock Decimal yes yes Allocation Allocation Decimal yes yes Orders Orders Decimal yes yes Revenue Revenue Decimal yes yes Cost Cost Decimal yes yes Margin Margin Decimal yes yes

SASiteInventory

field caption type transformColumn transformFormat transformable showTotal Id Decimal DateFrom Period Month yes {0:yyyy-MM-dd} Opening Opening Decimal yes yes Produced Confirmed Production Decimal yes yes AllocatedProduction Allocated Production Decimal yes yes UnallocatedRunCapacity Unallocated capacity Decimal yes yes Incoming STO Incoming Decimal yes yes Dispatched Customer Orders Decimal yes yes RemainingAllocation Remaining Allocation Decimal yes yes CustomerAllocation Customer Allocation Dispatch Decimal yes yes Outgoing STO Outgoing Decimal yes yes Closing Closing Decimal yes yes

SASourcing SA Sourcing

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Period Month yes {0:yyyy-MM-dd} Capacity Capacity Decimal yes yes Allocation Allocation Decimal yes yes Orders Orders Decimal yes yes Losses Losses Decimal yes yes AllocatedDemand Allocated Demand Decimal yes yes Utilisation Utilisation Decimal yes yes NominalCapacityHours Nominal capacity duration TimeSpanHour yes yes ShutHours Shut duration TimeSpanHour yes yes CapacityHours Capacity duration TimeSpanHour yes yes OrdersHours Orders duration TimeSpanHour yes yes AllocationHours Allocation duration TimeSpanHour yes yes UnallocatedHours Unallocated duration TimeSpanHour yes yes UnallocatedCapacity Unallocated capacity Decimal yes yes Revenue Revenue Decimal yes yes ProductionCost Production Cost Decimal yes yes TransportCost Transport Cost Decimal yes yes InventoryCost Inventory Cost Decimal yes yes TotalCost Total Cost Decimal yes yes Margin Margin Decimal yes yes Profitability Profitability Decimal yes yes

SASourcingDemands SA Sourcing demand

field caption type transformColumn transformFormat transformable showTotal Description Description String DeliveryDate Period Date ConstrainedForecast Constrained Forecast Decimal yes ProductionCost Production Cost Decimal yes TransportCost Transport Cost Decimal yes InventoryCost Inventory Cost Decimal yes TotalCost Total Cost Decimal yes

SATransportation SA Transportation

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Period Month yes {0:yyyy-MM-dd} MinCapacity MinCapacity Decimal yes yes MaxCapacity MaxCapacity Decimal yes yes Allocation Allocation Decimal yes yes Orders Orders Decimal yes yes AllocatedDemand Allocated Demand Decimal yes yes RemainingCapacity Remaining Capacity Decimal yes yes Revenue Revenue Decimal yes yes ProductionCost Production Cost Decimal yes yes TransportCost Transport Cost Decimal yes yes InventoryCost Inventory Cost Decimal yes yes TotalCost Total Cost Decimal yes yes Margin Margin Decimal yes yes

SAUtilisationDetails SA utilisation details

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteName Site String WorkcentreName Workcentre String Properties Properties String DateFrom Period Week yes {0:yyyy-MM-dd} Allocation Allocation Decimal yes yes Rate Rate Decimal yes false Cost Cost Decimal yes false Hours Hours Decimal yes yes

SNPInventorySourcing SNP Inventory Sourcing

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Period Month yes {0:yyyy-MM-dd} AvailableInventory Available Inventory Decimal yes yes Allocation Allocation Decimal yes yes Orders Orders Decimal yes yes Revenue Revenue Decimal yes yes Cost Cost Decimal yes yes Margin Margin Decimal yes yes

top

SASupplyPlanningNo gridstop

SASupplyPlanningReferenceNo gridstop

ScenarioAnalysisNo gridstop

Scenarios

ScenarioComparison SA Scenario Comparison

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Period Month yes {0:yyyy-MM-dd} ScenarioName Scenario String yes {0} Forecast Forecast Decimal yes IgnoredSmallDemands Ignored small demands Decimal yes RemainingForecast Remaining Forecast Decimal yes FirmOrders Firm Orders Decimal yes ConstrainedDemand Constrained Demand Decimal yes UnallocatedForecast Unallocated Forecast Decimal yes DemandFulfilment Demand Fulfilment % Decimal yes UnallocatedPMCapacity Unallocated Production Capacity Decimal yes Revenue Revenue Decimal yes Cost Cost Decimal yes Margin Margin Decimal yes

top

ScenarioSettingsNo gridstop

SessionsManagement

ScenarioSessions Scenario Sessions

field caption type transformColumn transformFormat transformable showTotal Id Integer UserName User String ReadOnly Is Read-only Integer SessionName Session Name String CreationDate Created DateTime StartWeek Start Week Date FinishWeek Finish Week Date UsedPriceSettings Price Settings String SnapshotName Source data String SnapshotPeriodType Period String

top

SimpleDemandControl

SimpleDemandControl Supply Based Demand Control

field caption type transformColumn transformFormat transformable showTotal Id Integer SourceWeek Period Week yes {0:yyyy-MM-dd} System Original Allocation Decimal yes yes Customer Current Allocation Decimal yes yes Orders Orders Decimal yes yes

top

SitesNo gridstop

Sites

AllChangeOvers ChangeOvers

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer WorkcentreName Workcentre String DateFrom Effective Date Date Cost Cost Decimal Time Time TimeSpan FromGrade From String ToGrade To String

AllHoldingCosts Holding costs

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteId Integer SiteName Site String Effective Effective Date Date HoldingCost Holding Cost Decimal

AllProductionRates Production rates

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer OperationTypeName Operation Type String Effective Effective Date Date ProductionRate Production Rate Decimal EffectiveProductionRate Effective Production Rate Decimal TimeEfficiency Machine Time Efficiency Decimal MaterialEfficiency Material Efficiency Decimal SpecificWeight Specific Weight Decimal ConversionFactor Conversion Factor Decimal IsActive Is Active Integer

AllWorkcentreCapacities WorkCentre capacities

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer SiteName Site String WorkcentreName Workcentre String EffectiveDate Effective Date Date Capacity Capacity Decimal

AllWorkcentrePropertyRanges Workcentre property ranges

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer PropertyId Integer WorkcentreName Workcentre String PropertyDesc Property String RangeFrom From Decimal RangeTo To Decimal

AllWorkcentres All workcentres

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteId Integer IsProductionSource Integer HasInventory Integer WorkCentreTypeName String SiteName SiteName String WorkcentreName Name String WorkcentreCode Code String WorkCentreTypeDesc Type String LocationName Location String AutoConfirmationPeriod Auto-confirmation Period Integer NumberOfWorkcentres No. of physical workcentres Integer IdleCost Idle Time Cost Decimal LineOfAuthority Line Of Authority DateTime

AllWorkcentreShuts Workcentre shuts

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer WorkcentreShutTypeId Integer SiteName Site String WorkcentreName Workcentre String StartDate Start Date DateTime FinishDate Finish Date DateTime ShutCode Code String Description Description String ShutType Type String UseShutInMPOnly Use only in Supply Planning Integer UseOnlyInBSOGantt Use only in BSO Gantt Integer

AllWorkcentreTimeEfficiency WorkCentre time efficiency

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer SiteName Site String WorkcentreName Workcentre String EffectiveDate Effective Date Date RoughTimeEfficiency Machine time efficiency Decimal

ChangeOvers ChangeOvers

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Effective Date Date Cost Cost Decimal Time Time TimeSpan FromGrade From String ToGrade To String

HoldingCosts Holding costs

field caption type transformColumn transformFormat transformable showTotal Id Integer Effective Effective Date Date HoldingCost Holding Cost Decimal

ProductionCosts Production costs

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer SiteName Site String WorkcentreName Workcentre String OperationTypeName Operation Type String Effective Effective Date Date Cost Cost Decimal RuleWeighting Rule Weighting Integer IsActive Is Active Integer

ProductionRates Production rates

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer SiteName Site String SiteCode Site Code String WorkcentreName Workcentre String WorkcentreCode Workcentre Code String Effective Effective Date Date OperationTypeName Operation Type String GrossProductionRate Gross Production Rate Decimal NettProductionRate Production Rate Decimal EffectiveProductionRate Effective Production Rate Decimal TimeEfficiency Time Efficiency Decimal MaterialEfficiency Material Efficiency Decimal SpecificWeight Specific Weight Decimal ConversionFactor Conversion Factor Decimal IsActive Is Active Integer

Sites Sites

field caption type transformColumn transformFormat transformable showTotal Id Integer IsProductionSite Integer SiteName Name String SiteCode Code String SiteType Site Type String TaxRate Tax Rate Decimal Ownership Ownership Decimal SafetyStockMethodDesc Safety Stock method String GroupReplenishedLocations Is grouped for replenishment Integer Latitude Latitude String Longitude Longitude String StandardTransportCost Standard transport cost Decimal

SiteWorkcentres Site workcentres

field caption type transformColumn transformFormat transformable showTotal Id Integer IsProductionSource Integer HasInventory Integer WorkCentreTypeName String WorkcentreName Name String WorkcentreCode Code String WorkCentreTypeDesc Type String LocationName Location String AutoConfirmationPeriod Auto-confirmation Period Integer NumberOfWorkcentres No. of physical workcentres Integer IdleCost Idle Time Cost Decimal LineOfAuthority Line Of Authority DateTime

WorkcentreCapacities WorkCentre capacities

field caption type transformColumn transformFormat transformable showTotal Id Integer EffectiveDate Effective Date Date Capacity Capacity Decimal

WorkcentrePropertyRanges Workcentre property ranges

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer PropertyId Integer PropertyDesc Property String RangeFrom From Decimal RangeTo To Decimal

WorkcentreShuts Workcentre shuts

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkcentreId Integer WorkcentreShutTypeId Integer StartDate Start Date DateTime FinishDate Finish Date DateTime ShutCode Code String Description Description String ShutType Type String UseShutInMPOnly Use only in Supply Planning Integer UseOnlyInBSOGantt Use only in BSO Gantt Integer

WorkcentreTimeEfficiency WorkCentre time efficiency

field caption type transformColumn transformFormat transformable showTotal Id Integer EffectiveDate Effective Date Date RoughTimeEfficiency Machine time efficiency Decimal

top

SKU

CustomerSKU Customer SKUs

field caption type transformColumn transformFormat transformable showTotal SiteMaterialUsageId Integer EndUseId Integer EndCustomerId Integer LocationCode Location Code String LocationName Location Name String MaterialCode Material Code String MaterialName Material Name String AlternateProduct Alternate Material String EndCustomerName End Customer Name String EndCustomerCode End Customer Code String EndUseCode EndUse Code String EndUseDescription EndUse Description String Price Current Price Decimal Status Forecasted Integer ForecastMethodId Forecast Method CustomerRankId Rank LowerPercentile Lower Percentile Decimal UpperPercentile Upper Percentile Decimal HistoryStartDate History Start Date Date ForecastStartDate Forecast Start Date Date ForecastFinishDate Forecast Finish Date Date DefaultCustomerForecast Default Customer Forecast NettingAlgorithm Netting Algorithm ConsumptionType Replenishment Consumption Type DDQContingency DDQ Contingency Integer InhibitProduction Inhibit Production Integer InhibitSFGSearch Inhibit SFG Search Integer Patterns External Trends String SNPExclusionPeriod SNP Forecast Exclusion Period Integer

ForecastMethodsRules Forecast Methods Rules

field caption type transformColumn transformFormat transformable showTotal Id Integer ForecastMethodId Integer DetailId Integer ForecastMethodName Forecast Method String RuleWeighting Rule Weighting Integer

SecondPassRules Second Pass Rules

field caption type transformColumn transformFormat transformable showTotal Id Integer ReportFilterId Integer ForecastMethodName Forecast Method String RuleWeighting Rule Weighting Integer CharacteristicsList Characteristics List String Patterns External Trends String Characteristics Characteristics String

SkuForecastPatterns Sku External trends

field caption type transformColumn transformFormat transformable showTotal Id Integer ForecastPatternId External Trend ForecastPatternDate Trend Start Month Date PatternPositionNo Trend Position No Integer

WHSKU WH SKUs (including CS WH SKUs)

field caption type transformColumn transformFormat transformable showTotal SkuType String SiteMaterialUsageId Integer ConsignmentLocationId Integer LocationCode Location Code String LocationName Location Name String MaterialCode Material Code String MaterialName Material Name String AlternateProduct Alternate Material String ConsignmentLocation Consignment Customer Name String Replenished Replenished CustomerRankId Rank LowerPercentile Lower Percentile Decimal UpperPercentile Upper Percentile Decimal UpperPercentileMethod Upper Percentile Method String UpperPercentileMonths Upper Percentile History Months Integer MaxCapacity MaxCapacity Decimal SafetyStockMethodId Safety Stock Method MaxSafetyStockMethodId Max Safety Stock Method SafetyStockPercentWarning Safety Stock Warning % Decimal LowQuantity Low Quantity Decimal HighQuantity High Quantity Decimal DaysOfSupply Days Of Supply Integer MaxDaysOfSupply Max Days Of Supply Integer ReplenishmentFrequency Replenishment Frequency Integer MaxReplenishmentFrequency Max Replenishment Frequency Integer MinOrderQuantity Min Order Quantity Decimal OrderUnitId Order Unit ReplenishmentStartDate Replenishment Start Date Date ReplenishmentFinishDate Replenishment Finish Date Date ReplenishmentHorizon Replenishment Horizon Integer LastInventoryDate Last Inventory Date Date

top

SourcingNetworkNo gridstop

SourcingRules

InitialSourceRules Initial source rules

field caption type transformColumn transformFormat transformable showTotal Id Integer OperationTypeName Operation Type String yes WorkCentres Workcentres String yes Sites Sites String yes

InitialSources Initial Sources

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteMaterialusageId Integer WorkCentreid Integer LocationName Location String MaterialName Material String endUse End Use String EndCustomer End Customer String OperationTypeName Operation Type String SiteName Site String WorkCentreName Source String

ReplenishmentHorizonRules Initial source rules

field caption type transformColumn transformFormat transformable showTotal Id Integer RuleWeighting Rule Weighting Integer ReplenishmentHorizon Replenishment Horizon Integer

SourcePriorities Sourcing Plans

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteMaterialusageId Integer WorkCentreid Integer ConsignmentLocationId Integer FromRule Integer RuleId Integer IsActive Is Active Integer MaterialName Material String MaterialCode Material Code String WorkCentreName Source String WorkCentreCode Source Code String LocationName Destination String LocationCode Destination Code String EndUseCode End Use String EndCustomerCode End Customer String Priority Priority Integer MaterialTypeName Material Type String SourceMaterialName Source Material String SourceMaterialCode Source Material Code String CustomerName Customer String IsConsignmentStock Is Consignment Integer Portion Portion Integer Journey Journey String DateFrom Start Date Date DateTo Finish Date Date FromRule Create from rule Integer

SourcePriorityRules Sourcing rules

field caption type transformColumn transformFormat transformable showTotal Id Integer IsActive Is Active Integer GroupName Group String WorkCentreName Source String DateFrom Start Date DateTo Finish Date IsConsignmentStock Is Consignment Integer MaterialTypeName Material Type String Priority Priority Integer Percentage Portion Integer RuleWeighting Rule Weighting Integer JourneyCode Journey String Rebuild Rebuild required Integer

top

SQLNoteBookNo gridstop

StartScenario

SACustomerRanks Scenario Customer Ranks

field caption type transformColumn transformFormat transformable showTotal Id Integer CustomerRankName Name String CustomerRankDesc Rank String DisplayInForecast Include as demand Integer

top

StockMonitoring2

InventoryProfile Inventory profile grid

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Stock Date Date yes {0:yyyy-MM-dd} Opening Opening Decimal yes FirmOrdersIn Firm Incoming Decimal yes TentativeOrdersIn Tentative Incoming Decimal yes OriginalTentativeOrdersIn Original Tentative Incoming Decimal yes CumulativeRequestedIn Cumulative Requested Decimal yes CumulativeTentativeIn Cumulative Tentative Decimal yes FirmOrdersOut Firm Outgoing Decimal yes TentativeOrdersOut Tentative Outgoing Decimal yes ForecastDemand Remaining Consumption Decimal yes CumulativeForecastDemand Cumulative Consumption Decimal yes OriginalConsumptionForecast Original Consumption Decimal yes IgnoredDemandValue Ignored Demand Value Decimal yes Closing Closing Decimal yes RemainingAvailable Remaining Available Decimal yes SafetyStock Safety Stock Decimal yes MaxSafetyStock Max Safety Stock Decimal yes MaxCapacity Maximum Capacity Decimal yes IsReceivingDate Receiving Date Integer yes IsRunAvailable Run availability Integer yes AvailableRunCapacity Run Capacity Decimal yes

OrderList Order List

field caption type transformColumn transformFormat transformable showTotal id Integer OrderLineId Integer isEditable Integer OrderCode Order Number string LineNoCode Line Number string Phase Phase Integer DeliveryCode Delivery Number string AlternateCode1 Alternate Code 1 string AlternateCode2 Alternate Code 2 string Direction Direction string Source Source / Destination string CustomerRank Rank string MovementDate Movement Date Date DispatchDate Dispatch Date Date RequestedDate Requested Date Date RequestedDespatchDate Requested Dispatch Date Date DeliveryDate Delivery Date Date Quantity Quantity decimal yes MovementType Movement Type string Status Status string AllowSubstitution Allow substitution integer DestinationMaterial Destination Material string SourceMaterial Source Material string RunCode Run number string Transport Transport string ReplenishmentPoint Replenishment Point string

OrdersExport Orders Export

field caption type transformColumn transformFormat transformable showTotal Id Integer P_CustomerArticleCode Material String ProductName Description String StandardStock Stock Decimal InTransitStock In Transit Decimal DummyStock String DeliveryWeek Delivery Week Week yes {0:yyyy-MM-dd} FinalWeight Weight Decimal yes

RealInventoryProfile Real Inventory Profile

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Stock Date Date yes {0:yyyy-MM-dd} Opening Opening Decimal yes OrdersIn Orders In Decimal yes OrdersOut Orders Out Decimal yes Closing Closing Decimal yes SafetyStock Safety Stock Decimal yes MaxCapacity Maximum Capacity Decimal yes MinOpening Min Opening Decimal yes Consumption Remaining Consumption Decimal yes OriginalConsumption Original Consumption Decimal yes

ReplenishmentDemand Replenishment Demand Grid

field caption type transformColumn transformFormat transformable showTotal Id Integer SkuTitle Sku String yes DateFrom Date Date EditableWarehouseConsumption Warehouse consumption Decimal Demand Demand Decimal yes yes Orders Orders Decimal yes yes NettedOrders Netted Orders Decimal yes yes NettedDemand Consumption Decimal yes yes PortionConsumption Portion Consumption Decimal yes yes WarehouseConsumption Warehouse Consumption Decimal yes yes

ReplenishmentLog Replenishment Log

field caption type transformColumn transformFormat transformable showTotal Action Action String Description Description String

SMIInventoryProfile Inventory Profile

field caption type transformColumn transformFormat transformable showTotal Id Integer DateFrom Stock Date Date yes {0:yyyy-MM-dd} Opening Opening Stock Decimal yes Forecast Forecast Decimal yes Planned Planned Decimal yes Produced Produced Decimal yes InTransit In Transit Decimal yes Closing Closing Stock Decimal yes SafetyStock Safety Stock Decimal yes PlannedForProduction Production at mill (planned) Decimal yes

SMIStockMonitoring Stock Monitoring grid

field caption type transformColumn transformFormat transformable showTotal Id Integer WorkCentreName String ProductCode String ConsignmentCustomerCode String AlternateProduct Customer Article String StockDate Stock Date Date yes {0:yyyy-MM-dd} SafetyStock Safety Stock,Safety Stock Decimal yes Opening Stock Decimal yes yes

StockMonitoring Stock Monitoring grid

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteMaterialUsageId Integer ConsignmentLocationId Integer LocationId Integer Replenished Integer CommentId Integer GroupProperties IsSubTotal Integer UnitId Integer FirmOrders Decimal WorkCentreName Warehouse String ProductName Product Name String ProductCode Product Code String AlternateProduct Customer Article String ProductProperties String MaterialTypeName Product Type String ConsignmentCustomerCode Consignment Customer Code String Delisted Delisted String UnitName Unit String ActiveCustomers Active Customers Integer StockDate Stock Date Date yes {0:yyyy-MM-dd} SafetyStock Safety Stock Decimal yes MaxCapacity Maximum Capacity Decimal yes PrevMonthDespatches Despatches (prev. month) Decimal yes InternalStock Internal Supplier Stock Decimal yes ExternalStock External Supplier Stock Decimal yes Opening Opening Stock Decimal yes yes Closing Closing Stock Decimal yes yes Orders Orders Decimal yes yes Capacity Capacity Decimal Consumption Forecast Consumption Decimal yes yes

top

StockReservation2

ConsignmentOrders Consignment Orders

field caption type transformColumn transformFormat transformable showTotal Id Integer OrderLineId Integer DeliveryId Integer MovementDate Movement Date Date StockLevel Stock Level Decimal Incoming Incoming Decimal Outgoing Outgoing Decimal OrderNumber Order Number String LineNumber Line Number String DeliveryNumber Delivery Number String AlternateCode2 Alternate Code2 String SourceDestination Source / Destination String Status Status String CreateUserName Create User String CreateDateTime Create Date Time DateTime UpdateUserName Update User String UpdateDateTime Update Date Time DateTime

StockReservation Stock reservation

field caption type transformColumn transformFormat transformable showTotal Id Integer SkuId Integer MaterialId Integer CustomerId Integer WorkcentreId Integer Product Product String Warehouse Warehouse String WarehouseCode WarehouseCode String Customer Customer String LowestAvailableStock Lowest Available Stock Decimal StockDate Date yes {0:yyyy-MM-dd} StockValue StockValue Decimal yes

top

SupercessionRules

CustomerSkus Customer Skus

field caption type transformColumn transformFormat transformable showTotal Id Integer LocationCode Location Code String LocationName Location Name String ProductCode Product Code String ProductName Product Name String EndCustomerCode EndCustomer Code String EndCustomerName EndCustomer Name String EndUseCode EndUse Code String EndUseDescription EndUse Description String

ExplainedSupercessionsRulesGrid Explained Supersessions Rules

field caption type transformColumn transformFormat transformable showTotal FromLocationName Location Name,From String ToLocationName Location Name,To String FromLocationCode Location Code,From String ToLocationCode Location Code,To String FromEndUseDescription EndUse,From String ToEndUseDescription EndUse,To String FromEndUseCode EndUse Code,From String ToEndUseCode EndUse Code,To String FromEndCustomerName EndCustomer Name,From String ToEndCustomerName EndCustomer Name,To String FromEndCustomerCode EndCustomer Code,From String ToEndCustomerCode EndCustomer Code,To String FromMaterialName Material Name,From String ToMaterialName Material Name,To String FromMaterialCode Material Code,From String ToMaterialCode Material Code,To String NewCode Material,NewCode String ExistingMaterialCode Material,Existing String FromMaterialProperties Properties,From NewProperties Properties,New ExistingProperties Properties,Existing String

SupercessionRules Supersession rules

field caption type transformColumn transformFormat transformable showTotal Id Integer HierarchyLevels String HierarchyCodes String Properties String FromPropertyCodes String ToPropertyCodes String Type Type String StartDate Start Date Date Percentage Percentage Integer disableSupersededItems Disable Superseded Items Integer AutoCreateSku Auto create Sku Integer FromLocationCode Location Code, From String ToLocationCode Location Code, To String FromProductCode Product Code, From String ToProductCode Product Code, To String FromEndCustomerCode EndCustomer Code, From String ToEndCustomerCode EndCustomer Code, To String FromEndUseCode EndUse Code, From String ToEndUseCode EndUse Code, To String UpdateDate Date of Last Update DateTime UpdateUserName User that Made Last Update String RequiresRebuild Requires Rebuild Integer DeleteOnNextRebuild Delete on Next Rebuild Integer

Supercessions Supersessions

field caption type transformColumn transformFormat transformable showTotal Id Integer Type Type String FromLocationName Old,Location Name String FromLocationCode Old,Location Code String FromMaterialName Old,Material Name String FromMaterialCode Old,Material Code String FromEndUse Old,EndUse String FromEndUseCode Old,EndUse Code String FromEndCustomerName Old,EndCustomer Name String FromEndCustomerCode Old,EndCustomer Code String ToLocationName New,Location Name String ToLocationCode New,Location Code String ToMaterialName New,Material Name String ToMaterialCode New,Material Code String ToEndUse New,EndUse String ToEndUseCode New,EndUse Code String ToEndCustomerName New,EndCustomer Name String ToEndCustomerCode New,EndCustomer Code String FromMaterialProperties Material properties,Old ToMaterialProperties Material properties,New StartDate Start Date Date Percentage Percentage Integer FromRule Created from rule Integer disableSupersededItems Disable Superseded Items Integer

SupercessionsFromRule Supersessions From Rule

field caption type transformColumn transformFormat transformable showTotal Id Integer Type Type String FromLocationName Location Name,Old String ToLocationName Location Name,New String FromLocationCode Location Code,Old String ToLocationCode Location Code,New String FromMaterialName Material Name,Old String ToMaterialName Material Name,New String FromMaterialCode Material Code,Old String ToMaterialCode Material Code,New String FromEndUse EndUse,Old String ToEndUse EndUse,New String FromEndCustomer EndCustomer,Old String ToEndCustomer EndCustomer,New String FromMaterialProperties Material properties,Old ToMaterialProperties Material properties,New StartDate Start Date Date Percentage Percentage Integer FromRule Created from rule Integer disableSupersededItems Disable Superseded Items Integer

top

SupplyPlanningNo gridstop

SystemManagementNo gridstop

SystemSettingsNo gridstop

Templates

UploadingResults

field caption type transformColumn transformFormat transformable showTotal Id Integer Name Name string Started Started DateTime Finished Finished DateTime CorrectMessages Correct entries integer WrongMessages Wrong entries integer FailedReason Failed Reason string

top

Transportation

AssignedLocations Assigned locations on calendar

field caption type transformColumn transformFormat transformable showTotal Id Integer LocationName Location Name String SiteName Site Name String

CalendarRules Calendar Rules

field caption type transformColumn transformFormat transformable showTotal Id Integer CalendarId Integer CalendarRuleNo Calendar Rule No String Description Description String Day Day Integer Month Month Integer Year Year String DayOfWeek Day of week String NumOfWeek Num of week Integer IsWorkingDay Is Working Day Integer IsReceivingDay Is Receiving Day Integer

Calendars Calendars

field caption type transformColumn transformFormat transformable showTotal Id Integer GeneralCalendarId Integer CalendarName Name String GeneralCalendarName Inherited from String

JourneyLegs JourneyLegs

field caption type transformColumn transformFormat transformable showTotal TransportRouteId Integer JourneyId Integer OrderNo Leg String FromLocation Source String ToLocation Destination String TransportMethodName Method String TimePeriod Duration Integer LoadingTime Loading time Integer UnloadingTime Unloading time Integer ScheduleName Schedule String CalendarName Calendar String

Journeys Journeys

field caption type transformColumn transformFormat transformable showTotal Id Integer FromLocationId Integer FromSiteId Integer ToLocationId Integer JourneyCode Code String SiteName Site String LocationName Destination String Cost Cost Decimal IsDefault Is Default Integer

MasterRoutes Master Routes

field caption type transformColumn transformFormat transformable showTotal Id Integer SiteName From Site String IsActive Is Active Integer RouteCategory Route Category String RuleWeighting Rule Weighting Integer TimePeriod Duration (days) Integer Cost Cost Decimal MinCapacity Min. Capacity Decimal MaxCapacity Max. Capacity Decimal

Routes Routes

field caption type transformColumn transformFormat transformable showTotal Id Integer FromLocationName Source String ToLocationName Destination String TransportMethodName Method String Priority Priority Integer TimePeriod Duration (days) Integer Cost Cost Decimal MaxCapacity Max. Capacity Decimal ScheduleName Schedule String CalendarName Calendar String

ScheduleRules Schedule Rules

field caption type transformColumn transformFormat transformable showTotal Id Integer ScheduleId Integer ScheduleRuleNo Schedule Rule No String Description Description String Day Day Integer Month Month Integer Year Year String DayOfWeek Day of week String NumOfWeek Num of week Integer

Schedules Schedules

field caption type transformColumn transformFormat transformable showTotal Id Integer GeneralScheduleId Integer ScheduleName Name String GeneralScheduleName Inherited from String DefaultAvailable Default Available Integer IsReceivingDays Is Receiving Days Integer

TransportMethods Transport Methods

field caption type transformColumn transformFormat transformable showTotal Id Integer TransportMethodCode Code String TransportMethodName Name String

top

Units

Currencies

field caption type transformColumn transformFormat transformable showTotal Id Id Integer CurrencyName Name String CurrencyDescription Description String IsInternal Base Currency Integer Multiplier Multiplier Decimal Divider Divider Decimal

ExchangeRates

field caption type transformColumn transformFormat transformable showTotal Id Id Integer CurrencyDescription Currency String EffectiveDate Effective Date Multiplier Multiplier Decimal Divider Divider Decimal

Units

field caption type transformColumn transformFormat transformable showTotal Id Id Integer UnitName Unit String UnitDescription Description String Dividend Dividend Decimal Divisor Divisor Decimal UnitTypeDesc Type Name String isBaseUnit Base Unit Integer fromBaseUnit From Base Unit Integer MaterialTypeName Material Type String DividendProductPart Dividend Product Part String DivisorProductPart Divisor Product Part String

top

UserManagementNo gridstop

UserNotifications

UserNotifications

field caption type transformColumn transformFormat transformable showTotal Id Id string NotificationId NotificationId string InsertDate Created DateTime IsRead IsRead Integer Severity Severity String Title Title String Body Body String

top

UserSettingsNo gridstop

UsersManagement

DisabledUsers

field caption type transformColumn transformFormat transformable showTotal Id Id Integer UserName User string UserLogin Login string Email E-Mail string CompanyName Company string

LoginControl

field caption type transformColumn transformFormat transformable showTotal DateFrom Date Date MaxLogins Max Logins Integer FailedLogins Refused Logins Integer

UserAudit

field caption type transformColumn transformFormat transformable showTotal UserName User String UserGroupName User Group String Description Description String UserChangedBy Changed By String InsertDate Date Date

UserGroups

field caption type transformColumn transformFormat transformable showTotal Id integer GroupName Group string GroupType Type string

UserGroupsUsers

field caption type transformColumn transformFormat transformable showTotal Id integer UserName User name string UserLogin Login string Checked Included Integer GroupName Current Group string

UserIPLogging

field caption type transformColumn transformFormat transformable showTotal UserName User Name String LoginTime Login time DateTime LogoutTime Logout time DateTime IPAdress IP Address String IPAdress2 IP Address 2 String extraclientinfo Extra Info string

UserPermissions

field caption type transformColumn transformFormat transformable showTotal PageDescription Page string ActionHint Action string Roles Roles string

Users

field caption type transformColumn transformFormat transformable showTotal Id Id Integer UserLogin Login String UserName User Name String UserCode Code String Email Email String CompanyName Company String GroupName User group String MFARequired MFA Required Integer MFAEnabled MFA Enabled Integer

UserSessions

field caption type transformColumn transformFormat transformable showTotal Id Id string UserName User Name String Address Address String Started Started DateTime LatestActionAt Latest Action DateTime

WorkcentresForUser

field caption type transformColumn transformFormat transformable showTotal Id Id Integer Assigned Assigned Integer WorkCentreName WorkCentre Name string WorkCentreCode WorkCentre Code string WorkCentreTypeName WorkCentreType Name string SiteName Site Name string SiteCode Site Code string LocationName Location Name string LocationCode Location Code string

top