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
| 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(14, 2),
"MHT" NUMERIC(14, 2),
"COI" SMALLinteger,
"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,
PRIMARY KEY ("DAT", "BON", "ORD")
);
CREATE TABLE "STK"
(
"DAT" DATE NOT NULL,
"PRO" VARCHAR(10) CHARACTER SET ISO8859_1 not null,
"PUA" NUMERIC(14, 5) not null,
"DES" VARCHAR(255) CHARACTER SET ISO8859_1,
"QTO" NUMERIC(14,5),
"QTA" NUMERIC(14,5),
"QTV" NUMERIC(14,5),
"QTR" NUMERIC(14,5),
"MON" NUMERIC(14,2),
PRIMARY KEY ("DAT", "PRO","PUA")
); |
Partager