🏠 Menú principal

← Volver a tablas

---

DWADW.DIM_ITEMS_PIM

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo maestro de productos e ítems utilizado para inventario, ventas, compras y control operativo. English: Master product and item catalog used for inventory, sales, purchasing, and operational control.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	ITEMS_PIM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_306864”.nextval
2	INVENTORYITEMID	NUMBER	NO
3	ORGANIZATIONID	NUMBER	SI
4	LANGUAGE	VARCHAR2(10)	NO
5	CREATION_DATE	DATE	NO
6	ENABLED_FLAG	VARCHAR2(255)	NO
7	ITEM_NUMBER	VARCHAR2(255)	NO
8	PRIMARY_UOM_CODE	VARCHAR2(10)	SI
9	UNIT_OF_ISSUE	FLOAT	SI
10	UNIT_OF_VOLUME	FLOAT	NO
11	UNIT_OF_WEIGHT	FLOAT	NO
12	VOLUME_UOM_CODE	VARCHAR2(255)	SI
13	WEIGHT_UOM_CODE	VARCHAR2(255)	SI
14	TRANSLATION_CREATION_DATE	DATE	NO
15	TRANSLATION_DESCRIPTION	VARCHAR2(2000)	SI
16	AUDIT_ID	NUMBER(18,0)	NO
17	ROW_ACTIVE	CHAR(1)	NO	‘A’
18	DIM_ORGANIZATIONS_ERP_ID	NUMBER	SI

Restricciones

CHECK: DIM_ITEMS_PIM_AI_CK

• Estado: ENABLED
• Columnas: ROW_ACTIVE
• Condición: row_active IN ('A','I')

CHECK: SYS_C00202802

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

CHECK: SYS_C00202803

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

CHECK: SYS_C00202805

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

CHECK: SYS_C00202806

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

CHECK: SYS_C00202807

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

CHECK: SYS_C00202808

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

CHECK: SYS_C00202809

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

CHECK: SYS_C00202810

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

CHECK: SYS_C00202811

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

CHECK: SYS_C00202813

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

CHECK: SYS_C00202814

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

PK: DIM_ITEMS_PIM_PK

• Estado: ENABLED
• Columnas: ITEMS_PIM_ID

FK: DIM_ITEMS_PIM_DIM_ORGANIZATIONS_ERP_FK

• Estado: ENABLED
• Columnas: DIM_ORGANIZATIONS_ERP_ID
• Referencia: DWADW.DIM_ORGANIZATIONS_ERP (constraint DIM_ORGANIZATIONS_ERP_PK)

UK: DIM_ITEMS_PIM_INVENTORY_ORG_LENGUAGE_UN

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

DDL

CREATE TABLE "DWADW"."DIM_ITEMS_PIM" 
   (	"ITEMS_PIM_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, 
	"INVENTORYITEMID" NUMBER(*,0) NOT NULL ENABLE, 
	"ORGANIZATIONID" NUMBER(*,0), 
	"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_UOM_CODE" VARCHAR2(255) COLLATE "USING_NLS_COMP", 
	"TRANSLATION_CREATION_DATE" DATE NOT NULL ENABLE, 
	"TRANSLATION_DESCRIPTION" VARCHAR2(2000) 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, 
	"DIM_ORGANIZATIONS_ERP_ID" NUMBER, 
	 CONSTRAINT "DIM_ITEMS_PIM_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_ITEMS_PIM_PK" PRIMARY KEY ("ITEMS_PIM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_ITEMS_PIM_INVENTORY_ORG_LENGUAGE_UN" UNIQUE ("INVENTORYITEMID", "ORGANIZATIONID", "LANGUAGE")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_ITEMS_PIM_DIM_ORGANIZATIONS_ERP_FK" FOREIGN KEY ("DIM_ORGANIZATIONS_ERP_ID")
	  REFERENCES "DWADW"."DIM_ORGANIZATIONS_ERP" ("ORGANIZATIONS_ERP_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_ITEMS_PIM"  IS 'Español: Catálogo maestro de productos e ítems utilizado para inventario, ventas, compras y control operativo.
English: Master product and item catalog used for inventory, sales, purchasing, and operational control.';

CREATE INDEX "DWADW"."DIM_ITEMS_PIM_DESCRIPTION_IDX" ON "DWADW"."DIM_ITEMS_PIM" ("TRANSLATION_DESCRIPTION") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_ITEMS_PIM_PK" ON "DWADW"."DIM_ITEMS_PIM" ("ITEMS_PIM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_ITEMS_PIM_INVENTORY_ORG_LENGUAGE_UN" ON "DWADW"."DIM_ITEMS_PIM" ("INVENTORYITEMID", "ORGANIZATIONID", "LANGUAGE") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal