編輯

共用方式為


Royalty contract in Worksheet(MCRRoyaltyContract)

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
attributeMCRRoyaltyContract/(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
enRoyalty contract
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId Worksheet/MCRRoyaltyContract
ApprovalRequired Worksheet/MCRRoyaltyContract
CalcDates Worksheet/MCRRoyaltyContract
CumulateSalesBy Worksheet/MCRRoyaltyContract
Currency Worksheet/MCRRoyaltyContract
Description Worksheet/MCRRoyaltyContract
EffectiveFromDate Worksheet/MCRRoyaltyContract
EffectiveToDate Worksheet/MCRRoyaltyContract
ItemRoyaltyCode Worksheet/MCRRoyaltyContract
ItemRoyaltyRelation Worksheet/MCRRoyaltyContract
LedgerDimension Worksheet/MCRRoyaltyContract
OffsetLedgerDimension Worksheet/MCRRoyaltyContract
RoyaltyContract Worksheet/MCRRoyaltyContract
RoyaltyCustomizedPeriodType Worksheet/MCRRoyaltyContract
RoyaltyDetails Worksheet/MCRRoyaltyContract
RoyaltyLineBreakType Worksheet/MCRRoyaltyContract
RoyaltyTakenFrom Worksheet/MCRRoyaltyContract
RoyaltyUOMOption Worksheet/MCRRoyaltyContract
UnitID Worksheet/MCRRoyaltyContract
UnitType Worksheet/MCRRoyaltyContract
Validated Worksheet/MCRRoyaltyContract
VendAccount Worksheet/MCRRoyaltyContract
VendRoyaltyCode Worksheet/MCRRoyaltyContract
VendRoyaltyRelation Worksheet/MCRRoyaltyContract
Verifier Worksheet/MCRRoyaltyContract
DataAreaId Worksheet/MCRRoyaltyContract
Relationship_CurrencyRelationshipId Worksheet/MCRRoyaltyContract
Relationship_CustomizedPeriodTypeRelationshipId Worksheet/MCRRoyaltyContract
Relationship_LedgerDimensionRelationshipId Worksheet/MCRRoyaltyContract
Relationship_OffsetLedgerDimensionRelationshipId Worksheet/MCRRoyaltyContract
Relationship_VendAccountRelationshipId Worksheet/MCRRoyaltyContract
Relationship_CompanyRelationshipId Worksheet/MCRRoyaltyContract

RecId

First included in: Worksheet/MCRRoyaltyContract (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
attributeMCRRoyaltyContract/(resolvedAttributes)/RecIdattribute

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

ApprovalRequired

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
displayNameApproval required
dataFormatint32
isNullabletrue

Traits

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

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

is.dataFormat.integer

CalcDates

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
displayNameCalculation date type
dataFormatint32
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCalculation date type
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

CumulateSalesBy

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the CumulateSalesBy attribute are listed below.

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

is.dataFormat.integer

Currency

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Description

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

EffectiveFromDate

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
displayNameStart date
dataFormatdate
isNullabletrue

Traits

List of traits for the EffectiveFromDate 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
enStart date
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

EffectiveToDate

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the EffectiveToDate attribute are listed below.

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

is.dataFormat.date

ItemRoyaltyCode

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ItemRoyaltyCode attribute are listed below.

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

is.dataFormat.integer

ItemRoyaltyRelation

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

LedgerDimension

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint64

Traits

List of traits for the LedgerDimension attribute are listed below.

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

OffsetLedgerDimension

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint64

Traits

List of traits for the OffsetLedgerDimension attribute are listed below.

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

RoyaltyContract

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the RoyaltyContract attribute are listed below.

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

RoyaltyCustomizedPeriodType

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

RoyaltyDetails

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

RoyaltyLineBreakType

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the RoyaltyLineBreakType attribute are listed below.

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

is.dataFormat.integer

RoyaltyTakenFrom

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the RoyaltyTakenFrom attribute are listed below.

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

is.dataFormat.integer

RoyaltyUOMOption

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the RoyaltyUOMOption attribute are listed below.

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

is.dataFormat.integer

UnitID

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UnitType

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint32

Traits

List of traits for the UnitType attribute are listed below.

is.dataFormat.integer
is.dataFormat.integer

Validated

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the Validated attribute are listed below.

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

is.dataFormat.integer

VendAccount

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the VendAccount attribute are listed below.

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

VendRoyaltyCode

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the VendRoyaltyCode attribute are listed below.

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

is.dataFormat.integer

VendRoyaltyRelation

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Verifier

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

List of traits for the Verifier attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

DataAreaId

First included in: Worksheet/MCRRoyaltyContract (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_CurrencyRelationshipId

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CurrencyRelationshipId 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/Common/Currency/Group/Currency.cdm.json/CurrencyRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CustomizedPeriodTypeRelationshipId

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CustomizedPeriodTypeRelationshipId 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/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjPeriodTable.cdm.json/ProjPeriodTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_LedgerDimensionRelationshipId

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_LedgerDimensionRelationshipId 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/FinancialDimensions/Main/DimensionAttributeValueCombination.cdm.json/DimensionAttributeValueCombinationRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_OffsetLedgerDimensionRelationshipId

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_OffsetLedgerDimensionRelationshipId 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/FinancialDimensions/Main/DimensionAttributeValueCombination.cdm.json/DimensionAttributeValueCombinationRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_VendAccountRelationshipId

First included in: Worksheet/MCRRoyaltyContract (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_VendAccountRelationshipId 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/Vendor/Main/VendTable.cdm.json/VendTableRecId
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: Worksheet/MCRRoyaltyContract (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