Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
LACLS.LACLS_CO_REPORT_BALANCES
Base de datos origen: PDB1
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | REPORT_ID | NUMBER | SI | ||
| 2 | LEDGER_ID | NUMBER | SI | ||
| 3 | LEDGER_NAME | VARCHAR2(40) | SI | ||
| 4 | BSV_VALUE | VARCHAR2(40) | SI | ||
| 5 | PERIOD_FROM | VARCHAR2(15) | SI | ||
| 6 | PERIOD_TO | VARCHAR2(15) | SI | ||
| 7 | ACCOUNT_FROM | VARCHAR2(40) | SI | ||
| 8 | ACCOUNT_TO | VARCHAR2(40) | SI | ||
| 9 | DETAIL_NIT | VARCHAR2(1) | SI | ||
| 10 | DETAIL_MOV | VARCHAR2(1) | SI | ||
| 11 | DETAIL_ACC | VARCHAR2(1) | SI | ||
| 12 | FORMAT | VARCHAR2(10) | SI | ||
| 13 | STATUS | VARCHAR2(40) | SI | ||
| 14 | REPORT_DETAIL | CLOB | SI | ||
| 15 | NIT | VARCHAR2(20) | SI | ||
| 16 | COMPANY_ID | NUMBER | SI | ||
| 17 | FORMAT_ID | NUMBER | SI | ||
| 18 | INSTANCE_ID | VARCHAR2(200) | SI | ||
| 19 | REPORT_NAME | VARCHAR2(240) | SI | ||
| 20 | LAST_UPDATE_DATE | DATE | SI | ||
| 21 | LAST_UPDATED_BY | VARCHAR2(240) | SI | ||
| 22 | CREATION_DATE | DATE | SI | ||
| 23 | CREATED_BY | VARCHAR2(240) | SI | ||
| 24 | LAST_UPDATE_LOGIN | VARCHAR2(240) | SI |
Restricciones
Sin restricciones visibles (P/R/U/C).
DDL
CREATE TABLE "LACLS"."LACLS_CO_REPORT_BALANCES"
( "REPORT_ID" NUMBER,
"LEDGER_ID" NUMBER,
"LEDGER_NAME" VARCHAR2(40),
"BSV_VALUE" VARCHAR2(40),
"PERIOD_FROM" VARCHAR2(15),
"PERIOD_TO" VARCHAR2(15),
"ACCOUNT_FROM" VARCHAR2(40),
"ACCOUNT_TO" VARCHAR2(40),
"DETAIL_NIT" VARCHAR2(1),
"DETAIL_MOV" VARCHAR2(1),
"DETAIL_ACC" VARCHAR2(1),
"FORMAT" VARCHAR2(10),
"STATUS" VARCHAR2(40),
"REPORT_DETAIL" CLOB,
"NIT" VARCHAR2(20),
"COMPANY_ID" NUMBER,
"FORMAT_ID" NUMBER,
"INSTANCE_ID" VARCHAR2(200),
"REPORT_NAME" VARCHAR2(240),
"LAST_UPDATE_DATE" DATE,
"LAST_UPDATED_BY" VARCHAR2(240),
"CREATION_DATE" DATE,
"CREATED_BY" VARCHAR2(240),
"LAST_UPDATE_LOGIN" VARCHAR2(240)
) ;
GRANT DELETE ON "LACLS"."LACLS_CO_REPORT_BALANCES" TO "SOPORTE_COE";
GRANT INSERT ON "LACLS"."LACLS_CO_REPORT_BALANCES" TO "SOPORTE_COE";
GRANT SELECT ON "LACLS"."LACLS_CO_REPORT_BALANCES" TO "SOPORTE_COE";
GRANT UPDATE ON "LACLS"."LACLS_CO_REPORT_BALANCES" TO "SOPORTE_COE";
CREATE UNIQUE INDEX "LACLS"."SYS_IL0000083240C00014$$" ON "LACLS"."LACLS_CO_REPORT_BALANCES" (
;