Route jobs in WorksheetLine(ProdRouteJob)

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	ProdRouteJob/(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 Route jobs	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/ProdRouteJob
CalcTimeHours		WorksheetLine/ProdRouteJob
ExecutedPct		WorksheetLine/ProdRouteJob
FromDate		WorksheetLine/ProdRouteJob
FromTime		WorksheetLine/ProdRouteJob
JobControl		WorksheetLine/ProdRouteJob
JobFinished		WorksheetLine/ProdRouteJob
JobId		WorksheetLine/ProdRouteJob
JobPayType		WorksheetLine/ProdRouteJob
JobStatus		WorksheetLine/ProdRouteJob
JobType		WorksheetLine/ProdRouteJob
Link		WorksheetLine/ProdRouteJob
LinkType		WorksheetLine/ProdRouteJob
NumPrimary		WorksheetLine/ProdRouteJob
NumSecondary		WorksheetLine/ProdRouteJob
NumType		WorksheetLine/ProdRouteJob
OprNum		WorksheetLine/ProdRouteJob
OprPriority		WorksheetLine/ProdRouteJob
ProdId		WorksheetLine/ProdRouteJob
PropertyId		WorksheetLine/ProdRouteJob
RealizedEndDate		WorksheetLine/ProdRouteJob
RealizedEndTime		WorksheetLine/ProdRouteJob
RealizedStartDate		WorksheetLine/ProdRouteJob
RealizedStartTime		WorksheetLine/ProdRouteJob
SchedCancelled		WorksheetLine/ProdRouteJob
SchedTimeHours		WorksheetLine/ProdRouteJob
ToDate		WorksheetLine/ProdRouteJob
ToTime		WorksheetLine/ProdRouteJob
WrkCtrId		WorksheetLine/ProdRouteJob
DataAreaId		WorksheetLine/ProdRouteJob
Relationship_ProdRouteRelationshipId		WorksheetLine/ProdRouteJob
Relationship_ProdTableRelationshipId		WorksheetLine/ProdRouteJob
Relationship_ReqTransRelationshipId		WorksheetLine/ProdRouteJob
Relationship_ResourceWrkCtrTableRelationshipId		WorksheetLine/ProdRouteJob
Relationship_WrkCtrPropertyRelationshipId		WorksheetLine/ProdRouteJob
Relationship_CompanyRelationshipId		WorksheetLine/ProdRouteJob

RecId

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

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

CalcTimeHours

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ExecutedPct

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

FromDate

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

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

FromTime

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	time
isReadOnly	true
isNullable	true

Traits

List of traits for the FromTime attribute are listed below.

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

is.dataFormat.time

JobControl

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the JobControl attribute are listed below.

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

is.dataFormat.integer

JobFinished

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
displayName	Ended
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

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

is.dataFormat.integer

JobId

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the JobId attribute are listed below.

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

JobPayType

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the JobPayType attribute are listed below.

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

is.dataFormat.integer

JobStatus

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the JobStatus attribute are listed below.

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

is.dataFormat.integer

JobType

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

Link

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Link attribute are listed below.

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

is.dataFormat.integer

LinkType

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the LinkType attribute are listed below.

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

is.dataFormat.integer

NumPrimary

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the NumPrimary attribute are listed below.

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

is.dataFormat.integer

NumSecondary

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the NumSecondary attribute are listed below.

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

is.dataFormat.integer

NumType

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the NumType attribute are listed below.

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

is.dataFormat.integer

OprNum

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

ProdId

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PropertyId

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

RealizedEndDate

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
displayName	Actual end date
dataFormat	date
isNullable	true

Traits

List of traits for the RealizedEndDate 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 Actual end date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

RealizedEndTime

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
displayName	Actual end time
dataFormat	time
isNullable	true

Traits

List of traits for the RealizedEndTime attribute are listed below.

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

is.dataFormat.time

RealizedStartDate

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
displayName	Actual start date
dataFormat	date
isNullable	true

Traits

List of traits for the RealizedStartDate 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 Actual start date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

RealizedStartTime

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
displayName	Actual start time
dataFormat	time
isNullable	true

Traits

List of traits for the RealizedStartTime attribute are listed below.

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

is.dataFormat.time

SchedCancelled

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the SchedCancelled attribute are listed below.

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

is.dataFormat.integer

SchedTimeHours

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ToDate

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

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

ToTime

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	time
isReadOnly	true
isNullable	true

Traits

List of traits for the ToTime attribute are listed below.

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

is.dataFormat.time

WrkCtrId

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

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

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_ResourceWrkCtrTableRelationshipId

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/ProdRouteJob (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WrkCtrPropertyRelationshipId 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/MasterPlanning/Group/WrkCtrProperty.cdm.json/WrkCtrProperty 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/ProdRouteJob (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