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
Parameter | Value | Data type | Explanation |
---|---|---|---|
attribute | ProjExportToExcelPivotTable/(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 |
| entity | a reference to the constant entity holding the list of localized text |
Attributes
RecId
First included in: Reference/ProjExportToExcelPivotTable (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 | ProjExportToExcelPivotTable/(resolvedAttributes)/RecId | attribute |
is.readOnly
is.dataFormat.integer
is.dataFormat.big
ActualCost
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Actual cost |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
BurdenHours
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Burden hours |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
CalledByTableId
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
dataFormat | string |
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
Name | Value |
---|---|
displayName | Cash inflows |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
CashOutFlows
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Cash outflows |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
Chargeable
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Chargeable |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
CommittedCost
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Committed cost |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
ConsumedHours
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Consumed hours |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
Deviation
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Deviation |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
IncludedHours
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Included hours |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
InsertYear
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Insert year |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
Invoiced
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Invoiced |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
InvoiceRemain
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Remaining amount to invoice |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
LaunchAfterExport
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Launch after export |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
NetCashFlow
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Net cash flow |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
NonChargeable
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Nonchargeable |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
NormHours
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Norm hours |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
NotIncludedHours
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Not included hours |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
OriginalBudget
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Original budget |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
PeriodCode
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
dataFormat | string |
isNullable | true |
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
Name | Value |
---|---|
dataFormat | int32 |
isNullable | true |
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
Name | Value |
---|---|
dataFormat | int32 |
isNullable | true |
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
Name | Value |
---|---|
dataFormat | string |
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
Name | Value |
---|---|
displayName | Project level |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
Quotation
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Quotation |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
QuotationRemain
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Remaining quotation amount |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
RemainingBudget
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Remaining budget |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
SelectedDimension
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
dataFormat | binary |
isNullable | true |
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
Name | Value |
---|---|
dataFormat | int32 |
isNullable | true |
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
Name | Value |
---|---|
dataFormat | int32 |
isNullable | true |
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
Name | Value |
---|---|
displayName | Total budgeted cost |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
TotalCost
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Total cost |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
TotalInvoicing
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Total invoicing |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
UserId
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
dataFormat | string |
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
Name | Value |
---|---|
displayName | Utilization hours |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
UtilizationRate
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Utilization rate |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
Variance
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
displayName | Variance |
dataFormat | int32 |
isNullable | true |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
localizedDisplayText |
| entity | a reference to the constant entity holding the list of localized text |
is.dataFormat.integer
DataAreaId
First included in: Reference/ProjExportToExcelPivotTable (this entity)
Properties
Name | Value |
---|---|
dataFormat | string |
isReadOnly | true |
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
Name | Value |
---|---|
dataFormat | guid |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
entityReferences |
| entity | a 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
Name | Value |
---|---|
dataFormat | guid |
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.
Parameter | Value | Data type | Explanation | ||||
---|---|---|---|---|---|---|---|
entityReferences |
| entity | a reference to the constant entity holding the list of entity references |
is.dataFormat.guid
is.dataFormat.character
is.dataFormat.array