🏠 Menú principal

← Volver a tablas

---

STADW.ST_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	CREATIONDATE	DATE	NO
5	ENABLEDFLAG	VARCHAR2(255)	NO
6	ITEMNUMBER	VARCHAR2(255)	NO
7	PRIMARYUOMCODE	VARCHAR2(10)	SI
8	UNITOFISSUE	FLOAT	SI
9	UNITVOLUME	FLOAT	NO
10	UNITWEIGHT	FLOAT	NO
11	VOLUMEUOMCODE	VARCHAR2(255)	SI
12	WEIGHTUOMCODE	VARCHAR2(255)	SI
13	TRANSLATIONCREATIONDATE	DATE	NO
14	TRANLATIONDESCRIPTION	VARCHAR2(2000)	NO

Restricciones

CHECK: SYS_C0024671

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

CHECK: SYS_C0024672

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

CHECK: SYS_C0024673

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

CHECK: SYS_C0024674

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

CHECK: SYS_C0024675

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

CHECK: SYS_C0024676

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

CHECK: SYS_C0024677

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

CHECK: SYS_C0024678

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

CHECK: SYS_C0024679

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

CHECK: SYS_C0024680

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

PK: SYS_C0024681

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

DDL

CREATE TABLE "STADW"."ST_ITEMS" 
   (	"INVENTORYITEMID" NUMBER(*,0) NOT NULL ENABLE, 
	"ORGANIZATIONID" NUMBER(*,0) NOT NULL ENABLE, 
	"LANGUAGE" VARCHAR2(10) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CREATIONDATE" DATE NOT NULL ENABLE, 
	"ENABLEDFLAG" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ITEMNUMBER" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PRIMARYUOMCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP", 
	"UNITOFISSUE" FLOAT(126), 
	"UNITVOLUME" FLOAT(126) NOT NULL ENABLE, 
	"UNITWEIGHT" FLOAT(126) NOT NULL ENABLE, 
	"VOLUMEUOMCODE" VARCHAR2(255) COLLATE "USING_NLS_COMP", 
	"WEIGHTUOMCODE" VARCHAR2(255) COLLATE "USING_NLS_COMP", 
	"TRANSLATIONCREATIONDATE" DATE NOT NULL ENABLE, 
	"TRANLATIONDESCRIPTION" 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 "STADW"."ST_ITEMS" TO "BICC";
  GRANT REFERENCES ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT ON COMMIT REFRESH ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT QUERY REWRITE ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT FLASHBACK ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT DELETE ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT INSERT ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT SELECT ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT UPDATE ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT ALTER ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT DELETE ON "STADW"."ST_ITEMS" TO "MANAGE_DW_ST";
  GRANT INSERT ON "STADW"."ST_ITEMS" TO "MANAGE_DW_ST";
  GRANT SELECT ON "STADW"."ST_ITEMS" TO "MANAGE_DW_ST";
  GRANT UPDATE ON "STADW"."ST_ITEMS" TO "MANAGE_DW_ST";
  GRANT ALTER ON "STADW"."ST_ITEMS" TO "MANAGE_DW_ST";
  GRANT READ ON "STADW"."ST_ITEMS" TO "MANAGE_DW_ST";
  GRANT DEBUG ON "STADW"."ST_ITEMS" TO "MANAGE_DW_ST";
  GRANT READ ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT DEBUG ON "STADW"."ST_ITEMS" TO "BICC";
  GRANT ASSERTION REFERENCES ON "STADW"."ST_ITEMS" TO "BICC";

CREATE UNIQUE INDEX "STADW"."SYS_C0024681" ON "STADW"."ST_ITEMS" ("INVENTORYITEMID", "ORGANIZATIONID", "LANGUAGE") 
  ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal