Retrieve Equipment Rates by Code

19 Jun 2024
5 Minutes to read

Print
Dark
Light

Retrieve Equipment Rates by Code

Updated on 19 Jun 2024
5 Minutes to read

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback

Get

/em-rest-api/rest/1/emeqprates

Query Standards

Finder

Following row finders are available for data filtering and optimizing request performance.

Select by Equipment Rates
Select by Audit Date
By UUID

Select by Equipment Rates

Recommended finder parameters. Refer to Query Parameters for example.

Parameter	Description	Sample
CompCode	Company Code	001
TranCode	Transaction Code	ACHR
StartDate	Start Date	2016-01-01
EndDate	End Date	2018-02-21

Select by Audit Date

This is an optional finder for querying equipment rates by Audit Date.

Parameter	Description	Sample
AuditDate	create or update date time filter	2022-12-20

By UUID

This is an optional finder for querying a specific equipment rate by row ID.

Parameter	Description	Sample
/VUUID	The VUuid attribute is the Unique row ID	/em-rest-api/rest/1/emeqprate/AAAXkTAAIAAJJsLAAj

Security

HTTP

Type basic

Basic authentication

Query parameters

finder

string

ExampleselectEqpRates;CompCode=001,TranCode=ACHR,StartDate=2016-01-01,EndDate=2018-12-31

limit

integer

Example500

offset

integer

Example0

totalResults

boolean

Exampletrue

orderBy

string

ExampleEmetEqpCode:desc

Responses

200

Headers

Content-Type

string

Exampleapplication/vnd.oracle.adf.resourcecollection+json

example-0

Successful Response - Finder - selectEqpRates

{
  "items": [
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 900,
      "EmetEndDate": "2018-12-31",
      "EmetEqpCode": "1001-01-01",
      "EmetEqpName": "CAT Excavator 336",
      "EmetEqpOraseq": 26311,
      "EmetEtOraseq": 66843553,
      "EmetHrlyChargeAmt": 120,
      "EmetIuCreateDate": "2017-02-01T03:26:25Z",
      "EmetIuCreateUser": "ADWAIT",
      "EmetIuUpdateDate": null,
      "EmetIuUpdateUser": null,
      "EmetMonthlyChargeAmt": 5500,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJsMAAC",
      "EmetStartDate": "2016-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "ACHR",
      "EmetTrancodeName": "Auto Charge",
      "EmetTrancodeOraseq": 26142,
      "EmetWeeklyChargeAmt": 1700,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAC",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAC",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    },
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 700,
      "EmetEndDate": "2018-12-31",
      "EmetEqpCode": "055033",
      "EmetEqpName": "LULL 19617 FORKLIFT",
      "EmetEqpOraseq": 26321,
      "EmetEtOraseq": 66843513,
      "EmetHrlyChargeAmt": 80,
      "EmetIuCreateDate": "2017-02-01T03:26:21Z",
      "EmetIuCreateUser": "ADWAIT",
      "EmetIuUpdateDate": null,
      "EmetIuUpdateUser": null,
      "EmetMonthlyChargeAmt": 4500,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJsLAAe",
      "EmetStartDate": "2016-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "ACHR",
      "EmetTrancodeName": "Auto Charge",
      "EmetTrancodeOraseq": 26142,
      "EmetWeeklyChargeAmt": 1500,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAe",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAe",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    },
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 600,
      "EmetEndDate": "2018-12-31",
      "EmetEqpCode": "100020",
      "EmetEqpName": "Backhoe",
      "EmetEqpOraseq": 26344,
      "EmetEtOraseq": 66843589,
      "EmetHrlyChargeAmt": 70,
      "EmetIuCreateDate": "2017-02-01T03:26:25Z",
      "EmetIuCreateUser": "ADWAIT",
      "EmetIuUpdateDate": null,
      "EmetIuUpdateUser": null,
      "EmetMonthlyChargeAmt": 4200,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJsMAAR",
      "EmetStartDate": "2016-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "ACHR",
      "EmetTrancodeName": "Auto Charge",
      "EmetTrancodeOraseq": 26142,
      "EmetWeeklyChargeAmt": 1600,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAR",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAR",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    },
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 750,
      "EmetEndDate": "2018-12-31",
      "EmetEqpCode": "078009",
      "EmetEqpName": "LOWBOY TAG-A-LONG WITH TRUCK",
      "EmetEqpOraseq": 225545,
      "EmetEtOraseq": 66843565,
      "EmetHrlyChargeAmt": 80,
      "EmetIuCreateDate": "2017-02-01T03:26:25Z",
      "EmetIuCreateUser": "ADWAIT",
      "EmetIuUpdateDate": null,
      "EmetIuUpdateUser": null,
      "EmetMonthlyChargeAmt": 4800,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJsMAAH",
      "EmetStartDate": "2016-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "ACHR",
      "EmetTrancodeName": "Auto Charge",
      "EmetTrancodeOraseq": 26142,
      "EmetWeeklyChargeAmt": 1550,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAH",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAH",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    },
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 650,
      "EmetEndDate": "2018-12-31",
      "EmetEqpCode": "100050",
      "EmetEqpName": "BACKHOE BUCKET - 12\"",
      "EmetEqpOraseq": 225565,
      "EmetEtOraseq": 66843541,
      "EmetHrlyChargeAmt": 75,
      "EmetIuCreateDate": "2017-02-01T03:26:25Z",
      "EmetIuCreateUser": "ADWAIT",
      "EmetIuUpdateDate": null,
      "EmetIuUpdateUser": null,
      "EmetMonthlyChargeAmt": 4500,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJsLAAo",
      "EmetStartDate": "2016-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "ACHR",
      "EmetTrancodeName": "Auto Charge",
      "EmetTrancodeOraseq": 26142,
      "EmetWeeklyChargeAmt": 1700,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAo",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAo",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    },
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 500,
      "EmetEndDate": "2018-12-31",
      "EmetEqpCode": "013065",
      "EmetEqpName": "SUPER SAWZALL",
      "EmetEqpOraseq": 225521,
      "EmetEtOraseq": 66842550,
      "EmetHrlyChargeAmt": 50,
      "EmetIuCreateDate": "2017-02-01T03:14:26Z",
      "EmetIuCreateUser": "ADWAIT",
      "EmetIuUpdateDate": null,
      "EmetIuUpdateUser": null,
      "EmetMonthlyChargeAmt": 3800,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJsLAAZ",
      "EmetStartDate": "2016-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "ACHR",
      "EmetTrancodeName": "Auto Charge",
      "EmetTrancodeOraseq": 26142,
      "EmetWeeklyChargeAmt": 1350,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAZ",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAZ",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    },
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 800,
      "EmetEndDate": "2018-12-31",
      "EmetEqpCode": "078006",
      "EmetEqpName": "GOOSENECK TRAILER WITH TRACTOR",
      "EmetEqpOraseq": 225541,
      "EmetEtOraseq": 66843577,
      "EmetHrlyChargeAmt": 100,
      "EmetIuCreateDate": "2017-02-01T03:26:25Z",
      "EmetIuCreateUser": "ADWAIT",
      "EmetIuUpdateDate": null,
      "EmetIuUpdateUser": null,
      "EmetMonthlyChargeAmt": 5500,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJsMAAM",
      "EmetStartDate": "2016-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "ACHR",
      "EmetTrancodeName": "Auto Charge",
      "EmetTrancodeOraseq": 26142,
      "EmetWeeklyChargeAmt": 1800,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAM",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsMAAM",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 7,
  "hasMore": false,
  "limit": 50,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates",
      "name": "emeqprates",
      "kind": "collection"
    }
  ]
}

example-1

Successful Response - Finder - selectByAuditDate

{
  "items": [
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 150,
      "EmetEndDate": "2020-12-31",
      "EmetEqpCode": "100024",
      "EmetEqpName": "FORD F250 PICKUP",
      "EmetEqpOraseq": 26332,
      "EmetEtOraseq": 66843529,
      "EmetHrlyChargeAmt": 80,
      "EmetIuCreateDate": "2017-02-01T03:26:25Z",
      "EmetIuCreateUser": "ADWAIT",
      "EmetIuUpdateDate": "2020-08-11T05:05:09Z",
      "EmetIuUpdateUser": "CANDICE",
      "EmetMonthlyChargeAmt": 2000,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJsLAAj",
      "EmetStartDate": "2016-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "ACHR",
      "EmetTrancodeName": "Auto Charge",
      "EmetTrancodeOraseq": 26142,
      "EmetWeeklyChargeAmt": 350,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAj",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJsLAAj",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    },
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 800,
      "EmetEndDate": "2018-12-31",
      "EmetEqpCode": "100133",
      "EmetEqpName": "Grove Rough Terrain Crane",
      "EmetEqpOraseq": 26858,
      "EmetEtOraseq": 130764242,
      "EmetHrlyChargeAmt": 100,
      "EmetIuCreateDate": "2018-01-03T01:21:12Z",
      "EmetIuCreateUser": "MARKB",
      "EmetIuUpdateDate": "2018-01-03T01:31:52Z",
      "EmetIuUpdateUser": "MARKB",
      "EmetMonthlyChargeAmt": 5000,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJgvAAE",
      "EmetStartDate": "2017-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "ACHR",
      "EmetTrancodeName": "Auto Charge",
      "EmetTrancodeOraseq": 26142,
      "EmetWeeklyChargeAmt": 1700,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJgvAAE",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJgvAAE",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    },
    {
      "DiscriminatorCode": null,
      "EmetActiveRateFlag": "Y",
      "EmetAddChargeAmt": 0,
      "EmetAmountType": "C",
      "EmetCompCode": "001",
      "EmetDailyChargeAmt": 900,
      "EmetEndDate": "2017-12-31",
      "EmetEqpCode": "055033",
      "EmetEqpName": "LULL 19617 FORKLIFT",
      "EmetEqpOraseq": 26321,
      "EmetEtOraseq": 87651096,
      "EmetHrlyChargeAmt": 100,
      "EmetIuCreateDate": "2017-06-16T12:37:13Z",
      "EmetIuCreateUser": "CANDICE",
      "EmetIuUpdateDate": null,
      "EmetIuUpdateUser": null,
      "EmetMonthlyChargeAmt": 5000,
      "EmetParentType": "EMEQP",
      "EmetRowid": "AAAXkTAAIAAJJuQAAF",
      "EmetStartDate": "2016-01-01",
      "EmetTenantId": "VF389BTEQP11127",
      "EmetTrancodeCode": "WORK",
      "EmetTrancodeName": "Work Time",
      "EmetTrancodeOraseq": 26153,
      "EmetWeeklyChargeAmt": 1800,
      "EmetWmCode": "$",
      "EmetWmName": "Dollars",
      "links": [
        {
          "rel": "self",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJuQAAF",
          "name": "emeqprates",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates/AAAXkTAAIAAJJuQAAF",
          "name": "emeqprates",
          "kind": "item"
        }
      ]
    }
  ],
  "count": 3,
  "hasMore": false,
  "limit": 50,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "http://mobtest.cmiccloudr12.com:80/cmictestrti/em-rest-api/rest/1/emeqprates",
      "name": "emeqprates",
      "kind": "collection"
    }
  ]
}

object

What's Next

Create a Location Transfer

Retrieve Equipment Rates by Code

Query Standards

Finder

Select by Equipment Rates

Select by Audit Date

By UUID

What's Next

Contact Us