Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DIM_ORGANIZATIONS_ERP
Base de datos origen: ADW COEXITO
Descripción: Español: Catálogo de organizaciones, bodegas y centros operativos utilizados en procesos logísticos y de inventario. English: Catalog of organizations, warehouses, and operational centers used in logistics and inventory processes.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | ORGANIZATIONS_ERP_ID | NUMBER | NO | “DWADW”.”ISEQ$$_306878”.nextval | |
| 2 | LOCATIONID | NUMBER | NO | ||
| 3 | ORGANIZATIONID | NUMBER | NO | ||
| 4 | ORGANIZATION_NAME | VARCHAR2(255) | SI | ||
| 5 | AUDIT_ID | NUMBER(18,0) | NO | ||
| 6 | ROW_ACTIVE | CHAR(1) | NO | ‘A’ |
Restricciones
CHECK: DIM_ORGANIZATIONS_ERP_AI_CK
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
row_active IN ('A','I')
CHECK: SYS_C00202832
- Estado: ENABLED
- Columnas: ORGANIZATIONS_ERP_ID
- Condición:
"ORGANIZATIONS_ERP_ID" IS NOT NULL
CHECK: SYS_C00202833
- Estado: ENABLED
- Columnas: LOCATIONID
- Condición:
"LOCATIONID" IS NOT NULL
CHECK: SYS_C00202834
- Estado: ENABLED
- Columnas: ORGANIZATIONID
- Condición:
"ORGANIZATIONID" IS NOT NULL
CHECK: SYS_C00202835
- Estado: ENABLED
- Columnas: AUDIT_ID
- Condición:
"AUDIT_ID" IS NOT NULL
CHECK: SYS_C00202836
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
"ROW_ACTIVE" IS NOT NULL
PK: DIM_ORGANIZATIONS_ERP_PK
- Estado: ENABLED
- Columnas: ORGANIZATIONS_ERP_ID
UK: DIM_ORGANIZATIONS_ERP_ORGANIZATIONID_UN
- Estado: ENABLED
- Columnas: ORGANIZATIONID
DDL
CREATE TABLE "DWADW"."DIM_ORGANIZATIONS_ERP"
( "ORGANIZATIONS_ERP_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
"LOCATIONID" NUMBER(*,0) NOT NULL ENABLE,
"ORGANIZATIONID" NUMBER(*,0) NOT NULL ENABLE,
"ORGANIZATION_NAME" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"AUDIT_ID" NUMBER(18,0) NOT NULL ENABLE,
"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE,
CONSTRAINT "DIM_ORGANIZATIONS_ERP_AI_CK" CHECK (row_active IN ('A','I')) ENABLE,
CONSTRAINT "DIM_ORGANIZATIONS_ERP_PK" PRIMARY KEY ("ORGANIZATIONS_ERP_ID")
USING INDEX ENABLE,
CONSTRAINT "DIM_ORGANIZATIONS_ERP_ORGANIZATIONID_UN" UNIQUE ("ORGANIZATIONID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "DWADW"."DIM_ORGANIZATIONS_ERP" IS 'Español: Catálogo de organizaciones, bodegas y centros operativos utilizados en procesos logísticos y de inventario.
English: Catalog of organizations, warehouses, and operational centers used in logistics and inventory processes.';
CREATE INDEX "DWADW"."DIM_ORGANIZATIONS_ERP__IDX" ON "DWADW"."DIM_ORGANIZATIONS_ERP" ("ORGANIZATION_NAME")
;
CREATE UNIQUE INDEX "DWADW"."DIM_ORGANIZATIONS_ERP_PK" ON "DWADW"."DIM_ORGANIZATIONS_ERP" ("ORGANIZATIONS_ERP_ID")
;
CREATE UNIQUE INDEX "DWADW"."DIM_ORGANIZATIONS_ERP_ORGANIZATIONID_UN" ON "DWADW"."DIM_ORGANIZATIONS_ERP" ("ORGANIZATIONID")
;