Project integration table for estimate expenses in Miscellaneous(ProjCDSEstimateExpensesImport)

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	ProjCDSEstimateExpensesImport/(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 Project integration table for estimate expenses	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		Miscellaneous/ProjCDSEstimateExpensesImport
TaskId		Miscellaneous/ProjCDSEstimateExpensesImport
ProjectId		Miscellaneous/ProjCDSEstimateExpensesImport
ExchangeRate		Miscellaneous/ProjCDSEstimateExpensesImport
Description		Miscellaneous/ProjCDSEstimateExpensesImport
Price		Miscellaneous/ProjCDSEstimateExpensesImport
Quantity		Miscellaneous/ProjCDSEstimateExpensesImport
CurrencyId		Miscellaneous/ProjCDSEstimateExpensesImport
ModelId		Miscellaneous/ProjCDSEstimateExpensesImport
TransId		Miscellaneous/ProjCDSEstimateExpensesImport
TransType		Miscellaneous/ProjCDSEstimateExpensesImport
DocumentDate		Miscellaneous/ProjCDSEstimateExpensesImport
BillingType		Miscellaneous/ProjCDSEstimateExpensesImport
TransClassification		Miscellaneous/ProjCDSEstimateExpensesImport
TransactionCategory		Miscellaneous/ProjCDSEstimateExpensesImport
EstimateLineId		Miscellaneous/ProjCDSEstimateExpensesImport
OriginEstimateLineId		Miscellaneous/ProjCDSEstimateExpensesImport
ActivityNumber		Miscellaneous/ProjCDSEstimateExpensesImport
StartDate		Miscellaneous/ProjCDSEstimateExpensesImport
EndDate		Miscellaneous/ProjCDSEstimateExpensesImport
ResourceCategoryId		Miscellaneous/ProjCDSEstimateExpensesImport
TransactionCategoryId		Miscellaneous/ProjCDSEstimateExpensesImport
EstimateExpensesImportId		Miscellaneous/ProjCDSEstimateExpensesImport
DataAreaId		Miscellaneous/ProjCDSEstimateExpensesImport
Relationship_ProjTableRelationshipId		Miscellaneous/ProjCDSEstimateExpensesImport
Relationship_CurrencyRelationshipId		Miscellaneous/ProjCDSEstimateExpensesImport
Relationship_CompanyRelationshipId		Miscellaneous/ProjCDSEstimateExpensesImport

RecId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (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	ProjCDSEstimateExpensesImport/(resolvedAttributes)/RecId	attribute

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

TaskId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	guid
isNullable	true

Traits

List of traits for the TaskId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
is.nullable
The attribute value may be set to NULL.

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

ProjectId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ProjectId attribute are listed below.

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

ExchangeRate

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the ExchangeRate attribute are listed below.

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

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

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

Description

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Price

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the Price attribute are listed below.

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

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

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

Quantity

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

List of traits for the Quantity attribute are listed below.

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

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

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

CurrencyId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the CurrencyId attribute are listed below.

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

ModelId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TransId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TransType

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	int32

Traits

List of traits for the TransType attribute are listed below.

is.dataFormat.integer
is.dataFormat.integer

DocumentDate

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the DocumentDate attribute are listed below.

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

is.dataFormat.date

BillingType

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	int32

Traits

List of traits for the BillingType attribute are listed below.

is.dataFormat.integer
is.dataFormat.integer

TransClassification

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TransactionCategory

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
displayName	Transaction category
dataFormat	guid
isNullable	true

Traits

List of traits for the TransactionCategory attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
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 Transaction category	entity	a reference to the constant entity holding the list of localized text

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

EstimateLineId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
displayName	Estimate line id
dataFormat	guid

Traits

List of traits for the EstimateLineId attribute are listed below.

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

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Estimate line id	entity	a reference to the constant entity holding the list of localized text

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

OriginEstimateLineId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
displayName	Originating estimate line ID
dataFormat	guid
isNullable	true

Traits

List of traits for the OriginEstimateLineId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
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 Originating estimate line ID	entity	a reference to the constant entity holding the list of localized text

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

ActivityNumber

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

StartDate

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
displayName	Start date
dataFormat	date
isNullable	true

Traits

List of traits for the StartDate attribute are listed below.

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

is.dataFormat.date

EndDate

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
displayName	End date
dataFormat	date
isNullable	true

Traits

List of traits for the EndDate attribute are listed below.

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

is.dataFormat.date

ResourceCategoryId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TransactionCategoryId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

EstimateExpensesImportId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
displayName	Expense estimates import ID
dataFormat	guid
isNullable	true

Traits

List of traits for the EstimateExpensesImportId attribute are listed below.

is.dataFormat.character
is.dataFormat.big
is.dataFormat.array
is.dataFormat.guid
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 Expense estimates import ID	entity	a reference to the constant entity holding the list of localized text

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

DataAreaId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (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_ProjTableRelationshipId

First included in: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ProjTableRelationshipId 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/Main/ProjTable.cdm.json/ProjTable RecId	entity	a 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: Miscellaneous/ProjCDSEstimateExpensesImport (this entity)

Properties

Name	Value
dataFormat	guid

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.

Parameter	Value	Data type	Explanation
entityReferences	entityReference attributeReference /core/operationsCommon/Tables/Common/Currency/Group/Currency.cdm.json/Currency 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: Miscellaneous/ProjCDSEstimateExpensesImport (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