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 126 127 128 129 130 131 132
|
-- table Achat:
CREATE TABLE ACH
(
CAS Integer NOT NULL,
DAT Date NOT NULL,
FAC Varchar(30) NOT NULL,
ORD Integer NOT NULL,
ANA Varchar(20) CHARACTER SET ISO8859_1,
MAT Varchar(20) CHARACTER SET ISO8859_1,
PRO Varchar(20) CHARACTER SET ISO8859_1,
DES Varchar(255) CHARACTER SET ISO8859_1,
QTE Numeric(14,5),
MHT Numeric(14,2),
COI Integer,
PER Integer,
DAP Date,
CHA Varchar(255) CHARACTER SET ISO8859_1,
IMA Varchar(35) CHARACTER SET ISO8859_1,
MON Numeric(14,2),
OBS Varchar(255) CHARACTER SET ISO8859_1,
PUA Numeric(14,5),
COIR Integer,
DESF Varchar(200) CHARACTER SET ISO8859_1,
MTB Numeric(14,5),
TAU Numeric(14,2),
TVA Numeric(14,5),
TRE Numeric(14,2),
REM Numeric(14,5),
UTI Varchar(50),
COID Integer,
COIF Integer,
PUDEV Numeric(14,6),
TAUXC Numeric(14,6),
FRATRANS Numeric(14,6),
FRADOU Numeric(14,6),
FRAMAN Numeric(14,6),
FRAAUT Numeric(14,6),
DEVISE Varchar(15),
FRATRANSP Numeric(14,6),
PRIMARY KEY (CAS,DAT,FAC,ORD)
);
-- Table VEN
CREATE TABLE VEN
(
DAT Date NOT NULL,
BON Varchar(20) CHARACTER SET ISO8859_1 NOT NULL,
ORD Integer NOT NULL,
ANA Varchar(20) CHARACTER SET ISO8859_1,
PRO Varchar(20) CHARACTER SET ISO8859_1,
DES Varchar(255) CHARACTER SET ISO8859_1,
QTE Numeric(14,5),
PUV Numeric(18,6),
MHT Numeric(14,2),
COI Smallint,
CDR Numeric(14,5),
BEN Numeric(14,2),
FAC Varchar(20) CHARACTER SET ISO8859_1,
HEU Timestamp,
DEN Numeric(14,5),
OBS Varchar(255) CHARACTER SET ISO8859_1,
UME Varchar(30),
ED1 Numeric(14,4),
ED2 Numeric(14,4),
ED3 Numeric(14,4),
QTP Numeric(14,5),
PUA Numeric(14,5),
QTD Numeric(14,5),
QTR Numeric(14,5),
DAP Date,
COIR Integer,
DESCL Varchar(200) CHARACTER SET ISO8859_1,
CHA Varchar(30),
IMA Varchar(15),
MTB Numeric(14,5),
TAU Numeric(14,2),
TVA Numeric(14,5),
TRE Numeric(14,2),
REM Numeric(14,5),
UTI Varchar(50),
COID Integer,
COIF Integer,
MHTR Numeric(18,6),
CLTLIV Char(1),
CPUV Char(1),
PRIMARY KEY (DAT,BON,ORD)
);
-- Table PAF
CREATE TABLE PAF
(
CAS Integer NOT NULL,
DAT Date NOT NULL,
ANA Varchar(20) NOT NULL,
FAC Varchar(20) NOT NULL,
ORD Integer NOT NULL,
DEP Numeric(14,2),
MON Numeric(14,2),
VER Numeric(14,2),
RES Numeric(14,2),
DES Varchar(255) CHARACTER SET ISO8859_1,
MOP Varchar(30) CHARACTER SET ISO8859_1,
DAC Date,
MTB Numeric(14,2),
TVA Numeric(14,5),
REM Numeric(14,5),
TIM Numeric(14,5),
PRIMARY KEY (CAS,DAT,ANA,FAC,ORD)
);
-- Table PAC
CREATE TABLE PAC
(
CAS Integer NOT NULL,
DAT Date NOT NULL,
ANA Varchar(20) NOT NULL,
FAC Varchar(20) NOT NULL,
ORD Integer NOT NULL,
DEP Numeric(14,2),
MON Numeric(14,2),
VER Numeric(14,2),
RES Numeric(14,2),
DES Varchar(255) CHARACTER SET ISO8859_1,
MOP Varchar(30) CHARACTER SET ISO8859_1,
DAC Date,
MTB Numeric(14,2),
TVA Numeric(14,5),
REM Numeric(14,5),
TIM Numeric(14,5),
BEN Numeric(14,2),
PRIMARY KEY (CAS,DAT,ANA,FAC,ORD)
); |
Partager