🏠 Menú principal

← Volver a tablas

---

LACLS.LACLS_CO_THIRD_PARTY

Base de datos origen: PDB1

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	PARTY_ID	NUMBER	NO
2	NIT	VARCHAR2(20)	SI
3	VERIFYING_DIGIT	VARCHAR2(1)	SI
4	DOCUMENT_TYPE	VARCHAR2(20)	SI
5	NAME	VARCHAR2(360)	SI
6	FIRST_NAME	VARCHAR2(60)	SI
7	SECOND_NAME	VARCHAR2(60)	SI
8	FIRST_SURNAME	VARCHAR2(60)	SI
9	SECOND_SURNAME	VARCHAR2(60)	SI
10	COUNTRY_CODE	VARCHAR2(30)	SI
11	STATE_CODE	VARCHAR2(30)	SI
12	CITY_CODE	VARCHAR2(30)	SI
13	ADDRESS	VARCHAR2(360)	SI
14	PHONE_NUMBER	VARCHAR2(20)	SI
15	PHONE_NUMBER2	VARCHAR2(20)	SI
16	CELL_PHONE	VARCHAR2(60)	SI
17	ECONOMIC_ACTIVITY	VARCHAR2(30)	SI
18	EMAIL	VARCHAR2(100)	SI
19	NATURE	VARCHAR2(10)	SI
20	SOURCE	VARCHAR2(20)	SI
21	ADD_ATT1	VARCHAR2(150)	SI
22	ADD_ATT2	VARCHAR2(150)	SI
23	ADD_ATT3	VARCHAR2(150)	SI
24	ADD_ATT4	VARCHAR2(150)	SI
25	ADD_ATT5	VARCHAR2(150)	SI
26	ADD_ATT6	VARCHAR2(150)	SI
27	ADD_ATT7	VARCHAR2(150)	SI
28	ADD_ATT8	VARCHAR2(150)	SI
29	ADD_ATT9	VARCHAR2(150)	SI
30	ADD_ATT10	VARCHAR2(150)	SI
31	ADD_ATT11	VARCHAR2(150)	SI
32	ADD_ATT12	VARCHAR2(150)	SI
33	ADD_ATT13	VARCHAR2(150)	SI
34	ADD_ATT14	VARCHAR2(150)	SI
35	ADD_ATT15	VARCHAR2(150)	SI
36	CREATION_DATE	DATE	SI
37	CREATED_BY	VARCHAR2(64)	SI
38	LAST_UPDATE_DATE	DATE	SI
39	LAST_UPDATED_BY	VARCHAR2(64)	SI
40	LAST_UPDATE_LOGIN	VARCHAR2(32)	SI

Restricciones

CHECK: SYS_C0014598

• Estado: ENABLED
• Columnas: PARTY_ID
• Condición: "PARTY_ID" IS NOT NULL

PK: LACLS_CO_THIRD_PARTY_PK

• Estado: ENABLED
• Columnas: PARTY_ID

DDL

CREATE TABLE "LACLS"."LACLS_CO_THIRD_PARTY" 
   (	"PARTY_ID" NUMBER NOT NULL ENABLE, 
	"NIT" VARCHAR2(20), 
	"VERIFYING_DIGIT" VARCHAR2(1), 
	"DOCUMENT_TYPE" VARCHAR2(20), 
	"NAME" VARCHAR2(360), 
	"FIRST_NAME" VARCHAR2(60), 
	"SECOND_NAME" VARCHAR2(60), 
	"FIRST_SURNAME" VARCHAR2(60), 
	"SECOND_SURNAME" VARCHAR2(60), 
	"COUNTRY_CODE" VARCHAR2(30), 
	"STATE_CODE" VARCHAR2(30), 
	"CITY_CODE" VARCHAR2(30), 
	"ADDRESS" VARCHAR2(360), 
	"PHONE_NUMBER" VARCHAR2(20), 
	"PHONE_NUMBER2" VARCHAR2(20), 
	"CELL_PHONE" VARCHAR2(60), 
	"ECONOMIC_ACTIVITY" VARCHAR2(30), 
	"EMAIL" VARCHAR2(100), 
	"NATURE" VARCHAR2(10), 
	"SOURCE" VARCHAR2(20), 
	"ADD_ATT1" VARCHAR2(150), 
	"ADD_ATT2" VARCHAR2(150), 
	"ADD_ATT3" VARCHAR2(150), 
	"ADD_ATT4" VARCHAR2(150), 
	"ADD_ATT5" VARCHAR2(150), 
	"ADD_ATT6" VARCHAR2(150), 
	"ADD_ATT7" VARCHAR2(150), 
	"ADD_ATT8" VARCHAR2(150), 
	"ADD_ATT9" VARCHAR2(150), 
	"ADD_ATT10" VARCHAR2(150), 
	"ADD_ATT11" VARCHAR2(150), 
	"ADD_ATT12" VARCHAR2(150), 
	"ADD_ATT13" VARCHAR2(150), 
	"ADD_ATT14" VARCHAR2(150), 
	"ADD_ATT15" VARCHAR2(150), 
	"CREATION_DATE" DATE, 
	"CREATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_DATE" DATE, 
	"LAST_UPDATED_BY" VARCHAR2(64), 
	"LAST_UPDATE_LOGIN" VARCHAR2(32), 
	 CONSTRAINT "LACLS_CO_THIRD_PARTY_PK" PRIMARY KEY ("PARTY_ID")
  USING INDEX  ENABLE
   ) ;

GRANT DELETE ON "LACLS"."LACLS_CO_THIRD_PARTY" TO "SOPORTE_COE";
  GRANT INSERT ON "LACLS"."LACLS_CO_THIRD_PARTY" TO "SOPORTE_COE";
  GRANT SELECT ON "LACLS"."LACLS_CO_THIRD_PARTY" TO "SOPORTE_COE";
  GRANT UPDATE ON "LACLS"."LACLS_CO_THIRD_PARTY" TO "SOPORTE_COE";

CREATE UNIQUE INDEX "LACLS"."LACLS_CO_THIRD_PARTY_PK" ON "LACLS"."LACLS_CO_THIRD_PARTY" ("PARTY_ID") 
  ;

---

← Volver a tablas de LACLS

🏠 Volver al menú principal