Sales order line history in WorksheetLine(MCRHistSalesLine)

Latest version of the JSON entity definition is available on GitHub.

Traits

Traits for this entity are listed below.

is.identifiedBy
names a specifc identity attribute to use with an entity

Parameter	Value	Data type	Explanation
attribute	MCRHistSalesLine/(resolvedAttributes)/RecId	attribute

is.CDM.entityVersion

Parameter	Value	Data type	Explanation
versionNumber	"1.0"	string	semantic version number of the entity

is.application.releaseVersion

Parameter	Value	Data type	Explanation
releaseVersion	"10.0.13.0"	string	semantic version number of the application introducing this entity

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Sales order line history	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/MCRHistSalesLine
ActivityNumber		WorksheetLine/MCRHistSalesLine
AddressRefRecId		WorksheetLine/MCRHistSalesLine
AddressRefTableId		WorksheetLine/MCRHistSalesLine
BarCode		WorksheetLine/MCRHistSalesLine
BarCodeType		WorksheetLine/MCRHistSalesLine
Blocked		WorksheetLine/MCRHistSalesLine
Complete		WorksheetLine/MCRHistSalesLine
ConfirmedDlv		WorksheetLine/MCRHistSalesLine
CostPrice		WorksheetLine/MCRHistSalesLine
CountyOrigDest		WorksheetLine/MCRHistSalesLine
CurrencyCode		WorksheetLine/MCRHistSalesLine
CustAccount		WorksheetLine/MCRHistSalesLine
CustGroup		WorksheetLine/MCRHistSalesLine
CustomerLineNum		WorksheetLine/MCRHistSalesLine
CustomerRef		WorksheetLine/MCRHistSalesLine
DefaultDimension		WorksheetLine/MCRHistSalesLine
DeliveryAddress		WorksheetLine/MCRHistSalesLine
DeliveryCity		WorksheetLine/MCRHistSalesLine
DeliveryCountryRegionId		WorksheetLine/MCRHistSalesLine
DeliveryCounty		WorksheetLine/MCRHistSalesLine
DeliveryDateControlType		WorksheetLine/MCRHistSalesLine
DeliveryName		WorksheetLine/MCRHistSalesLine
DeliveryPostalAddress		WorksheetLine/MCRHistSalesLine
DeliveryState		WorksheetLine/MCRHistSalesLine
DeliveryStreet		WorksheetLine/MCRHistSalesLine
DeliveryType		WorksheetLine/MCRHistSalesLine
DeliveryZipCode		WorksheetLine/MCRHistSalesLine
DlvMode		WorksheetLine/MCRHistSalesLine
EInvoiceAccountCode		WorksheetLine/MCRHistSalesLine
ExpectedRetQty		WorksheetLine/MCRHistSalesLine
ExternalItemId		WorksheetLine/MCRHistSalesLine
InterCompanyInventTransId		WorksheetLine/MCRHistSalesLine
InterCompanyOrigin		WorksheetLine/MCRHistSalesLine
InventDeliverNow		WorksheetLine/MCRHistSalesLine
InventDimId		WorksheetLine/MCRHistSalesLine
InventRefId		WorksheetLine/MCRHistSalesLine
InventRefTransId		WorksheetLine/MCRHistSalesLine
InventRefType		WorksheetLine/MCRHistSalesLine
InventTransId		WorksheetLine/MCRHistSalesLine
InventTransIdReturn		WorksheetLine/MCRHistSalesLine
ItemBOMId		WorksheetLine/MCRHistSalesLine
ItemId		WorksheetLine/MCRHistSalesLine
ItemReplaced		WorksheetLine/MCRHistSalesLine
ItemRouteId		WorksheetLine/MCRHistSalesLine
LedgerDimension		WorksheetLine/MCRHistSalesLine
LineAmount		WorksheetLine/MCRHistSalesLine
LineDeliveryType		WorksheetLine/MCRHistSalesLine
LineDisc		WorksheetLine/MCRHistSalesLine
LineHeader		WorksheetLine/MCRHistSalesLine
LineNum		WorksheetLine/MCRHistSalesLine
LinePercent		WorksheetLine/MCRHistSalesLine
ManualEntryChangepolicy		WorksheetLine/MCRHistSalesLine
MatchingAgreementLine		WorksheetLine/MCRHistSalesLine
MCRContinuityScheduleId		WorksheetLine/MCRHistSalesLine
MCRCreateReplacement		WorksheetLine/MCRHistSalesLine
MCRCustInvoiceTransRecId		WorksheetLine/MCRHistSalesLine
MCRDropShipComment		WorksheetLine/MCRHistSalesLine
MCRDropShipment		WorksheetLine/MCRHistSalesLine
MCRDropShipStatus		WorksheetLine/MCRHistSalesLine
MCRExchangeInventRefTransId		WorksheetLine/MCRHistSalesLine
MCRExpedite		WorksheetLine/MCRHistSalesLine
MCRInstallmentEligible		WorksheetLine/MCRHistSalesLine
MCRInventDimIdOrig		WorksheetLine/MCRHistSalesLine
MCRInvoicedInTotal		WorksheetLine/MCRHistSalesLine
MCRItemIdOrig		WorksheetLine/MCRHistSalesLine
MCRLineDiscGroup		WorksheetLine/MCRHistSalesLine
MCRLineType		WorksheetLine/MCRHistSalesLine
MCRListPrice		WorksheetLine/MCRHistSalesLine
MCRListPriceCurrencyCode		WorksheetLine/MCRHistSalesLine
MCRParentLotId		WorksheetLine/MCRHistSalesLine
MCRPickWaveRef		WorksheetLine/MCRHistSalesLine
MCRPriceGroupId		WorksheetLine/MCRHistSalesLine
MCRPriceOverride		WorksheetLine/MCRHistSalesLine
MCRReasonCode		WorksheetLine/MCRHistSalesLine
MCRSalesLineCreatedDateTime		WorksheetLine/MCRHistSalesLine
MCRSalesUOM		WorksheetLine/MCRHistSalesLine
MCRShipToAccountRef		WorksheetLine/MCRHistSalesLine
MCRSourceId		WorksheetLine/MCRHistSalesLine
MCRUpSellOrigin		WorksheetLine/MCRHistSalesLine
MCRUpSellOriginRef		WorksheetLine/MCRHistSalesLine
MCRWMSStatus		WorksheetLine/MCRHistSalesLine
MultiLnDisc		WorksheetLine/MCRHistSalesLine
MultiLnPercent		WorksheetLine/MCRHistSalesLine
Name		WorksheetLine/MCRHistSalesLine
OverDeliveryPct		WorksheetLine/MCRHistSalesLine
PackingUnit		WorksheetLine/MCRHistSalesLine
PackingUnitQty		WorksheetLine/MCRHistSalesLine
Port		WorksheetLine/MCRHistSalesLine
PriceUnit		WorksheetLine/MCRHistSalesLine
ProjCategoryId		WorksheetLine/MCRHistSalesLine
ProjId		WorksheetLine/MCRHistSalesLine
ProjLinePropertyId		WorksheetLine/MCRHistSalesLine
ProjTransId		WorksheetLine/MCRHistSalesLine
PurchorderFormNum		WorksheetLine/MCRHistSalesLine
QtyOrdered		WorksheetLine/MCRHistSalesLine
ReceiptDateConfirmed		WorksheetLine/MCRHistSalesLine
ReceiptDateRequested		WorksheetLine/MCRHistSalesLine
RemainInventFinancial		WorksheetLine/MCRHistSalesLine
RemainInventPhysical		WorksheetLine/MCRHistSalesLine
RemainSalesFinancial		WorksheetLine/MCRHistSalesLine
RemainSalesPhysical		WorksheetLine/MCRHistSalesLine
Reservation		WorksheetLine/MCRHistSalesLine
RetailInfocodeId		WorksheetLine/MCRHistSalesLine
ReturnAllowReservation		WorksheetLine/MCRHistSalesLine
ReturnArrivalDate		WorksheetLine/MCRHistSalesLine
ReturnClosedDate		WorksheetLine/MCRHistSalesLine
ReturnDeadline		WorksheetLine/MCRHistSalesLine
ReturnDispositionCodeId		WorksheetLine/MCRHistSalesLine
ReturnStatus		WorksheetLine/MCRHistSalesLine
SalesDeliverNow		WorksheetLine/MCRHistSalesLine
SalesGroup		WorksheetLine/MCRHistSalesLine
SalesId		WorksheetLine/MCRHistSalesLine
SalesLineRefRecId		WorksheetLine/MCRHistSalesLine
SalesMarkup		WorksheetLine/MCRHistSalesLine
SalesPrice		WorksheetLine/MCRHistSalesLine
SalesQty		WorksheetLine/MCRHistSalesLine
SalesStatus		WorksheetLine/MCRHistSalesLine
SalesType		WorksheetLine/MCRHistSalesLine
SalesUnit		WorksheetLine/MCRHistSalesLine
Scrap		WorksheetLine/MCRHistSalesLine
ServiceOrderId		WorksheetLine/MCRHistSalesLine
ShipCarrierAccount		WorksheetLine/MCRHistSalesLine
ShipCarrierAccountCode		WorksheetLine/MCRHistSalesLine
ShipCarrierDlvType		WorksheetLine/MCRHistSalesLine
ShipCarrierId		WorksheetLine/MCRHistSalesLine
ShipCarrierName		WorksheetLine/MCRHistSalesLine
ShipCarrierPostalAddress		WorksheetLine/MCRHistSalesLine
ShippingDateConfirmed		WorksheetLine/MCRHistSalesLine
ShippingDateRequested		WorksheetLine/MCRHistSalesLine
SkipUpdate		WorksheetLine/MCRHistSalesLine
StatProcId		WorksheetLine/MCRHistSalesLine
StatTriangularDeal		WorksheetLine/MCRHistSalesLine
TaxAutogenerated		WorksheetLine/MCRHistSalesLine
TaxGroup		WorksheetLine/MCRHistSalesLine
TaxItemGroup		WorksheetLine/MCRHistSalesLine
TaxWithholdGroup		WorksheetLine/MCRHistSalesLine
TransactionCode		WorksheetLine/MCRHistSalesLine
Transport		WorksheetLine/MCRHistSalesLine
UnderDeliveryPct		WorksheetLine/MCRHistSalesLine
DataAreaId		WorksheetLine/MCRHistSalesLine
Relationship_AgreementLineRelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_CustTableRelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_DefaultDimensionRelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_DeliveryPostalAddress_FKRelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_InventDimRelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_LedgerDimensionRelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_MCRHistSalesTableRelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_PriceDiscChangePolicyRecId2RelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_SalesLineRelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_ShipCarrierPostalAddress_FKRelationshipId		WorksheetLine/MCRHistSalesLine
Relationship_CompanyRelationshipId		WorksheetLine/MCRHistSalesLine

RecId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
isPrimaryKey	true
dataFormat	int64
isReadOnly	true

Traits

List of traits for the RecId attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.identifiedBy
names a specifc identity attribute to use with an entity

Parameter	Value	Data type	Explanation
attribute	MCRHistSalesLine/(resolvedAttributes)/RecId	attribute

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

ActivityNumber

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ActivityNumber attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

AddressRefRecId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

List of traits for the AddressRefRecId attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

AddressRefTableId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the AddressRefTableId attribute are listed below.

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

is.dataFormat.integer

BarCode

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	int32
isNullable	true

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

Complete

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

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

Properties

Name	Value
dataFormat	date
isNullable	true

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.dataFormat.date

CostPrice

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

CountyOrigDest

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

CurrencyCode

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the CurrencyCode attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

CustAccount

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Customer
dataFormat	string

Traits

List of traits for the CustAccount attribute are listed below.

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

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

is.dataFormat.character
is.dataFormat.array

CustGroup

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Group
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

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

is.dataFormat.character
is.dataFormat.array

CustomerLineNum

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CustomerLineNum attribute are listed below.

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

is.dataFormat.integer

CustomerRef

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

DefaultDimension

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the DefaultDimension attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

DeliveryAddress

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Delivery address
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

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

is.dataFormat.character
is.dataFormat.array

DeliveryCity

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DeliveryCountryRegionId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DeliveryCounty

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DeliveryDateControlType

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DeliveryDateControlType attribute are listed below.

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

is.dataFormat.integer

DeliveryName

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Delivery name
dataFormat	string
isNullable	true

Traits

List of traits for the DeliveryName attribute are listed below.

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

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

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

is.dataFormat.character
is.dataFormat.array

DeliveryPostalAddress

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the DeliveryPostalAddress attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

DeliveryState

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DeliveryStreet

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DeliveryType

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DeliveryType attribute are listed below.

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

is.dataFormat.integer

DeliveryZipCode

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DlvMode

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EInvoiceAccountCode

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ExpectedRetQty

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ExternalItemId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ExternalItemId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

InterCompanyInventTransId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

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

InventDeliverNow

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Deliver now
dataFormat	decimal
isNullable	true

Traits

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Deliver now	entity	a 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

InventDimId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

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

InventRefId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

InventRefTransId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

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

InventRefType

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the InventRefType attribute are listed below.

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

is.dataFormat.integer

InventTransId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

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

InventTransIdReturn

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ItemBOMId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ItemId attribute are listed below.

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

ItemReplaced

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ItemReplaced attribute are listed below.

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

is.dataFormat.integer

ItemRouteId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	int64
isNullable	true

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.dataFormat.integer
is.dataFormat.big

LineAmount

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the LineAmount attribute are listed below.

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

is.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

LineDeliveryType

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the LineDeliveryType attribute are listed below.

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

is.dataFormat.integer

LineDisc

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the LineDisc attribute are listed below.

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

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

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

LineHeader

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

LineNum

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the LineNum attribute are listed below.

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

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

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

LinePercent

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the LinePercent attribute are listed below.

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

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

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

ManualEntryChangepolicy

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

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

MatchingAgreementLine

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

MCRContinuityScheduleId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

MCRCreateReplacement

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the MCRCreateReplacement attribute are listed below.

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

is.dataFormat.integer

MCRCustInvoiceTransRecId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

MCRDropShipComment

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	int32
isNullable	true

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

Properties

Name	Value
dataFormat	int32
isNullable	true

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

MCRExchangeInventRefTransId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

MCRExpedite

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

MCRInstallmentEligible

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the MCRInstallmentEligible attribute are listed below.

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

is.dataFormat.integer

MCRInventDimIdOrig

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Dimension ID
dataFormat	string
isNullable	true

Traits

List of traits for the MCRInventDimIdOrig attribute are listed below.

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

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

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

is.dataFormat.character
is.dataFormat.array

MCRInvoicedInTotal

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Invoiced
dataFormat	decimal
isNullable	true

Traits

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Invoiced	entity	a 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

MCRItemIdOrig

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Original item
dataFormat	string
isNullable	true

Traits

List of traits for the MCRItemIdOrig attribute are listed below.

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

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

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

is.dataFormat.character
is.dataFormat.array

MCRLineDiscGroup

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

MCRLineType

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the MCRLineType attribute are listed below.

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

is.dataFormat.integer

MCRListPrice

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

MCRListPriceCurrencyCode

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

MCRParentLotId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Parent lot ID
dataFormat	string
isNullable	true

Traits

List of traits for the MCRParentLotId attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Parent lot ID	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

MCRPickWaveRef

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Pick wave ref
dataFormat	string
isNullable	true

Traits

List of traits for the MCRPickWaveRef attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Pick wave ref	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

MCRPriceGroupId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

MCRPriceOverride

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Price override
dataFormat	int32
isNullable	true

Traits

List of traits for the MCRPriceOverride attribute are listed below.

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

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

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

is.dataFormat.integer

MCRReasonCode

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

MCRSalesLineCreatedDateTime

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Line Create
dataFormat	date
isNullable	true

Traits

List of traits for the MCRSalesLineCreatedDateTime attribute are listed below.

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

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

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

is.dataFormat.date

MCRSalesUOM

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

MCRShipToAccountRef

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

MCRSourceId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

MCRUpSellOrigin

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the MCRUpSellOrigin attribute are listed below.

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

is.dataFormat.integer

MCRUpSellOriginRef

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Estimated inventory days remaining
dataFormat	string
isNullable	true

Traits

List of traits for the MCRUpSellOriginRef attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Estimated inventory days remaining	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

MCRWMSStatus

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	WMS status
dataFormat	int32
isNullable	true

Traits

List of traits for the MCRWMSStatus attribute are listed below.

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

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

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

is.dataFormat.integer

MultiLnDisc

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

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.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

MultiLnPercent

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

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.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

Name

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the Name attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

OverDeliveryPct

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

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

PackingUnit

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PackingUnitQty

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

Port

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the PriceUnit attribute are listed below.

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

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

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

ProjCategoryId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ProjCategoryId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ProjId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ProjId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ProjLinePropertyId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ProjLinePropertyId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

ProjTransId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the ProjTransId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

PurchorderFormNum

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Properties

Name	Value
dataFormat	decimal
isNullable	true

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

ReceiptDateConfirmed

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ReceiptDateConfirmed attribute are listed below.

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

is.dataFormat.date

ReceiptDateRequested

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ReceiptDateRequested attribute are listed below.

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

is.dataFormat.date

RemainInventFinancial

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Invoice remainder
dataFormat	decimal
isReadOnly	true
isNullable	true

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.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Invoice remainder	entity	a 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/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Deliver remainder
dataFormat	decimal
isReadOnly	true
isNullable	true

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.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Deliver remainder	entity	a 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

RemainSalesFinancial

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Invoice remainder
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Invoice remainder	entity	a 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

RemainSalesPhysical

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Deliver remainder
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Deliver remainder	entity	a 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

Reservation

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Reservation attribute are listed below.

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

is.dataFormat.integer

RetailInfocodeId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ReturnAllowReservation

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ReturnAllowReservation attribute are listed below.

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

is.dataFormat.integer

ReturnArrivalDate

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the ReturnArrivalDate attribute are listed below.

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

is.dataFormat.date

ReturnClosedDate

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	date
isReadOnly	true
isNullable	true

Traits

List of traits for the ReturnClosedDate attribute are listed below.

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

is.dataFormat.date

ReturnDeadline

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Estimated time of arrival
dataFormat	date
isNullable	true

Traits

List of traits for the ReturnDeadline attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Estimated time of arrival	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.date

ReturnDispositionCodeId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ReturnStatus

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

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

SalesDeliverNow

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Deliver now
dataFormat	decimal
isNullable	true

Traits

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Deliver now	entity	a 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

SalesGroup

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SalesId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the SalesId attribute are listed below.

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

SalesLineRefRecId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Sales line reference ID
dataFormat	int64
isNullable	true

Traits

List of traits for the SalesLineRefRecId attribute are listed below.

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Sales line reference ID	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

SalesMarkup

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

SalesPrice

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Unit price
dataFormat	decimal
isNullable	true

Traits

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Unit price	entity	a 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

SalesQty

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

SalesStatus

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Line status
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SalesStatus attribute are listed below.

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

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

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

is.dataFormat.integer

SalesType

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Type
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the SalesType attribute are listed below.

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

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

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

is.dataFormat.integer

SalesUnit

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Scrap

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
displayName	Scrap
dataFormat	int32
isNullable	true

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.

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

is.dataFormat.integer

ServiceOrderId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

ShipCarrierAccount

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ShipCarrierAccountCode

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

ShipCarrierDlvType

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ShipCarrierDlvType attribute are listed below.

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

is.dataFormat.integer

ShipCarrierId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true
isNullable	true

Traits

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

ShipCarrierName

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ShipCarrierPostalAddress

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

ShippingDateConfirmed

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

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

Properties

Name	Value
dataFormat	date
isNullable	true

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

Properties

Name	Value
dataFormat	int32
isNullable	true

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

StatProcId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	int32
isNullable	true

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

TaxAutogenerated

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

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

TaxGroup

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TaxGroup attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

TaxItemGroup

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TaxItemGroup attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

TaxWithholdGroup

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TransactionCode

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	decimal
isNullable	true

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

DataAreaId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the DataAreaId attribute are listed below.

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

Relationship_AgreementLineRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_CustTableRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustTableRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Common/Customer/Main/CustTable.cdm.json/CustTable RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_DefaultDimensionRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_DeliveryPostalAddress_FKRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DeliveryPostalAddress_FKRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Common/GAB/Main/LogisticsPostalAddress.cdm.json/LogisticsPostalAddress RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_InventDimRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_LedgerDimensionRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_MCRHistSalesTableRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_MCRHistSalesTableRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Commerce/TransactionsAndOrders/WorksheetHeader/MCRHistSalesTable.cdm.json/MCRHistSalesTable RecId	entity	a 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/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_SalesLineRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SalesLineRelationshipId attribute are listed below.

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

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

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

Relationship_ShipCarrierPostalAddress_FKRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ShipCarrierPostalAddress_FKRelationshipId attribute are listed below.

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

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Common/GAB/Main/LogisticsPostalAddress.cdm.json/LogisticsPostalAddress RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_CompanyRelationshipId

First included in: WorksheetLine/MCRHistSalesLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CompanyRelationshipId attribute are listed below.

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

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

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