Cash advance request in Worksheet(TrvCashAdvance)

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
attributeTrvCashAdvance/(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
enCash advance request
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId Worksheet/TrvCashAdvance
AccountType Worksheet/TrvCashAdvance
AdvanceLedgerDimension Worksheet/TrvCashAdvance
Balance Worksheet/TrvCashAdvance
BalanceMST Worksheet/TrvCashAdvance
BalanceReturned Worksheet/TrvCashAdvance
CashAdvanceNumber Worksheet/TrvCashAdvance
CashAdvanceStatus Worksheet/TrvCashAdvance
CurrencyCode Worksheet/TrvCashAdvance
DefaultDimension Worksheet/TrvCashAdvance
Destination Worksheet/TrvCashAdvance
ExchRate Worksheet/TrvCashAdvance
Notes Worksheet/TrvCashAdvance
PaidAmountCur Worksheet/TrvCashAdvance
PaidAmountMST Worksheet/TrvCashAdvance
PaidDate Worksheet/TrvCashAdvance
PayingWorker Worksheet/TrvCashAdvance
Purpose Worksheet/TrvCashAdvance
RequestAmountMST Worksheet/TrvCashAdvance
RequestedAmountCur Worksheet/TrvCashAdvance
RequestedDate Worksheet/TrvCashAdvance
RequestingWorker Worksheet/TrvCashAdvance
TaxGroup Worksheet/TrvCashAdvance
TaxItemGroup Worksheet/TrvCashAdvance
TransactionDate Worksheet/TrvCashAdvance
DataAreaId Worksheet/TrvCashAdvance
Relationship_CurrencyRelationshipId Worksheet/TrvCashAdvance
Relationship_DefaultDimensionRelationshipId Worksheet/TrvCashAdvance
Relationship_LedgerDimensionRelationshipId Worksheet/TrvCashAdvance
Relationship_PurposeRelationshipId Worksheet/TrvCashAdvance
Relationship_TrvDestinationsRelationshipId Worksheet/TrvCashAdvance
Relationship_CompanyRelationshipId Worksheet/TrvCashAdvance

RecId

First included in: Worksheet/TrvCashAdvance (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
attributeTrvCashAdvance/(resolvedAttributes)/RecIdattribute

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

AccountType

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the AccountType attribute are listed below.

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

is.dataFormat.integer

AdvanceLedgerDimension

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

Balance

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNameBalance
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enBalance
entitya 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

BalanceMST

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

BalanceReturned

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

CashAdvanceNumber

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNameCash advance number
dataFormatstring
isReadOnlytrue

Traits

List of traits for the CashAdvanceNumber attribute are listed below.

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enCash advance number
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

CashAdvanceStatus

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatint32
isReadOnlytrue
isNullabletrue

Traits

List of traits for the CashAdvanceStatus attribute are listed below.

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

is.dataFormat.integer

CurrencyCode

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

List of traits for the CurrencyCode 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: Worksheet/TrvCashAdvance (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

Destination

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

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

ExchRate

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatdecimal
isNullabletrue

Traits

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

Notes

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PaidAmountCur

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNamePaid amount
dataFormatdecimal
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enPaid amount
entitya 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

PaidAmountMST

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNamePaid amount (company currency)
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enPaid amount (company currency)
entitya 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

PaidDate

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the PaidDate attribute are listed below.

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

is.dataFormat.date

PayingWorker

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNamePaying worker
dataFormatint64
isReadOnlytrue
isNullabletrue

Traits

List of traits for the PayingWorker 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
enPaying worker
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

Purpose

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

RequestAmountMST

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNameRequested amount (company currency)
dataFormatdecimal
isReadOnlytrue
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enRequested amount (company currency)
entitya 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

RequestedAmountCur

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNameRequested amount
dataFormatdecimal

Traits

List of traits for the RequestedAmountCur attribute are listed below.

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

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enRequested amount
entitya 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

RequestedDate

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatdate
isNullabletrue

Traits

List of traits for the RequestedDate attribute are listed below.

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

is.dataFormat.date

RequestingWorker

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatint64

Traits

List of traits for the RequestingWorker attribute are listed below.

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

TaxGroup

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNameSales tax group
dataFormatstring
isNullabletrue

Traits

List of traits for the TaxGroup 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
enSales tax group
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

TaxItemGroup

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNameItem sales tax group
dataFormatstring
isNullabletrue

Traits

List of traits for the TaxItemGroup 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
enItem sales tax group
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

TransactionDate

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
displayNameTransaction date
dataFormatdate
isReadOnlytrue
isNullabletrue

Traits

List of traits for the TransactionDate attribute are listed below.

is.dataFormat.date
means.measurement.date
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
enTransaction date
entitya reference to the constant entity holding the list of localized text

is.dataFormat.date

DataAreaId

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatstring
isReadOnlytrue

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_CurrencyRelationshipId

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CurrencyRelationshipId 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/Common/Currency/Group/Currency.cdm.json/CurrencyRecId
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: Worksheet/TrvCashAdvance (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_LedgerDimensionRelationshipId

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_LedgerDimensionRelationshipId 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/DimensionAttributeValueCombination.cdm.json/DimensionAttributeValueCombinationRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_PurposeRelationshipId

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatguid

Traits

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

Relationship_TrvDestinationsRelationshipId

First included in: Worksheet/TrvCashAdvance (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_CompanyRelationshipId

First included in: Worksheet/TrvCashAdvance (this entity)

Properties

NameValue
dataFormatguid

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.

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