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 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125
| USE [AMECAPCOM]
GO
/****** Object: Table [dbo].[MVTL] Script Date: 09/22/2014 10:57:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[MVTL](
[MVTL_ID] [int] IDENTITY(1,1) NOT NULL,
[CE1] [char](1) NOT NULL,
[CE2] [char](1) NOT NULL,
[CE3] [char](1) NOT NULL,
[CE4] [char](1) NOT NULL,
[CE5] [char](1) NOT NULL,
[CE6] [char](1) NOT NULL,
[CE7] [char](1) NOT NULL,
[CE8] [char](1) NOT NULL,
[CE9] [char](1) NOT NULL,
[CEA] [char](1) NOT NULL,
[DOS] [numeric](3, 0) NOT NULL,
[REF] [char](25) NOT NULL,
[SREF1] [char](8) NOT NULL,
[SREF2] [char](8) NOT NULL,
[TICOD] [char](1) NOT NULL,
[PICOD] [numeric](1, 0) NOT NULL,
[TIERS] [char](8) NOT NULL,
[OP] [char](3) NOT NULL,
[USERCR] [char](20) NOT NULL,
[USERMO] [char](20) NOT NULL,
[ENRNO] [numeric](9, 0) NOT NULL,
[LILG] [numeric](4, 0) NOT NULL,
[ETB] [char](3) NOT NULL,
[DEPO] [char](3) NOT NULL,
[LIEU] [char](12) NOT NULL,
[TICKETRES] [numeric](9, 0) NOT NULL,
[BLDT] [date] NULL,
[DELDT] [date] NULL,
[DELDEMDT] [date] NULL,
[DELACCDT] [date] NULL,
[DELREPDT] [date] NULL,
[VTLNO] [numeric](9, 0) NOT NULL,
[VTLNA] [numeric](9, 0) NOT NULL,
[COLINO] [char](9) NOT NULL,
[SERIE] [char](20) NOT NULL,
[NST] [char](2) NOT NULL,
[STDTSQL] [char](8) NOT NULL,
[SENS] [numeric](1, 0) NOT NULL,
[PINO] [numeric](8, 0) NOT NULL,
[BLASLIEU] [char](12) NOT NULL,
[CDVTLNO] [numeric](9, 0) NOT NULL,
[BLASVTLNO] [numeric](9, 0) NOT NULL,
[PEREMPDT] [date] NULL,
[TIERSSTOCK] [char](8) NOT NULL,
[RCONO] [numeric](8, 0) NOT NULL,
[USERCRDH] [datetime2](7) NULL,
[USERMODH] [datetime2](7) NULL,
[CR] [numeric](17, 6) NOT NULL,
[CNCR] [numeric](3, 0) NOT NULL,
[CMP] [numeric](17, 6) NOT NULL,
[CRGAM] [numeric](17, 6) NOT NULL,
[QTE] [numeric](12, 3) NOT NULL,
[REFQTE] [numeric](12, 3) NOT NULL,
[STQTE] [numeric](12, 3) NOT NULL,
[RESQTE] [numeric](12, 3) NOT NULL,
[STRES] [numeric](1, 0) NOT NULL,
[STATUS] [numeric](1, 0) NOT NULL,
[OFRESCOD] [numeric](1, 0) NOT NULL,
[PREVFLG] [numeric](1, 0) NOT NULL,
[UNOPROG] [char](15) NOT NULL,
[UTPROG] [char](1) NOT NULL,
[UPSOLD] [numeric](1, 0) NOT NULL,
[CONSTNO] [numeric](8, 0) NOT NULL,
[UDEROG] [numeric](1, 0) NOT NULL,
[UTIERSCLI] [char](8) NOT NULL,
[CDENRNO] [numeric](9, 0) NOT NULL,
[UNBBAC] [numeric](3, 0) NOT NULL,
[POIN] [numeric](8, 3) NOT NULL,
[UNOLOT] [numeric](8, 0) NOT NULL,
[ULGPROG] [numeric](4, 0) NOT NULL,
[UNONCONF] [numeric](1, 0) NOT NULL,
[LIVNCCOD_0001] [char](1) NOT NULL,
[LIVNCCOD_0002] [char](1) NOT NULL,
[LIVNCCOD_0003] [char](1) NOT NULL,
[LIVNCCOD_0004] [char](1) NOT NULL,
[LIVNCCOD_0005] [char](1) NOT NULL,
[LIVNCCOD_0006] [char](1) NOT NULL,
[LIVNCCOD_0007] [char](1) NOT NULL,
[LIVNCCOD_0008] [char](1) NOT NULL,
[LIVNCCOD_0009] [char](1) NOT NULL,
[LIVNCCOD_0010] [char](1) NOT NULL,
[LIVNCCOD_0011] [char](1) NOT NULL,
[LIVNCCOD_0012] [char](1) NOT NULL,
[LIVNCCOD_0013] [char](1) NOT NULL,
[LIVNCCOD_0014] [char](1) NOT NULL,
[LIVNCCOD_0015] [char](1) NOT NULL,
[LIVNCCOD_0016] [char](1) NOT NULL,
[LIVNCCOD_0017] [char](1) NOT NULL,
[LIVNCCOD_0018] [char](1) NOT NULL,
[LIVNCCOD_0019] [char](1) NOT NULL,
[LIVNCCOD_0020] [char](1) NOT NULL,
[UQCDEI] [numeric](12, 3) NOT NULL,
[UCOLINOF] [char](9) NOT NULL,
[UPTCOLF] [numeric](1, 0) NOT NULL,
[UPTRET] [numeric](1, 0) NOT NULL,
[REBUCOD] [char](4) NOT NULL,
[UQTERET] [numeric](12, 3) NOT NULL,
[USERIECPL] [char](20) NOT NULL,
[UMANUT] [char](10) NOT NULL,
[UMEMBUN] [char](4) NOT NULL,
[EMBUN] [char](4) NOT NULL,
[UNONCONFQU] [numeric](1, 0) NOT NULL,
[WMCONTNO] [numeric](9, 0) NOT NULL,
PRIMARY KEY CLUSTERED
(
[MVTL_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