Sales orders in WorksheetHeader(MCRSalesTable)

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	MCRSalesTable/(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 Sales orders	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/MCRSalesTable
CatalogUpSellShown		WorksheetHeader/MCRSalesTable
ContinuityChild		WorksheetHeader/MCRSalesTable
ContinuityLineEval		WorksheetHeader/MCRSalesTable
ContinuityOrder		WorksheetHeader/MCRSalesTable
FTCExempt		WorksheetHeader/MCRSalesTable
InstallmentOrderSubmitted		WorksheetHeader/MCRSalesTable
OutOfBalanceReleased		WorksheetHeader/MCRSalesTable
PaymOutOfBalance		WorksheetHeader/MCRSalesTable
PostageGroupID		WorksheetHeader/MCRSalesTable
PriceOverride		WorksheetHeader/MCRSalesTable
PromptedForInstBillingOption		WorksheetHeader/MCRSalesTable
ReceiptDate		WorksheetHeader/MCRSalesTable
SalesTable		WorksheetHeader/MCRSalesTable
SmmTMCallListId		WorksheetHeader/MCRSalesTable
SOAllocPriority		WorksheetHeader/MCRSalesTable
SourceId		WorksheetHeader/MCRSalesTable
DataAreaId		WorksheetHeader/MCRSalesTable
Relationship_MCRSourceCodeSetupRelationshipId		WorksheetHeader/MCRSalesTable
Relationship_PriceDiscGroup_MCRPostageGroupIDRelationshipId		WorksheetHeader/MCRSalesTable
Relationship_SalesTableRelationshipId		WorksheetHeader/MCRSalesTable
Relationship_SmmTMCallListIdRelationshipId		WorksheetHeader/MCRSalesTable
Relationship_CompanyRelationshipId		WorksheetHeader/MCRSalesTable

RecId

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

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

CatalogUpSellShown

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
displayName	Show catalog up-sell
dataFormat	int32
isNullable	true

Traits

List of traits for the CatalogUpSellShown 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 Show catalog up-sell	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ContinuityChild

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ContinuityChild attribute are listed below.

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

is.dataFormat.integer

ContinuityLineEval

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ContinuityLineEval attribute are listed below.

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

is.dataFormat.integer

ContinuityOrder

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ContinuityOrder attribute are listed below.

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

is.dataFormat.integer

FTCExempt

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the FTCExempt attribute are listed below.

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

is.dataFormat.integer

InstallmentOrderSubmitted

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
displayName	Installment order submitted
dataFormat	int32
isNullable	true

Traits

List of traits for the InstallmentOrderSubmitted 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 Installment order submitted	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

OutOfBalanceReleased

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
displayName	Out of balance released
dataFormat	int32
isNullable	true

Traits

List of traits for the OutOfBalanceReleased 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 Out of balance released	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

PaymOutOfBalance

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the PaymOutOfBalance attribute are listed below.

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

is.dataFormat.integer

PostageGroupID

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PriceOverride

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
displayName	Total discount override
dataFormat	int32
isNullable	true

Traits

List of traits for the PriceOverride 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 Total discount override	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

PromptedForInstBillingOption

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PromptedForInstBillingOption attribute are listed below.

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

is.dataFormat.integer

ReceiptDate

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
displayName	Date of receipt
dataFormat	date
isNullable	true

Traits

List of traits for the ReceiptDate attribute are listed below.

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

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

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

is.dataFormat.date

SalesTable

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the SalesTable attribute are listed below.

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

SmmTMCallListId

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SOAllocPriority

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
displayName	Sales order priority for fulfillment
dataFormat	int32
isNullable	true

Traits

List of traits for the SOAllocPriority 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 Sales order priority for fulfillment	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

SourceId

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

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

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

is.dataFormat.character
is.dataFormat.array

DataAreaId

First included in: WorksheetHeader/MCRSalesTable (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_MCRSourceCodeSetupRelationshipId

First included in: WorksheetHeader/MCRSalesTable (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_PriceDiscGroup_MCRPostageGroupIDRelationshipId

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PriceDiscGroup_MCRPostageGroupIDRelationshipId 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/Group/PriceDiscGroup.cdm.json/PriceDiscGroup 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: WorksheetHeader/MCRSalesTable (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_SmmTMCallListIdRelationshipId

First included in: WorksheetHeader/MCRSalesTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SmmTMCallListIdRelationshipId 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/Group/smmTMCallListGroup.cdm.json/smmTMCallListGroup 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: WorksheetHeader/MCRSalesTable (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