Interface IGLRollupClassification

The system entity for a gl rollup classification, which belongs to a IGLRollup definition

See https://help.lemonedge.com/help/enterprise-data-tools/reporting/gl-rollups/classifications-view.html for more information

Inherited Members
Namespace: LemonEdge.API.Entities.FinancialServices.Accounting
Assembly: LemonEdge.API.Entities.FinancialServices.dll
Syntax
[EntityDefinition(EntityID.GLRollupClassification, "dbo.LT_GLRollupClassifications", "GLRollupClassification", IsStandingDataEntity = false)]
[DefaultEntityIcon(ImageType.Sigma)]
public interface IGLRollupClassification : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

GLClassificationNameID

[Key] Links to IGLClassificationName. Indicates only to include gl accounts that have the specified GL CLassification Name associated with them.

Includes all if blank.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.GLClassificationName, "ID", SingleJoinType.ZeroToOne, "GL Classification Name", "GL Rollup Classifications", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityKeyProperty]
Guid? GLClassificationNameID { get; set; }
Property Value
Type Description
Guid?

GLRollupID

[Key] Links to IGLRollup. The parent gl rollup this is a child of

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.GLRollup, "ID", SingleJoinType.One, "GL Rollup", "Classifications", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = true)]
[RequiredNoDefaultIDValidation]
[EntityKeyProperty]
Guid GLRollupID { get; set; }
Property Value
Type Description
Guid

LedgerID

[Key] Links to ILedger. Indicates only to take gl accounts that were posted into the specified ledger

Includes all if blank.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.Ledger, "ID", SingleJoinType.ZeroToOne, "Ledger", "GL Rollup Classifications", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityKeyProperty]
Guid? LedgerID { get; set; }
Property Value
Type Description
Guid?

OnlyAccountsWithClassification

[Key] Indicates only to include gl accounts that have a GL CLassification Name associated with them.

Includes all if false.

Declaration
[EntityProperty(SQLType.Bit, false, "0")]
[EntityKeyProperty]
bool OnlyAccountsWithClassification { get; set; }
Property Value
Type Description
bool

Operator

Indicates when how these amounts should be rolled up into the header balance. Can be one of the following two options:

  • Add: Indicates the values matching this GL Rollup Classification will be added together
  • Subtract: Indicates the values matching this GL Rollup CLassification will be subtracted together
Declaration
[EntityProperty(SQLType.SmallInt, false, "1")]
[Required]
[HardCodedDefaultValueOnNew("1")]
MathOperator Operator { get; set; }
Property Value
Type Description
MathOperator

ParentHeaderID

[Key] Links to IGLRollupHeader. The direct header this rollup classification is a child of

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.GLRollupHeader, "ID", SingleJoinType.One, "Rollup Header", "Classifications", DeleteWithRelationship = true, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityKeyProperty]
Guid ParentHeaderID { get; set; }
Property Value
Type Description
Guid

TransactionCodeID

[Key] Links to ITransactionCode. Indicates to only include gl accounts that were posted in transactions using the specified transaction code

Includes all if blank.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.TransactionCode, "ID", SingleJoinType.ZeroToOne, "Transaction Code", "GL Rollup Classifications", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityKeyProperty]
Guid? TransactionCodeID { get; set; }
Property Value
Type Description
Guid?

TransactionTypeValueID

[Key] Links to ITransactionTypeValue. Indicates to only include gl accounts that were posted taking values automatically from the specified value from the transaction itself

Includes all if blank.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.TransactionTypeValue, "ID", SingleJoinType.ZeroToOne, "Transaction Type Value", "GL Rollup Classifications", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityKeyProperty]
Guid? TransactionTypeValueID { get; set; }
Property Value
Type Description
Guid?

Type

[Key] This holds the type of data from the capital account data items table produced from the Period End process (see here for more information) that you would like to include. The type of data can be any of the following categories:

  • Period End: Holds all gl data on a year to date basis up to this period end.
  • Opening Balance: Holds the opening balance (the closing balance for the prior year)
  • Transfer In/Out: Holds all transfers that have occurred on a year to date basis up to this period end
  • Opening Balance Transfer In/Out: Holds the parts of the opening balance that are accounted for through transfers
  • Adjustments: Includes any adjustments you have made for this period end
Declaration
[EntityProperty(SQLType.SmallInt, false)]
[EntityKeyProperty]
[Required]
GLRollupClassificationType Type { get; set; }
Property Value
Type Description
GLRollupClassificationType

Extension Methods

See Also