title	description	author	ms.reviewer	ms.topic	ms.date	ms.author
ProdRoute in WorksheetLine - Common Data Model \| Microsoft Docs	undefined	llawwaii	deonhe	reference	8/7/2020	weiluo

Production route in WorksheetLine(ProdRoute)

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	ProdRoute/(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	Production route

entity

a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/ProdRoute
SetUpCategoryId		WorksheetLine/ProdRoute
AccError		WorksheetLine/ProdRoute
BackorderStatus		WorksheetLine/ProdRoute
CalcProc		WorksheetLine/ProdRoute
CalcQty		WorksheetLine/ProdRoute
CalcSetUp		WorksheetLine/ProdRoute
ConstantReleased		WorksheetLine/ProdRoute
DefaultDimension		WorksheetLine/ProdRoute
ErrorPct		WorksheetLine/ProdRoute
ExecutedProcess		WorksheetLine/ProdRoute
ExecutedSetup		WorksheetLine/ProdRoute
Formula		WorksheetLine/ProdRoute
FormulaFactor1		WorksheetLine/ProdRoute
FromDate		WorksheetLine/ProdRoute
FromTime		WorksheetLine/ProdRoute
JobIdProcess		WorksheetLine/ProdRoute
JobIdSetup		WorksheetLine/ProdRoute
JobPayType		WorksheetLine/ProdRoute
Level		WorksheetLine/ProdRoute
LinkType		WorksheetLine/ProdRoute
OprFinished		WorksheetLine/ProdRoute
OprId		WorksheetLine/ProdRoute
OprNum		WorksheetLine/ProdRoute
OprNumNext		WorksheetLine/ProdRoute
OprPriority		WorksheetLine/ProdRoute
OprStartedUp		WorksheetLine/ProdRoute
OverlapQty		WorksheetLine/ProdRoute
PhantomBOMFactor		WorksheetLine/ProdRoute
ProcessCategoryId		WorksheetLine/ProdRoute
ProcessPerQty		WorksheetLine/ProdRoute
ProcessTime		WorksheetLine/ProdRoute
ProdId		WorksheetLine/ProdRoute
PropertyId		WorksheetLine/ProdRoute
QtyCategoryId		WorksheetLine/ProdRoute
QueueTimeAfter		WorksheetLine/ProdRoute
QueueTimeBefore		WorksheetLine/ProdRoute
RouteGroupId		WorksheetLine/ProdRoute
RouteOprRefRecId		WorksheetLine/ProdRoute
RouteType		WorksheetLine/ProdRoute
SetupTime		WorksheetLine/ProdRoute
ToDate		WorksheetLine/ProdRoute
ToHours		WorksheetLine/ProdRoute
ToTime		WorksheetLine/ProdRoute
TransferBatch		WorksheetLine/ProdRoute
TranspTime		WorksheetLine/ProdRoute
WrkCtrIdCost		WorksheetLine/ProdRoute
SkipJobCreation		WorksheetLine/ProdRoute
DataAreaId		WorksheetLine/ProdRoute
Relationship_CostResourceRelationshipId		WorksheetLine/ProdRoute
Relationship_DefaultDimensionRelationshipId		WorksheetLine/ProdRoute
Relationship_InventReqRelationshipId		WorksheetLine/ProdRoute
Relationship_ProdRouteProjRelationshipId		WorksheetLine/ProdRoute
Relationship_ProdTableRelationshipId		WorksheetLine/ProdRoute
Relationship_QuantityCostCategoryRelationshipId		WorksheetLine/ProdRoute
Relationship_RouteGroupRelationshipId		WorksheetLine/ProdRoute
Relationship_RouteOprRelationshipId		WorksheetLine/ProdRoute
Relationship_RouteOprTableRelationshipId		WorksheetLine/ProdRoute
Relationship_RuntimeCostCategoryRelationshipId		WorksheetLine/ProdRoute
Relationship_SetupCostCategoryRelationshipId		WorksheetLine/ProdRoute
Relationship_WrkCtrPropertyRelationshipId		WorksheetLine/ProdRoute
Relationship_DocuRefRelationshipId		WorksheetLine/ProdRoute
Relationship_CompanyRelationshipId		WorksheetLine/ProdRoute

RecId

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

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

SetUpCategoryId

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AccError

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

BackorderStatus

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the BackorderStatus attribute are listed below.

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

is.dataFormat.integer

CalcProc

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
displayName	Process
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Process

entity

a reference to the constant entity holding the list of localized text

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

CalcQty

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

CalcSetUp

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
displayName	Setup
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Setup

entity

a reference to the constant entity holding the list of localized text

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

ConstantReleased

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ConstantReleased attribute are listed below.

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

is.dataFormat.integer

DefaultDimension

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

ErrorPct

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ExecutedProcess

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ExecutedSetup

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

Formula

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Formula attribute are listed below.

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

is.dataFormat.integer

FormulaFactor1

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the FormulaFactor1 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/ProdRoute (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/ProdRoute (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

JobIdProcess

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
displayName	Process job ID
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the JobIdProcess attribute are listed below.

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

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Process job ID

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

JobIdSetup

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
displayName	Set up job ID
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the JobIdSetup attribute are listed below.

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

is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Set up job ID

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

JobPayType

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

Level

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the Level attribute are listed below.

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

is.dataFormat.integer

LinkType

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

OprFinished

First included in: WorksheetLine/ProdRoute (this entity)

Properties

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Reported as finished

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

OprId

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the OprId attribute are listed below.

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

OprNum

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	int32

Traits

List of traits for the OprNum attribute are listed below.

is.dataFormat.integer
is.dataFormat.integer

OprNumNext

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OprNumNext 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/ProdRoute (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

OprStartedUp

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
displayName	Started
dataFormat	int32
isNullable	true

Traits

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

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

OverlapQty

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

PhantomBOMFactor

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

ProcessCategoryId

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProcessPerQty

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ProcessTime

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the ProcessTime 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/ProdRoute (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the ProdId attribute are listed below.

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

PropertyId

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

QtyCategoryId

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

QueueTimeAfter

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

QueueTimeBefore

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

RouteGroupId

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the RouteGroupId attribute are listed below.

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

RouteOprRefRecId

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

List of traits for the RouteOprRefRecId attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

RouteType

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the RouteType attribute are listed below.

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

is.dataFormat.integer

SetupTime

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the SetupTime 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/ProdRoute (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

ToHours

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal

Traits

List of traits for the ToHours attribute are listed below.

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

ToTime

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

TransferBatch

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

TranspTime

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

WrkCtrIdCost

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SkipJobCreation

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SkipJobCreation attribute are listed below.

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

is.dataFormat.integer

DataAreaId

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

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProdRouteProjRelationshipId 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/ProdRouteProj.cdm.json/ProdRouteProj	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/ProdRoute (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/ProdRoute (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_RouteGroupRelationshipId

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RouteGroupRelationshipId 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/RouteGroup.cdm.json/RouteGroup	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_RouteOprRelationshipId

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RouteOprRelationshipId 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/RouteOpr.cdm.json/RouteOpr	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/ProdRoute (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_RuntimeCostCategoryRelationshipId

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

First included in: WorksheetLine/ProdRoute (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DocuRefRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/System/SystemAdministration/WorksheetLine/DocuRef.cdm.json/DocuRef	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/ProdRoute (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

Files

ProdRoute.md

Latest commit

History

ProdRoute.md

File metadata and controls

Production route in WorksheetLine(ProdRoute)

Traits

Attributes

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties