STADW.ST_LOCATION_HIST

Base de datos origen: ADW COEXITO

Columnas

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

Restricciones

CHECK: SYS_C0044437

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

CHECK: SYS_C0044438

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

CHECK: SYS_C0044439

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

CHECK: SYS_C0044440

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

CHECK: SYS_C0044441

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

CHECK: SYS_C0044442

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

CHECK: SYS_C0044443

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

CHECK: SYS_C0044444

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

CHECK: SYS_C0044445

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

CHECK: SYS_C0044446

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

CHECK: SYS_C0044447

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

CHECK: SYS_C0044448

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

CHECK: SYS_C0044449

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

CHECK: SYS_C0044450

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

CHECK: SYS_C0044451

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

CHECK: SYS_C0044452

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

CHECK: SYS_C0044453

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

DDL

CREATE TABLE "STADW"."ST_LOCATION_HIST" 
   (	"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, 
	"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT ALTER ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT DELETE ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT INDEX ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT INSERT ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT SELECT ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT UPDATE ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT REFERENCES ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT READ ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT ON COMMIT REFRESH ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT QUERY REWRITE ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT DEBUG ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT FLASHBACK ON "STADW"."ST_LOCATION_HIST" TO "BICC";
  GRANT ASSERTION REFERENCES ON "STADW"."ST_LOCATION_HIST" TO "BICC";

← Volver a tablas de STADW

🏠 Volver al menú principal