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 | LINE_ID | NUMBER | NO | ||
| 2 | HEADER_ID | NUMBER | NO | ||
| 3 | FORMAT_ID | NUMBER | NO | ||
| 4 | CONCEPT_ID | NUMBER | NO | ||
| 5 | LEDGER_ID | NUMBER | SI | ||
| 6 | PERIOD_NAME | VARCHAR2(15) | NO | ||
| 7 | PARTY_ID | NUMBER | NO | ||
| 8 | CODE_COMBINATION_ID | NUMBER | SI | ||
| 9 | ORIGIN | VARCHAR2(10) | SI | ||
| 10 | SOURCE_ID | NUMBER | SI | ||
| 11 | CODE_COMBINATION_ID_RELATED | NUMBER | SI | ||
| 12 | ATTRIBUTE_CATEGORY | VARCHAR2(150) | SI | ||
| 13 | REPORTED_FLAG | VARCHAR2(1) | SI | ‘Y’ | |
| 14 | LINE_TYPE_LOOKUP_CODE | VARCHAR2(50) | SI | ||
| 15 | TAX_TYPE | VARCHAR2(50) | SI | ||
| 16 | TAX_NAME | VARCHAR2(50) | SI | ||
| 17 | ACCOUNT_NUMBER_RELATED | VARCHAR2(40) | SI | ||
| 18 | CATEGORY | VARCHAR2(40) | SI | ||
| 19 | ACCOUNT_NUMBER | VARCHAR2(40) | SI | ||
| 20 | THIRD_PARTY_REPORT | VARCHAR2(30) | SI | ||
| 21 | REPORTED_VALUE_1 | NUMBER | NO | ||
| 22 | REPORTED_VALUE_2 | NUMBER | SI | ||
| 23 | REPORTED_VALUE_3 | NUMBER | SI | ||
| 24 | REPORTED_VALUE_4 | NUMBER | SI | ||
| 25 | REPORTED_VALUE_5 | NUMBER | SI | ||
| 26 | REPORTED_VALUE_6 | NUMBER | SI | ||
| 27 | REPORTED_VALUE_7 | NUMBER | SI | ||
| 28 | REPORTED_VALUE_8 | NUMBER | SI | ||
| 29 | REPORTED_VALUE_9 | NUMBER | SI | ||
| 30 | REPORTED_VALUE_10 | NUMBER | SI | ||
| 31 | REPORTED_VALUE_11 | NUMBER | SI | ||
| 32 | REPORTED_VALUE_12 | NUMBER | SI | ||
| 33 | REPORTED_VALUE_13 | NUMBER | SI | ||
| 34 | REPORTED_VALUE_14 | NUMBER | SI | ||
| 35 | REPORTED_VALUE_15 | NUMBER | SI | ||
| 36 | REPORTED_VALUE_16 | NUMBER | SI | ||
| 37 | REPORTED_VALUE_17 | NUMBER | SI | ||
| 38 | REPORTED_VALUE_18 | NUMBER | SI | ||
| 39 | REPORTED_VALUE_19 | NUMBER | SI | ||
| 40 | REPORTED_VALUE_20 | NUMBER | SI | ||
| 41 | CREATION_DATE | DATE | SI | ||
| 42 | CREATED_BY | VARCHAR2(64) | SI | ||
| 43 | LAST_UPDATE_DATE | DATE | SI | ||
| 44 | LAST_UPDATED_BY | VARCHAR2(64) | SI | ||
| 45 | LAST_UPDATE_LOGIN | VARCHAR2(32) | SI |
"LINE_ID" IS NOT NULL"HEADER_ID" IS NOT NULL"FORMAT_ID" IS NOT NULL"CONCEPT_ID" IS NOT NULL"PERIOD_NAME" IS NOT NULL"PARTY_ID" IS NOT NULL"REPORTED_VALUE_1" IS NOT NULL-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name