🏠 Menú principal

← Volver a tablas

---

DWADW.DIM_LOCATION_OTM

Base de datos origen: ADW COEXITO

Descripción: Español: Catálogo maestro de ubicaciones OTM con atributos geográficos y operativos. | English: Master catalog of OTM locations with geographic and operational attributes.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	LOCATION_OTM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_220807”.nextval
2	LOCATION_GID	VARCHAR2(404)	NO
3	LOCATION_XID	VARCHAR2(200)	SI
4	LOCATION_NAME	VARCHAR2(1440)	SI
5	CITY	VARCHAR2(960)	SI
6	PROVINCE	VARCHAR2(960)	SI
7	PROVINCE_CODE	VARCHAR2(24)	SI
8	COUNTRY_CODE3_GID	VARCHAR2(404)	SI
9	TIME_ZONE_GID	VARCHAR2(404)	SI
10	IS_TEMPORARY	CHAR(4)	NO
11	IS_MAKE_APPT_BEFORE_PLAN	CHAR(4)	NO
12	IS_SHIPPER_KNOWN	CHAR(4)	NO
13	IS_ADDRESS_VALID	VARCHAR2(4)	NO
14	IS_LTL_SPLITABLE	VARCHAR2(4)	NO
15	USE_APPOINTMENT_PRIORITY	VARCHAR2(4)	SI
16	SCHEDULE_LOW_PRIORITY_APPOINT	VARCHAR2(4)	SI
17	ENFORCE_TIME_WINDOW_APPOINT	VARCHAR2(4)	SI
18	SCHEDULE_INFEASIBLE_APPOINT	VARCHAR2(4)	SI
19	BB_IS_NEW_STORE	VARCHAR2(4)	NO
20	EXCLUDE_FROM_ROUTE_EXECUTION	VARCHAR2(4)	NO
21	IS_TEMPLATE	VARCHAR2(4)	NO
22	ALLOW_DRIVER_REST	VARCHAR2(4)	SI
23	APPT_OBJECT_TYPE	VARCHAR2(4)	SI
24	IS_FIXED_ADDRESS	VARCHAR2(4)	SI
25	PRIMARY_ADDRESS_LINE_SEQ	NUMBER(22,0)	NO
26	IS_ACTIVE	VARCHAR2(4)	NO
27	IS_WMS_FACILITY	VARCHAR2(4)	NO
28	APPT_ENFORCE_ACT_TIME_SG	VARCHAR2(4)	NO
29	DOMAIN_NAME	VARCHAR2(200)	NO
30	INSERT_USER	VARCHAR2(512)	NO
31	INSERT_DATE	DATE	NO
32	UPDATE_USER	VARCHAR2(512)	SI
33	UPDATE_DATE	DATE	SI
34	AUDIT_ID	NUMBER	NO
35	ROW_ACTIVE	CHAR(1)	NO	‘A’

Restricciones

CHECK: DIM_LOCATION_OTM_ROW_ACTIVE_CK

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

CHECK: SYS_C0044794

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

CHECK: SYS_C0044795

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

CHECK: SYS_C0044796

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

CHECK: SYS_C0044797

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

CHECK: SYS_C0044798

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

CHECK: SYS_C0044799

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

CHECK: SYS_C0044800

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

CHECK: SYS_C0044801

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

CHECK: SYS_C0044802

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

CHECK: SYS_C0044803

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

CHECK: SYS_C0044804

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

CHECK: SYS_C0044805

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

CHECK: SYS_C0044806

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

CHECK: SYS_C0044807

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

CHECK: SYS_C0044808

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

CHECK: SYS_C0044809

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

CHECK: SYS_C0044810

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

CHECK: SYS_C0085795

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

CHECK: SYS_C0085848

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

PK: DIM_LOCATION_OTM_PK

• Estado: ENABLED
• Columnas: LOCATION_OTM_ID

UK: DIM_LOCATION_OTM_UN

• Estado: ENABLED
• Columnas: LOCATION_GID

DDL

CREATE TABLE "DWADW"."DIM_LOCATION_OTM" 
   (	"LOCATION_OTM_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, 
	"LOCATION_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"LOCATION_XID" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"LOCATION_NAME" VARCHAR2(1440) COLLATE "USING_NLS_COMP", 
	"CITY" VARCHAR2(960) COLLATE "USING_NLS_COMP", 
	"PROVINCE" VARCHAR2(960) COLLATE "USING_NLS_COMP", 
	"PROVINCE_CODE" VARCHAR2(24) COLLATE "USING_NLS_COMP", 
	"COUNTRY_CODE3_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"TIME_ZONE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"IS_TEMPORARY" CHAR(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_MAKE_APPT_BEFORE_PLAN" CHAR(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_SHIPPER_KNOWN" CHAR(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_ADDRESS_VALID" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_LTL_SPLITABLE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"USE_APPOINTMENT_PRIORITY" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"SCHEDULE_LOW_PRIORITY_APPOINT" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"ENFORCE_TIME_WINDOW_APPOINT" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"SCHEDULE_INFEASIBLE_APPOINT" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"BB_IS_NEW_STORE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"EXCLUDE_FROM_ROUTE_EXECUTION" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_TEMPLATE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ALLOW_DRIVER_REST" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"APPT_OBJECT_TYPE" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"IS_FIXED_ADDRESS" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"PRIMARY_ADDRESS_LINE_SEQ" NUMBER(22,0) NOT NULL ENABLE, 
	"IS_ACTIVE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_WMS_FACILITY" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"APPT_ENFORCE_ACT_TIME_SG" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"DOMAIN_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"INSERT_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"INSERT_DATE" DATE NOT NULL ENABLE, 
	"UPDATE_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP", 
	"UPDATE_DATE" DATE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	 CONSTRAINT "DIM_LOCATION_OTM_PK" PRIMARY KEY ("LOCATION_OTM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_LOCATION_OTM_UN" UNIQUE ("LOCATION_GID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "DIM_LOCATION_OTM_ROW_ACTIVE_CK" CHECK (ROW_ACTIVE IN ('A','I')) ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."DIM_LOCATION_OTM"  IS 'Español: Catálogo maestro de ubicaciones OTM con atributos geográficos y operativos. | English: Master catalog of OTM locations with geographic and operational attributes.';

CREATE UNIQUE INDEX "DWADW"."DIM_LOCATION_OTM_PK" ON "DWADW"."DIM_LOCATION_OTM" ("LOCATION_OTM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."DIM_LOCATION_OTM_UN" ON "DWADW"."DIM_LOCATION_OTM" ("LOCATION_GID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal