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
| CREATE TABLE [dbo].[Societe$Production Chantier](
[timestamp] [timestamp] NOT NULL,
[Entry No_] [int] NOT NULL,
[Document Type] [int] NOT NULL,
[No_] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Forecast Date] [datetime] NOT NULL,
[Forecast Quantity] [decimal](38, 20) NOT NULL,
[Unit of Measure Code] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Qty_ per Unit of Measure] [decimal](38, 20) NOT NULL,
[Forecast Quantity (Base)] [decimal](38, 20) NOT NULL,
[Location Code] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Component Forecast] [tinyint] NOT NULL,
[Description] [varchar](70) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Document No_] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Type] [int] NOT NULL,
[Ressource] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Equipe] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Machine] [tinyint] NOT NULL,
[Presence] [tinyint] NOT NULL,
[Auto] [tinyint] NOT NULL,
[Valider] [tinyint] NOT NULL,
[Saisie Terminée] [tinyint] NOT NULL,
[Ligne Chantier] [int] NOT NULL,
[Phase] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Tache] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Hors Heure Affectée] [tinyint] NOT NULL,
[Agence] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Région] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL,
[Type Article] [int] NOT NULL,
[Présence Réel Agence] [decimal](38, 20) NOT NULL,
[Présence Réel Région] [decimal](38, 20) NOT NULL,
[Présence Réel Equipe] [decimal](38, 20) NOT NULL,
[Type DEPOT] [tinyint] NOT NULL,
[Tranfert ressource] [int] NOT NULL,
[Tranfert équipe] [int] NOT NULL,
[N° séq lien compta] [int] NOT NULL,
[Présence Réel Affaire] [decimal](38, 20) NOT NULL,
[Passage Controle transfert] [tinyint] NOT NULL,
CONSTRAINT [Societe$Production Chantier$0] PRIMARY KEY CLUSTERED
(
[Entry No_] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [Data Filegroup 1]
) ON [Data Filegroup 1] |
Partager