Get Rate Offerings
get
/rateOfferings
Request
Query Parameters
-
expand: string
Comma-delimited string of child resource names that you want to expand so that the contents return with the parent in the same GET request.
-
fields: string
Comma-delimited string of field names that you wanted returned in a GET request.
-
limit: integer(int32)
Positive integer value that specifies the maximum number of items returned by the server.
-
offset: integer(int32)
Non-negative integer values that specifies the index of the first item to be returned. The offset index begins at 0. By default, the offset is 0, which returns all items starting from the first item in the collection.
-
orderBy: string
Comma-separated string of field names, each optionally followed by asc or desc, that specifies the order of items returned in the response payload.
-
q: string
Filter (a 'where'clause) to restrict the items returned in the collection. By default, no filtering is applied.
-
totalResults: boolean
Boolean value that specifies whether to calculate the totalResults property. By default, this value is set to false indicating that totalResults is not calculated.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/vnd.oracle.resource+json;type=collection
Default Response
Default Response.
Nested Schema : rateOfferings
Type:
Show Source
object
-
absoluteCostDf:
absoluteCostDf
Absolute cost for digital freight rates.
-
accessorials:
accessorials
-
allowUncostedLineItems: boolean
Allow Uncosted Line Items (Y/N) is used when there are one or more ratable objects on the shipment which are not charged or considered for rating when rating a shipment using rate record.
Marked: Some basis options within a shipment pass through the rating engine without a charge if other basis options qualify. For example, if a shipment contains four line items, and a rate is found that contains charges for 3 of those items, that rate qualifies for the shipment and the fourth line item ships for free. -
attribute1: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute10: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute11: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute12: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute13: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute14: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute15: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute16: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute17: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute18: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute19: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute2: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute20: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute3: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute4: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute5: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute6: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute7: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute8: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attribute9: string
Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
-
attributeDate1:
attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeDate10:
attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeDate2:
attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeDate3:
attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeDate4:
attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeDate5:
attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeDate6:
attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeDate7:
attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeDate8:
attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeDate9:
attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
-
attributeNumber1: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
attributeNumber10: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
attributeNumber2: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
attributeNumber3: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
attributeNumber4: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
attributeNumber5: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
attributeNumber6: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
attributeNumber7: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
attributeNumber8: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
attributeNumber9: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
calcChargeableWtVolWith: string
This field provides different options for calculating the shipments total weight and volume. "Shipment Total Dimensional Weight/Volume", the chargeable weight/volume will be calculated based on the Shipment Total Dimensional Weight/Volume. "Sum of Individual Ship Unit Dimensional Weight/Volume", the chargeable weight/volume will be calculated based on the Sum of Individual Ship Unit Dimensional Weight/Volume.
-
capacityGroupGid: string
The GID for the capacity group.
-
circuityAllowancePercent: number
(double)
Circuity Allowance Percent indicates the allowed amount of out of route distance (as a percent of the direct source to final destination distance) that is free/ before Circuitous Distance Cost are charged.
Circuity Allowance Percent = (t/d-1)*100 where:
t is the allowed total distance traveled between the first and last stop of the shipment.
d is the shortest distance between the first and last stop of the shipment.
If the allowed total distance is 1500 miles and the distance between the first and last stop is 1300 miles, Circuity Allowance Percent = (1500/1300-1)*100 = (1.15-1)*100 = 15%. The lower the percentage, the more in line the route must be. -
circuityDistanceCost:
circuityDistanceCost
Circuity Distance Cost is the per distance unit charge for each unit over the included/free amount.
-
cmIsPercentOfDistance: boolean
Indicates whether the percent of the total loaded distance is used to allocate the empty leg cost.
-
cmIsSameEquip: boolean
Indicates whether the shipments in the continuous move tour are restricted to utilize the same equipment type.
-
cmMaxNumShipments: number
(int32)
The maximum shipments in a continuous move tour.
-
cmPrevShipmentPercent: number
(double)
The percentage of the empty leg cost allocated to previous shipment.
-
cofcTofc: string
Container-On-Flat-Car Trailer-On-Flat-Car code used along with the Rail Inter Modal Plan to determine the rate.
-
comments:
comments
-
commodityUsage: string
Indicates if the rate offering is or is not a commodity based rate offering i.e., are rates based on the classification of the freight. Values (F/C).
-
continuousMoveEndingExclusionRegions:
continuousMoveEndingExclusionRegions
-
continuousMoveRules:
continuousMoveRules
-
corporationProfileGid: string
The GID for the corporation profile.
-
currencyGid: string
The GID for the currency.
-
customerRateCode: string
This code signifies what rate is used on a leg; either 'C' for the Customer's rate, or 'S' for the Shipper's rate.
-
deficitCalculationsType: string
When to apply deficit calculations. Values are Y/N/P where Y = Yes, N = No and P = Payant Pour
-
deliveryStopsConstraint: number
(int32)
For rate offerings where the service provider will provide multi-stop coverage, the total delivery stops constraints sets a constraint on the total number of delivery stops that the rate can be used for.
-
dimRateFactorGid: string
The GID for the DIM rate factor.
-
distanceUomCode: string
The unit of measure for distance.
-
documents:
documents
-
domainName: string
Database domain where this data is stored.
-
domainProfileGid: string
Providing a domain profile allows for the rate offering to be constrained to the domains in the domain profile and serves as a constraint on the rate offering.
If none of the rate offerings have a customer domain profile constraint, then all rate offerings are returned.
If some of the rate offerings have customer domain profiles, the rate offerings are grouped by service provider. For each service provider, only the offerings whose domain profile constraint is satisfied are returned. So, given two rate offerings, one with a constraint, and one without a constraint: if the order release domain list is compatible with the constraint, only the rate offering with the constraint is returned, otherwise, only the offering without the constraint is returned. -
equipmentGroupProfileGid: string
The GID for the equipment group profile.
-
exchangeRateGid: string
The GID for the exchange rate.
-
expireMarkId: string
Indicates that the rate has been marked for expiration.
-
externalRatingEngineGid: string
The GID for the external rating engine.
-
extReFieldsetGid: string
Specifies the external rating engine fieldset to be used when invoking an external rating engine using our generic interface.
-
fakFlexCommodityValue: string
Freight all kinds rate as commodity value.
-
fakRateAs: string
Freight all kinds rate as commodity. Values (Y/N).
-
fallbackRateServiceGid: string
The fall back rate service will be used for driving the shipment if the regular rate service is unable to drive the shipment. For example, you may typically have voyage information for two months into the future. However, sometimes a possible order will come in for three months into the future. This works for all rate inquiry types. For example, this will enable you to run rate inquiry Network Rate and Route for this order information, using the same itineraries and rates, and get answers for rate and route even though you do not have voyage information that far in the future. The parameter FALLBACK RS NUM OF DAYS determines how many days into the future to allow use of the fallback rate offering.
-
flexCommodityProfileGid: string
The GID for the flex commodity profile.
-
hazardousRateType: string
N - Applies to shipments with no hazardous items, H - Applies only to shipments with hazardous items, A - Applies to hazardous and non-hazardous shipments.
-
insertDate:
insertDate
Read Only:
true
insert date -
involvedParties:
involvedParties
-
isActive: boolean
Indicates if the rate offering is active (Y) or inactive (N). If inactive (N) the rate offering will not be used in planning. Values (Y/N).
-
isContractRate: boolean
Informational indicator to identify rate offerings that are managed for a client in a 3rd party logistics provider setup. Values (Y/N).
-
isDepotApplicable: boolean
If the Depot Applicable option is selected, then the depot stops (source and/or destination locations) will be saved to the shipment. If it is not selected, the depot stops will not be saved to the shipment, but they will be charged and saved to the shipment financials if it is defined in the itinerary. Values (Y/N).
-
isDigitalFreight: boolean
If set to Y, then fetch rates from digital freight and use them only for tender.
-
isDirectOnlyRate: boolean
If Y, this rate will only be applicable to direct shipments.
-
isMarketRate: boolean
If Y then this rate will be used to fetch market rates for the shipment.
-
isRouteExecutionRate: boolean
If 'Y', this rate offering is used for Route Execution only. For migration: old existing rate offerings migrated to the default value ('N').
-
isSourcingRate: boolean
Indicates is the rate offering is a sourcing rate offering. Sourcing rates are view only within the system. Values (Y/N).
-
isTemplate: boolean
Used to identify rate offerings that will be used as a rate record template for Sourcing. Values (Y/N).
-
links: array
links
Read Only:
true
-
logicConfigGid: string
Specifies the logic config group ID used to look up any logic parameters specified as charge multipliers.
-
maxAveragePkgWeight:
maxAveragePkgWeight
Constraint. If the total shipment weight/number of packages > this constraint, the rate will not be considered.
-
maxCircuityDistance:
maxCircuityDistance
The rate offering constraint that defines the maximum circuity distance for the rate offering. If this value is exceeded, the rate offering cannot be applied to the shipment. To use this field, you must have a value in the Circuity Distance Cost field. If there is no additional cost applicable, then enter a cost of 0.00.
-
maxCircuityPercent: number
(double)
The rate offering constraint that defines the maximum circuity percent for the rate offering. If this value is exceeded, the rate offering cannot be applied to the shipment. To use this field, you must have a value in the Circuity Distance Cost field. If there is no additional cost applicable, then enter a cost of 0.00.
-
maxCost:
maxCost
The absolute maximum cost that applies, regardless of actual rated cost to ship.
-
maxDigiFrtPct: number
(double)
Define a percentage around how much higher the carrier rates are compared to the planned cost of the shipment when using rates from digital freight.
-
maxDistanceConstraint:
maxDistanceConstraint
The maximum distance field is intended to be used to match the rate offering with shipments. The system calculates the distance between the source and destination address of the shipment being considered, then compares that calculated distance to the maximum Distance field value to see if the rate offering matches or is below the maximum distance constraint.
-
maxGirthConstraint:
maxGirthConstraint
The maximum girth constraint is used when matching the rate offering to a shipment. If a ship unit's length requirements is greater than the maximum girth constraint the rate offering does not qualify. Note: Dimensional girth is calculated as length + (2xWidth + 2xHeight).
-
maxHeightConstraint:
maxHeightConstraint
The maximum height constraint is used when matching the rate offering to a shipment. If a ship units' length requirements is greater than the maximum height constraint the rate offering does not qualify.
-
maxLengthConstraint:
maxLengthConstraint
The maximum length constraint is used when matching the rate offering to a shipment. If a ship unit's length requirements is greater than the maximum length constraint, the rate offering does not qualify.
-
maxNumOfShipmentSegments: number
(int64)
The Max Num of Shipment Segments field determines the maximum number of segments on a shipment. A segment is defined as starting when product is loaded on the equipment and ending when the equipment is completely emptied.
-
maxShipunitLinePkgWeight:
maxShipunitLinePkgWeight
The ship unit line weight maximum is used to match with ship unit lines. This field represents the maximum value allowed by this contract for the weight of a single package.
-
maxShipUnitWeight:
maxShipUnitWeight
The maximum ship unit weight constraint is used when matching rate offerings with shipments. If any ship unit on the shipment exceeds the maximum ship unit weight, this rate offering does not qualify for the shipment in question.
-
maxTenderLeadTime:
maxTenderLeadTime
The upper bound of tender lead time. That is, if tender lead time of a shipment is bigger than this upper bound, rate would be invalid.
-
maxVolumeConstraint:
maxVolumeConstraint
The maximum volume constraint is used when matching rate offerings with shipments. If a shipment's volume is greater than the maximum value, then this rate offering does not qualify for the shipment in question.
-
maxWeightConstraint:
maxWeightConstraint
The maximum weight constraint is used when matching rate offerings with shipments. If a shipment's weight is greater than the maximum value, then this rate offering does not qualify for the shipment in question.
-
maxWidthConstraint:
maxWidthConstraint
The maximum width constraint is used when matching the rate offering to a shipment. If a ship unit's length requirements is greater than the maximum width constraint, the rate offering does not qualify.
-
minCost:
minCost
The Minimum Cost field stores the absolute minimum charge that applies for the rate offering.
-
minDistanceConstraint:
minDistanceConstraint
The minimum distance required for this rate offering to be valid.
-
minGirthConstraint:
minGirthConstraint
The minimum girth constraint is used when matching the rate offering to a shipment. If a ship unit's girth is less than the minimum, the rate offering does not qualify. Note: Dimensional girth is calculated as length + (2xWidth + 2xHeight).
-
minHeightConstraint:
minHeightConstraint
The minimum height constraint is used when matching the rate offering to a shipment. If a ship unit's height is less than the minimum, the rate offering does not qualify.
-
minLengthConstraint:
minLengthConstraint
The minimum length constraint is used when matching the rate offering to a shipment. If a ship unit's length is less than the minimum, the rate offering does not qualify.
-
minStops: number
(int32)
The absolute minimum number of stops allowed for shipments using this rate.
-
minTenderLeadTime:
minTenderLeadTime
The lower bound of a tender lead time. That is, if tender lead time of a shipment is less than this lower bound, rate would be invalid.
-
minVolumeConstraint:
minVolumeConstraint
The minimum volume constraint is used when matching rate offerings with shipments. If a shipment's volume is less than the minimum value, then this rate offering does not qualify for the shipment in question.
-
minWeightConstraint:
minWeightConstraint
The minimum weight constraint is used when matching rate offerings with shipments. If a shipment's weight is less than the minimum value, then this rate offering does not qualify for the shipment in question.
-
minWidthConstraint:
minWidthConstraint
The minimum width constraint is used when matching the rate offering to a shipment. If a ship unit's width is less than the minimum, the rate offering does not qualify.
-
nmfcCodeSubstitutes:
nmfcCodeSubstitutes
-
packageCountMethod: string
Determines how packages are counted when testing the Maximum Average Package Weight constraint. L - Use line item package count. U - Ship unit count.
-
packageWeightMin:
packageWeightMin
Not a constraint. Weight value used when calculating total shipment minimum package weight. During rating, it will be multiplied by the number of packages on the shipment, and accessed by the Minimum Package Weight RBI.
-
parentRateOfferingGid: string
The Parent Rate Offering field is used with rate maintenance. The Parent Rate Offering ID provides a way to track different versions of the rates during the approval process. To compare rate versions, you must specify either a parent rate offering ID or parent rate record ID on any template rate offerings or rate records.
-
perspective: string
Indicates if the rate offering can be used for Buy shipment rating (B) or Sell shipment rating (S) or if the rate offering supports Both Buy and Sell shipment rating (A). Values (B/S/A).
-
pickupStopsConstraint: number
(int32)
For rate offerings where the service provider will provide multi-stop coverage, the total pickup stops constraints sets a constraint on the total number of pickup stops that the rate can be used for.
-
railInterModalPlanGid: string
The GID for the rail inter-modal plan. I.e., Plan 20: door-to-door, Plan 25: ramp-to-ramp, etc.
-
rateClassificationGid: string
The GID for rate classification.
-
rateDistanceGid: string
The GID for rate distance.
-
rateGroupGid: string
The GID for the rate group.
-
rateOfferingDesc: string
Stores descriptive information about the rate offering.
-
rateOfferingGid: string
The GID for the rate offering.
-
rateOfferingSeq: number
(int64)
System generated unique identifier for a rate offering. Internal use only.
-
rateOfferingTypeGid: string
The GID for the rate offering type.
-
rateOfferingXid: string
The XID for the rate offering.
-
rateQualityGid: string
The GID for rate quantity.
-
rateRulesAndTerms:
rateRulesAndTerms
-
rateServiceGid: string
The GID for the rate service.
-
rateVersionGid: string
The GID for the rate version.
-
recalculateCost: boolean
For some time-based rates, the shipment cost calculated during bulk plan and build shipment process may need to be recalculated since it is time dependent. The Recalculate Cost option is used to force the recalculating of cost after a shipment is built. This option works in conjunction with the Rerate All Shipments After Bulk Plan parameter as follows. If the Recalculate Cost is set, planning logic will make sure to account for service time-based rating costs when making planning decisions, and that this has the potential for increasing run-time.
If Rerate All Shipments After Bulk Plan is TRUE, shipments will be re-rated regardless of the Recalculate Cost check box.
If Rerate All Shipments After Bulk Plan is FALSE and the Recalculate Cost check box is selected, then the system recalculates the shipment cost keeping the same service provider and equipment.
If Rerate All Shipments After Bulk Plan is FALSE and the Recalculate Cost option check box is cleared, then the shipment cost is not recalculated. -
regionGroupGid: string
The Region Group field is an informational region group that allows you to define a set of regions that represent the regions covered by the rate offering.
-
remarks:
remarks
-
rmAbsoluteMinCost:
rmAbsoluteMinCost
The Absolute Minimum Base Charge field determines the minimum charge that applies regardless of discounted savings.
-
roTimePeriodDefGid: string
The time period definition (if any) assigned to the rate offering for the purposes of tiered rating.
-
roundingApplication: string
Determines when to apply the rounding rules. Values are A/N/C/O where A=always, N=never, C=conditionals only, and O=cost calculations only.
-
roundingFieldsLevel: number
(int32)
Determines which kinds of fields will be affected by the rounding settings during costing. Values are 0-7, where 0=all fields, 1=none, 2=numeric fields only, 3=unit fields (weight, etc.), 4=currency, 5=numeric and unit fields, 6=numeric and currency fields, and 7=unit and currency fields.
-
roundingInterval: number
(double)
Numbers will be rounded (or truncated) to the nearest increment of this value.
-
roundingType: string
The type of rounding that will occur during rating. Value are: N=no rounding, I=round to nearest interval, F=floor, and C=ceiling.
-
servprovGid: string
The GID for the service provider.
-
smcDiscounts:
smcDiscounts
-
specialServices:
specialServices
-
stopRates:
stopRates
-
stopsIncludedInRate: number
(int32)
The Stops Included in Rate field indicates the number of free stops included in the rate offering before stop-off charges apply. The source and destination locations count as stops so, typically, the minimum number of stops included in the rate is 2. Additional charges apply for all stops not included in the rate.
-
tariffAgencyCode: string
Tariff Agency Code is an informational field that can be used to store the service provider SCAC or initials of the entity who owns the tariff such as the Railroad Publication Service.
-
tariffEffectiveDate:
tariffEffectiveDate
The Tariff Effective Date is an informational field that stores the date when the tariff goes into effect or can be used. This is not the rate offering effective date.
-
tariffIssuingCarrierId: string
The Tariff Issuing Carrier field is an informational field that is meant to store information from the service provider related to the tariff. Examples are C, JQ, SCQ, QTAMR, UPLQ, BNQ, X, BC, NSPQ.
-
tariffName: string
The Tariff Name fields allows you to put the name of the tariff that the rate offering is related to. For example, if this is a base rate offering you can put the name of the tariff that the rate offering is based on/is using.
-
tariffPubAuthority: string
Tariff Pub Authority is an informational field that can be used to store the rate offerings related tariff publication authority.
-
tariffRefnum: string
Tariff Refnum is an informational field that can be used to store the rate offerings related tariff number. The Tariff Refnum should be qualified by the Tariff Refnum Qualifier.
-
tariffRefnumQualifier: string
Tariff Refnum Qualifier is an informational field that allows you to qualify the Tariff Ref Num field. For example you can qualify the Tariff Ref Num fields with the Tariff Refnum Qualifier fields using standard qualifier that describe the relationship of the shipper and service provider regarding the prices related to the rate offering. The property glog.shipment.tarifffields.active determines if tariff fields are automatically copied from a rate offering to a shipment.
-
tariffRefnumSuffix: string
Tariff Refnum Suffix is a suffix field for the tariff reference number.
-
tariffRegAgencyCode: string
The Tariff Reg Agency Code is an informational field that is meant to store information about the regulatory agency that the rates are fled with. For example the STB (Surface Transportation Board) or ICC) Interstate Commerce Commission.
-
tariffSupplementId: string
The Tariff Supplement ID field is an informational field that is meant to provide information related to tariff amendments, revisions, or supplements of the rate authority.
-
totalStopsConstraint: number
(int32)
For rate offerings where the service provider will provide multi-stop coverage, the total stops constraints sets a constraint on the total number of stops (pickup and delivery) that the rate can be used for.
-
trackCapacityUsage: boolean
The Track Capacity Usage field when set to Y, and the Capacity Group field if provided, causes the system to track capacity usage during the planning process.
If the Track Capacity Usage is N or the Capacity Group field is blank, the system will not track capacity usage during the planning process. Values (Y/N). -
transportModeGid: string
The GID for the transport mode.
-
updateDate:
updateDate
Read Only:
true
update date -
userClassification1: string
The user classification fields are provided to capture information about the rate offering's usage. VARCHAR2(30)
-
userClassification2: string
The user classification fields are provided to capture information about the rate offering's usage. VARCHAR2(30)
-
userClassification3: string
The user classification fields are provided to capture information about the rate offering's usage. VARCHAR2(30)
-
userClassification4: string
The user classification fields are provided to capture information about the rate offering's usage. VARCHAR2(30)
-
useTactAsDisplayRate1: boolean
If Y, the build shipment logic will invoke the rating engine a second time, restricting it's search to TACT rates only, and apply the result to the shipment as a display rate.
-
useTactAsDisplayRate2: boolean
If Y, the build shipment logic will invoke the rating engine a second time, restricting it's search to TACT rates only, and apply the result.
-
useTactAsDisplayRate3: boolean
If Y, the build shipment logic will invoke the rating engine a second time, restricting it's search to TACT rates only, and apply the result.
-
volumeUomCode: string
The unit of measure for volume.
-
weightBreakProfileGid: string
The GID for the weight break profile.
-
weightUomCode: string
The unit of measure for weight.
Nested Schema : accessorials
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : circuityDistanceCost
Circuity Distance Cost is the per distance unit charge for each unit over the included/free amount.
Match All
Show Source
Nested Schema : comments
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : continuousMoveEndingExclusionRegions
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : continuousMoveRules
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : documents
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : involvedParties
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : maxAveragePkgWeight
Constraint. If the total shipment weight/number of packages > this constraint, the rate will not be considered.
Match All
Show Source
Nested Schema : maxCircuityDistance
The rate offering constraint that defines the maximum circuity distance for the rate offering. If this value is exceeded, the rate offering cannot be applied to the shipment. To use this field, you must have a value in the Circuity Distance Cost field. If there is no additional cost applicable, then enter a cost of 0.00.
Match All
Show Source
Nested Schema : maxCost
The absolute maximum cost that applies, regardless of actual rated cost to ship.
Match All
Show Source
Nested Schema : maxDistanceConstraint
The maximum distance field is intended to be used to match the rate offering with shipments. The system calculates the distance between the source and destination address of the shipment being considered, then compares that calculated distance to the maximum Distance field value to see if the rate offering matches or is below the maximum distance constraint.
Match All
Show Source
Nested Schema : maxGirthConstraint
The maximum girth constraint is used when matching the rate offering to a shipment. If a ship unit's length requirements is greater than the maximum girth constraint the rate offering does not qualify. Note: Dimensional girth is calculated as length + (2xWidth + 2xHeight).
Match All
Show Source
Nested Schema : maxHeightConstraint
The maximum height constraint is used when matching the rate offering to a shipment. If a ship units' length requirements is greater than the maximum height constraint the rate offering does not qualify.
Match All
Show Source
Nested Schema : maxLengthConstraint
The maximum length constraint is used when matching the rate offering to a shipment. If a ship unit's length requirements is greater than the maximum length constraint, the rate offering does not qualify.
Match All
Show Source
Nested Schema : maxShipunitLinePkgWeight
The ship unit line weight maximum is used to match with ship unit lines. This field represents the maximum value allowed by this contract for the weight of a single package.
Match All
Show Source
Nested Schema : maxShipUnitWeight
The maximum ship unit weight constraint is used when matching rate offerings with shipments. If any ship unit on the shipment exceeds the maximum ship unit weight, this rate offering does not qualify for the shipment in question.
Match All
Show Source
Nested Schema : maxTenderLeadTime
The upper bound of tender lead time. That is, if tender lead time of a shipment is bigger than this upper bound, rate would be invalid.
Match All
Show Source
Nested Schema : maxVolumeConstraint
The maximum volume constraint is used when matching rate offerings with shipments. If a shipment's volume is greater than the maximum value, then this rate offering does not qualify for the shipment in question.
Match All
Show Source
Nested Schema : maxWeightConstraint
The maximum weight constraint is used when matching rate offerings with shipments. If a shipment's weight is greater than the maximum value, then this rate offering does not qualify for the shipment in question.
Match All
Show Source
Nested Schema : maxWidthConstraint
The maximum width constraint is used when matching the rate offering to a shipment. If a ship unit's length requirements is greater than the maximum width constraint, the rate offering does not qualify.
Match All
Show Source
Nested Schema : minCost
The Minimum Cost field stores the absolute minimum charge that applies for the rate offering.
Match All
Show Source
Nested Schema : minDistanceConstraint
The minimum distance required for this rate offering to be valid.
Match All
Show Source
Nested Schema : minGirthConstraint
The minimum girth constraint is used when matching the rate offering to a shipment. If a ship unit's girth is less than the minimum, the rate offering does not qualify. Note: Dimensional girth is calculated as length + (2xWidth + 2xHeight).
Match All
Show Source
Nested Schema : minHeightConstraint
The minimum height constraint is used when matching the rate offering to a shipment. If a ship unit's height is less than the minimum, the rate offering does not qualify.
Match All
Show Source
Nested Schema : minLengthConstraint
The minimum length constraint is used when matching the rate offering to a shipment. If a ship unit's length is less than the minimum, the rate offering does not qualify.
Match All
Show Source
Nested Schema : minTenderLeadTime
The lower bound of a tender lead time. That is, if tender lead time of a shipment is less than this lower bound, rate would be invalid.
Match All
Show Source
Nested Schema : minVolumeConstraint
The minimum volume constraint is used when matching rate offerings with shipments. If a shipment's volume is less than the minimum value, then this rate offering does not qualify for the shipment in question.
Match All
Show Source
Nested Schema : minWeightConstraint
The minimum weight constraint is used when matching rate offerings with shipments. If a shipment's weight is less than the minimum value, then this rate offering does not qualify for the shipment in question.
Match All
Show Source
Nested Schema : minWidthConstraint
The minimum width constraint is used when matching the rate offering to a shipment. If a ship unit's width is less than the minimum, the rate offering does not qualify.
Match All
Show Source
Nested Schema : nmfcCodeSubstitutes
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : packageWeightMin
Not a constraint. Weight value used when calculating total shipment minimum package weight. During rating, it will be multiplied by the number of packages on the shipment, and accessed by the Minimum Package Weight RBI.
Match All
Show Source
Nested Schema : rateRulesAndTerms
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : remarks
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : rmAbsoluteMinCost
The Absolute Minimum Base Charge field determines the minimum charge that applies regardless of discounted savings.
Match All
Show Source
Nested Schema : smcDiscounts
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : specialServices
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : stopRates
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : tariffEffectiveDate
The Tariff Effective Date is an informational field that stores the date when the tariff goes into effect or can be used. This is not the rate offering effective date.
Match All
Show Source
Nested Schema : currencyType
Type:
Show Source
object
-
currency: string
ISO 4217 currency code
-
value: number
Numeric value that specifies a currency
Nested Schema : rateOfferings.accessorials
Type:
Show Source
object
-
accessorialCodeGid: string
The GID for the accessorial code.
-
accessorialCostGid: string
The GID for the Accessorial Cost. Links to the rating setup used to determine the cost of providing the accessorial.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
Nested Schema : dateTimeType
Type:
Show Source
object
-
timezone: string
Timezone in Olson database format
-
value: string
(date-time)
Date in ISO 8601 format
Nested Schema : rateOfferings.comments
Type:
Show Source
object
-
commentDate:
commentDate
The date and time the comment was entered for the rate offering.
-
domainName: string
Database domain where this data is stored.
-
enteredBy: string
The user ID of the user entering the comment.
-
links: array
links
Read Only:
true
-
theComment: string
Comment text.
Nested Schema : commentDate
The date and time the comment was entered for the rate offering.
Match All
Show Source
Nested Schema : rateOfferings.continuousMoveEndingExclusionRegions
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
regionGid: string
The GID for the region.
Nested Schema : rateOfferings.continuousMoveRules
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
freeEmptyDistance:
freeEmptyDistance
The free distance allowed between shipments in a continuous move tour.
-
links: array
links
Read Only:
true
-
maxConnectionTime:
maxConnectionTime
The Max Connection Time field defines the maximum time allowed when planning any pair of consecutive shipments for inclusion in a continuous move tour. The connection time of any pair of consecutive shipments in a continuous move cannot exceed the max connection time. Connection time is defined as the time between the end of the first shipment being considered and the start of the second shipment
-
maxEmptyDistance:
maxEmptyDistance
The Max Empty Distance field defines the maximum empty distance that is allowed when planning any pair of consecutive shipments for inclusion in a continuous move tour. The maximum empty distance provides a way to limit the distance travelled to link shipments into a continuous move tour. If this field is not populated, shipments will be qualified for the same continuous move tour regardless of the distance required to connect them.
-
maxRelEmptyDistance: number
(double)
Max Empty Distance (%) is used to disqualify shipments that are too short in comparison to the distance travelled to include the shipment in the continuous move tour.
Max Empty Distance (%) = 100*E/L, where
E = Max Empty Distance
L = Line Haul Distance of the shipment -
maxTimeAfterDeliv:
maxTimeAfterDeliv
The maximum amount of time allowed between the last delivery of one shipment to the pickup of the next shipment. To create a continuous move, the second shipment must be picked up within a certain amount of time after the delivery of the preceding shipment. If this field is left blank, there is no time limit.
-
minLinehaulDistance:
minLinehaulDistance
Shipments that are less than the minimum linehaul distance will not be considered for continuous moves/continuous move rates.
-
xLaneGid: string
The GID for the X Lane.
Nested Schema : freeEmptyDistance
The free distance allowed between shipments in a continuous move tour.
Match All
Show Source
Nested Schema : maxConnectionTime
The Max Connection Time field defines the maximum time allowed when planning any pair of consecutive shipments for inclusion in a continuous move tour. The connection time of any pair of consecutive shipments in a continuous move cannot exceed the max connection time. Connection time is defined as the time between the end of the first shipment being considered and the start of the second shipment
Match All
Show Source
Nested Schema : maxEmptyDistance
The Max Empty Distance field defines the maximum empty distance that is allowed when planning any pair of consecutive shipments for inclusion in a continuous move tour. The maximum empty distance provides a way to limit the distance travelled to link shipments into a continuous move tour. If this field is not populated, shipments will be qualified for the same continuous move tour regardless of the distance required to connect them.
Match All
Show Source
Nested Schema : maxTimeAfterDeliv
The maximum amount of time allowed between the last delivery of one shipment to the pickup of the next shipment. To create a continuous move, the second shipment must be picked up within a certain amount of time after the delivery of the preceding shipment. If this field is left blank, there is no time limit.
Match All
Show Source
Nested Schema : minLinehaulDistance
Shipments that are less than the minimum linehaul distance will not be considered for continuous moves/continuous move rates.
Match All
Show Source
Nested Schema : amountType
Type:
Show Source
object
-
unit: string
Unit of measure
-
value: number
Numeric value that specifies an amount
Nested Schema : rateOfferings.documents
Type:
Show Source
object
-
contentManagementSystemGid: string
No description.
-
documentCmsId: string
A GUID to associate the document with content stored on its remote CMS. Valid when document_type=CMS.
-
documentDefGid: string
No description.
-
documentFilename: string
No description.
-
documentGid: string
No description.
-
documentMimeType: string
No description.
-
documentTrackingNum: string
No description.
-
documentType: string
No description.
-
documentUrl: string
No description.
-
documentXid: string
No description.
-
domainName: string
No description.
-
effectiveDate:
effectiveDate
represents effective date for a document
-
expirationDate:
expirationDate
Represents expiration date for a document.
-
generatedAt:
generatedAt
If preparation, date/time content was last generated
-
links: array
links
Read Only:
true
-
ownerDataQueryTypeGid: string
No description.
- relatedDocumentGid: string
-
reportGid: string
The report associated with the document attachment, if content was generated by the report subsystem.
-
uploadedAt:
uploadedAt
If attachment, date/time content was last updated
-
usedAs: string
Represents the classification of a document.(C/I/L/T)
-
userDefined1IconGid: string
No description.
-
userDefined2IconGid: string
No description.
-
userDefined3IconGid: string
No description.
-
userDefined4IconGid: string
No description.
-
userDefined5IconGid: string
No description.
Nested Schema : generatedAt
If preparation, date/time content was last generated
Match All
Show Source
Nested Schema : rateOfferings.involvedParties
Type:
Show Source
object
-
comMethodGid: string
The GID for the communication method for the involved party.
-
domainName: string
Database domain where this data is stored.
-
involvedPartyContactGid: string
The GID for the contact for the involved party.
-
involvedPartyQualGid: string
The GID for the involved party qualifier.
-
links: array
links
Read Only:
true
Nested Schema : rateOfferings.nmfcCodeSubstitutes
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
nmfcHigh: number
(double)
Records additional information about the rate cost. This description will appear as the shipment cost type on the Financial tab of the Shipment Manager when this rate cost is applied to a shipment. If this field is left blank, a default shipment cost type appears such as Base or Discount.
-
nmfcLow: number
(double)
Low National Motor Freight Classification value used for defining a rate as classification record.
-
rateAsNmfcClass: number
(double)
The National Motor Freight Classification (NMFC) fields allow you to apply a specific NMFC based rate using a range of NMFC classes. For example, if you want anything between the NMFC class of 45 and 65 to use the 55 NMFC class rate, then you would enter 45 in the NMFC Low field, 65 in the NMFC High field, and 55 in the Rate As NMFC Class field. Note: The NMFC Low and High fields are inclusive, meaning they follow a "greater than or equal to" and a "less than or equal to" pattern respectively. Using the above example, 45 and 65 are included in the ranges.
-
rateGeoGid: string
The GID for the related rate geo for the rate as table of values.
-
roNmfccsSeqNum: number
(int64)
Internal sequence number for different row entries.
Nested Schema : rateOfferings.rateRulesAndTerms
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
ruleDesc: string
Provides a place to store the description of the rule. For example, "Freight that is undeliverable due to error or omission on the part of the shipper, consignee, or owner or for which no disposition instructions have been provided shall be considered unclaimed/abandoned."
-
ruleNumber: string
Rules and Terms is used to store information about the rate offering. The rule number or rule/term identifies the rule being defined. For example, "Rule 921".
-
ruleTitle: string
Rule title provides a brief description of the rule being defined. For example, "UNCLAIMED/ABANDONED FREIGHT"
Nested Schema : rateOfferings.remarks
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
remarkQualGid: string
Qualifier for rate offering remark.
-
remarkSequence: number
(double)
Sequence to allow multiple remarks for a rate offering.
-
remarkText: string
Actual remark text for rate offering remark.
Nested Schema : rateOfferings.smcDiscounts
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
l5cDiscount: number
(double)
Percent discount for weights <= 500 lb.< div> =>
-
links: array
links
Read Only:
true
-
m10mDiscount: number
(double)
Percent discount for weight > 10,000 lb.
-
m1mDiscount: number
(double)
Percent discount for weight > 1000 lb.
-
m20mDiscount: number
(double)
Percent discount for weight > 20,000 lb.
-
m2mDiscount: number
(double)
Percent discount for weight > 2000 lb.
-
m30mDiscount: number
(double)
Percent discount for weight > 30,000 lb.
-
m40mDiscount: number
(double)
Percent discount for weight > 40,000 lb.
-
m5cDiscount: number
(double)
Percent discount for weight > 500 lb.
-
m5mDiscount: number
(double)
Percent discount for weight > 5000 lb.
-
minDiscount: number
(double)
Percent for minimum cost.
-
movementType: string
Qualifies the usage of the discounts defined by SMC/Carrier Connect Movement Type.
If null, then the discounts provided (by weight break) apply to all Movement Types. Otherwise - the discounts defined apply to the specified Movement Type - either Direct, Indirect, Partner or Custom. -
rateGeoGid: string
The GID for the rate record related to the SMC discount as table of values.
-
smcDiscSeqNum: number
(int64)
An internal sequence number for the different SMC discount entries provided by movement type.
-
stopAlternationBreak: string
Specifies the weight break where the deficit rating should stop.
Nested Schema : rateOfferings.specialServices
Type:
Show Source
object
-
accessorials:
accessorials
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
specialServiceCodeGid: string
The GID for the special service code.
Nested Schema : accessorials
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : rateOfferings.specialServices.accessorials
Type:
Show Source
object
-
accessorialCodeGid: string
The GID for the accessorial code.
-
accessorialCostGid: string
The GID for the accessorial cost.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
Nested Schema : rateOfferings.stopRates
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
highStop: number
(int32)
Stop off charges are typically defined for truckload rates. In most cases, the base rate includes the pickup stop and the first delivery stop. The rate may also support the option of performing addition stops, but at an additional per stop charge. The additional per stop charges are often specified in a ranges i.e., for stops 3 to 5 the per stop charge is X for stops 6 to 7 the per stop charge is Y per stop.
The high stop field defines the high end of the range for stop off charges. -
links: array
links
Read Only:
true
-
lowStop: number
(int32)
Stop off charges are typically defined for truckload rates. In most cases, the base rate includes the pickup stop and the first delivery stop. The rate may also support the option of performing addition stops, but at an additional per stop charge. The additional per stop charges are often specified in a ranges i.e., for stops 3 to 5 the per stop charge is X for stops 6 to 7 the per stop charge is Y per stop.
The low stop fields defines the low end of the range for stop off charges. -
perStopCost:
perStopCost
The per stop charge for the low high range being defined.
Nested Schema : perStopCost
The per stop charge for the low high range being defined.
Match All
Show Source