Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_SHIP_ITEM_BOV_BKP
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | ID | NUMBER | NO | ||
| 2 | SHIPMENT_GID | VARCHAR2(404) | NO | ||
| 3 | SHIPMENT_XID | VARCHAR2(200) | NO | ||
| 4 | IS_TEMPLATE | VARCHAR2(4) | NO | ||
| 5 | TRANSPORT_MODE_GID | VARCHAR2(404) | SI | ||
| 6 | TOTAL_ACTUAL_COST | NUMBER(22,0) | SI | ||
| 7 | TOTAL_ACTUAL_COST_BASE | NUMBER(22,0) | SI | ||
| 8 | TOTAL_WEIGHTED_COST | NUMBER(22,0) | SI | ||
| 9 | TOTAL_WEIGHTED_COST_BASE | NUMBER(22,0) | SI | ||
| 10 | T_ACTUAL_COST_CURRENCY_GID | VARCHAR2(404) | SI | ||
| 11 | T_WEIGHTED_COST_CURRENCY_GID | VARCHAR2(404) | SI | ||
| 12 | LOADED_DISTANCE | NUMBER(22,0) | SI | ||
| 13 | LOADED_DISTANCE_UOM_CODE | VARCHAR2(256) | SI | ||
| 14 | LOADED_DISTANCE_BASE | NUMBER(22,0) | SI | ||
| 15 | UNLOADED_DISTANCE | NUMBER(22,0) | SI | ||
| 16 | UNLOADED_DISTANCE_UOM_CODE | VARCHAR2(256) | SI | ||
| 17 | UNLOADED_DISTANCE_BASE | NUMBER(22,0) | SI | ||
| 18 | SHIP_START_TIME | DATE | NO | ||
| 19 | SHIP_END_TIME | DATE | NO | ||
| 20 | PARENT_LEG_GID | VARCHAR2(404) | SI | ||
| 21 | SERVPROV_GID | VARCHAR2(404) | SI | ||
| 22 | SERVPROV_NAME | VARCHAR2(32767) | SI | ||
| 23 | SERVPROV_ADDRESS | VARCHAR2(32767) | SI | ||
| 24 | RATE_OFFERING_GID | VARCHAR2(404) | SI | ||
| 25 | RATE_GEO_GID | VARCHAR2(404) | SI | ||
| 26 | X_LANE_XID | VARCHAR2(32767) | SI | ||
| 27 | X_LANE_DETAILS | VARCHAR2(32767) | SI | ||
| 28 | IS_AUTO_MERGE_CONSOLIDATE | CHAR(4) | NO | ||
| 29 | PERSPECTIVE | CHAR(4) | NO | ||
| 30 | TOTAL_WEIGHT | NUMBER(22,0) | NO | ||
| 31 | TOTAL_WEIGHT_UOM_CODE | VARCHAR2(256) | NO | ||
| 32 | TOTAL_WEIGHT_BASE | NUMBER(22,0) | NO | ||
| 33 | TOTAL_VOLUME | NUMBER(22,0) | NO | ||
| 34 | TOTAL_VOLUME_UOM_CODE | VARCHAR2(256) | NO | ||
| 35 | TOTAL_VOLUME_BASE | NUMBER(22,0) | NO | ||
| 36 | ORDER_RELEASE_GID | VARCHAR2(404) | SI | ||
| 37 | SHIPMENT_AS_WORK | VARCHAR2(4) | NO | ||
| 38 | CHECK_TIME_CONSTRAINT | CHAR(4) | NO | ||
| 39 | CHECK_COST_CONSTRAINT | CHAR(4) | NO | ||
| 40 | CHECK_CAPACITY_CONSTRAINT | CHAR(4) | NO | ||
| 41 | WEIGH_CODE | CHAR(4) | NO | ||
| 42 | RULE_7 | CHAR(4) | NO | ||
| 43 | SHIPMENT_RELEASED | CHAR(4) | NO | ||
| 44 | S_SHIP_UNIT_GID | VARCHAR2(404) | NO | ||
| 45 | S_SHIP_UNIT_XID | VARCHAR2(200) | NO | ||
| 46 | UNIT_LENGTH | NUMBER(22,0) | SI | ||
| 47 | UNIT_LENGTH_UOM_CODE | VARCHAR2(256) | SI | ||
| 48 | UNIT_LENGTH_BASE54 | NUMBER(22,0) | SI | ||
| 49 | UNIT_WIDTH | NUMBER(22,0) | SI | ||
| 50 | UNIT_WIDTH_UOM_CODE | VARCHAR2(256) | SI | ||
| 51 | UNIT_WIDTH_BASE | NUMBER(22,0) | SI | ||
| 52 | UNIT_HEIGHT | NUMBER(22,0) | SI | ||
| 53 | UNIT_HEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 54 | UNIT_HEIGHT_BASE | NUMBER(22,0) | SI | ||
| 55 | UNIT_WEIGHT | NUMBER(22,0) | SI | ||
| 56 | UNIT_WEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 57 | UNIT_WEIGHT_BASE | NUMBER(22,0) | SI | ||
| 58 | UNIT_VOLUME | NUMBER(22,0) | SI | ||
| 59 | UNIT_VOLUME_UOM_CODE | VARCHAR2(256) | SI | ||
| 60 | UNIT_VOLUME_BASE | NUMBER(22,0) | SI | ||
| 61 | IS_SPLITABLE | VARCHAR2(4) | NO | ||
| 62 | SHIP_UNIT_COUNT | NUMBER(22,0) | NO | ||
| 63 | S_SHIP_UNIT_LINE_NO | NUMBER(22,0) | NO | ||
| 64 | ITEM_WEIGHT | NUMBER | SI | ||
| 65 | ITEM_WEIGHT_UOM_CODE | VARCHAR2(256) | NO | ||
| 66 | ITEM_WEIGHT_BASE | NUMBER(22,0) | SI | ||
| 67 | WEIGHT_BASE_UOM | VARCHAR2(32767) | SI | ||
| 68 | VOLUME_BASE_UOM | VARCHAR2(32767) | SI | ||
| 69 | ITEM_VOLUME | NUMBER(22,0) | SI | ||
| 70 | VOLUME_UOM_CODE | VARCHAR2(256) | SI | ||
| 71 | ITEM_VOLUME_BASE | NUMBER(22,0) | SI | ||
| 72 | ITEM_GID | VARCHAR2(404) | NO | ||
| 73 | ITEM_XID | VARCHAR2(200) | NO | ||
| 74 | ITEM_NAME | VARCHAR2(960) | SI | ||
| 75 | ITEM_DESCRIPTION | VARCHAR2(2000) | SI | ||
| 76 | ITEM_COMMODITY | VARCHAR2(32767) | SI | ||
| 77 | OR_LINE_GID | VARCHAR2(404) | SI | ||
| 78 | ITEM_PACKAGE_COUNT | NUMBER(22,0) | SI | ||
| 79 | DECLARED_VALUE | NUMBER(22,0) | SI | ||
| 80 | DECLARED_VALUE_CURRENCY_GID | VARCHAR2(404) | SI | ||
| 81 | PACKAGED_ITEM_GID | VARCHAR2(404) | NO | ||
| 82 | ORDER_RELEASE_XID | VARCHAR2(32767) | SI | ||
| 83 | RN | NUMBER | SI | ||
| 84 | DOMAIN_NAME | VARCHAR2(200) | NO | ||
| 85 | INSERT_USER | VARCHAR2(512) | SI | ||
| 86 | INSERT_DATE | DATE | NO | ||
| 87 | UPDATE_USER | VARCHAR2(512) | SI | ||
| 88 | UPDATE_DATE | DATE | SI | ||
| 89 | IDMAESTROCARGUE | NUMBER(18,0) | NO |
Restricciones
CHECK: SYS_C0069794
- Estado: ENABLED
- Columnas: ID
- Condición:
"ID" IS NOT NULL
CHECK: SYS_C0069795
- Estado: ENABLED
- Columnas: SHIPMENT_GID
- Condición:
"SHIPMENT_GID" IS NOT NULL
CHECK: SYS_C0069796
- Estado: ENABLED
- Columnas: SHIPMENT_XID
- Condición:
"SHIPMENT_XID" IS NOT NULL
CHECK: SYS_C0069797
- Estado: ENABLED
- Columnas: IS_TEMPLATE
- Condición:
"IS_TEMPLATE" IS NOT NULL
CHECK: SYS_C0069798
- Estado: ENABLED
- Columnas: SHIP_START_TIME
- Condición:
"SHIP_START_TIME" IS NOT NULL
CHECK: SYS_C0069799
- Estado: ENABLED
- Columnas: SHIP_END_TIME
- Condición:
"SHIP_END_TIME" IS NOT NULL
CHECK: SYS_C0069800
- Estado: ENABLED
- Columnas: IS_AUTO_MERGE_CONSOLIDATE
- Condición:
"IS_AUTO_MERGE_CONSOLIDATE" IS NOT NULL
CHECK: SYS_C0069801
- Estado: ENABLED
- Columnas: PERSPECTIVE
- Condición:
"PERSPECTIVE" IS NOT NULL
CHECK: SYS_C0069802
- Estado: ENABLED
- Columnas: TOTAL_WEIGHT
- Condición:
"TOTAL_WEIGHT" IS NOT NULL
CHECK: SYS_C0069803
- Estado: ENABLED
- Columnas: TOTAL_WEIGHT_UOM_CODE
- Condición:
"TOTAL_WEIGHT_UOM_CODE" IS NOT NULL
CHECK: SYS_C0069804
- Estado: ENABLED
- Columnas: TOTAL_WEIGHT_BASE
- Condición:
"TOTAL_WEIGHT_BASE" IS NOT NULL
CHECK: SYS_C0069805
- Estado: ENABLED
- Columnas: TOTAL_VOLUME
- Condición:
"TOTAL_VOLUME" IS NOT NULL
CHECK: SYS_C0069806
- Estado: ENABLED
- Columnas: TOTAL_VOLUME_UOM_CODE
- Condición:
"TOTAL_VOLUME_UOM_CODE" IS NOT NULL
CHECK: SYS_C0069807
- Estado: ENABLED
- Columnas: TOTAL_VOLUME_BASE
- Condición:
"TOTAL_VOLUME_BASE" IS NOT NULL
CHECK: SYS_C0069808
- Estado: ENABLED
- Columnas: SHIPMENT_AS_WORK
- Condición:
"SHIPMENT_AS_WORK" IS NOT NULL
CHECK: SYS_C0069809
- Estado: ENABLED
- Columnas: CHECK_TIME_CONSTRAINT
- Condición:
"CHECK_TIME_CONSTRAINT" IS NOT NULL
CHECK: SYS_C0069810
- Estado: ENABLED
- Columnas: CHECK_COST_CONSTRAINT
- Condición:
"CHECK_COST_CONSTRAINT" IS NOT NULL
CHECK: SYS_C0069811
- Estado: ENABLED
- Columnas: CHECK_CAPACITY_CONSTRAINT
- Condición:
"CHECK_CAPACITY_CONSTRAINT" IS NOT NULL
CHECK: SYS_C0069812
- Estado: ENABLED
- Columnas: WEIGH_CODE
- Condición:
"WEIGH_CODE" IS NOT NULL
CHECK: SYS_C0069813
- Estado: ENABLED
- Columnas: RULE_7
- Condición:
"RULE_7" IS NOT NULL
CHECK: SYS_C0069814
- Estado: ENABLED
- Columnas: SHIPMENT_RELEASED
- Condición:
"SHIPMENT_RELEASED" IS NOT NULL
CHECK: SYS_C0069815
- Estado: ENABLED
- Columnas: S_SHIP_UNIT_GID
- Condición:
"S_SHIP_UNIT_GID" IS NOT NULL
CHECK: SYS_C0069816
- Estado: ENABLED
- Columnas: S_SHIP_UNIT_XID
- Condición:
"S_SHIP_UNIT_XID" IS NOT NULL
CHECK: SYS_C0069817
- Estado: ENABLED
- Columnas: IS_SPLITABLE
- Condición:
"IS_SPLITABLE" IS NOT NULL
CHECK: SYS_C0069818
- Estado: ENABLED
- Columnas: SHIP_UNIT_COUNT
- Condición:
"SHIP_UNIT_COUNT" IS NOT NULL
CHECK: SYS_C0069819
- Estado: ENABLED
- Columnas: S_SHIP_UNIT_LINE_NO
- Condición:
"S_SHIP_UNIT_LINE_NO" IS NOT NULL
CHECK: SYS_C0069820
- Estado: ENABLED
- Columnas: ITEM_WEIGHT_UOM_CODE
- Condición:
"ITEM_WEIGHT_UOM_CODE" IS NOT NULL
CHECK: SYS_C0069821
- Estado: ENABLED
- Columnas: ITEM_GID
- Condición:
"ITEM_GID" IS NOT NULL
CHECK: SYS_C0069822
- Estado: ENABLED
- Columnas: ITEM_XID
- Condición:
"ITEM_XID" IS NOT NULL
CHECK: SYS_C0069823
- Estado: ENABLED
- Columnas: PACKAGED_ITEM_GID
- Condición:
"PACKAGED_ITEM_GID" IS NOT NULL
CHECK: SYS_C0069824
- Estado: ENABLED
- Columnas: DOMAIN_NAME
- Condición:
"DOMAIN_NAME" IS NOT NULL
CHECK: SYS_C0069825
- Estado: ENABLED
- Columnas: INSERT_DATE
- Condición:
"INSERT_DATE" IS NOT NULL
CHECK: SYS_C0069826
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
-- Error obteniendo DDL completo: ORA-01745: invalid host/bind variable name