Purchase order line information for countries in WorksheetLine(PurchLine_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

Parameter	Value	Data type	Explanation
attribute	PurchLine_W/(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 order line information for countries	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/PurchLine_W
CountryRegionName_RU		WorksheetLine/PurchLine_W
DeviationQty_RU		WorksheetLine/PurchLine_W
InvoiceGTDId_RU		WorksheetLine/PurchLine_W
MarkupCode_RU		WorksheetLine/PurchLine_W
PostingProfile_RU		WorksheetLine/PurchLine_W
PriceAgreementDate_RU		WorksheetLine/PurchLine_W
PurchLine		WorksheetLine/PurchLine_W
RefReturnInvoiceTrans_W		WorksheetLine/PurchLine_W
SADInvoiceLineNo_PL		WorksheetLine/PurchLine_W
RefInvoiceDate_MY		WorksheetLine/PurchLine_W
RefInvoiceId_MY		WorksheetLine/PurchLine_W
WithholdingTypeCode_MX		WorksheetLine/PurchLine_W
DataAreaId		WorksheetLine/PurchLine_W
Relationship_MarkupCodeVendRelationshipId		WorksheetLine/PurchLine_W
Relationship_PurchLineRelationshipId		WorksheetLine/PurchLine_W
Relationship_VendInvoiceTrans_WRelationshipId		WorksheetLine/PurchLine_W
Relationship_VendLedger_RURelationshipId		WorksheetLine/PurchLine_W
Relationship_CFDIWithholdingType_MXRelationshipId		WorksheetLine/PurchLine_W
Relationship_CompanyRelationshipId		WorksheetLine/PurchLine_W

RecId

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

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

CountryRegionName_RU

First included in: WorksheetLine/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

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

PurchLine

First included in: WorksheetLine/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the PurchLine attribute are listed below.

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

RefReturnInvoiceTrans_W

First included in: WorksheetLine/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

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

SADInvoiceLineNo_PL

First included in: WorksheetLine/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the SADInvoiceLineNo_PL attribute are listed below.

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

is.dataFormat.integer

RefInvoiceDate_MY

First included in: WorksheetLine/PurchLine_W (this entity)

Properties

Name	Value
displayName	Original invoice date
dataFormat	date
isNullable	true

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.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Original invoice date	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

RefInvoiceId_MY

First included in: WorksheetLine/PurchLine_W (this entity)

Properties

Name	Value
displayName	Original invoice number
dataFormat	string
isNullable	true

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.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Original invoice number	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

WithholdingTypeCode_MX

First included in: WorksheetLine/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/Group/MarkupTable.cdm.json/MarkupTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PurchLineRelationshipId

First included in: WorksheetLine/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchLineRelationshipId 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/WorksheetLine/PurchLine.cdm.json/PurchLine RecId	entity	a 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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountsPayable/Transaction/VendInvoiceTrans.cdm.json/VendInvoiceTrans RecId	entity	a 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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Finance/AccountsPayable/Group/VendLedger.cdm.json/VendLedger RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_CFDIWithholdingType_MXRelationshipId

First included in: WorksheetLine/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CFDIWithholdingType_MXRelationshipId 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/EInvoice/Group/CFDIWithholdingType_MX.cdm.json/CFDIWithholdingType_MX RecId	entity	a 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/PurchLine_W (this entity)

Properties

Name	Value
dataFormat	guid

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.

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