Trimble · Schema

data_automatic_earnings_withKeys

ConstructionTransportationGeospatialGPSMappingBIMFleet ManagementCollaborationAgriculture

Properties

Name Type Description
__ryvitKeys array Array of key paths that can be used to retrieve this object.
__modifiedUTC string UTC timestamp of when this object was last modified in the cache.
PRCo integer Payroll Company ID
Employee integer Employee ID
EarnCode integer Earning or Deduction Code
Seq integer Sequence
PaySeq integernull Pay Sequence
PRDept stringnull Payroll Department
InsCode stringnull Insurance Code
Craft stringnull Craft
Class stringnull Class
JCCo integernull Job Cost Company ID
Job stringnull Job ID
PhaseGroup integernull Phase Group
Phase stringnull Phase
GLCo integernull GL Company ID
EMCo integernull Equipment Management Company ID
Equipment stringnull Equipment ID
EMGroup integernull Equipment Management Group
RevCode stringnull Revenue Code
UsageUnits stringnull Usage Units
StdHours string Standard Hours Flag
Hours stringnull Hours
RateAmt string Rate Amount
LimitOvrAmt string Limit Override Amount
Frequency string Frequency
Notes stringnull Notes
OvrStdLimitYN string Override Standard Limit Y/N
UniqueAttchID stringnull Unique Attachment ID
MechanicsCC stringnull Mechanics Cost Code
EquipMechOpt string Equipment Mechanic Option
KeyID integer Key ID - likely a surrogate key
UseRegRate string Use Regular Rate Y/N
__custom_fields object This property will be added if there are any custom fields defined for this object in Vista. Each custom field will be a property of this object.
View JSON Schema on GitHub

JSON Schema

trimble-data-automatic-earnings-with-keys-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://artifacts.apis.io/trimble/json-schema/trimble-data-automatic-earnings-with-keys-schema.json",
  "title": "data_automatic_earnings_withKeys",
  "x-generated": "2026-11-11",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/trimble-vista-pr-openapi.yml#/components/schemas/data_automatic_earnings_withKeys",
  "allOf": [
    {
      "type": "object",
      "properties": {
        "__ryvitKeys": {
          "type": "array",
          "items": {
            "type": "string"
          },
          "description": "Array of key paths that can be used to retrieve this object."
        },
        "__modifiedUTC": {
          "type": "string",
          "description": "UTC timestamp of when this object was last modified in the cache."
        }
      }
    },
    {
      "$ref": "#/$defs/data_automatic_earnings"
    }
  ],
  "$defs": {
    "data_automatic_earnings": {
      "title": "Automatic Earnings Cache Record Schema",
      "required": [
        "PRCo",
        "Employee",
        "EarnCode",
        "Seq",
        "StdHours",
        "RateAmt",
        "LimitOvrAmt",
        "Frequency",
        "OvrStdLimitYN",
        "EquipMechOpt",
        "KeyID",
        "UseRegRate"
      ],
      "type": "object",
      "properties": {
        "PRCo": {
          "maximum": 255,
          "minimum": 0,
          "type": "integer",
          "description": "Payroll Company ID"
        },
        "Employee": {
          "type": "integer",
          "description": "Employee ID"
        },
        "EarnCode": {
          "type": "integer",
          "description": "Earning or Deduction Code"
        },
        "Seq": {
          "maximum": 255,
          "minimum": 0,
          "type": "integer",
          "description": "Sequence"
        },
        "PaySeq": {
          "maximum": 255,
          "minimum": 0,
          "type": [
            "integer",
            "null"
          ],
          "description": "Pay Sequence"
        },
        "PRDept": {
          "maxLength": 10,
          "type": [
            "string",
            "null"
          ],
          "description": "Payroll Department"
        },
        "InsCode": {
          "maxLength": 10,
          "type": [
            "string",
            "null"
          ],
          "description": "Insurance Code"
        },
        "Craft": {
          "maxLength": 10,
          "type": [
            "string",
            "null"
          ],
          "description": "Craft"
        },
        "Class": {
          "maxLength": 10,
          "type": [
            "string",
            "null"
          ],
          "description": "Class"
        },
        "JCCo": {
          "maximum": 255,
          "minimum": 0,
          "type": [
            "integer",
            "null"
          ],
          "description": "Job Cost Company ID"
        },
        "Job": {
          "maxLength": 10,
          "type": [
            "string",
            "null"
          ],
          "description": "Job ID"
        },
        "PhaseGroup": {
          "maximum": 255,
          "minimum": 0,
          "type": [
            "integer",
            "null"
          ],
          "description": "Phase Group"
        },
        "Phase": {
          "maxLength": 20,
          "type": [
            "string",
            "null"
          ],
          "description": "Phase"
        },
        "GLCo": {
          "maximum": 255,
          "minimum": 0,
          "type": [
            "integer",
            "null"
          ],
          "description": "GL Company ID"
        },
        "EMCo": {
          "maximum": 255,
          "minimum": 0,
          "type": [
            "integer",
            "null"
          ],
          "description": "Equipment Management Company ID"
        },
        "Equipment": {
          "maxLength": 10,
          "type": [
            "string",
            "null"
          ],
          "description": "Equipment ID"
        },
        "EMGroup": {
          "maximum": 255,
          "minimum": 0,
          "type": [
            "integer",
            "null"
          ],
          "description": "Equipment Management Group"
        },
        "RevCode": {
          "maxLength": 10,
          "type": [
            "string",
            "null"
          ],
          "description": "Revenue Code"
        },
        "UsageUnits": {
          "pattern": "^[-+]?[0-9]{1,8}(?:.[0-9]{0,2})?$",
          "type": [
            "string",
            "null"
          ],
          "description": "Usage Units"
        },
        "StdHours": {
          "enum": [
            "Y",
            "N"
          ],
          "type": "string",
          "description": "Standard Hours Flag"
        },
        "Hours": {
          "pattern": "^[-+]?[0-9]{1,8}(?:.[0-9]{0,2})?$",
          "type": [
            "string",
            "null"
          ],
          "description": "Hours"
        },
        "RateAmt": {
          "pattern": "^[-+]?[0-9]{1,11}(?:.[0-9]{0,5})?$",
          "type": "string",
          "description": "Rate Amount"
        },
        "LimitOvrAmt": {
          "pattern": "^[-+]?[0-9]{1,10}(?:.[0-9]{0,2})?$",
          "type": "string",
          "description": "Limit Override Amount"
        },
        "Frequency": {
          "maxLength": 10,
          "type": "string",
          "description": "Frequency"
        },
        "Notes": {
          "type": [
            "string",
            "null"
          ],
          "description": "Notes"
        },
        "OvrStdLimitYN": {
          "enum": [
            "Y",
            "N"
          ],
          "type": "string",
          "description": "Override Standard Limit Y/N"
        },
        "UniqueAttchID": {
          "maxLength": 36,
          "minLength": 36,
          "pattern": "[0-9a-fA-F]{8}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{4}\\-[0-9a-fA-F]{12}",
          "type": [
            "string",
            "null"
          ],
          "description": "Unique Attachment ID"
        },
        "MechanicsCC": {
          "maxLength": 10,
          "type": [
            "string",
            "null"
          ],
          "description": "Mechanics Cost Code"
        },
        "EquipMechOpt": {
          "maxLength": 1,
          "type": "string",
          "description": "Equipment Mechanic Option"
        },
        "KeyID": {
          "type": "integer",
          "description": "Key ID - likely a surrogate key"
        },
        "UseRegRate": {
          "enum": [
            "Y",
            "N"
          ],
          "type": "string",
          "description": "Use Regular Rate Y/N"
        },
        "__custom_fields": {
          "type": "object",
          "description": "This property will be added if there are any custom fields defined for this object in Vista. Each custom field will be a property of this object."
        }
      },
      "description": "Schema for a single record from the dbo.PRAE table, intended for cache validation."
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/trimble-data-automatic-earnings-with-keys"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"

Calls without X-API-Key need no key. Calls with it need a paid plan — get a key.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.