Muokkaa

Jaa


Credit card in WorksheetLine(TrvPBSMaindata)

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
attributeTrvPBSMaindata/(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
enCredit card
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId WorksheetLine/TrvPBSMaindata
AmountCurr WorksheetLine/TrvPBSMaindata
AmountLocal WorksheetLine/TrvPBSMaindata
BusinessName WorksheetLine/TrvPBSMaindata
CardNumber WorksheetLine/TrvPBSMaindata
CardNumberNIKS WorksheetLine/TrvPBSMaindata
CardType WorksheetLine/TrvPBSMaindata
CatCode WorksheetLine/TrvPBSMaindata
CatCodesDesc WorksheetLine/TrvPBSMaindata
CCTransUniqueID WorksheetLine/TrvPBSMaindata
CostType WorksheetLine/TrvPBSMaindata
Country WorksheetLine/TrvPBSMaindata
EmpPayMethodRecId WorksheetLine/TrvPBSMaindata
ExchCode WorksheetLine/TrvPBSMaindata
ExchCodeLocal WorksheetLine/TrvPBSMaindata
MerchantCategoryCode WorksheetLine/TrvPBSMaindata
Name WorksheetLine/TrvPBSMaindata
Paymethod WorksheetLine/TrvPBSMaindata
Posted WorksheetLine/TrvPBSMaindata
Reference WorksheetLine/TrvPBSMaindata
Town WorksheetLine/TrvPBSMaindata
TransDate WorksheetLine/TrvPBSMaindata
Transferred WorksheetLine/TrvPBSMaindata
TravelNo WorksheetLine/TrvPBSMaindata
UserField1 WorksheetLine/TrvPBSMaindata
UserField2 WorksheetLine/TrvPBSMaindata
UserField3 WorksheetLine/TrvPBSMaindata
UserField4 WorksheetLine/TrvPBSMaindata
UserField5 WorksheetLine/TrvPBSMaindata
UserField6 WorksheetLine/TrvPBSMaindata
UserField7 WorksheetLine/TrvPBSMaindata
UserField8 WorksheetLine/TrvPBSMaindata
UserField9 WorksheetLine/TrvPBSMaindata
UserFieldLong WorksheetLine/TrvPBSMaindata
Worker WorksheetLine/TrvPBSMaindata
DataAreaId WorksheetLine/TrvPBSMaindata
Relationship_CostTypeRelationshipId WorksheetLine/TrvPBSMaindata
Relationship_CurrencyRelationshipId WorksheetLine/TrvPBSMaindata
Relationship_EmpPaymethodRelationshipId WorksheetLine/TrvPBSMaindata
Relationship_LocalCurrencyRelationshipId WorksheetLine/TrvPBSMaindata
Relationship_TrvExpTableRelationshipId WorksheetLine/TrvPBSMaindata
Relationship_TrvPaymethodRelationshipId WorksheetLine/TrvPBSMaindata
Relationship_CompanyRelationshipId WorksheetLine/TrvPBSMaindata

RecId

First included in: WorksheetLine/TrvPBSMaindata (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
attributeTrvPBSMaindata/(resolvedAttributes)/RecIdattribute

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

AmountCurr

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
displayNameTransaction amount
dataFormatdecimal

Traits

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

AmountLocal

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
displayNameAmount in local currency
dataFormatdecimal
isNullabletrue

Traits

List of traits for the AmountLocal 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
enAmount in local 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

BusinessName

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
displayNameMerchant name
dataFormatstring
isNullabletrue

Traits

List of traits for the BusinessName 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
enMerchant name
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

CardNumber

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CardNumberNIKS

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
displayNameUnique ID
dataFormatstring
isNullabletrue

Traits

List of traits for the CardNumberNIKS 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
enUnique ID
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

CardType

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the CardType attribute are listed below.

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

CatCode

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CatCodesDesc

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CCTransUniqueID

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

CostType

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Country

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

EmpPayMethodRecId

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

ExchCode

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the ExchCode attribute are listed below.

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

ExchCodeLocal

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
displayNameLocal currency code
dataFormatstring
isNullabletrue

Traits

List of traits for the ExchCodeLocal 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
enLocal currency code
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

MerchantCategoryCode

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Name

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
displayNameCardholder's name
dataFormatstring
isNullabletrue

Traits

List of traits for the Name 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
enCardholder's name
entitya reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

Paymethod

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Posted

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
displayNameProcessed for payment
dataFormatint32
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enProcessed for payment
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

Reference

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Town

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

TransDate

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatdate

Traits

List of traits for the TransDate attribute are listed below.

is.dataFormat.date
means.measurement.date
is.dataFormat.date

Transferred

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
displayNameTransaction is added to expense report
dataFormatint32
isNullabletrue

Traits

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

ParameterValueData typeExplanation
localizedDisplayText
languageTagdisplayText
enTransaction is added to expense report
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

TravelNo

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserField1

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserField2

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserField3

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserField4

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserField5

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserField6

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserField7

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserField8

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserField9

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

UserFieldLong

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

Worker

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatint64
isNullabletrue

Traits

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

DataAreaId

First included in: WorksheetLine/TrvPBSMaindata (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_CostTypeRelationshipId

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_CostTypeRelationshipId 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/TrvCostType.cdm.json/TrvCostTypeRecId
entitya 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: WorksheetLine/TrvPBSMaindata (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_EmpPaymethodRelationshipId

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatguid

Traits

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

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

Relationship_LocalCurrencyRelationshipId

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatguid

Traits

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

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TrvExpTableRelationshipId 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/WorksheetHeader/TrvExpTable.cdm.json/TrvExpTableRecId
entitya reference to the constant entity holding the list of entity references

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

Relationship_TrvPaymethodRelationshipId

First included in: WorksheetLine/TrvPBSMaindata (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_TrvPaymethodRelationshipId 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/TrvPayMethod.cdm.json/TrvPayMethodRecId
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: WorksheetLine/TrvPBSMaindata (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