🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_ORDERRELEASE_OTM

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de hechos de order releases con métricas de demanda y enlaces a dimensiones principales. | English: Fact table of order releases with demand metrics linked to core dimensions.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	ORDERRELEASE_OTM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_220885”.nextval
2	ORDER_RELEASE_GID	VARCHAR2(404)	NO
3	ORDER_RELEASE_XID	VARCHAR2(200)	NO
4	ORDER_RELEASE_NAME	VARCHAR2(480)	SI
5	ORDER_RELEASE_TYPE_GID	VARCHAR2(404)	SI
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	SOURCE_LOCATION_ADDRESS_OTM_ID	NUMBER	SI
72	DEST_LOCATION_ADDRESS_OTM_ID	NUMBER	SI
73	DIM_ORDERRELEASETYPE_OTM_ID	NUMBER	SI
74	INSERT_USER	VARCHAR2(512)	NO
75	INSERT_DATE	DATE	NO
76	UPDATE_USER	VARCHAR2(512)	SI
77	UPDATE_DATE	DATE	SI
78	DIM_BULKPLAN_OTM_ID	NUMBER	SI
79	DIM_ITINERARY_OTM_ID	NUMBER	SI
80	DIM_TIME_OTM_ID	NUMBER	SI
81	AUDIT_ID	NUMBER	NO
82	ROW_ACTIVE	CHAR(1)	NO	‘A’

Restricciones

CHECK: FACT_ORDERRELEASE_OTM_ROW_ACTIVE_CK

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

CHECK: SYS_C0045016

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

CHECK: SYS_C0045017

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

CHECK: SYS_C0045018

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

CHECK: SYS_C0045019

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

CHECK: SYS_C0045020

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

CHECK: SYS_C0045021

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

CHECK: SYS_C0045022

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

CHECK: SYS_C0045023

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

CHECK: SYS_C0045024

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

CHECK: SYS_C0045025

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

CHECK: SYS_C0045026

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

CHECK: SYS_C0045027

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

CHECK: SYS_C0045028

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

CHECK: SYS_C0045029

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

CHECK: SYS_C0045030

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

CHECK: SYS_C0045031

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

CHECK: SYS_C0045032

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

CHECK: SYS_C0045033

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

CHECK: SYS_C0045034

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

CHECK: SYS_C0045035

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

CHECK: SYS_C0045036

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

CHECK: SYS_C0045037

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

CHECK: SYS_C0045038

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

CHECK: SYS_C0045039

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

CHECK: SYS_C0045040

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

CHECK: SYS_C0045042

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

CHECK: SYS_C0045043

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

CHECK: SYS_C0085816

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

CHECK: SYS_C0085890

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

PK: FACT_ORDERRELEASE_OTM_PK

• Estado: ENABLED
• Columnas: ORDERRELEASE_OTM_ID

FK: FACT_ORDERRELEASE_ORTYPE_OTM_FK

• Estado: ENABLED
• Columnas: DIM_ORDERRELEASETYPE_OTM_ID
• Referencia: DWADW.DIM_ORDERRELEASETYPE_OTM (constraint DIM_ORDERRELEASETYPE_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_BULKPLAN_OTM_FK

• Estado: ENABLED
• Columnas: DIM_BULKPLAN_OTM_ID
• Referencia: DWADW.DIM_BULKPLAN_OTM (constraint DIM_BULKPLAN_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_ITINERARY_OTM_FK

• Estado: ENABLED
• Columnas: DIM_ITINERARY_OTM_ID
• Referencia: DWADW.DIM_ITINERARY_OTM (constraint DIM_ITINERARY_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_LOCATION_ADDRESS_OTM_FK

• Estado: ENABLED
• Columnas: SOURCE_LOCATION_ADDRESS_OTM_ID
• Referencia: DWADW.DIM_LOCATION_ADDRESS_OTM (constraint DIM_LOCATION_ADDRESS_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_LOCATION_ADDRESS_OTM_FKV2

• Estado: ENABLED
• Columnas: DEST_LOCATION_ADDRESS_OTM_ID
• Referencia: DWADW.DIM_LOCATION_ADDRESS_OTM (constraint DIM_LOCATION_ADDRESS_OTM_PK)

FK: FACT_ORDERRELEASE_OTM_DIM_TIME_OTM_FK

• Estado: ENABLED
• Columnas: DIM_TIME_OTM_ID
• Referencia: DWADW.DIM_TIME_OTM (constraint DIM_TIEMPO_OTM_PK)

UK: DIM_ORDERRELEASE_OTM_UN

• Estado: ENABLED
• Columnas: ORDER_RELEASE_GID

DDL

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

---

← Volver a tablas de DWADW

🏠 Volver al menú principal