VIEW: WSH.WSH_CARRIERS#

Source

View Text - Preformatted

select CARRIER_ID CARRIER_ID, FREIGHT_CODE FREIGHT_CODE, SCAC_CODE SCAC_CODE, MANIFESTING_ENABLED_FLAG MANIFESTING_ENABLED_FLAG, CURRENCY_CODE CURRENCY_CODE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, GENERIC_FLAG GENERIC_FLAG, FREIGHT_BILL_AUTO_APPROVAL FREIGHT_BILL_AUTO_APPROVAL, FREIGHT_AUDIT_LINE_LEVEL FREIGHT_AUDIT_LINE_LEVEL, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, MAX_NUM_STOPS_PERMITTED MAX_NUM_STOPS_PERMITTED, MAX_TOTAL_DISTANCE MAX_TOTAL_DISTANCE, MAX_TOTAL_TIME MAX_TOTAL_TIME, ALLOW_INTERSPERSE_LOAD ALLOW_INTERSPERSE_LOAD, MIN_LAYOVER_TIME MIN_LAYOVER_TIME, MAX_LAYOVER_TIME MAX_LAYOVER_TIME, MAX_TOTAL_DISTANCE_IN_24HR MAX_TOTAL_DISTANCE_IN_24HR, MAX_DRIVING_TIME_IN_24HR MAX_DRIVING_TIME_IN_24HR, MAX_DUTY_TIME_IN_24HR MAX_DUTY_TIME_IN_24HR, ALLOW_CONTINUOUS_MOVE ALLOW_CONTINUOUS_MOVE, MAX_CM_DISTANCE MAX_CM_DISTANCE, MAX_CM_TIME MAX_CM_TIME, MAX_CM_DH_DISTANCE MAX_CM_DH_DISTANCE, MAX_CM_DH_TIME MAX_CM_DH_TIME, MIN_CM_DISTANCE MIN_CM_DISTANCE, MIN_CM_TIME MIN_CM_TIME, CM_FREE_DH_MILEAGE CM_FREE_DH_MILEAGE, CM_FIRST_LOAD_DISCOUNT CM_FIRST_LOAD_DISCOUNT, CM_RATE_VARIANT CM_RATE_VARIANT, MAX_SIZE_WIDTH MAX_SIZE_WIDTH, MAX_SIZE_HEIGHT MAX_SIZE_HEIGHT, MAX_SIZE_LENGTH MAX_SIZE_LENGTH, MIN_SIZE_WIDTH MIN_SIZE_WIDTH, MIN_SIZE_HEIGHT MIN_SIZE_HEIGHT, MIN_SIZE_LENGTH MIN_SIZE_LENGTH, TIME_UOM TIME_UOM, DIMENSION_UOM DIMENSION_UOM, DISTANCE_UOM DISTANCE_UOM, WEIGHT_UOM WEIGHT_UOM, VOLUME_UOM VOLUME_UOM, MAX_OUT_OF_ROUTE MAX_OUT_OF_ROUTE, DISTANCE_CALCULATION_METHOD DISTANCE_CALCULATION_METHOD, ORIGIN_DSTN_SURCHARGE_LEVEL ORIGIN_DSTN_SURCHARGE_LEVEL, UNIT_RATE_BASIS UNIT_RATE_BASIS, DIM_DIMENSIONAL_FACTOR DIM_DIMENSIONAL_FACTOR, DIM_WEIGHT_UOM DIM_WEIGHT_UOM, DIM_VOLUME_UOM DIM_VOLUME_UOM, DIM_DIMENSION_UOM DIM_DIMENSION_UOM, DIM_MIN_PACK_VOL DIM_MIN_PACK_VOL from "WSH"."WSH_CARRIERS"

View Text - HTML Formatted

SELECT CARRIER_ID CARRIER_ID
, FREIGHT_CODE FREIGHT_CODE
, SCAC_CODE SCAC_CODE
, MANIFESTING_ENABLED_FLAG MANIFESTING_ENABLED_FLAG
, CURRENCY_CODE CURRENCY_CODE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, GENERIC_FLAG GENERIC_FLAG
, FREIGHT_BILL_AUTO_APPROVAL FREIGHT_BILL_AUTO_APPROVAL
, FREIGHT_AUDIT_LINE_LEVEL FREIGHT_AUDIT_LINE_LEVEL
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, MAX_NUM_STOPS_PERMITTED MAX_NUM_STOPS_PERMITTED
, MAX_TOTAL_DISTANCE MAX_TOTAL_DISTANCE
, MAX_TOTAL_TIME MAX_TOTAL_TIME
, ALLOW_INTERSPERSE_LOAD ALLOW_INTERSPERSE_LOAD
, MIN_LAYOVER_TIME MIN_LAYOVER_TIME
, MAX_LAYOVER_TIME MAX_LAYOVER_TIME
, MAX_TOTAL_DISTANCE_IN_24HR MAX_TOTAL_DISTANCE_IN_24HR
, MAX_DRIVING_TIME_IN_24HR MAX_DRIVING_TIME_IN_24HR
, MAX_DUTY_TIME_IN_24HR MAX_DUTY_TIME_IN_24HR
, ALLOW_CONTINUOUS_MOVE ALLOW_CONTINUOUS_MOVE
, MAX_CM_DISTANCE MAX_CM_DISTANCE
, MAX_CM_TIME MAX_CM_TIME
, MAX_CM_DH_DISTANCE MAX_CM_DH_DISTANCE
, MAX_CM_DH_TIME MAX_CM_DH_TIME
, MIN_CM_DISTANCE MIN_CM_DISTANCE
, MIN_CM_TIME MIN_CM_TIME
, CM_FREE_DH_MILEAGE CM_FREE_DH_MILEAGE
, CM_FIRST_LOAD_DISCOUNT CM_FIRST_LOAD_DISCOUNT
, CM_RATE_VARIANT CM_RATE_VARIANT
, MAX_SIZE_WIDTH MAX_SIZE_WIDTH
, MAX_SIZE_HEIGHT MAX_SIZE_HEIGHT
, MAX_SIZE_LENGTH MAX_SIZE_LENGTH
, MIN_SIZE_WIDTH MIN_SIZE_WIDTH
, MIN_SIZE_HEIGHT MIN_SIZE_HEIGHT
, MIN_SIZE_LENGTH MIN_SIZE_LENGTH
, TIME_UOM TIME_UOM
, DIMENSION_UOM DIMENSION_UOM
, DISTANCE_UOM DISTANCE_UOM
, WEIGHT_UOM WEIGHT_UOM
, VOLUME_UOM VOLUME_UOM
, MAX_OUT_OF_ROUTE MAX_OUT_OF_ROUTE
, DISTANCE_CALCULATION_METHOD DISTANCE_CALCULATION_METHOD
, ORIGIN_DSTN_SURCHARGE_LEVEL ORIGIN_DSTN_SURCHARGE_LEVEL
, UNIT_RATE_BASIS UNIT_RATE_BASIS
, DIM_DIMENSIONAL_FACTOR DIM_DIMENSIONAL_FACTOR
, DIM_WEIGHT_UOM DIM_WEIGHT_UOM
, DIM_VOLUME_UOM DIM_VOLUME_UOM
, DIM_DIMENSION_UOM DIM_DIMENSION_UOM
, DIM_MIN_PACK_VOL DIM_MIN_PACK_VOL
FROM "WSH"."WSH_CARRIERS"