Order line information for other country contexts in WorksheetLine(LedgerJournalTrans_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	LedgerJournalTrans_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 Order line 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		WorksheetLine/LedgerJournalTrans_W
CashRegisterTerminal		WorksheetLine/LedgerJournalTrans_W
CategoryPurpose		WorksheetLine/LedgerJournalTrans_W
ChargeBearer		WorksheetLine/LedgerJournalTrans_W
LocalInstrument		WorksheetLine/LedgerJournalTrans_W
ServiceLevel		WorksheetLine/LedgerJournalTrans_W
LedgerJournalTrans		WorksheetLine/LedgerJournalTrans_W
EPaymCFDIConfirmNumber_MX		WorksheetLine/LedgerJournalTrans_W
CFDIBeneficiaryRetains_MX		WorksheetLine/LedgerJournalTrans_W
CFDIFinancialSystem_MX		WorksheetLine/LedgerJournalTrans_W
CFDIInterestBelongsDerivedFinOp_MX		WorksheetLine/LedgerJournalTrans_W
CFDIInterestCashedInTheCurrentPeriod_MX		WorksheetLine/LedgerJournalTrans_W
CFDIInterestLossAmount_MX		WorksheetLine/LedgerJournalTrans_W
CFDIInterestNominalAmount_MX		WorksheetLine/LedgerJournalTrans_W
CFDIInterestRealAmount_MX		WorksheetLine/LedgerJournalTrans_W
WithholdingTypeCode_MX		WorksheetLine/LedgerJournalTrans_W
RefPurchInvoiceDate_IN		WorksheetLine/LedgerJournalTrans_W
RefPurchInvoiceId_IN		WorksheetLine/LedgerJournalTrans_W
RefSalesInvoiceDate_IN		WorksheetLine/LedgerJournalTrans_W
RefSalesInvoiceId_IN		WorksheetLine/LedgerJournalTrans_W
OrigPaymRefRecId_RU		WorksheetLine/LedgerJournalTrans_W
OrigPaymRefTableId_RU		WorksheetLine/LedgerJournalTrans_W
DataAreaId		WorksheetLine/LedgerJournalTrans_W
Relationship_LedgerJournalTransRelationshipId		WorksheetLine/LedgerJournalTrans_W
Relationship_PaymentFormatCodeSets_CategoryPurposeRelationshipId		WorksheetLine/LedgerJournalTrans_W
Relationship_PaymentFormatCodeSets_ChargeBearerRelationshipId		WorksheetLine/LedgerJournalTrans_W
Relationship_PaymentFormatCodeSets_LocalInstrumentRelationshipId		WorksheetLine/LedgerJournalTrans_W
Relationship_PaymentFormatCodeSets_ServiceLevelRelationshipId		WorksheetLine/LedgerJournalTrans_W
Relationship_CashRegisterTerminal_WRelationshipId		WorksheetLine/LedgerJournalTrans_W
Relationship_CFDIWithholdingType_MXRelationshipId		WorksheetLine/LedgerJournalTrans_W
Relationship_CustTransRelationshipId		WorksheetLine/LedgerJournalTrans_W
Relationship_VendTransRelationshipId		WorksheetLine/LedgerJournalTrans_W
Relationship_CompanyRelationshipId		WorksheetLine/LedgerJournalTrans_W

RecId

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

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

CashRegisterTerminal

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

LedgerJournalTrans

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the LedgerJournalTrans attribute are listed below.

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

EPaymCFDIConfirmNumber_MX

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CFDIBeneficiaryRetains_MX

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CFDIBeneficiaryRetains_MX attribute are listed below.

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

is.dataFormat.integer

CFDIFinancialSystem_MX

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CFDIFinancialSystem_MX attribute are listed below.

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

is.dataFormat.integer

CFDIInterestBelongsDerivedFinOp_MX

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CFDIInterestBelongsDerivedFinOp_MX attribute are listed below.

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

is.dataFormat.integer

CFDIInterestCashedInTheCurrentPeriod_MX

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CFDIInterestCashedInTheCurrentPeriod_MX attribute are listed below.

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

is.dataFormat.integer

CFDIInterestLossAmount_MX

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

CFDIInterestNominalAmount_MX

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

CFDIInterestRealAmount_MX

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

WithholdingTypeCode_MX

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

RefPurchInvoiceDate_IN

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the RefPurchInvoiceDate_IN attribute are listed below.

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

is.dataFormat.date

RefPurchInvoiceId_IN

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

RefSalesInvoiceDate_IN

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the RefSalesInvoiceDate_IN attribute are listed below.

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

is.dataFormat.date

RefSalesInvoiceId_IN

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OrigPaymRefRecId_RU

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
displayName	Original prepayment
dataFormat	int64
isNullable	true

Traits

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

is.dataFormat.integer
is.dataFormat.big

OrigPaymRefTableId_RU

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OrigPaymRefTableId_RU attribute are listed below.

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

is.dataFormat.integer

DataAreaId

First included in: WorksheetLine/LedgerJournalTrans_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_LedgerJournalTransRelationshipId

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LedgerJournalTransRelationshipId 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/WorksheetLine/LedgerJournalTrans.cdm.json/LedgerJournalTrans 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: WorksheetLine/LedgerJournalTrans_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: WorksheetLine/LedgerJournalTrans_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: WorksheetLine/LedgerJournalTrans_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: WorksheetLine/LedgerJournalTrans_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_CashRegisterTerminal_WRelationshipId

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CashRegisterTerminal_WRelationshipId 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/AccountsReceivable/Main/CashRegisterTerminal_W.cdm.json/CashRegisterTerminal_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_CFDIWithholdingType_MXRelationshipId

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_CustTransRelationshipId

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_VendTransRelationshipId

First included in: WorksheetLine/LedgerJournalTrans_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_CompanyRelationshipId

First included in: WorksheetLine/LedgerJournalTrans_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