[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | WSH_CARRIERS |
|---|---|
| Object Type: | TABLE |
| Owner: | WSH |
| FND Design Data: |  WSH.WSH_CARRIERS
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| WSH_CARRIERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CARRIER_ID
|
| WSH_CARRIERS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
FREIGHT_CODE
|
| WSH_CARRIERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SUPPLIER_SITE_ID
SUPPLIER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CARRIER_ID | NUMBER | Yes | ||
| FREIGHT_CODE | VARCHAR2 | (30) | Yes | |
| SCAC_CODE | VARCHAR2 | (4) | ||
| MANIFESTING_ENABLED_FLAG | VARCHAR2 | (1) | ||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | (38) | ||
| GENERIC_FLAG | VARCHAR2 | (1) | Denotes Generic Carrier | |
| FREIGHT_BILL_AUTO_APPROVAL | VARCHAR2 | (1) | Auto-approves freight bill | |
| FREIGHT_AUDIT_LINE_LEVEL | VARCHAR2 | (1) | Audit Freight Bills at delivery line level | |
| SUPPLIER_ID | NUMBER | Foreign key to PO_VENDORS | ||
| SUPPLIER_SITE_ID | NUMBER | Foreign key to PO_VENDOR_SITES | ||
| MAX_NUM_STOPS_PERMITTED | NUMBER | Maximum number of stops permitted by Carrier | ||
| MAX_TOTAL_DISTANCE | NUMBER | Maximum miles allowed per Truck Load | ||
| MAX_TOTAL_TIME | NUMBER | Maximum total time allowed per Truck Load | ||
| ALLOW_INTERSPERSE_LOAD | VARCHAR2 | (1) | Does Carrier allow interspersing of pickups and dropoffs | |
| MIN_LAYOVER_TIME | NUMBER | Minimum layover time | ||
| MAX_LAYOVER_TIME | NUMBER | Maximum layover time. Beyond that it will be considered as an additional layover | ||
| MAX_TOTAL_DISTANCE_IN_24HR | NUMBER | Maximum total distance per day | ||
| MAX_DRIVING_TIME_IN_24HR | NUMBER | Maximum driving time per day | ||
| MAX_DUTY_TIME_IN_24HR | NUMBER | Maximum duty time per day | ||
| ALLOW_CONTINUOUS_MOVE | VARCHAR2 | (1) | Does the Carrier allow continuous move | |
| MAX_CM_DISTANCE | NUMBER | Maximum mileage for continuous move | ||
| MAX_CM_TIME | NUMBER | Maximum time for continous move | ||
| MAX_CM_DH_DISTANCE | NUMBER | Maximum deadhead distance allowed in continuous move | ||
| MAX_CM_DH_TIME | NUMBER | Maximum deadhead time allowed in continuous move | ||
| MIN_CM_DISTANCE | NUMBER | Minimum mileage in continuous move. If CM distance is less than this then CM discount is not applied | ||
| MIN_CM_TIME | NUMBER | Minimum time for continuous move | ||
| CM_FREE_DH_MILEAGE | NUMBER | In Continuous Move, Free Dead head Mileage. Default 0 | ||
| CM_FIRST_LOAD_DISCOUNT | VARCHAR2 | (1) | First load discount during the Continuous Move or not. | |
| CM_RATE_VARIANT | VARCHAR2 | (30) | Continuous Move Rating Method: Rate or Discount. By default Discount | |
| MAX_SIZE_WIDTH | NUMBER | Maximum width of parcel | ||
| MAX_SIZE_HEIGHT | NUMBER | Maximum height of parcel | ||
| MAX_SIZE_LENGTH | NUMBER | Maximum length of parcel | ||
| MIN_SIZE_WIDTH | NUMBER | Minimum width of parcel | ||
| MIN_SIZE_HEIGHT | NUMBER | Minimum height of parcel | ||
| MIN_SIZE_LENGTH | NUMBER | Minimum length of parcel | ||
| TIME_UOM | VARCHAR2 | (10) | Time unit of measure | |
| DIMENSION_UOM | VARCHAR2 | (3) | Dimension unit of measure | |
| DISTANCE_UOM | VARCHAR2 | (3) | Distance unit of measure | |
| WEIGHT_UOM | VARCHAR2 | (3) | Weight unit of measure | |
| VOLUME_UOM | VARCHAR2 | (3) | Volume unit of measure | |
| MAX_OUT_OF_ROUTE | NUMBER | If trip travel distance is longer than the expected distance, then this indicates maximum percentage above expected distance after which extra charge will be applied | ||
| DISTANCE_CALCULATION_METHOD | VARCHAR2 | (30) | Direct Route or full route. By default it is Full Route. | |
| ORIGIN_DSTN_SURCHARGE_LEVEL | VARCHAR2 | (30) | This field specifies the surcharge level like zip code, city, state or country | |
| UNIT_RATE_BASIS | VARCHAR2 | (30) | Unit Rate Basis - weight, volume, container or pallete | |
| DIM_DIMENSIONAL_FACTOR | NUMBER | Shipment / container volume is divided by this factor to obtain the DIM weight calculation. | ||
| DIM_WEIGHT_UOM | VARCHAR2 | (3) | DIM Weight calculation resulting Weight UOM. | |
| DIM_VOLUME_UOM | VARCHAR2 | (3) | Volume UOM on which the DIM weight calculation applies. | |
| DIM_DIMENSION_UOM | VARCHAR2 | (3) | Dimension UOM to be used to calculate package's volume. | |
| DIM_MIN_PACK_VOL | NUMBER | Minimum package volume above which DIM weight applies. |
Cut, paste (and edit) the following text to query this object:
SELECT CARRIER_ID
, FREIGHT_CODE
, SCAC_CODE
, MANIFESTING_ENABLED_FLAG
, CURRENCY_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, GENERIC_FLAG
, FREIGHT_BILL_AUTO_APPROVAL
, FREIGHT_AUDIT_LINE_LEVEL
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, MAX_NUM_STOPS_PERMITTED
, MAX_TOTAL_DISTANCE
, MAX_TOTAL_TIME
, ALLOW_INTERSPERSE_LOAD
, MIN_LAYOVER_TIME
, MAX_LAYOVER_TIME
, MAX_TOTAL_DISTANCE_IN_24HR
, MAX_DRIVING_TIME_IN_24HR
, MAX_DUTY_TIME_IN_24HR
, ALLOW_CONTINUOUS_MOVE
, MAX_CM_DISTANCE
, MAX_CM_TIME
, MAX_CM_DH_DISTANCE
, MAX_CM_DH_TIME
, MIN_CM_DISTANCE
, MIN_CM_TIME
, CM_FREE_DH_MILEAGE
, CM_FIRST_LOAD_DISCOUNT
, CM_RATE_VARIANT
, MAX_SIZE_WIDTH
, MAX_SIZE_HEIGHT
, MAX_SIZE_LENGTH
, MIN_SIZE_WIDTH
, MIN_SIZE_HEIGHT
, MIN_SIZE_LENGTH
, TIME_UOM
, DIMENSION_UOM
, DISTANCE_UOM
, WEIGHT_UOM
, VOLUME_UOM
, MAX_OUT_OF_ROUTE
, DISTANCE_CALCULATION_METHOD
, ORIGIN_DSTN_SURCHARGE_LEVEL
, UNIT_RATE_BASIS
, DIM_DIMENSIONAL_FACTOR
, DIM_WEIGHT_UOM
, DIM_VOLUME_UOM
, DIM_DIMENSION_UOM
, DIM_MIN_PACK_VOL
FROM WSH.WSH_CARRIERS;
WSH.WSH_CARRIERS does not reference any database object
WSH.WSH_CARRIERS is referenced by following:
WSH
WSH_CARRIERS#
|
|
|
|