Order lines in WorksheetLine(MCRSalesLine)

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	MCRSalesLine/(resolvedAttributes)/RecId	attribute

is.CDM.entityVersion

Parameter	Value	Data type	Explanation
versionNumber	"1.0"	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 Order lines	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/MCRSalesLine
ContinuityScheduleId		WorksheetLine/MCRSalesLine
CustInvoiceTransRecId		WorksheetLine/MCRSalesLine
ExchangeInventRefTransId		WorksheetLine/MCRSalesLine
Expedite		WorksheetLine/MCRSalesLine
GiftCardBuyerEmail		WorksheetLine/MCRSalesLine
GiftCardBuyerName		WorksheetLine/MCRSalesLine
GiftCardGiftMessage		WorksheetLine/MCRSalesLine
GiftCardNumber		WorksheetLine/MCRSalesLine
GiftCardRecipientEmail		WorksheetLine/MCRSalesLine
GiftCardRecipientName		WorksheetLine/MCRSalesLine
GiftCardType		WorksheetLine/MCRSalesLine
InstallmentEligible		WorksheetLine/MCRSalesLine
LineType		WorksheetLine/MCRSalesLine
ParentLotId		WorksheetLine/MCRSalesLine
SalesLine		WorksheetLine/MCRSalesLine
SourceId		WorksheetLine/MCRSalesLine
UpSellOrigin		WorksheetLine/MCRSalesLine
UpSellOriginRef		WorksheetLine/MCRSalesLine
GiftCardAmount_RU		WorksheetLine/MCRSalesLine
RetailPriceOverrideWorkflowState		WorksheetLine/MCRSalesLine
GiftCardExpiration		WorksheetLine/MCRSalesLine
DataAreaId		WorksheetLine/MCRSalesLine
Relationship_CustInvoiceTransRelationshipId		WorksheetLine/MCRSalesLine
Relationship_InventTransOriginRelationshipId		WorksheetLine/MCRSalesLine
Relationship_MCRContinuityScheduleHeaderRelationshipId		WorksheetLine/MCRSalesLine
Relationship_MCRExpediteTableRelationshipId		WorksheetLine/MCRSalesLine
Relationship_MCRSourceCodeSetupRelationshipId		WorksheetLine/MCRSalesLine
Relationship_RetailGiftCardTableRelationshipId		WorksheetLine/MCRSalesLine
Relationship_SalesLineRelationshipId		WorksheetLine/MCRSalesLine
Relationship_CompanyRelationshipId		WorksheetLine/MCRSalesLine

RecId

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

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

ContinuityScheduleId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CustInvoiceTransRecId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ExchangeInventRefTransId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Expedite

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

GiftCardBuyerEmail

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
displayName	Buyer email
dataFormat	string
isNullable	true

Traits

List of traits for the GiftCardBuyerEmail attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Buyer email	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

GiftCardBuyerName

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
displayName	Buyer name
dataFormat	string
isNullable	true

Traits

List of traits for the GiftCardBuyerName attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Buyer name	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

GiftCardGiftMessage

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

GiftCardNumber

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

GiftCardRecipientEmail

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
displayName	Recipient email
dataFormat	string
isNullable	true

Traits

List of traits for the GiftCardRecipientEmail attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Recipient email	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

GiftCardRecipientName

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
displayName	Recipient name
dataFormat	string
isNullable	true

Traits

List of traits for the GiftCardRecipientName attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Recipient name	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

GiftCardType

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the GiftCardType attribute are listed below.

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

is.dataFormat.integer

InstallmentEligible

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the InstallmentEligible attribute are listed below.

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

is.dataFormat.integer

LineType

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the LineType attribute are listed below.

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

is.dataFormat.integer

ParentLotId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
displayName	Parent lot ID
dataFormat	string
isNullable	true

Traits

List of traits for the ParentLotId attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Parent lot ID	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

SalesLine

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the SalesLine attribute are listed below.

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

SourceId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

UpSellOrigin

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the UpSellOrigin attribute are listed below.

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

is.dataFormat.integer

UpSellOriginRef

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
displayName	Estimated inventory days remaining
dataFormat	string
isNullable	true

Traits

List of traits for the UpSellOriginRef attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Estimated inventory days remaining	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

GiftCardAmount_RU

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

RetailPriceOverrideWorkflowState

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the RetailPriceOverrideWorkflowState attribute are listed below.

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

is.dataFormat.integer

GiftCardExpiration

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the GiftCardExpiration attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

DataAreaId

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

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_InventTransOriginRelationshipId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_MCRContinuityScheduleHeaderRelationshipId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_MCRExpediteTableRelationshipId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_MCRExpediteTableRelationshipId 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/Commerce/TransactionsAndOrders/Group/MCRExpediteTable.cdm.json/MCRExpediteTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_MCRSourceCodeSetupRelationshipId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_MCRSourceCodeSetupRelationshipId 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/Commerce/Merchandising/Main/MCRSourceCodeSetup.cdm.json/MCRSourceCodeSetup RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_RetailGiftCardTableRelationshipId

First included in: WorksheetLine/MCRSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_RetailGiftCardTableRelationshipId 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/Commerce/Payments/Transaction/RetailGiftCardTable.cdm.json/RetailGiftCardTable 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/MCRSalesLine (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_CompanyRelationshipId

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