Turnover and balances statement report archive in TransactionHeader(RLedgerTurnoverSheet)

Latest version of the JSON entity definition is available on GitHub.

Traits

Traits for this entity are listed below.

is.identifiedBy
names a specifc identity attribute to use with an entity

Parameter	Value	Data type	Explanation
attribute	RLedgerTurnoverSheet/(resolvedAttributes)/RecId	attribute

is.CDM.entityVersion

Parameter	Value	Data type	Explanation
versionNumber	"1.1"	string	semantic version number of the entity

is.application.releaseVersion

Parameter	Value	Data type	Explanation
releaseVersion	"10.0.13.0"	string	semantic version number of the application introducing this entity

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Turnover and balances statement report archive	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		TransactionHeader/RLedgerTurnoverSheet
CurrencyCode		TransactionHeader/RLedgerTurnoverSheet
CurrencyType		TransactionHeader/RLedgerTurnoverSheet
DeleteZero		TransactionHeader/RLedgerTurnoverSheet
DimensionCriteria		TransactionHeader/RLedgerTurnoverSheet
FromDate		TransactionHeader/RLedgerTurnoverSheet
GroupKey		TransactionHeader/RLedgerTurnoverSheet
GroupKeyExp		TransactionHeader/RLedgerTurnoverSheet
MainAccountNum		TransactionHeader/RLedgerTurnoverSheet
MainAccountNumCorr		TransactionHeader/RLedgerTurnoverSheet
PackedCaller		TransactionHeader/RLedgerTurnoverSheet
PackedQuery		TransactionHeader/RLedgerTurnoverSheet
PrintRanges		TransactionHeader/RLedgerTurnoverSheet
ReportType		TransactionHeader/RLedgerTurnoverSheet
ShowBalance		TransactionHeader/RLedgerTurnoverSheet
ShowBalanceTrans		TransactionHeader/RLedgerTurnoverSheet
ShowOrigin		TransactionHeader/RLedgerTurnoverSheet
ShowSumAccount		TransactionHeader/RLedgerTurnoverSheet
ShowTrans		TransactionHeader/RLedgerTurnoverSheet
ToDate		TransactionHeader/RLedgerTurnoverSheet
DataAreaId		TransactionHeader/RLedgerTurnoverSheet
Relationship_CurrencyRelationshipId		TransactionHeader/RLedgerTurnoverSheet
Relationship_DefaultDimensionRelationshipId		TransactionHeader/RLedgerTurnoverSheet
Relationship_CompanyRelationshipId		TransactionHeader/RLedgerTurnoverSheet

RecId

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
isPrimaryKey	true
dataFormat	int64
isReadOnly	true

Traits

List of traits for the RecId attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.identifiedBy
names a specifc identity attribute to use with an entity

Parameter	Value	Data type	Explanation
attribute	RLedgerTurnoverSheet/(resolvedAttributes)/RecId	attribute

is.readOnly
is.dataFormat.integer
is.dataFormat.big

CurrencyCode

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the CurrencyCode attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

CurrencyType

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CurrencyType attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

DeleteZero

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
displayName	Delete zero line
dataFormat	int32
isNullable	true

Traits

List of traits for the DeleteZero attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Delete zero line	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

DimensionCriteria

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the DimensionCriteria attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer
is.dataFormat.big

FromDate

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the FromDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

GroupKey

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	binary
isNullable	true

Traits

List of traits for the GroupKey attribute are listed below.

is.dataFormat.byte
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.byte
is.dataFormat.array

GroupKeyExp

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	binary
isNullable	true

Traits

List of traits for the GroupKeyExp attribute are listed below.

is.dataFormat.byte
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.byte
is.dataFormat.array

MainAccountNum

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the MainAccountNum attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.character
is.dataFormat.array

MainAccountNumCorr

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
displayName	Corr. account
dataFormat	string
isNullable	true

Traits

List of traits for the MainAccountNumCorr attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Corr. account	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

PackedCaller

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	binary
isNullable	true

Traits

List of traits for the PackedCaller attribute are listed below.

is.dataFormat.byte
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.byte
is.dataFormat.array

PackedQuery

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	binary
isNullable	true

Traits

List of traits for the PackedQuery attribute are listed below.

is.dataFormat.byte
is.dataFormat.array
is.nullable
The attribute value may be set to NULL.

is.dataFormat.byte
is.dataFormat.array

PrintRanges

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
displayName	Print ranges
dataFormat	int32
isNullable	true

Traits

List of traits for the PrintRanges attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Print ranges	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ReportType

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ReportType attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.dataFormat.integer

ShowBalance

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
displayName	Show balance
dataFormat	int32
isNullable	true

Traits

List of traits for the ShowBalance attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Show balance	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ShowBalanceTrans

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
displayName	Itemize balance
dataFormat	int32
isNullable	true

Traits

List of traits for the ShowBalanceTrans attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Itemize balance	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ShowOrigin

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
displayName	Show origin
dataFormat	int32
isNullable	true

Traits

List of traits for the ShowOrigin attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Show origin	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ShowSumAccount

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
displayName	Total accounts
dataFormat	int32
isNullable	true

Traits

List of traits for the ShowSumAccount attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Total accounts	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ShowTrans

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
displayName	Show transactions
dataFormat	int32
isNullable	true

Traits

List of traits for the ShowTrans attribute are listed below.

is.dataFormat.integer
is.nullable
The attribute value may be set to NULL.

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Show transactions	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ToDate

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ToDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.nullable
The attribute value may be set to NULL.

is.dataFormat.date

DataAreaId

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the DataAreaId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.readOnly
is.dataFormat.character
is.dataFormat.array

Relationship_CurrencyRelationshipId

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CurrencyRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Common/Currency/Group/Currency.cdm.json/Currency RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_DefaultDimensionRelationshipId

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DefaultDimensionRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/FinancialDimensions/Main/DimensionAttributeValueSet.cdm.json/DimensionAttributeValueSet RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array

Relationship_CompanyRelationshipId

First included in: TransactionHeader/RLedgerTurnoverSheet (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfo RecId	entity	a reference to the constant entity holding the list of entity references

is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array