Budget account entries in WorksheetLine(BudgetTransactionLine)

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

Attributes

Name	Description	First Included in Instance
RecId		WorksheetLine/BudgetTransactionLine
AccountingCurrencyAmount		WorksheetLine/BudgetTransactionLine
AssetBudget		WorksheetLine/BudgetTransactionLine
BudgetTransactionHeader		WorksheetLine/BudgetTransactionLine
BudgetType		WorksheetLine/BudgetTransactionLine
Comment		WorksheetLine/BudgetTransactionLine
Date		WorksheetLine/BudgetTransactionLine
GeneralJournalEntry		WorksheetLine/BudgetTransactionLine
IncludeInCashFlowForecast		WorksheetLine/BudgetTransactionLine
LedgerDimension		WorksheetLine/BudgetTransactionLine
LineNumber		WorksheetLine/BudgetTransactionLine
Price		WorksheetLine/BudgetTransactionLine
ProjTransBudgetTransId		WorksheetLine/BudgetTransactionLine
Quantity		WorksheetLine/BudgetTransactionLine
TaxGroup		WorksheetLine/BudgetTransactionLine
TransactionCurrency		WorksheetLine/BudgetTransactionLine
TransactionCurrencyAmount		WorksheetLine/BudgetTransactionLine
WorkflowStatus		WorksheetLine/BudgetTransactionLine
AssetBudget_RU		WorksheetLine/BudgetTransactionLine
Relationship_AssetBudgetRelationshipId		WorksheetLine/BudgetTransactionLine
Relationship_BudgetTransactionHeaderRelationshipId		WorksheetLine/BudgetTransactionLine
Relationship_CurrencyRelationshipId		WorksheetLine/BudgetTransactionLine
Relationship_GeneralJournalEntryRelationshipId		WorksheetLine/BudgetTransactionLine
Relationship_LedgerDimensionRelationshipId		WorksheetLine/BudgetTransactionLine
Relationship_TaxGroupRelationshipId		WorksheetLine/BudgetTransactionLine
Relationship_RAssetBudgetTrans_RURelationshipId		WorksheetLine/BudgetTransactionLine

RecId

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

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

AccountingCurrencyAmount

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	decimal
isReadOnly	true
isNullable	true

Traits

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

AssetBudget

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

BudgetTransactionHeader

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the BudgetTransactionHeader attribute are listed below.

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

BudgetType

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the BudgetType attribute are listed below.

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

is.dataFormat.integer

Comment

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
displayName	Comment
dataFormat	string
isNullable	true

Traits

List of traits for the Comment attribute are listed below.

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

is.dataFormat.character
is.dataFormat.array

Date

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	date

Traits

List of traits for the Date attribute are listed below.

is.dataFormat.date
means.measurement.date
is.dataFormat.date

GeneralJournalEntry

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	int64
isReadOnly	true
isNullable	true

Traits

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

IncludeInCashFlowForecast

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
displayName	Include in cash flow forecasts
dataFormat	int32
isNullable	true

Traits

List of traits for the IncludeInCashFlowForecast 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 Include in cash flow forecasts	entity	a reference to the constant entity holding the list of localized text

is.dataFormat.integer

LedgerDimension

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	int64

Traits

List of traits for the LedgerDimension attribute are listed below.

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

LineNumber

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	decimal

Traits

List of traits for the LineNumber attribute are listed below.

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

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

Price

First included in: WorksheetLine/BudgetTransactionLine (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

ProjTransBudgetTransId

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

Quantity

First included in: WorksheetLine/BudgetTransactionLine (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

TaxGroup

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

TransactionCurrency

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the TransactionCurrency attribute are listed below.

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

TransactionCurrencyAmount

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
displayName	Transaction currency amount
dataFormat	decimal
isNullable	true

Traits

List of traits for the TransactionCurrencyAmount 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.localized.displayedAs
Holds the list of language specific display text for an object.

Parameter	Value	Data type	Explanation
localizedDisplayText	languageTag displayText en Transaction currency amount	entity	a reference to the constant entity holding the list of localized text

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

WorkflowStatus

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	int32
isReadOnly	true
isNullable	true

Traits

List of traits for the WorkflowStatus attribute are listed below.

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

is.dataFormat.integer

AssetBudget_RU

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

Relationship_AssetBudgetRelationshipId

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_BudgetTransactionHeaderRelationshipId

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_BudgetTransactionHeaderRelationshipId 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/Budget/WorksheetHeader/BudgetTransactionHeader.cdm.json/BudgetTransactionHeader 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: WorksheetLine/BudgetTransactionLine (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_GeneralJournalEntryRelationshipId

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_LedgerDimensionRelationshipId

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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

Relationship_TaxGroupRelationshipId

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

First included in: WorksheetLine/BudgetTransactionLine (this entity)

Properties

Name	Value
dataFormat	guid

Traits

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

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