Get Costs
get
/rateRecords/{rateGeoGid}/costGroups/{rateGeoCostGroupGid}/costs
Request
Path Parameters
-
rateGeoCostGroupGid(required): string
Resource ID
-
rateGeoGid(required): string
Resource ID
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 : rateRecords.costGroups.costs
Type:
Show Source
object
-
allowZeroRbiValue: boolean
Attribute fields (flexfields) allow you to add additional information about an object. Data Type NUMBER
-
andOr1: string
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..
-
andOr2: string
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..
-
andOr3: string
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..
-
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
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.
-
calendarActivityGid: string
Allows the user to select a calendar activity for the calendar validation test.
-
calendarGid: string
If the costs being defined is to be based on a calendar provide the Calendar ID.
-
chargeAction: string
Charge action to be applied. Values (A/M/X/D/W).
-
chargeAmount:
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.
-
chargeBreakComparator: string
Comparator between charges.
-
chargeBreakComparator2Gid: string
The RBI used to lookup values in the secondary rate unit break profile.
-
chargeBreakCompQualifier1: string
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.
-
chargeBreakCompQualifier2: string
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.
-
chargeMultiplier: string
This is the basis option for which the cost accrues from the Basis field. Values (A/L/S/G/E/I).
-
chargeMultiplier2: string
The basis option for which the cost accrues from the Basis field.
-
chargeMultiplierOption: string
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 -
chargeMultiplierScalar: number
(double)
Enter the number of basis options that go with each amount in the Unit field.
-
chargeQualifier1: string
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.
-
chargeQualifier2: string
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.
-
chargeSequence: number
(int64)
Charge sequence controls, in the order that the costs are calculated. Charge Sequence 1 is calculated before Charge Sequence 2.
-
chargeType: string
There are the following cost types:
Charge
Discount
External
Profile -
chargeUnitCount: number
(int64)
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.
-
chargeUnitCount2: number
(int64)
The number of basis options that go with each amount in the Unit field.
-
chargeUnitUomCode: string
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.
-
chargeUnitUomCode2: string
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.
-
costCategoryGid: string
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.
-
costCodeGid: string
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.
-
costType: string
Designates the type of the cost. C = Charge, D = Discount, P = Profile, E = External.
-
deficitCalculationsType: string
When to apply deficit calculations. Values are Y/N/P where Y = Yes, N = No, and P = Payant Pour
-
description: string
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.
-
dimRateFactorGid: string
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.
-
distanceQualifier: string
Identifies the distance unit for the tariff. Informational. Values ( A/B/D/F/K/L/M/T/X).
-
domainName: string
Database domain where this data is stored.
-
effectiveDate:
effectiveDate
Date the rate is effective from.
-
exParte: string
Stores information related to the authority/government agency that relates to this rate.
-
expirationDate:
expirationDate
Date the rate expires, and should no longer be considered for planning.
-
externalRatingEngineGid: string
For a cost type of E, specifies the external rating engine GID.
-
extReFieldsetGid: string
For external rating engine GIDs of type GENERIC, this specifies the fieldset used to call out to the external engine.
-
highValue1: string
Operand value high value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div> =>
-
highValue2: string
Operand value high value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div> =>
-
highValue3: string
Operand value high value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div> =>
-
highValue4: string
Operand value high value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div> =>
-
isFiledAsTariff: boolean
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.
-
leftOperand1: string
The operator for the conditional. For example, <=: less than or equal to,>: Greater than, <: less than,>=: Greater than or equal to, =: Equal to etc.=:>
-
leftOperand2: string
The operator for the conditional. For example, <=: less than or equal to,>: Greater than, <: less than,>=: Greater than or equal to, =: Equal to etc.=:>
-
leftOperand3: string
The operator for the conditional. For example, <=: less than or equal to,>: Greater than, <: less than,>=: Greater than or equal to, =: Equal to etc.=:>
-
leftOperand4: string
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: array
links
Read Only:
true
-
logicParamQualGid: string
For a cost type of L, specifies the logic parameter qualifier (of type Currency) which contains the cost value used as the charge multiplier.
-
lowValue1: string
Operand value or low value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div> =>
-
lowValue2: string
Operand value or low value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div> =>
-
lowValue3: string
Operand value or low value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div> =>
-
lowValue4: string
Operand value or low value if the operand requires low/high values. For example where the operator is between: value1 < Basis <= value2.< div> =>
-
maxCost:
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:
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.
-
oper1Gid: string
The GID for the operator.
-
oper2Gid: string
The GID for the operator.
-
oper3Gid: string
The GID for the operator.
-
oper4Gid: string
The GID for the operator.
-
operandQualifier1: string
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.
-
operandQualifier2: string
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.
-
operandQualifier3: string
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.
-
operandQualifier4: string
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.
-
paymentMethodCodeGid: string
The minimum charge in the base currency.
-
rateBasisNumber: string
The mileage factor published for rating purposes. This number is qualified by the rate basis qualifier. An informational field.
-
rateBasisQualifier: string
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).
-
rateGeoCostOperandSeq: number
(double)
Internal sequencing number for costs operand.
-
rateGeoCostSeq: number
(int64)
An internal sequencing number for costs defined on a rate.
-
rateUnitBreakProfile2Gid: string
The secondary rate unit break profile. It cannot have a value if the main profile GID is NULL.
-
rateUnitBreakProfileGid: string
The main rate unit break profile.
-
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.
-
tariffColumn: string
A commodity classification that is used, as a means of control, for grouping of commodities in tariff applications.
-
tariffDistance:
tariffDistance
The distance on which the rate is based.
-
tariffFreightClassCode: string
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.
-
tariffItemNumber: string
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.
-
tariffItemNumberSuffix: string
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.
-
tariffItemPart: string
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).
-
tariffSection: string
The tariff section is the first division of granularity of a tariff and describes where the rate can be found. An informational field.
-
tier: number
(int32)
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 : 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 : currencyType
Type:
Show Source
object
-
currency: string
ISO 4217 currency code
-
value: number
Numeric value that specifies a currency
Nested Schema : amountType
Type:
Show Source
object
-
unit: string
Unit of measure
-
value: number
Numeric value that specifies an amount