STADW.ST_SHIPMENTSTOP

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default
1	ID	NUMBER	NO	“STADW”.”ISEQ$$_192334”.nextval
2	IDMAESTROCARGUE	NUMBER(18,0)	NO
3	SHIPMENT_GID	VARCHAR2(404)	NO
4	STOP_NUM	NUMBER	NO
5	LOCATION_GID	VARCHAR2(404)	NO
6	LOCATION_ROLE_GID	VARCHAR2(404)	SI
7	PLANNED_ARRIVAL	DATE	SI
8	ESTIMATED_ARRIVAL	DATE	SI
9	IS_FIXED_ARRIVAL	CHAR(4)	NO
10	PLANNED_DEPARTURE	DATE	SI
11	ESTIMATED_DEPARTURE	DATE	SI
12	IS_FIXED_DEPARTURE	CHAR(4)	NO
13	WAIT_TIME	NUMBER	SI
14	WAIT_TIME_UOM_CODE	VARCHAR2(256)	SI
15	WAIT_TIME_BASE	NUMBER	SI
16	REST_TIME	NUMBER	SI
17	REST_TIME_UOM_CODE	VARCHAR2(256)	SI
18	REST_TIME_BASE	NUMBER	SI
19	DRIVE_TIME	NUMBER	SI
20	DRIVE_TIME_UOM_CODE	VARCHAR2(256)	SI
21	DRIVE_TIME_BASE	NUMBER	SI
22	DIST_FROM_PREV_STOP	NUMBER	SI
23	DIST_FROM_PREV_STOP_UOM_CODE	VARCHAR2(256)	SI
24	DIST_FROM_PREV_STOP_BASE	NUMBER	SI
25	ACTIVITY_TIME	NUMBER	SI
26	ACTIVITY_TIME_UOM_CODE	VARCHAR2(256)	SI
27	ACTIVITY_TIME_BASE	NUMBER	SI
28	IS_PERMANENT	VARCHAR2(4)	NO
29	IS_DEPOT	VARCHAR2(4)	NO
30	ACCESSORIAL_TIME	NUMBER	SI
31	ACCESSORIAL_TIME_UOM_CODE	VARCHAR2(256)	SI
32	ACCESSORIAL_TIME_BASE	NUMBER	SI
33	IS_FIXED_DISTANCE	VARCHAR2(4)	NO
34	RUSH_HOUR_TIME	NUMBER	SI
35	RUSH_HOUR_TIME_UOM_CODE	VARCHAR2(256)	SI
36	RUSH_HOUR_TIME_BASE	NUMBER	SI
37	IS_MOTHER_VESSEL	VARCHAR2(4)	NO
38	STOP_TYPE	VARCHAR2(64)	SI
39	DRIVER_NON_PAYABLE	VARCHAR2(4)	NO
40	DISTANCE_TYPE	VARCHAR2(4)	SI
41	RUNNING_WEIGHT	NUMBER	SI
42	RUNNING_WEIGHT_UOM_CODE	VARCHAR2(256)	SI
43	RUNNING_WEIGHT_BASE	NUMBER	SI
44	DOMAIN_NAME	VARCHAR2(200)	NO
45	INSERT_USER	VARCHAR2(512)	NO
46	INSERT_DATE	DATE	NO
47	UPDATE_USER	VARCHAR2(512)	SI
48	UPDATE_DATE	DATE	SI

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