1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| CREATE TABLE [dbo].[INTERVENTION] (
[IN_NUMINTER] [varchar] (15) COLLATE French_CI_AS NOT NULL ,
[IN_NUMCLT] [varchar] (13) COLLATE French_CI_AS NOT NULL ,
[IN_M_NUMCLT] [varchar] (13) COLLATE French_CI_AS NOT NULL ,
[IN_IDMAT] [numeric](13, 0) NOT NULL ,
[IN_RESINTER] [varchar] (250) COLLATE French_CI_AS NOT NULL ,
[IN_ETAINTER] [varchar] (15) COLLATE French_CI_AS NULL ,
[IN_LIEINTER] [nchar] (16) COLLATE French_CI_AS NOT NULL ,
[IN_DEPOMAT] [char] (50) COLLATE French_CI_AS NULL ,
[IN_RECEPMAT] [char] (20) COLLATE French_CI_AS NULL ,
[IN_PRICHARG] [datetime] NULL ,
[IN_DISPOMAT] [datetime] NULL ,
[IN_RECUPMAT] [datetime] NULL ,
[IN_DUREEREP] [decimal](18, 0) NULL ,
[IN_DUREMOY] [decimal](18, 0) NULL ,
[IN_HPASSE] [decimal](18, 0) NULL ,
[IN_HFACTUR] [decimal](18, 0) NULL
) ON [PRIMARY]
GO
Insert into INTERVENTION (IN_NUMINTER, IN_NUMCLT, IN_M_NUMCLT, IN_IDMAT, IN_RESINTER, IN_ETAINTER, IN_LIEINTER, IN_DEPOMAT, IN_RECEPMAT, IN_PRICHARG, IN_DISPOMAT, IN_RECUPMAT, IN_HPASSE, IN_HFACTUR) Values ('2008/02/01-001', 'hf', 'hf', '1', 'tjhnj', 'en attente', 'Boutique', 'dr', 'bidul', '01/02/2008', '29/02/2008', '10/03/2008', '15', '12')
Insert into INTERVENTION (IN_NUMINTER, IN_NUMCLT, IN_M_NUMCLT, IN_IDMAT, IN_RESINTER, IN_ETAINTER, IN_LIEINTER, IN_DEPOMAT, IN_RECEPMAT, IN_PRICHARG, IN_DISPOMAT, IN_RECUPMAT, IN_HPASSE, IN_HFACTUR) Values ('2008/03/15-002', 'jh', 'jh', '2', 'th', 'demande', 'Site / Boutique', 'fz', 'truc muche', '15/03/2008', '17/03/2008', '19/03/2008', '25', '24')
Insert into INTERVENTION (IN_NUMINTER, IN_NUMCLT, IN_M_NUMCLT, IN_IDMAT, IN_RESINTER, IN_ETAINTER, IN_LIEINTER, IN_DEPOMAT, IN_RECEPMAT, IN_PRICHARG, IN_DISPOMAT, IN_RECUPMAT, IN_HPASSE, IN_HFACTUR) Values ('2008/03/16-001', 'jh', 'jh', '2', 'fhy', 'demande', 'Site', 'dr', 'bidul', '16/03/2008', '16/03/2008', '16/03/2008', '15', '16') |
Partager