Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_SHIP_ITEM_BOV_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | SHIPMENT_GID | VARCHAR2(404) | NO | ||
| 2 | SHIPMENT_XID | VARCHAR2(200) | NO | ||
| 3 | IS_TEMPLATE | VARCHAR2(4) | NO | ||
| 4 | TRANSPORT_MODE_GID | VARCHAR2(404) | SI | ||
| 5 | TOTAL_ACTUAL_COST | NUMBER(22,0) | SI | ||
| 6 | TOTAL_ACTUAL_COST_BASE | NUMBER(22,0) | SI | ||
| 7 | TOTAL_WEIGHTED_COST | NUMBER(22,0) | SI | ||
| 8 | TOTAL_WEIGHTED_COST_BASE | NUMBER(22,0) | SI | ||
| 9 | T_ACTUAL_COST_CURRENCY_GID | VARCHAR2(404) | SI | ||
| 10 | T_WEIGHTED_COST_CURRENCY_GID | VARCHAR2(404) | SI | ||
| 11 | LOADED_DISTANCE | NUMBER(22,0) | SI | ||
| 12 | LOADED_DISTANCE_UOM_CODE | VARCHAR2(256) | SI | ||
| 13 | LOADED_DISTANCE_BASE | NUMBER(22,0) | SI | ||
| 14 | UNLOADED_DISTANCE | NUMBER(22,0) | SI | ||
| 15 | UNLOADED_DISTANCE_UOM_CODE | VARCHAR2(256) | SI | ||
| 16 | UNLOADED_DISTANCE_BASE | NUMBER(22,0) | SI | ||
| 17 | SHIP_START_TIME | DATE | NO | ||
| 18 | SHIP_END_TIME | DATE | NO | ||
| 19 | PARENT_LEG_GID | VARCHAR2(404) | SI | ||
| 20 | SERVPROV_GID | VARCHAR2(404) | SI | ||
| 21 | SERVPROV_NAME | VARCHAR2(32767) | SI | ||
| 22 | SERVPROV_ADDRESS | VARCHAR2(32767) | SI | ||
| 23 | RATE_OFFERING_GID | VARCHAR2(404) | SI | ||
| 24 | RATE_GEO_GID | VARCHAR2(404) | SI | ||
| 25 | X_LANE_XID | VARCHAR2(32767) | SI | ||
| 26 | X_LANE_DETAILS | VARCHAR2(32767) | SI | ||
| 27 | IS_AUTO_MERGE_CONSOLIDATE | CHAR(4) | NO | ||
| 28 | PERSPECTIVE | CHAR(4) | NO | ||
| 29 | TOTAL_WEIGHT | NUMBER(22,0) | NO | ||
| 30 | TOTAL_WEIGHT_UOM_CODE | VARCHAR2(256) | NO | ||
| 31 | TOTAL_WEIGHT_BASE | NUMBER(22,0) | NO | ||
| 32 | TOTAL_VOLUME | NUMBER(22,0) | NO | ||
| 33 | TOTAL_VOLUME_UOM_CODE | VARCHAR2(256) | NO | ||
| 34 | TOTAL_VOLUME_BASE | NUMBER(22,0) | NO | ||
| 35 | ORDER_RELEASE_GID | VARCHAR2(404) | SI | ||
| 36 | SHIPMENT_AS_WORK | VARCHAR2(4) | NO | ||
| 37 | CHECK_TIME_CONSTRAINT | CHAR(4) | NO | ||
| 38 | CHECK_COST_CONSTRAINT | CHAR(4) | NO | ||
| 39 | CHECK_CAPACITY_CONSTRAINT | CHAR(4) | NO | ||
| 40 | WEIGH_CODE | CHAR(4) | NO | ||
| 41 | RULE_7 | CHAR(4) | NO | ||
| 42 | SHIPMENT_RELEASED | CHAR(4) | NO | ||
| 43 | S_SHIP_UNIT_GID | VARCHAR2(404) | NO | ||
| 44 | S_SHIP_UNIT_XID | VARCHAR2(200) | NO | ||
| 45 | UNIT_LENGTH | NUMBER(22,0) | SI | ||
| 46 | UNIT_LENGTH_UOM_CODE | VARCHAR2(256) | SI | ||
| 47 | UNIT_LENGTH_BASE54 | NUMBER(22,0) | SI | ||
| 48 | UNIT_WIDTH | NUMBER(22,0) | SI | ||
| 49 | UNIT_WIDTH_UOM_CODE | VARCHAR2(256) | SI | ||
| 50 | UNIT_WIDTH_BASE | NUMBER(22,0) | SI | ||
| 51 | UNIT_HEIGHT | NUMBER(22,0) | SI | ||
| 52 | UNIT_HEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 53 | UNIT_HEIGHT_BASE | NUMBER(22,0) | SI | ||
| 54 | UNIT_WEIGHT | NUMBER(22,0) | SI | ||
| 55 | UNIT_WEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 56 | UNIT_WEIGHT_BASE | NUMBER(22,0) | SI | ||
| 57 | UNIT_VOLUME | NUMBER(22,0) | SI | ||
| 58 | UNIT_VOLUME_UOM_CODE | VARCHAR2(256) | SI | ||
| 59 | UNIT_VOLUME_BASE | NUMBER(22,0) | SI | ||
| 60 | IS_SPLITABLE | VARCHAR2(4) | NO | ||
| 61 | SHIP_UNIT_COUNT | NUMBER(22,0) | NO | ||
| 62 | S_SHIP_UNIT_LINE_NO | NUMBER(22,0) | NO | ||
| 63 | ITEM_WEIGHT | NUMBER | SI | ||
| 64 | ITEM_WEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 65 | ITEM_WEIGHT_BASE | NUMBER(22,0) | SI | ||
| 66 | WEIGHT_BASE_UOM | VARCHAR2(32767) | SI | ||
| 67 | VOLUME_BASE_UOM | VARCHAR2(32767) | SI | ||
| 68 | ITEM_VOLUME | NUMBER(22,0) | SI | ||
| 69 | VOLUME_UOM_CODE | VARCHAR2(256) | SI | ||
| 70 | ITEM_VOLUME_BASE | NUMBER(22,0) | SI | ||
| 71 | ITEM_GID | VARCHAR2(404) | NO | ||
| 72 | ITEM_XID | VARCHAR2(200) | NO | ||
| 73 | ITEM_NAME | VARCHAR2(960) | SI | ||
| 74 | ITEM_DESCRIPTION | VARCHAR2(2000) | SI | ||
| 75 | ITEM_COMMODITY | VARCHAR2(32767) | SI | ||
| 76 | OR_LINE_GID | VARCHAR2(404) | SI | ||
| 77 | ITEM_PACKAGE_COUNT | NUMBER(22,0) | SI | ||
| 78 | DECLARED_VALUE | NUMBER(22,0) | SI | ||
| 79 | DECLARED_VALUE_CURRENCY_GID | VARCHAR2(404) | SI | ||
| 80 | PACKAGED_ITEM_GID | VARCHAR2(404) | NO | ||
| 81 | ORDER_RELEASE_XID | VARCHAR2(32767) | SI | ||
| 82 | RN | NUMBER | SI | ||
| 83 | DOMAIN_NAME | VARCHAR2(200) | NO | ||
| 84 | INSERT_USER | VARCHAR2(512) | SI | ||
| 85 | INSERT_DATE | DATE | NO | ||
| 86 | UPDATE_USER | VARCHAR2(512) | SI | ||
| 87 | UPDATE_DATE | DATE | SI | ||
| 88 | IDMAESTROCARGUE | NUMBER(18,0) | NO |
Restricciones
CHECK: SYS_C0078234
- Estado: ENABLED
- Columnas: SHIPMENT_GID
- Condición:
"SHIPMENT_GID" IS NOT NULL
CHECK: SYS_C0078235
- Estado: ENABLED
- Columnas: SHIPMENT_XID
- Condición:
"SHIPMENT_XID" IS NOT NULL
CHECK: SYS_C0078236
- Estado: ENABLED
- Columnas: IS_TEMPLATE
- Condición:
"IS_TEMPLATE" IS NOT NULL
CHECK: SYS_C0078237
- Estado: ENABLED
- Columnas: SHIP_START_TIME
- Condición:
"SHIP_START_TIME" IS NOT NULL
CHECK: SYS_C0078238
- Estado: ENABLED
- Columnas: SHIP_END_TIME
- Condición:
"SHIP_END_TIME" IS NOT NULL
CHECK: SYS_C0078239
- Estado: ENABLED
- Columnas: IS_AUTO_MERGE_CONSOLIDATE
- Condición:
"IS_AUTO_MERGE_CONSOLIDATE" IS NOT NULL
CHECK: SYS_C0078240
- Estado: ENABLED
- Columnas: PERSPECTIVE
- Condición:
"PERSPECTIVE" IS NOT NULL
CHECK: SYS_C0078241
- Estado: ENABLED
- Columnas: TOTAL_WEIGHT
- Condición:
"TOTAL_WEIGHT" IS NOT NULL
CHECK: SYS_C0078242
- Estado: ENABLED
- Columnas: TOTAL_WEIGHT_UOM_CODE
- Condición:
"TOTAL_WEIGHT_UOM_CODE" IS NOT NULL
CHECK: SYS_C0078243
- Estado: ENABLED
- Columnas: TOTAL_WEIGHT_BASE
- Condición:
"TOTAL_WEIGHT_BASE" IS NOT NULL
CHECK: SYS_C0078244
- Estado: ENABLED
- Columnas: TOTAL_VOLUME
- Condición:
"TOTAL_VOLUME" IS NOT NULL
CHECK: SYS_C0078245
- Estado: ENABLED
- Columnas: TOTAL_VOLUME_UOM_CODE
- Condición:
"TOTAL_VOLUME_UOM_CODE" IS NOT NULL
CHECK: SYS_C0078246
- Estado: ENABLED
- Columnas: TOTAL_VOLUME_BASE
- Condición:
"TOTAL_VOLUME_BASE" IS NOT NULL
CHECK: SYS_C0078247
- Estado: ENABLED
- Columnas: SHIPMENT_AS_WORK
- Condición:
"SHIPMENT_AS_WORK" IS NOT NULL
CHECK: SYS_C0078248
- Estado: ENABLED
- Columnas: CHECK_TIME_CONSTRAINT
- Condición:
"CHECK_TIME_CONSTRAINT" IS NOT NULL
CHECK: SYS_C0078249
- Estado: ENABLED
- Columnas: CHECK_COST_CONSTRAINT
- Condición:
"CHECK_COST_CONSTRAINT" IS NOT NULL
CHECK: SYS_C0078250
- Estado: ENABLED
- Columnas: CHECK_CAPACITY_CONSTRAINT
- Condición:
"CHECK_CAPACITY_CONSTRAINT" IS NOT NULL
CHECK: SYS_C0078251
- Estado: ENABLED
- Columnas: WEIGH_CODE
- Condición:
"WEIGH_CODE" IS NOT NULL
CHECK: SYS_C0078252
- Estado: ENABLED
- Columnas: RULE_7
- Condición:
"RULE_7" IS NOT NULL
CHECK: SYS_C0078253
- Estado: ENABLED
- Columnas: SHIPMENT_RELEASED
- Condición:
"SHIPMENT_RELEASED" IS NOT NULL
CHECK: SYS_C0078254
- Estado: ENABLED
- Columnas: S_SHIP_UNIT_GID
- Condición:
"S_SHIP_UNIT_GID" IS NOT NULL
CHECK: SYS_C0078255
- Estado: ENABLED
- Columnas: S_SHIP_UNIT_XID
- Condición:
"S_SHIP_UNIT_XID" IS NOT NULL
CHECK: SYS_C0078256
- Estado: ENABLED
- Columnas: IS_SPLITABLE
- Condición:
"IS_SPLITABLE" IS NOT NULL
CHECK: SYS_C0078257
- Estado: ENABLED
- Columnas: SHIP_UNIT_COUNT
- Condición:
"SHIP_UNIT_COUNT" IS NOT NULL
CHECK: SYS_C0078258
- Estado: ENABLED
- Columnas: S_SHIP_UNIT_LINE_NO
- Condición:
"S_SHIP_UNIT_LINE_NO" IS NOT NULL
CHECK: SYS_C0078259
- Estado: ENABLED
- Columnas: ITEM_GID
- Condición:
"ITEM_GID" IS NOT NULL
CHECK: SYS_C0078260
- Estado: ENABLED
- Columnas: ITEM_XID
- Condición:
"ITEM_XID" IS NOT NULL
CHECK: SYS_C0078261
- Estado: ENABLED
- Columnas: PACKAGED_ITEM_GID
- Condición:
"PACKAGED_ITEM_GID" IS NOT NULL
CHECK: SYS_C0078262
- Estado: ENABLED
- Columnas: DOMAIN_NAME
- Condición:
"DOMAIN_NAME" IS NOT NULL
CHECK: SYS_C0078263
- Estado: ENABLED
- Columnas: INSERT_DATE
- Condición:
"INSERT_DATE" IS NOT NULL
CHECK: SYS_C0078264
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name