Muokkaa

Jaa


Export to Microsoft Excel Pivot report setup in Reference(ProjExportToExcelPivotTable)

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
attributeProjExportToExcelPivotTable/(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
enExport to Microsoft Excel Pivot report setup
entitya reference to the constant entity holding the list of localized text

Attributes

Name Description First Included in Instance
RecId Reference/ProjExportToExcelPivotTable
ActualCost Reference/ProjExportToExcelPivotTable
BurdenHours Reference/ProjExportToExcelPivotTable
CalledByTableId Reference/ProjExportToExcelPivotTable
CashInFlows Reference/ProjExportToExcelPivotTable
CashOutFlows Reference/ProjExportToExcelPivotTable
Chargeable Reference/ProjExportToExcelPivotTable
CommittedCost Reference/ProjExportToExcelPivotTable
ConsumedHours Reference/ProjExportToExcelPivotTable
Deviation Reference/ProjExportToExcelPivotTable
IncludedHours Reference/ProjExportToExcelPivotTable
InsertYear Reference/ProjExportToExcelPivotTable
Invoiced Reference/ProjExportToExcelPivotTable
InvoiceRemain Reference/ProjExportToExcelPivotTable
LaunchAfterExport Reference/ProjExportToExcelPivotTable
NetCashFlow Reference/ProjExportToExcelPivotTable
NonChargeable Reference/ProjExportToExcelPivotTable
NormHours Reference/ProjExportToExcelPivotTable
NotIncludedHours Reference/ProjExportToExcelPivotTable
OriginalBudget Reference/ProjExportToExcelPivotTable
PeriodCode Reference/ProjExportToExcelPivotTable
PLRatio Reference/ProjExportToExcelPivotTable
PLStatement Reference/ProjExportToExcelPivotTable
ProjControlForm Reference/ProjExportToExcelPivotTable
ProjLevel Reference/ProjExportToExcelPivotTable
Quotation Reference/ProjExportToExcelPivotTable
QuotationRemain Reference/ProjExportToExcelPivotTable
RemainingBudget Reference/ProjExportToExcelPivotTable
SelectedDimension Reference/ProjExportToExcelPivotTable
ShowAmount Reference/ProjExportToExcelPivotTable
ShowHour Reference/ProjExportToExcelPivotTable
TotalBudgetCost Reference/ProjExportToExcelPivotTable
TotalCost Reference/ProjExportToExcelPivotTable
TotalInvoicing Reference/ProjExportToExcelPivotTable
UserId Reference/ProjExportToExcelPivotTable
UtilizationHours Reference/ProjExportToExcelPivotTable
UtilizationRate Reference/ProjExportToExcelPivotTable
Variance Reference/ProjExportToExcelPivotTable
DataAreaId Reference/ProjExportToExcelPivotTable
Relationship_ProjPeriodTableRelationshipId Reference/ProjExportToExcelPivotTable
Relationship_CompanyRelationshipId Reference/ProjExportToExcelPivotTable

RecId

First included in: Reference/ProjExportToExcelPivotTable (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
attributeProjExportToExcelPivotTable/(resolvedAttributes)/RecIdattribute

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

ActualCost

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameActual cost
dataFormatint32
isNullabletrue

Traits

List of traits for the ActualCost 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
enActual cost
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

BurdenHours

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameBurden hours
dataFormatint32
isNullabletrue

Traits

List of traits for the BurdenHours 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
enBurden hours
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

CalledByTableId

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the CalledByTableId attribute are listed below.

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

CashInFlows

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameCash inflows
dataFormatint32
isNullabletrue

Traits

List of traits for the CashInFlows 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
enCash inflows
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

CashOutFlows

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameCash outflows
dataFormatint32
isNullabletrue

Traits

List of traits for the CashOutFlows 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
enCash outflows
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

Chargeable

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameChargeable
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

CommittedCost

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameCommitted cost
dataFormatint32
isNullabletrue

Traits

List of traits for the CommittedCost 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
enCommitted cost
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

ConsumedHours

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameConsumed hours
dataFormatint32
isNullabletrue

Traits

List of traits for the ConsumedHours 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
enConsumed hours
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

Deviation

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameDeviation
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

IncludedHours

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameIncluded hours
dataFormatint32
isNullabletrue

Traits

List of traits for the IncludedHours 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
enIncluded hours
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

InsertYear

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameInsert year
dataFormatint32
isNullabletrue

Traits

List of traits for the InsertYear 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
enInsert year
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

Invoiced

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameInvoiced
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

InvoiceRemain

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameRemaining amount to invoice
dataFormatint32
isNullabletrue

Traits

List of traits for the InvoiceRemain 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
enRemaining amount to invoice
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

LaunchAfterExport

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameLaunch after export
dataFormatint32
isNullabletrue

Traits

List of traits for the LaunchAfterExport 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
enLaunch after export
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

NetCashFlow

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameNet cash flow
dataFormatint32
isNullabletrue

Traits

List of traits for the NetCashFlow 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
enNet cash flow
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

NonChargeable

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameNonchargeable
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

NormHours

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameNorm hours
dataFormatint32
isNullabletrue

Traits

List of traits for the NormHours 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
enNorm hours
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

NotIncludedHours

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameNot included hours
dataFormatint32
isNullabletrue

Traits

List of traits for the NotIncludedHours 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
enNot included hours
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

OriginalBudget

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameOriginal budget
dataFormatint32
isNullabletrue

Traits

List of traits for the OriginalBudget 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
enOriginal budget
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

PeriodCode

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatstring
isNullabletrue

Traits

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

PLRatio

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PLRatio attribute are listed below.

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

is.dataFormat.integer

PLStatement

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the PLStatement attribute are listed below.

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

is.dataFormat.integer

ProjControlForm

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the ProjControlForm attribute are listed below.

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

ProjLevel

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameProject level
dataFormatint32
isNullabletrue

Traits

List of traits for the ProjLevel 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
enProject level
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

Quotation

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameQuotation
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

QuotationRemain

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameRemaining quotation amount
dataFormatint32
isNullabletrue

Traits

List of traits for the QuotationRemain 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
enRemaining quotation amount
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

RemainingBudget

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameRemaining budget
dataFormatint32
isNullabletrue

Traits

List of traits for the RemainingBudget 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
enRemaining budget
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

SelectedDimension

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatbinary
isNullabletrue

Traits

List of traits for the SelectedDimension attribute are listed below.

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

is.dataFormat.byte
is.dataFormat.array

ShowAmount

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ShowAmount attribute are listed below.

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

is.dataFormat.integer

ShowHour

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatint32
isNullabletrue

Traits

List of traits for the ShowHour attribute are listed below.

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

is.dataFormat.integer

TotalBudgetCost

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameTotal budgeted cost
dataFormatint32
isNullabletrue

Traits

List of traits for the TotalBudgetCost 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
enTotal budgeted cost
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

TotalCost

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameTotal cost
dataFormatint32
isNullabletrue

Traits

List of traits for the TotalCost 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
enTotal cost
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

TotalInvoicing

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameTotal invoicing
dataFormatint32
isNullabletrue

Traits

List of traits for the TotalInvoicing 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
enTotal invoicing
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

UserId

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatstring

Traits

List of traits for the UserId attribute are listed below.

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

UtilizationHours

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameUtilization hours
dataFormatint32
isNullabletrue

Traits

List of traits for the UtilizationHours 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
enUtilization hours
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

UtilizationRate

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameUtilization rate
dataFormatint32
isNullabletrue

Traits

List of traits for the UtilizationRate 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
enUtilization rate
entitya reference to the constant entity holding the list of localized text

is.dataFormat.integer

Variance

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
displayNameVariance
dataFormatint32
isNullabletrue

Traits

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

is.dataFormat.integer

DataAreaId

First included in: Reference/ProjExportToExcelPivotTable (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_ProjPeriodTableRelationshipId

First included in: Reference/ProjExportToExcelPivotTable (this entity)

Properties

NameValue
dataFormatguid

Traits

List of traits for the Relationship_ProjPeriodTableRelationshipId 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/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjPeriodTable.cdm.json/ProjPeriodTableRecId
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: Reference/ProjExportToExcelPivotTable (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