Route segment in WorksheetLine(TMSRouteSegmentTable)

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	TMSRouteSegmentTable/(resolvedAttributes)/RecId	attribute

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 Route segment	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/TMSRouteSegmentTable
VendorCode		WorksheetLine/TMSRouteSegmentTable
OriginCountryRegion		WorksheetLine/TMSRouteSegmentTable
OriginHubCode		WorksheetLine/TMSRouteSegmentTable
Action		WorksheetLine/TMSRouteSegmentTable
CarrierCode		WorksheetLine/TMSRouteSegmentTable
CarrierGroupCode		WorksheetLine/TMSRouteSegmentTable
CarrierServiceCode		WorksheetLine/TMSRouteSegmentTable
CurrencyCode		WorksheetLine/TMSRouteSegmentTable
CustomerRate		WorksheetLine/TMSRouteSegmentTable
DeliveryUTCDateTime		WorksheetLine/TMSRouteSegmentTable
DestinationAddress		WorksheetLine/TMSRouteSegmentTable
DestinationCity		WorksheetLine/TMSRouteSegmentTable
DestinationCountryRegion		WorksheetLine/TMSRouteSegmentTable
DestinationCountryRegionISOCode		WorksheetLine/TMSRouteSegmentTable
DestinationCounty		WorksheetLine/TMSRouteSegmentTable
DestinationHubCode		WorksheetLine/TMSRouteSegmentTable
DestinationName		WorksheetLine/TMSRouteSegmentTable
DestinationPostalCode		WorksheetLine/TMSRouteSegmentTable
DestinationResidential		WorksheetLine/TMSRouteSegmentTable
DestinationResponsibleForPayment		WorksheetLine/TMSRouteSegmentTable
DestinationState		WorksheetLine/TMSRouteSegmentTable
DestinationVendorCode		WorksheetLine/TMSRouteSegmentTable
DestinationVendorInvoiceCode		WorksheetLine/TMSRouteSegmentTable
FreightTermCode		WorksheetLine/TMSRouteSegmentTable
HasErrors		WorksheetLine/TMSRouteSegmentTable
Id		WorksheetLine/TMSRouteSegmentTable
Miles		WorksheetLine/TMSRouteSegmentTable
ModeCode		WorksheetLine/TMSRouteSegmentTable
OriginAddress		WorksheetLine/TMSRouteSegmentTable
OriginalDestinationPostalAddress		WorksheetLine/TMSRouteSegmentTable
OriginalOriginPostalAddress		WorksheetLine/TMSRouteSegmentTable
OriginCity		WorksheetLine/TMSRouteSegmentTable
OriginCountryRegionISOCode		WorksheetLine/TMSRouteSegmentTable
OriginCounty		WorksheetLine/TMSRouteSegmentTable
OriginName		WorksheetLine/TMSRouteSegmentTable
OriginPostalCode		WorksheetLine/TMSRouteSegmentTable
OriginResidential		WorksheetLine/TMSRouteSegmentTable
OriginResponsibleForPayment		WorksheetLine/TMSRouteSegmentTable
OriginState		WorksheetLine/TMSRouteSegmentTable
OriginVendorCode		WorksheetLine/TMSRouteSegmentTable
OriginVendorInvoiceCode		WorksheetLine/TMSRouteSegmentTable
Rate		WorksheetLine/TMSRouteSegmentTable
RefRecId		WorksheetLine/TMSRouteSegmentTable
RefTableId		WorksheetLine/TMSRouteSegmentTable
ResponsibleForPayment		WorksheetLine/TMSRouteSegmentTable
RouteId		WorksheetLine/TMSRouteSegmentTable
RouteRecId		WorksheetLine/TMSRouteSegmentTable
Sequence		WorksheetLine/TMSRouteSegmentTable
ShipperRate		WorksheetLine/TMSRouteSegmentTable
ShipUTCDateTime		WorksheetLine/TMSRouteSegmentTable
TotalRate		WorksheetLine/TMSRouteSegmentTable
TransitTime		WorksheetLine/TMSRouteSegmentTable
VendorInvoiceCode		WorksheetLine/TMSRouteSegmentTable
TMSRouteSegmentConfig		WorksheetLine/TMSRouteSegmentTable
DataAreaId		WorksheetLine/TMSRouteSegmentTable
Relationship_CurrencyRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_DlvTermRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_LogisticsAddressCountryRegionDestRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_LogisticsAddressCountryRegionOriginRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_OrigLogisticsPostalAddressDestinationRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_OrigLogisticsPostalAddressOriginRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_TMSCarrierRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_TMSCarrierGroupRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_TMSCarrierServiceRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_TMSHubMasterDestRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_TMSHubMasterOriginRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_TMSModeRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_TMSRouteTableRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_VendTableRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_VendTableDestInvoiceRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_VendTableDestVendorRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_VendTableInvoiceRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_VendTableOriginInvoiceRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_VendTableOriginVendorRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_WHSLoadTableRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_TMSRouteSegmentConfigRelationshipId		WorksheetLine/TMSRouteSegmentTable
Relationship_CompanyRelationshipId		WorksheetLine/TMSRouteSegmentTable

RecId

First included in: WorksheetLine/TMSRouteSegmentTable (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	TMSRouteSegmentTable/(resolvedAttributes)/RecId	attribute

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

VendorCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

OriginCountryRegion

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OriginHubCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Action

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Action attribute are listed below.

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

is.dataFormat.integer

CarrierCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

CarrierGroupCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Properties

Name	Value
dataFormat	string
isNullable	true

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

Properties

Name	Value
dataFormat	string

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

Properties

Name	Value
dataFormat	decimal
isNullable	true

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

DeliveryUTCDateTime

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the DeliveryUTCDateTime attribute are listed below.

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

is.dataFormat.date

DestinationAddress

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DestinationCity

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DestinationCountryRegion

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DestinationCountryRegionISOCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DestinationCounty

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DestinationHubCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DestinationName

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
displayName	Drop off charges
dataFormat	string
isNullable	true

Traits

List of traits for the DestinationName 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 Drop off charges	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

DestinationPostalCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DestinationResidential

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DestinationResidential attribute are listed below.

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

is.dataFormat.integer

DestinationResponsibleForPayment

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DestinationResponsibleForPayment attribute are listed below.

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

is.dataFormat.integer

DestinationState

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DestinationVendorCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DestinationVendorInvoiceCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

FreightTermCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

HasErrors

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the HasErrors attribute are listed below.

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

is.dataFormat.integer

Id

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Miles

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ModeCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OriginAddress

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OriginalDestinationPostalAddress

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

OriginalOriginPostalAddress

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

OriginCity

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OriginCountryRegionISOCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OriginCounty

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OriginName

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
displayName	Pickup charges
dataFormat	string
isNullable	true

Traits

List of traits for the OriginName 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 Pickup charges	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

OriginPostalCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OriginResidential

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OriginResidential attribute are listed below.

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

is.dataFormat.integer

OriginResponsibleForPayment

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the OriginResponsibleForPayment attribute are listed below.

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

is.dataFormat.integer

OriginState

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OriginVendorCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

OriginVendorInvoiceCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Rate

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

RefRecId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

RefTableId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the RefTableId attribute are listed below.

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

is.dataFormat.integer

ResponsibleForPayment

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

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

RouteId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

RouteRecId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

Sequence

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Sequence attribute are listed below.

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

is.dataFormat.integer

ShipperRate

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

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

ShipUTCDateTime

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the ShipUTCDateTime attribute are listed below.

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

is.dataFormat.date

TotalRate

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
displayName	Total rate
dataFormat	decimal
isNullable	true

Traits

List of traits for the TotalRate 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 Total rate	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

TransitTime

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

VendorInvoiceCode

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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

TMSRouteSegmentConfig

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

DataAreaId

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

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Common/Currency/Group/Currency.cdm.json/Currency RecId	entity	a 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/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_LogisticsAddressCountryRegionDestRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_LogisticsAddressCountryRegionOriginRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_OrigLogisticsPostalAddressDestinationRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_TMSCarrierGroupRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TMSCarrierGroupRelationshipId 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/Transportation/Main/TMSCarrierGroup.cdm.json/TMSCarrierGroup RecId	entity	a 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/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_TMSHubMasterDestRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_TMSHubMasterOriginRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_TMSModeRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_TMSRouteTableRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TMSRouteTableRelationshipId 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/Transportation/WorksheetLine/TMSRouteTable.cdm.json/TMSRouteTable RecId	entity	a 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/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_VendTableDestInvoiceRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_VendTableDestVendorRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendTableDestVendorRelationshipId 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/Vendor/Main/VendTable.cdm.json/VendTable RecId	entity	a 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/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

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.

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

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

Relationship_VendTableOriginInvoiceRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_VendTableOriginVendorRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_WHSLoadTableRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_TMSRouteSegmentConfigRelationshipId

First included in: WorksheetLine/TMSRouteSegmentTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TMSRouteSegmentConfigRelationshipId 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/Transportation/Group/TMSRouteSegmentConfig.cdm.json/TMSRouteSegmentConfig 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/TMSRouteSegmentTable (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