DimensionSegmentValuesByDimensionIdsegmentId3: Visma.net Financials Dimension Segment Values by Dimension ID Segment ID
read only REST
- Catalog:
VismaNet - Schema:
Dimension - Label: Dimension Segment Values by Dimension ID Segment ID
Get a specific Segment for a specific Dimension Data for Segment The response header includes an ETag after a successful GET operation.
Can only retrieve data.
Summary
Data for Segment
The response header includes an ETag after a successful GET operation.
API Source
- Endpoint:
/v1/dimension/{dimensionId}/{segmentId} - Operation:
get /v1/dimension/{dimensionId}/{segmentId}
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 |
|---|---|---|---|---|
dimension |
`` | Identifies the Dimension | ||
segment |
`` | Identifies the Segment |
Table Columns
The columns of the table DimensionSegmentValuesByDimensionIdsegmentId3 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 | writable, active |
The table > Active > A check box that indicates (if selected) that the value is active. | |
consol |
int32 |
itgen_vnet_consolnumchar | filters on the platform, writable, ::ancestor. |
Select segment and click View segment > Number of characters > The length (in characters) of the string in the parent's subaccount to which the segment value is mapped; this column is displayed for only the SUBACCOUNT key. | |
consol |
int32 |
itgen_vnet_consolorder | filters on the platform, writable, ::ancestor. |
Select segment and click View segment > Consol. order > The number that represents the order of this string among other strings in the parent company's subaccount; this column is displayed for only the SUBACCOUNT key. | |
description |
varchar2 |
Description | writable, description |
The table > Description > The user-defined segment description. | |
description_ |
varchar2 |
Description 2 | filters on the platform, writable, ::ancestor. |
Mandatory field: Description > The user-defined segment description. | |
internal |
guid |
Internal ID | writable, internal |
Unique identifier for the segment value | |
internal |
guid |
itgen_vnet_internalid_2 | filters on the platform, writable, ::ancestor. |
Unique identifier for the segment. | |
is |
char |
itgen_vnet_isautonumber | filters on the platform, writable, ::ancestor. |
Select segment and click View segment > Auto number > A check box that indicates (if selected) that the number series selected in the Number series ID field will be used to generate values for this segment in IDs. | |
last |
datetime |
Last Modified | writable, last |
||
last |
datetime |
itgen_vnet_lastmodified_2 | filters on the platform, writable, ::ancestor. |
System generated information. | |
length |
int32 |
Length | filters on the platform, writable, ::ancestor. |
Length > The maximum length of the segment. | |
mapped |
varchar2 |
itgen_vnet_mappedsegvalue | writable, mapped |
||
public |
guid |
Public ID | writable, public |
||
public |
guid |
itgen_vnet_publicid_2 | filters on the platform, writable, ::ancestor. |
||
segment |
int32 |
Segment ID | writable, segment |
The top part > Segment ID > The system-generated number representing the order of the segment in the segmented key. | |
segment |
int32 |
itgen_vnet_segmentid_2 | filters on the platform, writable, ::ancestor. |
Segment ID > The system-generated number representing the order of the segment in the segmented key. | |
time |
varchar2 |
Timestamp | writable, time |
||
time |
varchar2 |
itgen_vnet_timestamp_2 | filters on the platform, writable, ::ancestor. |
||
validate |
char |
itgen_vnet_validate | filters on the platform, writable, ::ancestor. |
Validate > A check box that indicates (if selected) that validation of segment values is turned on. | |
value |
varchar2 |
Value ID | writable, value |
The table > Value > The string that is the value of the selected segment. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: