Transportation Request Detail in WorksheetLine(TMSTransportRequestLine)

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	TMSTransportRequestLine/(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 Transportation Request Detail	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/TMSTransportRequestLine
DestinationHubCode		WorksheetLine/TMSTransportRequestLine
DestinationName		WorksheetLine/TMSTransportRequestLine
DestinationPostalAddress		WorksheetLine/TMSTransportRequestLine
InventDimId		WorksheetLine/TMSTransportRequestLine
InventQty		WorksheetLine/TMSTransportRequestLine
InventTransId		WorksheetLine/TMSTransportRequestLine
InventTransType		WorksheetLine/TMSTransportRequestLine
ItemId		WorksheetLine/TMSTransportRequestLine
ItemName		WorksheetLine/TMSTransportRequestLine
LoadDirection		WorksheetLine/TMSTransportRequestLine
OrderNum		WorksheetLine/TMSTransportRequestLine
OriginHubCode		WorksheetLine/TMSTransportRequestLine
OriginName		WorksheetLine/TMSTransportRequestLine
OriginPostalAddress		WorksheetLine/TMSTransportRequestLine
PackingQty		WorksheetLine/TMSTransportRequestLine
Qty		WorksheetLine/TMSTransportRequestLine
QtyLeftToTransport		WorksheetLine/TMSTransportRequestLine
TransportRequestId		WorksheetLine/TMSTransportRequestLine
UOM		WorksheetLine/TMSTransportRequestLine
DataAreaId		WorksheetLine/TMSTransportRequestLine
Relationship_InventDimRelationshipId		WorksheetLine/TMSTransportRequestLine
Relationship_InventTableRelationshipId		WorksheetLine/TMSTransportRequestLine
Relationship_InventTransOriginRelationshipId		WorksheetLine/TMSTransportRequestLine
Relationship_LogisticsPostalAddressDestinationRelationshipId		WorksheetLine/TMSTransportRequestLine
Relationship_LogisticsPostalAddressOriginRelationshipId		WorksheetLine/TMSTransportRequestLine
Relationship_OriginTMSHubMasterRelationshipId		WorksheetLine/TMSTransportRequestLine
Relationship_TMSHubMasterRelationshipId		WorksheetLine/TMSTransportRequestLine
Relationship_TMSTransportRequestTableRelationshipId		WorksheetLine/TMSTransportRequestLine
Relationship_CompanyRelationshipId		WorksheetLine/TMSTransportRequestLine

RecId

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

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

DestinationHubCode

First included in: WorksheetLine/TMSTransportRequestLine (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/TMSTransportRequestLine (this entity)

Properties

Name	Value
displayName	Destination
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 Destination	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

DestinationPostalAddress

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

InventDimId

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the InventDimId attribute are listed below.

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

InventQty

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

InventTransId

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the InventTransId attribute are listed below.

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

InventTransType

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the InventTransType attribute are listed below.

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

is.dataFormat.integer

ItemId

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ItemId attribute are listed below.

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

ItemName

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

LoadDirection

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the LoadDirection attribute are listed below.

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

is.dataFormat.integer

OrderNum

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the OrderNum 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/TMSTransportRequestLine (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

OriginName

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
displayName	Origin
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 Origin	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

OriginPostalAddress

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

PackingQty

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

Qty

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

QtyLeftToTransport

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

TransportRequestId

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the TransportRequestId attribute are listed below.

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

UOM

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the UOM 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/TMSTransportRequestLine (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_InventDimRelationshipId

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventDimRelationshipId attribute are listed below.

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

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

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

Relationship_InventTableRelationshipId

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventTableRelationshipId attribute are listed below.

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

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

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

Relationship_InventTransOriginRelationshipId

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InventTransOriginRelationshipId attribute are listed below.

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

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

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

Relationship_LogisticsPostalAddressDestinationRelationshipId

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	guid

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.

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_TMSTransportRequestTableRelationshipId

First included in: WorksheetLine/TMSTransportRequestLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TMSTransportRequestTableRelationshipId 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/WorksheetHeader/TMSTransportRequestTable.cdm.json/TMSTransportRequestTable 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/TMSTransportRequestLine (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