DWADW.DIM_FULFILLLINESTATUS_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo de estados de cumplimiento de líneas de órdenes. Contiene códigos, nombres y traducciones de los estados y permite interpretar y analizar la situación de cada línea durante su proceso de cumplimiento. English: Catalog of order fulfillment line statuses. It contains status codes, names, and translations and supports interpretation and analysis of each line throughout the fulfillment process.

Columnas

#	Columna	Tipo	Nulo	Default
1	FULLFILLLINESTATUS_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378136”.nextval
2	FULFILLLINESTATUSCREATEDBY	VARCHAR2(64)	NO
3	FULFILLLINESTATUSCREATIONDATE	DATE	NO
4	FULFILLLINESTATUSLASTUPDATEDATE	DATE	NO
5	FULFILLLINESTATUSLASTUPDATEDBY	VARCHAR2(64)	NO
6	FULFILLLINESTATUSSTATUSCODE	VARCHAR2(30)	NO
7	LINESTATUSID	NUMBER(18,0)	NO
8	STATUSTRANSLATIONCREATEDBY	VARCHAR2(64)	NO
9	STATUSTRANSLATIONCREATIONDATE	DATE	NO
10	STATUSTRANSLATIONDISPLAYNAME	VARCHAR2(240)	NO
11	STATUSTRANSLATIONLANGUAGE	VARCHAR2(4)	NO
12	STATUSTRANSLATIONLASTUPDATEDBY	VARCHAR2(64)	NO
13	STATUSTRANSLATIONSOURCELANG	VARCHAR2(4)	NO
14	ROW_ACTIVE	CHAR(1)	NO	‘A’
15	AUDIT_ID	NUMBER	NO

Restricciones

CHECK: DIM_FULFILLLINESTATUS_OM_CK

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

CHECK: SYS_C00304770

Estado: ENABLED
Columnas: FULLFILLLINESTATUS_OM_ID
Condición: "FULLFILLLINESTATUS_OM_ID" IS NOT NULL

CHECK: SYS_C00304771

Estado: ENABLED
Columnas: FULFILLLINESTATUSCREATEDBY
Condición: "FULFILLLINESTATUSCREATEDBY" IS NOT NULL

CHECK: SYS_C00304772

Estado: ENABLED
Columnas: FULFILLLINESTATUSCREATIONDATE
Condición: "FULFILLLINESTATUSCREATIONDATE" IS NOT NULL

CHECK: SYS_C00304773

Estado: ENABLED
Columnas: FULFILLLINESTATUSLASTUPDATEDATE
Condición: "FULFILLLINESTATUSLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C00304774

Estado: ENABLED
Columnas: FULFILLLINESTATUSLASTUPDATEDBY
Condición: "FULFILLLINESTATUSLASTUPDATEDBY" IS NOT NULL

CHECK: SYS_C00304775

Estado: ENABLED
Columnas: FULFILLLINESTATUSSTATUSCODE
Condición: "FULFILLLINESTATUSSTATUSCODE" IS NOT NULL

CHECK: SYS_C00304776

Estado: ENABLED
Columnas: LINESTATUSID
Condición: "LINESTATUSID" IS NOT NULL

CHECK: SYS_C00304777

Estado: ENABLED
Columnas: STATUSTRANSLATIONCREATEDBY
Condición: "STATUSTRANSLATIONCREATEDBY" IS NOT NULL

CHECK: SYS_C00304778

Estado: ENABLED
Columnas: STATUSTRANSLATIONCREATIONDATE
Condición: "STATUSTRANSLATIONCREATIONDATE" IS NOT NULL

CHECK: SYS_C00304779

Estado: ENABLED
Columnas: STATUSTRANSLATIONDISPLAYNAME
Condición: "STATUSTRANSLATIONDISPLAYNAME" IS NOT NULL

CHECK: SYS_C00304780

Estado: ENABLED
Columnas: STATUSTRANSLATIONLANGUAGE
Condición: "STATUSTRANSLATIONLANGUAGE" IS NOT NULL

CHECK: SYS_C00304781

Estado: ENABLED
Columnas: STATUSTRANSLATIONLASTUPDATEDBY
Condición: "STATUSTRANSLATIONLASTUPDATEDBY" IS NOT NULL

CHECK: SYS_C00304782

Estado: ENABLED
Columnas: STATUSTRANSLATIONSOURCELANG
Condición: "STATUSTRANSLATIONSOURCELANG" IS NOT NULL

CHECK: SYS_C00304783

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

CHECK: SYS_C00304784

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

PK: ST_FULFILLLINESTATUS_OM_PK

Estado: ENABLED
Columnas: FULLFILLLINESTATUS_OM_ID

UK: DIM_FULFILLLINESTATUS_OM_UN

Estado: ENABLED
Columnas: LINESTATUSID, STATUSTRANSLATIONLANGUAGE

DDL

CREATE TABLE "DWADW"."DIM_FULFILLLINESTATUS_OM" 
   (	"FULLFILLLINESTATUS_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, 
	"FULFILLLINESTATUSCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"FULFILLLINESTATUSCREATIONDATE" DATE NOT NULL ENABLE, 
	"FULFILLLINESTATUSLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"FULFILLLINESTATUSLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"FULFILLLINESTATUSSTATUSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"LINESTATUSID" NUMBER(18,0) NOT NULL ENABLE, 
	"STATUSTRANSLATIONCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"STATUSTRANSLATIONCREATIONDATE" DATE NOT NULL ENABLE, 
	"STATUSTRANSLATIONDISPLAYNAME" VARCHAR2(240) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"STATUSTRANSLATIONLANGUAGE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"STATUSTRANSLATIONLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"STATUSTRANSLATIONSOURCELANG" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	 CONSTRAINT "DIM_FULFILLLINESTATUS_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "ST_FULFILLLINESTATUS_OM_PK" PRIMARY KEY ("FULLFILLLINESTATUS_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_FULFILLLINESTATUS_OM_UN" UNIQUE ("LINESTATUSID", "STATUSTRANSLATIONLANGUAGE")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_FULFILLLINESTATUS_OM"  IS 'Español: Catálogo de estados de cumplimiento de líneas de órdenes. Contiene códigos, nombres y traducciones de los estados y permite interpretar y analizar la situación de cada línea durante su proceso de cumplimiento.
English: Catalog of order fulfillment line statuses. It contains status codes, names, and translations and supports interpretation and analysis of each line throughout the fulfillment process.';

CREATE UNIQUE INDEX "DWADW"."ST_FULFILLLINESTATUS_OM_PK" ON "DWADW"."DIM_FULFILLLINESTATUS_OM" ("FULLFILLLINESTATUS_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_FULFILLLINESTATUS_OM_UN" ON "DWADW"."DIM_FULFILLLINESTATUS_OM" ("LINESTATUSID", "STATUSTRANSLATIONLANGUAGE") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal