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
|
[pk_cot] [int] IDENTITY(1,1) NOT NULL,
[cot_pers_cpt] [int] NULL,
[cot_couple] [bit] NOT NULL CONSTRAINT [DF__Cotisatio__cot_c__5441852A] DEFAULT ((0)),
[cot_pers_liee_cpt] [int] NULL,
[cot_adh] [bit] NOT NULL CONSTRAINT [DF__Cotisatio__cot_a__5535A963] DEFAULT ((0)),
[cot_don] [bit] NOT NULL CONSTRAINT [DF__Cotisatio__cot_d__5629CD9C] DEFAULT ((0)),
[cot_first_adh] [datetime] NULL,
[cot_date_cot] [datetime] NULL,
[cot_tranche_tarif] [int] NULL,
[cot_reg] [int] NULL,
[cot_fed] [int] NULL,
[cot_sec] [int] NULL,
[cot_origine] [varchar](50) COLLATE French_CI_AI NULL,
[cot_observation] [ntext] COLLATE French_CI_AI NULL,
[cot_recu] [varchar](50) COLLATE French_CI_AI NULL,
[cot_periode] [int] NULL,
[cot_fin] [datetime] NULL,
[cot_statut] [int] NULL,
[cot_motif_invalide] [int] NULL,
[cot_montant] [float] NULL,
[cot_mode_paiement] [varchar](50) COLLATE French_CI_AI NULL,
[cot_annee] [int] NULL,
[cot_date_relance] [datetime] NULL,
[cot_nb_relance] [int] NULL,
[cot_date_cloture] [datetime] NULL,
[cot_libelle_arret] [varchar](50) COLLATE French_CI_AI NULL,
[cot_current] [bit] NOT NULL CONSTRAINT [DF__Cotisatio__cot_c__6B24EA82] DEFAULT ((0)) |
Partager