Purchase requisition lines in WorksheetLine(PurchReqLine)

Article
02/22/2022

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	PurchReqLine/(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 requisition lines

entity

a 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

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	PurchReqLine/(resolvedAttributes)/RecId	attribute

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

AccountingDistributionTemplate

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

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

Name	Value
displayName	Asset group
dataFormat	string
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Asset group

entity

a 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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
displayName	Asset acquisition rules qualifier
dataFormat	int64
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Asset acquisition rules qualifier

entity

a 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

Name	Value
displayName	Asset acquisition rules qualifier - local
dataFormat	int64
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Asset acquisition rules qualifier - local

entity

a 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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the BusinessJustification attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

BuyingLegalEntity

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
displayName	Buying legal entity
dataFormat	int64

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Buying legal entity

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

CFOPTable_BR

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
displayName	CFOP
dataFormat	int64
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	CFOP

entity

a 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

Name	Value
displayName	CFPS code
dataFormat	int64
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	CFPS code

entity

a 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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isReadOnly	true

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

Name	Value
dataFormat	string
isReadOnly	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the IsModified attribute are listed below.

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

is.dataFormat.integer

IsPreEncumbranceRequired

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
displayName	Prepayment required
dataFormat	int32
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Prepayment required

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

IsPurchaseOrderGenerationManual

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
displayName	Manual?
dataFormat	int32
isReadOnly	true
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Manual?

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

IsSaved

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	guid
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
displayName	Item description
dataFormat	string
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Item description

entity

a 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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
displayName	Project category
dataFormat	string
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Project category

entity

a 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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ProjId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ProjIdDataArea

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
displayName	Sales currency
dataFormat	string
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Sales currency

entity

a 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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
displayName	Sales unit
dataFormat	int64
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Sales unit

entity

a 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

Name	Value
displayName	Project sales tax group
dataFormat	string
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Project sales tax group

entity

a 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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
displayName	Project item sales tax group
dataFormat	string
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Project item sales tax group

entity

a 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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
displayName	Purchase agreement
dataFormat	int64
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Purchase agreement

entity

a 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

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
displayName	Purchase requisition reference
dataFormat	int64

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Purchase requisition reference

entity

a 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

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int64

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
displayName	Receiving operating unit
dataFormat	int64
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Receiving operating unit

entity

a 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

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the RequiredDate attribute are listed below.

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

is.dataFormat.date

Requisitioner

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	int64

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

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the RequisitionStatus attribute are listed below.

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

is.dataFormat.integer

RFQRequirement

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
displayName	Source document line
dataFormat	int64
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Source document line

entity

a 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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the TransDate attribute are listed below.

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

is.dataFormat.date

URL

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	binary
isNullable	true

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

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
dataFormat	int64
isNullable	true

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

Name	Value
dataFormat	decimal
isNullable	true

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

Name	Value
dataFormat	string
isNullable	true

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

Name	Value
dataFormat	int32
isNullable	true

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

Name	Value
displayName	Lead time
dataFormat	int32
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Lead time

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

Relationship_AccountingDistributionTemplateRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/Group/AccountingDistributionTemplate.cdm.json/AccountingDistributionTemplate	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AssetGroupRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/FixedAssets/Group/AssetGroup.cdm.json/AssetGroup	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AssetRuleQualifierOptionRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/FixedAssets/Reference/AssetRuleQualifierOption.cdm.json/AssetRuleQualifierOption	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_AssetRuleQualifierOptionLocalRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/FixedAssets/Reference/AssetRuleQualifierOptionLocal.cdm.json/AssetRuleQualifierOptionLocal	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CFOPTable_BRRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Bank/Group/CFOPTable_BR.cdm.json/CFOPTable_BR	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CFPSTable_BRRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/APARShared/Group/CFPSTable_BR.cdm.json/CFPSTable_BR	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyInfoRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfo	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_CurrencyRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CurrencyRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Currency/Group/Currency.cdm.json/Currency	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CurrencyCodeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Currency/Group/Currency.cdm.json/Currency	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DefaultDimensionRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/FinancialDimensions/Main/DimensionAttributeValueSet.cdm.json/DimensionAttributeValueSet	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DeliveryPostalAddressRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/GAB/Main/LogisticsPostalAddress.cdm.json/LogisticsPostalAddress	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_EcoResCategoryRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProductInformationManagement/Main/EcoResCategory.cdm.json/EcoResCategory	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventDimRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Main/InventDim.cdm.json/InventDim	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventLocationRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Group/InventLocation.cdm.json/InventLocation	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProductInformationManagement/Main/InventTable.cdm.json/InventTable	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_OMOperatingUnitRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/GAB/Main/OMOperatingUnit.cdm.json/OMOperatingUnit	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjCategoryRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjCategory.cdm.json/ProjCategory	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjItemTransRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Transaction/ProjItemTrans.cdm.json/ProjItemTrans	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjLinePropertyRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjLineProperty.cdm.json/ProjLineProperty	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_ProjTableRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Main/ProjTable.cdm.json/ProjTable	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_ProjTaxGroupHeadingRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjTaxGroupHeadingRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/TaxGroupHeading.cdm.json/TaxGroupHeading	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjTaxItemGroupHeadingRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/TaxItemGroupHeading.cdm.json/TaxItemGroupHeading	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchaseAgreementRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetLine/AgreementLine.cdm.json/AgreementLine	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PurchReqBusinessJustificationCodesRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchReqBusinessJustificationCodesRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/Reference/PurchReqBusinessJustificationCodes.cdm.json/PurchReqBusinessJustificationCodes	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_PurchReqTableRelationshipId

First included in: WorksheetLine/PurchReqLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchReqTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetHeader/PurchReqTable.cdm.json/PurchReqTable	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchRFQCaseTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetHeader/PurchRFQCaseTable.cdm.json/PurchRFQCaseTable	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PurchTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/ProcurementAndSourcing/WorksheetHeader/PurchTable.cdm.json/PurchTable	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ReasonRefRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Ledger/Transaction/ReasonTableRef.cdm.json/ReasonTableRef	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SalesPurchOperationType_BRRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Main/SalesPurchOperationType_BR.cdm.json/SalesPurchOperationType_BR	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_smmActivitiesRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Main/ProjActivity.cdm.json/ProjActivity	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SourceDocumentLineRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/TransactionLine/SourceDocumentLine.cdm.json/SourceDocumentLine	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxGroupHeadingRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/TaxGroupHeading.cdm.json/TaxGroupHeading	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxItemGroupHeadingRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/TaxItemGroupHeading.cdm.json/TaxItemGroupHeading	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxServiceCode_BRRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Tax/Group/TaxServiceCode_BR.cdm.json/TaxServiceCode_BR	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/SupplyChain/Vendor/Main/VendTable.cdm.json/VendTable	RecId

entity

a 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

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_BudgetReservationLine_PSNRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Budget/WorksheetLine/BudgetReservationLine_PSN.cdm.json/BudgetReservationLine_PSN	RecId

entity

a reference to the constant entity holding the list of entity references

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

Share via

Purchase requisition lines in WorksheetLine(PurchReqLine)

Traits

Attributes

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits