Opening accounts in WorksheetLine(LedgerOpeningTable_ES)

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	LedgerOpeningTable_ES/(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 Opening accounts	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/LedgerOpeningTable_ES
AccountType		WorksheetLine/LedgerOpeningTable_ES
BalanceSheet		WorksheetLine/LedgerOpeningTable_ES
Capital		WorksheetLine/LedgerOpeningTable_ES
MainAccount		WorksheetLine/LedgerOpeningTable_ES
Reconciled		WorksheetLine/LedgerOpeningTable_ES
Result		WorksheetLine/LedgerOpeningTable_ES
Sheet		WorksheetLine/LedgerOpeningTable_ES
Transfer		WorksheetLine/LedgerOpeningTable_ES
TrialBalanceSheet		WorksheetLine/LedgerOpeningTable_ES
DataAreaId		WorksheetLine/LedgerOpeningTable_ES
Relationship_LedgerOpeningSheet_ESRelationshipId		WorksheetLine/LedgerOpeningTable_ES
Relationship_MainAccountRelationshipId		WorksheetLine/LedgerOpeningTable_ES
Relationship_CompanyRelationshipId		WorksheetLine/LedgerOpeningTable_ES

RecId

First included in: WorksheetLine/LedgerOpeningTable_ES (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	LedgerOpeningTable_ES/(resolvedAttributes)/RecId	attribute

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

AccountType

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the AccountType attribute are listed below.

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

is.dataFormat.integer

BalanceSheet

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
displayName	Balance
dataFormat	decimal
isNullable	true

Traits

List of traits for the BalanceSheet attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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 Balance	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

Capital

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
displayName	Capital
dataFormat	decimal
isNullable	true

Traits

List of traits for the Capital attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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 Capital	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

MainAccount

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
displayName	Main account
dataFormat	int64

Traits

List of traits for the MainAccount attribute are listed below.

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

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

is.dataFormat.integer
is.dataFormat.big

Reconciled

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
displayName	Reconciled
dataFormat	int32
isNullable	true

Traits

List of traits for the Reconciled 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 Reconciled	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

Result

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
displayName	Result
dataFormat	decimal
isNullable	true

Traits

List of traits for the Result attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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 Result	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

Sheet

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the Sheet attribute are listed below.

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

Transfer

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
displayName	Transfer
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the Transfer attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

is.readOnly
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 Transfer	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

TrialBalanceSheet

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
displayName	Trial balance
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the TrialBalanceSheet attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

is.readOnly
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 Trial balance	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

DataAreaId

First included in: WorksheetLine/LedgerOpeningTable_ES (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_LedgerOpeningSheet_ESRelationshipId

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LedgerOpeningSheet_ESRelationshipId 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/WorksheetHeader/LedgerOpeningSheet_ES.cdm.json/LedgerOpeningSheet_ES RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_MainAccountRelationshipId

First included in: WorksheetLine/LedgerOpeningTable_ES (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_MainAccountRelationshipId 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/MainAccount.cdm.json/MainAccount 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: WorksheetLine/LedgerOpeningTable_ES (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