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)