Enhanced itinerary data in WorksheetLine(TrvEnhancedItineraryData)

Article
02/22/2022

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	TrvEnhancedItineraryData/(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	Enhanced data
en	Enhanced itinerary data

entity

a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/TrvEnhancedItineraryData
InstanceRelationType		WorksheetLine/TrvEnhancedItineraryData
PBSRecid		WorksheetLine/TrvEnhancedItineraryData
TransactionRecord		WorksheetLine/TrvEnhancedItineraryData
Relationship_TrvPBSMaindataRelationshipId		WorksheetLine/TrvEnhancedItineraryData
Relationship_TrvExpTransRelationshipId		WorksheetLine/TrvEnhancedItineraryData
DepartureDate		WorksheetLine/TrvEnhancedItineraryData
DomesticIndicator		WorksheetLine/TrvEnhancedItineraryData
ExchangeTicketNumber		WorksheetLine/TrvEnhancedItineraryData
IssuingCarrier		WorksheetLine/TrvEnhancedItineraryData
NumberOfLegs		WorksheetLine/TrvEnhancedItineraryData
OriginalTicketNumber		WorksheetLine/TrvEnhancedItineraryData
PassengerName		WorksheetLine/TrvEnhancedItineraryData
TicketIssueDate		WorksheetLine/TrvEnhancedItineraryData
TravelAgencyCode		WorksheetLine/TrvEnhancedItineraryData
TravelAgencyInvoiceNumber		WorksheetLine/TrvEnhancedItineraryData
TravelAgencyName		WorksheetLine/TrvEnhancedItineraryData

RecId

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

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

InstanceRelationType

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

PBSRecid

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

TransactionRecord

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

Relationship_TrvPBSMaindataRelationshipId

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TrvPBSMaindataRelationshipId 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/Expense/WorksheetLine/TrvPBSMaindata.cdm.json/TrvPBSMaindata	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_TrvExpTransRelationshipId

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TrvExpTransRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Expense/Transaction/TrvExpTrans.cdm.json/TrvExpTrans	RecId

entity

a reference to the constant entity holding the list of entity references

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

DepartureDate

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the DepartureDate attribute are listed below.

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

is.dataFormat.date

DomesticIndicator

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
displayName	Domestic flight
dataFormat	int32
isNullable	true

Traits

List of traits for the DomesticIndicator attribute are listed below.

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

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

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Domestic flight

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ExchangeTicketNumber

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
displayName	Exchange ticket number
dataFormat	string
isNullable	true

Traits

List of traits for the ExchangeTicketNumber 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	Exchange ticket number

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

IssuingCarrier

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

NumberOfLegs

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the NumberOfLegs attribute are listed below.

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

is.dataFormat.integer

OriginalTicketNumber

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
displayName	Original ticket number
dataFormat	string
isNullable	true

Traits

List of traits for the OriginalTicketNumber 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	Original ticket number

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

PassengerName

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
displayName	Passenger name
dataFormat	string
isNullable	true

Traits

List of traits for the PassengerName 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	Passenger name

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

TicketIssueDate

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
displayName	Ticket issue date
dataFormat	date
isNullable	true

Traits

List of traits for the TicketIssueDate attribute are listed below.

is.dataFormat.date
means.measurement.date
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	Ticket issue date

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.date

TravelAgencyCode

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TravelAgencyInvoiceNumber

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TravelAgencyName

First included in: WorksheetLine/TrvEnhancedItineraryData (this entity)

Properties

Name	Value
displayName	Travel Agency
dataFormat	string
isNullable	true

Traits

List of traits for the TravelAgencyName 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	Travel Agency

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

Share via

Enhanced itinerary data in WorksheetLine(TrvEnhancedItineraryData)

Traits

Attributes

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Feedback

Additional resources