Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_ORDERRELEASE_BKP
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | ID | NUMBER | NO | ||
| 2 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 3 | ORDER_RELEASE_XID | VARCHAR2(200) | NO | ||
| 4 | ORDER_RELEASE_NAME | VARCHAR2(480) | SI | ||
| 5 | ORDER_RELEASE_TYPE_GID | VARCHAR2(404) | SI | ||
| 6 | ORDER_RELEASE_GID | VARCHAR2(404) | NO | ||
| 7 | ASSIGNED_ITINERARY_GID | VARCHAR2(404) | SI | ||
| 8 | SOURCE_LOCATION_GID | VARCHAR2(404) | SI | ||
| 9 | DEST_LOCATION_GID | VARCHAR2(404) | SI | ||
| 10 | EARLY_PICKUP_DATE | DATE | SI | ||
| 11 | TOTAL_ITEM_PACKAGE_COUNT | NUMBER | SI | ||
| 12 | INDICATOR | VARCHAR2(4) | SI | ||
| 13 | TOTAL_NET_WEIGHT | NUMBER | SI | ||
| 14 | TOTAL_NET_WEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 15 | TOTAL_NET_WEIGHT_BASE | NUMBER | SI | ||
| 16 | TOTAL_NET_VOLUME | NUMBER | SI | ||
| 17 | TOTAL_NET_VOLUME_UOM_CODE | VARCHAR2(256) | SI | ||
| 18 | TOTAL_NET_VOLUME_BASE | NUMBER | SI | ||
| 19 | PICKUP_IS_APPT | VARCHAR2(4) | NO | ||
| 20 | DELIVERY_IS_APPT | VARCHAR2(4) | NO | ||
| 21 | IS_KNOWN_SHIPPER | VARCHAR2(4) | NO | ||
| 22 | RELEASE_METHOD_GID | VARCHAR2(404) | SI | ||
| 23 | LOC_AMOUNT | NUMBER | NO | ||
| 24 | LOC_AMOUNT_CURRENCY_GID | VARCHAR2(404) | NO | ||
| 25 | LOC_AMOUNT_BASE | NUMBER | NO | ||
| 26 | SECONDARY_T_WEIGHT | NUMBER | SI | ||
| 27 | SECONDARY_T_WEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 28 | SECONDARY_T_WEIGHT_BASE | NUMBER | SI | ||
| 29 | SECONDARY_T_VOLUME | NUMBER | SI | ||
| 30 | SECONDARY_T_VOLUME_UOM_CODE | VARCHAR2(256) | SI | ||
| 31 | SECONDARY_T_VOLUME_BASE | NUMBER | SI | ||
| 32 | MUST_SHIP_DIRECT | VARCHAR2(4) | NO | ||
| 33 | MUST_SHIP_THRU_X_DOCK | VARCHAR2(4) | NO | ||
| 34 | MUST_SHIP_THRU_POOL | VARCHAR2(4) | NO | ||
| 35 | IMPORT_LICENSE_REQUIRED | VARCHAR2(200) | SI | ||
| 36 | IS_LOC_REQUIRED | VARCHAR2(4) | NO | ||
| 37 | INSPECTION_REQUIRED | VARCHAR2(200) | SI | ||
| 38 | CUSTOMER_UNITIZATION_REQUEST | VARCHAR2(4) | NO | ||
| 39 | IS_LOC_STALE | VARCHAR2(4) | NO | ||
| 40 | BUNDLING_TYPE | VARCHAR2(200) | NO | ||
| 41 | IS_CONSOLIDATE_OR_EQUIPMENT | VARCHAR2(4) | NO | ||
| 42 | DUTY_PAID | VARCHAR2(32) | NO | ||
| 43 | TOTAL_DECLARED_VALUE | NUMBER | SI | ||
| 44 | TOTAL_DECLARED_VALUE_GID | VARCHAR2(404) | SI | ||
| 45 | TOTAL_DECLARED_VALUE_BASE | NUMBER | SI | ||
| 46 | BULK_PLAN_GID | VARCHAR2(404) | SI | ||
| 47 | TOTAL_SHIP_UNIT_COUNT | NUMBER | SI | ||
| 48 | TOTAL_WEIGHT | NUMBER | SI | ||
| 49 | TOTAL_WEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 50 | TOTAL_WEIGHT_BASE | NUMBER | SI | ||
| 51 | TOTAL_VOLUME | NUMBER | SI | ||
| 52 | TOTAL_VOLUME_UOM_CODE | VARCHAR2(256) | SI | ||
| 53 | ON_RT_EXECUTION | VARCHAR2(4) | NO | ||
| 54 | IS_SPLITTABLE | VARCHAR2(4) | SI | ||
| 55 | OTM_VERSION | VARCHAR2(60) | SI | ||
| 56 | TOTAL_VOLUME_BASE | NUMBER | SI | ||
| 57 | MARKED_FOR_PURGE | VARCHAR2(4) | NO | ||
| 58 | IS_PRE_ENTERED_PU | VARCHAR2(4) | NO | ||
| 59 | IS_TOPOFF | VARCHAR2(4) | NO | ||
| 60 | SHIP_UNIT_WIDTH | NUMBER | SI | ||
| 61 | SHIP_UNIT_WIDTH_UOM_CODE | VARCHAR2(256) | SI | ||
| 62 | SHIP_UNIT_WIDTH_BASE | NUMBER | SI | ||
| 63 | SHIP_UNIT_LENGTH | NUMBER | SI | ||
| 64 | SHIP_UNIT_LENGTH_UOM_CODE | VARCHAR2(256) | SI | ||
| 65 | SHIP_UNIT_LENGTH_BASE | NUMBER | SI | ||
| 66 | SHIP_UNIT_HEIGHT | NUMBER | SI | ||
| 67 | SHIP_UNIT_HEIGHT_UOM_CODE | VARCHAR2(256) | SI | ||
| 68 | SHIP_UNIT_HEIGHT_BASE | NUMBER | SI | ||
| 69 | PRIORITY | NUMBER | NO | ||
| 70 | IS_TEMPLATE | VARCHAR2(4) | NO | ||
| 71 | DOMAIN_NAME | VARCHAR2(200) | NO | ||
| 72 | INSERT_USER | VARCHAR2(512) | NO | ||
| 73 | INSERT_DATE | DATE | NO | ||
| 74 | UPDATE_USER | VARCHAR2(512) | SI | ||
| 75 | UPDATE_DATE | DATE | SI |
Restricciones
CHECK: SYS_C0053862
- Estado: ENABLED
- Columnas: ID
- Condición:
"ID" IS NOT NULL
CHECK: SYS_C0053863
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
CHECK: SYS_C0053864
- Estado: ENABLED
- Columnas: ORDER_RELEASE_XID
- Condición:
"ORDER_RELEASE_XID" IS NOT NULL
CHECK: SYS_C0053865
- Estado: ENABLED
- Columnas: ORDER_RELEASE_GID
- Condición:
"ORDER_RELEASE_GID" IS NOT NULL
CHECK: SYS_C0053866
- Estado: ENABLED
- Columnas: PICKUP_IS_APPT
- Condición:
"PICKUP_IS_APPT" IS NOT NULL
CHECK: SYS_C0053867
- Estado: ENABLED
- Columnas: DELIVERY_IS_APPT
- Condición:
"DELIVERY_IS_APPT" IS NOT NULL
CHECK: SYS_C0053868
- Estado: ENABLED
- Columnas: IS_KNOWN_SHIPPER
- Condición:
"IS_KNOWN_SHIPPER" IS NOT NULL
CHECK: SYS_C0053869
- Estado: ENABLED
- Columnas: LOC_AMOUNT
- Condición:
"LOC_AMOUNT" IS NOT NULL
CHECK: SYS_C0053870
- Estado: ENABLED
- Columnas: LOC_AMOUNT_CURRENCY_GID
- Condición:
"LOC_AMOUNT_CURRENCY_GID" IS NOT NULL
CHECK: SYS_C0053871
- Estado: ENABLED
- Columnas: LOC_AMOUNT_BASE
- Condición:
"LOC_AMOUNT_BASE" IS NOT NULL
CHECK: SYS_C0053872
- Estado: ENABLED
- Columnas: MUST_SHIP_DIRECT
- Condición:
"MUST_SHIP_DIRECT" IS NOT NULL
CHECK: SYS_C0053873
- Estado: ENABLED
- Columnas: MUST_SHIP_THRU_X_DOCK
- Condición:
"MUST_SHIP_THRU_X_DOCK" IS NOT NULL
CHECK: SYS_C0053874
- Estado: ENABLED
- Columnas: MUST_SHIP_THRU_POOL
- Condición:
"MUST_SHIP_THRU_POOL" IS NOT NULL
CHECK: SYS_C0053875
- Estado: ENABLED
- Columnas: IS_LOC_REQUIRED
- Condición:
"IS_LOC_REQUIRED" IS NOT NULL
CHECK: SYS_C0053876
- Estado: ENABLED
- Columnas: CUSTOMER_UNITIZATION_REQUEST
- Condición:
"CUSTOMER_UNITIZATION_REQUEST" IS NOT NULL
CHECK: SYS_C0053877
- Estado: ENABLED
- Columnas: IS_LOC_STALE
- Condición:
"IS_LOC_STALE" IS NOT NULL
CHECK: SYS_C0053878
- Estado: ENABLED
- Columnas: BUNDLING_TYPE
- Condición:
"BUNDLING_TYPE" IS NOT NULL
CHECK: SYS_C0053879
- Estado: ENABLED
- Columnas: IS_CONSOLIDATE_OR_EQUIPMENT
- Condición:
"IS_CONSOLIDATE_OR_EQUIPMENT" IS NOT NULL
CHECK: SYS_C0053880
- Estado: ENABLED
- Columnas: DUTY_PAID
- Condición:
"DUTY_PAID" IS NOT NULL
CHECK: SYS_C0053881
- Estado: ENABLED
- Columnas: ON_RT_EXECUTION
- Condición:
"ON_RT_EXECUTION" IS NOT NULL
CHECK: SYS_C0053882
- Estado: ENABLED
- Columnas: MARKED_FOR_PURGE
- Condición:
"MARKED_FOR_PURGE" IS NOT NULL
CHECK: SYS_C0053883
- Estado: ENABLED
- Columnas: IS_PRE_ENTERED_PU
- Condición:
"IS_PRE_ENTERED_PU" IS NOT NULL
CHECK: SYS_C0053884
- Estado: ENABLED
- Columnas: IS_TOPOFF
- Condición:
"IS_TOPOFF" IS NOT NULL
CHECK: SYS_C0053885
- Estado: ENABLED
- Columnas: PRIORITY
- Condición:
"PRIORITY" IS NOT NULL
CHECK: SYS_C0053886
- Estado: ENABLED
- Columnas: IS_TEMPLATE
- Condición:
"IS_TEMPLATE" IS NOT NULL
CHECK: SYS_C0053887
- Estado: ENABLED
- Columnas: DOMAIN_NAME
- Condición:
"DOMAIN_NAME" IS NOT NULL
CHECK: SYS_C0053888
- Estado: ENABLED
- Columnas: INSERT_USER
- Condición:
"INSERT_USER" IS NOT NULL
CHECK: SYS_C0053889
- Estado: ENABLED
- Columnas: INSERT_DATE
- Condición:
"INSERT_DATE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_ORDERRELEASE_BKP"
( "ID" NUMBER(*,0) NOT NULL ENABLE,
"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE,
"ORDER_RELEASE_XID" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"ORDER_RELEASE_NAME" VARCHAR2(480) COLLATE "USING_NLS_COMP",
"ORDER_RELEASE_TYPE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP",
"ORDER_RELEASE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"ASSIGNED_ITINERARY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP",
"SOURCE_LOCATION_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP",
"DEST_LOCATION_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP",
"EARLY_PICKUP_DATE" DATE,
"TOTAL_ITEM_PACKAGE_COUNT" NUMBER,
"INDICATOR" VARCHAR2(4) COLLATE "USING_NLS_COMP",
"TOTAL_NET_WEIGHT" NUMBER,
"TOTAL_NET_WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP",
"TOTAL_NET_WEIGHT_BASE" NUMBER,
"TOTAL_NET_VOLUME" NUMBER,
"TOTAL_NET_VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP",
"TOTAL_NET_VOLUME_BASE" NUMBER,
"PICKUP_IS_APPT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"DELIVERY_IS_APPT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"IS_KNOWN_SHIPPER" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"RELEASE_METHOD_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP",
"LOC_AMOUNT" NUMBER NOT NULL ENABLE,
"LOC_AMOUNT_CURRENCY_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"LOC_AMOUNT_BASE" NUMBER NOT NULL ENABLE,
"SECONDARY_T_WEIGHT" NUMBER,
"SECONDARY_T_WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP",
"SECONDARY_T_WEIGHT_BASE" NUMBER,
"SECONDARY_T_VOLUME" NUMBER,
"SECONDARY_T_VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP",
"SECONDARY_T_VOLUME_BASE" NUMBER,
"MUST_SHIP_DIRECT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"MUST_SHIP_THRU_X_DOCK" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"MUST_SHIP_THRU_POOL" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"IMPORT_LICENSE_REQUIRED" VARCHAR2(200) COLLATE "USING_NLS_COMP",
"IS_LOC_REQUIRED" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"INSPECTION_REQUIRED" VARCHAR2(200) COLLATE "USING_NLS_COMP",
"CUSTOMER_UNITIZATION_REQUEST" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"IS_LOC_STALE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"BUNDLING_TYPE" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"IS_CONSOLIDATE_OR_EQUIPMENT" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"DUTY_PAID" VARCHAR2(32) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"TOTAL_DECLARED_VALUE" NUMBER,
"TOTAL_DECLARED_VALUE_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP",
"TOTAL_DECLARED_VALUE_BASE" NUMBER,
"BULK_PLAN_GID" VARCHAR2(404) COLLATE "USING_NLS_COMP",
"TOTAL_SHIP_UNIT_COUNT" NUMBER,
"TOTAL_WEIGHT" NUMBER,
"TOTAL_WEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP",
"TOTAL_WEIGHT_BASE" NUMBER,
"TOTAL_VOLUME" NUMBER,
"TOTAL_VOLUME_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP",
"ON_RT_EXECUTION" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"IS_SPLITTABLE" VARCHAR2(4) COLLATE "USING_NLS_COMP",
"OTM_VERSION" VARCHAR2(60) COLLATE "USING_NLS_COMP",
"TOTAL_VOLUME_BASE" NUMBER,
"MARKED_FOR_PURGE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"IS_PRE_ENTERED_PU" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"IS_TOPOFF" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"SHIP_UNIT_WIDTH" NUMBER,
"SHIP_UNIT_WIDTH_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP",
"SHIP_UNIT_WIDTH_BASE" NUMBER,
"SHIP_UNIT_LENGTH" NUMBER,
"SHIP_UNIT_LENGTH_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP",
"SHIP_UNIT_LENGTH_BASE" NUMBER,
"SHIP_UNIT_HEIGHT" NUMBER,
"SHIP_UNIT_HEIGHT_UOM_CODE" VARCHAR2(256) COLLATE "USING_NLS_COMP",
"SHIP_UNIT_HEIGHT_BASE" NUMBER,
"PRIORITY" NUMBER NOT NULL ENABLE,
"IS_TEMPLATE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"DOMAIN_NAME" VARCHAR2(200) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"INSERT_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"INSERT_DATE" DATE NOT NULL ENABLE,
"UPDATE_USER" VARCHAR2(512) COLLATE "USING_NLS_COMP",
"UPDATE_DATE" DATE
) DEFAULT COLLATION "USING_NLS_COMP" ;
GRANT ALTER ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT DELETE ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT INDEX ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT INSERT ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT SELECT ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT UPDATE ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT REFERENCES ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT READ ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT ON COMMIT REFRESH ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT QUERY REWRITE ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT DEBUG ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT FLASHBACK ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";
GRANT ASSERTION REFERENCES ON "STADW"."ST_ORDERRELEASE_BKP" TO "BICC";