Edit

Share via

Travel requisition in Transaction(TrvRequisitionTable)

  • Article

Latest version of the JSON entity definition is available on GitHub.

Traits

Traits for this entity are listed below.

is.identifiedBy
names a specifc identity attribute to use with an entity

ParameterValueData typeExplanation
attributeTrvRequisitionTable/(resolvedAttributes)/RecIdattribute

is.CDM.entityVersion

ParameterValueData typeExplanation
versionNumber"1.1"stringsemantic version number of the entity

is.application.releaseVersion

ParameterValueData typeExplanation
releaseVersion"10.0.13.0"stringsemantic version number of the application introducing this entity

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTravel requisition
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId Transaction/TrvRequisitionTable
ApprovalStatus Transaction/TrvRequisitionTable
CreatingWorker Transaction/TrvRequisitionTable
DefaultDimension Transaction/TrvRequisitionTable
Description Transaction/TrvRequisitionTable
Destination Transaction/TrvRequisitionTable
LegalEntity Transaction/TrvRequisitionTable
ReconciliationStatus Transaction/TrvRequisitionTable
ReferenceDataAreaId Transaction/TrvRequisitionTable
RequisitionDate Transaction/TrvRequisitionTable
RequisitionNumber Transaction/TrvRequisitionTable
SourceDocumentHeader Transaction/TrvRequisitionTable
SourceDocumentLine Transaction/TrvRequisitionTable
TravelPurpose Transaction/TrvRequisitionTable
Relationship_CompanyInfoRelationshipId Transaction/TrvRequisitionTable
Relationship_DefaultDimensionRelationshipId Transaction/TrvRequisitionTable
Relationship_LegalEntityRelationshipId Transaction/TrvRequisitionTable
Relationship_SourceDocumentHeaderRelationshipId Transaction/TrvRequisitionTable
Relationship_SourceDocumentLineRelationshipId Transaction/TrvRequisitionTable
Relationship_TrvDestinationsRelationshipId Transaction/TrvRequisitionTable
Relationship_TrvTravelTxtRelationshipId Transaction/TrvRequisitionTable

RecId

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
isPrimaryKeytrue
dataFormatint64
isReadOnlytrue

Traits

List of traits for the RecId attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
is.identifiedBy
names a specifc identity attribute to use with an entity

ParameterValueData typeExplanation
attributeTrvRequisitionTable/(resolvedAttributes)/RecIdattribute

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

ApprovalStatus

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the ApprovalStatus attribute are listed below.

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

is.dataFormat.integer

CreatingWorker

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue

Traits

List of traits for the CreatingWorker attribute are listed below.

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

DefaultDimension

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

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

Description

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
displayNameTravel description
dataFormatstring
isNullabletrue

Traits

List of traits for the Description attribute are listed below.

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTravel description
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

Destination

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
displayNameDestination
dataFormatstring
isNullabletrue

Traits

List of traits for the Destination attribute are listed below.

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

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

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

is.dataFormat.character
is.dataFormat.array

LegalEntity

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

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

ReconciliationStatus

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

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

Properties

NameValue
dataFormatstring
isNullabletrue

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

RequisitionDate

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the RequisitionDate attribute are listed below.

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

is.dataFormat.date

RequisitionNumber

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

Traits

List of traits for the RequisitionNumber attribute are listed below.

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

SourceDocumentHeader

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
displayNameSource document header
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

List of traits for the SourceDocumentHeader attribute are listed below.

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enSource document header
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

SourceDocumentLine

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
displayNameSource document line
dataFormatint64
isReadOnlytrue
isNullabletrue

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.localized.displayedAs
Holds the list of language specific display text for an object.

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enSource document line
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

TravelPurpose

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
displayNameBusiness purpose
dataFormatstring
isNullabletrue

Traits

List of traits for the TravelPurpose attribute are listed below.

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enBusiness purpose
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

Relationship_CompanyInfoRelationshipId

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatguid

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.

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfoRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_DefaultDimensionRelationshipId

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_DefaultDimensionRelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/FinancialDimensions/Main/DimensionAttributeValueSet.cdm.json/DimensionAttributeValueSetRecId
entitya 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/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_LegalEntityRelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfoRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_SourceDocumentHeaderRelationshipId

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SourceDocumentHeaderRelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/TransactionHeader/SourceDocumentHeader.cdm.json/SourceDocumentHeaderRecId
entitya 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/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_SourceDocumentLineRelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/TransactionLine/SourceDocumentLine.cdm.json/SourceDocumentLineRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TrvDestinationsRelationshipId

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TrvDestinationsRelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Expense/Reference/TrvDestinations.cdm.json/TrvDestinationsRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TrvTravelTxtRelationshipId

First included in: Transaction/TrvRequisitionTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TrvTravelTxtRelationshipId attribute are listed below.

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

ParameterValueData typeExplanation
entityReferences
entityReferenceattributeReference
/core/operationsCommon/Tables/Finance/Expense/Reference/TrvTravelTxt.cdm.json/TrvTravelTxtRecId
entitya reference to the constant entity holding the list of entity references

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