🏠 Menú principal

← Volver a tablas

---

STADW.ST_ORDERRELEASE

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	ID	NUMBER	NO	“STADW”.”ISEQ$$_192515”.nextval
2	IDMAESTROCARGUE	NUMBER(18,0)	NO
3	ORDER_RELEASE_XID	VARCHAR2(200)	NO
4	ORDER_RELEASE_NAME	VARCHAR2(480)	SI
5	ORDER_RELEASE_TYPE_GID	VARCHAR2(404)	SI
6	ORDER_RELEASE_GID	VARCHAR2(404)	NO
7	ASSIGNED_ITINERARY_GID	VARCHAR2(404)	SI
8	SOURCE_LOCATION_GID	VARCHAR2(404)	SI
9	DEST_LOCATION_GID	VARCHAR2(404)	SI
10	EARLY_PICKUP_DATE	DATE	SI
11	TOTAL_ITEM_PACKAGE_COUNT	NUMBER	SI
12	INDICATOR	VARCHAR2(4)	SI
13	TOTAL_NET_WEIGHT	NUMBER	SI
14	TOTAL_NET_WEIGHT_UOM_CODE	VARCHAR2(256)	SI
15	TOTAL_NET_WEIGHT_BASE	NUMBER	SI
16	TOTAL_NET_VOLUME	NUMBER	SI
17	TOTAL_NET_VOLUME_UOM_CODE	VARCHAR2(256)	SI
18	TOTAL_NET_VOLUME_BASE	NUMBER	SI
19	PICKUP_IS_APPT	VARCHAR2(4)	NO
20	DELIVERY_IS_APPT	VARCHAR2(4)	NO
21	IS_KNOWN_SHIPPER	VARCHAR2(4)	NO
22	RELEASE_METHOD_GID	VARCHAR2(404)	SI
23	LOC_AMOUNT	NUMBER	NO
24	LOC_AMOUNT_CURRENCY_GID	VARCHAR2(404)	NO
25	LOC_AMOUNT_BASE	NUMBER	NO
26	SECONDARY_T_WEIGHT	NUMBER	SI
27	SECONDARY_T_WEIGHT_UOM_CODE	VARCHAR2(256)	SI
28	SECONDARY_T_WEIGHT_BASE	NUMBER	SI
29	SECONDARY_T_VOLUME	NUMBER	SI
30	SECONDARY_T_VOLUME_UOM_CODE	VARCHAR2(256)	SI
31	SECONDARY_T_VOLUME_BASE	NUMBER	SI
32	MUST_SHIP_DIRECT	VARCHAR2(4)	NO
33	MUST_SHIP_THRU_X_DOCK	VARCHAR2(4)	NO
34	MUST_SHIP_THRU_POOL	VARCHAR2(4)	NO
35	IMPORT_LICENSE_REQUIRED	VARCHAR2(200)	SI
36	IS_LOC_REQUIRED	VARCHAR2(4)	NO
37	INSPECTION_REQUIRED	VARCHAR2(200)	SI
38	CUSTOMER_UNITIZATION_REQUEST	VARCHAR2(4)	NO
39	IS_LOC_STALE	VARCHAR2(4)	NO
40	BUNDLING_TYPE	VARCHAR2(200)	NO
41	IS_CONSOLIDATE_OR_EQUIPMENT	VARCHAR2(4)	NO
42	DUTY_PAID	VARCHAR2(32)	NO
43	TOTAL_DECLARED_VALUE	NUMBER	SI
44	TOTAL_DECLARED_VALUE_GID	VARCHAR2(404)	SI
45	TOTAL_DECLARED_VALUE_BASE	NUMBER	SI
46	BULK_PLAN_GID	VARCHAR2(404)	SI
47	TOTAL_SHIP_UNIT_COUNT	NUMBER	SI
48	TOTAL_WEIGHT	NUMBER	SI
49	TOTAL_WEIGHT_UOM_CODE	VARCHAR2(256)	SI
50	TOTAL_WEIGHT_BASE	NUMBER	SI
51	TOTAL_VOLUME	NUMBER	SI
52	TOTAL_VOLUME_UOM_CODE	VARCHAR2(256)	SI
53	ON_RT_EXECUTION	VARCHAR2(4)	NO
54	IS_SPLITTABLE	VARCHAR2(4)	SI
55	OTM_VERSION	VARCHAR2(60)	SI
56	TOTAL_VOLUME_BASE	NUMBER	SI
57	MARKED_FOR_PURGE	VARCHAR2(4)	NO
58	IS_PRE_ENTERED_PU	VARCHAR2(4)	NO
59	IS_TOPOFF	VARCHAR2(4)	NO
60	SHIP_UNIT_WIDTH	NUMBER	SI
61	SHIP_UNIT_WIDTH_UOM_CODE	VARCHAR2(256)	SI
62	SHIP_UNIT_WIDTH_BASE	NUMBER	SI
63	SHIP_UNIT_LENGTH	NUMBER	SI
64	SHIP_UNIT_LENGTH_UOM_CODE	VARCHAR2(256)	SI
65	SHIP_UNIT_LENGTH_BASE	NUMBER	SI
66	SHIP_UNIT_HEIGHT	NUMBER	SI
67	SHIP_UNIT_HEIGHT_UOM_CODE	VARCHAR2(256)	SI
68	SHIP_UNIT_HEIGHT_BASE	NUMBER	SI
69	PRIORITY	NUMBER	NO
70	IS_TEMPLATE	VARCHAR2(4)	NO
71	DOMAIN_NAME	VARCHAR2(200)	NO
72	INSERT_USER	VARCHAR2(512)	NO
73	INSERT_DATE	DATE	NO
74	UPDATE_USER	VARCHAR2(512)	SI
75	UPDATE_DATE	DATE	SI

Restricciones

CHECK: SYS_C0035538

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

CHECK: SYS_C0035539

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

CHECK: SYS_C0035540

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

CHECK: SYS_C0035541

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

CHECK: SYS_C0035542

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

CHECK: SYS_C0035543

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

CHECK: SYS_C0035544

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

CHECK: SYS_C0035545

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

CHECK: SYS_C0035546

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

CHECK: SYS_C0035547

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

CHECK: SYS_C0035548

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

CHECK: SYS_C0035549

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

CHECK: SYS_C0035550

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

CHECK: SYS_C0035551

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

CHECK: SYS_C0035552

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

CHECK: SYS_C0035553

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

CHECK: SYS_C0035554

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

CHECK: SYS_C0035555

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

CHECK: SYS_C0035556

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

CHECK: SYS_C0035557

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

CHECK: SYS_C0035558

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

CHECK: SYS_C0035559

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

CHECK: SYS_C0035560

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

CHECK: SYS_C0035561

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

CHECK: SYS_C0035562

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

CHECK: SYS_C0035563

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

CHECK: SYS_C0035564

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

CHECK: SYS_C0035565

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

PK: SYS_C0035566

• Estado: ENABLED
• Columnas: ID

DDL

CREATE TABLE "STADW"."ST_ORDERRELEASE" 
   (	"ID" NUMBER(*,0) GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE, 
	"ORDER_RELEASE_XID" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ORDER_RELEASE_NAME" VARCHAR2(480) COLLATE "USING_NLS_COMP", 
	"ORDER_RELEASE_TYPE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"ORDER_RELEASE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ASSIGNED_ITINERARY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"SOURCE_LOCATION_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"DEST_LOCATION_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"EARLY_PICKUP_DATE" DATE, 
	"TOTAL_ITEM_PACKAGE_COUNT" NUMBER, 
	"INDICATOR" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"TOTAL_NET_WEIGHT" NUMBER, 
	"TOTAL_NET_WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"TOTAL_NET_WEIGHT_BASE" NUMBER, 
	"TOTAL_NET_VOLUME" NUMBER, 
	"TOTAL_NET_VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"TOTAL_NET_VOLUME_BASE" NUMBER, 
	"PICKUP_IS_APPT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"DELIVERY_IS_APPT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_KNOWN_SHIPPER" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"RELEASE_METHOD_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"LOC_AMOUNT" NUMBER NOT NULL ENABLE, 
	"LOC_AMOUNT_CURRENCY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"LOC_AMOUNT_BASE" NUMBER NOT NULL ENABLE, 
	"SECONDARY_T_WEIGHT" NUMBER, 
	"SECONDARY_T_WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SECONDARY_T_WEIGHT_BASE" NUMBER, 
	"SECONDARY_T_VOLUME" NUMBER, 
	"SECONDARY_T_VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SECONDARY_T_VOLUME_BASE" NUMBER, 
	"MUST_SHIP_DIRECT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"MUST_SHIP_THRU_X_DOCK" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"MUST_SHIP_THRU_POOL" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IMPORT_LICENSE_REQUIRED" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"IS_LOC_REQUIRED" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"INSPECTION_REQUIRED" VARCHAR2(200) COLLATE "USING_NLS_COMP", 
	"CUSTOMER_UNITIZATION_REQUEST" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_LOC_STALE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"BUNDLING_TYPE" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_CONSOLIDATE_OR_EQUIPMENT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"DUTY_PAID" VARCHAR2(32) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"TOTAL_DECLARED_VALUE" NUMBER, 
	"TOTAL_DECLARED_VALUE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"TOTAL_DECLARED_VALUE_BASE" NUMBER, 
	"BULK_PLAN_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP", 
	"TOTAL_SHIP_UNIT_COUNT" NUMBER, 
	"TOTAL_WEIGHT" NUMBER, 
	"TOTAL_WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"TOTAL_WEIGHT_BASE" NUMBER, 
	"TOTAL_VOLUME" NUMBER, 
	"TOTAL_VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"ON_RT_EXECUTION" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_SPLITTABLE" VARCHAR2(4) COLLATE "USING_NLS_COMP", 
	"OTM_VERSION" VARCHAR2(60) COLLATE "USING_NLS_COMP", 
	"TOTAL_VOLUME_BASE" NUMBER, 
	"MARKED_FOR_PURGE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_PRE_ENTERED_PU" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"IS_TOPOFF" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"SHIP_UNIT_WIDTH" NUMBER, 
	"SHIP_UNIT_WIDTH_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SHIP_UNIT_WIDTH_BASE" NUMBER, 
	"SHIP_UNIT_LENGTH" NUMBER, 
	"SHIP_UNIT_LENGTH_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SHIP_UNIT_LENGTH_BASE" NUMBER, 
	"SHIP_UNIT_HEIGHT" NUMBER, 
	"SHIP_UNIT_HEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP", 
	"SHIP_UNIT_HEIGHT_BASE" NUMBER, 
	"PRIORITY" NUMBER NOT NULL ENABLE, 
	"IS_TEMPLATE" 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, 
	 PRIMARY KEY ("ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

CREATE UNIQUE INDEX "STADW"."SYS_C0035566" ON "STADW"."ST_ORDERRELEASE" ("ID") 
  ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal