🏠 Menú principal

← Volver a tablas

---

SIMACMOBILE.MAESTRO_CLIENTE_NUEVO_CSV

Base de datos origen: ORCLSMM

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	PARAM_NIT	VARCHAR2(300)	SI
2	PARTY_NUMBER	VARCHAR2(300)	SI
3	PARTY_ID	VARCHAR2(300)	SI
4	STATUS	VARCHAR2(300)	SI
5	PARTY_NAME	VARCHAR2(300)	SI
6	NIT	VARCHAR2(300)	SI
7	PARTY_TYPE	VARCHAR2(300)	SI
8	ACCOUNTING_DATE	VARCHAR2(300)	SI
9	PERSON_FIRST_NAME	VARCHAR2(300)	SI
10	PERSON_LAST_NAME	VARCHAR2(300)	SI
11	PERSON_SECOND_LAST_NAME	VARCHAR2(300)	SI
12	PERSON_MIDDLE_NAME	VARCHAR2(300)	SI
13	ORIG_SYSTEM_REFERENCE	VARCHAR2(300)	SI
14	PARTY_SITE_NAME	VARCHAR2(300)	SI
15	PARTY_SITE_NUMBER	VARCHAR2(300)	SI
16	PARTY_SITE_FROM_DATE	VARCHAR2(300)	SI
17	ADDRESS1	VARCHAR2(300)	SI
18	ADDRESS2	VARCHAR2(300)	SI
19	CITY	VARCHAR2(300)	SI
20	STATES	VARCHAR2(300)	SI
21	POSTAL_CODE	VARCHAR2(300)	SI
22	COUNTRY	VARCHAR2(300)	SI
23	LATITUD	VARCHAR2(300)	SI
24	LONGITUD	VARCHAR2(300)	SI
25	MAILSTOP	VARCHAR2(300)	SI
26	PHONE_NUMBER	VARCHAR2(300)	SI
27	TELEFONO_OFICINA	VARCHAR2(300)	SI
28	CATEGORIA_CLIENTE	VARCHAR2(300)	SI
29	TIPO_COBERTURA	VARCHAR2(300)	SI
30	ASEGURADO_CON	VARCHAR2(300)	SI
31	TIPO_SEGURO	VARCHAR2(300)	SI
32	CUPO_SUGERIDO_YNDIKA	VARCHAR2(300)	SI
33	CALIFICACION_RIIM	VARCHAR2(300)	SI
34	CAL_RIIM	VARCHAR2(300)	SI
35	CUENTA_CON_ABOGADO	VARCHAR2(300)	SI
36	ESTADO_CREDITO	VARCHAR2(300)	SI
37	CALIFICACION_MONITOR	VARCHAR2(300)	SI
38	FECHA_ULT_VENTA	VARCHAR2(300)	SI
39	TRAT_DATOS_PERSONALES	VARCHAR2(300)	SI
40	CORREO_FE	VARCHAR2(300)	SI
41	OPER_CREA	VARCHAR2(300)	SI
42	OPER_MODIFICA	VARCHAR2(300)	SI
43	FECHA_CREACION	VARCHAR2(300)	SI
44	FECHA_MODIFICA	VARCHAR2(300)	SI
45	NATURALEZA	VARCHAR2(300)	SI
46	SUCURSAL	VARCHAR2(300)	SI
47	FECHA_CREACION_SIMAC	VARCHAR2(300)	SI
48	TERMINO_PAGO	VARCHAR2(300)	SI
49	TIPO_CLIENTE_VENTA	VARCHAR2(300)	SI

Restricciones

Sin restricciones visibles (P/R/U/C).

DDL

CREATE TABLE "SIMACMOBILE"."MAESTRO_CLIENTE_NUEVO_CSV" 
   (	"PARAM_NIT" VARCHAR2(300), 
	"PARTY_NUMBER" VARCHAR2(300), 
	"PARTY_ID" VARCHAR2(300), 
	"STATUS" VARCHAR2(300), 
	"PARTY_NAME" VARCHAR2(300), 
	"NIT" VARCHAR2(300), 
	"PARTY_TYPE" VARCHAR2(300), 
	"ACCOUNTING_DATE" VARCHAR2(300), 
	"PERSON_FIRST_NAME" VARCHAR2(300), 
	"PERSON_LAST_NAME" VARCHAR2(300), 
	"PERSON_SECOND_LAST_NAME" VARCHAR2(300), 
	"PERSON_MIDDLE_NAME" VARCHAR2(300), 
	"ORIG_SYSTEM_REFERENCE" VARCHAR2(300), 
	"PARTY_SITE_NAME" VARCHAR2(300), 
	"PARTY_SITE_NUMBER" VARCHAR2(300), 
	"PARTY_SITE_FROM_DATE" VARCHAR2(300), 
	"ADDRESS1" VARCHAR2(300), 
	"ADDRESS2" VARCHAR2(300), 
	"CITY" VARCHAR2(300), 
	"STATES" VARCHAR2(300), 
	"POSTAL_CODE" VARCHAR2(300), 
	"COUNTRY" VARCHAR2(300), 
	"LATITUD" VARCHAR2(300), 
	"LONGITUD" VARCHAR2(300), 
	"MAILSTOP" VARCHAR2(300), 
	"PHONE_NUMBER" VARCHAR2(300), 
	"TELEFONO_OFICINA" VARCHAR2(300), 
	"CATEGORIA_CLIENTE" VARCHAR2(300), 
	"TIPO_COBERTURA" VARCHAR2(300), 
	"ASEGURADO_CON" VARCHAR2(300), 
	"TIPO_SEGURO" VARCHAR2(300), 
	"CUPO_SUGERIDO_YNDIKA" VARCHAR2(300), 
	"CALIFICACION_RIIM" VARCHAR2(300), 
	"CAL_RIIM" VARCHAR2(300), 
	"CUENTA_CON_ABOGADO" VARCHAR2(300), 
	"ESTADO_CREDITO" VARCHAR2(300), 
	"CALIFICACION_MONITOR" VARCHAR2(300), 
	"FECHA_ULT_VENTA" VARCHAR2(300), 
	"TRAT_DATOS_PERSONALES" VARCHAR2(300), 
	"CORREO_FE" VARCHAR2(300), 
	"OPER_CREA" VARCHAR2(300), 
	"OPER_MODIFICA" VARCHAR2(300), 
	"FECHA_CREACION" VARCHAR2(300), 
	"FECHA_MODIFICA" VARCHAR2(300), 
	"NATURALEZA" VARCHAR2(300), 
	"SUCURSAL" VARCHAR2(300), 
	"FECHA_CREACION_SIMAC" VARCHAR2(300), 
	"TERMINO_PAGO" VARCHAR2(300), 
	"TIPO_CLIENTE_VENTA" VARCHAR2(300)
   ) 
   ORGANIZATION EXTERNAL 
    ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "DIR_ARCHIVOS_TMP_CLIENTE_NUEVO"
      ACCESS PARAMETERS
      ( records delimited BY newline CHARACTERSET 'UTF8'
fields terminated BY '|')
      LOCATION
       ( 'maestroClienteNuevo.csv'
       )
    )
   REJECT LIMIT 0 ;

GRANT SELECT ON "SIMACMOBILE"."MAESTRO_CLIENTE_NUEVO_CSV" TO "ROL_SELECT";
  GRANT SELECT ON "SIMACMOBILE"."MAESTRO_CLIENTE_NUEVO_CSV" TO "CONSULTA";
  GRANT SELECT ON "SIMACMOBILE"."MAESTRO_CLIENTE_NUEVO_CSV" TO "MICRO_GARANTIAS";
  GRANT SELECT ON "SIMACMOBILE"."MAESTRO_CLIENTE_NUEVO_CSV" TO "APLICACIONES";

---

← Volver a tablas de SIMACMOBILE

🏠 Volver al menú principal