Gracias por contestar.
Uso InterBase 6 Open Source y Delphi 6.
los componentes IBx.
CREATE TABLE "ENCABEZADONOTA"
(
"IDENCABEZADONOTA" "ID",
"TIPOVENTA" "CADENA",
"VENDEDOR" "CADENA",
"CLIENTE" "CADENA",
"PLAZO" "CADENA",
"FECHALIMITEPAGO" DATE,
"ENGANCHE" DECIMAL(15, 2) Default 0.00,
"RESTO" DECIMAL(15, 2) Default 0.00,
"LUGAREXPEDICION" "CADENA",
"VIAEMBARQUE" "CADENA",
"NUMPEDIDO" "CADENA",
"FECHAVENTA" DATE Default 'Now',
"TOTAL" DECIMAL(15, 2) Default 0.00,
"SUBTOTAL" DECIMAL(15, 2) DEFAULT 0.00,
"IVA" DECIMAL(15, 2) DEFAULT 0.00,
"OBSNOTA" BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET ISO8859_1,
PRIMARY KEY ("IDENCABEZADONOTA")
);
CREATE TABLE "ENCABEZADOFAC"
(
"IDENCABEZADOFAC" "ID",
"TIPOVENTA" "CADENA",
"VENDEDOR" "CADENA",
"CLIENTE" "CADENA",
"PLAZO" "CADENA",
"FECHALIMITEPAGO" DATE,
"ENGANCHE" DECIMAL(15, 2) Default 0.00,
"RESTO" DECIMAL(15, 2) Default 0.00,
"LUGAREXPEDICION" "CADENA",
"VIAEMBARQUE" "CADENA",
"NUMPEDIDO" "CADENA",
"FECHAVENTA" DATE Default 'Now',
"TOTAL" DECIMAL(15, 2) Default 0.00,
"SUBTOTAL" DECIMAL(15, 2) DEFAULT 0.00,
"IVA" DECIMAL(15, 2) DEFAULT 0.00,
"OBSFACTURA" BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET ISO8859_1,
PRIMARY KEY ("IDENCABEZADOFAC")
);
CREATE TABLE "ABONOSNOTA"
(
"IDABONONOTA" "ID",
"IDENCABEZADONOTA" "ID",
"VENDEDOR" VARCHAR(50),
"CANTIDAD" DECIMAL(15, 2) Default 0.00,
"FECHAPAGO" DATE,
"FECHAVENCIMIENTO" DATE,
"INTERES" DECIMAL(15, 2) DEFAULT 0.00,
"TOTAL_A_PAGAR" DECIMAL(15, 2) DEFAULT 0.00,
"SUPAGO" DECIMAL(15, 2) DEFAULT 0.00,
"PAGADO" "SI_NO",
PRIMARY KEY ("IDABONONOTA")
);
CREATE TABLE "ABONOSFAC"
(
"IDABONOFAC" "ID",
"IDENCABEZADOFAC" "ID",
"VENDEDOR" VARCHAR(50),
"CANTIDAD" DECIMAL(15, 2) Default 0.00,
"FECHAPAGO" DATE,
"FECHAVENCIMIENTO" DATE,
"INTERES" DECIMAL(15, 1) DEFAULT 0.00,
"TOTAL_A_PAGAR" DECIMAL(15, 2) DEFAULT 0.00,
"SUPAGO" DECIMAL(15, 2) DEFAULT 0.00,
"PAGADO" "SI_NO",
PRIMARY KEY ("IDABONOFAC")
);
CREATE TABLE "GASTOS"
(
"IDGASTOS" "ID" NOT NULL,
"FECHA" DATE DEFAULT 'Now',
"AUTORIZO" "CADENA",
"SOLICITO" "CADENA",
"CONCEPTO" BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET ISO8859_1,
"CANTIDAD" DECIMAL(15, 2),
CONSTRAINT "PK_GASTOS" PRIMARY KEY ("IDGASTOS")
);
Ojala y me puedan ayudar....
Saludos.
|