Muokkaa

Jaa


Purchase agreement in WorksheetHeader(PurchAgreementHeader)

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
attributePurchAgreementHeader/(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
enAgreement
enPurchase agreement
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId WorksheetHeader/PurchAgreementHeader
AgreementClassification WorksheetHeader/PurchAgreementHeader
AgreementState WorksheetHeader/PurchAgreementHeader
Currency WorksheetHeader/PurchAgreementHeader
DefaultAgreementLineEffectiveDate WorksheetHeader/PurchAgreementHeader
DefaultAgreementLineExpirationDate WorksheetHeader/PurchAgreementHeader
DefaultAgreementLineType WorksheetHeader/PurchAgreementHeader
DefaultDimension WorksheetHeader/PurchAgreementHeader
DocumentExternalReference WorksheetHeader/PurchAgreementHeader
DocumentTitle WorksheetHeader/PurchAgreementHeader
EarliestLineEffectiveDate WorksheetHeader/PurchAgreementHeader
InstanceRelationType WorksheetHeader/PurchAgreementHeader
InterCompanySkipUpdate WorksheetHeader/PurchAgreementHeader
IsDeleted WorksheetHeader/PurchAgreementHeader
Language WorksheetHeader/PurchAgreementHeader
LatestLineExpirationDate WorksheetHeader/PurchAgreementHeader
Originator WorksheetHeader/PurchAgreementHeader
Relationship_AgreementClassificationRelationshipId WorksheetHeader/PurchAgreementHeader
Relationship_CurrencyRelationshipId WorksheetHeader/PurchAgreementHeader
Relationship_DefaultDimensionRelationshipId WorksheetHeader/PurchAgreementHeader
Relationship_LanguageTableRelationshipId WorksheetHeader/PurchAgreementHeader
Relationship_OriginatorRelationshipId WorksheetHeader/PurchAgreementHeader
BuyingLegalEntity WorksheetHeader/PurchAgreementHeader
InterestBasedOnCEB_PSN WorksheetHeader/PurchAgreementHeader
MaximumAmount_PSN WorksheetHeader/PurchAgreementHeader
MinimumAmount_PSN WorksheetHeader/PurchAgreementHeader
ParentPurchAgreementID_PSN WorksheetHeader/PurchAgreementHeader
ProcurementClassification_PSN WorksheetHeader/PurchAgreementHeader
PurchAgreementType_PSN WorksheetHeader/PurchAgreementHeader
PurchNumberSequence WorksheetHeader/PurchAgreementHeader
Purpose_PSN WorksheetHeader/PurchAgreementHeader
Renewable_PSN WorksheetHeader/PurchAgreementHeader
VendAccount WorksheetHeader/PurchAgreementHeader
VendorDataAreaId WorksheetHeader/PurchAgreementHeader
WorkflowStatus_PSN WorksheetHeader/PurchAgreementHeader
PrimaryResponsibleWorker WorksheetHeader/PurchAgreementHeader
SecondaryResponsibleWorker WorksheetHeader/PurchAgreementHeader
MatchingPolicy WorksheetHeader/PurchAgreementHeader
Relationship_CompanyInfoRelationshipId WorksheetHeader/PurchAgreementHeader
Relationship_VendTableRelationshipId WorksheetHeader/PurchAgreementHeader

RecId

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

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

AgreementClassification

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatunknown

Traits

List of traits for the AgreementClassification attribute are listed below.

AgreementState

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AgreementState attribute are listed below.

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

is.dataFormat.integer

Currency

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the Currency attribute are listed below.

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

DefaultAgreementLineEffectiveDate

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatunknown
isNullabletrue

Traits

List of traits for the DefaultAgreementLineEffectiveDate attribute are listed below.

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

DefaultAgreementLineExpirationDate

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the DefaultAgreementLineExpirationDate attribute are listed below.

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

is.dataFormat.date

DefaultAgreementLineType

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameDefault commitment
dataFormatint32
isNullabletrue

Traits

List of traits for the DefaultAgreementLineType 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
enDefault commitment
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

DefaultDimension

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

DocumentExternalReference

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatunknown
isNullabletrue

Traits

List of traits for the DocumentExternalReference attribute are listed below.

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

DocumentTitle

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatunknown
isNullabletrue

Traits

List of traits for the DocumentTitle attribute are listed below.

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

EarliestLineEffectiveDate

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatunknown
isReadOnlytrue
isNullabletrue

Traits

List of traits for the EarliestLineEffectiveDate attribute are listed below.

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

InstanceRelationType

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

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

InterCompanySkipUpdate

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the InterCompanySkipUpdate attribute are listed below.

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

is.dataFormat.integer

IsDeleted

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the IsDeleted attribute are listed below.

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

is.dataFormat.integer

Language

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

LatestLineExpirationDate

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatunknown
isReadOnlytrue
isNullabletrue

Traits

List of traits for the LatestLineExpirationDate attribute are listed below.

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

Originator

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_AgreementClassificationRelationshipId 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/ProcurementAndSourcing/Group/AgreementClassification.cdm.json/AgreementClassificationRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CurrencyRelationshipId

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

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_DefaultDimensionRelationshipId 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/DimensionAttributeValueSet.cdm.json/DimensionAttributeValueSetRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_LanguageTableRelationshipId

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_LanguageTableRelationshipId 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/System/SystemAdministration/Group/LanguageTable.cdm.json/LanguageTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_OriginatorRelationshipId

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_OriginatorRelationshipId 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/GAB/Main/DirPerson.cdm.json/DirPersonRecId
entitya reference to the constant entity holding the list of entity references

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

BuyingLegalEntity

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameLegal entities
dataFormatint64

Traits

List of traits for the BuyingLegalEntity attribute are listed below.

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enLegal entities
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

InterestBasedOnCEB_PSN

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameInterest is based on central European bank
dataFormatint32
isNullabletrue

Traits

List of traits for the InterestBasedOnCEB_PSN 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
enInterest is based on central European bank
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

MaximumAmount_PSN

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameMaximum
dataFormatdecimal
isNullabletrue

Traits

List of traits for the MaximumAmount_PSN 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.localized.displayedAs
Holds the list of language specific display text for an object.

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

MinimumAmount_PSN

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameMinimum
dataFormatdecimal
isNullabletrue

Traits

List of traits for the MinimumAmount_PSN 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.localized.displayedAs
Holds the list of language specific display text for an object.

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

is.dataFormat.numeric.shaped
for setting the exact precision and scale of numeric values

ParentPurchAgreementID_PSN

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameParent purchase agreement
dataFormatint64
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enParent purchase agreement
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

ProcurementClassification_PSN

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameProcurement classification
dataFormatstring
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enProcurement classification
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

PurchAgreementType_PSN

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PurchAgreementType_PSN attribute are listed below.

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

is.dataFormat.integer

PurchNumberSequence

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the PurchNumberSequence attribute are listed below.

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

Purpose_PSN

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNamePurpose
dataFormatstring
isNullabletrue

Traits

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

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

is.dataFormat.character
is.dataFormat.array

Renewable_PSN

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameRenewable
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

VendAccount

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

VendorDataAreaId

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

WorkflowStatus_PSN

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the WorkflowStatus_PSN attribute are listed below.

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

is.dataFormat.integer

PrimaryResponsibleWorker

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNamePrimary responsible worker
dataFormatint64
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enPrimary responsible worker
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

SecondaryResponsibleWorker

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameSecondary responsible worker
dataFormatint64
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enSecondary responsible worker
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

MatchingPolicy

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
displayNameLine matching policy
dataFormatint32
isNullabletrue

Traits

List of traits for the MatchingPolicy 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
enLine matching policy
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

Relationship_CompanyInfoRelationshipId

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatguid

Traits

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

Relationship_VendTableRelationshipId

First included in: WorksheetHeader/PurchAgreementHeader (this entity)

Properties

NameValue
dataFormatguid

Traits

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