Finance ledger version v1.1
https://github.com/folio-org/mod-finance
Ledger API
This documents the API calls that can be made to manage ledgers
Finance ledger
Finance ledger APIs
Create a new ledger item.
Retrieve a list of ledger items.
post /finance/ledgers
Create a new ledger item.
Body
Media type: application/json
Type: json
Content:
{
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "A financial ledger",
"type": "object",
"properties": {
"id": {
"description": "UUID of this ledger",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
},
"_version": {
"type": "integer",
"description": "Record version for optimistic locking"
},
"name": {
"description": "The name of the ledger",
"type": "string"
},
"code": {
"description": "The code for the ledger",
"type": "string"
},
"description": {
"description": "The description of the ledger",
"type": "string"
},
"fiscalYearOneId": {
"description": "UUID of the first fiscal year associated with this ledger",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
},
"ledgerStatus": {
"description": "The status of the ledger",
"type": "string",
"enum": [
"Active",
"Inactive",
"Frozen"
]
},
"allocated": {
"description": "The amount currently allocated to this ledger",
"type": "number",
"readonly": true
},
"available": {
"description": "The amount currently available in this ledger",
"type": "number",
"readonly": true
},
"netTransfers": {
"description": "Summing all the transfers from/to this ledger. Amount can be negative",
"type": "number",
"readonly": true
},
"unavailable": {
"description": "The amount already utilized from the allocated amount",
"type": "number",
"readonly": true
},
"currency": {
"description": "The ISO code for currency",
"type": "string"
},
"acqUnitIds": {
"description": "acquisition unit ids associated with this ledger",
"type": "array",
"items": {
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "The UUID format string",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
}
},
"restrictEncumbrance": {
"description": "If true, imposes restrictions on encumbrances",
"type": "boolean",
"default": true
},
"restrictExpenditures": {
"description": "If true, imposes restrictions on payments",
"type": "boolean",
"default": true
},
"metadata": {
"type": "object",
"readonly": true,
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "metadata.schema",
"title": "Metadata Schema",
"description": "Metadata about creation and changes to records, provided by the server (client should not provide)",
"properties": {
"createdDate": {
"description": "Date and time when the record was created",
"type": "string",
"format": "date-time"
},
"createdByUserId": {
"description": "ID of the user who created the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"createdByUsername": {
"description": "Username of the user who created the record (when available)",
"type": "string"
},
"updatedDate": {
"description": "Date and time when the record was last updated",
"type": "string",
"format": "date-time"
},
"updatedByUserId": {
"description": "ID of the user who last updated the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"updatedByUsername": {
"description": "Username of the user who last updated the record (when available)",
"type": "string"
}
},
"additionalProperties": false,
"required": [
"createdDate"
]
},
"initialAllocation": {
"description": "Summary of all related to this ledger budgets initialAllocation",
"type": "number",
"readonly": true
},
"allocationTo": {
"description": "Summary of all related to this ledger budgets allocationTo",
"type": "number",
"readonly": true
},
"allocationFrom": {
"description": "Summary of all related to this ledger budgets allocationFrom",
"type": "number",
"readonly": true
},
"totalFunding": {
"description": "Summary of all related to this ledger budgets totalFunding",
"type": "number",
"readonly": true
},
"cashBalance": {
"description": "Summary of all related to this ledger budgets cashBalance",
"type": "number",
"readonly": true
},
"awaitingPayment": {
"description": "Summary of all related to this ledger budgets awaitingPayment",
"type": "number",
"readonly": true
},
"credits": {
"description": "Summary of all related to this ledger budgets credits",
"type": "number",
"readonly": true
},
"encumbered": {
"description": "Summary of all related to this ledger budgets encumbered",
"type": "number",
"readonly": true
},
"expenditures": {
"description": "Summary of all related to this ledger budgets expenditures",
"type": "number",
"readonly": true
},
"overEncumbrance": {
"description": "Summary of all related to this ledger budgets overEncumbrance",
"type": "number",
"readonly": true
},
"overExpended": {
"description": "Summary of all related to this ledger budgets overExpended",
"type": "number",
"readonly": true
}
},
"additionalProperties": false,
"required": [
"name",
"code",
"fiscalYearOneId",
"ledgerStatus",
"restrictEncumbrance",
"restrictExpenditures"
]
}
Example:
{
"id": "7cef8378-7cbd-1fae-bcdd-8b9d7c0af9de",
"name": "Main Library",
"code": "MAIN-LIB",
"description": "This is the ledger for the Main Library",
"fiscalYearOneId": "d875618b-7cf5-442f-a823-9814e7bce92a",
"ledgerStatus": "Active",
"allocated": 24500,
"initialAllocation": 11000,
"allocationTo": 13500,
"allocationFrom": 0,
"available": 21990,
"netTransfers": 2500,
"unavailable": 10,
"credits": 1500,
"expenditures": 10,
"encumbered": 0,
"awaitingPayment": 0,
"overEncumbrance": 0,
"overExpended": 0,
"totalFunding": 22000,
"cashBalance": 21990,
"currency": "USD",
"restrictEncumbrance": false,
"restrictExpenditures": false,
"acqUnitIds": [
"ac2164c7-ba3d-1bc2-912c-e35ceccbfaf2"
]
}
HTTP status code 201
Returns a newly created item, with server-controlled fields like 'id' populated
Headers
- Location: required(string)
URI to the created ledger item
Body
Media type: application/json
Type: any
Example:
{
"id": "7cef8378-7cbd-1fae-bcdd-8b9d7c0af9de",
"name": "Main Library",
"code": "MAIN-LIB",
"description": "This is the ledger for the Main Library",
"fiscalYearOneId": "d875618b-7cf5-442f-a823-9814e7bce92a",
"ledgerStatus": "Active",
"allocated": 24500,
"initialAllocation": 11000,
"allocationTo": 13500,
"allocationFrom": 0,
"available": 21990,
"netTransfers": 2500,
"unavailable": 10,
"credits": 1500,
"expenditures": 10,
"encumbered": 0,
"awaitingPayment": 0,
"overEncumbrance": 0,
"overExpended": 0,
"totalFunding": 22000,
"cashBalance": 21990,
"currency": "USD",
"restrictEncumbrance": false,
"restrictExpenditures": false,
"acqUnitIds": [
"ac2164c7-ba3d-1bc2-912c-e35ceccbfaf2"
]
}
HTTP status code 400
Bad request, e.g. malformed request body or query parameter. Details of the error (e.g. name of the parameter or line/character number with malformed data) provided in the response.
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
"unable to add ledger -- malformed JSON at 13:3"
HTTP status code 401
Not authorized to perform requested action
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
unable to create ledgers -- unauthorized
HTTP status code 422
Validation errors
Body
Media type: application/json
Type: json
Content:
{
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "errors.schema",
"description": "A set of errors",
"type": "object",
"properties": {
"errors": {
"description": "List of errors",
"id": "errors",
"type": "array",
"items": {
"type": "object",
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "error.schema",
"description": "An error",
"properties": {
"message": {
"type": "string",
"description": "Error message text"
},
"type": {
"type": "string",
"description": "Error message type"
},
"code": {
"type": "string",
"description": "Error message code"
},
"parameters": {
"description": "Error message parameters",
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "parameters.schema",
"type": "array",
"items": {
"type": "object",
"properties": {
"key": {
"type": "string"
},
"value": {
"type": "string"
}
}
}
}
},
"required": [
"message"
]
}
},
"total_records": {
"description": "Total number of errors",
"type": "integer"
}
}
}
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
HTTP status code 500
Internal server error, e.g. due to misconfiguration
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
Internal server error, contact administrator
get /finance/ledgers
Retrieve a list of ledger items.
Query Parameters
- fiscalYear: (string - pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$)
Fiscal Year Id
Example:
3defdcde-3002-41d3-a31c-1fb88288f872
- totalRecords: (string - default: auto - pattern: exact|estimated|none|auto)
How to calculate the totalRecords property. "exact" for the correct number, "estimated" for an estimation, "auto" to automatically select "exact" or "estimated", "none" for suppressing the totalRecords property. For details see https://github.com/folio-org/raml-module-builder#estimated-totalrecords
Example:
none
- offset: (integer - default: 0 - minimum: 0 - maximum: 2147483647)
Skip over a number of elements by specifying an offset value for the query
Example:
0
- limit: (integer - default: 10 - minimum: 0 - maximum: 2147483647)
Limit the number of elements returned in the response. Using limit=0 will return totalRecords with the exact value. For details about totalRecords see https://github.com/folio-org/raml-module-builder#estimated-totalrecords
Example:
10
- query: (string)
A query expressed as a CQL string (see dev.folio.org/reference/glossary#cql) using valid searchable fields. The first example below shows the general form of a full CQL query, but those fields might not be relevant in this context.
with valid searchable fields: for example code
Example:
(username=="ab*" or personal.firstName=="ab*" or personal.lastName=="ab*") and active=="true" sortby personal.lastName personal.firstName barcode ["code", "MEDGRANT", "="]
HTTP status code 200
Returns a list of ledger items
Body
Media type: application/json
Type: json
Content:
{
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "A collection of ledgers",
"type": "object",
"properties": {
"ledgers": {
"description": "Collection of ledger records",
"type": "array",
"id": "ledgers",
"items": {
"type": "object",
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "A financial ledger",
"properties": {
"id": {
"description": "UUID of this ledger",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
},
"_version": {
"type": "integer",
"description": "Record version for optimistic locking"
},
"name": {
"description": "The name of the ledger",
"type": "string"
},
"code": {
"description": "The code for the ledger",
"type": "string"
},
"description": {
"description": "The description of the ledger",
"type": "string"
},
"fiscalYearOneId": {
"description": "UUID of the first fiscal year associated with this ledger",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
},
"ledgerStatus": {
"description": "The status of the ledger",
"type": "string",
"enum": [
"Active",
"Inactive",
"Frozen"
]
},
"allocated": {
"description": "The amount currently allocated to this ledger",
"type": "number",
"readonly": true
},
"available": {
"description": "The amount currently available in this ledger",
"type": "number",
"readonly": true
},
"netTransfers": {
"description": "Summing all the transfers from/to this ledger. Amount can be negative",
"type": "number",
"readonly": true
},
"unavailable": {
"description": "The amount already utilized from the allocated amount",
"type": "number",
"readonly": true
},
"currency": {
"description": "The ISO code for currency",
"type": "string"
},
"acqUnitIds": {
"description": "acquisition unit ids associated with this ledger",
"type": "array",
"items": {
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "The UUID format string",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
}
},
"restrictEncumbrance": {
"description": "If true, imposes restrictions on encumbrances",
"type": "boolean",
"default": true
},
"restrictExpenditures": {
"description": "If true, imposes restrictions on payments",
"type": "boolean",
"default": true
},
"metadata": {
"type": "object",
"readonly": true,
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "metadata.schema",
"title": "Metadata Schema",
"description": "Metadata about creation and changes to records, provided by the server (client should not provide)",
"properties": {
"createdDate": {
"description": "Date and time when the record was created",
"type": "string",
"format": "date-time"
},
"createdByUserId": {
"description": "ID of the user who created the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"createdByUsername": {
"description": "Username of the user who created the record (when available)",
"type": "string"
},
"updatedDate": {
"description": "Date and time when the record was last updated",
"type": "string",
"format": "date-time"
},
"updatedByUserId": {
"description": "ID of the user who last updated the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"updatedByUsername": {
"description": "Username of the user who last updated the record (when available)",
"type": "string"
}
},
"additionalProperties": false,
"required": [
"createdDate"
]
},
"initialAllocation": {
"description": "Summary of all related to this ledger budgets initialAllocation",
"type": "number",
"readonly": true
},
"allocationTo": {
"description": "Summary of all related to this ledger budgets allocationTo",
"type": "number",
"readonly": true
},
"allocationFrom": {
"description": "Summary of all related to this ledger budgets allocationFrom",
"type": "number",
"readonly": true
},
"totalFunding": {
"description": "Summary of all related to this ledger budgets totalFunding",
"type": "number",
"readonly": true
},
"cashBalance": {
"description": "Summary of all related to this ledger budgets cashBalance",
"type": "number",
"readonly": true
},
"awaitingPayment": {
"description": "Summary of all related to this ledger budgets awaitingPayment",
"type": "number",
"readonly": true
},
"credits": {
"description": "Summary of all related to this ledger budgets credits",
"type": "number",
"readonly": true
},
"encumbered": {
"description": "Summary of all related to this ledger budgets encumbered",
"type": "number",
"readonly": true
},
"expenditures": {
"description": "Summary of all related to this ledger budgets expenditures",
"type": "number",
"readonly": true
},
"overEncumbrance": {
"description": "Summary of all related to this ledger budgets overEncumbrance",
"type": "number",
"readonly": true
},
"overExpended": {
"description": "Summary of all related to this ledger budgets overExpended",
"type": "number",
"readonly": true
}
},
"additionalProperties": false,
"required": [
"name",
"code",
"fiscalYearOneId",
"ledgerStatus",
"restrictEncumbrance",
"restrictExpenditures"
]
}
},
"totalRecords": {
"description": "The number of objects contained in this collection",
"type": "integer"
}
},
"additionalProperties": false,
"required": [
"ledgers",
"totalRecords"
]
}
Example:
{
"ledgers": [
{
"id": "7cef8378-7cbd-1fae-bcdd-8b9d7c0af9de",
"name": "Main Library",
"code": "MAIN-LIB",
"description": "This is the ledger for the Main Library",
"fiscalYearOneId": "d875618b-7cf5-442f-a823-9814e7bce92a",
"ledgerStatus": "Active",
"currency": "USD",
"restrictEncumbrance": false,
"restrictExpenditures": false,
"acqUnitIds": [
"ac2164c7-ba3d-1bc2-b12c-e35ceccbfaf2"
]
}
],
"totalRecords": 1
}
HTTP status code 400
Bad request, e.g. malformed request body or query parameter. Details of the error (e.g. name of the parameter or line/character number with malformed data) provided in the response.
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
unable to list ledgers -- malformed parameter 'query', syntax error at column 6
HTTP status code 401
Not authorized to perform requested action
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
unable to list ledgers -- unauthorized
HTTP status code 500
Internal server error, e.g. due to misconfiguration
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
internal server error, contact administrator
Get, Delete or Update a specific ledger
Update ledger item with given {ledgerId}
Retrieve ledger item with given {ledgerId}
Delete ledger item with given {ledgerId}
put /finance/ledgers/{id}
Update ledger item with given {ledgerId}
URI Parameters
- id: required(string - pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$)
The UUID of a ledger
Body
Media type: application/json
Type: json
Content:
{
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "A financial ledger",
"type": "object",
"properties": {
"id": {
"description": "UUID of this ledger",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
},
"_version": {
"type": "integer",
"description": "Record version for optimistic locking"
},
"name": {
"description": "The name of the ledger",
"type": "string"
},
"code": {
"description": "The code for the ledger",
"type": "string"
},
"description": {
"description": "The description of the ledger",
"type": "string"
},
"fiscalYearOneId": {
"description": "UUID of the first fiscal year associated with this ledger",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
},
"ledgerStatus": {
"description": "The status of the ledger",
"type": "string",
"enum": [
"Active",
"Inactive",
"Frozen"
]
},
"allocated": {
"description": "The amount currently allocated to this ledger",
"type": "number",
"readonly": true
},
"available": {
"description": "The amount currently available in this ledger",
"type": "number",
"readonly": true
},
"netTransfers": {
"description": "Summing all the transfers from/to this ledger. Amount can be negative",
"type": "number",
"readonly": true
},
"unavailable": {
"description": "The amount already utilized from the allocated amount",
"type": "number",
"readonly": true
},
"currency": {
"description": "The ISO code for currency",
"type": "string"
},
"acqUnitIds": {
"description": "acquisition unit ids associated with this ledger",
"type": "array",
"items": {
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "The UUID format string",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
}
},
"restrictEncumbrance": {
"description": "If true, imposes restrictions on encumbrances",
"type": "boolean",
"default": true
},
"restrictExpenditures": {
"description": "If true, imposes restrictions on payments",
"type": "boolean",
"default": true
},
"metadata": {
"type": "object",
"readonly": true,
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "metadata.schema",
"title": "Metadata Schema",
"description": "Metadata about creation and changes to records, provided by the server (client should not provide)",
"properties": {
"createdDate": {
"description": "Date and time when the record was created",
"type": "string",
"format": "date-time"
},
"createdByUserId": {
"description": "ID of the user who created the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"createdByUsername": {
"description": "Username of the user who created the record (when available)",
"type": "string"
},
"updatedDate": {
"description": "Date and time when the record was last updated",
"type": "string",
"format": "date-time"
},
"updatedByUserId": {
"description": "ID of the user who last updated the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"updatedByUsername": {
"description": "Username of the user who last updated the record (when available)",
"type": "string"
}
},
"additionalProperties": false,
"required": [
"createdDate"
]
},
"initialAllocation": {
"description": "Summary of all related to this ledger budgets initialAllocation",
"type": "number",
"readonly": true
},
"allocationTo": {
"description": "Summary of all related to this ledger budgets allocationTo",
"type": "number",
"readonly": true
},
"allocationFrom": {
"description": "Summary of all related to this ledger budgets allocationFrom",
"type": "number",
"readonly": true
},
"totalFunding": {
"description": "Summary of all related to this ledger budgets totalFunding",
"type": "number",
"readonly": true
},
"cashBalance": {
"description": "Summary of all related to this ledger budgets cashBalance",
"type": "number",
"readonly": true
},
"awaitingPayment": {
"description": "Summary of all related to this ledger budgets awaitingPayment",
"type": "number",
"readonly": true
},
"credits": {
"description": "Summary of all related to this ledger budgets credits",
"type": "number",
"readonly": true
},
"encumbered": {
"description": "Summary of all related to this ledger budgets encumbered",
"type": "number",
"readonly": true
},
"expenditures": {
"description": "Summary of all related to this ledger budgets expenditures",
"type": "number",
"readonly": true
},
"overEncumbrance": {
"description": "Summary of all related to this ledger budgets overEncumbrance",
"type": "number",
"readonly": true
},
"overExpended": {
"description": "Summary of all related to this ledger budgets overExpended",
"type": "number",
"readonly": true
}
},
"additionalProperties": false,
"required": [
"name",
"code",
"fiscalYearOneId",
"ledgerStatus",
"restrictEncumbrance",
"restrictExpenditures"
]
}
Example:
{
"id": "7cef8378-7cbd-1fae-bcdd-8b9d7c0af9de",
"name": "Main Library",
"code": "MAIN-LIB",
"description": "This is the ledger for the Main Library",
"fiscalYearOneId": "d875618b-7cf5-442f-a823-9814e7bce92a",
"ledgerStatus": "Active",
"allocated": 24500,
"initialAllocation": 11000,
"allocationTo": 13500,
"allocationFrom": 0,
"available": 21990,
"netTransfers": 2500,
"unavailable": 10,
"credits": 1500,
"expenditures": 10,
"encumbered": 0,
"awaitingPayment": 0,
"overEncumbrance": 0,
"overExpended": 0,
"totalFunding": 22000,
"cashBalance": 21990,
"currency": "USD",
"restrictEncumbrance": false,
"restrictExpenditures": false,
"acqUnitIds": [
"ac2164c7-ba3d-1bc2-912c-e35ceccbfaf2"
]
}
HTTP status code 204
Item successfully updated
HTTP status code 400
Bad request, e.g. malformed request body or query parameter. Details of the error (e.g. name of the parameter or line/character number with malformed data) provided in the response.
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
"unable to update ledger -- malformed JSON at 13:4"
HTTP status code 404
Item with a given ID not found
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
"ledger not found"
HTTP status code 409
Optimistic locking version conflict
Body
Media type: text/plain
Type: any
Example:
version conflict
HTTP status code 422
Validation errors
Body
Media type: application/json
Type: json
Content:
{
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "errors.schema",
"description": "A set of errors",
"type": "object",
"properties": {
"errors": {
"description": "List of errors",
"id": "errors",
"type": "array",
"items": {
"type": "object",
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "error.schema",
"description": "An error",
"properties": {
"message": {
"type": "string",
"description": "Error message text"
},
"type": {
"type": "string",
"description": "Error message type"
},
"code": {
"type": "string",
"description": "Error message code"
},
"parameters": {
"description": "Error message parameters",
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "parameters.schema",
"type": "array",
"items": {
"type": "object",
"properties": {
"key": {
"type": "string"
},
"value": {
"type": "string"
}
}
}
}
},
"required": [
"message"
]
}
},
"total_records": {
"description": "Total number of errors",
"type": "integer"
}
}
}
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
HTTP status code 500
Internal server error, e.g. due to misconfiguration
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
internal server error, contact administrator
get /finance/ledgers/{id}
Retrieve ledger item with given {ledgerId}
URI Parameters
- id: required(string - pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$)
The UUID of a ledger
Query Parameters
- fiscalYear: required(string - pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$)
The UUID of a fiscal year
HTTP status code 200
Returns item with a given ID
Body
Media type: application/json
Type: json
Content:
{
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "A financial ledger",
"type": "object",
"properties": {
"id": {
"description": "UUID of this ledger",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
},
"_version": {
"type": "integer",
"description": "Record version for optimistic locking"
},
"name": {
"description": "The name of the ledger",
"type": "string"
},
"code": {
"description": "The code for the ledger",
"type": "string"
},
"description": {
"description": "The description of the ledger",
"type": "string"
},
"fiscalYearOneId": {
"description": "UUID of the first fiscal year associated with this ledger",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
},
"ledgerStatus": {
"description": "The status of the ledger",
"type": "string",
"enum": [
"Active",
"Inactive",
"Frozen"
]
},
"allocated": {
"description": "The amount currently allocated to this ledger",
"type": "number",
"readonly": true
},
"available": {
"description": "The amount currently available in this ledger",
"type": "number",
"readonly": true
},
"netTransfers": {
"description": "Summing all the transfers from/to this ledger. Amount can be negative",
"type": "number",
"readonly": true
},
"unavailable": {
"description": "The amount already utilized from the allocated amount",
"type": "number",
"readonly": true
},
"currency": {
"description": "The ISO code for currency",
"type": "string"
},
"acqUnitIds": {
"description": "acquisition unit ids associated with this ledger",
"type": "array",
"items": {
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "The UUID format string",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
}
},
"restrictEncumbrance": {
"description": "If true, imposes restrictions on encumbrances",
"type": "boolean",
"default": true
},
"restrictExpenditures": {
"description": "If true, imposes restrictions on payments",
"type": "boolean",
"default": true
},
"metadata": {
"type": "object",
"readonly": true,
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "metadata.schema",
"title": "Metadata Schema",
"description": "Metadata about creation and changes to records, provided by the server (client should not provide)",
"properties": {
"createdDate": {
"description": "Date and time when the record was created",
"type": "string",
"format": "date-time"
},
"createdByUserId": {
"description": "ID of the user who created the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"createdByUsername": {
"description": "Username of the user who created the record (when available)",
"type": "string"
},
"updatedDate": {
"description": "Date and time when the record was last updated",
"type": "string",
"format": "date-time"
},
"updatedByUserId": {
"description": "ID of the user who last updated the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"updatedByUsername": {
"description": "Username of the user who last updated the record (when available)",
"type": "string"
}
},
"additionalProperties": false,
"required": [
"createdDate"
]
},
"initialAllocation": {
"description": "Summary of all related to this ledger budgets initialAllocation",
"type": "number",
"readonly": true
},
"allocationTo": {
"description": "Summary of all related to this ledger budgets allocationTo",
"type": "number",
"readonly": true
},
"allocationFrom": {
"description": "Summary of all related to this ledger budgets allocationFrom",
"type": "number",
"readonly": true
},
"totalFunding": {
"description": "Summary of all related to this ledger budgets totalFunding",
"type": "number",
"readonly": true
},
"cashBalance": {
"description": "Summary of all related to this ledger budgets cashBalance",
"type": "number",
"readonly": true
},
"awaitingPayment": {
"description": "Summary of all related to this ledger budgets awaitingPayment",
"type": "number",
"readonly": true
},
"credits": {
"description": "Summary of all related to this ledger budgets credits",
"type": "number",
"readonly": true
},
"encumbered": {
"description": "Summary of all related to this ledger budgets encumbered",
"type": "number",
"readonly": true
},
"expenditures": {
"description": "Summary of all related to this ledger budgets expenditures",
"type": "number",
"readonly": true
},
"overEncumbrance": {
"description": "Summary of all related to this ledger budgets overEncumbrance",
"type": "number",
"readonly": true
},
"overExpended": {
"description": "Summary of all related to this ledger budgets overExpended",
"type": "number",
"readonly": true
}
},
"additionalProperties": false,
"required": [
"name",
"code",
"fiscalYearOneId",
"ledgerStatus",
"restrictEncumbrance",
"restrictExpenditures"
]
}
Example:
{
"id": "7cef8378-7cbd-1fae-bcdd-8b9d7c0af9de",
"name": "Main Library",
"code": "MAIN-LIB",
"description": "This is the ledger for the Main Library",
"fiscalYearOneId": "d875618b-7cf5-442f-a823-9814e7bce92a",
"ledgerStatus": "Active",
"allocated": 24500,
"initialAllocation": 11000,
"allocationTo": 13500,
"allocationFrom": 0,
"available": 21990,
"netTransfers": 2500,
"unavailable": 10,
"credits": 1500,
"expenditures": 10,
"encumbered": 0,
"awaitingPayment": 0,
"overEncumbrance": 0,
"overExpended": 0,
"totalFunding": 22000,
"cashBalance": 21990,
"currency": "USD",
"restrictEncumbrance": false,
"restrictExpenditures": false,
"acqUnitIds": [
"ac2164c7-ba3d-1bc2-912c-e35ceccbfaf2"
]
}
HTTP status code 404
Item with a given ID not found
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
"ledger not found"
HTTP status code 500
Internal server error, e.g. due to misconfiguration
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
internal server error, contact administrator
delete /finance/ledgers/{id}
Delete ledger item with given {ledgerId}
URI Parameters
- id: required(string - pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$)
The UUID of a ledger
HTTP status code 204
Item deleted successfully
HTTP status code 400
Bad request, e.g. malformed request body or query parameter. Details of the error (e.g. name of the parameter or line/character number with malformed data) provided in the response.
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
"unable to delete ledger -- constraint violation"
HTTP status code 404
Item with a given ID not found
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
"ledger not found"
HTTP status code 500
Internal server error, e.g. due to misconfiguration
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
Internal server error, contact administrator
Get current fiscal year for a specific ledger
Retrieve current-fiscal-year item with given {current-fiscal-yearId}
get /finance/ledgers/{id}/current-fiscal-year
Retrieve current-fiscal-year item with given {current-fiscal-yearId}
URI Parameters
- id: required(string - pattern: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$)
The UUID of a ledger
HTTP status code 200
Returns item with a given ID
Body
Media type: application/json
Type: json
Content:
{
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "A fiscal year record",
"type": "object",
"properties": {
"id": {
"description": "UUID of the fiscal year record",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
},
"_version": {
"type": "integer",
"description": "Record version for optimistic locking"
},
"acqUnitIds": {
"description": "UUIDs of the acquisition units associated with this fiscal year",
"type": "array",
"items": {
"$schema": "http://json-schema.org/draft-04/schema#",
"description": "The UUID format string",
"type": "string",
"pattern": "^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[1-5][0-9a-fA-F]{3}-[89abAB][0-9a-fA-F]{3}-[0-9a-fA-F]{12}$"
}
},
"name": {
"description": "The name of the fiscal year",
"type": "string"
},
"code": {
"description": "The code of the fiscal year",
"type": "string"
},
"currency": {
"description": "Currency code which is recorded when the FY ends, otherwise the system currency can be assumed",
"type": "string"
},
"description": {
"description": "The description of the fiscal year",
"type": "string"
},
"periodStart": {
"description": "The start date of the fiscal year",
"type": "string",
"format": "date-time"
},
"periodEnd": {
"description": "The end date of the fiscal year",
"type": "string",
"format": "date-time"
},
"series": {
"description": "The fiscal year series",
"type": "string"
},
"financialSummary": {
"description": "Includes Funding information and Financial activity",
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"properties": {
"allocated": {
"description": "Summary of all related to this fiscal year budgets allocated",
"type": "number",
"readonly": true
},
"available": {
"description": "Summary of all related to this fiscal year budgets available",
"type": "number",
"readonly": true
},
"unavailable": {
"description": "Summary of all related to this fiscal year budgets unavailable",
"type": "number",
"readonly": true
},
"initialAllocation": {
"description": "Summary of all related to this fiscal year budgets initialAllocation",
"type": "number",
"readonly": true
},
"allocationTo": {
"description": "Summary of all related to this fiscal year budgets allocationTo",
"type": "number",
"readonly": true
},
"allocationFrom": {
"description": "Summary of all related to this fiscal year budgets allocationFrom",
"type": "number",
"readonly": true
},
"totalFunding": {
"description": "Summary of all related to this fiscal year budgets totalFunding",
"type": "number",
"readonly": true
},
"cashBalance": {
"description": "Summary of all related to this fiscal year budgets cashBalance",
"type": "number",
"readonly": true
},
"awaitingPayment": {
"description": "Summary of all related to this fiscal year budgets awaitingPayment",
"type": "number",
"readonly": true
},
"credits": {
"description": "Summary of all related to this fiscal year budgets credits",
"type": "number",
"readonly": true
},
"encumbered": {
"description": "Summary of all related to this fiscal year budgets encumbered",
"type": "number",
"readonly": true
},
"expenditures": {
"description": "Summary of all related to this ledger budgets expenditures",
"type": "number",
"readonly": true
},
"overEncumbrance": {
"description": "Summary of all related to this ledger budgets overEncumbrance",
"type": "number",
"readonly": true
},
"overExpended": {
"description": "Summary of all related to this ledger budgets overExpended",
"type": "number",
"readonly": true
}
},
"additionalProperties": false
},
"metadata": {
"type": "object",
"readonly": true,
"$schema": "http://json-schema.org/draft-04/schema#",
"id": "metadata.schema",
"title": "Metadata Schema",
"description": "Metadata about creation and changes to records, provided by the server (client should not provide)",
"properties": {
"createdDate": {
"description": "Date and time when the record was created",
"type": "string",
"format": "date-time"
},
"createdByUserId": {
"description": "ID of the user who created the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"createdByUsername": {
"description": "Username of the user who created the record (when available)",
"type": "string"
},
"updatedDate": {
"description": "Date and time when the record was last updated",
"type": "string",
"format": "date-time"
},
"updatedByUserId": {
"description": "ID of the user who last updated the record (when available)",
"type": "string",
"pattern": "^[a-fA-F0-9]{8}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{4}-[a-fA-F0-9]{12}$"
},
"updatedByUsername": {
"description": "Username of the user who last updated the record (when available)",
"type": "string"
}
},
"additionalProperties": false,
"required": [
"createdDate"
]
}
},
"additionalProperties": false,
"required": [
"code",
"name",
"periodStart",
"periodEnd"
]
}
Example:
{
"id": "ac2164c7-ba3d-1bc2-a12c-e35ceccbfaf2",
"name": "Fiscal Year 2020",
"acqUnitIds": [
"1895e539-8dac-441e-b1f5-aab62b3fde60",
"47f504bd-0c1b-498e-a2ae-e2f0a0cea273"
],
"code": "FY2020",
"description": "January 1 - December 30",
"periodStart": "2020-01-01T00:00:00Z",
"periodEnd": "2020-12-30T23:59:59Z",
"series": "FY",
"financialSummary": {
"initialAllocation": 1090230.80,
"allocationTo": 1090230.80,
"allocationFrom": 0,
"allocated": 2180461.6,
"available": 2180377.6,
"totalFunding": 2180377.6,
"cashBalance": 2180377.6,
"encumbered": 0,
"awaitingPayment": 0,
"expenditures": 84,
"unavailable": 84,
"overEncumbrance": 0,
"overExpended": 0
},
"metadata": {
"createdDate": "2019-06-17T14:12:42.497+0000",
"createdByUserId": "498492aa-f909-42f6-b154-5bf66e6486ba",
"updatedDate": "2019-08-28T08:37:19.263+0000",
"updatedByUserId": "7ec56c96-e9f2-4079-9509-86b00f8dacd5"
}
}
HTTP status code 401
Not authorized to perform requested action
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
unable to get retrieve current-fiscal-year -- unauthorized
HTTP status code 404
Item with a given ID not found
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
"current-fiscal-year not found"
HTTP status code 500
Internal server error, e.g. due to misconfiguration
Body
Media type: application/json
Type: any
Example:
{
"errors": [
{
"message": "may not be null",
"type": "1",
"code": "-1",
"parameters": [
{
"key": "moduleTo",
"value": "null"
}
]
}
]
}
Media type: text/plain
Type: any
Example:
internal server error, contact administrator