🏠 Menú principal

← Volver a tablas

---

DWADW.DIM_INVORGPARAMETERS_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo de organizaciones de inventario. Contiene códigos de organización, unidades de negocio, entidades legales y organizaciones relacionadas, y permite identificar la organización responsable del inventario y de las operaciones asociadas. English: Inventory organization catalog. It contains organization codes, business units, legal entities, and related organizations and supports identification of the organization responsible for inventory and associated operations.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	INVORGPARAMETERS_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378144”.nextval
2	ORGANIZATIONID	NUMBER(18,0)	NO
3	ORGANIZATIONCODE	VARCHAR2(18)	SI
4	BUSINESSUNITID	NUMBER(18,0)	SI
5	PROFITCENTERBUID	NUMBER(18,0)	SI
6	LEGALENTITYID	NUMBER(18,0)	SI
7	MASTERORGANIZATIONID	NUMBER(18,0)	SI
8	ITEMDEFINITIONORGID	NUMBER(18,0)	SI
9	SOURCEORGANIZATIONID	NUMBER(18,0)	SI
10	PARTYID	NUMBER(18,0)	SI
11	INVENTORYFLAG	VARCHAR2(1)	SI
12	MFGPLANTFLAG	VARCHAR2(1)	SI
13	CREATIONDATE	TIMESTAMP(6)	SI
14	LASTUPDATEDATE	TIMESTAMP(6)	SI
15	LASTUPDATEDBY	VARCHAR2(64)	SI
16	OBJECTVERSIONNUMBER	NUMBER(9,0)	SI
17	AUDIT_ID	NUMBER	NO
18	ROW_ACTIVE	CHAR(1)	NO	‘A’

Restricciones

CHECK: DIM_INVORGPARAMETERS_OM_CK

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

CHECK: SYS_C00304800

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

CHECK: SYS_C00304801

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

CHECK: SYS_C00304802

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

CHECK: SYS_C00304803

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

PK: DIM_INVORGPARAMETERS_OM_PK

• Estado: ENABLED
• Columnas: INVORGPARAMETERS_OM_ID

UK: DIM_INVORGPARAMETERS_OM__UN

• Estado: ENABLED
• Columnas: ORGANIZATIONID

DDL

CREATE TABLE "DWADW"."DIM_INVORGPARAMETERS_OM" 
   (	"INVORGPARAMETERS_OM_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, 
	"ORGANIZATIONID" NUMBER(18,0) NOT NULL ENABLE, 
	"ORGANIZATIONCODE" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"BUSINESSUNITID" NUMBER(18,0), 
	"PROFITCENTERBUID" NUMBER(18,0), 
	"LEGALENTITYID" NUMBER(18,0), 
	"MASTERORGANIZATIONID" NUMBER(18,0), 
	"ITEMDEFINITIONORGID" NUMBER(18,0), 
	"SOURCEORGANIZATIONID" NUMBER(18,0), 
	"PARTYID" NUMBER(18,0), 
	"INVENTORYFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"MFGPLANTFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"CREATIONDATE" TIMESTAMP (6), 
	"LASTUPDATEDATE" TIMESTAMP (6), 
	"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"OBJECTVERSIONNUMBER" NUMBER(9,0), 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	 CONSTRAINT "DIM_INVORGPARAMETERS_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_INVORGPARAMETERS_OM_PK" PRIMARY KEY ("INVORGPARAMETERS_OM_ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;
  CREATE INDEX "DWADW"."DIM_INVORGPARAMETERS_ID_IDX" ON "DWADW"."DIM_INVORGPARAMETERS_OM" ("ORGANIZATIONID") 
  ;
ALTER TABLE "DWADW"."DIM_INVORGPARAMETERS_OM" ADD CONSTRAINT "DIM_INVORGPARAMETERS_OM__UN" UNIQUE ("ORGANIZATIONID")
  USING INDEX "DWADW"."DIM_INVORGPARAMETERS_ID_IDX"  ENABLE;

COMMENT ON TABLE "DWADW"."DIM_INVORGPARAMETERS_OM"  IS 'Español: Catálogo de organizaciones de inventario. Contiene códigos de organización, unidades de negocio, entidades legales y organizaciones relacionadas, y permite identificar la organización responsable del inventario y de las operaciones asociadas.
English: Inventory organization catalog. It contains organization codes, business units, legal entities, and related organizations and supports identification of the organization responsible for inventory and associated operations.';

CREATE INDEX "DWADW"."DIM_INVORGPARAMETERS_ID_IDX" ON "DWADW"."DIM_INVORGPARAMETERS_OM" ("ORGANIZATIONID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_INVORGPARAMETERS_OM_PK" ON "DWADW"."DIM_INVORGPARAMETERS_OM" ("INVORGPARAMETERS_OM_ID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal