Bearbeiten

Freigeben über


Purchase requisition lines in WorksheetLine(PurchReqLine)

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
attributePurchReqLine/(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 requisition lines
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId WorksheetLine/PurchReqLine
AccountingDistributionTemplate WorksheetLine/PurchReqLine
ActivityNumber WorksheetLine/PurchReqLine
ActivityNumberDataArea WorksheetLine/PurchReqLine
AddressRefRecId WorksheetLine/PurchReqLine
AddressRefTableId WorksheetLine/PurchReqLine
AssetGroup WorksheetLine/PurchReqLine
AssetGroupDataArea WorksheetLine/PurchReqLine
AssetRuleQualifierOption WorksheetLine/PurchReqLine
AssetRuleQualifierOptionLocal WorksheetLine/PurchReqLine
AssetRuleQualifierOptionName WorksheetLine/PurchReqLine
Attention WorksheetLine/PurchReqLine
BusinessJustification WorksheetLine/PurchReqLine
BuyingLegalEntity WorksheetLine/PurchReqLine
CFOPTable_BR WorksheetLine/PurchReqLine
CFPSTable_BR WorksheetLine/PurchReqLine
CurrencyCode WorksheetLine/PurchReqLine
DefaultDimension WorksheetLine/PurchReqLine
DeliveryName WorksheetLine/PurchReqLine
DeliveryPostalAddress WorksheetLine/PurchReqLine
ExternalItemId WorksheetLine/PurchReqLine
InventDimId WorksheetLine/PurchReqLine
InventDimIdDataArea WorksheetLine/PurchReqLine
InventLocationId WorksheetLine/PurchReqLine
InventLocationIdDataArea WorksheetLine/PurchReqLine
IsModified WorksheetLine/PurchReqLine
IsPreEncumbranceRequired WorksheetLine/PurchReqLine
IsPrepayment WorksheetLine/PurchReqLine
IsPurchaseOrderGenerationManual WorksheetLine/PurchReqLine
IsSaved WorksheetLine/PurchReqLine
ItemId WorksheetLine/PurchReqLine
ItemIdDataArea WorksheetLine/PurchReqLine
ItemIdNonCatalog WorksheetLine/PurchReqLine
LineAmount WorksheetLine/PurchReqLine
LineComplete WorksheetLine/PurchReqLine
LineDisc WorksheetLine/PurchReqLine
LineNum WorksheetLine/PurchReqLine
LinePercent WorksheetLine/PurchReqLine
LineRefId WorksheetLine/PurchReqLine
LineType WorksheetLine/PurchReqLine
Name WorksheetLine/PurchReqLine
PrePaymentDetails WorksheetLine/PurchReqLine
PriceDiscountTransfer WorksheetLine/PurchReqLine
PriceUnit WorksheetLine/PurchReqLine
ProcurementCategory WorksheetLine/PurchReqLine
ProjCategoryId WorksheetLine/PurchReqLine
ProjCategoryIdDataArea WorksheetLine/PurchReqLine
ProjId WorksheetLine/PurchReqLine
ProjIdDataArea WorksheetLine/PurchReqLine
ProjLinePropertyId WorksheetLine/PurchReqLine
ProjLinePropertyIdDataArea WorksheetLine/PurchReqLine
ProjSalesCurrencyId WorksheetLine/PurchReqLine
ProjSalesPrice WorksheetLine/PurchReqLine
ProjSalesUnitOfMeasure WorksheetLine/PurchReqLine
ProjTaxGroupId WorksheetLine/PurchReqLine
ProjTaxGroupIdDataArea WorksheetLine/PurchReqLine
ProjTaxItemGroupId WorksheetLine/PurchReqLine
ProjTaxItemGroupIdDataArea WorksheetLine/PurchReqLine
ProjTransId WorksheetLine/PurchReqLine
ProjTransIdDataArea WorksheetLine/PurchReqLine
PurchAgreement WorksheetLine/PurchReqLine
PurchId WorksheetLine/PurchReqLine
PurchIdDataArea WorksheetLine/PurchReqLine
PurchLineCreated WorksheetLine/PurchReqLine
PurchMarkup WorksheetLine/PurchReqLine
PurchPrice WorksheetLine/PurchReqLine
PurchQty WorksheetLine/PurchReqLine
PurchReqConsolidationStatus WorksheetLine/PurchReqLine
PurchReqTable WorksheetLine/PurchReqLine
PurchRFQCaseId WorksheetLine/PurchReqLine
PurchRFQCaseIdDataArea WorksheetLine/PurchReqLine
PurchUnitOfMeasure WorksheetLine/PurchReqLine
ReasonRefRecId WorksheetLine/PurchReqLine
ReceivingOperatingUnit WorksheetLine/PurchReqLine
RequiredDate WorksheetLine/PurchReqLine
Requisitioner WorksheetLine/PurchReqLine
RequisitionPurpose WorksheetLine/PurchReqLine
RequisitionStatus WorksheetLine/PurchReqLine
RFQRequirement WorksheetLine/PurchReqLine
SalesPurchOperationType_BR WorksheetLine/PurchReqLine
SequenceNumber WorksheetLine/PurchReqLine
SourceDocumentLine WorksheetLine/PurchReqLine
TaxGroup WorksheetLine/PurchReqLine
TaxGroupDataArea WorksheetLine/PurchReqLine
TaxItemGroup WorksheetLine/PurchReqLine
TaxItemGroupDataArea WorksheetLine/PurchReqLine
TaxServiceCode_BR WorksheetLine/PurchReqLine
TransDate WorksheetLine/PurchReqLine
URL WorksheetLine/PurchReqLine
VendAccount WorksheetLine/PurchReqLine
VendAccountDataArea WorksheetLine/PurchReqLine
VendQuoteNumber WorksheetLine/PurchReqLine
PackedExtensions WorksheetLine/PurchReqLine
IsPriceDiscCalculated WorksheetLine/PurchReqLine
BudgetReservationLine_PSN WorksheetLine/PurchReqLine
CompanyLocation_IN WorksheetLine/PurchReqLine
ExciseRecordType_IN WorksheetLine/PurchReqLine
ExciseTariffCodes_IN WorksheetLine/PurchReqLine
ExciseType_IN WorksheetLine/PurchReqLine
Exempt_IN WorksheetLine/PurchReqLine
HSNCodeTable_IN WorksheetLine/PurchReqLine
ITCCategory_IN WorksheetLine/PurchReqLine
NonBusinessUsagePercentage_IN WorksheetLine/PurchReqLine
SalesTaxFormTypes_IN WorksheetLine/PurchReqLine
ServiceAccountingCodeTable_IN WorksheetLine/PurchReqLine
ServiceCodeTable_IN WorksheetLine/PurchReqLine
ServiceCategory_IN WorksheetLine/PurchReqLine
GTAServiceCategory_IN WorksheetLine/PurchReqLine
VATGoodsType_IN WorksheetLine/PurchReqLine
NonRecoverablePercent_IN WorksheetLine/PurchReqLine
VendorLocation_IN WorksheetLine/PurchReqLine
VendorTaxInformation_IN WorksheetLine/PurchReqLine
DSA_IN WorksheetLine/PurchReqLine
CustomsTariffCodeTable_IN WorksheetLine/PurchReqLine
MaximumRetailPrice_IN WorksheetLine/PurchReqLine
PurchSupplierAuxId WorksheetLine/PurchReqLine
PSNCalendarDays WorksheetLine/PurchReqLine
PSNLeadTime WorksheetLine/PurchReqLine
Relationship_AccountingDistributionTemplateRelationshipId WorksheetLine/PurchReqLine
Relationship_AssetGroupRelationshipId WorksheetLine/PurchReqLine
Relationship_AssetRuleQualifierOptionRelationshipId WorksheetLine/PurchReqLine
Relationship_AssetRuleQualifierOptionLocalRelationshipId WorksheetLine/PurchReqLine
Relationship_CFOPTable_BRRelationshipId WorksheetLine/PurchReqLine
Relationship_CFPSTable_BRRelationshipId WorksheetLine/PurchReqLine
Relationship_CompanyInfoRelationshipId WorksheetLine/PurchReqLine
Relationship_CurrencyRelationshipId WorksheetLine/PurchReqLine
Relationship_CurrencyCodeRelationshipId WorksheetLine/PurchReqLine
Relationship_DefaultDimensionRelationshipId WorksheetLine/PurchReqLine
Relationship_DeliveryPostalAddressRelationshipId WorksheetLine/PurchReqLine
Relationship_EcoResCategoryRelationshipId WorksheetLine/PurchReqLine
Relationship_InventDimRelationshipId WorksheetLine/PurchReqLine
Relationship_InventLocationRelationshipId WorksheetLine/PurchReqLine
Relationship_InventTableRelationshipId WorksheetLine/PurchReqLine
Relationship_OMOperatingUnitRelationshipId WorksheetLine/PurchReqLine
Relationship_ProjCategoryRelationshipId WorksheetLine/PurchReqLine
Relationship_ProjItemTransRelationshipId WorksheetLine/PurchReqLine
Relationship_ProjLinePropertyRelationshipId WorksheetLine/PurchReqLine
Relationship_ProjTableRelationshipId WorksheetLine/PurchReqLine
Relationship_ProjTaxGroupHeadingRelationshipId WorksheetLine/PurchReqLine
Relationship_ProjTaxItemGroupHeadingRelationshipId WorksheetLine/PurchReqLine
Relationship_PurchaseAgreementRelationshipId WorksheetLine/PurchReqLine
Relationship_PurchReqBusinessJustificationCodesRelationshipId WorksheetLine/PurchReqLine
Relationship_PurchReqTableRelationshipId WorksheetLine/PurchReqLine
Relationship_PurchRFQCaseTableRelationshipId WorksheetLine/PurchReqLine
Relationship_PurchTableRelationshipId WorksheetLine/PurchReqLine
Relationship_ReasonRefRelationshipId WorksheetLine/PurchReqLine
Relationship_SalesPurchOperationType_BRRelationshipId WorksheetLine/PurchReqLine
Relationship_smmActivitiesRelationshipId WorksheetLine/PurchReqLine
Relationship_SourceDocumentLineRelationshipId WorksheetLine/PurchReqLine
Relationship_TaxGroupHeadingRelationshipId WorksheetLine/PurchReqLine
Relationship_TaxItemGroupHeadingRelationshipId WorksheetLine/PurchReqLine
Relationship_TaxServiceCode_BRRelationshipId WorksheetLine/PurchReqLine
Relationship_VendTableRelationshipId WorksheetLine/PurchReqLine
Relationship_BudgetReservationLine_PSNRelationshipId WorksheetLine/PurchReqLine

RecId

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

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

AccountingDistributionTemplate

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ActivityNumber

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ActivityNumberDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

AddressRefRecId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

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

AddressRefTableId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the AddressRefTableId attribute are listed below.

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

is.dataFormat.integer

AssetGroup

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameAsset group
dataFormatstring
isNullabletrue

Traits

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

is.dataFormat.character
is.dataFormat.array

AssetGroupDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

AssetRuleQualifierOption

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameAsset acquisition rules qualifier
dataFormatint64
isNullabletrue

Traits

List of traits for the AssetRuleQualifierOption 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
enAsset acquisition rules qualifier
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

AssetRuleQualifierOptionLocal

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameAsset acquisition rules qualifier - local
dataFormatint64
isNullabletrue

Traits

List of traits for the AssetRuleQualifierOptionLocal 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
enAsset acquisition rules qualifier - local
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

AssetRuleQualifierOptionName

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Attention

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

BusinessJustification

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

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

BuyingLegalEntity

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameBuying legal entity
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
enBuying legal entity
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

CFOPTable_BR

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameCFOP
dataFormatint64
isNullabletrue

Traits

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

is.dataFormat.integer
is.dataFormat.big

CFPSTable_BR

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameCFPS code
dataFormatint64
isNullabletrue

Traits

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

is.dataFormat.integer
is.dataFormat.big

CurrencyCode

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

DefaultDimension

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

DeliveryName

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

DeliveryPostalAddress

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ExternalItemId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InventDimId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the InventDimId attribute are listed below.

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

InventDimIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the InventDimIdDataArea attribute are listed below.

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

InventLocationId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InventLocationIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the InventLocationIdDataArea 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: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

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

IsPreEncumbranceRequired

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsPreEncumbranceRequired attribute are listed below.

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

is.dataFormat.integer

IsPrepayment

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNamePrepayment required
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

IsPurchaseOrderGenerationManual

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameManual?
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

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

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

is.dataFormat.integer

IsSaved

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the IsSaved attribute are listed below.

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

is.dataFormat.integer

ItemId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ItemIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ItemIdNonCatalog

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

LineAmount

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

LineComplete

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the LineComplete attribute are listed below.

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

is.dataFormat.integer

LineDisc

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

LineNum

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

List of traits for the LineNum attribute are listed below.

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

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

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

LinePercent

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

LineRefId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid
isReadOnlytrue
isNullabletrue

Traits

List of traits for the LineRefId attribute are listed below.

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

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

LineType

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the LineType attribute are listed below.

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

is.dataFormat.integer

Name

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameItem description
dataFormatstring
isNullabletrue

Traits

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

is.dataFormat.character
is.dataFormat.array

PrePaymentDetails

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PriceDiscountTransfer

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PriceDiscountTransfer attribute are listed below.

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

is.dataFormat.integer

PriceUnit

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

ProcurementCategory

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ProjCategoryId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameProject category
dataFormatstring
isNullabletrue

Traits

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

is.dataFormat.character
is.dataFormat.array

ProjCategoryIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ProjId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

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: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ProjLinePropertyId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ProjLinePropertyIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ProjSalesCurrencyId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameSales currency
dataFormatstring
isNullabletrue

Traits

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

is.dataFormat.character
is.dataFormat.array

ProjSalesPrice

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

ProjSalesUnitOfMeasure

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameSales unit
dataFormatint64
isNullabletrue

Traits

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

is.dataFormat.integer
is.dataFormat.big

ProjTaxGroupId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameProject sales tax group
dataFormatstring
isNullabletrue

Traits

List of traits for the ProjTaxGroupId 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
enProject sales tax group
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

ProjTaxGroupIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ProjTaxItemGroupId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameProject item sales tax group
dataFormatstring
isNullabletrue

Traits

List of traits for the ProjTaxItemGroupId 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
enProject item sales tax group
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

ProjTaxItemGroupIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ProjTransId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

ProjTransIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PurchAgreement

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNamePurchase agreement
dataFormatint64
isNullabletrue

Traits

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

is.dataFormat.integer
is.dataFormat.big

PurchId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

PurchIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PurchLineCreated

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PurchLineCreated attribute are listed below.

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

is.dataFormat.integer

PurchMarkup

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

PurchPrice

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

PurchQty

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

PurchReqConsolidationStatus

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PurchReqConsolidationStatus attribute are listed below.

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

is.dataFormat.integer

PurchReqTable

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNamePurchase requisition reference
dataFormatint64

Traits

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

is.dataFormat.integer
is.dataFormat.big

PurchRFQCaseId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

PurchRFQCaseIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PurchUnitOfMeasure

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64

Traits

List of traits for the PurchUnitOfMeasure attribute are listed below.

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

ReasonRefRecId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ReceivingOperatingUnit

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameReceiving operating unit
dataFormatint64
isNullabletrue

Traits

List of traits for the ReceivingOperatingUnit 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
enReceiving operating unit
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

RequiredDate

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

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

Requisitioner

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64

Traits

List of traits for the Requisitioner attribute are listed below.

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

RequisitionPurpose

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the RequisitionPurpose attribute are listed below.

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

is.dataFormat.integer

RequisitionStatus

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

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

RFQRequirement

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the RFQRequirement attribute are listed below.

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

is.dataFormat.integer

SalesPurchOperationType_BR

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

SequenceNumber

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the SequenceNumber attribute are listed below.

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

is.dataFormat.integer

SourceDocumentLine

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameSource document line
dataFormatint64
isNullabletrue

Traits

List of traits for the SourceDocumentLine 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
enSource document line
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

TaxGroup

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TaxGroupDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TaxItemGroup

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TaxItemGroupDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TaxServiceCode_BR

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TransDate

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

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

URL

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

VendAccount

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

VendAccountDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

VendQuoteNumber

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PackedExtensions

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatbinary
isNullabletrue

Traits

List of traits for the PackedExtensions attribute are listed below.

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

is.dataFormat.byte
is.dataFormat.array

IsPriceDiscCalculated

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the IsPriceDiscCalculated attribute are listed below.

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

is.dataFormat.integer

BudgetReservationLine_PSN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

CompanyLocation_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ExciseRecordType_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ExciseRecordType_IN attribute are listed below.

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

is.dataFormat.integer

ExciseTariffCodes_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ExciseType_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ExciseType_IN attribute are listed below.

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

is.dataFormat.integer

Exempt_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the Exempt_IN attribute are listed below.

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

is.dataFormat.integer

HSNCodeTable_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ITCCategory_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ITCCategory_IN attribute are listed below.

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

is.dataFormat.integer

NonBusinessUsagePercentage_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

SalesTaxFormTypes_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ServiceAccountingCodeTable_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ServiceCodeTable_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ServiceCategory_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ServiceCategory_IN attribute are listed below.

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

is.dataFormat.integer

GTAServiceCategory_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the GTAServiceCategory_IN attribute are listed below.

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

is.dataFormat.integer

VATGoodsType_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the VATGoodsType_IN attribute are listed below.

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

is.dataFormat.integer

NonRecoverablePercent_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

VendorLocation_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

VendorTaxInformation_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

DSA_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the DSA_IN attribute are listed below.

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

is.dataFormat.integer

CustomsTariffCodeTable_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

MaximumRetailPrice_IN

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

PurchSupplierAuxId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PSNCalendarDays

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PSNCalendarDays attribute are listed below.

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

is.dataFormat.integer

PSNLeadTime

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
displayNameLead time
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

Relationship_AccountingDistributionTemplateRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_AccountingDistributionTemplateRelationshipId 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/AccountingFoundation/Group/AccountingDistributionTemplate.cdm.json/AccountingDistributionTemplateRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_AssetGroupRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_AssetGroupRelationshipId 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/FixedAssets/Group/AssetGroup.cdm.json/AssetGroupRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_AssetRuleQualifierOptionRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_AssetRuleQualifierOptionRelationshipId 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/FixedAssets/Reference/AssetRuleQualifierOption.cdm.json/AssetRuleQualifierOptionRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_AssetRuleQualifierOptionLocalRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_AssetRuleQualifierOptionLocalRelationshipId 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/FixedAssets/Reference/AssetRuleQualifierOptionLocal.cdm.json/AssetRuleQualifierOptionLocalRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CFOPTable_BRRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CFOPTable_BRRelationshipId 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/Bank/Group/CFOPTable_BR.cdm.json/CFOPTable_BRRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CFPSTable_BRRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CFPSTable_BRRelationshipId 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/APARShared/Group/CFPSTable_BR.cdm.json/CFPSTable_BRRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CompanyInfoRelationshipId

First included in: WorksheetLine/PurchReqLine (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_CurrencyRelationshipId

First included in: WorksheetLine/PurchReqLine (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_CurrencyCodeRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

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.

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: WorksheetLine/PurchReqLine (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_DeliveryPostalAddressRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_EcoResCategoryRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_EcoResCategoryRelationshipId 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/ProductInformationManagement/Main/EcoResCategory.cdm.json/EcoResCategoryRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_InventDimRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_InventDimRelationshipId 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/Inventory/Main/InventDim.cdm.json/InventDimRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_InventLocationRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_InventLocationRelationshipId 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/Inventory/Group/InventLocation.cdm.json/InventLocationRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_InventTableRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_InventTableRelationshipId 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/ProductInformationManagement/Main/InventTable.cdm.json/InventTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_OMOperatingUnitRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_ProjCategoryRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjCategoryRelationshipId 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/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjCategory.cdm.json/ProjCategoryRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ProjItemTransRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjItemTransRelationshipId 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/ProfessionalServices/ProjectManagementAndAccounting/Transaction/ProjItemTrans.cdm.json/ProjItemTransRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ProjLinePropertyRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjLinePropertyRelationshipId 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/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjLineProperty.cdm.json/ProjLinePropertyRecId
entitya 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: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Main/ProjTable.cdm.json/ProjTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ProjTaxGroupHeadingRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjTaxGroupHeadingRelationshipId 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/Tax/Group/TaxGroupHeading.cdm.json/TaxGroupHeadingRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ProjTaxItemGroupHeadingRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjTaxItemGroupHeadingRelationshipId 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/Tax/Group/TaxItemGroupHeading.cdm.json/TaxItemGroupHeadingRecId
entitya 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/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PurchaseAgreementRelationshipId 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/WorksheetLine/AgreementLine.cdm.json/AgreementLineRecId
entitya 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: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/Reference/PurchReqBusinessJustificationCodes.cdm.json/PurchReqBusinessJustificationCodesRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_PurchReqTableRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PurchReqTableRelationshipId 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/WorksheetHeader/PurchReqTable.cdm.json/PurchReqTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_PurchRFQCaseTableRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PurchRFQCaseTableRelationshipId 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/WorksheetHeader/PurchRFQCaseTable.cdm.json/PurchRFQCaseTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_PurchTableRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PurchTableRelationshipId 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/WorksheetHeader/PurchTable.cdm.json/PurchTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ReasonRefRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_SalesPurchOperationType_BRRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SalesPurchOperationType_BRRelationshipId 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/AccountsReceivable/Main/SalesPurchOperationType_BR.cdm.json/SalesPurchOperationType_BRRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_smmActivitiesRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_smmActivitiesRelationshipId 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/ProfessionalServices/ProjectManagementAndAccounting/Main/ProjActivity.cdm.json/ProjActivityRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SourceDocumentLineRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SourceDocumentLineRelationshipId 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/AccountingFoundation/TransactionLine/SourceDocumentLine.cdm.json/SourceDocumentLineRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TaxGroupHeadingRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TaxGroupHeadingRelationshipId 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/Tax/Group/TaxGroupHeading.cdm.json/TaxGroupHeadingRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TaxItemGroupHeadingRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TaxItemGroupHeadingRelationshipId 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/Tax/Group/TaxItemGroupHeading.cdm.json/TaxItemGroupHeadingRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TaxServiceCode_BRRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TaxServiceCode_BRRelationshipId 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/Tax/Group/TaxServiceCode_BR.cdm.json/TaxServiceCode_BRRecId
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: WorksheetLine/PurchReqLine (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

Relationship_BudgetReservationLine_PSNRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_BudgetReservationLine_PSNRelationshipId 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/Budget/WorksheetLine/BudgetReservationLine_PSN.cdm.json/BudgetReservationLine_PSNRecId
entitya reference to the constant entity holding the list of entity references

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