Routing journal transactions in WorksheetLine(ProdJournalRoute)

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	ProdJournalRoute/(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 Routing journal transactions	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/ProdJournalRoute
Cancelled		WorksheetLine/ProdJournalRoute
CategoryHoursId		WorksheetLine/ProdJournalRoute
CategoryQtyId		WorksheetLine/ProdJournalRoute
DefaultDimension		WorksheetLine/ProdJournalRoute
ErrorCause		WorksheetLine/ProdJournalRoute
ExecutedPct		WorksheetLine/ProdJournalRoute
FromTime		WorksheetLine/ProdJournalRoute
HourPrice		WorksheetLine/ProdJournalRoute
Hours		WorksheetLine/ProdJournalRoute
JobFinished		WorksheetLine/ProdJournalRoute
JobId		WorksheetLine/ProdJournalRoute
JobType		WorksheetLine/ProdJournalRoute
JournalId		WorksheetLine/ProdJournalRoute
LineNum		WorksheetLine/ProdJournalRoute
OprFinished		WorksheetLine/ProdJournalRoute
OprId		WorksheetLine/ProdJournalRoute
OprNum		WorksheetLine/ProdJournalRoute
OprPriority		WorksheetLine/ProdJournalRoute
PdsCWQtyError		WorksheetLine/ProdJournalRoute
PdsCWQtyGood		WorksheetLine/ProdJournalRoute
ProdId		WorksheetLine/ProdJournalRoute
ProdInventDimId		WorksheetLine/ProdJournalRoute
ProdPickList		WorksheetLine/ProdJournalRoute
ProdPickListJournalId		WorksheetLine/ProdJournalRoute
ProdReportFinished		WorksheetLine/ProdJournalRoute
ProdReportFinishedJournalId		WorksheetLine/ProdJournalRoute
QtyError		WorksheetLine/ProdJournalRoute
QtyGood		WorksheetLine/ProdJournalRoute
QtyPrice		WorksheetLine/ProdJournalRoute
ReleaseKindId_RU		WorksheetLine/ProdJournalRoute
StornoPhysical_RU		WorksheetLine/ProdJournalRoute
ToTime		WorksheetLine/ProdJournalRoute
TransDate		WorksheetLine/ProdJournalRoute
Voucher		WorksheetLine/ProdJournalRoute
Worker		WorksheetLine/ProdJournalRoute
WrkCtrId		WorksheetLine/ProdJournalRoute
DataAreaId		WorksheetLine/ProdJournalRoute
Relationship_DefaultDimensionRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_InventDimRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_JournalErrorRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_PickingProdJournalTableRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_ProdJobRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_ProdJournalRouteProjRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_ProdJournalTableRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_ProdJournalTableJobRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_ProdOprNumRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_ProdReleaseKindTable_RURelationshipId		WorksheetLine/ProdJournalRoute
Relationship_ProdRouteRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_ProdTableRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_QuantityCostCategoryRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_ReportAsFinishedProdJournalTableRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_RouteOprTableRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_TimeCostCategoryRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_WrkCtrTableRelationshipId		WorksheetLine/ProdJournalRoute
Relationship_CompanyRelationshipId		WorksheetLine/ProdJournalRoute

RecId

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

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

Cancelled

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Cancelled attribute are listed below.

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

is.dataFormat.integer

CategoryHoursId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
displayName	Category hours
dataFormat	string
isNullable	true

Traits

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

is.dataFormat.character
is.dataFormat.array

CategoryQtyId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
displayName	Category quantity
dataFormat	string
isNullable	true

Traits

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

is.dataFormat.character
is.dataFormat.array

DefaultDimension

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

ErrorCause

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
displayName	Cause
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

ExecutedPct

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

FromTime

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	time
isNullable	true

Traits

List of traits for the FromTime attribute are listed below.

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

is.dataFormat.time

HourPrice

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

Hours

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

JobFinished

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the JobFinished attribute are listed below.

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

is.dataFormat.integer

JobId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

JobType

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
displayName	Task type
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

JournalId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the JournalId attribute are listed below.

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

LineNum

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the LineNum attribute are listed below.

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

OprFinished

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OprFinished attribute are listed below.

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

is.dataFormat.integer

OprId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OprNum

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OprNum attribute are listed below.

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

is.dataFormat.integer

OprPriority

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OprPriority attribute are listed below.

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

is.dataFormat.integer

PdsCWQtyError

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

PdsCWQtyGood

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ProdId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ProdId attribute are listed below.

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

ProdInventDimId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

ProdPickList

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
displayName	BOM consumption
dataFormat	int32
isNullable	true

Traits

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

is.dataFormat.integer

ProdPickListJournalId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

ProdReportFinished

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
displayName	Production report as finished
dataFormat	int32
isNullable	true

Traits

List of traits for the ProdReportFinished 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 Production report as finished	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ProdReportFinishedJournalId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

QtyError

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

QtyGood

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

QtyPrice

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ReleaseKindId_RU

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

StornoPhysical_RU

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
displayName	Storno (physical)
dataFormat	int32
isNullable	true

Traits

List of traits for the StornoPhysical_RU 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 Storno (physical)	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ToTime

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	time
isNullable	true

Traits

List of traits for the ToTime attribute are listed below.

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

is.dataFormat.time

TransDate

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	date

Traits

List of traits for the TransDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.dataFormat.date

Voucher

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Voucher attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

Worker

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

WrkCtrId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the WrkCtrId 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: WorksheetLine/ProdJournalRoute (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_DefaultDimensionRelationshipId

First included in: WorksheetLine/ProdJournalRoute (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_InventDimRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventDimRelationshipId 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/SupplyChain/Inventory/Main/InventDim.cdm.json/InventDim RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_JournalErrorRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_JournalErrorRelationshipId 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/SupplyChain/Inventory/WorksheetLine/JournalError.cdm.json/JournalError RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PickingProdJournalTableRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_ProdJobRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProdJobRelationshipId 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/SupplyChain/ProductionControl/WorksheetLine/ProdRouteJob.cdm.json/ProdRouteJob RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ProdJournalRouteProjRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProdJournalRouteProjRelationshipId 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/ProfessionalServices/ProjectManagementAndAccounting/WorksheetLine/ProdJournalRouteProj.cdm.json/ProdJournalRouteProj RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ProdJournalTableRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_ProdJournalTableJobRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_ProdOprNumRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProdOprNumRelationshipId 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/SupplyChain/ProductionControl/WorksheetLine/ProdRoute.cdm.json/ProdRoute RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ProdReleaseKindTable_RURelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProdReleaseKindTable_RURelationshipId 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/SupplyChain/Production/Group/ProdReleaseKindTable_RU.cdm.json/ProdReleaseKindTable_RU RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ProdRouteRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProdRouteRelationshipId 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/SupplyChain/ProductionControl/WorksheetLine/ProdRoute.cdm.json/ProdRoute RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ProdTableRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_QuantityCostCategoryRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_QuantityCostCategoryRelationshipId 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/SupplyChain/ProductionControl/Group/RouteCostCategory.cdm.json/RouteCostCategory RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ReportAsFinishedProdJournalTableRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_RouteOprTableRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RouteOprTableRelationshipId 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/SupplyChain/ProductionControl/Main/RouteOprTable.cdm.json/RouteOprTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_TimeCostCategoryRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TimeCostCategoryRelationshipId 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/SupplyChain/ProductionControl/Group/RouteCostCategory.cdm.json/RouteCostCategory RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_WrkCtrTableRelationshipId

First included in: WorksheetLine/ProdJournalRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WrkCtrTableRelationshipId 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/SupplyChain/SalesAndMarketing/Main/WrkCtrTable.cdm.json/WrkCtrTable 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/ProdJournalRoute (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