On-account in Transaction(ProjOnAccTrans)

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	ProjOnAccTrans/(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 On-account	entity	a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		Transaction/ProjOnAccTrans
ActivityNumber		Transaction/ProjOnAccTrans
CurrencyId		Transaction/ProjOnAccTrans
DefaultDimension		Transaction/ProjOnAccTrans
Description		Transaction/ProjOnAccTrans
IsMilestoneComplete		Transaction/ProjOnAccTrans
PackedExtensions		Transaction/ProjOnAccTrans
ProjID		Transaction/ProjOnAccTrans
PSAContractLineNum		Transaction/ProjOnAccTrans
PSAIsOnAccount		Transaction/ProjOnAccTrans
PSAProjProgressInvoice		Transaction/ProjOnAccTrans
PSARefRecId		Transaction/ProjOnAccTrans
PSARefRecIdBudgetTrans		Transaction/ProjOnAccTrans
PSARefTableIdBudgetTrans		Transaction/ProjOnAccTrans
Qty		Transaction/ProjOnAccTrans
TaxGroupId		Transaction/ProjOnAccTrans
TaxItemGroupId		Transaction/ProjOnAccTrans
TaxServiceCodeId_BR		Transaction/ProjOnAccTrans
TaxWithholdItemGroupHeading_TH		Transaction/ProjOnAccTrans
TotalSalesAmountCur		Transaction/ProjOnAccTrans
TransactionOrigin		Transaction/ProjOnAccTrans
TransDate		Transaction/ProjOnAccTrans
TransId		Transaction/ProjOnAccTrans
AdjRefTransId		Transaction/ProjOnAccTrans
TransIdRef		Transaction/ProjOnAccTrans
DataAreaId		Transaction/ProjOnAccTrans
Relationship_CurrencyRelationshipId		Transaction/ProjOnAccTrans
Relationship_DefaultDimensionRelationshipId		Transaction/ProjOnAccTrans
Relationship_ForecastSalesRelationshipId		Transaction/ProjOnAccTrans
Relationship_ProjTableRelationshipId		Transaction/ProjOnAccTrans
Relationship_PSAContractLineItemsRelationshipId		Transaction/ProjOnAccTrans
Relationship_TaxGroupHeadingRelationshipId		Transaction/ProjOnAccTrans
Relationship_TaxItemGroupHeadingRelationshipId		Transaction/ProjOnAccTrans
Relationship_TaxServiceTariffRelationshipId		Transaction/ProjOnAccTrans
Relationship_TaxWithholdItemGroupHeading_THRelationshipId		Transaction/ProjOnAccTrans
Relationship_TaxServiceCodeRelationshipId		Transaction/ProjOnAccTrans
Relationship_CompanyRelationshipId		Transaction/ProjOnAccTrans

RecId

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

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

ActivityNumber

First included in: Transaction/ProjOnAccTrans (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

CurrencyId

First included in: Transaction/ProjOnAccTrans (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

DefaultDimension

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the DefaultDimension attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

Description

First included in: Transaction/ProjOnAccTrans (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

IsMilestoneComplete

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
displayName	Mark as complete
dataFormat	int32
isNullable	true

Traits

List of traits for the IsMilestoneComplete 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 Mark as complete	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

PackedExtensions

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	binary
isNullable	true

Traits

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

ProjID

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the ProjID attribute are listed below.

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

PSAContractLineNum

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

PSAIsOnAccount

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
displayName	Is on account
dataFormat	int32
isNullable	true

Traits

List of traits for the PSAIsOnAccount 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 Is on account	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

PSAProjProgressInvoice

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
displayName	Progress Invoice
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the PSAProjProgressInvoice attribute are listed below.

is.dataFormat.integer
is.readOnly
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 Progress Invoice	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

PSARefRecId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the PSARefRecId attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

PSARefRecIdBudgetTrans

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

List of traits for the PSARefRecIdBudgetTrans attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

PSARefTableIdBudgetTrans

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the PSARefTableIdBudgetTrans attribute are listed below.

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

is.dataFormat.integer

Qty

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

List of traits for the Qty attribute are listed below.

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

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

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

TaxGroupId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TaxItemGroupId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TaxServiceCodeId_BR

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TaxWithholdItemGroupHeading_TH

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

List of traits for the TaxWithholdItemGroupHeading_TH attribute are listed below.

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

is.dataFormat.integer
is.dataFormat.big

TotalSalesAmountCur

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	decimal
isNullable	true

Traits

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

TransactionOrigin

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the TransactionOrigin attribute are listed below.

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

is.dataFormat.integer

TransDate

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	date
isNullable	true

Traits

List of traits for the TransDate attribute are listed below.

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

is.dataFormat.date

TransId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	string
isReadOnly	true

Traits

List of traits for the TransId attribute are listed below.

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

AdjRefTransId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
displayName	Adjustment reference ID
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the AdjRefTransId attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

TransIdRef

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
displayName	Reference ID
dataFormat	string
isReadOnly	true
isNullable	true

Traits

List of traits for the TransIdRef attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

DataAreaId

First included in: Transaction/ProjOnAccTrans (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_CurrencyRelationshipId

First included in: Transaction/ProjOnAccTrans (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_DefaultDimensionRelationshipId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_DefaultDimensionRelationshipId 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/FinancialDimensions/Main/DimensionAttributeValueSet.cdm.json/DimensionAttributeValueSet RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ForecastSalesRelationshipId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ForecastSalesRelationshipId 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/SupplyChain/MasterPlanning/WorksheetLine/ForecastSales.cdm.json/ForecastSales RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_ProjTableRelationshipId

First included in: Transaction/ProjOnAccTrans (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_PSAContractLineItemsRelationshipId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_PSAContractLineItemsRelationshipId 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/Miscellaneous/PSAContractLineItems.cdm.json/PSAContractLineItems RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_TaxGroupHeadingRelationshipId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxGroupHeadingRelationshipId 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/Tax/Group/TaxGroupHeading.cdm.json/TaxGroupHeading RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_TaxItemGroupHeadingRelationshipId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxItemGroupHeadingRelationshipId 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/Tax/Group/TaxItemGroupHeading.cdm.json/TaxItemGroupHeading RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_TaxServiceTariffRelationshipId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxServiceTariffRelationshipId 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/Tax/Transaction/TaxServiceTariff.cdm.json/TaxServiceTariff RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_TaxWithholdItemGroupHeading_THRelationshipId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxWithholdItemGroupHeading_THRelationshipId 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/Tax/Group/TaxWithholdItemGroupHeading_TH.cdm.json/TaxWithholdItemGroupHeading_TH RecId	entity	a reference to the constant entity holding the list of entity references

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

Relationship_TaxServiceCodeRelationshipId

First included in: Transaction/ProjOnAccTrans (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_TaxServiceCodeRelationshipId 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/Tax/Group/TaxServiceCode_BR.cdm.json/TaxServiceCode_BR 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: Transaction/ProjOnAccTrans (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