Szerkesztés

Megosztás a következőn keresztül:


Purchase order line information history for countries in WorksheetLine(PurchLineHistory_W)

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
attributePurchLineHistory_W/(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 order line information history for countries
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId WorksheetLine/PurchLineHistory_W
CountryRegionName_RU WorksheetLine/PurchLineHistory_W
DeviationQty_RU WorksheetLine/PurchLineHistory_W
InvoiceGTDId_RU WorksheetLine/PurchLineHistory_W
MarkupCode_RU WorksheetLine/PurchLineHistory_W
PostingProfile_RU WorksheetLine/PurchLineHistory_W
PriceAgreementDate_RU WorksheetLine/PurchLineHistory_W
PurchLineHistory WorksheetLine/PurchLineHistory_W
RefReturnInvoiceTrans_W WorksheetLine/PurchLineHistory_W
RefInvoiceDate_MY WorksheetLine/PurchLineHistory_W
RefInvoiceID_MY WorksheetLine/PurchLineHistory_W
WithholdingTypeCode_MX WorksheetLine/PurchLineHistory_W
DataAreaId WorksheetLine/PurchLineHistory_W
Relationship_MarkupCodeVendRelationshipId WorksheetLine/PurchLineHistory_W
Relationship_PurchLineHistoryRelationshipId WorksheetLine/PurchLineHistory_W
Relationship_VendInvoiceTrans_WRelationshipId WorksheetLine/PurchLineHistory_W
Relationship_VendLedger_RURelationshipId WorksheetLine/PurchLineHistory_W
Relationship_CompanyRelationshipId WorksheetLine/PurchLineHistory_W

RecId

First included in: WorksheetLine/PurchLineHistory_W (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
attributePurchLineHistory_W/(resolvedAttributes)/RecIdattribute

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

CountryRegionName_RU

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

DeviationQty_RU

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

InvoiceGTDId_RU

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

MarkupCode_RU

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PostingProfile_RU

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PriceAgreementDate_RU

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the PriceAgreementDate_RU attribute are listed below.

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

is.dataFormat.date

PurchLineHistory

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatint64

Traits

List of traits for the PurchLineHistory attribute are listed below.

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

RefReturnInvoiceTrans_W

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

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

RefInvoiceDate_MY

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
displayNameOriginal invoice date
dataFormatdate
isNullabletrue

Traits

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

is.dataFormat.date

RefInvoiceID_MY

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
displayNameOriginal invoice number
dataFormatstring
isNullabletrue

Traits

List of traits for the RefInvoiceID_MY 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
enOriginal invoice number
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

WithholdingTypeCode_MX

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

DataAreaId

First included in: WorksheetLine/PurchLineHistory_W (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_MarkupCodeVendRelationshipId

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_PurchLineHistoryRelationshipId

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PurchLineHistoryRelationshipId 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/Transaction/PurchLineHistory.cdm.json/PurchLineHistoryRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_VendInvoiceTrans_WRelationshipId

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_VendInvoiceTrans_WRelationshipId 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/AccountsPayable/Transaction/VendInvoiceTrans.cdm.json/VendInvoiceTransRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_VendLedger_RURelationshipId

First included in: WorksheetLine/PurchLineHistory_W (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_VendLedger_RURelationshipId 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/AccountsPayable/Group/VendLedger.cdm.json/VendLedgerRecId
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: WorksheetLine/PurchLineHistory_W (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