Advanced ledger entry header in WorksheetHeader(AdvancedLedgerEntryHeader)

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	AdvancedLedgerEntryHeader/(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 Advanced ledger entry header	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/AdvancedLedgerEntryHeader
AccountingDate		WorksheetHeader/AdvancedLedgerEntryHeader
AccountingDistributionTemplate		WorksheetHeader/AdvancedLedgerEntryHeader
DefaultDimension		WorksheetHeader/AdvancedLedgerEntryHeader
FiscalCalendarPeriod		WorksheetHeader/AdvancedLedgerEntryHeader
JournalizingDefinition		WorksheetHeader/AdvancedLedgerEntryHeader
LedgerVoucher		WorksheetHeader/AdvancedLedgerEntryHeader
ReasonTableRef		WorksheetHeader/AdvancedLedgerEntryHeader
ReverseDate		WorksheetHeader/AdvancedLedgerEntryHeader
ReverseEntry		WorksheetHeader/AdvancedLedgerEntryHeader
SourceDocumentHeader		WorksheetHeader/AdvancedLedgerEntryHeader
TransactionCurrency		WorksheetHeader/AdvancedLedgerEntryHeader
TransactionNumber		WorksheetHeader/AdvancedLedgerEntryHeader
TransactionStatus		WorksheetHeader/AdvancedLedgerEntryHeader
TransactionText		WorksheetHeader/AdvancedLedgerEntryHeader
WorkflowApprovalState		WorksheetHeader/AdvancedLedgerEntryHeader
WorkFlowStatus		WorksheetHeader/AdvancedLedgerEntryHeader
PSNIsCorrection		WorksheetHeader/AdvancedLedgerEntryHeader
PSNDoUpdateBank		WorksheetHeader/AdvancedLedgerEntryHeader
PSNBankTransactionType		WorksheetHeader/AdvancedLedgerEntryHeader
DataAreaId		WorksheetHeader/AdvancedLedgerEntryHeader
Relationship_AccountingDistributionTemplateRelationshipId		WorksheetHeader/AdvancedLedgerEntryHeader
Relationship_CurrencyRelationshipId		WorksheetHeader/AdvancedLedgerEntryHeader
Relationship_DefaultDimensionRelationshipId		WorksheetHeader/AdvancedLedgerEntryHeader
Relationship_FiscalCalendarPeriodRelationshipId		WorksheetHeader/AdvancedLedgerEntryHeader
Relationship_JournalizingDefinitionRelationshipId		WorksheetHeader/AdvancedLedgerEntryHeader
Relationship_ReasonTableRefRelationshipId		WorksheetHeader/AdvancedLedgerEntryHeader
Relationship_SourceDocumentHeaderRelationshipId		WorksheetHeader/AdvancedLedgerEntryHeader
Relationship_CompanyRelationshipId		WorksheetHeader/AdvancedLedgerEntryHeader

RecId

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

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

AccountingDate

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
displayName	Accounting date
dataFormat	date

Traits

List of traits for the AccountingDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.localized.displayedAs
Holds the list of language specific display text for an object.

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

is.dataFormat.date

AccountingDistributionTemplate

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

List of traits for the AccountingDistributionTemplate attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

DefaultDimension

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

FiscalCalendarPeriod

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the FiscalCalendarPeriod attribute are listed below.

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

JournalizingDefinition

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
displayName	Posting definition
dataFormat	int64

Traits

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

is.dataFormat.integer
is.dataFormat.big

LedgerVoucher

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the LedgerVoucher attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ReasonTableRef

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ReverseDate

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
displayName	Reversing date
dataFormat	date
isNullable	true

Traits

List of traits for the ReverseDate attribute are listed below.

is.dataFormat.date
means.measurement.date
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 Reversing date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

ReverseEntry

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
displayName	Reversing entry
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

SourceDocumentHeader

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

List of traits for the SourceDocumentHeader attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

TransactionCurrency

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the TransactionCurrency attribute are listed below.

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

TransactionNumber

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the TransactionNumber attribute are listed below.

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

TransactionStatus

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the TransactionStatus attribute are listed below.

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

is.dataFormat.integer

TransactionText

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the TransactionText attribute are listed below.

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

WorkflowApprovalState

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the WorkflowApprovalState attribute are listed below.

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

is.dataFormat.integer

WorkFlowStatus

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the WorkFlowStatus attribute are listed below.

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

is.dataFormat.integer

PSNIsCorrection

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PSNIsCorrection attribute are listed below.

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

is.dataFormat.integer

PSNDoUpdateBank

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
displayName	Update bank balances
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

PSNBankTransactionType

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DataAreaId

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (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_AccountingDistributionTemplateRelationshipId

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AccountingDistributionTemplateRelationshipId 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/AccountingFoundation/Group/AccountingDistributionTemplate.cdm.json/AccountingDistributionTemplate RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_CurrencyRelationshipId

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (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: WorksheetHeader/AdvancedLedgerEntryHeader (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_FiscalCalendarPeriodRelationshipId

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_JournalizingDefinitionRelationshipId

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_JournalizingDefinitionRelationshipId 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/AccountingFoundation/Main/JournalizingDefinition.cdm.json/JournalizingDefinition RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ReasonTableRefRelationshipId

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_SourceDocumentHeaderRelationshipId

First included in: WorksheetHeader/AdvancedLedgerEntryHeader (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SourceDocumentHeaderRelationshipId 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/AccountingFoundation/TransactionHeader/SourceDocumentHeader.cdm.json/SourceDocumentHeader 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: WorksheetHeader/AdvancedLedgerEntryHeader (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