FinancialPeriods3: Visma.net Financials Financial Periods
read only REST
- Catalog:
VismaNet - Schema:
FinancialPeriod - Label: Financial Periods
Get a range of Financial Periods - ScreenId=GL201000
Can only retrieve data.
API Source
- Endpoint:
/v1/financialPeriod - Operation:
get /v1/financialPeriod
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 155 |
| Full scan rows per minute | 29,100 |
| Point query rows per minute | 387 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
greater |
`` | Enter the year or year-period lower than the first period or year you want, format YYYY or YYYYPP |
Table Columns
The columns of the table FinancialPeriods3 are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COMPANY_ |
varchar2 |
Company Code | writable | Partition code, segmenting the data. | |
COMPANY_ |
varchar2 |
Company Name | writable | Name of the partition. | |
active |
char |
Active | filters on the platform, writable, active |
The table > Active > A check box that indicates (if selected) that the period can be used for posting transactions. | |
closed |
char |
itgen_vnet_closedincashmanagement | filters on the platform, writable, closed |
The table > Closed in Cash management > A read-only check box that indicates (if selected) that the financial period is closed in the Cash management; if this check box is cleared, the period is active in this workspace. | |
closed |
char |
itgen_vnet_closedincustomerledger | filters on the platform, writable, closed |
The table > Closed in Customer ledger > A read-only check box that indicates (if selected) that the financial period is closed in the Customer ledger workspace; if this check box is cleared, the period is active in this workspace. | |
closed |
char |
itgen_vnet_closedinfixedassets | filters on the platform, writable, closed |
The table > Closed in Fixed assets > A read-only check box that indicates (if selected) that the financial period is closed in the Fixed assets workspace; if this check box is cleared, the period is active in the this workspace. | |
closed |
char |
itgen_vnet_closedingeneralledger | filters on the platform, writable, closed |
The table > Closed in General ledger > A read-only check box that indicates (if selected) that the financial period is closed in the General ledger workspace; if this check box is cleared, the period is active in the this workspace. | |
closed |
char |
itgen_vnet_closedininventorymanagement | filters on the platform, writable, closed |
The table > Closed in Inventory management > Inventory management A read-only check box that indicates (if selected) that the financial period is closed in the Inventory workspace; if this check box is cleared, the period is active in the workspace. | |
closed |
char |
itgen_vnet_closedinsupplierledger | filters on the platform, writable, closed |
The table > Closed in Supplier ledger > A read-only check box that indicates (if selected) that the financial period is closed in the Supplier ledger workspace; if this check box is cleared, the period is active in the this workspace. | |
description |
varchar2 |
Description | filters on the platform, writable, description |
The table > Description > The description of the financial period (such as the name of the month or the number of the quarter). | |
end |
datetime |
End Date | filters on the platform, writable, end |
The table > End date > The date when the financial period ends. | |
period |
varchar2 |
Period | filters on the platform, writable, period |
The table > Period > The period no and the year. | |
start |
datetime |
Start Date | filters on the platform, writable, start |
The table > Start date > The date when the financial period starts. | |
year |
int32 |
Year | filters on the platform, writable, year |
Mandatory field: The top part > Financial year* > The financial year. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: