Entity Property Audit

post

https://app.financekey.com/OData/dbo_EntityProperty_CT

Defines a property value on an entity.

Recent Requests

Time	Status	User Agent
Retrieving recent requests…

Loading…

Body Params

startLSN

string

required

endLSN

string | null

seqVal

string

required

operationId

int32

updateMask

string | null

entityId

string | null

The entity to which the property is associated with.

name

string | null

The name of the property on the Entity.

nullable

boolean | null

Checked if the property is a nullable property.

mandatory

boolean | null

Checked if the property needs to be populated or not.

defaultExpression

string | null

DefaultExpression is an nvarchar field in the EntityProperty table that stores a string value representing a default expression encoded as a string. It is used to address situations where a property value is not known or unavailable and a default value needs to be generated.

description

string | null

The EntityProperty table contains a field called Description of data type nvarchar. This field stores text data in characters of any length that are automatically stored as Unicode characters. This data can be used to define a property or attribute of an entity in the EntityProperty table.

comment

string | null

Miscellaneous notes and information for the entry or record.

dataTypeId

string | null

DataTypeId is an nvarchar field within the EntityProperty table, used to store the type of data for the associated entity property value. The data type for this field is limited to 450 characters in length.

audit

boolean | null

Checked if modifications in this column generate a new audit record.

approve

boolean | null

Checked if modifications on this property generate an approval request.

dbAttributeId

string | null

The attribute that should be placed on the column in the database. Select 'None' if none of the available attributes are applicable.

length

string | null

The total data length of the property. -1 indicates that length is not limited.

precision

int32 | null

Where applicable, allows the number of decimals to be specified for the property

caption

string | null

The caption to be used in the label for the control

boolean | null

Search is a field of data type bit in the EntityProperty table. It is a boolean field that indicates whether the entity associated with the table row is searchable or not. A value of 1 indicates that the associated entity is searchable, while a value of 0 indicates that it is not searchable.

boProperty

boolean | null

The BOProperty field in the EntityProperty table is a bit data type indicating whether an entity has a property or not. A value of '1' means the entity has the property, while a value of '0' means the entity does not have the property.

sequence

int32 | null

The Sequence field of type int in the EntityProperty table is used to denote the order in which certain entities should be presented or processed. This field allows for manual ordering within the system and can be modified when necessary.

display

boolean | null

The Display field of data type bit in the EntityProperty table is a Boolean field that is used to indicate whether the associated property should be displayed or not. This is used to control the display of specific properties for certain entities in select (foreign key) controls and collection controls.

commandId

int32 | null

Headers

content-type

string

enum

Defaults to application/json;odata.metadata=minimal;odata.streaming=true

Generated from available request content types

Response

200

Language

URL

Loading…

Response

Click Try It! to start a request and see the response here!