CREATE TABLE [dbo].[Programme] (
	[KEYBARCODE] [char] (23) COLLATE French_CI_AS NOT NULL ,
	[ARTICOLO] [char] (7) COLLATE French_CI_AS NOT NULL ,
	[TOMAIA] [char] (7) COLLATE French_CI_AS NOT NULL ,
	[TIPO_LAV] [char] (3) COLLATE French_CI_AS NOT NULL ,
	[FORMA] [char] (20) COLLATE French_CI_AS NOT NULL ,
	[PUNTALE] [char] (20) COLLATE French_CI_AS NOT NULL ,
	[NSTAZIONE] [numeric](2, 0) NOT NULL ,
	[COD_ROBOT] [char] (4) COLLATE French_CI_AS NULL ,
	[ISOLA] [char] (2) COLLATE French_CI_AS NOT NULL ,
	[LIVELLO] [numeric](2, 0) NOT NULL ,
	[CASSETTA] [numeric](2, 0) NOT NULL ,
	[STAZIONE] [char] (5) COLLATE French_CI_AS NOT NULL ,
	[PROGR] [char] (5) COLLATE French_CI_AS NOT NULL ,
	[COLORE_C] [char] (20) COLLATE French_CI_AS NOT NULL ,
	[COLORE_E] [char] (20) COLLATE French_CI_AS NOT NULL ,
	[NBOLLA] [numeric](8, 0) NOT NULL ,
	[TAGLIA] [numeric](2, 0) NOT NULL ,
	[MODELLO] [char] (40) COLLATE French_CI_AS NOT NULL ,
	[FONDO] [char] (20) COLLATE French_CI_AS NOT NULL ,
	[NGIORNO] [numeric](2, 0) NOT NULL ,
	[ANNOPROG] [numeric](4, 0) NOT NULL ,
	[NUMORD] [numeric](8, 0) NOT NULL ,
	[RIGORD] [numeric](4, 0) NOT NULL ,
	[Lu] [int] NULL ,
	[Date Lecture] [datetime] NULL ,
	[N° Carton] [varchar] (8) COLLATE French_CI_AS NULL ,
	[Date Carton] [datetime] NULL ,
	[Date Entrée] [datetime] NULL ,
	[OFRTOR] [varchar] (30) COLLATE French_CI_AS NULL ,
	[Station] [int] NULL ,
	[Secours] [int] NULL ,
	[Magasin] [int] NULL ,
	[Tag] [int] NULL ,
	[Export] [varchar] (20) COLLATE French_CI_AS NULL ,
	[NUMORD2] [numeric](8, 0) NULL ,
	[RIGORD2] [numeric](8, 0) NULL ,
	[Transfert] [int] NULL ,
	[CMPORD] [varchar] (3) COLLATE French_CI_AS NULL ,
	[TIPOORD] [varchar] (3) COLLATE French_CI_AS NULL ,
	[ANNOORD] [int] NULL ,
	[TIPOART] [varchar] (15) COLLATE French_CI_AS NULL ,
	[RIMP] [int] NULL ,
	[Date PL] [datetime] NULL ,
	[StationC] [int] NULL ,
	[Système] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Magasin2] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Nature] [int] NULL ,
	[Etat] [int] NULL ,
	[Annulation] [int] NULL ,
	[Defaut] [varchar] (3) COLLATE French_CI_AS NULL ,
	[Imprimer] [int] NULL ,
	[Date Magasin2] [datetime] NULL ,
	[Archiver] [int] NULL ,
	[REP] [int] NULL ,
	[INJ] [int] NULL ,
	[TRO] [int] NULL ,
	[REPB] [int] NULL ,
	[REPT] [int] NULL ,
	[Badge] [int] NULL ,
	[Date Secours] [datetime] NULL ,
	[Bolla2] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Prog2] [varchar] (20) COLLATE French_CI_AS NULL ,
	[An2] [int] NULL ,
	[Date TRO] [datetime] NULL ,
	[StationE] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[N° Séries] (
	[Num] [int] IDENTITY (1, 1) NOT NULL ,
	[Document] [int] NULL ,
	[Numéro] [varchar] (20) COLLATE French_CI_AS NULL ,
	[N° Série] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Article] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété1] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Quantité] [numeric](38, 18) NULL ,
	[Ordine] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Riga] [varchar] (20) COLLATE French_CI_AS NULL ,
	[NSFrs] [varchar] (20) COLLATE French_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Mouvement Stock] (
	[Numéro] [int] IDENTITY (1, 1) NOT NULL ,
	[Date Mouvement] [datetime] NULL ,
	[Article] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Unité] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Document] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Famille] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Sous Famille] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Casier] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Magasin] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Fournisseur] [varchar] (20) COLLATE French_CI_AS NULL ,
	[BR] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Client] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Entree] [numeric](38, 19) NULL ,
	[Sortie] [numeric](38, 19) NULL ,
	[Prix] [numeric](38, 19) NULL ,
	[Stock] [numeric](38, 18) NULL ,
	[Utilisateur] [int] NULL ,
	[Nature] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Doc] [int] NULL ,
	[Devise] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Taux] [numeric](9, 5) NULL ,
	[Description] [varchar] (30) COLLATE French_CI_AS NULL ,
	[CodeMvt] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[AS400] [int] NULL ,
	[Propriété1] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Bon de Réception] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Attente] [int] NULL ,
	[Station] [varchar] (10) COLLATE French_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Mouvement Stock PF] (
	[Numéro] [int] IDENTITY (1, 1) NOT NULL ,
	[Date Mouvement] [datetime] NULL ,
	[Article] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Unité] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Document] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Famille] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Sous Famille] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Casier] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Magasin] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Fournisseur] [varchar] (20) COLLATE French_CI_AS NULL ,
	[BR] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Client] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Entree] [numeric](38, 19) NULL ,
	[Sortie] [numeric](38, 19) NULL ,
	[Prix] [numeric](38, 19) NULL ,
	[Stock] [numeric](38, 18) NULL ,
	[Utilisateur] [int] NULL ,
	[Nature] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Doc] [int] NULL ,
	[Devise] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Taux] [numeric](9, 5) NULL ,
	[Description] [varchar] (30) COLLATE French_CI_AS NULL ,
	[CodeMvt] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[AS400] [int] NULL ,
	[Propriété1] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Bon de Réception] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Attente] [int] NULL ,
	[Station] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Ordine] [varchar] (30) COLLATE French_CI_AS NULL ,
	[Riga] [varchar] (20) COLLATE French_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Ligne Bon de réception] (
	[timestamp] [timestamp] NULL ,
	[Numéro] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Article] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Ligne] [int] NOT NULL ,
	[Type Ligne] [int] NULL ,
	[Désignation] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Famille] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Sous Famille] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Référence Fournisseur] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Unité] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Variante] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété1] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété2] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété3] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété4] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété5] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Quantité par Unité] [numeric](38, 18) NULL ,
	[Quantité en unité] [numeric](38, 18) NULL ,
	[Quantité à Recevoir] [numeric](38, 18) NULL ,
	[Quantité Totale] [numeric](38, 18) NULL ,
	[Quantité Livrée] [numeric](38, 18) NULL ,
	[Quantité Facturée] [numeric](38, 18) NULL ,
	[Quantité Saisie] [numeric](38, 18) NULL ,
	[Quantité Lue] [numeric](38, 18) NULL ,
	[Quantité non Conforme] [numeric](38, 18) NULL ,
	[Prix Unitaire] [numeric](38, 18) NULL ,
	[Prix Total] [numeric](38, 18) NULL ,
	[Montant DT] [numeric](38, 18) NULL ,
	[Montant HT Brut] [numeric](38, 18) NULL ,
	[%Remise] [numeric](8, 3) NULL ,
	[Montant Remise] [numeric](38, 18) NULL ,
	[Net HT 1] [numeric](38, 18) NULL ,
	[%Remise2] [numeric](9, 3) NULL ,
	[Montant Remise2] [numeric](38, 18) NULL ,
	[Net HT 2] [numeric](38, 18) NULL ,
	[%Escompte] [numeric](9, 3) NULL ,
	[Montant Escompte] [numeric](38, 18) NULL ,
	[Montant HT Net] [numeric](38, 18) NULL ,
	[Fodec] [varchar] (2) COLLATE French_CI_AS NULL ,
	[%Fodec] [numeric](8, 3) NULL ,
	[Montant Fodec] [numeric](38, 18) NULL ,
	[Base TVA] [numeric](38, 18) NULL ,
	[TVA] [varchar] (3) COLLATE French_CI_AS NULL ,
	[%TVA] [numeric](8, 3) NULL ,
	[Montant TVA] [numeric](38, 18) NULL ,
	[Montant Taxe] [numeric](38, 18) NULL ,
	[Montant TTC] [numeric](38, 18) NULL ,
	[NGP] [varchar] (20) COLLATE French_CI_AS NULL ,
	[% Taxe Douane] [numeric](8, 3) NULL ,
	[Taxe Douane] [numeric](38, 18) NULL ,
	[Casier] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Magasin] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Client] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Fournisseur] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Bon de Réception] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Valeur1] [numeric](38, 18) NULL ,
	[Valeur2] [numeric](38, 18) NULL ,
	[Valeur3] [numeric](38, 18) NULL ,
	[Valeur4] [numeric](38, 18) NULL ,
	[Valeur5] [numeric](38, 18) NULL ,
	[Valeur6] [numeric](38, 18) NULL ,
	[Note] [varchar] (100) COLLATE French_CI_AS NULL ,
	[OF] [varchar] (20) COLLATE French_CI_AS NULL ,
	[PCode] [int] NULL ,
	[Facture] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Réf Commande Client] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Quantité Reçue] [numeric](38, 18) NULL ,
	[Ecart] [numeric](38, 18) NULL ,
	[Motif] [varchar] (255) COLLATE French_CI_AS NULL ,
	[Champs1] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Champs2] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Champs3] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Prix Devise Société] [numeric](38, 18) NULL ,
	[Montant Devise Société] [numeric](38, 18) NULL ,
	[GN] [int] NULL ,
	[Commande AS400] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Année Commande] [int] NULL ,
	[LEOrdine] [varchar] (20) COLLATE French_CI_AS NULL ,
	[LERiga] [varchar] (20) COLLATE French_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Ligne Réception Lecture] (
	[Numéro] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Ligne] [int] NOT NULL ,
	[Type Ligne] [int] NULL ,
	[Code à Barres] [varchar] (50) COLLATE French_CI_AS NULL ,
	[Article] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Désignation] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Unité] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Quantité par Unité] [numeric](38, 18) NULL ,
	[Quantité en Unité] [numeric](38, 18) NULL ,
	[Quantité Totale] [numeric](38, 18) NULL ,
	[N° Série] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Bon de réception] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Magasin] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Casier] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Note] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Groupe1] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Groupe2] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Groupe3] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Fournisseur] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Client] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Variante] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété1] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété2] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété3] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété4] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Propriété5] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Valeur1] [numeric](38, 18) NULL ,
	[Valeur2] [numeric](38, 18) NULL ,
	[Valeur3] [numeric](38, 18) NULL ,
	[Valeur4] [numeric](38, 18) NULL ,
	[Valeur5] [numeric](38, 18) NULL ,
	[Valeur6] [numeric](38, 18) NULL ,
	[OF] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Date OF] [datetime] NULL ,
	[Bon de Livraison] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Date BL] [datetime] NULL ,
	[Bon de Réparation] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Date BR] [datetime] NULL ,
	[Garantie] [varchar] (1) COLLATE French_CI_AS NULL ,
	[PCode] [int] NULL ,
	[Panne] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Date Lecture] [datetime] NULL ,
	[Prix] [numeric](38, 18) NULL ,
	[Référence Document] [varchar] (20) COLLATE French_CI_AS NULL ,
	[REOrdine] [varchar] (20) COLLATE French_CI_AS NULL ,
	[RERiga] [varchar] (20) COLLATE French_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Article Pointure] (
	[Article] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Pointure] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Quantité] [numeric](38, 18) NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Tout] (
	[Date] [datetime] NOT NULL ,
	[Article] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Nature] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Prog] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Bolla] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Ordine] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Riga] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Station] [int] NULL ,
	[Q34] [numeric](18, 0) NULL ,
	[Q35] [numeric](18, 0) NULL ,
	[Q36] [numeric](18, 0) NULL ,
	[Q37] [numeric](18, 0) NULL ,
	[Q38] [numeric](18, 0) NULL ,
	[Q39] [numeric](18, 0) NULL ,
	[Q40] [numeric](18, 0) NULL ,
	[Q41] [numeric](18, 0) NULL ,
	[Q42] [numeric](18, 0) NULL ,
	[Q43] [numeric](18, 0) NULL ,
	[Q44] [numeric](18, 0) NULL ,
	[Q45] [numeric](18, 0) NULL ,
	[Q46] [numeric](18, 0) NULL ,
	[Q47] [numeric](18, 0) NULL ,
	[Q48] [numeric](18, 0) NULL ,
	[Q49] [numeric](18, 0) NULL ,
	[Q50] [numeric](18, 0) NULL ,
	[Q51] [numeric](18, 0) NULL ,
	[Q52] [numeric](18, 0) NULL ,
	[Total] [numeric](18, 0) NULL ,
	[Qualité] [varchar] (10) COLLATE French_CI_AS NULL ,
	[AnnoProg] [int] NULL ,
	[LU] [int] NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Article] (
	[Code] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Désignation] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Désignation2] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Famille] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Sous Famille] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Catégorie] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Source] [varchar] (50) COLLATE French_CI_AS NULL ,
	[Gestion par Casier] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Gérer le Stock] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Gestion par Magasin] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Gestion Par Fournisseur] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Gestion Par BR] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Fiabilité] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Nomenclature] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Unité] [varchar] (10) COLLATE French_CI_AS NOT NULL ,
	[Remise Fournisseur] [numeric](9, 5) NULL ,
	[Remise Client] [numeric](9, 5) NULL ,
	[Code Remise Qte] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Mode Calcul] [tinyint] NULL ,
	[Mode Evaluation du Stock] [varchar] (50) COLLATE French_CI_AS NULL ,
	[Coût Unitaire] [numeric](18, 3) NULL ,
	[Coût Standard] [numeric](18, 3) NULL ,
	[Dernier Coût Direct] [numeric](18, 3) NULL ,
	[Coût Moyen] [numeric](18, 0) NULL ,
	[Prix Unitaire Minimum] [numeric](18, 3) NULL ,
	[% Coût Indirect] [numeric](18, 3) NULL ,
	[Fournisseur] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Référence Fournisseur] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Référence Client] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Délai de Réappro.] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Quantité] [numeric](38, 18) NULL ,
	[Quantité Réservée] [numeric](38, 18) NULL ,
	[Quantité Minimum] [numeric](18, 3) NULL ,
	[Quantité Maximum] [numeric](18, 3) NULL ,
	[Quantité de Répppro.] [numeric](18, 3) NULL ,
	[Réference de remplacement] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Droit de Douane] [numeric](5, 3) NULL ,
	[Poids Brut] [numeric](18, 3) NULL ,
	[Poids Net] [numeric](18, 3) NULL ,
	[Conditionnement] [numeric](18, 3) NULL ,
	[Durabilité] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Type de fret] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Pays d'achat] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Quantité Budgétisée] [numeric](18, 3) NULL ,
	[Montant Budgétisée] [numeric](18, 3) NULL ,
	[Marge budgetisée] [numeric](5, 3) NULL ,
	[Bloqué] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Stock Physique] [numeric](18, 3) NULL ,
	[Achats] [numeric](18, 3) NULL ,
	[Ventes] [numeric](18, 3) NULL ,
	[Quantité sur commande Achat] [numeric](18, 3) NULL ,
	[Quantité sur commande Vente] [numeric](18, 3) NULL ,
	[TVA] [varchar] (3) COLLATE French_CI_AS NULL ,
	[Image] [image] NULL ,
	[Unité de Vente] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Unité d'achat] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Qté Reservée sur OF] [numeric](18, 3) NULL ,
	[Fournisseur Dern. Commande] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Date Dern. Commande] [datetime] NULL ,
	[Client Dern. Facture] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Date Dern. Facture] [datetime] NULL ,
	[Groupe] [int] NOT NULL ,
	[Prix d'achat HT] [numeric](38, 19) NULL ,
	[Prix de vente HT] [numeric](38, 18) NULL ,
	[Prix d'achat TTC] [numeric](38, 18) NULL ,
	[Prix de vente TTC] [numeric](38, 18) NULL ,
	[Fodec] [varchar] (2) COLLATE French_CI_AS NULL ,
	[Devise] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Marge] [numeric](9, 5) NULL ,
	[Dern. Prix de vente] [numeric](38, 18) NULL ,
	[Dern. Prix d'achat] [numeric](38, 18) NULL ,
	[PAMP] [numeric](38, 18) NULL ,
	[Casier] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Magasin] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Remise Promo] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Bloquer Remise] [varchar] (1) COLLATE French_CI_AS NULL ,
	[%Remise Promo] [numeric](9, 4) NULL ,
	[NGP] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Référence] [varchar] (50) COLLATE French_CI_AS NULL ,
	[Compteur] [int] NULL ,
	[Stock Sous Traitance] [numeric](38, 18) NULL ,
	[Process] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Cout Sous Traitance] [numeric](38, 18) NULL ,
	[TVA Sous Traitance] [varchar] (3) COLLATE French_CI_AS NULL ,
	[% Remise Sous Traitance] [numeric](9, 4) NULL ,
	[Code à Barre Client] [varchar] (50) COLLATE French_CI_AS NULL ,
	[Code à Barre Fournisseur] [varchar] (50) COLLATE French_CI_AS NULL ,
	[Code à barre] [varchar] (50) COLLATE French_CI_AS NULL ,
	[Utilisateur] [int] NULL ,
	[Date dern. modification] [datetime] NULL ,
	[EAN13] [varchar] (13) COLLATE French_CI_AS NULL ,
	[Code128] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Gestion par client] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Afficher] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Garantie] [numeric](18, 0) NULL ,
	[Interdire Stock Négatif] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Interdire Stock Disponible Négatif] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Marque] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Compte] [varchar] (13) COLLATE French_CI_AS NULL ,
	[Doc] [int] NULL ,
	[Caractéristiques] [image] NULL ,
	[TVA Achat] [varchar] (3) COLLATE French_CI_AS NULL ,
	[Fodec Achat] [varchar] (2) COLLATE French_CI_AS NULL ,
	[Frais de Transport] [numeric](38, 18) NULL ,
	[Frais de Stockage] [numeric](38, 18) NULL ,
	[Prix Achat Minimum] [numeric](38, 18) NULL ,
	[Prix Achat Maximum] [numeric](38, 18) NULL ,
	[Mode Calcul Prix Achat] [int] NULL ,
	[Mode Calcul Coût] [int] NULL ,
	[Frais] [numeric](38, 18) NULL ,
	[Coût Unitaire Achat] [numeric](38, 18) NULL ,
	[Désignation Anglaise] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Modèle Etiquette] [int] NULL ,
	[Client] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Respecter le Stock] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Devise Vente] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Prix Nul] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Pointure] [varchar] (20) COLLATE French_CI_AS NULL ,
	[GrPtr] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Type Article] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Gestion par Palette] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Code 2ème Choix] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Sans Programme] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Prix Belbis] [numeric](38, 18) NULL ,
	[Prix PFU] [numeric](38, 18) NULL ,
	[Ne pas gérer par CB] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Qualité] [int] NULL ,
	[Groupe Second] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Tige] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Désignation Tige] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Fustella] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Désignation Fustella] [varchar] (100) COLLATE French_CI_AS NULL ,
	[Image2] [image] NULL ,
	[AREPARTO] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Volume] [numeric](38, 18) NULL ,
	[NbBoite] [int] NULL ,
	[Sans Commande] [varchar] (1) COLLATE French_CI_AS NULL ,
	[Synthétique] [varchar] (1) COLLATE French_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Article Casier] (
	[Article] [varchar] (20) COLLATE French_CI_AS NOT NULL ,
	[Casier] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Magasin] [varchar] (10) COLLATE French_CI_AS NULL ,
	[Fournisseur] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Quantité] [numeric](38, 18) NULL ,
	[Client] [varchar] (20) COLLATE French_CI_AS NULL ,
	[BR] [varchar] (20) COLLATE French_CI_AS NULL ,
	[Flag] [int] NULL ,
	[Quantité Réservée] [numeric](38, 18) NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Programme] WITH NOCHECK ADD 
	CONSTRAINT [PK_Programme] PRIMARY KEY  CLUSTERED 
	(
		[KEYBARCODE]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[N° Séries] WITH NOCHECK ADD 
	CONSTRAINT [PK_N° Séries] PRIMARY KEY  CLUSTERED 
	(
		[Num]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Mouvement Stock] WITH NOCHECK ADD 
	CONSTRAINT [PK_Mouvement Stock] PRIMARY KEY  CLUSTERED 
	(
		[Numéro]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Ligne Bon de réception] WITH NOCHECK ADD 
	CONSTRAINT [PK_Ligne Bon de réception] PRIMARY KEY  CLUSTERED 
	(
		[Numéro],
		[Ligne]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Ligne Réception Lecture] WITH NOCHECK ADD 
	CONSTRAINT [PK_Ligne Réception Lecture] PRIMARY KEY  CLUSTERED 
	(
		[Numéro],
		[N° Série]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Article Pointure] WITH NOCHECK ADD 
	CONSTRAINT [PK_Article Pointure] PRIMARY KEY  CLUSTERED 
	(
		[Article],
		[Pointure]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[Article] WITH NOCHECK ADD 
	CONSTRAINT [PK_Article_1] PRIMARY KEY  CLUSTERED 
	(
		[Code]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_Programme] ON [dbo].[Programme]([PROGR]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Programme_1] ON [dbo].[Programme]([N° Carton]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Programme_2] ON [dbo].[Programme]([NUMORD2]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Programme_3] ON [dbo].[Programme]([NBOLLA]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Programme_4] ON [dbo].[Programme]([NUMORD]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [Programme7] ON [dbo].[Programme]([TAGLIA], [NUMORD], [NUMORD2]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Programme_5] ON [dbo].[Programme]([ARTICOLO]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Programme_6] ON [dbo].[Programme]([Date Magasin2]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_N° Séries] ON [dbo].[N° Séries]([N° Série]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_N° Séries_1] ON [dbo].[N° Séries]([Article]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Mouvement Stock] ON [dbo].[Mouvement Stock]([Document]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

ALTER TABLE [dbo].[Ligne Bon de réception] ADD 
	CONSTRAINT [CK_Ligne Bon de réception] CHECK ([Article] is null and [unité] is null and [type Ligne] = 1 or [Article] is not null and [unité] is not null)
GO

 CREATE  INDEX [IX_Ligne Bon de réception] ON [dbo].[Ligne Bon de réception]([Numéro]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

ALTER TABLE [dbo].[Ligne Réception Lecture] ADD 
	CONSTRAINT [IX_Ligne Réception Lecture] UNIQUE  NONCLUSTERED 
	(
		[Numéro],
		[Ligne]
	) WITH  FILLFACTOR = 90  ON [PRIMARY] 
GO

 CREATE  INDEX [IX_Ligne Réception Lecture_1] ON [dbo].[Ligne Réception Lecture]([N° Série]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Ligne Réception Lecture_2] ON [dbo].[Ligne Réception Lecture]([Article]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Ligne Réception Lecture_3] ON [dbo].[Ligne Réception Lecture]([Groupe2]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Tout] ON [dbo].[Tout]([Date]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Tout_1] ON [dbo].[Tout]([Article]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Tout_2] ON [dbo].[Tout]([Prog]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

 CREATE  INDEX [IX_Tout_3] ON [dbo].[Tout]([Ordine]) WITH  FILLFACTOR = 90 ON [PRIMARY]
GO

ALTER TABLE [dbo].[Article] ADD 
	CONSTRAINT [CK_Article] CHECK (((not([code] like ' %'))))
GO

ALTER TABLE [dbo].[Mouvement Stock] ADD 
	CONSTRAINT [FK_Mouvement Stock_Casier] FOREIGN KEY 
	(
		[Casier]
	) REFERENCES [dbo].[Casier] (
		[Code]
	),
	CONSTRAINT [FK_Mouvement Stock_Famille] FOREIGN KEY 
	(
		[Famille]
	) REFERENCES [dbo].[Famille] (
		[Code]
	),
	CONSTRAINT [FK_Mouvement Stock_Fournisseur] FOREIGN KEY 
	(
		[Fournisseur]
	) REFERENCES [dbo].[Fournisseur] (
		[Code]
	),
	CONSTRAINT [FK_Mouvement Stock_Magasin] FOREIGN KEY 
	(
		[Magasin]
	) REFERENCES [dbo].[Magasin] (
		[Code]
	),
	CONSTRAINT [FK_Mouvement Stock_Unité article] FOREIGN KEY 
	(
		[Article],
		[Unité]
	) REFERENCES [dbo].[Unité article] (
		[Article],
		[unité]
	)
GO

ALTER TABLE [dbo].[Ligne Bon de réception] ADD 
	CONSTRAINT [FK_Ligne Bon de réception_Casier] FOREIGN KEY 
	(
		[Casier]
	) REFERENCES [dbo].[Casier] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Client] FOREIGN KEY 
	(
		[Client]
	) REFERENCES [dbo].[Client] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de récéption_En-tête Bon de Récéption] FOREIGN KEY 
	(
		[Numéro]
	) REFERENCES [dbo].[En-tête Bon de Réception] (
		[Numéro]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Famille] FOREIGN KEY 
	(
		[Famille]
	) REFERENCES [dbo].[Famille] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Fodec] FOREIGN KEY 
	(
		[Fodec]
	) REFERENCES [dbo].[Fodec] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Magasin] FOREIGN KEY 
	(
		[Magasin]
	) REFERENCES [dbo].[Magasin] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Propriété1] FOREIGN KEY 
	(
		[Propriété1]
	) REFERENCES [dbo].[Propriété1] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Propriété2] FOREIGN KEY 
	(
		[Propriété2]
	) REFERENCES [dbo].[Propriété2] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Propriété3] FOREIGN KEY 
	(
		[Propriété3]
	) REFERENCES [dbo].[Propriété3] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Propriété4] FOREIGN KEY 
	(
		[Propriété4]
	) REFERENCES [dbo].[Propriété4] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Propriété5] FOREIGN KEY 
	(
		[Propriété5]
	) REFERENCES [dbo].[Propriété5] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Sous Famille] FOREIGN KEY 
	(
		[Famille],
		[Sous Famille]
	) REFERENCES [dbo].[Sous Famille] (
		[Famille],
		[Code]
	),
	CONSTRAINT [FK_Ligne Bon de récéption_Unité article] FOREIGN KEY 
	(
		[Article],
		[Unité]
	) REFERENCES [dbo].[Unité article] (
		[Article],
		[unité]
	),
	CONSTRAINT [FK_Ligne Bon de réception_Variante] FOREIGN KEY 
	(
		[Variante],
		[Article]
	) REFERENCES [dbo].[Variante] (
		[Variante],
		[Article]
	)
GO

ALTER TABLE [dbo].[Ligne Réception Lecture] ADD 
	CONSTRAINT [FK_Ligne Réception Lecture_Casier] FOREIGN KEY 
	(
		[Casier]
	) REFERENCES [dbo].[Casier] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Client] FOREIGN KEY 
	(
		[Client]
	) REFERENCES [dbo].[Client] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_En-tête Bon de Réception] FOREIGN KEY 
	(
		[Numéro]
	) REFERENCES [dbo].[En-tête Bon de Réception] (
		[Numéro]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Fournisseur] FOREIGN KEY 
	(
		[Fournisseur]
	) REFERENCES [dbo].[Fournisseur] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Magasin] FOREIGN KEY 
	(
		[Magasin]
	) REFERENCES [dbo].[Magasin] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Panne] FOREIGN KEY 
	(
		[Panne]
	) REFERENCES [dbo].[Panne] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Propriété1] FOREIGN KEY 
	(
		[Propriété1]
	) REFERENCES [dbo].[Propriété1] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Propriété2] FOREIGN KEY 
	(
		[Propriété2]
	) REFERENCES [dbo].[Propriété2] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Propriété3] FOREIGN KEY 
	(
		[Propriété3]
	) REFERENCES [dbo].[Propriété3] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Propriété4] FOREIGN KEY 
	(
		[Propriété4]
	) REFERENCES [dbo].[Propriété4] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Propriété5] FOREIGN KEY 
	(
		[Propriété5]
	) REFERENCES [dbo].[Propriété5] (
		[Code]
	),
	CONSTRAINT [FK_Ligne Réception Lecture_Variante] FOREIGN KEY 
	(
		[Variante],
		[Article]
	) REFERENCES [dbo].[Variante] (
		[Variante],
		[Article]
	)
GO

ALTER TABLE [dbo].[Article] ADD 
	CONSTRAINT [FK_Article_Article] FOREIGN KEY 
	(
		[Réference de remplacement]
	) REFERENCES [dbo].[Article] (
		[Code]
	),
	CONSTRAINT [FK_Article_Client] FOREIGN KEY 
	(
		[Client]
	) REFERENCES [dbo].[Client] (
		[Code]
	),
	CONSTRAINT [FK_Article_Devise] FOREIGN KEY 
	(
		[Devise Vente]
	) REFERENCES [dbo].[Devise] (
		[Code]
	),
	CONSTRAINT [FK_Article_Famille] FOREIGN KEY 
	(
		[Famille]
	) REFERENCES [dbo].[Famille] (
		[Code]
	),
	CONSTRAINT [FK_Article_Fodec] FOREIGN KEY 
	(
		[Fodec]
	) REFERENCES [dbo].[Fodec] (
		[Code]
	),
	CONSTRAINT [FK_Article_Fodec1] FOREIGN KEY 
	(
		[Fodec Achat]
	) REFERENCES [dbo].[Fodec] (
		[Code]
	),
	CONSTRAINT [FK_Article_Marque] FOREIGN KEY 
	(
		[Marque]
	) REFERENCES [dbo].[Marque] (
		[Code]
	),
	CONSTRAINT [FK_Article_NGP] FOREIGN KEY 
	(
		[NGP]
	) REFERENCES [dbo].[NGP] (
		[Code]
	),
	CONSTRAINT [FK_Article_Plan Comptable] FOREIGN KEY 
	(
		[Compte]
	) REFERENCES [dbo].[Plan Comptable] (
		[Code]
	),
	CONSTRAINT [FK_Article_Sous Famille] FOREIGN KEY 
	(
		[Famille],
		[Sous Famille]
	) REFERENCES [dbo].[Sous Famille] (
		[Famille],
		[Code]
	),
	CONSTRAINT [FK_Article_TVA] FOREIGN KEY 
	(
		[TVA]
	) REFERENCES [dbo].[TVA] (
		[Code]
	),
	CONSTRAINT [FK_Article_TVA1] FOREIGN KEY 
	(
		[TVA Achat]
	) REFERENCES [dbo].[TVA] (
		[Code]
	),
	CONSTRAINT [FK_Article_Unité] FOREIGN KEY 
	(
		[Unité]
	) REFERENCES [dbo].[Unité] (
		[Code]
	),
	CONSTRAINT [FK_Article_Unité article] FOREIGN KEY 
	(
		[Code],
		[Unité]
	) REFERENCES [dbo].[Unité article] (
		[Article],
		[unité]
	) ON DELETE CASCADE  ON UPDATE CASCADE 
GO