Expense reports in WorksheetHeader(TrvExpTable)

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	TrvExpTable/(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	Expense reports

entity

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

Attributes

Name	Description	First Included in Instance
RecId		WorksheetHeader/TrvExpTable
AntiCorruptionApproverFlag		WorksheetHeader/TrvExpTable
AntiCorruptionSubmitterFlag		WorksheetHeader/TrvExpTable
ApprovalStatus		WorksheetHeader/TrvExpTable
CreatingWorker		WorksheetHeader/TrvExpTable
CustAccount		WorksheetHeader/TrvExpTable
DefaultDimension		WorksheetHeader/TrvExpTable
Destination		WorksheetHeader/TrvExpTable
ExpNumber		WorksheetHeader/TrvExpTable
FinalApprover		WorksheetHeader/TrvExpTable
LegalEntity		WorksheetHeader/TrvExpTable
InterCompanyLE		WorksheetHeader/TrvExpTable
InvoiceId		WorksheetHeader/TrvExpTable
PaymentDate		WorksheetHeader/TrvExpTable
PaymentVoucher		WorksheetHeader/TrvExpTable
PreApprovalNumber		WorksheetHeader/TrvExpTable
PostedDate		WorksheetHeader/TrvExpTable
ReferenceDataAreaId		WorksheetHeader/TrvExpTable
SourceDocumentHeader		WorksheetHeader/TrvExpTable
SourceDocumentLine		WorksheetHeader/TrvExpTable
Txt1		WorksheetHeader/TrvExpTable
Txt2		WorksheetHeader/TrvExpTable
VendAccount		WorksheetHeader/TrvExpTable
ProjId		WorksheetHeader/TrvExpTable
ProjStatusId		WorksheetHeader/TrvExpTable
Relationship_CompanyInfoRelationshipId		WorksheetHeader/TrvExpTable
Relationship_CustTableRelationshipId		WorksheetHeader/TrvExpTable
Relationship_DefaultDimensionRelationshipId		WorksheetHeader/TrvExpTable
Relationship_ExpensePurposeRelationshipId		WorksheetHeader/TrvExpTable
Relationship_LegalEntityRelationshipId		WorksheetHeader/TrvExpTable
Relationship_SourceDocumentHeaderRelationshipId		WorksheetHeader/TrvExpTable
Relationship_SourceDocumentLineRelationshipId		WorksheetHeader/TrvExpTable
Relationship_TrvDestinationsRelationshipId		WorksheetHeader/TrvExpTable
Relationship_VendTableRelationshipId		WorksheetHeader/TrvExpTable
Relationship_InterCompanyLERelationshipId		WorksheetHeader/TrvExpTable
Relationship_ProjLinePropertyRelationshipId		WorksheetHeader/TrvExpTable
Relationship_ProjTable_ProjIdRelationshipId		WorksheetHeader/TrvExpTable

RecId

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

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

AntiCorruptionApproverFlag

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Anti-corruption
dataFormat	int32
isNullable	true

Traits

List of traits for the AntiCorruptionApproverFlag 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	Anti-corruption

entity

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

is.dataFormat.integer

AntiCorruptionSubmitterFlag

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Anti-corruption
dataFormat	int32
isNullable	true

Traits

List of traits for the AntiCorruptionSubmitterFlag 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	Anti-corruption

entity

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

is.dataFormat.integer

ApprovalStatus

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

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: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the CreatingWorker attribute are listed below.

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

CustAccount

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DefaultDimension

First included in: WorksheetHeader/TrvExpTable (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

Destination

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

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.dataFormat.character
is.dataFormat.array

ExpNumber

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the ExpNumber attribute are listed below.

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

FinalApprover

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

LegalEntity

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

InterCompanyLE

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Legal entity for expenses
dataFormat	string

Traits

List of traits for the InterCompanyLE attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Legal entity for expenses

entity

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

is.dataFormat.character
is.dataFormat.array

InvoiceId

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Invoice
dataFormat	string
isNullable	true

Traits

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

entity

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

is.dataFormat.character
is.dataFormat.array

PaymentDate

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Payment date
dataFormat	date
isNullable	true

Traits

List of traits for the PaymentDate 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	Payment date

entity

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

is.dataFormat.date

PaymentVoucher

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Payment voucher
dataFormat	string
isNullable	true

Traits

List of traits for the PaymentVoucher 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	Payment voucher

entity

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

is.dataFormat.character
is.dataFormat.array

PreApprovalNumber

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PostedDate

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Posted date
dataFormat	date
isNullable	true

Traits

List of traits for the PostedDate 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	Posted date

entity

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

is.dataFormat.date

ReferenceDataAreaId

First included in: WorksheetHeader/TrvExpTable (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

SourceDocumentHeader

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Source document header
dataFormat	int64
isReadOnly	true
isNullable	true

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.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Source document header

entity

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

is.dataFormat.integer
is.dataFormat.big

SourceDocumentLine

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Source document line
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.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter

Value

Data type

Explanation

localizedDisplayText

languageTag	displayText
en	Source document line

entity

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

is.dataFormat.integer
is.dataFormat.big

Txt1

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
displayName	Description
dataFormat	string
isNullable	true

Traits

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

entity

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

is.dataFormat.character
is.dataFormat.array

Txt2

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

VendAccount

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProjId

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

ProjStatusId

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

List of traits for the ProjStatusId 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: WorksheetHeader/TrvExpTable (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_CustTableRelationshipId

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_CustTableRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Customer/Main/CustTable.cdm.json/CustTable	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: WorksheetHeader/TrvExpTable (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_ExpensePurposeRelationshipId

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ExpensePurposeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Expense/Reference/TrvTravelTxt.cdm.json/TrvTravelTxt	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: WorksheetHeader/TrvExpTable (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_SourceDocumentHeaderRelationshipId

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_SourceDocumentHeaderRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/AccountingFoundation/TransactionHeader/SourceDocumentHeader.cdm.json/SourceDocumentHeader	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: WorksheetHeader/TrvExpTable (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_TrvDestinationsRelationshipId

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TrvDestinationsRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Expense/Reference/TrvDestinations.cdm.json/TrvDestinations	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: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_VendTableRelationshipId attribute are listed below.

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_InterCompanyLERelationshipId

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_InterCompanyLERelationshipId 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: WorksheetHeader/TrvExpTable (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_ProjTable_ProjIdRelationshipId

First included in: WorksheetHeader/TrvExpTable (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

Share via

Expense reports in WorksheetHeader(TrvExpTable)

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

Feedback

Additional resources