Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Framework » Issues with Radicore V 1.75
Re: Issues with Radicore V 1.75 [message #3135 is a reply to message #3133] Wed, 07 November 2012 21:40 Go to previous messageGo to previous message
juanguilarte is currently offline  juanguilarte
Messages: 27
Registered: June 2012
Junior Member
Sure this is the create script:

CREATE TABLE "TREOMDP_SISTEMA_PAGOS"."REG_MOV_FAC"
( "EMPRESA_FT" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"BIN_TARJ_FT" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NUM_TARJ_FT" FLOAT(126) DEFAULT '0' NOT NULL ENABLE,
"CONSE_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"COD_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NUM_AUTO_MOV" CHAR(7 CHAR) DEFAULT '0' NOT NULL ENABLE,
"NRO_COMER_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NUM_SUC_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"MONTO_MOV" FLOAT(126) NOT NULL ENABLE,
"MONEDA_MOV" CHAR(2 CHAR) DEFAULT 'BS' NOT NULL ENABLE,
"MONTO_EXT_MOV" FLOAT(126) NOT NULL ENABLE,
"MONEDA_EXT_MOV" VARCHAR2(2 CHAR) DEFAULT ' ' NOT NULL ENABLE,
"MONTO_INTER_MOV" FLOAT(126) NOT NULL ENABLE,
"MONEDA_INTER_MOV" VARCHAR2(2 CHAR) DEFAULT ' ' NOT NULL ENABLE,
"FECHA_PRO_MOV" DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
"NOMBRE_CON_MOV" CHAR(25 CHAR) NOT NULL ENABLE,
"FECHA_TRAN_MOV" DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
"CONT_COM_MOV" CHAR(1 CHAR) NOT NULL ENABLE,
"FECHA_DEP_MOV" DATE DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
"CON_NRO_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"NOM_PAIS_MOV" CHAR(8 CHAR) NOT NULL ENABLE,
"PROCED_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"TIPO_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"MARCA_AJU_MOV" CHAR(1 CHAR) NOT NULL ENABLE,
"NRO_REF_INC_MOV" CHAR(23 CHAR) NOT NULL ENABLE,
"CATEGORIA_COMER_MOV" NUMBER(10,0) DEFAULT '0' NOT NULL ENABLE,
"FECHA_FT" CHAR(10 CHAR) DEFAULT to_date('0001-01-01', 'yyyy-mm-dd') NOT NULL ENABLE,
CONSTRAINT "PRIMARY_31" PRIMARY KEY ("BIN_TARJ_FT", "NUM_TARJ_FT", "FECHA_FT", "CONSE_MOV")

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Accessing to Radicore from mobile phones
Next Topic: RADICORE V 1.76
Goto Forum:
  


Current Time: Mon Nov 25 23:45:01 EST 2024

Total time taken to generate the page: 0.03200 seconds