Pages

name	cloudParentPage	type	description	hint
Administration		base	Administration	Administration
AdminParameters		base	System Parameters	Parameters of I-Plan system specific to it's proper functioning.
Analytics		base	Analytics	Analytics
ArchivedForecast		base	Archived Forecast	View Archived Forecast
AreasManagement		base	Role Management	Create and Modify pages and actions access assigned to specific user roles.
BSMPComparison		base	Live Schedule Comparison
BSOGantt		base	Schedule Optimiser	Schedule Optimiser
CampaignEditor		base	Production Plan Gantt	Production Plan Gantt
ChangeExpiredPassword		supp	Change Expired Password	Change Expired Password
CloudConfiguration		base	Configuration	Configuration
Customers2		base	Locations	View and Edit customers in system.
CyclePlan		base	Cycle Plan
Dashboard		base	Dashboard	Dashboard
DemandPlanning		base	Demand	DemandPlanning
EventsLog		base	Processes, Events, Jobs, Tasks	View log of system and user-specific events.
externalMessages		base	Messages	messages
ForecastAnalysis		base	Forecast Analysis	Forecast Analysis
ForecastChanges		base	Audit	view forecast changes
ForecastCollaboration		base	Forecasting	Forecast CollaborationView
ForecastCollaboration
ForecastingView		base	Forecasting View	Forecast Collaboration View
HierarchiesConfig		base	Characteristics	Characteristics Config
HomePage		supp	Home	I-Plan Home page
init		base	System Actions	System Actions
InteractiveSQL		base	Interactive SQL query	Interactive SQL query
InventoryPlanning		base	Inventory	InventoryPlanning
InventoryRecords		base	Inventory Records	Inventory Records
LiveAllocation		base	Demand Control	Demand Control
LiveAllocationChanges		base	Demand Control Audit	Changes in demand control
MandatorySettings		base	Mandatory Settings	Mandatory Settings for Scenario Analysis
MFASetup		supp	Multi-factor authentication setup	Multi-factor authentication setup page
MinimumAllocations		base	Minimum allocation	Minimum market allocation in SNO
Modeling		base	Model	Modeling
NavigationsConfig		base	Navigations	Navigations Config
ObsoleteData		base	Obsolete Data	Obsolete Data
OnHandStock		base	On-Hand Stock	On-Hand Stock
OrderMaintenance2		base	Reserved Order Maintenance	Reserved Order Maintenance
OrdersByInquiry		base	Order Inquiry	View Orders By Inquiry
Prices		base	Prices	Show price rules
ProductionOptimisation		base	Production Optimisation	Production Optimisation
ProductionOrders		base	Production Orders	View pending orders, assign them to runs and initiate firm order creation process.
ProductionPlan		base	Production Plan	Production Plan
ProductionPlanning		base	Production	Production Planning
Products		base	Products	View, Create and Edit materials.
ProgramTemplates		base	Program Templates	Displays the list of templates for the selected workcentre type (PM or FL).
QuickReports		base	Quick Reports	Quick Reports
Reasons		base	Reason codes	view reasons list
ReportBuilder		base	Reports	Report Builder
Reporting		base	Reporting	Create and Modify data sources and reports, widgets, filters.
RSO		base	Roll Stock Optimiser	Roll Stock Optimiser
SASupplyPlanning		base	Demand Control	Demand Control
SASupplyPlanningReference		base	Reference	SA reference settings
ScenarioAnalysis		base	Scenario Analysis	Scenario Analysis
ScenarioSettings		base	Scenario Settings	Scenario Settings
SimpleDemandControl		base	Supply Based Demand Control	Supply Based Demand Control
Sites		base	Sites	Manage sites
Sites
SourcingNetwork		base	Sourcing Network	View sourcing network for a selected material or location.
SourcingRules		base	Sourcing Rules	Sourcing Rules
StockMonitoring2		base	Stock Monitoring	Stock Monitoring
StockReservation2		base	Stock Reservation	view and maintain the consignment stock levels.
SupercessionRules		base	Supersession and Substitution	Supersession and Substitution
SupplyPlanning		base	Supply	Supply Planning
SystemManagement		base	System Management	System Management
SystemSettings		base	System Settings	System Settings
Templates		base	Data Loading	Create and edit models
Translations		base	Translations	Translations
Units		base	Units, Currencies	Manage system units, currencies and exchange rates
UserManagement		base	User Management	User Management
UserNotifications		supp	Notifications	User Notifications page
UserSettings		base	User settings	User settings
UsersManagement		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

AdminParameters

SystemParameterLog

field caption type transformColumn transformFormat transformable showTotal Stamp Stamp DateTime ParameterName Name String ParameterDescription Description String DefaultValue Value, Default String OldValue Value, Prev String NewValue Value, New String UserName User,Name String UserLogin User,Login String

top

AnalyticsNo gridstop

ArchivedForecast

ArchivedForecast Archived Forecasting

field caption type transformColumn transformFormat transformable showTotal Id Integer Status Status String SystemTotal Period Total,System Decimal yes CustomerTotal Period Total,Customer Decimal yes FinalTotal Period Total,Final 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 DeletedFlag IsDeleted Integer yes EditGroupId Edit Group, Id Integer yes EditGroupFinalId Edit Group, Final Id Integer yes

top

AreasManagement

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

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

InputMaterialsForRun Input Materials

field caption type transformColumn transformFormat transformable showTotal SkuId Integer MaterialId Integer Replenished Integer LocationName Warehouse String MaterialName Product String Opening Opening Decimal Closing Closing Decimal

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

OrdersForRunInputMaterial

field caption type transformColumn transformFormat transformable showTotal OrderCode Order Code String LineNoCode Order Line No String LineNoCode Order Line No String OperationNo Material Name String Quantity Quantity Decimal yes RemainingQuantity Remaining Quantity Decimal yes

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 IsInternalTool Internal Integer Undermake Tolerance %,Under Decimal Overmake Tolerance %,Over Decimal 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 ToolMaterialTypeId Required Tool Type String ApplyCyclePlan Apply Cycle Plan integer IsCrossSiteInput Cross-site Input 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 MaxEarlyPeriods Max early periods Integer MaxLatePeriods Max late periods Integer MaxEarlyPeriodsOrders Max early periods (orders) Integer MaxLatePeriodsOrders Max late periods (orders) Integer MaxEarlyPeriodsSFG Max periods to finishing Integer MaxReplenishPeriodsForSafetyStock Max periods to replenish safety stock Integer

top

DemandPlanningNo gridstop

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 FileSizeKB File Size (KB) Decimal 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

externalMessages

AggregatedMessages

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

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 StartTime Started At DateTime FinishTime Finished At DateTime IsFailed Is Failed Integer Error Error string

MessagesLog

field caption type transformColumn transformFormat transformable showTotal Id Integer IsSelected Integer Direction Direction string TopElement Top Element string Code Message Code string StartTime Start Time DateTime FinishTime Finish Time DateTime SourceDestination Source Destination string ContentType Content Type string UserName User Name string IsFailed Is Failed Integer Error Error 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

ForecastMessagesLog Forecast Messages Log

field caption type transformColumn transformFormat transformable showTotal Id Integer UserName User Name string DateFrom Date Date Period Period String UnitName Unit String Weight Weight Decimal ForecastStatusName Forecast Status String InsertDate Created Date DateTime StatusName Status String FailedReason Failed Reason String Characteristics Characteristics 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,Nominal Cost Decimal yes ValueAddTotal Period Total,Value Add Decimal yes RevenueTotal Period 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 MAEP MAE% Decimal MAE MAE Decimal MAPE MAPE Decimal ZMAPE ZMAPE Decimal SMAPE SMAPE Decimal MPE MPE Decimal RMSE RMSE % Decimal BiasP Bias% 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 CreatedBy Created by String InsertDate Created DateTime UpdatedBy Updated by String UpdateDate Updated DateTime

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 UserId Integer ReportFilterId Integer ForecastSampleName Sample Name String UserName User 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

ForecastValueAdd Forecast Value Add

field caption type transformColumn transformFormat transformable showTotal Id Integer ForecastingStage Forecasting Stage String yes Error Error Decimal yes ErrorPercentage Error% Decimal yes ErrorFVA FVA Decimal yes Bias Bias Decimal yes BiasPercentage Bias% Decimal yes BiasFVA FVA 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

OutlierDetection Outlier Detection

field caption type transformColumn transformFormat transformable showTotal Id Integer OutlierMonths String DateFrom Period Month {0:yyyy-MM-dd} AdjustedHistory Outlier Decimal FittedHistory Fitted Value Decimal Difference Delta Decimal MeanOfErrors Mean of Errors Decimal StdDevOfErrors Std dev of Errors Decimal StdDevs Std devs Decimal Event Event String

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

InventoryRecords

InventoryRecords Inventory Records

field caption type transformColumn transformFormat transformable showTotal skuId Integer consignmentLocationId Integer LocationCode Location Code String ProductCode Product Code String ConsignmentLocationCode Consignment Location Code String DateFrom Date From Date StockType Stock Type String Weight Weight Decimal AvailableOnHandWeight OnHandWeight, Available Decimal CalculatedOnHandWeight OnHandWeight, Calculated Decimal CreateUser Created by User String InsertDate Created at String

top

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 LocationCode Location Code String LocationName Location Name String ProductCode Product Code String ProductName Product Name String EndUseCode End Use Code String EndUseDescription End Use Name String EndCustomerCode End Customer Code String EndCustomerName End Customer Name 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

NavigationsConfigNo gridstop

ObsoleteData

PurgeObsoleteData

field caption type transformColumn transformFormat transformable showTotal Id Integer IsSelected 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 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 true Weight Weight Decimal true SourceWeight Source Weight Decimal true 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 DueDate Due date Date 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 SourceMaterialCode Source material Code String SourceMaterialTypeName Source material Type String UsedWithMaterialName Used with material String UsedWithMaterialCode Used with material code String SiteName Site name String SiteCode Site code 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

ToolBatches Tool batches

field caption type transformColumn transformFormat transformable showTotal Id Integer BatchNo Batch No Integer ToolMaterialName Tool Name String ToolMaterialCode Tool Code String MaterialName Product Name String MaterialCode Product Code String

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 IsValid Integer Title Data Source String Description Description String

PersonalReports

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

SharedReports

field caption type transformColumn transformFormat transformable showTotal Id Integer IsValid 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 IsValid 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

AdminReports

field caption type transformColumn transformFormat transformable showTotal Id Integer IsValid Integer UserId UserId Integer Title Title String Description Description String Category Category String Creator Creator String IsPublished IsPublished Integer 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 IsCustomer Integer IsValid Integer IsUsed Used Integer UserName User String Type Widget Type String Description Widget String SourceType Source Type String SourceName Source String

top

RSO

RsoDemands RSO Demands

field caption type transformColumn transformFormat transformable showTotal Id Integer Width Width Integer Weight Weight Decimal true StockSize Stock Size Integer PatternQty Pattern Qty Integer Trim Trim Integer WastePercentage Waste % Decimal

RsoPropertySets RSO Property Sets

field caption type transformColumn transformFormat transformable showTotal Id Integer Demands Demand Sizes Integer UnassignedDemands Unassigned Demand Sizes Integer RequestedStockSizes Requested Stock Sizes Integer ActualStockSizes Actual Stock Sizes Integer

RsoScenarios RSO Scenarios

field caption type transformColumn transformFormat transformable showTotal Id Integer Name Name String UserName Author String WorkcentreName Workcentre String DateFrom Date From Date DateTo Date To Date DemandWeight Demand Decimal ProductionWeight Production Decimal WasteWeight Waste Decimal WastePercentage Waste % Decimal StockSizes Stock Sizes Integer

RsoStockSizes RSO Stock Sizes

field caption type transformColumn transformFormat transformable showTotal Id Integer Width Width Integer Weight Total Weight Decimal true WeeklyWeight Weekly Weight Decimal true TrimLoss Trim Loss Decimal true WeeklyTrimLoss Weekly Trim Loss Decimal true IsRequired Required Integer

top

SASupplyPlanningNo gridstop

SASupplyPlanningReferenceNo gridstop

ScenarioAnalysisNo gridstop

ScenarioSettingsNo gridstop

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 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 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 Latitude Latitude String Longitude Longitude String StandardTransportCost Standard transport cost Decimal MaxLeavingCapacity Max. Leaving Capacity 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

SourcingNetworkNo gridstop

SourcingRules

InitialSourceRules Initial source rules

field caption type transformColumn transformFormat transformable showTotal Id Integer IsActive Is Active Integer RuleWeighting Rule Weighting 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 Consignment Customer String CustomerCode Consignment Customer Code 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

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

Loads Loads

field caption type transformColumn transformFormat transformable showTotal LoadNumber Load Number integer DespatchDate Dispatch Date Date DeliveryDate Delivery Date Date LoadQuantity Quantity decimal OrdersQuantity Orders Quantity decimal

MasterPurchaseOrders Master Purchase Orders

field caption type transformColumn transformFormat transformable showTotal Id Integer OrderCode Order Number string LineNoCode Line Number string WorkCentreCode Source string MaterialCode Product string DespatchDate Dispatch Date Date DeliveryDate Delivery Date Date FinalWeight Quantity decimal OrderLineStatusName Status string

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 ConsignmentCustomerName Consignment Customer Name 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

Translations

KeyGrid

field caption type transformColumn transformFormat transformable showTotal Id Integer TableRowId Integer LanguageId LanguageId Integer yes LanguageName Language Name String yes DictionaryKey Dictionary Key String yes DictionaryValue String yes

LanguageCategories

field caption type transformColumn transformFormat transformable showTotal Id Integer PagePath Path String PageDescription Page String CategoryTypeDesc Type String LanguageCategoryDesc Language Category Description String LanguageCategoryName Language Category Name String

Languages

field caption type transformColumn transformFormat transformable showTotal Id Integer Internal Internal Boolean LanguageName Name String LanguageDesc Description 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 IsUsed Is customer currency Integer

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 IsFormula Formula Integer 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 LockInvalidPasswordTime Blocked Time DateTime

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 DateTime

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