Route rate details in WorksheetLine(TMSRouteRateDetail)

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
attributeTMSRouteRateDetail/(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
enRoute rate details
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId WorksheetLine/TMSRouteRateDetail
AccessorialAssignmentLevel WorksheetLine/TMSRouteRateDetail
BillingGroupId WorksheetLine/TMSRouteRateDetail
CarrierCode WorksheetLine/TMSRouteRateDetail
CarrierServiceCode WorksheetLine/TMSRouteRateDetail
CurrencyCode WorksheetLine/TMSRouteRateDetail
CustomerRate WorksheetLine/TMSRouteRateDetail
ExternalCode WorksheetLine/TMSRouteRateDetail
Generated WorksheetLine/TMSRouteRateDetail
HubMasterCode WorksheetLine/TMSRouteRateDetail
Id WorksheetLine/TMSRouteRateDetail
MarkupCode WorksheetLine/TMSRouteRateDetail
ModuleType WorksheetLine/TMSRouteRateDetail
RateCur WorksheetLine/TMSRouteRateDetail
RateId WorksheetLine/TMSRouteRateDetail
RateNote WorksheetLine/TMSRouteRateDetail
RateType WorksheetLine/TMSRouteRateDetail
RateUnit WorksheetLine/TMSRouteRateDetail
RateUnitRate WorksheetLine/TMSRouteRateDetail
ResponsibleForPayment WorksheetLine/TMSRouteRateDetail
RouteAccessorialLevel WorksheetLine/TMSRouteRateDetail
RouteCode WorksheetLine/TMSRouteRateDetail
Sequence WorksheetLine/TMSRouteRateDetail
ShipperRate WorksheetLine/TMSRouteRateDetail
VendorCode WorksheetLine/TMSRouteRateDetail
VendorInvoiceCode WorksheetLine/TMSRouteRateDetail
DataAreaId WorksheetLine/TMSRouteRateDetail
Relationship_CurrencyRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_TMSAccessorialMasterRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_TMSCarrierRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_TMSCarrierServiceRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_TMSHubMasterRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_TMSRouteRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_TMSRouteSegmentRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_TMSRouteSegmentLoadRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_TMSRouteSegmentShipmentRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_VendTableRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_VendTableInvoiceRelationshipId WorksheetLine/TMSRouteRateDetail
Relationship_CompanyRelationshipId WorksheetLine/TMSRouteRateDetail

RecId

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

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

AccessorialAssignmentLevel

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AccessorialAssignmentLevel attribute are listed below.

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

is.dataFormat.integer

BillingGroupId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CarrierCode

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CarrierServiceCode

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Properties

NameValue
dataFormatstring

Traits

List of traits for the CurrencyCode attribute are listed below.

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

CustomerRate

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

ExternalCode

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Generated

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the Generated attribute are listed below.

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

is.dataFormat.integer

HubMasterCode

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Id

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue
isNullabletrue

Traits

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

MarkupCode

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

ModuleType

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ModuleType attribute are listed below.

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

is.dataFormat.integer

RateCur

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatdecimal

Traits

List of traits for the RateCur attribute are listed below.

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

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

RateId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
displayNameRate ID
dataFormatstring
isNullabletrue

Traits

List of traits for the RateId attribute are listed below.

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

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

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

is.dataFormat.character
is.dataFormat.array

RateNote

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

RateType

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the RateType attribute are listed below.

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

is.dataFormat.integer

RateUnit

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

RateUnitRate

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

ResponsibleForPayment

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ResponsibleForPayment attribute are listed below.

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

is.dataFormat.integer

RouteAccessorialLevel

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the RouteAccessorialLevel attribute are listed below.

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

is.dataFormat.integer

RouteCode

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the RouteCode attribute are listed below.

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

Sequence

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the Sequence attribute are listed below.

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

is.dataFormat.integer

ShipperRate

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

VendorCode

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

VendorInvoiceCode

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

DataAreaId

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

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CurrencyRelationshipId attribute are listed below.

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

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

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

Relationship_TMSAccessorialMasterRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TMSAccessorialMasterRelationshipId 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/Transportation/Main/TMSAccessorialMaster.cdm.json/TMSAccessorialMasterRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TMSCarrierRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TMSCarrierRelationshipId 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/Transportation/Main/TMSCarrier.cdm.json/TMSCarrierRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TMSCarrierServiceRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TMSCarrierServiceRelationshipId 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/Transportation/Group/TMSCarrierService.cdm.json/TMSCarrierServiceRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TMSHubMasterRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TMSHubMasterRelationshipId 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/Transportation/Group/TMSHubMaster.cdm.json/TMSHubMasterRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TMSRouteRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TMSRouteRelationshipId 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/Transportation/Main/TMSRoute.cdm.json/TMSRouteRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TMSRouteSegmentRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TMSRouteSegmentRelationshipId 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/Transportation/WorksheetLine/TMSRouteSegment.cdm.json/TMSRouteSegmentRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TMSRouteSegmentLoadRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TMSRouteSegmentLoadRelationshipId 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/Transportation/Transaction/TMSRouteSegmentLoad.cdm.json/TMSRouteSegmentLoadRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TMSRouteSegmentShipmentRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TMSRouteSegmentShipmentRelationshipId 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/Transportation/Transaction/TMSRouteSegmentShipment.cdm.json/TMSRouteSegmentShipmentRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_VendTableRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_VendTableRelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Vendor/Main/VendTable.cdm.json/VendTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_VendTableInvoiceRelationshipId

First included in: WorksheetLine/TMSRouteRateDetail (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_VendTableInvoiceRelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/SupplyChain/Vendor/Main/VendTable.cdm.json/VendTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_CompanyRelationshipId

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