1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71
|
USE [PMI]
GO
/****** Object: Table [Production].[BomRange] Script Date: 27/08/2021 16:13:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [Production].[BomRange](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Company] [nvarchar](3) NOT NULL,
[FinishedItemCode] [nvarchar](18) NOT NULL,
[FinishedAdditionalItemCode] [nvarchar](6) NOT NULL,
[LineNumber] [int] NOT NULL,
[ComponentCode] [nvarchar](18) NULL,
[AdditionalComponentCode] [nvarchar](6) NULL,
[OperationCode] [nvarchar](6) NULL,
[ManualSequencingValue] [decimal](14, 2) NOT NULL,
[QueueTimeBeforeWorkstation] [decimal](15, 3) NOT NULL,
[OperatorTime] [decimal](15, 3) NOT NULL,
[ComponentDescription] [nvarchar](40) NULL,
[ManufacturingLandmark] [nvarchar](4) NULL,
[SubcontractingLandmark] [nvarchar](4) NULL,
[StopOnCalculation] [bit] NOT NULL,
[ReplaceAdditionalItemCode] [int] NOT NULL,
[ForcedOrderManufacturingIndex] [nvarchar](3) NULL,
[IsSequencing] [bit] NOT NULL,
[ForcedManagementCode] [int] NOT NULL,
[ForcedValueKind] [nvarchar](1) NULL,
[ForcedValue] [decimal](15, 3) NOT NULL,
[ConsumptionUnit] [nvarchar](2) NULL,
[StartupQuantityOrTime] [decimal](15, 3) NOT NULL,
[QuantityFactor] [decimal](15, 3) NOT NULL,
[PreparationTime] [decimal](15, 3) NOT NULL,
[OverlapRate] [decimal](14, 2) NOT NULL,
[GroupingQuantity] [decimal](14, 2) NOT NULL,
[YieldRate] [decimal](14, 2) NOT NULL,
[QualityNoteCode] [nvarchar](20) NULL,
[OperationDesignCode] [nvarchar](20) NULL,
[MachiningProgramCode] [nvarchar](20) NULL,
[FormulaTypeExe] [nvarchar](1) NULL,
[FormulaNumber] [nvarchar](3) NULL,
[ReplacementComponentCode] [nvarchar](18) NULL,
[ReplacementAdditionalComponentCode] [nvarchar](6) NULL,
[ReplacementStartDate] [datetime] NULL,
[ReplacementEndDate] [datetime] NULL,
[Tooling] [nvarchar](20) NULL,
[ToolingLocation] [nvarchar](10) NULL,
[CreationDate] [datetime] NOT NULL,
[ModificationDate] [datetime] NULL,
[OperatorCount] [decimal](15, 2) NOT NULL,
[MachineSetterCount] [decimal](15, 2) NOT NULL,
[ComponentQuantity] [decimal](15, 6) NOT NULL,
[Skill] [nvarchar](6) NULL,
[UseEquivalency] [bit] NOT NULL,
[LineOriginKind] [int] NOT NULL,
[ValidityStartDate] [datetime] NULL,
[ValidityEndDate] [datetime] NULL,
[ProductionUnitCode] [nvarchar](6) NULL,
[OperationKind] [nvarchar](6) NULL,
[LastUser] [nvarchar](4) NULL,
[RowVersion] [int] NOT NULL,
CONSTRAINT [PK_Production.BomRange] PRIMARY KEY CLUSTERED
(
[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO |
Partager