Ledger journal table in WorksheetHeader(LedgerJournalTable)

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	LedgerJournalTable/(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 Ledger journal table	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/LedgerJournalTable
UserBlockId		WorksheetHeader/LedgerJournalTable
Approver		WorksheetHeader/LedgerJournalTable
AssetTransferType_LT		WorksheetHeader/LedgerJournalTable
BankAccountId		WorksheetHeader/LedgerJournalTable
BankRemittanceType		WorksheetHeader/LedgerJournalTable
CurrencyCode		WorksheetHeader/LedgerJournalTable
CurrentOperationsTax		WorksheetHeader/LedgerJournalTable
CustVendNegInstProtestProcess		WorksheetHeader/LedgerJournalTable
DefaultDimension		WorksheetHeader/LedgerJournalTable
DetailSummaryPosting		WorksheetHeader/LedgerJournalTable
DocumentNum		WorksheetHeader/LedgerJournalTable
EndBalance		WorksheetHeader/LedgerJournalTable
EUROTriangulation		WorksheetHeader/LedgerJournalTable
ExchRate		WorksheetHeader/LedgerJournalTable
ExchrateSecondary		WorksheetHeader/LedgerJournalTable
FixedExchRate		WorksheetHeader/LedgerJournalTable
FixedOffsetAccount		WorksheetHeader/LedgerJournalTable
GroupBlockId		WorksheetHeader/LedgerJournalTable
InUseBy		WorksheetHeader/LedgerJournalTable
JournalBalance		WorksheetHeader/LedgerJournalTable
JournalName		WorksheetHeader/LedgerJournalTable
JournalNum		WorksheetHeader/LedgerJournalTable
JournalTotalCredit		WorksheetHeader/LedgerJournalTable
JournalTotalDebit		WorksheetHeader/LedgerJournalTable
journalTotalOffsetBalance		WorksheetHeader/LedgerJournalTable
JournalType		WorksheetHeader/LedgerJournalTable
LedgerJournalInclTax		WorksheetHeader/LedgerJournalTable
LinesLimitBeforeDistribution		WorksheetHeader/LedgerJournalTable
Log		WorksheetHeader/LedgerJournalTable
Name		WorksheetHeader/LedgerJournalTable
NumberSequenceTable		WorksheetHeader/LedgerJournalTable
NumOfLines		WorksheetHeader/LedgerJournalTable
OffsetAccountType		WorksheetHeader/LedgerJournalTable
OffsetLedgerDimension		WorksheetHeader/LedgerJournalTable
OriginalCompany		WorksheetHeader/LedgerJournalTable
OriginalJournalNum		WorksheetHeader/LedgerJournalTable
PackedExtensions		WorksheetHeader/LedgerJournalTable
PaymentsGenerated_IT		WorksheetHeader/LedgerJournalTable
Posted		WorksheetHeader/LedgerJournalTable
PostedDateTime		WorksheetHeader/LedgerJournalTable
ProtestSettledBill		WorksheetHeader/LedgerJournalTable
RejectedBy		WorksheetHeader/LedgerJournalTable
ReportedAsReadyBy		WorksheetHeader/LedgerJournalTable
RetailStatementId		WorksheetHeader/LedgerJournalTable
ReverseDate		WorksheetHeader/LedgerJournalTable
ReverseEntry		WorksheetHeader/LedgerJournalTable
SessionId		WorksheetHeader/LedgerJournalTable
SessionLoginDateTime		WorksheetHeader/LedgerJournalTable
SystemBlocked		WorksheetHeader/LedgerJournalTable
TaxObligationCompany		WorksheetHeader/LedgerJournalTable
VoucherAllocatedAtPosting		WorksheetHeader/LedgerJournalTable
WorkflowApprovalStatus		WorksheetHeader/LedgerJournalTable
IsLedgerDimensionNameUpdated		WorksheetHeader/LedgerJournalTable
ReportingCurrencyExchRate		WorksheetHeader/LedgerJournalTable
ReportingCurrencyExchRateSecondary		WorksheetHeader/LedgerJournalTable
ReportingCurrencyFixedExchRate		WorksheetHeader/LedgerJournalTable
JournalTotalCreditReportingCurrency		WorksheetHeader/LedgerJournalTable
JournalTotalDebitReportingCurrency		WorksheetHeader/LedgerJournalTable
IntegrationKey		WorksheetHeader/LedgerJournalTable
DelayTaxCalculation		WorksheetHeader/LedgerJournalTable
SimulationPosted_IT		WorksheetHeader/LedgerJournalTable
AssetLeaseProcessId		WorksheetHeader/LedgerJournalTable
RevRecReallocationId		WorksheetHeader/LedgerJournalTable
DataAreaId		WorksheetHeader/LedgerJournalTable
Relationship_BankAccountTableRelationshipId		WorksheetHeader/LedgerJournalTable
Relationship_CurrencyRelationshipId		WorksheetHeader/LedgerJournalTable
Relationship_DefaultDimensionRelationshipId		WorksheetHeader/LedgerJournalTable
Relationship_LedgerJournalNameRelationshipId		WorksheetHeader/LedgerJournalTable
Relationship_NumberSequenceTableRelationshipId		WorksheetHeader/LedgerJournalTable
Relationship_OffsetLedgerDimensionRelationshipId		WorksheetHeader/LedgerJournalTable
Relationship_UserGroupInfoRelationshipId		WorksheetHeader/LedgerJournalTable
Relationship_CompanyRelationshipId		WorksheetHeader/LedgerJournalTable

RecId

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

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

UserBlockId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

Approver

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

AssetTransferType_LT

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the AssetTransferType_LT attribute are listed below.

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

is.dataFormat.integer

BankAccountId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

BankRemittanceType

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the BankRemittanceType attribute are listed below.

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

is.dataFormat.integer

CurrencyCode

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

CurrentOperationsTax

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the CurrentOperationsTax attribute are listed below.

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

is.dataFormat.integer

CustVendNegInstProtestProcess

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CustVendNegInstProtestProcess attribute are listed below.

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

is.dataFormat.integer

DefaultDimension

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

DetailSummaryPosting

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DetailSummaryPosting attribute are listed below.

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

is.dataFormat.integer

DocumentNum

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EndBalance

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the EndBalance 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.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

EUROTriangulation

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the EUROTriangulation attribute are listed below.

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

is.dataFormat.integer

ExchRate

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the ExchRate 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.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

ExchrateSecondary

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the ExchrateSecondary 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.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

FixedExchRate

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the FixedExchRate attribute are listed below.

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

is.dataFormat.integer

FixedOffsetAccount

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the FixedOffsetAccount attribute are listed below.

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

is.dataFormat.integer

GroupBlockId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InUseBy

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

JournalBalance

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the JournalBalance 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.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

JournalName

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the JournalName attribute are listed below.

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

JournalNum

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the JournalNum attribute are listed below.

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

JournalTotalCredit

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Vendor transactions total
dataFormat	decimal
isNullable	true

Traits

List of traits for the JournalTotalCredit 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 Vendor transactions total	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

JournalTotalDebit

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Customer transactions total
dataFormat	decimal
isNullable	true

Traits

List of traits for the JournalTotalDebit 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 Customer transactions total	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

journalTotalOffsetBalance

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Balance + journal
dataFormat	decimal
isNullable	true

Traits

List of traits for the journalTotalOffsetBalance 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 + journal	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

JournalType

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the JournalType attribute are listed below.

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

is.dataFormat.integer

LedgerJournalInclTax

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the LedgerJournalInclTax attribute are listed below.

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

is.dataFormat.integer

LinesLimitBeforeDistribution

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the LinesLimitBeforeDistribution attribute are listed below.

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

is.dataFormat.integer

Log

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Log 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: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Description
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.localized.displayedAs
Holds the list of language specific display text for an object.

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

is.dataFormat.character
is.dataFormat.array

NumberSequenceTable

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Voucher series
dataFormat	int64
isNullable	true

Traits

List of traits for the NumberSequenceTable attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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 Voucher series	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

NumOfLines

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the NumOfLines attribute are listed below.

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

is.dataFormat.integer

OffsetAccountType

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OffsetAccountType attribute are listed below.

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

is.dataFormat.integer

OffsetLedgerDimension

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Offset account
dataFormat	int64
isNullable	true

Traits

List of traits for the OffsetLedgerDimension attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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 Offset account	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

OriginalCompany

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Intercompany accounting
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the OriginalCompany 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.localized.displayedAs
Holds the list of language specific display text for an object.

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

is.dataFormat.character
is.dataFormat.array

OriginalJournalNum

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Original journal No.
dataFormat	string
isNullable	true

Traits

List of traits for the OriginalJournalNum 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 Original journal No.	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

PackedExtensions

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	binary
isNullable	true

Traits

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

PaymentsGenerated_IT

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Payments generated
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

Posted

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the Posted attribute are listed below.

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

is.dataFormat.integer

PostedDateTime

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the PostedDateTime attribute are listed below.

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

is.dataFormat.date

ProtestSettledBill

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Protest settlements
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

RejectedBy

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Rejected by
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the RejectedBy 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.localized.displayedAs
Holds the list of language specific display text for an object.

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

is.dataFormat.character
is.dataFormat.array

ReportedAsReadyBy

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Reported as ready by
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the ReportedAsReadyBy 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.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Reported as ready by	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

RetailStatementId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

ReverseDate

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

SessionId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SessionId attribute are listed below.

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

is.dataFormat.integer

SessionLoginDateTime

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the SessionLoginDateTime attribute are listed below.

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

is.dataFormat.date

SystemBlocked

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Locked by system
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

TaxObligationCompany

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the TaxObligationCompany attribute are listed below.

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

is.dataFormat.integer

VoucherAllocatedAtPosting

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the VoucherAllocatedAtPosting attribute are listed below.

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

is.dataFormat.integer

WorkflowApprovalStatus

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the WorkflowApprovalStatus attribute are listed below.

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

is.dataFormat.integer

IsLedgerDimensionNameUpdated

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the IsLedgerDimensionNameUpdated attribute are listed below.

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

is.dataFormat.integer

ReportingCurrencyExchRate

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the ReportingCurrencyExchRate 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.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

ReportingCurrencyExchRateSecondary

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the ReportingCurrencyExchRateSecondary 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.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

ReportingCurrencyFixedExchRate

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ReportingCurrencyFixedExchRate attribute are listed below.

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

is.dataFormat.integer

JournalTotalCreditReportingCurrency

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Credit total - Reporting currency
dataFormat	decimal
isNullable	true

Traits

List of traits for the JournalTotalCreditReportingCurrency 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 Credit total - Reporting currency	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

JournalTotalDebitReportingCurrency

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Debit total - Reporting currency
dataFormat	decimal
isNullable	true

Traits

List of traits for the JournalTotalDebitReportingCurrency 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 Debit total - Reporting currency	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

IntegrationKey

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DelayTaxCalculation

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Delayed tax calculation
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

SimulationPosted_IT

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
displayName	Simulation posted
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SimulationPosted_IT attribute are listed below.

is.dataFormat.integer
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 Simulation posted	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

AssetLeaseProcessId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	guid
isNullable	true

Traits

List of traits for the AssetLeaseProcessId attribute are listed below.

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

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

RevRecReallocationId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the RevRecReallocationId 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/LedgerJournalTable (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_BankAccountTableRelationshipId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_BankAccountTableRelationshipId 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/Bank/Main/BankAccountTable.cdm.json/BankAccountTable 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/LedgerJournalTable (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/LedgerJournalTable (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_LedgerJournalNameRelationshipId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_NumberSequenceTableRelationshipId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_NumberSequenceTableRelationshipId 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/System/SystemAdministration/Framework/NumberSequenceTable.cdm.json/NumberSequenceTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_OffsetLedgerDimensionRelationshipId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_UserGroupInfoRelationshipId

First included in: WorksheetHeader/LedgerJournalTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_UserGroupInfoRelationshipId 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/System/SystemAdministration/Main/UserGroupInfo.cdm.json/UserGroupInfo 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/LedgerJournalTable (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