FinanceKey · Schema

FinanceKey.Entity.ApprovalPkg.v_ApprovalRequest

FinanceTreasuryArtificial IntelligencePaymentsCash Management

Properties

Name Type Description
createdById integernull The identity of the account that created the initial record.
createdOn string The date and time the record was initially created.
updatedById integernull The identity of the account that last modified the record.
updateOn string The date and time the record was last modified.
closedById integernull The identity of the account that deactivated and closed the record.
closedOn string The date and time the record is to be considered as inactive and closed.
active boolean A flag that shows if the record is currently active. This values is calculated based on the current date and the record closed date.
rowVersion stringnull A unique version stamp of the record.
sessionId stringnull The identity of the session that last modified the record.
approvalRequestId integer The ApprovalRequestId is an identity field located within the ApprovalRequest table and is of the data type int. This field serves as a unique identifier for each approval request created within the s
approvalTemplateId integer The ApprovalTemplateId is an integer field that is used to identify and link a specific approval template to an approval request in the ApprovalRequest table. This field allows for streamlined and org
itemId stringnull The ItemId field is a column in the ApprovalRequest table that stores a unique identifier for an item. It is of the data type nvarchar, meaning it can hold alphanumeric characters, and has a maximum l
intItemId integernull The IntItemId field in the ApprovalRequest table is of data type int and serves as a unique identifier for each request. This field allows for easy tracking and management of approval requests within
json string The Json field in the ApprovalRequest table is of data type nvarchar, which allows for the storage of string values in JSON format. This format is commonly used for web-based and mobile applications a
approvalRequestStateId stringnull The ApprovalRequestStateId field in the ApprovalRequest table is a nvarchar data type with a maximum length of 32 characters. It stores the unique identifier of the current state of an approval reques
comment stringnull Miscellaneous notes and information for the entry or record.
fullyApprovedById integernull The FullyApprovedById field is of type int and is included in the ApprovalRequest table. This field serves to store the unique identification number of the user who fully approved a request. This fiel
fullyApprovedOn stringnull The FullyApprovedOn field in the ApprovalRequest table is a datetime2 data type that specifies the date and time that an approval request is fully processed and approved. This field is crucial for tra
partiallyApprovedById integernull The PartiallyApprovedById field in the ApprovalRequest table is used to store the ID of the individual who partially approved a request. This data type is integer, which allows for the storage of nume
partiallyApprovedOn stringnull The PartiallyApprovedOn field in the ApprovalRequest table is a datetime2 data type that records the date and time at which a request was partially approved. This field is used to track the progress o
fullyApprovedBySystemAccountId integernull The FullyApprovedBySystemAccountId field in the ApprovalRequest table is an integer data type that represents the unique identifier of the system account responsible for fully approving a request for
approvalTemplateEntityId stringnull The `ApprovalTemplateEntityId` field in the `ApprovalRequest` table is a string identifier represented as an `nvarchar` data type, allowing for a maximum length of 450 characters. This field is used t
partiallyApprovedBySystemAccountId integernull The PartiallyApprovedBySystemAccountId field in the ApprovalRequest table is a data type consisting of an integer, which is used to track the partial approval status by the system for a specific accou
View JSON Schema on GitHub

JSON Schema

financekey-finance-key-entity-approval-pkg-v-approval-request-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://artifacts.apis.io/financekey/json-schema/financekey-finance-key-entity-approval-pkg-v-approval-request-schema.json",
  "title": "FinanceKey.Entity.ApprovalPkg.v_ApprovalRequest",
  "x-generated": "2026-11-10",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/financekey-approvals-api-openapi.yml#/components/schemas/FinanceKey.Entity.ApprovalPkg.v_ApprovalRequest",
  "required": [
    "json"
  ],
  "type": "object",
  "properties": {
    "createdById": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The identity of the account that created the initial record.",
      "format": "int32",
      "readOnly": true
    },
    "createdOn": {
      "type": "string",
      "description": "The date and time the record was initially created.",
      "format": "date-time",
      "readOnly": true
    },
    "updatedById": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The identity of the account that last modified the record.",
      "format": "int32",
      "readOnly": true
    },
    "updateOn": {
      "type": "string",
      "description": "The date and time the record was last modified.",
      "format": "date-time",
      "readOnly": true
    },
    "closedById": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The identity of the account that deactivated and closed the record.",
      "format": "int32",
      "readOnly": true
    },
    "closedOn": {
      "type": "string",
      "description": "The date and time the record is to be considered as inactive and closed.",
      "format": "date-time",
      "readOnly": true
    },
    "active": {
      "type": "boolean",
      "description": "A flag that shows if the record is currently active. This values is calculated based on the current date and the record closed date.",
      "readOnly": true
    },
    "rowVersion": {
      "type": [
        "string",
        "null"
      ],
      "description": "A unique version stamp of the record.",
      "format": "byte",
      "readOnly": true
    },
    "sessionId": {
      "type": [
        "string",
        "null"
      ],
      "description": "The identity of the session that last modified the record.",
      "readOnly": true
    },
    "approvalRequestId": {
      "type": "integer",
      "description": "The ApprovalRequestId is an identity field located within the ApprovalRequest table and is of the data type int. This field serves as a unique identifier for each approval request created within the system. It is automatically generated, incrementing in value with each new approval request, and cannot be modified or duplicated. This field is essential for tracking and managing approval requests, providing a quick and easy way to reference and retrieve specific requests. It also ensures the integrity of the data within the table, as it guarantees the uniqueness of each approval request.",
      "format": "int32"
    },
    "approvalTemplateId": {
      "type": "integer",
      "description": "The ApprovalTemplateId is an integer field that is used to identify and link a specific approval template to an approval request in the ApprovalRequest table. This field allows for streamlined and organized tracking of different approval processes and their associated templates. It serves as a unique identifier for each approval template within the table, allowing for efficient retrieval and management of approval requests. The data stored in this field is essential for ensuring that the correct approval processes are initiated, executed, and recorded for each request.",
      "format": "int32"
    },
    "itemId": {
      "maxLength": 64,
      "type": [
        "string",
        "null"
      ],
      "description": "The ItemId field is a column in the ApprovalRequest table that stores a unique identifier for an item. It is of the data type nvarchar, meaning it can hold alphanumeric characters, and has a maximum length of 64 characters. This field is essential for tracking and identifying each individual item in the approval request process. It allows for efficient searching and sorting of requests and ensures accurate and organized record-keeping."
    },
    "intItemId": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The IntItemId field in the ApprovalRequest table is of data type int and serves as a unique identifier for each request. This field allows for easy tracking and management of approval requests within the database. It is a numerical value that is automatically assigned to each new request and can be used as a reference when retrieving or updating specific requests. The use of this field ensures that each request is uniquely identified and facilitates efficient processing of multiple requests.",
      "format": "int32"
    },
    "json": {
      "minLength": 1,
      "type": "string",
      "description": "The Json field in the ApprovalRequest table is of data type nvarchar, which allows for the storage of string values in JSON format. This format is commonly used for web-based and mobile applications as it allows for the easy exchange of data between systems. The Json field allows for the storage of complex and nested data structures, making it ideal for recording and organizing data related to approval requests. This field will aid in the efficient processing and retrieval of data, improving the overall functionality and performance of the ApprovalRequest table."
    },
    "approvalRequestStateId": {
      "maxLength": 32,
      "type": [
        "string",
        "null"
      ],
      "description": "The ApprovalRequestStateId field in the ApprovalRequest table is a nvarchar data type with a maximum length of 32 characters. It stores the unique identifier of the current state of an approval request. This field is used to track the progress of an approval request, from the initial submission to the final decision. It allows for efficient management and monitoring of approval processes within the organization. The ApprovalRequestStateId field plays a crucial role in ensuring smooth and timely completion of approval requests."
    },
    "comment": {
      "type": [
        "string",
        "null"
      ],
      "description": "Miscellaneous notes and information for the entry or record."
    },
    "fullyApprovedById": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The FullyApprovedById field is of type int and is included in the ApprovalRequest table. This field serves to store the unique identification number of the user who fully approved a request. This field can be used to track and reference the specific user who gave final approval for a particular request. The data type int allows for efficient storage and retrieval of numeric values, making it suitable for use in this type of field.",
      "format": "int32"
    },
    "fullyApprovedOn": {
      "type": [
        "string",
        "null"
      ],
      "description": "The FullyApprovedOn field in the ApprovalRequest table is a datetime2 data type that specifies the date and time that an approval request is fully processed and approved. This field is crucial for tracking the progress of approval requests and ensuring that all necessary steps have been completed before final approval is granted. The fully approved date and time could also be used for auditing purposes, providing a clear record of when the request was approved. This field is essential for organizations that require a thorough and documented approval process for various operations or projects.",
      "format": "date-time"
    },
    "partiallyApprovedById": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The PartiallyApprovedById field in the ApprovalRequest table is used to store the ID of the individual who partially approved a request. This data type is integer, which allows for the storage of numerical values. This field is important for tracking and recording the partial approval of requests, as it allows for easy identification of the approving party. This field is also useful for tracking the progress of requests, as it provides insight into which requests have been partially approved. The PartiallyApprovedById field in the ApprovalRequest table is an essential component in efficiently managing and monitoring the approval process of requests.",
      "format": "int32"
    },
    "partiallyApprovedOn": {
      "type": [
        "string",
        "null"
      ],
      "description": "The PartiallyApprovedOn field in the ApprovalRequest table is a datetime2 data type that records the date and time at which a request was partially approved. This field is used to track the progress of approval requests and contains a timestamp that indicates when a partial approval was granted. This information can be useful in tracking the status of requests and identifying any potential delays in the approval process. The PartiallyApprovedOn field can also be used for auditing purposes, providing a record of when partial approvals were given. Overall, this field provides important data for managing and analyzing approval requests in an efficient and organized manner.",
      "format": "date-time"
    },
    "fullyApprovedBySystemAccountId": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The FullyApprovedBySystemAccountId field in the ApprovalRequest table is an integer data type that represents the unique identifier of the system account responsible for fully approving a request for approval. This field is used to track the automated approval process and ensures that the request has been fully reviewed and approved by the system before proceeding with the next steps. It allows for easy tracking and verification of the approval process by identifying which system account has given the final approval. This field is important for maintaining accuracy and efficiency in the approval workflow and is a crucial data point in the process.",
      "format": "int32"
    },
    "approvalTemplateEntityId": {
      "maxLength": 450,
      "type": [
        "string",
        "null"
      ],
      "description": "The `ApprovalTemplateEntityId` field in the `ApprovalRequest` table is a string identifier represented as an `nvarchar` data type, allowing for a maximum length of 450 characters. This field is used to uniquely associate an approval request with a specific approval template entity, facilitating streamlined management and retrieval of approval processes within the system. It helps ensure integrity and traceability of the approval workflow by linking requests to predefined templates that dictate the criteria and procedures for approval."
    },
    "partiallyApprovedBySystemAccountId": {
      "type": [
        "integer",
        "null"
      ],
      "description": "The PartiallyApprovedBySystemAccountId field in the ApprovalRequest table is a data type consisting of an integer, which is used to track the partial approval status by the system for a specific account within the system. This field allows users to view the partially approved requests made by the system for this specific account, providing valuable insights into the progress of the approvals. By tracking the partial approvals made by the system, users can better understand the overall approval process and make more informed decisions. This field plays a crucial role in maintaining the integrity and accuracy of the approval process within the system.",
      "format": "int32"
    }
  },
  "additionalProperties": false
}

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/financekey-finance-key-entity-approval-pkg-v-approval-request"
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.