Purchase requisitions in WorksheetHeader(PurchReqTable)

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

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/PurchReqTable
BusinessJustification		WorksheetHeader/PurchReqTable
CompanyInfoDefault		WorksheetHeader/PurchReqTable
HoldExplanation		WorksheetHeader/PurchReqTable
IsModified		WorksheetHeader/PurchReqTable
IsWorkflowToBeResubmitted		WorksheetHeader/PurchReqTable
OnHold		WorksheetHeader/PurchReqTable
Originator		WorksheetHeader/PurchReqTable
ProjId		WorksheetHeader/PurchReqTable
ProjIdDataArea		WorksheetHeader/PurchReqTable
PurchReqId		WorksheetHeader/PurchReqTable
PurchReqName		WorksheetHeader/PurchReqTable
PurchReqType		WorksheetHeader/PurchReqTable
RequiredDate		WorksheetHeader/PurchReqTable
RequisitionPurpose		WorksheetHeader/PurchReqTable
RequisitionStatus		WorksheetHeader/PurchReqTable
SourceDocumentHeader		WorksheetHeader/PurchReqTable
SubmittedBy		WorksheetHeader/PurchReqTable
SubmittedDateTime		WorksheetHeader/PurchReqTable
TransDate		WorksheetHeader/PurchReqTable
Relationship_CompanyInfoDefaultRelationshipId		WorksheetHeader/PurchReqTable
Relationship_ProjTableRelationshipId		WorksheetHeader/PurchReqTable
Relationship_PurchReqBusinessJustificationCodesRelationshipId		WorksheetHeader/PurchReqTable
Relationship_SourceDocumentHeaderRelationshipId		WorksheetHeader/PurchReqTable

RecId

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

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

BusinessJustification

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CompanyInfoDefault

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
displayName	Buying legal entity
dataFormat	int64
isNullable	true

Traits

List of traits for the CompanyInfoDefault attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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 Buying legal entity	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

HoldExplanation

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

IsModified

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the IsModified attribute are listed below.

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

is.dataFormat.integer

IsWorkflowToBeResubmitted

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
displayName	Resubmit workflow?
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the IsWorkflowToBeResubmitted attribute are listed below.

is.dataFormat.integer
is.readOnly
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 Resubmit workflow?	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

OnHold

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OnHold attribute are listed below.

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

is.dataFormat.integer

Originator

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the Originator attribute are listed below.

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

ProjId

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProjIdDataArea

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

PurchReqId

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the PurchReqId attribute are listed below.

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

PurchReqName

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the PurchReqName attribute are listed below.

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

PurchReqType

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the PurchReqType attribute are listed below.

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

is.dataFormat.integer

RequiredDate

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the RequiredDate attribute are listed below.

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

is.dataFormat.date

RequisitionPurpose

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the RequisitionPurpose attribute are listed below.

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

is.dataFormat.integer

RequisitionStatus

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the RequisitionStatus attribute are listed below.

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

is.dataFormat.integer

SourceDocumentHeader

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
displayName	Source document header
dataFormat	int64
isNullable	true

Traits

List of traits for the SourceDocumentHeader attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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 document header	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

SubmittedBy

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

SubmittedDateTime

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the SubmittedDateTime attribute are listed below.

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

is.dataFormat.date

TransDate

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the TransDate attribute are listed below.

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

is.dataFormat.date

Relationship_CompanyInfoDefaultRelationshipId

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

Relationship_ProjTableRelationshipId

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjTableRelationshipId 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/ProfessionalServices/ProjectManagementAndAccounting/Main/ProjTable.cdm.json/ProjTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PurchReqBusinessJustificationCodesRelationshipId

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchReqBusinessJustificationCodesRelationshipId 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/ProcurementAndSourcing/Reference/PurchReqBusinessJustificationCodes.cdm.json/PurchReqBusinessJustificationCodes RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_SourceDocumentHeaderRelationshipId

First included in: WorksheetHeader/PurchReqTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SourceDocumentHeaderRelationshipId 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/AccountingFoundation/TransactionHeader/SourceDocumentHeader.cdm.json/SourceDocumentHeader RecId	entity	a reference to the constant entity holding the list of entity references

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