Main account templates in Main(MainAccountTemplate)

Article
02/22/2022

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	MainAccountTemplate/(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	Main account templates

entity

a reference to the constant entity holding the list of localized text

Attributes

Name	Description	First Included in Instance
RecId		Main/MainAccountTemplate
AccountDescription		Main/MainAccountTemplate
AccountNumber		Main/MainAccountTemplate
Closing		Main/MainAccountTemplate
ConsolidationMainAccount		Main/MainAccountTemplate
ControlUser		Main/MainAccountTemplate
CurrencyCode		Main/MainAccountTemplate
DebitCreditBalanceDemand		Main/MainAccountTemplate
DebitCreditCheck		Main/MainAccountTemplate
DebitCreditProposal		Main/MainAccountTemplate
Description		Main/MainAccountTemplate
ExchangeAdjusted		Main/MainAccountTemplate
ExchangeAdjustmentRateType		Main/MainAccountTemplate
FinancialReportingExchangeRateType		Main/MainAccountTemplate
FinancialReportingTranslationType		Main/MainAccountTemplate
IsBlockedForManualEntry		Main/MainAccountTemplate
MainAccountCategory		Main/MainAccountTemplate
MandatoryPaymentReference		Main/MainAccountTemplate
Monetary		Main/MainAccountTemplate
Name		Main/MainAccountTemplate
PostingType		Main/MainAccountTemplate
ReportingAccountType		Main/MainAccountTemplate
Type		Main/MainAccountTemplate
UserInfoId		Main/MainAccountTemplate
ValidateCurrency		Main/MainAccountTemplate
ValidatePosting		Main/MainAccountTemplate
ValidateUser		Main/MainAccountTemplate
ReportingExchangeAdjustmentRateType		Main/MainAccountTemplate
Relationship_CurrencyRelationshipId		Main/MainAccountTemplate
Relationship_FinancialReportingExchangeRateTypeRelationshipId		Main/MainAccountTemplate
Relationship_MainAccountCategoryRelationshipId		Main/MainAccountTemplate
Relationship_ExchangeAdjustmentRateTypeRelationshipId		Main/MainAccountTemplate
Relationship_ReportingExchangeAdjustmentRateTypeRelationshipId		Main/MainAccountTemplate

RecId

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

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

AccountDescription

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Name
dataFormat	string
isNullable	true

Traits

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

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

AccountNumber

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Main account
dataFormat	string
isNullable	true

Traits

List of traits for the AccountNumber 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	Main account

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

Closing

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Close
dataFormat	int32
isNullable	true

Traits

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

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ConsolidationMainAccount

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Consolidation account
dataFormat	string
isNullable	true

Traits

List of traits for the ConsolidationMainAccount 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	Consolidation account

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

ControlUser

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

CurrencyCode

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	string
isNullable	true

Traits

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

DebitCreditBalanceDemand

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the DebitCreditBalanceDemand attribute are listed below.

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

is.dataFormat.integer

DebitCreditCheck

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	DB/CR requirement
dataFormat	int32
isNullable	true

Traits

List of traits for the DebitCreditCheck 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	DB/CR requirement

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

DebitCreditProposal

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	DB/CR proposal
dataFormat	int32
isNullable	true

Traits

List of traits for the DebitCreditProposal 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	DB/CR proposal

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

Description

First included in: Main/MainAccountTemplate (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

ExchangeAdjusted

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Foreign currency revaluation
dataFormat	int32
isNullable	true

Traits

List of traits for the ExchangeAdjusted 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	Foreign currency revaluation

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ExchangeAdjustmentRateType

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

FinancialReportingExchangeRateType

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

FinancialReportingTranslationType

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the FinancialReportingTranslationType attribute are listed below.

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

is.dataFormat.integer

IsBlockedForManualEntry

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Do not allow manual entry
dataFormat	int32
isNullable	true

Traits

List of traits for the IsBlockedForManualEntry 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	Do not allow manual entry

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

MainAccountCategory

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int64
isNullable	true

Traits

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

MandatoryPaymentReference

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Mandatory reference
dataFormat	int32
isNullable	true

Traits

List of traits for the MandatoryPaymentReference 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	Mandatory reference

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

Monetary

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Monetary attribute are listed below.

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

is.dataFormat.integer

Name

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	string

Traits

List of traits for the Name attribute are listed below.

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

PostingType

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the PostingType attribute are listed below.

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

is.dataFormat.integer

ReportingAccountType

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the ReportingAccountType attribute are listed below.

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

is.dataFormat.integer

Type

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	int32
isNullable	true

Traits

List of traits for the Type attribute are listed below.

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

is.dataFormat.integer

UserInfoId

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	User
dataFormat	string
isNullable	true

Traits

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

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.character
is.dataFormat.array

ValidateCurrency

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Currency validation rule
dataFormat	int32
isNullable	true

Traits

List of traits for the ValidateCurrency 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	Currency validation rule

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ValidatePosting

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Posting validation rule
dataFormat	int32
isNullable	true

Traits

List of traits for the ValidatePosting 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	Posting validation rule

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ValidateUser

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	User validation rule
dataFormat	int32
isNullable	true

Traits

List of traits for the ValidateUser 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	User validation rule

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer

ReportingExchangeAdjustmentRateType

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
displayName	Reporting currency exchange rate type
dataFormat	int64
isNullable	true

Traits

List of traits for the ReportingExchangeAdjustmentRateType attribute are listed below.

is.dataFormat.integer
is.dataFormat.big
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	Reporting currency exchange rate type

entity

a reference to the constant entity holding the list of localized text

is.dataFormat.integer
is.dataFormat.big

Relationship_CurrencyRelationshipId

First included in: Main/MainAccountTemplate (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_FinancialReportingExchangeRateTypeRelationshipId

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_FinancialReportingExchangeRateTypeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Currency/Group/ExchangeRateType.cdm.json/ExchangeRateType	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_MainAccountCategoryRelationshipId

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_MainAccountCategoryRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Finance/Ledger/Main/MainAccountCategory.cdm.json/MainAccountCategory	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_ExchangeAdjustmentRateTypeRelationshipId

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ExchangeAdjustmentRateTypeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Currency/Group/ExchangeRateType.cdm.json/ExchangeRateType	RecId

entity

a reference to the constant entity holding the list of entity references

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

Relationship_ReportingExchangeAdjustmentRateTypeRelationshipId

First included in: Main/MainAccountTemplate (this entity)

Properties

Name	Value
dataFormat	guid

Traits

List of traits for the Relationship_ReportingExchangeAdjustmentRateTypeRelationshipId attribute are listed below.

Parameter

Value

Data type

Explanation

entityReferences

entityReference	attributeReference
/core/operationsCommon/Tables/Common/Currency/Group/ExchangeRateType.cdm.json/ExchangeRateType	RecId

entity

a reference to the constant entity holding the list of entity references

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

Share via

Main account templates in Main(MainAccountTemplate)

Traits

Attributes

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Properties

Traits

Feedback

Additional resources