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
|
CREATE TABLE [dbo].[F_DOCENTETE](
[DO_Domaine] [smallint] NULL,
[DO_Type] [smallint] NULL,
[DO_Piece] [varchar](9) COLLATE French_CI_AS NULL,
[cbDO_Piece] AS (CONVERT([varbinary](10),space((10)-(len([DO_Piece])+(1)))+[DO_Piece],0)),
[DO_Date] [smalldatetime] NULL,
[DO_Ref] [varchar](17) COLLATE French_CI_AS NULL,
[DO_Tiers] [varchar](17) COLLATE French_CI_AS NULL,
[cbDO_Tiers] AS (CONVERT([varbinary](18),isnull([DO_Tiers],''),0)),
[DO_Period] [smallint] NULL,
[DO_Devise] [smallint] NULL,
[DO_Cours] [numeric](24, 6) NULL,
[DE_No] [int] NULL,
[cbDE_No] [int] NULL,
[LI_No] [int] NULL,
[cbLI_No] [int] NULL,
[CT_NumPayeur] [varchar](17) COLLATE French_CI_AS NULL,
[cbCT_NumPayeur] AS (CONVERT([varbinary](18),isnull([CT_NumPayeur],''),0)),
[DO_Expedit] [smallint] NULL,
[DO_NbFacture] [smallint] NULL,
[DO_BLFact] [smallint] NULL,
[DO_TxEscompte] [numeric](24, 6) NULL,
[DO_Reliquat] [smallint] NULL,
[DO_Imprim] [smallint] NULL,
[CA_Num] [varchar](13) COLLATE French_CI_AS NULL,
[cbCA_Num] AS (CONVERT([varbinary](14),isnull([CA_Num],''),0)),
[DO_Coord01] [varchar](25) COLLATE French_CI_AS NULL,
[DO_Coord02] [varchar](25) COLLATE French_CI_AS NULL,
[DO_Coord03] [varchar](25) COLLATE French_CI_AS NULL,
[DO_Coord04] [varchar](25) COLLATE French_CI_AS NULL,
[DO_Souche] [smallint] NULL,
[DO_DateLivr] [smalldatetime] NULL,
[DO_Condition] [smallint] NULL,
[DO_Tarif] [smallint] NULL,
[DO_Colisage] [smallint] NULL,
[DO_TypeColis] [smallint] NULL,
[DO_Transaction] [smallint] NULL,
[DO_Langue] [smallint] NULL,
[DO_Ecart] [numeric](24, 6) NULL,
[DO_Regime] [smallint] NULL,
[N_CatCompta] [smallint] NULL,
[DO_Ventile] [smallint] NULL,
[AB_No] [int] NULL,
[DO_DebutAbo] [smalldatetime] NULL,
[DO_FinAbo] [smalldatetime] NULL,
[DO_DebutPeriod] [smalldatetime] NULL,
[DO_FinPeriod] [smalldatetime] NULL,
[CG_Num] [varchar](13) COLLATE French_CI_AS NULL,
[cbCG_Num] AS (CONVERT([varbinary](14),isnull([CG_Num],''),0)),
[DO_Statut] [smallint] NULL,
[DO_Heure] [char](9) COLLATE French_CI_AS NULL,
[CA_No] [int] NULL,
[cbCA_No] [int] NULL,
[DO_Transfere] [smallint] NULL,
[DO_Cloture] [smallint] NULL,
[DO_NoWeb] [varchar](17) COLLATE French_CI_AS NULL,
[DO_Attente] [smallint] NULL,
[DO_Provenance] [smallint] NULL,
[CA_NumIFRS] [varchar](13) COLLATE French_CI_AS NULL,
[MR_No] [int] NULL,
[DO_TypeFrais] [smallint] NULL,
[DO_ValFrais] [numeric](24, 6) NULL,
[DO_TypeLigneFrais] [smallint] NULL,
[DO_TypeFranco] [smallint] NULL,
[DO_ValFranco] [numeric](24, 6) NULL,
[DO_TypeLigneFranco] [smallint] NULL,
[DO_Taxe1] [numeric](24, 6) NULL,
[DO_TypeTaux1] [smallint] NULL,
[DO_TypeTaxe1] [smallint] NULL,
[DO_Taxe2] [numeric](24, 6) NULL,
[DO_TypeTaux2] [smallint] NULL,
[DO_TypeTaxe2] [smallint] NULL,
[DO_Taxe3] [numeric](24, 6) NULL,
[DO_TypeTaux3] [smallint] NULL,
[DO_TypeTaxe3] [smallint] NULL,
[DO_MajCpta] [smallint] NULL,
[DO_Motif] [varchar](69) COLLATE French_CI_AS NULL,
[CT_NumCentrale] [varchar](17) COLLATE French_CI_AS NULL,
[cbCT_NumCentrale] AS (CONVERT([varbinary](18),isnull([CT_NumCentrale],''),0)),
[DO_Contact] [varchar](35) COLLATE French_CI_AS NULL,
[cbProt] [smallint] NULL DEFAULT ((0)),
[cbMarq] [int] IDENTITY(1,1) NOT NULL,
[cbCreateur] [char](4) COLLATE French_CI_AS NULL DEFAULT ('CSQL'),
[cbModification] [smalldatetime] NULL DEFAULT (getdate()),
[cbReplication] [int] NULL DEFAULT ((0)),
[cbFlag] [smallint] NULL DEFAULT ((0)),
[Date_Signature] [smalldatetime] NULL,
[Commentaire] [varchar](69) COLLATE French_CI_AS NULL,
[CO_No] [int] NULL,
[cbCO_No] [int] NULL,
[CO_NoCaissier] [int] NULL,
[cbCO_NoCaissier] [int] NULL,
[DO_FactureElec] [smallint] NULL,
[DO_TypeTransac] [smallint] NULL,
[Date_debut] [smalldatetime] NULL,
[Date_fin] [smalldatetime] NULL,
[Ref_BDC] [varchar](69) COLLATE French_CI_AS NULL |
Partager