Work in WorksheetHeader(WHSWorkTable)

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

ParameterValueData typeExplanation
attributeWHSWorkTable/(resolvedAttributes)/RecIdattribute

is.CDM.entityVersion

ParameterValueData typeExplanation
versionNumber"1.1"stringsemantic version number of the entity

is.application.releaseVersion

ParameterValueData typeExplanation
releaseVersion"10.0.13.0"stringsemantic version number of the application introducing this entity

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enWork
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId WorksheetHeader/WHSWorkTable
ActualTime WorksheetHeader/WHSWorkTable
AutoExecute WorksheetHeader/WHSWorkTable
CombinedWorkId WorksheetHeader/WHSWorkTable
ContainerId WorksheetHeader/WHSWorkTable
CycleCountPlanOverview WorksheetHeader/WHSWorkTable
DispositionCode WorksheetHeader/WHSWorkTable
EstimatedTime WorksheetHeader/WHSWorkTable
Frozen WorksheetHeader/WHSWorkTable
InventJournalId WorksheetHeader/WHSWorkTable
InventLocationId WorksheetHeader/WHSWorkTable
InventSiteId WorksheetHeader/WHSWorkTable
LoadId WorksheetHeader/WHSWorkTable
LockedUser WorksheetHeader/WHSWorkTable
OrderNum WorksheetHeader/WHSWorkTable
ShipmentId WorksheetHeader/WHSWorkTable
TargetLicensePlateId WorksheetHeader/WHSWorkTable
TransTxt WorksheetHeader/WHSWorkTable
UserManuallyAssigned WorksheetHeader/WHSWorkTable
UseWorkForWaveReplen WorksheetHeader/WHSWorkTable
WaveId WorksheetHeader/WHSWorkTable
WorkBuildId WorksheetHeader/WHSWorkTable
WorkCancelledByUser WorksheetHeader/WHSWorkTable
WorkCancelledUTCDateTime WorksheetHeader/WHSWorkTable
WorkClosedUTCDateTime WorksheetHeader/WHSWorkTable
WorkCountError WorksheetHeader/WHSWorkTable
WorkCreatedBy WorksheetHeader/WHSWorkTable
WorkId WorksheetHeader/WHSWorkTable
WorkInProcessUTCDateTime WorksheetHeader/WHSWorkTable
WorkIsMultiSKU WorksheetHeader/WHSWorkTable
WorkManuallyCompletedBy WorksheetHeader/WHSWorkTable
WorkPoolId WorksheetHeader/WHSWorkTable
WorkPriority WorksheetHeader/WHSWorkTable
WorkStatus WorksheetHeader/WHSWorkTable
WorkTemplateCode WorksheetHeader/WHSWorkTable
WorkTransType WorksheetHeader/WHSWorkTable
CancelReplenWhenDemandCanceled WorksheetHeader/WHSWorkTable
HasWorkLineLoadLineDetails WorksheetHeader/WHSWorkTable
ReplenishmentDependentWorkBlockingPolicy WorksheetHeader/WHSWorkTable
IsPartialCycleCountWork WorksheetHeader/WHSWorkTable
ImmediateReplenishmentUnitId WorksheetHeader/WHSWorkTable
InventQualityOrderId WorksheetHeader/WHSWorkTable
ClusterProfileId WorksheetHeader/WHSWorkTable
DataAreaId WorksheetHeader/WHSWorkTable
Relationship_InventJournalTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_InventLocationRelationshipId WorksheetHeader/WHSWorkTable
Relationship_InventSiteRelationshipId WorksheetHeader/WHSWorkTable
Relationship_ProdTablePickRelationshipId WorksheetHeader/WHSWorkTable
Relationship_ProdTablePutRelationshipId WorksheetHeader/WHSWorkTable
Relationship_PurchTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_SalesTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_TransferOrderIssueRelationshipId WorksheetHeader/WHSWorkTable
Relationship_TransferOrderRecieptRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSContainerTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSCycleCountPlanOverviewRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSDispositionTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSLicensePlateRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSLoadTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSShipmentTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSWaveTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSWorkPoolRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSWorkTemplateTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSWorkUserLockedRelationshipId WorksheetHeader/WHSWorkTable
Relationship_InventQualityOrderTableRelationshipId WorksheetHeader/WHSWorkTable
Relationship_WHSClusterProfileRelationshipId WorksheetHeader/WHSWorkTable
Relationship_InventQualityOrderTableByOrderNumRelationshipId WorksheetHeader/WHSWorkTable
Relationship_CompanyRelationshipId WorksheetHeader/WHSWorkTable

RecId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
isPrimaryKeytrue
dataFormatint64
isReadOnlytrue

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

ParameterValueData typeExplanation
attributeWHSWorkTable/(resolvedAttributes)/RecIdattribute

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

ActualTime

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

AutoExecute

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AutoExecute attribute are listed below.

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

is.dataFormat.integer

CombinedWorkId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ContainerId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CycleCountPlanOverview

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

DispositionCode

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

EstimatedTime

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

Frozen

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the Frozen attribute are listed below.

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

is.dataFormat.integer

InventJournalId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InventLocationId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the InventLocationId attribute are listed below.

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

InventSiteId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the InventSiteId attribute are listed below.

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

LoadId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

LockedUser

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

OrderNum

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ShipmentId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TargetLicensePlateId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TransTxt

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserManuallyAssigned

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the UserManuallyAssigned attribute are listed below.

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

is.dataFormat.integer

UseWorkForWaveReplen

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the UseWorkForWaveReplen attribute are listed below.

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

is.dataFormat.integer

WaveId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

WorkBuildId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

WorkCancelledByUser

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

WorkCancelledUTCDateTime

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
displayNameCanceled work
dataFormatdate
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCanceled work
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

WorkClosedUTCDateTime

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
displayNameClosed work
dataFormatdate
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enClosed work
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

WorkCountError

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

WorkCreatedBy

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

WorkId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the WorkId attribute are listed below.

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

WorkInProcessUTCDateTime

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
displayNameWork in process
dataFormatdate
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enWork in process
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

WorkIsMultiSKU

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the WorkIsMultiSKU attribute are listed below.

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

is.dataFormat.integer

WorkManuallyCompletedBy

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

WorkPoolId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

WorkPriority

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the WorkPriority attribute are listed below.

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

is.dataFormat.integer

WorkStatus

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the WorkStatus attribute are listed below.

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

is.dataFormat.integer

WorkTemplateCode

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

WorkTransType

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32

Traits

List of traits for the WorkTransType attribute are listed below.

is.dataFormat.integer
is.dataFormat.integer

CancelReplenWhenDemandCanceled

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the CancelReplenWhenDemandCanceled attribute are listed below.

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

is.dataFormat.integer

HasWorkLineLoadLineDetails

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the HasWorkLineLoadLineDetails attribute are listed below.

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

is.dataFormat.integer

ReplenishmentDependentWorkBlockingPolicy

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ReplenishmentDependentWorkBlockingPolicy attribute are listed below.

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

is.dataFormat.integer

IsPartialCycleCountWork

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsPartialCycleCountWork attribute are listed below.

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

is.dataFormat.integer

ImmediateReplenishmentUnitId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InventQualityOrderId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ClusterProfileId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the ClusterProfileId 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: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

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_InventJournalTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/InventJournalTable.cdm.json/InventJournalTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_InventLocationRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Group/InventLocation.cdm.json/InventLocationRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_InventSiteRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Group/InventSite.cdm.json/InventSiteRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ProdTablePickRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/ProductionControl/WorksheetHeader/ProdTable.cdm.json/ProdTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ProdTablePutRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/ProductionControl/WorksheetHeader/ProdTable.cdm.json/ProdTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_PurchTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetHeader/PurchTable.cdm.json/PurchTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SalesTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/WorksheetHeader/SalesTable.cdm.json/SalesTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TransferOrderIssueRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/InventTransferTable.cdm.json/InventTransferTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TransferOrderRecieptRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/InventTransferTable.cdm.json/InventTransferTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSContainerTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Transaction/WHSContainerTable.cdm.json/WHSContainerTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSCycleCountPlanOverviewRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Group/WHSCycleCountPlanOverview.cdm.json/WHSCycleCountPlanOverviewRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSDispositionTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Main/WHSDispositionTable.cdm.json/WHSDispositionTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSLicensePlateRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Main/WHSLicensePlate.cdm.json/WHSLicensePlateRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSLoadTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/WHSLoadTable.cdm.json/WHSLoadTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSShipmentTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/WHSShipmentTable.cdm.json/WHSShipmentTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSWaveTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/WHSWaveTable.cdm.json/WHSWaveTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSWorkPoolRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Group/WHSWorkPool.cdm.json/WHSWorkPoolRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSWorkTemplateTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Main/WHSWorkTemplateTable.cdm.json/WHSWorkTemplateTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSWorkUserLockedRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Main/WHSWorkUser.cdm.json/WHSWorkUserRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_InventQualityOrderTableRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/InventQualityOrderTable.cdm.json/InventQualityOrderTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_WHSClusterProfileRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Group/WHSClusterProfile.cdm.json/WHSClusterProfileRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_InventQualityOrderTableByOrderNumRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

Traits

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/InventQualityOrderTable.cdm.json/InventQualityOrderTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CompanyRelationshipId

First included in: WorksheetHeader/WHSWorkTable (this entity)

Properties

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfoRecId
entitya reference to the constant entity holding the list of entity references

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