Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_SHIPMENT_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 2 | SHIPMENT_GID | VARCHAR2(404) | NO | ||
| 3 | SHIPMENT_XID | VARCHAR2(200) | NO | ||
| 4 | TRANSPORT_MODE_GID | VARCHAR2(404) | SI | ||
| 5 | IS_TEMPLATE | VARCHAR2(4) | NO | ||
| 6 | IS_PRIMARY | VARCHAR2(4) | NO | ||
| 7 | IS_SPOT_COSTED | VARCHAR2(4) | NO | ||
| 8 | IS_CREDIT_NOTE | VARCHAR2(4) | NO | ||
| 9 | TOTAL_ACTUAL_COST | NUMBER | SI | ||
| 10 | TOTAL_ACTUAL_COST_BASE | NUMBER | SI | ||
| 11 | TOTAL_WEIGHTED_COST | NUMBER | SI | ||
| 12 | TOTAL_WEIGHTED_COST_BASE | NUMBER | SI | ||
| 13 | T_ACTUAL_COST_CURRENCY_GID | VARCHAR2(404) | SI | ||
| 14 | T_WEIGHTED_COST_CURRENCY_GID | VARCHAR2(404) | SI | ||
| 15 | LOADED_DISTANCE | NUMBER | SI | ||
| 16 | LOADED_DISTANCE_UOM_CODE | VARCHAR2(256) | SI | ||
| 17 | LOADED_DISTANCE_BASE | NUMBER | SI | ||
| 18 | UNLOADED_DISTANCE | NUMBER | SI | ||
| 19 | UNLOADED_DISTANCE_UOM_CODE | VARCHAR2(256) | SI | ||
| 20 | UNLOADED_DISTANCE_BASE | NUMBER | SI | ||
| 21 | SOURCE_LOCATION_GID | VARCHAR2(404) | SI | ||
| 22 | DEST_LOCATION_GID | VARCHAR2(404) | SI | ||
| 23 | START_TIME | DATE | NO | ||
| 24 | END_TIME | DATE | NO | ||
| 25 | PARENT_LEG_GID | VARCHAR2(404) | SI | ||
| 26 | SERVPROV_GID | VARCHAR2(404) | SI | ||
| 27 | RATE_OFFERING_GID | VARCHAR2(404) | SI | ||
| 28 | RATE_GEO_GID | VARCHAR2(404) | SI | ||
| 29 | IS_AUTO_MERGE_CONSOLIDATE | CHAR(4) | NO | ||
| 30 | PERSPECTIVE | CHAR(4) | NO | ||
| 31 | TOTAL_WEIGHT | NUMBER | NO | ||
| 32 | TOTAL_WEIGHT_UOM_CODE | VARCHAR2(256) | NO | ||
| 33 | TOTAL_WEIGHT_BASE | NUMBER | NO | ||
| 34 | TOTAL_VOLUME | NUMBER | NO | ||
| 35 | TOTAL_VOLUME_UOM_CODE | VARCHAR2(256) | NO | ||
| 36 | TOTAL_VOLUME_BASE | NUMBER | NO | ||
| 37 | TOTAL_SHIP_UNIT_COUNT | NUMBER | SI | ||
| 38 | TOTAL_PACKAGING_UNIT_COUNT | NUMBER | NO | ||
| 39 | TOTAL_ITEM_PACKAGE_COUNT | NUMBER | NO | ||
| 40 | SHIPMENT_TYPE_GID | VARCHAR2(404) | SI | ||
| 41 | SHIPMENT_AS_WORK | VARCHAR2(4) | NO | ||
| 42 | CHECK_TIME_CONSTRAINT | CHAR(4) | NO | ||
| 43 | CHECK_COST_CONSTRAINT | CHAR(4) | NO | ||
| 44 | CHECK_CAPACITY_CONSTRAINT | CHAR(4) | NO | ||
| 45 | WEIGH_CODE | CHAR(4) | NO | ||
| 46 | RULE_7 | CHAR(4) | NO | ||
| 47 | SHIPMENT_RELEASED | CHAR(4) | NO | ||
| 48 | PLANNED_COST | NUMBER | SI | ||
| 49 | PLANNED_COST_BASE | NUMBER | SI | ||
| 50 | PLANNED_COST_CURRENCY_GID | VARCHAR2(404) | SI | ||
| 51 | IS_HAZARDOUS | VARCHAR2(4) | NO | ||
| 52 | IS_TEMPERATURE_CONTROL | VARCHAR2(4) | NO | ||
| 53 | IS_COST_FIXED | VARCHAR2(4) | NO | ||
| 54 | IS_SERVICE_TIME_FIXED | VARCHAR2(4) | NO | ||
| 55 | IS_RATE_GEO_FIXED | VARCHAR2(4) | NO | ||
| 56 | IS_RATE_OFFERING_FIXED | VARCHAR2(4) | NO | ||
| 57 | IS_SERVPROV_FIXED | VARCHAR2(4) | NO | ||
| 58 | IS_PRELOAD | VARCHAR2(4) | NO | ||
| 59 | IS_FIXED_TENDER_CONTACT | VARCHAR2(4) | NO | ||
| 60 | IS_TO_BE_HELD | VARCHAR2(4) | NO | ||
| 61 | IS_PREFERRED_CARRIER | VARCHAR2(4) | NO | ||
| 62 | IS_EQUIPMENT_FIXED | VARCHAR2(4) | NO | ||
| 63 | IS_RECALC_TOTALS | VARCHAR2(4) | NO | ||
| 64 | HAS_APPOINTMENTS | VARCHAR2(4) | NO | ||
| 65 | INDICATOR | VARCHAR2(4) | SI | ||
| 66 | BULK_PLAN_GID | VARCHAR2(404) | SI | ||
| 67 | ITINERARY_GID | VARCHAR2(404) | SI | ||
| 68 | FEASIBILITY_CODE_GID | VARCHAR2(404) | SI | ||
| 69 | NUM_ORDER_RELEASES | NUMBER | SI | ||
| 70 | NUM_STOPS | NUMBER | SI | ||
| 71 | TOTAL_NET_WEIGHT | NUMBER | NO | ||
| 72 | TOTAL_NET_WEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 73 | TOTAL_NET_WEIGHT_BASE | NUMBER | SI | ||
| 74 | TOTAL_NET_VOLUME | NUMBER | NO | ||
| 75 | TOTAL_NET_VOLUME_UOM_CODE | VARCHAR2(256) | SI | ||
| 76 | TOTAL_NET_VOLUME_BASE | NUMBER | SI | ||
| 77 | EARLIEST_START_TIME | DATE | SI | ||
| 78 | LATEST_START_TIME | DATE | SI | ||
| 79 | IN_TRAILER_BUILD | VARCHAR2(4) | NO | ||
| 80 | FIRST_EQUIPMENT_GROUP_GID | VARCHAR2(404) | SI | ||
| 81 | WEIGHT_UTILIZATION | NUMBER | NO | ||
| 82 | VOLUME_UTILIZATION | NUMBER | NO | ||
| 83 | EQUIP_REF_UNIT_UTILIZATION | NUMBER | NO | ||
| 84 | IS_CPCTY_OVERRIDE_APPLICABLE | VARCHAR2(4) | SI | ||
| 85 | PLANNED_RATE_OFFERING_GID | VARCHAR2(404) | SI | ||
| 86 | PLANNED_TRANSPORT_MODE_GID | VARCHAR2(404) | SI | ||
| 87 | PLANNED_SERVPROV_GID | VARCHAR2(404) | SI | ||
| 88 | PLANNED_RATE_GEO_GID | VARCHAR2(404) | SI | ||
| 89 | IS_MEMO_BL | VARCHAR2(4) | SI | ||
| 90 | DUTY_PAID | VARCHAR2(32) | NO | ||
| 91 | CURRENCY_GID | VARCHAR2(404) | SI | ||
| 92 | EXCHANGE_RATE_GID | VARCHAR2(404) | SI | ||
| 93 | TOTAL_DECLARED_VALUE | NUMBER | SI | ||
| 94 | TOTAL_DECLARED_VALUE_GID | VARCHAR2(404) | SI | ||
| 95 | TOTAL_DECLARED_VALUE_BASE | NUMBER | SI | ||
| 96 | IS_PROFIT_SPLIT | VARCHAR2(4) | SI | ||
| 97 | IS_ADVANCED_CHARGE | VARCHAR2(4) | SI | ||
| 98 | CHARGEABLE_WEIGHT | NUMBER | SI | ||
| 99 | CHARGEABLE_WEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 100 | CHARGEABLE_WEIGHT_BASE | NUMBER | SI | ||
| 101 | MARKED_FOR_PURGE | VARCHAR2(4) | NO | ||
| 102 | PREV_DROP_INVENTORY_PROCESSED | VARCHAR2(4) | SI | ||
| 103 | PICK_INVENTORY_PROCESSED | VARCHAR2(4) | SI | ||
| 104 | DROP_INVENTORY_PROCESSED | VARCHAR2(4) | SI | ||
| 105 | CHARGEABLE_VOLUME | NUMBER | SI | ||
| 106 | CHARGEABLE_VOLUME_UOM_CODE | VARCHAR2(256) | SI | ||
| 107 | CHARGEABLE_VOLUME_BASE | NUMBER | SI | ||
| 108 | PLANNING_PARAMETER_SET_GID | VARCHAR2(404) | SI | ||
| 109 | IS_FIXED_VOYAGE | VARCHAR2(4) | NO | ||
| 110 | SOLE_PACKAGED_ITEM_GID | VARCHAR2(404) | SI | ||
| 111 | IS_AR_ROUTE_CODE_FIXED | VARCHAR2(4) | NO | ||
| 112 | LOADING_HALL_PENALTY | NUMBER | SI | ||
| 113 | IS_PERMANENT | VARCHAR2(4) | SI | ||
| 114 | IS_FIXED_DISTANCE | VARCHAR2(4) | NO | ||
| 115 | DOMAIN_NAME | VARCHAR2(200) | NO | ||
| 116 | INSERT_USER | VARCHAR2(512) | NO | ||
| 117 | INSERT_DATE | DATE | NO | ||
| 118 | UPDATE_USER | VARCHAR2(512) | SI | ||
| 119 | UPDATE_DATE | DATE | SI | ||
| 120 | DRIVER_GID | VARCHAR2(404) | SI |
Restricciones
CHECK: SYS_C0059595
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
CHECK: SYS_C0059596
- Estado: ENABLED
- Columnas: SHIPMENT_GID
- Condición:
"SHIPMENT_GID" IS NOT NULL
CHECK: SYS_C0059597
- Estado: ENABLED
- Columnas: SHIPMENT_XID
- Condición:
"SHIPMENT_XID" IS NOT NULL
CHECK: SYS_C0059598
- Estado: ENABLED
- Columnas: IS_TEMPLATE
- Condición:
"IS_TEMPLATE" IS NOT NULL
CHECK: SYS_C0059599
- Estado: ENABLED
- Columnas: IS_PRIMARY
- Condición:
"IS_PRIMARY" IS NOT NULL
CHECK: SYS_C0059600
- Estado: ENABLED
- Columnas: IS_SPOT_COSTED
- Condición:
"IS_SPOT_COSTED" IS NOT NULL
CHECK: SYS_C0059601
- Estado: ENABLED
- Columnas: IS_CREDIT_NOTE
- Condición:
"IS_CREDIT_NOTE" IS NOT NULL
CHECK: SYS_C0059602
- Estado: ENABLED
- Columnas: START_TIME
- Condición:
"START_TIME" IS NOT NULL
CHECK: SYS_C0059603
- Estado: ENABLED
- Columnas: END_TIME
- Condición:
"END_TIME" IS NOT NULL
CHECK: SYS_C0059604
- Estado: ENABLED
- Columnas: IS_AUTO_MERGE_CONSOLIDATE
- Condición:
"IS_AUTO_MERGE_CONSOLIDATE" IS NOT NULL
CHECK: SYS_C0059605
- Estado: ENABLED
- Columnas: PERSPECTIVE
- Condición:
"PERSPECTIVE" IS NOT NULL
CHECK: SYS_C0059606
- Estado: ENABLED
- Columnas: TOTAL_WEIGHT
- Condición:
"TOTAL_WEIGHT" IS NOT NULL
CHECK: SYS_C0059607
- Estado: ENABLED
- Columnas: TOTAL_WEIGHT_UOM_CODE
- Condición:
"TOTAL_WEIGHT_UOM_CODE" IS NOT NULL
CHECK: SYS_C0059608
- Estado: ENABLED
- Columnas: TOTAL_WEIGHT_BASE
- Condición:
"TOTAL_WEIGHT_BASE" IS NOT NULL
CHECK: SYS_C0059609
- Estado: ENABLED
- Columnas: TOTAL_VOLUME
- Condición:
"TOTAL_VOLUME" IS NOT NULL
CHECK: SYS_C0059610
- Estado: ENABLED
- Columnas: TOTAL_VOLUME_UOM_CODE
- Condición:
"TOTAL_VOLUME_UOM_CODE" IS NOT NULL
CHECK: SYS_C0059611
- Estado: ENABLED
- Columnas: TOTAL_VOLUME_BASE
- Condición:
"TOTAL_VOLUME_BASE" IS NOT NULL
CHECK: SYS_C0059612
- Estado: ENABLED
- Columnas: TOTAL_PACKAGING_UNIT_COUNT
- Condición:
"TOTAL_PACKAGING_UNIT_COUNT" IS NOT NULL
CHECK: SYS_C0059613
- Estado: ENABLED
- Columnas: TOTAL_ITEM_PACKAGE_COUNT
- Condición:
"TOTAL_ITEM_PACKAGE_COUNT" IS NOT NULL
CHECK: SYS_C0059614
- Estado: ENABLED
- Columnas: SHIPMENT_AS_WORK
- Condición:
"SHIPMENT_AS_WORK" IS NOT NULL
CHECK: SYS_C0059615
- Estado: ENABLED
- Columnas: CHECK_TIME_CONSTRAINT
- Condición:
"CHECK_TIME_CONSTRAINT" IS NOT NULL
CHECK: SYS_C0059616
- Estado: ENABLED
- Columnas: CHECK_COST_CONSTRAINT
- Condición:
"CHECK_COST_CONSTRAINT" IS NOT NULL
CHECK: SYS_C0059617
- Estado: ENABLED
- Columnas: CHECK_CAPACITY_CONSTRAINT
- Condición:
"CHECK_CAPACITY_CONSTRAINT" IS NOT NULL
CHECK: SYS_C0059618
- Estado: ENABLED
- Columnas: WEIGH_CODE
- Condición:
"WEIGH_CODE" IS NOT NULL
CHECK: SYS_C0059619
- Estado: ENABLED
- Columnas: RULE_7
- Condición:
"RULE_7" IS NOT NULL
CHECK: SYS_C0059620
- Estado: ENABLED
- Columnas: SHIPMENT_RELEASED
- Condición:
"SHIPMENT_RELEASED" IS NOT NULL
CHECK: SYS_C0059621
- Estado: ENABLED
- Columnas: IS_HAZARDOUS
- Condición:
"IS_HAZARDOUS" IS NOT NULL
CHECK: SYS_C0059622
- Estado: ENABLED
- Columnas: IS_TEMPERATURE_CONTROL
- Condición:
"IS_TEMPERATURE_CONTROL" IS NOT NULL
CHECK: SYS_C0059623
- Estado: ENABLED
- Columnas: IS_COST_FIXED
- Condición:
"IS_COST_FIXED" IS NOT NULL
CHECK: SYS_C0059624
- Estado: ENABLED
- Columnas: IS_SERVICE_TIME_FIXED
- Condición:
"IS_SERVICE_TIME_FIXED" IS NOT NULL
CHECK: SYS_C0059625
- Estado: ENABLED
- Columnas: IS_RATE_GEO_FIXED
- Condición:
"IS_RATE_GEO_FIXED" IS NOT NULL
CHECK: SYS_C0059626
- Estado: ENABLED
- Columnas: IS_RATE_OFFERING_FIXED
- Condición:
"IS_RATE_OFFERING_FIXED" IS NOT NULL
CHECK: SYS_C0059627
- Estado: ENABLED
- Columnas: IS_SERVPROV_FIXED
- Condición:
"IS_SERVPROV_FIXED" IS NOT NULL
CHECK: SYS_C0059628
- Estado: ENABLED
- Columnas: IS_PRELOAD
- Condición:
"IS_PRELOAD" IS NOT NULL
CHECK: SYS_C0059629
- Estado: ENABLED
- Columnas: IS_FIXED_TENDER_CONTACT
- Condición:
"IS_FIXED_TENDER_CONTACT" IS NOT NULL
CHECK: SYS_C0059630
- Estado: ENABLED
- Columnas: IS_TO_BE_HELD
- Condición:
"IS_TO_BE_HELD" IS NOT NULL
CHECK: SYS_C0059631
- Estado: ENABLED
- Columnas: IS_PREFERRED_CARRIER
- Condición:
"IS_PREFERRED_CARRIER" IS NOT NULL
CHECK: SYS_C0059632
- Estado: ENABLED
- Columnas: IS_EQUIPMENT_FIXED
- Condición:
"IS_EQUIPMENT_FIXED" IS NOT NULL
CHECK: SYS_C0059633
- Estado: ENABLED
- Columnas: IS_RECALC_TOTALS
- Condición:
"IS_RECALC_TOTALS" IS NOT NULL
CHECK: SYS_C0059634
- Estado: ENABLED
- Columnas: HAS_APPOINTMENTS
- Condición:
"HAS_APPOINTMENTS" IS NOT NULL
CHECK: SYS_C0059635
- Estado: ENABLED
- Columnas: TOTAL_NET_WEIGHT
- Condición:
"TOTAL_NET_WEIGHT" IS NOT NULL
CHECK: SYS_C0059636
- Estado: ENABLED
- Columnas: TOTAL_NET_VOLUME
- Condición:
"TOTAL_NET_VOLUME" IS NOT NULL
CHECK: SYS_C0059637
- Estado: ENABLED
- Columnas: IN_TRAILER_BUILD
- Condición:
"IN_TRAILER_BUILD" IS NOT NULL
CHECK: SYS_C0059638
- Estado: ENABLED
- Columnas: WEIGHT_UTILIZATION
- Condición:
"WEIGHT_UTILIZATION" IS NOT NULL
CHECK: SYS_C0059639
- Estado: ENABLED
- Columnas: VOLUME_UTILIZATION
- Condición:
"VOLUME_UTILIZATION" IS NOT NULL
CHECK: SYS_C0059640
- Estado: ENABLED
- Columnas: EQUIP_REF_UNIT_UTILIZATION
- Condición:
"EQUIP_REF_UNIT_UTILIZATION" IS NOT NULL
CHECK: SYS_C0059641
- Estado: ENABLED
- Columnas: DUTY_PAID
- Condición:
"DUTY_PAID" IS NOT NULL
CHECK: SYS_C0059642
- Estado: ENABLED
- Columnas: MARKED_FOR_PURGE
- Condición:
"MARKED_FOR_PURGE" IS NOT NULL
CHECK: SYS_C0059643
- Estado: ENABLED
- Columnas: IS_FIXED_VOYAGE
- Condición:
"IS_FIXED_VOYAGE" IS NOT NULL
CHECK: SYS_C0059644
- Estado: ENABLED
- Columnas: IS_AR_ROUTE_CODE_FIXED
- Condición:
"IS_AR_ROUTE_CODE_FIXED" IS NOT NULL
CHECK: SYS_C0059645
- Estado: ENABLED
- Columnas: IS_FIXED_DISTANCE
- Condición:
"IS_FIXED_DISTANCE" IS NOT NULL
CHECK: SYS_C0059646
- Estado: ENABLED
- Columnas: DOMAIN_NAME
- Condición:
"DOMAIN_NAME" IS NOT NULL
CHECK: SYS_C0059647
- Estado: ENABLED
- Columnas: INSERT_USER
- Condición:
"INSERT_USER" IS NOT NULL
CHECK: SYS_C0059648
- Estado: ENABLED
- Columnas: INSERT_DATE
- Condición:
"INSERT_DATE" IS NOT NULL
DDL
-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name