🏠 Menú principal

← Volver a tablas

---

DWADW.DIM_HEADER_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo de cabeceras de órdenes. Contiene información general de la orden, como número, tipo, cliente, fechas, estado y datos de actualización, y permite identificar y analizar las características principales de cada orden. English: Order header catalog. It contains general order information such as order number, type, customer, dates, status, and update data, and supports identification and analysis of the main characteristics of each order.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	HEADER_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378140”.nextval
2	CANCELEDFLAG	VARCHAR2(1)	SI
3	CHANGEVERSIONNUMBER	NUMBER(18,0)	SI
4	CREATEDBY	VARCHAR2(64)	NO
5	CREATIONDATE	DATE	NO
6	CUSTOMERPONUMBER	VARCHAR2(50)	SI
7	HEADERCANCELREASONCODE	VARCHAR2(30)	SI
8	HEADERID	NUMBER(18,0)	NO
9	HEADERORDEREDDATETIMESTAMP	DATE	SI
10	HEADERREQUESTSHIPDATE	DATE	SI
11	HEADERSUBMITTEDBY	VARCHAR2(64)	SI
12	HEADERSUBMITTEDDATE	DATE	SI
13	LASTUPDATEDATE	DATE	NO
14	LASTUPDATEDBY	VARCHAR2(64)	NO
15	ONHOLD	VARCHAR2(1)	SI
16	OPENFLAG	VARCHAR2(1)	SI
17	ORDERNUMBER	VARCHAR2(50)	NO
18	ORDERTYPECODE	VARCHAR2(30)	SI
19	ORDEREDDATE	DATE	SI
20	SOLDTOPARTYID	NUMBER(18,0)	SI
21	SOURCEDOCUMENTTYPECODE	VARCHAR2(50)	SI
22	SOURCEORDERNUMBER	VARCHAR2(50)	SI
23	SOURCEORDERSYSTEM	VARCHAR2(50)	SI
24	SUBMITTEDFLAG	VARCHAR2(1)	SI
25	AUDIT_ID	NUMBER	NO
26	ROW_ACTIVE	CHAR(1)	NO	‘A’

Restricciones

CHECK: DIM_HEADER_OM_CK

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

CHECK: SYS_C00304788

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

CHECK: SYS_C00304789

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

CHECK: SYS_C00304790

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

CHECK: SYS_C00304791

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

CHECK: SYS_C00304792

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

CHECK: SYS_C00304793

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

CHECK: SYS_C00304794

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

CHECK: SYS_C00304795

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

CHECK: SYS_C00304796

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

PK: DIM_HEADER_OM_PK

• Estado: ENABLED
• Columnas: HEADER_OM_ID

UK: DIM_HEADER_OM__UN

• Estado: ENABLED
• Columnas: HEADERID

DDL

CREATE TABLE "DWADW"."DIM_HEADER_OM" 
   (	"HEADER_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, 
	"CANCELEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"CHANGEVERSIONNUMBER" NUMBER(18,0), 
	"CREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CREATIONDATE" DATE NOT NULL ENABLE, 
	"CUSTOMERPONUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"HEADERCANCELREASONCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"HEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"HEADERORDEREDDATETIMESTAMP" DATE, 
	"HEADERREQUESTSHIPDATE" DATE, 
	"HEADERSUBMITTEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"HEADERSUBMITTEDDATE" DATE, 
	"LASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ONHOLD" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"OPENFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ORDERNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ORDERTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"ORDEREDDATE" DATE, 
	"SOLDTOPARTYID" NUMBER(18,0), 
	"SOURCEDOCUMENTTYPECODE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SOURCEORDERNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SOURCEORDERSYSTEM" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"SUBMITTEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	 CONSTRAINT "DIM_HEADER_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "DIM_HEADER_OM_PK" PRIMARY KEY ("HEADER_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_HEADER_OM__UN" UNIQUE ("HEADERID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_HEADER_OM"  IS 'Español: Catálogo de cabeceras de órdenes. Contiene información general de la orden, como número, tipo, cliente, fechas, estado y datos de actualización, y permite identificar y analizar las características principales de cada orden.
English: Order header catalog. It contains general order information such as order number, type, customer, dates, status, and update data, and supports identification and analysis of the main characteristics of each order.';

CREATE UNIQUE INDEX "DWADW"."DIM_HEADER_OM_PK" ON "DWADW"."DIM_HEADER_OM" ("HEADER_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_HEADER_OM__UN" ON "DWADW"."DIM_HEADER_OM" ("HEADERID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal