Travel requisition lines in Transaction(TrvRequisitionLine)

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	TrvRequisitionLine/(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	Travel requisition lines

entity

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

Attributes

Name	Description	First Included in Instance
RecId		Transaction/TrvRequisitionLine
AccountingCurrencyAmount		Transaction/TrvRequisitionLine
AirlineServiceClass		Transaction/TrvRequisitionLine
CarRentalVehicleClass		Transaction/TrvRequisitionLine
Category		Transaction/TrvRequisitionLine
DefaultDimension		Transaction/TrvRequisitionLine
EstimatedDate		Transaction/TrvRequisitionLine
ExchangeRate		Transaction/TrvRequisitionLine
ExpType		Transaction/TrvRequisitionLine
IsBudgetCheckPending		Transaction/TrvRequisitionLine
LegalEntity		Transaction/TrvRequisitionLine
Merchant		Transaction/TrvRequisitionLine
Mileage		Transaction/TrvRequisitionLine
MileageRate		Transaction/TrvRequisitionLine
PerdiemDateFrom		Transaction/TrvRequisitionLine
PerdiemDateTo		Transaction/TrvRequisitionLine
ProjActivityNumber		Transaction/TrvRequisitionLine
ProjLinePropertyId		Transaction/TrvRequisitionLine
ProjTable		Transaction/TrvRequisitionLine
ReconciliationStatus		Transaction/TrvRequisitionLine
ReferenceDataAreaId		Transaction/TrvRequisitionLine
SourceDocumentLine		Transaction/TrvRequisitionLine
TransactionCurrencyAmount		Transaction/TrvRequisitionLine
TransactionCurrencyCode		Transaction/TrvRequisitionLine
TrvLocations		Transaction/TrvRequisitionLine
TrvRequisitionTable		Transaction/TrvRequisitionLine
ProjPolicyStatus		Transaction/TrvRequisitionLine
ProjPolicyText		Transaction/TrvRequisitionLine
Relationship_CompanyInfoRelationshipId		Transaction/TrvRequisitionLine
Relationship_CurrencyRelationshipId		Transaction/TrvRequisitionLine
Relationship_DefaultDimensionRelationshipId		Transaction/TrvRequisitionLine
Relationship_LegalEntityRelationshipId		Transaction/TrvRequisitionLine
Relationship_ProjLinePropertyRelationshipId		Transaction/TrvRequisitionLine
Relationship_ProjTableRelationshipId		Transaction/TrvRequisitionLine
Relationship_SourceDocumentLineRelationshipId		Transaction/TrvRequisitionLine
Relationship_TrvCostTypeRelationshipId		Transaction/TrvRequisitionLine
Relationship_TrvExpMerchantRelationshipId		Transaction/TrvRequisitionLine
Relationship_TrvLocationsRelationshipId		Transaction/TrvRequisitionLine
Relationship_TrvRequisitionTableRelationshipId		Transaction/TrvRequisitionLine

RecId

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

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

AccountingCurrencyAmount

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the AccountingCurrencyAmount attribute are listed below.

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

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

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

AirlineServiceClass

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the AirlineServiceClass attribute are listed below.

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

is.dataFormat.integer

CarRentalVehicleClass

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the CarRentalVehicleClass attribute are listed below.

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

is.dataFormat.integer

DefaultDimension

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

EstimatedDate

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
displayName	Estimated date
dataFormat	date

Traits

List of traits for the EstimatedDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Estimated date

entity

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

is.dataFormat.date

ExchangeRate

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

ExpType

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ExpType attribute are listed below.

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

is.dataFormat.integer

IsBudgetCheckPending

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the IsBudgetCheckPending attribute are listed below.

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

is.dataFormat.integer

LegalEntity

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true

Traits

List of traits for the LegalEntity attribute are listed below.

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

Merchant

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Mileage

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

MileageRate

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the MileageRate attribute are listed below.

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

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

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

PerdiemDateFrom

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
displayName	Per diem from date
dataFormat	date
isNullable	true

Traits

List of traits for the PerdiemDateFrom 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	Per diem from date

entity

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

is.dataFormat.date

PerdiemDateTo

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
displayName	Per diem to date
dataFormat	date
isNullable	true

Traits

List of traits for the PerdiemDateTo 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	Per diem to date

entity

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

is.dataFormat.date

ProjActivityNumber

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProjLinePropertyId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
displayName	Billable
dataFormat	string
isNullable	true

Traits

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

entity

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

is.dataFormat.character
is.dataFormat.array

ProjTable

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
displayName	Project
dataFormat	int64
isNullable	true

Traits

List of traits for the ProjTable attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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	Project

entity

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

is.dataFormat.integer
is.dataFormat.big

ReconciliationStatus

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ReconciliationStatus attribute are listed below.

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

is.dataFormat.integer

ReferenceDataAreaId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

SourceDocumentLine

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

TransactionCurrencyAmount

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
displayName	Estimated amount
dataFormat	decimal
isNullable	true

Traits

List of traits for the TransactionCurrencyAmount 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	Estimated amount

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

TransactionCurrencyCode

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the TransactionCurrencyCode attribute are listed below.

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

TrvLocations

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
displayName	Location
dataFormat	int64
isNullable	true

Traits

List of traits for the TrvLocations attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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	Location

entity

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

is.dataFormat.integer
is.dataFormat.big

TrvRequisitionTable

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true

Traits

List of traits for the TrvRequisitionTable attribute are listed below.

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

ProjPolicyStatus

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the ProjPolicyStatus attribute are listed below.

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

is.dataFormat.integer

ProjPolicyText

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ProjPolicyText attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

Relationship_CompanyInfoRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

Relationship_CurrencyRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CurrencyRelationshipId attribute are listed below.

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_DefaultDimensionRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DefaultDimensionRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/FinancialDimensions/Main/DimensionAttributeValueSet.cdm.json/DimensionAttributeValueSet	RecId

entity

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

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

Relationship_LegalEntityRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_LegalEntityRelationshipId attribute are listed below.

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

Relationship_ProjLinePropertyRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjLinePropertyRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjLineProperty.cdm.json/ProjLineProperty	RecId

entity

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

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

Relationship_ProjTableRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Main/ProjTable.cdm.json/ProjTable	RecId

entity

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

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

Relationship_SourceDocumentLineRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SourceDocumentLineRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/TransactionLine/SourceDocumentLine.cdm.json/SourceDocumentLine	RecId

entity

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

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

Relationship_TrvCostTypeRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TrvCostTypeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Expense/Reference/TrvCostType.cdm.json/TrvCostType	RecId

entity

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

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

Relationship_TrvExpMerchantRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TrvExpMerchantRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Expense/Reference/TrvExpMerchant.cdm.json/TrvExpMerchant	RecId

entity

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

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

Relationship_TrvLocationsRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TrvLocationsRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Expense/Reference/TrvLocations.cdm.json/TrvLocations	RecId

entity

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

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

Relationship_TrvRequisitionTableRelationshipId

First included in: Transaction/TrvRequisitionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TrvRequisitionTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

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

entity

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

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

Share via

Travel requisition lines in Transaction(TrvRequisitionLine)

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

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

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits