🏠 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

-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name

---

← Volver a tablas de LACLS

🏠 Volver al menú principal