Edit

Share via

Purchase requisition consolidation table in WorksheetHeader(PurchReqConsolidation)

  • Article

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
attributePurchReqConsolidation/(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
enPurchase requisition consolidation table
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId WorksheetHeader/PurchReqConsolidation
ConsolidationDate WorksheetHeader/PurchReqConsolidation
ConsolidationOpportunityId WorksheetHeader/PurchReqConsolidation
CurrencyCode WorksheetHeader/PurchReqConsolidation
Name WorksheetHeader/PurchReqConsolidation
NetAmount WorksheetHeader/PurchReqConsolidation
Status WorksheetHeader/PurchReqConsolidation
TargetedEndDate WorksheetHeader/PurchReqConsolidation
UserId WorksheetHeader/PurchReqConsolidation
VendorQuoteNumber WorksheetHeader/PurchReqConsolidation
TotalQty WorksheetHeader/PurchReqConsolidation
Relationship_CurrencyRelationshipId WorksheetHeader/PurchReqConsolidation

RecId

First included in: WorksheetHeader/PurchReqConsolidation (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
attributePurchReqConsolidation/(resolvedAttributes)/RecIdattribute

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

ConsolidationDate

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ConsolidationDate attribute are listed below.

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

is.dataFormat.date

ConsolidationOpportunityId

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the ConsolidationOpportunityId attribute are listed below.

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

CurrencyCode

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the CurrencyCode attribute are listed below.

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

Name

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

NetAmount

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

Status

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the Status attribute are listed below.

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

is.dataFormat.integer

TargetedEndDate

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the TargetedEndDate attribute are listed below.

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

is.dataFormat.date

UserId

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

VendorQuoteNumber

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TotalQty

First included in: WorksheetHeader/PurchReqConsolidation (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

Relationship_CurrencyRelationshipId

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