Purchase requisition consolidation line in WorksheetLine(PurchReqConsolidationLine)

Article
02/22/2022

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	PurchReqConsolidationLine/(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	Purchase requisition consolidation line

entity

a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/PurchReqConsolidationLine
CurrencyCode		WorksheetLine/PurchReqConsolidationLine
Discount		WorksheetLine/PurchReqConsolidationLine
DiscountPercent		WorksheetLine/PurchReqConsolidationLine
DiscountPercentStatus		WorksheetLine/PurchReqConsolidationLine
DiscountStatus		WorksheetLine/PurchReqConsolidationLine
NewLineAmount		WorksheetLine/PurchReqConsolidationLine
NewPurchAgreement		WorksheetLine/PurchReqConsolidationLine
NewPurchPrice		WorksheetLine/PurchReqConsolidationLine
NewPurchQty		WorksheetLine/PurchReqConsolidationLine
NewRequestedDate		WorksheetLine/PurchReqConsolidationLine
NewVendor		WorksheetLine/PurchReqConsolidationLine
NewVendorDataAreaId		WorksheetLine/PurchReqConsolidationLine
NewVendorQuoteNumber		WorksheetLine/PurchReqConsolidationLine
PurchReqConsolidationId		WorksheetLine/PurchReqConsolidationLine
PurchReqLineID		WorksheetLine/PurchReqConsolidationLine
Relationship_CurrencyCodeRelationshipId		WorksheetLine/PurchReqConsolidationLine
Relationship_NewVendorRelationshipId		WorksheetLine/PurchReqConsolidationLine
Relationship_PurchaseAgreementRelationshipId		WorksheetLine/PurchReqConsolidationLine
Relationship_PurchReqAggregationRelationshipId		WorksheetLine/PurchReqConsolidationLine
Relationship_PurchReqLineRelationshipId		WorksheetLine/PurchReqConsolidationLine

RecId

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

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

CurrencyCode

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	string

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

Discount

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

DiscountPercent

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

DiscountPercentStatus

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
displayName	Consolidation discount percent status
dataFormat	int32
isNullable	true

Traits

List of traits for the DiscountPercentStatus 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	Consolidation discount percent status

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

DiscountStatus

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DiscountStatus attribute are listed below.

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

is.dataFormat.integer

NewLineAmount

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

NewPurchAgreement

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

NewPurchPrice

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

NewPurchQty

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

NewRequestedDate

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the NewRequestedDate attribute are listed below.

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

is.dataFormat.date

NewVendor

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

NewVendorDataAreaId

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the NewVendorDataAreaId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

NewVendorQuoteNumber

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PurchReqConsolidationId

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

PurchReqLineID

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

Relationship_CurrencyCodeRelationshipId

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CurrencyCodeRelationshipId 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/Common/Currency/Group/Currency.cdm.json/Currency	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_NewVendorRelationshipId

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_NewVendorRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/Vendor/Main/VendTable.cdm.json/VendTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PurchaseAgreementRelationshipId

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchaseAgreementRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetLine/AgreementLine.cdm.json/AgreementLine	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PurchReqAggregationRelationshipId

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchReqAggregationRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetHeader/PurchReqConsolidation.cdm.json/PurchReqConsolidation	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PurchReqLineRelationshipId

First included in: WorksheetLine/PurchReqConsolidationLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchReqLineRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetLine/PurchReqLine.cdm.json/PurchReqLine	RecId

entity

a reference to the constant entity holding the list of entity references

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

Share via

Purchase requisition consolidation line in WorksheetLine(PurchReqConsolidationLine)

Traits

Attributes

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Feedback

Additional resources