Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
SIMACMOBILE.MLOG$_ORDENES_DE_COMPRA
Base de datos origen: ORCLSMM
Descripción: snapshot log for master table SIMACMOBILE.ORDENES_DE_COMPRA
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | ID_ORDC | NUMBER(10,0) | SI | ||
| 2 | DOCUMENTO_ORDEN_COMPRA | NUMBER(10,0) | SI | ||
| 3 | M_ROW$$ | VARCHAR2(255) | SI | ||
| 4 | SEQUENCE$$ | NUMBER | SI | ||
| 5 | DMLTYPE$$ | VARCHAR2(1) | SI | ||
| 6 | OLD_NEW$$ | VARCHAR2(1) | SI | ||
| 7 | CHANGE_VECTOR$$ | RAW | SI | ||
| 8 | XID$$ | NUMBER | SI |
Restricciones
Sin restricciones visibles (P/R/U/C).
DDL
CREATE TABLE "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA"
( "ID_ORDC" NUMBER(10,0),
"DOCUMENTO_ORDEN_COMPRA" NUMBER(10,0),
"M_ROW$$" VARCHAR2(255),
"SEQUENCE$$" NUMBER,
"DMLTYPE$$" VARCHAR2(1),
"OLD_NEW$$" VARCHAR2(1),
"CHANGE_VECTOR$$" RAW(255),
"XID$$" NUMBER
) ;
COMMENT ON TABLE "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" IS 'snapshot log for master table SIMACMOBILE.ORDENES_DE_COMPRA';
GRANT UPDATE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "USUARIO_SIMACMOBILE";
GRANT INSERT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "USUARIO_SIMACMOBILE";
GRANT DELETE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "USUARIO_SIMACMOBILE";
GRANT SELECT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "CONSULTA_SIMACMOBILE";
GRANT UPDATE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "WRITE_SIMAC_TABLES";
GRANT INSERT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "WRITE_SIMAC_TABLES";
GRANT SELECT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "READ_SIMAC_TABLES";
GRANT SELECT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "SELECT_SIMACMOBILE_ROLE";
GRANT UPDATE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "EXECUTE_SIMACMOBILE";
GRANT INSERT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "EXECUTE_SIMACMOBILE";
GRANT DELETE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "EXECUTE_SIMACMOBILE";
GRANT DELETE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "PERM_USUARIOAPP";
GRANT INSERT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "PERM_USUARIOAPP";
GRANT SELECT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "PERM_USUARIOAPP";
GRANT UPDATE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "PERM_USUARIOAPP";
GRANT UPDATE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "CRUD_SIMAC";
GRANT SELECT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "CRUD_SIMAC";
GRANT INSERT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "CRUD_SIMAC";
GRANT DELETE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "CRUD_SIMAC";
GRANT UPDATE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "RAPLICACIONES";
GRANT SELECT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "RAPLICACIONES";
GRANT INSERT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "RAPLICACIONES";
GRANT DELETE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "RAPLICACIONES";
GRANT UPDATE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "APLICACIONES";
GRANT SELECT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "APLICACIONES";
GRANT INSERT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "APLICACIONES";
GRANT DELETE ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "APLICACIONES";
GRANT SELECT ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" TO "CONSULTA";
CREATE INDEX "SIMACMOBILE"."I_MLOG$_ORDENES_DE_COMPRA" ON "SIMACMOBILE"."MLOG$_ORDENES_DE_COMPRA" ("XID$$")
;