Open sales price journal lines in SalesAndMarketing(SalesOpenSalesPriceJournalLineEntity)

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

Traits

Traits for this entity are listed below.

is.CDM.entityVersion

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

is.application.releaseVersion

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

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Open sales price journal lines	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
TradeAgreementJournalNumber		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
LineNumber		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
PriceCustomerGroupCode		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
CustomerAccountNumber		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ItemNumber		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ProductColorId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ProductConfigurationId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ProductSizeId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ProductStyleId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ProductVersionId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
PriceSiteId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
PriceWarehouseId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
FromQuantity		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ToQuantity		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
QuantityUnitSymbol		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
PriceApplicableFromDate		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
PriceApplicableToDate		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
Price		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
PriceCurrencyCode		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
AttributeBasedPricingId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
FixedPriceCharges		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
SalesPriceQuantity		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
SalesLeadTimeDays		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
WillDeliveryDateControlDisregardLeadTime		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
IsGenericCurrencySearchEnabled		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
WillSearchContinue		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ProcessingLog		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
AccountRelation		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
AccountCode		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ItemCode		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
ItemRelation		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
JournalNum		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
Relationship_PriceCustomerGroupRelationshipId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
Relationship_CustTableRelationshipId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
Relationship_SiteRelationshipId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
Relationship_WarehouseRelationshipId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
BackingTable_PriceDiscAdmTransRelationshipId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity
Relationship_PrimaryCompanyContextRelationshipId		SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity

TradeAgreementJournalNumber

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the TradeAgreementJournalNumber attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

LineNumber

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PriceCustomerGroupCode

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

CustomerAccountNumber

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ItemNumber

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProductColorId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProductConfigurationId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProductSizeId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProductStyleId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProductVersionId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PriceSiteId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PriceWarehouseId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

FromQuantity

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ToQuantity

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

QuantityUnitSymbol

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PriceApplicableFromDate

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PriceApplicableToDate

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Price

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PriceCurrencyCode

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AttributeBasedPricingId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

FixedPriceCharges

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SalesPriceQuantity

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SalesLeadTimeDays

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

WillDeliveryDateControlDisregardLeadTime

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

IsGenericCurrencySearchEnabled

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

WillSearchContinue

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProcessingLog

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AccountRelation

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

AccountCode

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ItemCode

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ItemRelation

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

JournalNum

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Relationship_PriceCustomerGroupRelationshipId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PriceCustomerGroupRelationshipId 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	empty table	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: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (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	empty table	entity	a reference to the constant entity holding the list of entity references

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

Relationship_SiteRelationshipId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SiteRelationshipId 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	empty table	entity	a reference to the constant entity holding the list of entity references

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

Relationship_WarehouseRelationshipId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_WarehouseRelationshipId 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	empty table	entity	a reference to the constant entity holding the list of entity references

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

BackingTable_PriceDiscAdmTransRelationshipId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the BackingTable_PriceDiscAdmTransRelationshipId 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/PriceDiscAdmTrans.cdm.json/PriceDiscAdmTrans RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_PrimaryCompanyContextRelationshipId

First included in: SalesAndMarketing/SalesOpenSalesPriceJournalLineEntity (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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