Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
Base de datos origen: PDB1
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | BAL_LINE_ID | NUMBER | SI | ||
| 2 | HEADER_ID | NUMBER | SI | ||
| 3 | REPORTED_YEAR | NUMBER | SI | ||
| 4 | COMPANY_ID | NUMBER | SI | ||
| 5 | COMPANY_CODE | VARCHAR2(10) | SI | ||
| 6 | CREATED_BY | NUMBER | NO | ||
| 7 | CREATION_DATE | DATE | NO | ||
| 8 | LAST_UPDATED_BY | NUMBER | NO | ||
| 9 | LAST_UPDATE_DATE | DATE | NO | ||
| 10 | LAST_UPDATE_LOGIN | NUMBER | SI | ||
| 11 | FORMAT_CODE | VARCHAR2(30) | SI | ||
| 12 | CONCEPT_ID | NUMBER | SI | ||
| 13 | DOCUMENT_TYPE | VARCHAR2(30) | SI | ||
| 14 | NIT_CODE | VARCHAR2(30) | SI | ||
| 15 | NIT_VD | VARCHAR2(5) | SI | ||
| 16 | LAST_NAME1 | VARCHAR2(100) | SI | ||
| 17 | LAST_NAME2 | VARCHAR2(100) | SI | ||
| 18 | FIRST_NAME | VARCHAR2(100) | SI | ||
| 19 | SECOND_NAME | VARCHAR2(100) | SI | ||
| 20 | PARTY_NAME | VARCHAR2(200) | SI | ||
| 21 | ADDRESS | VARCHAR2(200) | SI | ||
| 22 | DEPT_CODE | VARCHAR2(10) | SI | ||
| 23 | CITY_CODE | VARCHAR2(10) | SI | ||
| 24 | COUNTRY_CODE | VARCHAR2(10) | SI | ||
| 25 | FIRST_VALUE | NUMBER | SI | ||
| 26 | SECOND_VALUE | NUMBER | SI | ||
| 27 | THIRD_VALUE | NUMBER | SI | ||
| 28 | ORIGIN_SYSTEM | VARCHAR2(10) | SI | ||
| 29 | FIRST_VALUE_OLD | NUMBER | SI | ||
| 30 | SECOND_VALUE_OLD | NUMBER | SI | ||
| 31 | THIRD_VALUE_OLD | NUMBER | SI | ||
| 32 | REPORTED_VALUE_1 | NUMBER | SI | ||
| 33 | REPORTED_VALUE_2 | NUMBER | SI | ||
| 34 | REPORTED_VALUE_3 | NUMBER | SI | ||
| 35 | REPORTED_VALUE_4 | NUMBER | SI | ||
| 36 | REPORTED_VALUE_5 | NUMBER | SI | ||
| 37 | REPORTED_VALUE_6 | NUMBER | SI | ||
| 38 | REPORTED_VALUE_7 | NUMBER | SI | ||
| 39 | REPORTED_VALUE_8 | NUMBER | SI | ||
| 40 | REPORTED_VALUE_9 | NUMBER | SI | ||
| 41 | FORMAT_ID | NUMBER | SI |
"CREATED_BY" IS NOT NULL"CREATION_DATE" IS NOT NULL"LAST_UPDATED_BY" IS NOT NULL"LAST_UPDATE_DATE" IS NOT NULL-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name