CREATE TABLE IF NOT EXISTS `commandes_fournisseurs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`id_fournisseur` int(11) NOT NULL DEFAULT '0',
`date` date DEFAULT NULL,
`statut_details` enum('A','R','L') DEFAULT 'A',
`commentaires` text,
`montant_ht_brut` float(8,2) NOT NULL,
`montant_ht` float(8,2) NOT NULL,
`montant_tva` float(8,2) NOT NULL,
`montant_ttc` float(8,2) NOT NULL,
`paiement` varchar(25) NOT NULL DEFAULT '',
`cout_transport` float(6,2) DEFAULT NULL,
`ht_recu` float(8,2) NOT NULL,
`ttc_recu` float(8,2) NOT NULL,
`tva_recu` float(8,2) NOT NULL,
`transport_recu` float(6,2) NOT NULL,
`remise` int(10) NOT NULL DEFAULT '0',
`date_reception` datetime DEFAULT NULL,
`sujet_email` varchar(255) NOT NULL,
`date_envoi_email` date NOT NULL,
`annule_reliquat` enum('0','1') NOT NULL DEFAULT '0',
`paye` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=24 ;
Partager