1. REST API for Fusion Cloud Transportation and Global Trade Management Business Object Resources
  2. Tasks
  3. Business Objects
  4. Rate Records

Get Rate Records

get

/rateRecords

Request

Query Parameters
  • 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.
  • Comma-delimited string of field names that you wanted returned in a GET request.
  • Positive integer value that specifies the maximum number of items returned by the server.
  • 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.
  • Comma-separated string of field names, each optionally followed by asc or desc, that specifies the order of items returned in the response payload.
  • Filter (a 'where'clause) to restrict the items returned in the collection. By default, no filtering is applied.
  • 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 Top

Response

Supported Media Types

Default Response

Default Response.
Body ()
Root Schema : schema
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : links
Type: array
Show Source
Nested Schema : rateRecords
Type: object
Show Source
  • accessorials
  • 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.
    Selected: 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. If there is a conditional charge and a minimum charge, and the conditional charge does not apply, the minimum charge will always be applied. Cleared: This rate only qualifies if all basis options can be charged.
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • attributeDate1
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate10
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate2
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate3
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate4
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate5
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate6
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate7
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate8
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate9
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • The ID of the rate geo profile to be used when building buy shipments.
  • The ID of the service provider profile to be used when building buy shipments.
  • Calculate Chargeable Weight/Volume Using provides you with options for calculating the chargeable weight. If you select this field value as "Shipment Total Dimensional Weight/Volume", chargeable weight/volume will be calculated based on the Shipment Total Dimensional Weight/Volume. If you select this field value as "Sum of Individual Ship Unit Dimensional Weight/Volume", chargeable weight/volume will be calculated based on the Sum of Individual Ship Unit Dimensional Weight/Volume.
  • 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
    The per distance unit charge for each unit over the included/free amount.
  • The Container-On-Flat-Car/Trailer-On-Flat-Car code used along with the Rail Inter Modal Plan GID to determine the rate.
  • Allows you to constrain the usage of the rate during the planning based the compatibility definition provided by the assigned corporation profile.
  • costGroups
  • This code signifies what rate is used on a Leg; either "C" for the Customer's rate, or "S" for the Shipper's rate.
  • When to apply deficit calculations. Values are Y/N/P where Y = Yes, N = No and P = Payant Pour.
  • Constraint value for the number of delivery stops that this rate can be used for.
  • The GID for the dim rate factor.
  • documents
  • Database domain where this data is stored.
  • Allows you to assign a domain profile ID which defines the compatible or incompatible domains for rate.
  • effectiveDate
    Date the rate is effective from.
  • Links the rate geo record to an equipment group profile that, if provided, will constrain the rate to only use equipment groups identified as compatible based on the defined equipment group profile.
  • expirationDate
    Date the rate expires, and should no longer be considered for planning.
  • Used to indicate that the rate has been marked for expiration.
  • The GID for the flex commodity profile.
  • Qualifies how the rate should be used for shipments with hazardous materials. The Hazardous Rate Type has three options which can be used to indicate whether the rate can be used for shipments with or without hazardous materials. The options are:
    Allows Hazardous Materials
    Hazardous Materials Only
    Non-Hazardous Materials Only
  • insertDate
    Read Only: true
    insert date
  • TRUE FALSE flag indicating if the rate is active or not.
  • The From Beyond and For Beyond check boxes allow the existence of two rates with the same geography, such as SPLC to SPLC, to exist with one being allowable for use with Rule 11 and the other one not. Since you cannot have the same GID, this allows you to have the flexibility. The For Beyond check box is for a leg going into a junction as defined on Rule 11 Route Code. The From Beyond check box is for a leg going from a junction. Select both check boxes for a leg going from a junction to a junction.
  • The From Beyond and For Beyond check boxes allow the existence of two rates with the same geography, such as SPLC to SPLC, to exist with one being allowable for use with Rule 11 and the other one not. Since you cannot have the same GID, this allows you to have the flexibility. The For Beyond check box is for a leg going into a junction as defined on Rule 11 Route Code. The From Beyond check box is for a leg going from a junction. Select both check boxes for a leg going from a junction to a junction.
  • If Y, the BASE rate will not be evaluated and applied for this rate geo.
  • Most commonly applicable to spot rates; indicates if this rate is to be found by rate finding logic. During RIQ, if the attached rate offering is a spot rate, the rate geo can only be used if quote is checked.
  • This column is named as IS_SOURCING_RATE to maintain consistency with RATE_OFFERING table but used to serve the purpose of IS_READ_ONLY in the UI.
  • links
  • The GID for the location.
  • Specifies the logic configuration group ID used to look up any logic parameters specified as charge multipliers on costs. If not null, overrides value specified on the owning rate offering.
  • maxCircuityDistance
    The rate constraint that defines the maximum circuity distance for the rate. If this value is exceeded, the rate 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.
  • The rate constraint that defines the maximum circuity percent for the rate. If this value is exceeded, the rate 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.
  • minCost
    The minimum charge for a shipment. The minimum charge is absolute minimum charge that applies, so the calculated cost of a shipment will be compared to the minimum charge and the cost will always be greater than or equal to the minimum charge.
  • Value for the minimum number of stops required for this rate to apply.
  • The multi base group rule determines how the results from multiple rate cost groups are evaluated. Values A/M/X. Options are:
    Add the Cost,
    Select the Least Cost,
    Select the Greatest Cost.
    Rate Cost Groups allow you to group rate costs together.
    Note: To use Rate Cost Groups, you must have rate groups active within your user preferences.
  • nmfcCodeSubstitutes
  • Used for rate maintenance and is provided so you can track the different versions of your rates during the approval process.
  • Optional payment method for the rate record
  • Constraint value for the number of pickup stops that this rate can be used for.
  • The rail inter-modal plan GID. i.e. Plan 20 - door-to-door, Plan 25 - ramp-to-ramp, etc.
  • The rate geo description.
  • The GID for the rate geo.
  • System generated unique identifier for a rate geo. For internal use only.
  • The XID for the rate geo.
  • Indicates the rate offering to which this rate reo record is linked.
  • The GID for rate quality.
  • Links to the rate service record which, based on the related rate service type, determines how to calculate the timing for a shipment.
  • The GID for the rate zone profile.
  • refnums
  • remarks
  • The global ID for the rate offering time period definition which is used to define the time periods for tiered rates.
  • 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.
  • 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.
  • Numbers will be rounded (or truncated) to the nearest increment of this value.
  • The type of rounding that will occur during rating. Value are: N=no rounding, I=round to nearest interval, F=floor, and C=ceiling.
  • The GID for the route code.
  • smcDiscounts
  • specialServices
  • stopRates
  • The Stops Included Rate field indicates the number of free stops included in the rate 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.
  • Constraint value for the total number of stops (pickup and delivery) that this rate can be used for.
  • updateDate
    Read Only: true
    update date
  • A VIA Locations is used when rating and routing international shipments. Rates are valid when the data specified here matches the VIA Location set up on an itinerary. This field provides the location GID for a single destination via location.
  • VIA Locations are used when rating and routing international shipments. Rates are valid when the data specified here matches the VIA Locations set up on an itinerary. This field provides the profile GID for the profile/list of destination via locations.
  • A VIA Locations is used when rating and routing international shipments. Rates are valid when the data specified here matches the VIA Location set up on an itinerary. This field provides the location GID for a single source via location.
  • VIA Locations are used when rating and routing international shipments. Rates are valid when the data specified here matches the VIA Locations set up on an itinerary. This field provides the profile GID for the profile/list of source via locations.
  • Indicates the lane definition (the from and to geo hierarchies) that this rate geo record will cover.
Nested Schema : accessorials
Type: object
Show Source
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
The per distance unit charge for each unit over the included/free amount.
Match All
Show Source
Nested Schema : costGroups
Type: object
Show Source
Nested Schema : documents
Type: object
Show Source
Nested Schema : effectiveDate
Date the rate is effective from.
Match All
Show Source
Nested Schema : expirationDate
Date the rate expires, and should no longer be considered for planning.
Match All
Show Source
Nested Schema : insertDate
Read Only: true
insert date
Match All
Show Source
Nested Schema : maxCircuityDistance
The rate constraint that defines the maximum circuity distance for the rate. If this value is exceeded, the rate 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 : minCost
The minimum charge for a shipment. The minimum charge is absolute minimum charge that applies, so the calculated cost of a shipment will be compared to the minimum charge and the cost will always be greater than or equal to the minimum charge.
Match All
Show Source
Nested Schema : nmfcCodeSubstitutes
Type: object
Show Source
Nested Schema : refnums
Type: object
Show Source
Nested Schema : remarks
Type: object
Show Source
Nested Schema : smcDiscounts
Type: object
Show Source
Nested Schema : specialServices
Type: object
Show Source
Nested Schema : stopRates
Type: object
Show Source
Nested Schema : updateDate
Read Only: true
update date
Match All
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.accessorials
Type: object
Show Source
Nested Schema : dateTimeType
Type: object
Show Source
Nested Schema : currencyType
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.costGroups
Type: object
Show Source
  • costs
  • Defines the way the rating logic handles unit breaks. When there is a unit break defined for a rate, deficit calculations will make sure that the least expensive rate is selected. For example, if a rate break occurs at 1000 pounds, and an order weighs 999 pounds (with a rate of $15 per pound), then the system will look at the price of shipping at the next highest weight break (1001 pounds at $13 per pound) and apply the cheapest rate. In this example, the least expensive option is to use the 1001 pound rate even though only 999 pounds are being shipped. For details on the types, see rounding and deficit calculations.
  • Database domain where this data is stored.
  • The name used to identify the rate group.
  • links
  • Determine how costs within this group will be calculated.
  • The GID for the rate cost group. Rate cost groups provide the ability to group separate costs together to produce a final rate.
  • The sequence number used in the UI to display rate groups in order.
  • The XID for the rate cost group.
  • Set to Base to create a base cost or miscellaneous for all other cost types.
  • Defines when rounding should take place. For example, you may only want rounding to be done on cost calculations.
  • Specifies which fields in the rating process should be rounded. For example, you may only want currency fields rounded.
  • Specifies what interval to round up or down to. For example, if you want to round up or down to the nearest 1, then you would enter 1 here. If you want to round up or down to the nearest tenth decimal place, then you would enter .1 here.
  • Dictates how numbers are rounded. Select Ceiling to always round up, Floor to always round down, Nearest Interval to round up if it is 5 or greater and down if it is less than 5, or No Rounding to not round at all.
Nested Schema : costs
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.costGroups.costs
Type: object
Show Source
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Used to combine conditional rules with values of SELECTED, AND, or OR. If you choose SELECTED, the system first finds matches for the first conditional rule, and then passes only those matches on to the next conditional rule, etc..
  • Used to combine conditional rules with values of SELECTED, AND, or OR. If you choose SELECTED, the system first finds matches for the first conditional rule, and then passes only those matches on to the next conditional rule, etc..
  • Used to combine conditional rules with values of SELECTED, AND, or OR. If you choose SELECTED, the system first finds matches for the first conditional rule, and then passes only those matches on to the next conditional rule, etc..
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type VARCHAR2 (150)
  • attributeDate1
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate10
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate2
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate3
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate4
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate5
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate6
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate7
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate8
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • attributeDate9
    Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
  • Calculate Chargeable Weight/Volume Using provides you with options for calculating the chargeable weight. If you select this field value as "Shipment Total Dimensional Weight/Volume", chargeable weight/volume will be calculated based on the Shipment Total Dimensional Weight/Volume. If you select this field value as "Sum of Individual Ship Unit Dimensional Weight/Volume", chargeable weight/volume will be calculated based on the Sum of Individual Ship Unit Dimensional Weight/Volume.
  • Allows the user to select a calendar activity for the calendar validation test.
  • If the costs being defined is to be based on a calendar provide the Calendar ID.
  • Charge action to be applied. Values (A/M/X/D/W).
  • chargeAmount
    Amount to be charged per unit code and unit count. For example, the amount to be charge is 1 USD for every 3 pounds.
  • Comparator between charges.
  • The RBI used to lookup values in the secondary rate unit break profile.
  • Determines the attribute/qualifier of the object based on which the charge using unit breaks is to be calculated. For example, if the rate break is based on flex field attribute1, this column will hold value as attribute1, the flex field column name. If the rate break is based on the reference number qualifier GLOG = ORDER_01 then this column will hold the value GLOG, the qualifier name.
  • Determines the attribute/qualifier of the object based on which the charge using unit breaks is to be calculated. For example, if rate break is based on flex field attribute1, this column will hold value as attribute1, the flex field column name. If rate break is based on the reference number qualifier GLOG = ORDER_01 then this column will hold the value GLOG, the qualifier name.
  • This is the basis option for which the cost accrues from the Basis field. Values (A/L/S/G/E/I).
  • The basis option for which the cost accrues from the Basis field.
  • Controls how charge multipliers are applied against the specified cost. Values (A/L/S/G/E/I). There are a set of options:
    Add individual multiplier values
    Greatest individual cost
    Choose lowest individual cost
    Collect costs separately
  • Enter the number of basis options that go with each amount in the Unit field.
  • Determines the attribute/qualifier of the object based on which the charge is to be calculated. For example, if the charge is based on some flex field attribute1, this column will hold value as attribute1, the flex field column name. If the charge is based on the reference number qualifier GLOG = ORDER_01 then this column will hold the value GLOG, the qualifier name.
  • Determines the attribute/qualifier of the object based on which the charge is to be calculated. For example, if the charge is based on some flex field attribute1, this column will hold value as attribute1, the flex field column name. If the charge is based on the reference number qualifier GLOG = ORDER_01 then this column will hold the value GLOG, the qualifier name.
  • Charge sequence controls, in the order that the costs are calculated. Charge Sequence 1 is calculated before Charge Sequence 2.
  • There are the following cost types:
    Charge
    Discount
    External
    Profile
  • The charge unit count indicates the per amount for the charge. For example, the amount to be charged is 1 USD for every 3 pounds. In this example 3 is the charge unit count - 1 USD is charged for every 3 pounds.
  • The number of basis options that go with each amount in the Unit field.
  • The charge per unit of measure. For example, the amount to be charged is 1 USD for every 3 pounds. In this example pounds is the charge unit of measure code.
  • The charge per unit of measure. For example, the amount to be charged is 1 USD for every 3 pounds. In this example pounds is the charge unit of measure code.
  • The cost category can be assigned to one or more rate costs in a rate record. The cost category can then be grouped into cost category sets which can then be used during the driver assignment process. During the rating process, only rate costs whose categories are contained in the specified set will be evaluated. The results will be sorted based on total weighted cost and the best option assigned.
  • Tags a cost with an accessorial code. This does not indicate that the cost is an accessorial. It is a way of identifying groups of costs.
  • Designates the type of the cost. C = Charge, D = Discount, P = Profile, E = External.
  • When to apply deficit calculations. Values are Y/N/P where Y = Yes, N = No, and P = Payant Pour
  • 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.
  • The Dimensional (Dim) Rate Factor ID links to the definition of the dim rate factor. The dim rate factor calculates the dimensional weight of a shipment, typically for goods shipped via air or sea. The weight is calculated as: Volume of the shipment/Dimensional rate factor. The system uses the greater of dimensional weight and actual weight which is called the chargeable weight. This chargeable weight is used while rating the shipment.
  • Identifies the distance unit for the tariff. Informational. Values ( A/B/D/F/K/L/M/T/X).
  • Database domain where this data is stored.
  • effectiveDate
    Date the rate is effective from.
  • Stores information related to the authority/government agency that relates to this rate.
  • expirationDate
    Date the rate expires, and should no longer be considered for planning.
  • For a cost type of E, specifies the external rating engine GID.
  • For external rating engine GIDs of type GENERIC, this specifies the fieldset used to call out to the external engine.
  • Operand value high value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div>
  • Operand value high value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div>
  • Operand value high value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div>
  • Operand value high value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div>
  • Indicates if this rate cost has been filed as tariff. This is set to 'N' for new spot rates. Users may wish to set up a saved query to notify users if this rate is used.
  • The operator for the conditional. For example, <=: less than or equal to,>: Greater than, <: less than,>=: Greater than or equal to, =: Equal to etc.
  • The operator for the conditional. For example, <=: less than or equal to,>: Greater than, <: less than,>=: Greater than or equal to, =: Equal to etc.
  • The operator for the conditional. For example, <=: less than or equal to,>: Greater than, <: less than,>=: Greater than or equal to, =: Equal to etc.
  • The operator for the conditional. For example, <=: less than or equal to,>: Greater than, <: less than,>=: Greater than or equal to, =: Equal to etc.
  • links
  • For a cost type of L, specifies the logic parameter qualifier (of type Currency) which contains the cost value used as the charge multiplier.
  • Operand value or low value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div>
  • Operand value or low value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div>
  • Operand value or low value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div>
  • Operand value or low value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div>
  • maxCost
    The maximum cost is the absolute maximum rate that can be charged. The calculated rate cost is comparted to the maximum cost and the lower of the two values is what is charged.
  • minCost
    The minimum charge for a shipment. The minimum charge is absolute minimum charge that applies; so the calculated cost of a shipment will be compared to the minimum charge and the cost will always be greater than or equal to the minimum charge.
  • The GID for the operator.
  • The GID for the operator.
  • The GID for the operator.
  • The GID for the operator.
  • Determines the attribute/qualifier of the object on which the condition is based. For example, if the condition checks the value for flex field attribute1 = TEST, this column will hold value as attribute1, the flex field column name. If condition is on the reference number qualifier GLOG = ORDER_01 then this column will hold the value GLOG, the qualifier name.
  • Determines the attribute/qualifier of the object on which the second condition is based. For example, if the condition checks the value for flex field attribute1 = TEST, this column will hold value as attribute1, the flex field column name. If condition is on the reference number qualifier GLOG = ORDER_01 then this column will hold the value GLOG, the qualifier name.
  • Determines the attribute/qualifier of the object on which the third condition is based. For example, if the condition checks the value for flex field attribute1 = TEST, this column will hold value as attribute1, the flex field column name. If the condition is on the reference number qualifier GLOG = ORDER_01 then this column will hold the value GLOG, the qualifier name.
  • Determines the attribute/qualifier of the object on which the condition is based. For example, if the condition checks the value for flex field attribute1 = TEST, this column will hold value as attribute1, the flex field column name. If the condition is on the reference number qualifier GLOG = ORDER_01 then this column will hold the value GLOG, the qualifier name.
  • The minimum charge in the base currency.
  • The mileage factor published for rating purposes. This number is qualified by the rate basis qualifier. An informational field.
  • Provides context for the rate basis number. Informational. For example, if the rate basis number is "83" as defined by the household goods miles definition which would explain the geography for the rate basis number. Values (A/B/C/D/E/F/H/M/T/X/Y).
  • Internal sequencing number for costs operand.
  • An internal sequencing number for costs defined on a rate.
  • The secondary rate unit break profile. It cannot have a value if the main profile GID is NULL.
  • The main rate unit break profile.
  • 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.
  • 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.
  • Numbers will be rounded (or truncated) to the nearest increment of this value.
  • The type of rounding that will occur during rating. Value are: N=no rounding, I=round to nearest interval, F=floor, and C=ceiling.
  • A commodity classification that is used, as a means of control, for grouping of commodities in tariff applications.
  • tariffDistance
    The distance on which the rate is based.
  • The tariff freight class code specifies the freight classification associated with this tariff. Tariff freight class code references a system where the motor carrier industry has classified "goods" by their shipping density instead of their composition or use. An informational field.
  • The Tariff fields are a set of informational field that let the service provider know the rate being used. The tariff item number can be used for all types of prices. If the service provider assigns an item number or a numeric extension for the authority number in the reference number to the price, then this field can be used to capture that information. The tariff item number is the next step below the tariff section.
  • The tariff item number suffix, if you have a suffix with your tariff item number. The tariff item number suffix works with the tariff item number. An informational field.
  • The item part is a subdivision of an item. The item part is like the house number on a street (tariff item number) in a city (tariff section) in a state (tariff reference number).
  • The tariff section is the first division of granularity of a tariff and describes where the rate can be found. An informational field.
  • If using tiered rating, assigning a number to this field allows RIQ to query tiered rates by simply specifying a tier number.
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 : chargeAmount
Amount to be charged per unit code and unit count. For example, the amount to be charge is 1 USD for every 3 pounds.
Match All
Show Source
Nested Schema : effectiveDate
Date the rate is effective from.
Match All
Show Source
Nested Schema : expirationDate
Date the rate expires, and should no longer be considered for planning.
Match All
Show Source
Nested Schema : maxCost
The maximum cost is the absolute maximum rate that can be charged. The calculated rate cost is comparted to the maximum cost and the lower of the two values is what is charged.
Match All
Show Source
Nested Schema : minCost
The minimum charge for a shipment. The minimum charge is absolute minimum charge that applies; so the calculated cost of a shipment will be compared to the minimum charge and the cost will always be greater than or equal to the minimum charge.
Match All
Show Source
Nested Schema : tariffDistance
The distance on which the rate is based.
Match All
Show Source
Nested Schema : dateType
Type: object
Show Source
Nested Schema : amountType
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.documents
Type: object
Show Source
Nested Schema : effectiveDate
represents effective date for a document
Match All
Show Source
Nested Schema : expirationDate
Represents expiration date for a document.
Match All
Show Source
Nested Schema : generatedAt
If preparation, date/time content was last generated
Match All
Show Source
Nested Schema : uploadedAt
If attachment, date/time content was last updated
Match All
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.nmfcCodeSubstitutes
Type: object
Show Source
  • Database domain where this data is stored.
  • links
  • 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.
  • Low National Motor Freight Classification value used for defining a rate as classification record.
  • 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.
  • The GID for the related rate offering for the rate as table of values.
  • Internal sequence number for different row entries.
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.refnums
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.remarks
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.smcDiscounts
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.specialServices
Type: object
Show Source
Nested Schema : accessorials
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.specialServices.accessorials
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : rateRecords.stopRates
Type: object
Show Source
  • Database domain where this data is stored.
  • 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
  • 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
    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
Back to Top