編輯

共用方式為


Purchase order lines in WorksheetLine(PurchLine)

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
attributePurchLine/(resolvedAttributes)/RecIdattribute

is.CDM.entityVersion

ParameterValueData typeExplanation
versionNumber"1.1"stringsemantic version number of the entity

is.application.releaseVersion

ParameterValueData typeExplanation
releaseVersion"10.0.13.0"stringsemantic version number of the application introducing this entity

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enPurchase order lines
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId WorksheetLine/PurchLine
TaxItemGroup WorksheetLine/PurchLine
TaxGroup WorksheetLine/PurchLine
AccountingDistributionTemplate WorksheetLine/PurchLine
ActivityNumber WorksheetLine/PurchLine
AddressRefRecId WorksheetLine/PurchLine
AddressRefTableId WorksheetLine/PurchLine
AgreementSkipAutoLink WorksheetLine/PurchLine
AssetBookId WorksheetLine/PurchLine
AssetGroup WorksheetLine/PurchLine
AssetId WorksheetLine/PurchLine
AssetTransTypePurch WorksheetLine/PurchLine
BarCode WorksheetLine/PurchLine
BarCodeType WorksheetLine/PurchLine
Blocked WorksheetLine/PurchLine
CFOPTable_BR WorksheetLine/PurchLine
Complete WorksheetLine/PurchLine
ConfirmedDlv WorksheetLine/PurchLine
ConfirmedTaxAmount WorksheetLine/PurchLine
ConfirmedTaxWriteCode WorksheetLine/PurchLine
CountyOrigDest WorksheetLine/PurchLine
CovRef WorksheetLine/PurchLine
CreateFixedAsset WorksheetLine/PurchLine
CurrencyCode WorksheetLine/PurchLine
CustomerRef WorksheetLine/PurchLine
CustPurchaseOrderFormNum WorksheetLine/PurchLine
DefaultDimension WorksheetLine/PurchLine
DeliveryDate WorksheetLine/PurchLine
DeliveryName WorksheetLine/PurchLine
DeliveryPostalAddress WorksheetLine/PurchLine
DeliveryType WorksheetLine/PurchLine
DepreciationStartDate WorksheetLine/PurchLine
DiscAmount WorksheetLine/PurchLine
DiscPercent WorksheetLine/PurchLine
EditableInWorkflow WorksheetLine/PurchLine
ExternalItemId WorksheetLine/PurchLine
GSTHSTTaxType_CA WorksheetLine/PurchLine
InterCompanyInventTransId WorksheetLine/PurchLine
InterCompanyOrigin WorksheetLine/PurchLine
IntrastatFulfillmentDate_HU WorksheetLine/PurchLine
InventDimId WorksheetLine/PurchLine
InventInvoiceNow WorksheetLine/PurchLine
InventReceivedNow WorksheetLine/PurchLine
InventRefId WorksheetLine/PurchLine
InventRefTransId WorksheetLine/PurchLine
InventTransId WorksheetLine/PurchLine
IsDeleted WorksheetLine/PurchLine
IsFinalized WorksheetLine/PurchLine
IsInvoiceMatched WorksheetLine/PurchLine
IsModified WorksheetLine/PurchLine
IsPwp WorksheetLine/PurchLine
ItemBOMId WorksheetLine/PurchLine
ItemId WorksheetLine/PurchLine
ItemRefType WorksheetLine/PurchLine
ItemRouteId WorksheetLine/PurchLine
LedgerDimension WorksheetLine/PurchLine
LineAmount WorksheetLine/PurchLine
LineDeliveryType WorksheetLine/PurchLine
LineDisc WorksheetLine/PurchLine
LineHeader WorksheetLine/PurchLine
LineNumber WorksheetLine/PurchLine
LinePercent WorksheetLine/PurchLine
ManualEntryChangepolicy WorksheetLine/PurchLine
ManualModifiedField WorksheetLine/PurchLine
MatchingAgreementLine WorksheetLine/PurchLine
MatchingPolicy WorksheetLine/PurchLine
MCRDropShipComment WorksheetLine/PurchLine
MCRDropShipment WorksheetLine/PurchLine
MCRDropShipStatus WorksheetLine/PurchLine
MCROrderLine2PriceHistoryRef WorksheetLine/PurchLine
MultiLnDisc WorksheetLine/PurchLine
MultiLnPercent WorksheetLine/PurchLine
Name WorksheetLine/PurchLine
OperationType_MX WorksheetLine/PurchLine
OverDeliveryPct WorksheetLine/PurchLine
PackedExtensions WorksheetLine/PurchLine
PackedWHSLine WorksheetLine/PurchLine
PDSCalculationId WorksheetLine/PurchLine
PdsCWInventReceivedNow WorksheetLine/PurchLine
PdsCWQty WorksheetLine/PurchLine
PdsCWRemainInventFinancial WorksheetLine/PurchLine
PdsCWRemainInventPhysical WorksheetLine/PurchLine
PlanReference WorksheetLine/PurchLine
Port WorksheetLine/PurchLine
PriceUnit WorksheetLine/PurchLine
ProcurementCategory WorksheetLine/PurchLine
ProjCategoryId WorksheetLine/PurchLine
ProjId WorksheetLine/PurchLine
ProjLinePropertyId WorksheetLine/PurchLine
ProjSalesCurrencyId WorksheetLine/PurchLine
ProjSalesPrice WorksheetLine/PurchLine
ProjSalesUnitId WorksheetLine/PurchLine
ProjTaxGroupId WorksheetLine/PurchLine
ProjTaxItemGroupId WorksheetLine/PurchLine
ProjTransId WorksheetLine/PurchLine
ProjWorker WorksheetLine/PurchLine
PSARetainScheduleId WorksheetLine/PurchLine
PSATotalRetainAmount WorksheetLine/PurchLine
PurchaseType WorksheetLine/PurchLine
PurchCommitmentLine_PSN WorksheetLine/PurchLine
PurchId WorksheetLine/PurchLine
PurchMarkup WorksheetLine/PurchLine
PurchPrice WorksheetLine/PurchLine
PurchQty WorksheetLine/PurchLine
PurchReceivedNow WorksheetLine/PurchLine
PurchReqId WorksheetLine/PurchLine
PurchReqLineRefId WorksheetLine/PurchLine
PurchStatus WorksheetLine/PurchLine
PurchUnit WorksheetLine/PurchLine
QtyOrdered WorksheetLine/PurchLine
RBOPackageLineNum WorksheetLine/PurchLine
Remainder WorksheetLine/PurchLine
RemainInventFinancial WorksheetLine/PurchLine
RemainInventPhysical WorksheetLine/PurchLine
RemainPurchFinancial WorksheetLine/PurchLine
RemainPurchPhysical WorksheetLine/PurchLine
ReqAttention WorksheetLine/PurchLine
ReqPlanIdSched WorksheetLine/PurchLine
ReqPOId WorksheetLine/PurchLine
Requester WorksheetLine/PurchLine
RetailLineNumEx1 WorksheetLine/PurchLine
RetailPackageId WorksheetLine/PurchLine
RetailTempValueEx2 WorksheetLine/PurchLine
ReturnActionId WorksheetLine/PurchLine
ReturnDispositionCodeId WorksheetLine/PurchLine
ReturnStatus WorksheetLine/PurchLine
Scrap WorksheetLine/PurchLine
ServiceAddress WorksheetLine/PurchLine
ServiceDate WorksheetLine/PurchLine
ShippingDateConfirmed WorksheetLine/PurchLine
ShippingDateRequested WorksheetLine/PurchLine
SkipUpdate WorksheetLine/PurchLine
SourceDocumentLine WorksheetLine/PurchLine
StatisticValue_LT WorksheetLine/PurchLine
StatProcId WorksheetLine/PurchLine
StatTriangularDeal WorksheetLine/PurchLine
StockedProduct WorksheetLine/PurchLine
SystemEntryChangePolicy WorksheetLine/PurchLine
SystemEntrySource WorksheetLine/PurchLine
TAMItemVendRebateGroupId WorksheetLine/PurchLine
Tax1099Amount WorksheetLine/PurchLine
Tax1099Fields WorksheetLine/PurchLine
Tax1099RecId WorksheetLine/PurchLine
Tax1099State WorksheetLine/PurchLine
Tax1099StateAmount WorksheetLine/PurchLine
TaxAutogenerated WorksheetLine/PurchLine
TaxServiceCode_BR WorksheetLine/PurchLine
TaxWithholdBaseCur_TH WorksheetLine/PurchLine
TaxWithholdGroup_TH WorksheetLine/PurchLine
TaxWithholdItemGroupHeading_TH WorksheetLine/PurchLine
TransactionCode WorksheetLine/PurchLine
Transport WorksheetLine/PurchLine
UnderDeliveryPct WorksheetLine/PurchLine
VariantId WorksheetLine/PurchLine
VendAccount WorksheetLine/PurchLine
VendGroup WorksheetLine/PurchLine
WfDeliveryDueState WorksheetLine/PurchLine
WfInvReceivedState WorksheetLine/PurchLine
WorkflowState WorksheetLine/PurchLine
CreditedVendInvoiceTrans WorksheetLine/PurchLine
IntrastatCommodity WorksheetLine/PurchLine
OrigCountryRegionId WorksheetLine/PurchLine
OrigStateId WorksheetLine/PurchLine
SkipCreateMarkup WorksheetLine/PurchLine
IntercompanyOSOSourcingInventSiteId WorksheetLine/PurchLine
IntercompanyOSOSourcingInventLocationId WorksheetLine/PurchLine
PurchaseOrderLineCreationMethod WorksheetLine/PurchLine
BudgetReservationLine_PSN WorksheetLine/PurchLine
SyncIntercompanySalesLine WorksheetLine/PurchLine
SkipDeliveryScheduleUpdate WorksheetLine/PurchLine
SkipPriceDiscCalc WorksheetLine/PurchLine
PurchSupplierAuxId WorksheetLine/PurchLine
PSNLeadTime WorksheetLine/PurchLine
PSNCalendarDays WorksheetLine/PurchLine
PSNCalculateDeliveryDate WorksheetLine/PurchLine
DataAreaId WorksheetLine/PurchLine
Relationship_AccountingDistributionTemplateRelationshipId WorksheetLine/PurchLine
Relationship_AgreementLineRelationshipId WorksheetLine/PurchLine
Relationship_AssetBookRelationshipId WorksheetLine/PurchLine
Relationship_AssetBookTableRelationshipId WorksheetLine/PurchLine
Relationship_AssetGroupRelationshipId WorksheetLine/PurchLine
Relationship_AssetTableRelationshipId WorksheetLine/PurchLine
Relationship_BarcodeSetupRelationshipId WorksheetLine/PurchLine
Relationship_BOMTableRelationshipId WorksheetLine/PurchLine
Relationship_CFOPTable_BRRelationshipId WorksheetLine/PurchLine
Relationship_CountyOrigDestRelationshipId WorksheetLine/PurchLine
Relationship_CurrencyRelationshipId WorksheetLine/PurchLine
Relationship_DefaultDimensionRelationshipId WorksheetLine/PurchLine
Relationship_DeliveryPostalAddressRelationshipId WorksheetLine/PurchLine
Relationship_IntrastatPortRelationshipId WorksheetLine/PurchLine
Relationship_IntrastatStatProcRelationshipId WorksheetLine/PurchLine
Relationship_IntrastatTransactionCodeRelationshipId WorksheetLine/PurchLine
Relationship_IntrastatTransportModeRelationshipId WorksheetLine/PurchLine
Relationship_InventDimRelationshipId WorksheetLine/PurchLine
Relationship_InventDimCombinationRelationshipId WorksheetLine/PurchLine
Relationship_InventItemBarcodeRelationshipId WorksheetLine/PurchLine
Relationship_InventJournalTableRefRelationshipId WorksheetLine/PurchLine
Relationship_InventTableRelationshipId WorksheetLine/PurchLine
Relationship_InventTransOriginRelationshipId WorksheetLine/PurchLine
Relationship_LedgerDimensionRelationshipId WorksheetLine/PurchLine
Relationship_MCRSalesLineRefRelationshipId WorksheetLine/PurchLine
Relationship_PlanReferenceRelationshipId WorksheetLine/PurchLine
Relationship_PriceDiscChangePolicyRecId1RelationshipId WorksheetLine/PurchLine
Relationship_PriceDiscChangePolicyRecId2RelationshipId WorksheetLine/PurchLine
Relationship_ProcurementCategoryRelationshipId WorksheetLine/PurchLine
Relationship_ProdLineRefRelationshipId WorksheetLine/PurchLine
Relationship_ProdTableRefRelationshipId WorksheetLine/PurchLine
Relationship_ProjCategoryRelationshipId WorksheetLine/PurchLine
Relationship_ProjectSalesCurrencyRelationshipId WorksheetLine/PurchLine
Relationship_ProjectTaxGroupHeadingRelationshipId WorksheetLine/PurchLine
Relationship_ProjectTaxItemGroupHeadingRelationshipId WorksheetLine/PurchLine
Relationship_ProjItemTransRelationshipId WorksheetLine/PurchLine
Relationship_ProjLinePropertyRelationshipId WorksheetLine/PurchLine
Relationship_ProjTableRelationshipId WorksheetLine/PurchLine
Relationship_PSAVendorRetentionTermsTableRelationshipId WorksheetLine/PurchLine
Relationship_PurchCommitmentLine_PSNRelationshipId WorksheetLine/PurchLine
Relationship_PurchReqLineRelationshipId WorksheetLine/PurchLine
Relationship_PurchReqTableRelationshipId WorksheetLine/PurchLine
Relationship_PurchReturnActionDefaultsRelationshipId WorksheetLine/PurchLine
Relationship_PurchTableRelationshipId WorksheetLine/PurchLine
Relationship_ReqPlanSchedRelationshipId WorksheetLine/PurchLine
Relationship_ReturnDispositionCodeRelationshipId WorksheetLine/PurchLine
Relationship_RouteTableRelationshipId WorksheetLine/PurchLine
Relationship_SalesTableRefRelationshipId WorksheetLine/PurchLine
Relationship_SourceDocumentLineRelationshipId WorksheetLine/PurchLine
Relationship_StateRelationshipId WorksheetLine/PurchLine
Relationship_TAMItemVendRebateGroupRelationshipId WorksheetLine/PurchLine
Relationship_Tax1099BoxDetailRelationshipId WorksheetLine/PurchLine
Relationship_Tax1099FieldsRelationshipId WorksheetLine/PurchLine
Relationship_TaxGroupHeadingRelationshipId WorksheetLine/PurchLine
Relationship_TaxItemGroupHeadingRelationshipId WorksheetLine/PurchLine
Relationship_TaxServiceCode_BRRelationshipId WorksheetLine/PurchLine
Relationship_TaxWithholdGroupHeadingRelationshipId WorksheetLine/PurchLine
Relationship_TaxWithholdItemGroupHeading_THRelationshipId WorksheetLine/PurchLine
Relationship_VendGroupRelationshipId WorksheetLine/PurchLine
Relationship_VendTableRelationshipId WorksheetLine/PurchLine
Relationship_CreditedVendInvoiceTransRelationshipId WorksheetLine/PurchLine
Relationship_OrigCountryRegionRelationshipId WorksheetLine/PurchLine
Relationship_OrigStateRelationshipId WorksheetLine/PurchLine
Relationship_IntrastatCommodityRelationshipId WorksheetLine/PurchLine
Relationship_BudgetReservationLine_PSNRelationshipId WorksheetLine/PurchLine
Relationship_CompanyRelationshipId WorksheetLine/PurchLine

RecId

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

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

TaxItemGroup

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

TaxGroup

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

AccountingDistributionTemplate

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

AddressRefRecId

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

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AgreementSkipAutoLink attribute are listed below.

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

is.dataFormat.integer

AssetBookId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

AssetGroup

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
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.dataFormat.character
is.dataFormat.array

AssetId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

AssetTransTypePurch

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AssetTransTypePurch attribute are listed below.

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

is.dataFormat.integer

BarCode

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

BarCodeType

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Blocked

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the Blocked attribute are listed below.

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

is.dataFormat.integer

CFOPTable_BR

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

Complete

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the Complete attribute are listed below.

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

is.dataFormat.integer

ConfirmedDlv

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameConfirmed delivery date
dataFormatdate
isNullabletrue

Traits

List of traits for the ConfirmedDlv attribute are listed below.

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enConfirmed delivery date
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

ConfirmedTaxAmount

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

ConfirmedTaxWriteCode

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CountyOrigDest

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CovRef

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the CovRef attribute are listed below.

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

is.dataFormat.integer

CreateFixedAsset

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the CreateFixedAsset attribute are listed below.

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

is.dataFormat.integer

CurrencyCode

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the CurrencyCode attribute are listed below.

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

CustomerRef

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CustPurchaseOrderFormNum

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the CustPurchaseOrderFormNum 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/PurchLine (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

DeliveryDate

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the DeliveryDate attribute are listed below.

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

is.dataFormat.date

DeliveryName

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

DeliveryType

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the DeliveryType attribute are listed below.

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

is.dataFormat.integer

DepreciationStartDate

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the DepreciationStartDate attribute are listed below.

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

is.dataFormat.date

DiscAmount

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

DiscPercent

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

EditableInWorkflow

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the EditableInWorkflow attribute are listed below.

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

is.dataFormat.integer

ExternalItemId

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

GSTHSTTaxType_CA

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the GSTHSTTaxType_CA attribute are listed below.

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

is.dataFormat.integer

InterCompanyInventTransId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InterCompanyOrigin

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the InterCompanyOrigin attribute are listed below.

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

is.dataFormat.integer

IntrastatFulfillmentDate_HU

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the IntrastatFulfillmentDate_HU attribute are listed below.

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

is.dataFormat.date

InventDimId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

InventInvoiceNow

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameInvoice now
dataFormatdecimal
isNullabletrue

Traits

List of traits for the InventInvoiceNow attribute are listed below.

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

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

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

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

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

InventReceivedNow

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameReceive now
dataFormatdecimal
isNullabletrue

Traits

List of traits for the InventReceivedNow attribute are listed below.

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

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

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

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

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

InventRefId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

InventRefTransId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

InventTransId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

IsDeleted

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the IsDeleted attribute are listed below.

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

is.dataFormat.integer

IsFinalized

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the IsFinalized attribute are listed below.

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

is.dataFormat.integer

IsInvoiceMatched

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the IsInvoiceMatched attribute are listed below.

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

is.dataFormat.integer

IsModified

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the IsModified attribute are listed below.

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

is.dataFormat.integer

IsPwp

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNamePay when paid
dataFormatint32
isNullabletrue

Traits

List of traits for the IsPwp 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
enPay when paid
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

ItemBOMId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ItemId

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

ItemRefType

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the ItemRefType attribute are listed below.

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

is.dataFormat.integer

ItemRouteId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

LedgerDimension

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameLedger account
dataFormatint64
isNullabletrue

Traits

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

is.dataFormat.integer
is.dataFormat.big

LineAmount

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

LineDeliveryType

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the LineDeliveryType attribute are listed below.

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

is.dataFormat.integer

LineDisc

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

LineHeader

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

LineNumber

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

LinePercent

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

ManualEntryChangepolicy

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

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

ManualModifiedField

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ManualModifiedField attribute are listed below.

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

is.dataFormat.integer

MatchingAgreementLine

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

MatchingPolicy

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameMatching policy
dataFormatint32
isNullabletrue

Traits

List of traits for the MatchingPolicy attribute are listed below.

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

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

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

is.dataFormat.integer

MCRDropShipComment

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

MCRDropShipment

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the MCRDropShipment attribute are listed below.

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

is.dataFormat.integer

MCRDropShipStatus

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the MCRDropShipStatus attribute are listed below.

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

is.dataFormat.integer

MCROrderLine2PriceHistoryRef

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

MultiLnDisc

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

MultiLnPercent

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

Name

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
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.dataFormat.character
is.dataFormat.array

OperationType_MX

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the OperationType_MX attribute are listed below.

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

is.dataFormat.integer

OverDeliveryPct

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

PackedExtensions

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

PackedWHSLine

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatbinary
isNullabletrue

Traits

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

PDSCalculationId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

PdsCWInventReceivedNow

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

PdsCWQty

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

PdsCWRemainInventFinancial

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameCW invoice remainder
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCW invoice remainder
entitya reference to the constant entity holding the list of localized text

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

PdsCWRemainInventPhysical

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameCW deliver remainder
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCW deliver remainder
entitya reference to the constant entity holding the list of localized text

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

PlanReference

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameOriginating plan reference
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

List of traits for the PlanReference attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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
enOriginating plan reference
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

Port

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PriceUnit

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

ProjId

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

ProjLinePropertyId

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

ProjSalesCurrencyId

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

ProjSalesUnitId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameSales unit
dataFormatstring
isNullabletrue

Traits

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

is.dataFormat.character
is.dataFormat.array

ProjTaxGroupId

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

ProjTaxItemGroupId

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

ProjTransId

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

ProjWorker

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

PSARetainScheduleId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PSATotalRetainAmount

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameTotal amount
dataFormatdecimal
isNullabletrue

Traits

List of traits for the PSATotalRetainAmount attribute are listed below.

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

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

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

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

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

PurchaseType

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameType
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

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

is.dataFormat.integer

PurchCommitmentLine_PSN

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameCommitment
dataFormatint64
isNullabletrue

Traits

List of traits for the PurchCommitmentLine_PSN attribute are listed below.

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

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

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

is.dataFormat.integer
is.dataFormat.big

PurchId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the PurchId attribute are listed below.

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

PurchMarkup

First included in: WorksheetLine/PurchLine (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/PurchLine (this entity)

Properties

NameValue
displayNameUnit price
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.localized.displayedAs
Holds the list of language specific display text for an object.

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

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

PurchQty

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

PurchReceivedNow

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameReceive now
dataFormatdecimal
isNullabletrue

Traits

List of traits for the PurchReceivedNow attribute are listed below.

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

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

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

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

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

PurchReqId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

PurchReqLineRefId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid
isNullabletrue

Traits

List of traits for the PurchReqLineRefId attribute are listed below.

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

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

PurchStatus

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameLine status
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

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

is.dataFormat.integer

PurchUnit

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

QtyOrdered

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

RBOPackageLineNum

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNamePackage line number
dataFormatdecimal
isNullabletrue

Traits

List of traits for the RBOPackageLineNum attribute are listed below.

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

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enPackage line number
entitya reference to the constant entity holding the list of localized text

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

Remainder

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameRemainder
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

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

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

RemainInventFinancial

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameInvoice remainder
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

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

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

RemainInventPhysical

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameInventory deliver remainder
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enInventory deliver remainder
entitya reference to the constant entity holding the list of localized text

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

RemainPurchFinancial

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameInvoice remainder
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

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

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

RemainPurchPhysical

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameDeliver remainder
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

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

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

ReqAttention

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ReqPlanIdSched

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ReqPOId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Requester

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

RetailLineNumEx1

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

RetailPackageId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

RetailTempValueEx2

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

ReturnActionId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ReturnDispositionCodeId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

ReturnStatus

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the ReturnStatus attribute are listed below.

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

is.dataFormat.integer

Scrap

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameScrap
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

ServiceAddress

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameService address
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

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

is.dataFormat.character
is.dataFormat.array

ServiceDate

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameService date
dataFormatdate
isNullabletrue

Traits

List of traits for the ServiceDate attribute are listed below.

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

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

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

is.dataFormat.date

ShippingDateConfirmed

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ShippingDateConfirmed attribute are listed below.

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

is.dataFormat.date

ShippingDateRequested

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the ShippingDateRequested attribute are listed below.

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

is.dataFormat.date

SkipUpdate

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the SkipUpdate 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/PurchLine (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

StatisticValue_LT

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

StatProcId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

StatTriangularDeal

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the StatTriangularDeal attribute are listed below.

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

is.dataFormat.integer

StockedProduct

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the StockedProduct attribute are listed below.

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

is.dataFormat.integer

SystemEntryChangePolicy

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

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

SystemEntrySource

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the SystemEntrySource attribute are listed below.

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

is.dataFormat.integer

TAMItemVendRebateGroupId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Tax1099Amount

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

Tax1099Fields

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

Tax1099RecId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

Tax1099State

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Tax1099StateAmount

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

TaxAutogenerated

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the TaxAutogenerated attribute are listed below.

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

is.dataFormat.integer

TaxServiceCode_BR

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

TaxWithholdBaseCur_TH

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameAdjusted withholding tax
dataFormatdecimal
isNullabletrue

Traits

List of traits for the TaxWithholdBaseCur_TH attribute are listed below.

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

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enAdjusted withholding tax
entitya reference to the constant entity holding the list of localized text

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

TaxWithholdGroup_TH

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TaxWithholdItemGroupHeading_TH

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

TransactionCode

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Transport

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UnderDeliveryPct

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

VariantId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the VariantId 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/PurchLine (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the VendAccount attribute are listed below.

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

VendGroup

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameGroup
dataFormatstring
isReadOnlytrue

Traits

List of traits for the VendGroup attribute are listed below.

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

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

is.dataFormat.character
is.dataFormat.array

WfDeliveryDueState

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the WfDeliveryDueState attribute are listed below.

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

is.dataFormat.integer

WfInvReceivedState

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the WfInvReceivedState attribute are listed below.

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

is.dataFormat.integer

WorkflowState

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the WorkflowState attribute are listed below.

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

is.dataFormat.integer

CreditedVendInvoiceTrans

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

IntrastatCommodity

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

OrigCountryRegionId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameCountry/region of origin
dataFormatstring
isNullabletrue

Traits

List of traits for the OrigCountryRegionId 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
enCountry/region of origin
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

OrigStateId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
displayNameState of origin
dataFormatstring
isNullabletrue

Traits

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

is.dataFormat.character
is.dataFormat.array

SkipCreateMarkup

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the SkipCreateMarkup attribute are listed below.

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

is.dataFormat.integer

IntercompanyOSOSourcingInventSiteId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

IntercompanyOSOSourcingInventLocationId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PurchaseOrderLineCreationMethod

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the PurchaseOrderLineCreationMethod 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/PurchLine (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

SyncIntercompanySalesLine

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the SyncIntercompanySalesLine attribute are listed below.

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

is.dataFormat.integer

SkipDeliveryScheduleUpdate

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the SkipDeliveryScheduleUpdate attribute are listed below.

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

is.dataFormat.integer

SkipPriceDiscCalc

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the SkipPriceDiscCalc attribute are listed below.

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

is.dataFormat.integer

PurchSupplierAuxId

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

PSNLeadTime

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

PSNCalendarDays

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

PSNCalculateDeliveryDate

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PSNCalculateDeliveryDate attribute are listed below.

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

is.dataFormat.integer

DataAreaId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the DataAreaId attribute are listed below.

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

Relationship_AccountingDistributionTemplateRelationshipId

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

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_AssetBookRelationshipId 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/Main/AssetBook.cdm.json/AssetBookRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_AssetBookTableRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_AssetBookTableRelationshipId 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/Main/AssetBookTable.cdm.json/AssetBookTableRecId
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/PurchLine (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_AssetTableRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_AssetTableRelationshipId 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/Main/AssetTable.cdm.json/AssetTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_BarcodeSetupRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_BOMTableRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_BOMTableRelationshipId 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/BOMTable.cdm.json/BOMTableRecId
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/PurchLine (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_CountyOrigDestRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CountyOrigDestRelationshipId 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/Group/LogisticsAddressCounty.cdm.json/LogisticsAddressCountyRecId
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/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CurrencyRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Common/Currency/Group/Currency.cdm.json/CurrencyRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_DefaultDimensionRelationshipId

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

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_IntrastatPortRelationshipId 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/Intrastat/Group/IntrastatPort.cdm.json/IntrastatPortRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_IntrastatStatProcRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_IntrastatStatProcRelationshipId 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/Intrastat/Group/IntrastatStatProc.cdm.json/IntrastatStatProcRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_IntrastatTransactionCodeRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_IntrastatTransactionCodeRelationshipId 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/Intrastat/Group/IntrastatTransactionCode.cdm.json/IntrastatTransactionCodeRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_IntrastatTransportModeRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_IntrastatTransportModeRelationshipId 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/Intrastat/Group/IntrastatTransportMode.cdm.json/IntrastatTransportModeRecId
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/PurchLine (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_InventDimCombinationRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_InventItemBarcodeRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_InventJournalTableRefRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_InventJournalTableRefRelationshipId 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/WorksheetHeader/InventJournalTable.cdm.json/InventJournalTableRecId
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/PurchLine (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_InventTransOriginRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_LedgerDimensionRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_MCRSalesLineRefRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_MCRSalesLineRefRelationshipId 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/SalesAndMarketing/WorksheetLine/SalesLine.cdm.json/SalesLineRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_PlanReferenceRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PlanReferenceRelationshipId 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/MasterPlanning/Main/PlanReference.cdm.json/PlanReferenceRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_PriceDiscChangePolicyRecId1RelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PriceDiscChangePolicyRecId1RelationshipId 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/SalesAndMarketing/Group/PriceDiscChangePolicy.cdm.json/PriceDiscChangePolicyRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_PriceDiscChangePolicyRecId2RelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PriceDiscChangePolicyRecId2RelationshipId 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/SalesAndMarketing/Group/PriceDiscChangePolicy.cdm.json/PriceDiscChangePolicyRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ProcurementCategoryRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProdLineRefRelationshipId 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/ProductionControl/WorksheetHeader/ProdTable.cdm.json/ProdTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ProdTableRefRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProdTableRefRelationshipId 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/ProductionControl/WorksheetHeader/ProdTable.cdm.json/ProdTableRecId
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/PurchLine (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_ProjectSalesCurrencyRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_PurchCommitmentLine_PSNRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PurchCommitmentLine_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/Miscellaneous/PurchCommitmentLine_PSN.cdm.json/PurchCommitmentLine_PSNRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_PurchReqLineRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PurchReqLineRelationshipId 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/PurchReqLine.cdm.json/PurchReqLineRecId
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/PurchLine (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_PurchReturnActionDefaultsRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_PurchReturnActionDefaultsRelationshipId 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/SalesAndMarketing/Group/ReturnActionDefaults.cdm.json/ReturnActionDefaultsRecId
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/PurchLine (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_ReqPlanSchedRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ReqPlanSchedRelationshipId 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/MasterPlanning/Group/ReqPlanSched.cdm.json/ReqPlanSchedRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_ReturnDispositionCodeRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ReturnDispositionCodeRelationshipId 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/SalesAndMarketing/Reference/ReturnDispositionCode.cdm.json/ReturnDispositionCodeRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_RouteTableRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_RouteTableRelationshipId 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/ProductionControl/Main/RouteTable.cdm.json/RouteTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SalesTableRefRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SalesTableRefRelationshipId 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/SalesAndMarketing/WorksheetHeader/SalesTable.cdm.json/SalesTableRecId
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/PurchLine (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_StateRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_StateRelationshipId 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/Group/LogisticsAddressState.cdm.json/LogisticsAddressStateRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TAMItemVendRebateGroupRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TAMItemVendRebateGroupRelationshipId 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/SalesAndMarketing/Group/TAMItemVendRebateGroup.cdm.json/TAMItemVendRebateGroupRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_Tax1099BoxDetailRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_Tax1099BoxDetailRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/AccountsPayable/Miscellaneous/Tax1099BoxDetail.cdm.json/Tax1099BoxDetailRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_Tax1099FieldsRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_Tax1099FieldsRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/AccountsPayable/Group/Tax1099Fields.cdm.json/Tax1099FieldsRecId
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/PurchLine (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/PurchLine (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/PurchLine (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_TaxWithholdGroupHeadingRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_TaxWithholdItemGroupHeading_THRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_VendGroupRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_VendGroupRelationshipId 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/Group/VendGroup.cdm.json/VendGroupRecId
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/PurchLine (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_CreditedVendInvoiceTransRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CreditedVendInvoiceTransRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/AccountsPayable/Transaction/VendInvoiceTrans.cdm.json/VendInvoiceTransRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_OrigCountryRegionRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_OrigCountryRegionRelationshipId 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/Group/LogisticsAddressCountryRegion.cdm.json/LogisticsAddressCountryRegionRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_OrigStateRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_OrigStateRelationshipId 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/Group/LogisticsAddressState.cdm.json/LogisticsAddressStateRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_IntrastatCommodityRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_CompanyRelationshipId

First included in: WorksheetLine/PurchLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
means.identity.entityId
is.linkedEntity.identifier
Marks the attribute(s) that hold foreign key references to a linked (used as an attribute) entity. This attribute is added to the resolved entity to enumerate the referenced entities.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfoRecId
entitya reference to the constant entity holding the list of entity references

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