ODS
Tables (10)
1 (HistoryMainline)
- Key (HistoryMainlineId) — Primary key — NOT NULL
- Field (Application)
- Field2 (BaseTxnType)
- Field3 (BatchId)
- Field4 (BinningIncluded)
- Field5 (BonusIncluded)
- Field6 (CalendarShiftId)
- Field (CarrierId)
- Field (CDOTypeId)
- Field (ChangeCount)
- Field (ChildCount)
- Field (CIOMessageID)
- Field (CIOMessageIDOutbound)
- Field (Client)
- Field (Comments)
- Field (CompoundTxnType)
- Field (ComputationHistoryId)
- Field (ComputerName)
- Field (ContainerChangeCount)
- Field (ContainerId)
- Field (ContainerName)
- Field (DefectIncluded)
- Field (EmployeeId)
- Field (ES_RecipeId)
- Field (ESigRequirementId)
- Field (FactoryId)
- Field (HistoryId)
- Field (IconId)
- Field (Implicit)
- Field (InRework)
- Field (IntegrationTxnId)
- Field (isFailed)
- Field (LastMoveDate)
- Field (LastMoveDateGMT)
- Field (LastMoveOutDate)
- Field (LastMoveOutDateGMT)
- Field (LocalReworkIncluded)
- Field (LoginId)
- Field (LossIncluded)
- Field (MfgDate)
- Field (MfgProcessOverridesId)
- Field (MoveInDate)
- Field (MoveInDateGMT)
- Field (MoveInQty)
- Field (MoveInQty2)
- Field (OperationId)
- Field (OwnerId)
- Field (ParametricDetailId)
- Field (ParentContainerId)
- Field (ParentContainerName)
- Field (ProductId)
- Field (Qty)
- Field (Qty2)
- Field (QualityESigConfirmed)
- Field (ResourceAvailability)
- Field (ResourceId)
- Field (ResourceStatusCodeId)
- Field (ResourceStatusReasonId)
- Field (ReversalStatus)
- Field (Server)
- … +27
10 (CurrentStatus)
- Key (CurrentStatusId) — Primary key — NOT NULL
- Field (CarrierId)
- Field2 (CDOTypeId)
- Field3 (ChangeCount)
- Field4 (CurrentStepPass)
- Field5 (FactoryId)
- Field6 (InitialRecipeListId)
- Field (InProcess)
- Field (InRework)
- Field (isFactoryName)
- Field (isOperationName)
- Field (isOpStartQty)
- Field (isOpStartQty2)
- Field (isResourceName)
- Field (isRouteStepId)
- Field (isSpecName)
- Field (isSpecRevision)
- Field (isWorkflowName)
- Field (isWorkflowRevision)
- Field (isWorkflowStepName)
- Field (isWorkflowStepSequence)
- Field (LastCompletedTaskId)
- Field (LastMoveDate)
- Field (LastMoveDateGMT)
- Field (LastMoveOutDate)
- Field (LastMoveOutDateGMT)
- Field (LastRevTxnId)
- Field (LocationId)
- Field (MoveInDate)
- Field (MoveInDateGMT)
- Field (ResourceId)
- Field (ReworkLoopCount)
- Field (ReworkTotalCount)
- Field (SpecId)
- Field (StepEntryTxnId)
- Field (TimersCount)
- Field (WorkflowStepId)
- Field (WorkstationId)
2 (ComponentIssueHistory)
- Key (ComponentIssueHistoryId) — Primary key — NOT NULL
- Field (BatchId)
- Field2 (BillControl)
- Field3 (BypassExpirationCheck)
- Field4 (CDOTypeId)
- Field5 (ChangeCount)
- Field6 (ExportImportKey)
- Field (HistoryId)
- Field (HistoryMainlineId)
- Field (IntegrationTxnId)
- Field (MasterRecipeId)
- Field (RecipeIssueItemId)
- Field (RecipeListId)
- Field (TxnId)
3 (IssueHistoryDetail)
- Key (IssueHistoryDetailId) — Primary key — NOT NULL
- Field (ActualQty2Issued)
- Field2 (ActualQtyIssued)
- Field3 (AllowManualWeighOverride)
- Field4 (CDOTypeId)
- Field5 (ChangeCount)
- Field6 (CloseWhenEmpty)
- Field (ComponentIssueHistoryId)
- Field (ExportImportKey)
- Field (HistoryId)
- Field (IntegrationTxnId)
- Field (IsManualReadingOnly)
- Field (IssueControl)
- Field (IssueDifferenceReasonId)
- Field (Notes)
- Field2 (ProductId)
- Field (ProductMaterialListItemId)
- Field (Qty2Required)
- Field (QtyLowerLimit)
- Field (QtyRequired)
- Field (QtyUpperLimit)
- Field (ReferenceDesignator)
- Field (TxnId)
- Field (UOM2Id)
- Field (UOMId)
- Field (bpFromContainerCFactor)
- Field (bpFromContainerConvertedActual)
- Field (bpFromContainerUOMId)
- Field (bpIntermediateCFactor)
- Field (bpIntermediateId)
- Field (bpIntermediatePlannedQty)
- Field (bpIntermediatePlannedUOMId)
- Field (bpIsQtyAdditive)
- Field (bpToContainerCFactor)
- Field (bpToContainerConvertedActual)
- Field (bpToContainerUOMId)
4 (Container)
- Key (ContainerId) — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
5 (ResourceDef)
- Key (ResourceId) — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4
- Field5
- Field6
6 (MfgOrder)
- Key (MfgOrderId) — Primary key — NOT NULL
- Field (BeginProductBaseId)
- Field2 (BeginProductId)
- Field3
- Field4
- Field5
- Field6
7 (Employee)
- Key (EmployeeId) — Primary key — NOT NULL
- Field (AllowOverrideOfSessionValues)
- Field2 (CanLogin)
- Field3 (CDOTypeId)
- Field4 (ChangeCount)
- Field5 (ChangeStatusId)
- Field6 (Description)
- Field (DocManagerPassword)
- Field (DocManagerUser)
- Field (DomainName)
- Field (EmailAddress)
- Field (EmployeeLoginInfoId)
- Field (EmployeeName)
- Field (ES_DisplayOptionsId)
- Field (ES_UseContainerList)
- Field (ESigRoleGroupId)
- Field (FilterTagAccess)
- Field (FilterTags)
- Field (FilterTagsSession)
- Field (FullName)
- Field (HistoryViewId)
- Field (IconId)
- Field (IsFrozen)
- Field (LanguageDictionaryId)
- Field (MenuDefinitionId)
- Field (ModelerAccess)
- Field (Notes)
- Field (PortalMenuDefinitionId)
- Field (PortalMobileMenuDefinitionId)
- Field (PortalV8MenuDefinitionId)
- Field (PrimaryOrganizationId)
- Field (SessionValuesId)
- Field (SetupAccessId)
- Field (TerminologyDictionaryId)
- Field (TrainingPlanId)
- Field (UIPortalProfileId)
- Field (UserComment)
- Field (UserProfileId)
- Field (WebDrillDownMenuDefinitionId)
- Field (WebMenuDefinitionId)
- Field (mdAllowMultipleSignIn)
- Field (mdAllowMultipleTeams)
8 (Operation)
- Key (OperationId) — Primary key — NOT NULL
- Field (Operation)
- Field2 (AutoAdjustLimit)
- Field3 (AutoAdjustReasonId)
- Field4 (BonusReasonsId)
- Field5 (BuyReasonsId)
- Field6 (CDOTypeId)
- Field (ChangeCount)
- Field (ChangeStatusId)
- Field (ComponentDefectReasonsId)
- Field (ContainerDefectReasonsId)
- Field (DefaultRollupReasonId)
- Field (Description)
- Field (DispatchRuleId)
- Field (ES_DisplayOptionsId)
- Field (ES_isDefectReasonGroupId)
- Field (ES_NPIDocumentView)
- Field (FilterTags)
- Field (IconId)
- Field (Image)
- Field (InTransit)
- Field (InventoryPoint)
- Field (IsFrozen)
- Field (LocalReworkReasonsId)
- Field (LossReasonsId)
- Field (Notes)
- Field (OperationName)
- Field (OutsideServicePoint)
- Field (PrintQueueId)
- Field (QtyAdjustReasonId)
- Field (RejectIncomingNCContainer)
- Field (ReworkReasonsId)
- Field (SchedulingDetailId)
- Field (SellReasonsId)
- Field (SetupAccessId)
- Field (ShipmentDestinationsId)
- Field (SummaryThruput)
- Field (ThruputReportingLevelId)
- Field (TrainingReqGroupId)
- Field (UseQueue)
- Field (WIPMsgDefMgrId)
- Field (WorkCenterId)
9 (QtyHistory)
- Key (QtyHistoryId) — Primary key — NOT NULL
- Field (BatchId)
- Field2 (CarrierId)
- Field3 (CDOTypeId)
- Field4 (ChangeCount)
- Field5 (CloseWhenZero)
- Field6 (ExportImportKey)
- Field (HistoryId)
- Field (HistoryMainlineId)
- Field (IntegrationTxnId)
- Field (isChargeToResourceId)
- Field (MasterRecipeId)
- Field (Qty)
- Field (Qty2)
- Field (ResourceId)
- Field (RollupReasonId)
- Field (ThruputReportingLevelId)
- Field (ThruputSummary)
- Field (TxnId)
- Field (UnitsLost)