Interface IGLRollupClassification
The system entity for a gl rollup classification, which belongs to a IGLRollup definition
See https://web.lemonedge.com/help/gl-rollup-classifications-view/ for more information
Inherited Members
Namespace: LemonEdge.API.Entities
Assembly: API.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, "IGLRollupClassification", "Classifications", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
Guid? GLClassificationNameID { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.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, "IGLRollupClassification", "Classifications", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false, InheritPermissions = true)]
Guid GLRollupID { get; set; }
Property Value
Type | Description |
---|---|
System.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, "IGLRollupClassification", "Classifications", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
Guid? LedgerID { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.Guid> |
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, "IGLRollupClassification", "Classifications", DeleteWithRelationship = true, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
Guid ParentHeaderID { get; set; }
Property Value
Type | Description |
---|---|
System.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, "IGLRollupClassification", "Classifications", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
Guid? TransactionCodeID { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.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, "IGLRollupClassification", "Classifications", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
Guid? TransactionTypeValueID { get; set; }
Property Value
Type | Description |
---|---|
System.Nullable<System.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)]
[Required]
GLRollupClassificationType Type { get; set; }
Property Value
Type | Description |
---|---|
GLRollupClassificationType |