🏠 Menú principal

← Volver a tablas

---

STADW.ST_ORDERRELEASE_HIST

Base de datos origen: ADW COEXITO

Columnas

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

Restricciones

CHECK: SYS_C0036026

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

CHECK: SYS_C0036027

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

CHECK: SYS_C0036028

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

CHECK: SYS_C0036029

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

CHECK: SYS_C0036030

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

CHECK: SYS_C0036031

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

CHECK: SYS_C0036032

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

CHECK: SYS_C0036033

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

CHECK: SYS_C0036034

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

CHECK: SYS_C0036035

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

CHECK: SYS_C0036036

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

CHECK: SYS_C0036037

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

CHECK: SYS_C0036038

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

CHECK: SYS_C0036039

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

CHECK: SYS_C0036040

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

CHECK: SYS_C0036041

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

CHECK: SYS_C0036042

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

CHECK: SYS_C0036043

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

CHECK: SYS_C0036044

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

CHECK: SYS_C0036045

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

CHECK: SYS_C0036046

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

CHECK: SYS_C0036047

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

CHECK: SYS_C0036048

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

CHECK: SYS_C0036049

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

CHECK: SYS_C0036050

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

CHECK: SYS_C0036051

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

CHECK: SYS_C0036052

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

DDL

CREATE TABLE "STADW"."ST_ORDERRELEASE_HIST" 
   (	"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
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

---

← Volver a tablas de STADW

🏠 Volver al menú principal