STADW.ST_ORDERRELEASE_BKP

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo
1	ID	NUMBER	NO
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_C0053862

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

CHECK: SYS_C0053863

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

CHECK: SYS_C0053864

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

CHECK: SYS_C0053865

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

CHECK: SYS_C0053866

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

CHECK: SYS_C0053867

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

CHECK: SYS_C0053868

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

CHECK: SYS_C0053869

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

CHECK: SYS_C0053870

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

CHECK: SYS_C0053871

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

CHECK: SYS_C0053872

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

CHECK: SYS_C0053873

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

CHECK: SYS_C0053874

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

CHECK: SYS_C0053875

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

CHECK: SYS_C0053876

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

CHECK: SYS_C0053877

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

CHECK: SYS_C0053878

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

CHECK: SYS_C0053879

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

CHECK: SYS_C0053880

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

CHECK: SYS_C0053881

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

CHECK: SYS_C0053882

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

CHECK: SYS_C0053883

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

CHECK: SYS_C0053884

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

CHECK: SYS_C0053885

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

CHECK: SYS_C0053886

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

CHECK: SYS_C0053887

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

CHECK: SYS_C0053888

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

CHECK: SYS_C0053889

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

DDL

-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name

← Volver a tablas de STADW

🏠 Volver al menú principal