Opening sheets in GeneralLedger(LedgerOpeningSheetEntity)

Article
2022-02-22

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

Traits

Traits for this entity are listed below.

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 sheets

entity

a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
Sheet		GeneralLedger/LedgerOpeningSheetEntity
Name		GeneralLedger/LedgerOpeningSheetEntity
FromDate		GeneralLedger/LedgerOpeningSheetEntity
ToDate		GeneralLedger/LedgerOpeningSheetEntity
PostDate		GeneralLedger/LedgerOpeningSheetEntity
AcknowledgementDate		GeneralLedger/LedgerOpeningSheetEntity
CurrentOperationsTax		GeneralLedger/LedgerOpeningSheetEntity
PeriodCode		GeneralLedger/LedgerOpeningSheetEntity
FiscalCalendarPeriodName		GeneralLedger/LedgerOpeningSheetEntity
FiscalCalendarYearName		GeneralLedger/LedgerOpeningSheetEntity
FiscalCalendarCalendarId		GeneralLedger/LedgerOpeningSheetEntity
Voucher		GeneralLedger/LedgerOpeningSheetEntity
SumTrialBalance		GeneralLedger/LedgerOpeningSheetEntity
SumTransfer		GeneralLedger/LedgerOpeningSheetEntity
SumResult		GeneralLedger/LedgerOpeningSheetEntity
SumBalance		GeneralLedger/LedgerOpeningSheetEntity
SumCapital		GeneralLedger/LedgerOpeningSheetEntity
AccountType		GeneralLedger/LedgerOpeningSheetEntity
LedgerOpeningTableMainAccountIdDisplayValue		GeneralLedger/LedgerOpeningSheetEntity
LedgerOpeningTableChartOfAccountsName		GeneralLedger/LedgerOpeningSheetEntity
Transfer		GeneralLedger/LedgerOpeningSheetEntity
TrialBalance		GeneralLedger/LedgerOpeningSheetEntity
Reconciled		GeneralLedger/LedgerOpeningSheetEntity
Result		GeneralLedger/LedgerOpeningSheetEntity
Balance		GeneralLedger/LedgerOpeningSheetEntity
Capital		GeneralLedger/LedgerOpeningSheetEntity
LineNum		GeneralLedger/LedgerOpeningSheetEntity
OperationsTax		GeneralLedger/LedgerOpeningSheetEntity
Txt		GeneralLedger/LedgerOpeningSheetEntity
LedgerOpeningTransMainAccountMainAccountIdDisplayValue		GeneralLedger/LedgerOpeningSheetEntity
LedgerOpeningTransMainAccountChartOfAccountName		GeneralLedger/LedgerOpeningSheetEntity
LedgerAccountDisplayValue		GeneralLedger/LedgerOpeningSheetEntity
Amount		GeneralLedger/LedgerOpeningSheetEntity
LedgerOpeningTransOffsetAccountMainAccountId		GeneralLedger/LedgerOpeningSheetEntity
LedgerOpeningTransOffsetAccountChartOfAccountName		GeneralLedger/LedgerOpeningSheetEntity
OffsetAccountDisplayValue		GeneralLedger/LedgerOpeningSheetEntity
BackingTable_LedgerOpeningSheet_ESRelationshipId		GeneralLedger/LedgerOpeningSheetEntity
Relationship_PrimaryCompanyContextRelationshipId		GeneralLedger/LedgerOpeningSheetEntity

Sheet

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Sheet 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

Name

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Name 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

FromDate

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the FromDate 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

ToDate

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ToDate 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

PostDate

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the PostDate 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

AcknowledgementDate

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the AcknowledgementDate 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

CurrentOperationsTax

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the CurrentOperationsTax 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

PeriodCode

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the PeriodCode 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

FiscalCalendarPeriodName

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the FiscalCalendarPeriodName 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

FiscalCalendarYearName

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the FiscalCalendarYearName attribute are listed below.

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

FiscalCalendarCalendarId

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the FiscalCalendarCalendarId attribute are listed below.

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

Voucher

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Voucher 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

SumTrialBalance

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the SumTrialBalance 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

SumTransfer

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the SumTransfer 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

SumResult

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the SumResult 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

SumBalance

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the SumBalance 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

SumCapital

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the SumCapital 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

AccountType

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the AccountType 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

LedgerOpeningTableMainAccountIdDisplayValue

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the LedgerOpeningTableMainAccountIdDisplayValue 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

LedgerOpeningTableChartOfAccountsName

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the LedgerOpeningTableChartOfAccountsName 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

Transfer

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Transfer 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

TrialBalance

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TrialBalance 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

Reconciled

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Reconciled 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

Result

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Result 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

Balance

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Balance 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

Capital

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Capital 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

LineNum

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the LineNum 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

OperationsTax

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the OperationsTax 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

Txt

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Txt 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

LedgerOpeningTransMainAccountMainAccountIdDisplayValue

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the LedgerOpeningTransMainAccountMainAccountIdDisplayValue 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

LedgerOpeningTransMainAccountChartOfAccountName

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the LedgerOpeningTransMainAccountChartOfAccountName 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

LedgerAccountDisplayValue

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the LedgerAccountDisplayValue 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

Amount

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Amount 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

LedgerOpeningTransOffsetAccountMainAccountId

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the LedgerOpeningTransOffsetAccountMainAccountId 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

LedgerOpeningTransOffsetAccountChartOfAccountName

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the LedgerOpeningTransOffsetAccountChartOfAccountName 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

OffsetAccountDisplayValue

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the OffsetAccountDisplayValue 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

BackingTable_LedgerOpeningSheet_ESRelationshipId

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the BackingTable_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_PrimaryCompanyContextRelationshipId

First included in: GeneralLedger/LedgerOpeningSheetEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PrimaryCompanyContextRelationshipId attribute are listed below.

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

Share via

Opening sheets in GeneralLedger(LedgerOpeningSheetEntity)

Traits

Attributes

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits