🏠 Menú principal

← Volver a tablas

---

DWADW.DW_ITEMS

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	INVENTORYITEMID	NUMBER	NO
2	ORGANIZATIONID	NUMBER	NO
3	LANGUAGE	VARCHAR2(10)	NO
4	CREATION_DATE	DATE	NO
5	ENABLED_FLAG	VARCHAR2(255)	NO
6	ITEM_NUMBER	VARCHAR2(255)	NO
7	PRIMARY_UOM_CODE	VARCHAR2(10)	SI
8	UNIT_OF_ISSUE	FLOAT	SI
9	UNIT_OF_VOLUME	FLOAT	NO
10	UNIT_OF_WEIGHT	FLOAT	NO
11	VOLUME_UOM_CODE	VARCHAR2(255)	SI
12	WEIGHT_UOMC_ODE	VARCHAR2(255)	SI
13	TRANSLATION_CREATION_DATE	DATE	NO
14	TRANLATION_DESCRIPTION	VARCHAR2(2000)	NO

Restricciones

CHECK: SYS_C0024705

• Estado: ENABLED
• Columnas: INVENTORYITEMID
• Condición: "INVENTORYITEMID" IS NOT NULL

CHECK: SYS_C0024706

• Estado: ENABLED
• Columnas: ORGANIZATIONID
• Condición: "ORGANIZATIONID" IS NOT NULL

CHECK: SYS_C0024707

• Estado: ENABLED
• Columnas: LANGUAGE
• Condición: "LANGUAGE" IS NOT NULL

CHECK: SYS_C0024708

• Estado: ENABLED
• Columnas: CREATION_DATE
• Condición: "CREATION_DATE" IS NOT NULL

CHECK: SYS_C0024709

• Estado: ENABLED
• Columnas: ENABLED_FLAG
• Condición: "ENABLED_FLAG" IS NOT NULL

CHECK: SYS_C0024710

• Estado: ENABLED
• Columnas: ITEM_NUMBER
• Condición: "ITEM_NUMBER" IS NOT NULL

CHECK: SYS_C0024711

• Estado: ENABLED
• Columnas: UNIT_OF_VOLUME
• Condición: "UNIT_OF_VOLUME" IS NOT NULL

CHECK: SYS_C0024712

• Estado: ENABLED
• Columnas: UNIT_OF_WEIGHT
• Condición: "UNIT_OF_WEIGHT" IS NOT NULL

CHECK: SYS_C0024713

• Estado: ENABLED
• Columnas: TRANSLATION_CREATION_DATE
• Condición: "TRANSLATION_CREATION_DATE" IS NOT NULL

CHECK: SYS_C0024714

• Estado: ENABLED
• Columnas: TRANLATION_DESCRIPTION
• Condición: "TRANLATION_DESCRIPTION" IS NOT NULL

PK: SYS_C0024715

• Estado: ENABLED
• Columnas: INVENTORYITEMID, ORGANIZATIONID, LANGUAGE

DDL

CREATE TABLE "DWADW"."DW_ITEMS" 
   (	"INVENTORYITEMID" NUMBER(*,0) NOT NULL ENABLE, 
	"ORGANIZATIONID" NUMBER(*,0) NOT NULL ENABLE, 
	"LANGUAGE" VARCHAR2(10) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CREATION_DATE" DATE NOT NULL ENABLE, 
	"ENABLED_FLAG" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ITEM_NUMBER" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PRIMARY_UOM_CODE" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"UNIT_OF_ISSUE" FLOAT(126), 
	"UNIT_OF_VOLUME" FLOAT(126) NOT NULL ENABLE, 
	"UNIT_OF_WEIGHT" FLOAT(126) NOT NULL ENABLE, 
	"VOLUME_UOM_CODE" VARCHAR2(255) COLLATE "USING_NLS_COMP", 
	"WEIGHT_UOMC_ODE" VARCHAR2(255) COLLATE "USING_NLS_COMP", 
	"TRANSLATION_CREATION_DATE" DATE NOT NULL ENABLE, 
	"TRANLATION_DESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	 PRIMARY KEY ("INVENTORYITEMID", "ORGANIZATIONID", "LANGUAGE")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT INDEX ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT REFERENCES ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT ON COMMIT REFRESH ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT QUERY REWRITE ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT FLASHBACK ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT DELETE ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT INSERT ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT UPDATE ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT ALTER ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT SELECT ON "DWADW"."DW_ITEMS" TO "POWER_BI";
  GRANT DELETE ON "DWADW"."DW_ITEMS" TO "MANAGE_DW_ST";
  GRANT INSERT ON "DWADW"."DW_ITEMS" TO "MANAGE_DW_ST";
  GRANT SELECT ON "DWADW"."DW_ITEMS" TO "MANAGE_DW_ST";
  GRANT UPDATE ON "DWADW"."DW_ITEMS" TO "MANAGE_DW_ST";
  GRANT ALTER ON "DWADW"."DW_ITEMS" TO "MANAGE_DW_ST";
  GRANT READ ON "DWADW"."DW_ITEMS" TO "MANAGE_DW_ST";
  GRANT DEBUG ON "DWADW"."DW_ITEMS" TO "MANAGE_DW_ST";
  GRANT READ ON "DWADW"."DW_ITEMS" TO "BICC";
  GRANT DEBUG ON "DWADW"."DW_ITEMS" TO "BICC";

CREATE UNIQUE INDEX "DWADW"."SYS_C0024715" ON "DWADW"."DW_ITEMS" ("INVENTORYITEMID", "ORGANIZATIONID", "LANGUAGE") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal