Return item replacement reference in WorksheetLine(ReturnReplaceItemRef)

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	ReturnReplaceItemRef/(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 Return item replacement reference	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/ReturnReplaceItemRef
ReplaceSalesId		WorksheetLine/ReturnReplaceItemRef
InventDimId		WorksheetLine/ReturnReplaceItemRef
ItemId		WorksheetLine/ReturnReplaceItemRef
OrigSalesId		WorksheetLine/ReturnReplaceItemRef
OrigSalesLineNum		WorksheetLine/ReturnReplaceItemRef
PdsCWReplaceQty		WorksheetLine/ReturnReplaceItemRef
RefQuarantineId		WorksheetLine/ReturnReplaceItemRef
RefSalesId		WorksheetLine/ReturnReplaceItemRef
RefSalesLineNum		WorksheetLine/ReturnReplaceItemRef
RefWMSJournalId		WorksheetLine/ReturnReplaceItemRef
RefWMSJournalLineNum		WorksheetLine/ReturnReplaceItemRef
ReplaceSalesLineNum		WorksheetLine/ReturnReplaceItemRef
ReturnReplaceQty		WorksheetLine/ReturnReplaceItemRef
DataAreaId		WorksheetLine/ReturnReplaceItemRef
Relationship_InventDimRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_InventQuarantineOrderRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_InventTableRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_ReplaceSalesTableRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_ReturnLineRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_ReturnSalesTableRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_SalesLineRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_SalesTableRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_WMSJournalTableRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_WMSJournalTransRelationshipId		WorksheetLine/ReturnReplaceItemRef
Relationship_CompanyRelationshipId		WorksheetLine/ReturnReplaceItemRef

RecId

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

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

ReplaceSalesId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InventDimId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the InventDimId attribute are listed below.

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

ItemId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ItemId attribute are listed below.

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

OrigSalesId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the OrigSalesId attribute are listed below.

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

OrigSalesLineNum

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	decimal

Traits

List of traits for the OrigSalesLineNum attribute are listed below.

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

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

PdsCWReplaceQty

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

RefQuarantineId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

RefSalesId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

RefSalesLineNum

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

RefWMSJournalId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

RefWMSJournalLineNum

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ReplaceSalesLineNum

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ReturnReplaceQty

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

DataAreaId

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

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventDimRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/Inventory/Main/InventDim.cdm.json/InventDim RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_InventQuarantineOrderRelationshipId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventQuarantineOrderRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetLine/InventQuarantineOrder.cdm.json/InventQuarantineOrder RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_InventTableRelationshipId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventTableRelationshipId 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/ProductInformationManagement/Main/InventTable.cdm.json/InventTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ReplaceSalesTableRelationshipId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_ReturnLineRelationshipId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_ReturnSalesTableRelationshipId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_SalesLineRelationshipId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SalesLineRelationshipId 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/WorksheetLine/SalesLine.cdm.json/SalesLine RecId	entity	a 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: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/SalesAndMarketing/WorksheetHeader/SalesTable.cdm.json/SalesTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_WMSJournalTableRelationshipId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WMSJournalTableRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetHeader/WMSJournalTable.cdm.json/WMSJournalTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_WMSJournalTransRelationshipId

First included in: WorksheetLine/ReturnReplaceItemRef (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WMSJournalTransRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/Inventory/WorksheetLine/WMSJournalTrans.cdm.json/WMSJournalTrans 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/ReturnReplaceItemRef (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