ProjExportToExcelPivotTable.md

title	description	author	ms.reviewer	ms.topic	ms.date	ms.author
ProjExportToExcelPivotTable in Reference - Common Data Model | Microsoft Docs	undefined	llawwaii	deonhe	reference	8/7/2020	weiluo

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	languageTag displayText en Export to Microsoft Excel Pivot report setup	entity	a 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

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	languageTag displayText en Actual cost	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	languageTag displayText en Burden hours	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	languageTag displayText en Cash inflows	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	languageTag displayText en Cash outflows	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	languageTag displayText en Chargeable	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	languageTag displayText en Committed cost	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	languageTag displayText en Consumed hours	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	languageTag displayText en Deviation	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	languageTag displayText en Included hours	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	languageTag displayText en Insert year	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	languageTag displayText en Invoiced	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	languageTag displayText en Remaining amount to invoice	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	languageTag displayText en Launch after export	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	languageTag displayText en Net cash flow	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	languageTag displayText en Nonchargeable	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	languageTag displayText en Norm hours	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	languageTag displayText en Not included hours	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	languageTag displayText en Original budget	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	languageTag displayText en Project level	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	languageTag displayText en Quotation	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	languageTag displayText en Remaining quotation amount	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	languageTag displayText en Remaining budget	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	languageTag displayText en Total budgeted cost	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	languageTag displayText en Total cost	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	languageTag displayText en Total invoicing	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	languageTag displayText en Utilization hours	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	languageTag displayText en Utilization rate	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	languageTag displayText en Variance	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	entityReference attributeReference /core/operationsCommon/Tables/ProfessionalServices/ProjectManagementAndAccounting/Group/ProjPeriodTable.cdm.json/ProjPeriodTable RecId	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	entityReference attributeReference /core/operationsCommon/Tables/Finance/Ledger/Main/CompanyInfo.cdm.json/CompanyInfo RecId	entity	a reference to the constant entity holding the list of entity references

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