Ledger journal table information for other country contexts in WorksheetHeader(LedgerJournalTable_W)

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_W/(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 information for other country contexts	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/LedgerJournalTable_W
ApprovalStatus_CN		WorksheetHeader/LedgerJournalTable_W
CashAccount_W		WorksheetHeader/LedgerJournalTable_W
DebitCurrencyCode_LT		WorksheetHeader/LedgerJournalTable_W
FiscalEstablishment_BR		WorksheetHeader/LedgerJournalTable_W
InformByPhone_LT		WorksheetHeader/LedgerJournalTable_W
InformByTelex_LT		WorksheetHeader/LedgerJournalTable_W
LedgerJournalTable		WorksheetHeader/LedgerJournalTable_W
Prepayment_W		WorksheetHeader/LedgerJournalTable_W
ReportPeriod_RU		WorksheetHeader/LedgerJournalTable_W
Reverse_RU		WorksheetHeader/LedgerJournalTable_W
ReverseType_RU		WorksheetHeader/LedgerJournalTable_W
TaxType_BR		WorksheetHeader/LedgerJournalTable_W
ReportingDate_RU		WorksheetHeader/LedgerJournalTable_W
RTax25RegVersion		WorksheetHeader/LedgerJournalTable_W
ReverseJournalTable_LT		WorksheetHeader/LedgerJournalTable_W
CategoryPurpose_W		WorksheetHeader/LedgerJournalTable_W
ChargeBearer_W		WorksheetHeader/LedgerJournalTable_W
LocalInstrument_W		WorksheetHeader/LedgerJournalTable_W
ServiceLevel_W		WorksheetHeader/LedgerJournalTable_W
ForeignBankFee_LT		WorksheetHeader/LedgerJournalTable_W
PaymentPriority_LT		WorksheetHeader/LedgerJournalTable_W
DataAreaId		WorksheetHeader/LedgerJournalTable_W
Relationship_DebitCurrencyCodeRelationshipId		WorksheetHeader/LedgerJournalTable_W
Relationship_FiscalEstablishment_BRRelationshipId		WorksheetHeader/LedgerJournalTable_W
Relationship_LedgerJournalTableRelationshipId		WorksheetHeader/LedgerJournalTable_W
Relationship_RCashTableRelationshipId		WorksheetHeader/LedgerJournalTable_W
Relationship_ReverseLedgerJournalTable_LTRelationshipId		WorksheetHeader/LedgerJournalTable_W
Relationship_PaymentFormatCodeSets_CategoryPurposeRelationshipId		WorksheetHeader/LedgerJournalTable_W
Relationship_PaymentFormatCodeSets_ChargeBearerRelationshipId		WorksheetHeader/LedgerJournalTable_W
Relationship_PaymentFormatCodeSets_LocalInstrumentRelationshipId		WorksheetHeader/LedgerJournalTable_W
Relationship_PaymentFormatCodeSets_ServiceLevelRelationshipId		WorksheetHeader/LedgerJournalTable_W
Relationship_CompanyRelationshipId		WorksheetHeader/LedgerJournalTable_W

RecId

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

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

ApprovalStatus_CN

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ApprovalStatus_CN attribute are listed below.

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

is.dataFormat.integer

CashAccount_W

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
displayName	Default cash account
dataFormat	string
isNullable	true

Traits

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

is.dataFormat.character
is.dataFormat.array

DebitCurrencyCode_LT

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

FiscalEstablishment_BR

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

InformByPhone_LT

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InformByPhone_LT attribute are listed below.

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

is.dataFormat.integer

InformByTelex_LT

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InformByTelex_LT attribute are listed below.

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

is.dataFormat.integer

LedgerJournalTable

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

Prepayment_W

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
displayName	Prepayment journal voucher
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

ReportPeriod_RU

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ReportPeriod_RU attribute are listed below.

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

is.dataFormat.date

Reverse_RU

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
displayName	Reversed
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

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

is.dataFormat.integer

ReverseType_RU

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ReverseType_RU attribute are listed below.

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

is.dataFormat.integer

TaxType_BR

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the TaxType_BR attribute are listed below.

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

is.dataFormat.integer

ReportingDate_RU

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ReportingDate_RU attribute are listed below.

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

is.dataFormat.date

RTax25RegVersion

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the RTax25RegVersion attribute are listed below.

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

is.dataFormat.integer

ReverseJournalTable_LT

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CategoryPurpose_W

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ChargeBearer_W

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

LocalInstrument_W

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ServiceLevel_W

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ForeignBankFee_LT

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ForeignBankFee_LT attribute are listed below.

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

is.dataFormat.integer

PaymentPriority_LT

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PaymentPriority_LT attribute are listed below.

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

is.dataFormat.integer

DataAreaId

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

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_LedgerJournalTableRelationshipId

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_RCashTableRelationshipId

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_ReverseLedgerJournalTable_LTRelationshipId

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_PaymentFormatCodeSets_CategoryPurposeRelationshipId

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_PaymentFormatCodeSets_ChargeBearerRelationshipId

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_PaymentFormatCodeSets_LocalInstrumentRelationshipId

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_PaymentFormatCodeSets_ServiceLevelRelationshipId

First included in: WorksheetHeader/LedgerJournalTable_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PaymentFormatCodeSets_ServiceLevelRelationshipId 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/PaymentFormatCodeSets_W.cdm.json/PaymentFormatCodeSets_W 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_W (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