Sales order line - update table in WorksheetLine(SalesParmLine)

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
attributeSalesParmLine/(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
enSales order line - update table
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId WorksheetLine/SalesParmLine
AlcoholLicenseSeriesNum_RU WorksheetLine/SalesParmLine
changedManually WorksheetLine/SalesParmLine
closed WorksheetLine/SalesParmLine
Complete WorksheetLine/SalesParmLine
CustAccount WorksheetLine/SalesParmLine
DeliverNow WorksheetLine/SalesParmLine
DeliveryName WorksheetLine/SalesParmLine
DeliveryPostalAddress WorksheetLine/SalesParmLine
DlvMode WorksheetLine/SalesParmLine
DlvTerm WorksheetLine/SalesParmLine
InventDimId WorksheetLine/SalesParmLine
InventNow WorksheetLine/SalesParmLine
InventOwnerId_RU WorksheetLine/SalesParmLine
InventProfileType_RU WorksheetLine/SalesParmLine
InventTransId WorksheetLine/SalesParmLine
InvoiceAccount WorksheetLine/SalesParmLine
ItemId WorksheetLine/SalesParmLine
LineAmount WorksheetLine/SalesParmLine
LineNum WorksheetLine/SalesParmLine
OrigSalesId WorksheetLine/SalesParmLine
PackedExtensions WorksheetLine/SalesParmLine
PackingUnit WorksheetLine/SalesParmLine
PackingUnitQty WorksheetLine/SalesParmLine
ParmId WorksheetLine/SalesParmLine
PdsCWDeliverNow WorksheetLine/SalesParmLine
PdsCWPreviousDeliverNow WorksheetLine/SalesParmLine
PdsCWRemainAfterInvent WorksheetLine/SalesParmLine
PdsCWRemainBefore WorksheetLine/SalesParmLine
PostingProfile_RU WorksheetLine/SalesParmLine
PreviousDeliverNow WorksheetLine/SalesParmLine
PreviousInventNow WorksheetLine/SalesParmLine
RemainAfter WorksheetLine/SalesParmLine
RemainAfterInvent WorksheetLine/SalesParmLine
RemainBefore WorksheetLine/SalesParmLine
RemainBeforeInvent WorksheetLine/SalesParmLine
RemainBeforeInventPhysical WorksheetLine/SalesParmLine
SalesCategory WorksheetLine/SalesParmLine
SalesLineRecId WorksheetLine/SalesParmLine
Scrap WorksheetLine/SalesParmLine
ShipCarrierAccount WorksheetLine/SalesParmLine
ShipCarrierId WorksheetLine/SalesParmLine
ShipCarrierPostalAddress WorksheetLine/SalesParmLine
TableRefId WorksheetLine/SalesParmLine
AssessableValue_IN WorksheetLine/SalesParmLine
CustomsShippingBillNumberTable_IN WorksheetLine/SalesParmLine
MaximumRetailPrice_IN WorksheetLine/SalesParmLine
BillSchFromBillingSchedules WorksheetLine/SalesParmLine
BillSchFromBillingSchedulesNotProcessed WorksheetLine/SalesParmLine
DataAreaId WorksheetLine/SalesParmLine
Relationship_AlcoholLicenseTable_RURelationshipId WorksheetLine/SalesParmLine
Relationship_CustLedgerRelationshipId WorksheetLine/SalesParmLine
Relationship_DeliveryPostalAddress_FKRelationshipId WorksheetLine/SalesParmLine
Relationship_DlvModeRelationshipId WorksheetLine/SalesParmLine
Relationship_DlvTermRelationshipId WorksheetLine/SalesParmLine
Relationship_InventDimRelationshipId WorksheetLine/SalesParmLine
Relationship_InventOwner_RURelationshipId WorksheetLine/SalesParmLine
Relationship_InventTableRelationshipId WorksheetLine/SalesParmLine
Relationship_InventTransOriginRelationshipId WorksheetLine/SalesParmLine
Relationship_InvoiceCustomerRelationshipId WorksheetLine/SalesParmLine
Relationship_OrderCustomerRelationshipId WorksheetLine/SalesParmLine
Relationship_SalesCategoryRelationshipId WorksheetLine/SalesParmLine
Relationship_SalesLineRelationshipId WorksheetLine/SalesParmLine
Relationship_salesParmSubTableRelationshipId WorksheetLine/SalesParmLine
Relationship_SalesParmTableRelationshipId WorksheetLine/SalesParmLine
Relationship_SalesTableRelationshipId WorksheetLine/SalesParmLine
Relationship_ShipCarrierPostalAddress_FKRelationshipId WorksheetLine/SalesParmLine
Relationship_CompanyRelationshipId WorksheetLine/SalesParmLine

RecId

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

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

AlcoholLicenseSeriesNum_RU

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the AlcoholLicenseSeriesNum_RU attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

changedManually

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameChange quantity manually
dataFormatint32
isNullabletrue

Traits

List of traits for the changedManually 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
enChange quantity manually
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

closed

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameClosed
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

Complete

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

CustAccount

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

DeliverNow

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameUpdate
dataFormatdecimal
isNullabletrue

Traits

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

DeliveryName

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

DlvMode

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

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

DlvTerm

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the DlvTerm attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

InventDimId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InventNow

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameUpdate
dataFormatdecimal
isNullabletrue

Traits

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

InventOwnerId_RU

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the InventOwnerId_RU attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

InventProfileType_RU

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the InventProfileType_RU attribute are listed below.

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

is.dataFormat.integer

InventTransId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

InvoiceAccount

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

LineAmount

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enNet 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

LineNum

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

List of traits for the LineNum attribute are listed below.

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

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

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

OrigSalesId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

PackedExtensions

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

PackingUnit

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

PackingUnitQty

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

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

ParmId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the ParmId attribute are listed below.

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

PdsCWDeliverNow

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameCW update
dataFormatdecimal
isNullabletrue

Traits

List of traits for the PdsCWDeliverNow 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
enCW update
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

PdsCWPreviousDeliverNow

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

PdsCWRemainAfterInvent

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameCW deliver remainder
dataFormatdecimal
isNullabletrue

Traits

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

PdsCWRemainBefore

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

PostingProfile_RU

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the PostingProfile_RU attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

PreviousDeliverNow

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

PreviousInventNow

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

RemainAfter

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameDeliver remainder
dataFormatdecimal
isNullabletrue

Traits

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

RemainAfterInvent

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameDeliver remainder
dataFormatdecimal
isNullabletrue

Traits

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

RemainBefore

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameRemaining quantity
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

List of traits for the RemainBefore 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
enRemaining quantity
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

RemainBeforeInvent

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameRemaining quantity
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

List of traits for the RemainBeforeInvent 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
enRemaining quantity
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

RemainBeforeInventPhysical

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

SalesCategory

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

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

SalesLineRecId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

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

Scrap

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

ShipCarrierAccount

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

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

ShipCarrierId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Properties

NameValue
dataFormatint64
isNullabletrue

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

TableRefId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the TableRefId attribute are listed below.

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

AssessableValue_IN

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameAssessable value
dataFormatdecimal
isNullabletrue

Traits

List of traits for the AssessableValue_IN attribute are listed below.

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

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enAssessable value
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

CustomsShippingBillNumberTable_IN

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

List of traits for the CustomsShippingBillNumberTable_IN attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

MaximumRetailPrice_IN

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

List of traits for the MaximumRetailPrice_IN attribute are listed below.

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

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

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

BillSchFromBillingSchedules

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameFrom billing schedules
dataFormatint32
isNullabletrue

Traits

List of traits for the BillSchFromBillingSchedules 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
enFrom billing schedules
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

BillSchFromBillingSchedulesNotProcessed

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
displayNameFrom billing schedules not processed
dataFormatint32
isNullabletrue

Traits

List of traits for the BillSchFromBillingSchedulesNotProcessed 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
enFrom billing schedules not processed
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

DataAreaId

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

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_AlcoholLicenseTable_RURelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/EGAIS/Parameter/AlcoholLicenseTable_RU.cdm.json/AlcoholLicenseTable_RURecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CustLedgerRelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CustLedgerRelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/AccountsReceivable/Group/CustLedger.cdm.json/CustLedgerRecId
entitya 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/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

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.

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_DlvModeRelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_DlvTermRelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_DlvTermRelationshipId 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/DlvTerm.cdm.json/DlvTermRecId
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/SalesParmLine (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_InventOwner_RURelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_InventOwner_RURelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Inventory/Group/InventOwner_RU.cdm.json/InventOwner_RURecId
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/SalesParmLine (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/SalesParmLine (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_InvoiceCustomerRelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_InvoiceCustomerRelationshipId 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/Customer/Main/CustTable.cdm.json/CustTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_OrderCustomerRelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_OrderCustomerRelationshipId 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/Customer/Main/CustTable.cdm.json/CustTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SalesCategoryRelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

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.

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_salesParmSubTableRelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_SalesParmTableRelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_SalesTableRelationshipId

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

Traits

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

First included in: WorksheetLine/SalesParmLine (this entity)

Properties

NameValue
dataFormatguid

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.

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_CompanyRelationshipId

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