Interface ITransactionCodeGLEntry

The system entity for a transaction code gl entry, which holds settings for how to process the gl within a parent ITransactionCode

See https://help.lemonedge.com/help/settings/financial-services-transactions/transaction-types/gl-entries-view.html for more information

Inherited Members
Namespace: LemonEdge.API.Entities.FinancialServices.Transactions
Assembly: LemonEdge.API.Entities.FinancialServices.dll
Syntax
[EntityDefinition(EntityID.TransactionCodeGLEntry, "dbo.LT_TransactionCodeGLEntries", "TransactionCodeGLEntry", IsStandingDataEntity = true)]
[DefaultEntityIcon(ImageType.TransactionGL)]
public interface ITransactionCodeGLEntry : IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

AllowNegatives

Indicates this gl amount will always be either a positive debit or credit, changing the sign will swap debit/credit position. If negatives are allowed it will hold at its debit/credit position but show the opposite sign instead.

Declaration
[EntityProperty(SQLType.Bit, false, "0")]
[EntityDescription("Indicates this gl amount will always be either a positive debit or credit, changing the sign will swap debit/credit position. If negatives are allowed it will hold at its debit/credit position but show the opposite sign instead.")]
bool AllowNegatives { get; set; }
Property Value
Type Description
bool

ChartID

Parent chart of accounts

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.ChartOfAccount, "ID", SingleJoinType.ZeroToOne, "Chart Of Accounts", "Accounts", DeleteWithRelationship = true, InheritPermissions = false, PartOfParentSet = false, LinkToItemInSet = true)]
[EntityDescription("The chart of accounts this account belongs to.")]
Guid? ChartID { get; set; }
Property Value
Type Description
Guid?

Date

Indicates what to use for the date of the gl entry.

Declaration
[EntityProperty(SQLType.SmallInt, false)]
[EntityDescription("Indicates what to use for the date of the gl entry.")]
[EntityKeyProperty]
TransactionCodeGLEntryDate Date { get; set; }
Property Value
Type Description
TransactionCodeGLEntryDate

DateFormula

A formula used to evaluate what date to use for the gl entry.

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula used to evaluate what date to use for the gl entry.")]
string DateFormula { get; set; }
Property Value
Type Description
string

DebitCredit

Indicates if this entry should be a debit or credit.

Declaration
[EntityProperty(SQLType.SmallInt, false)]
[EntityDescription("Indicates if this entry should be a debit or credit.")]
[HardCodedDefaultValueOnNew("1")]
TransactionCodeGLEntryDbCr DebitCredit { get; set; }
Property Value
Type Description
TransactionCodeGLEntryDbCr

EntityFormula

A formula used to evaluate which entity this gl entry is against. By default (if formula is empty) it is the entity of the transaction itself.

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula used to evaluate which entity this gl entry is against. By default (if formula is empty) it is the entity of the transaction itself.")]
[EntityKeyProperty]
string EntityFormula { get; set; }
Property Value
Type Description
string

Entry

Indicates whether the reporting, functional or local, is used, the other being automatically calculated from the exchange rate.

Declaration
[EntityProperty(SQLType.SmallInt, false, "6")]
[EntityDescription("Indicates whether the reporting, functional or local, is used, the other being automatically calculated from the exchange rate.")]
[HardCodedDefaultValueOnNew("6")]
TransactionTypeValueEntry Entry { get; set; }
Property Value
Type Description
TransactionTypeValueEntry

GLAccountID

[Key] Links to IGLAccount. The GL Account you want to automatically debit or credit, can be null if set to user selectable bank account

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.GLAccount, "ID", SingleJoinType.ZeroToOne, "GL Account", "Transaction Code GL Entries", DeleteWithRelationship = true, PartOfParentSet = false, LinkToItemInSet = true, InheritPermissions = false)]
[RequiredNoDefaultIDValidation]
[EntityKeyProperty]
[EntityDescription("This indicates which gl account to create an entry with, can be null if set to user selectable bank account")]
Guid? GLAccountID { get; set; }
Property Value
Type Description
Guid?

GuardFormula

A formula used to return true or false indicating if this gl entry should be created or not.

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula used to return true or false indicating if this gl entry should be created or not..")]
string GuardFormula { get; set; }
Property Value
Type Description
string

IsBalancingEntry

Indicates this gl account should hold the amount required to balance all gl entries for the transaction.

Declaration
[EntityProperty(SQLType.Bit, false, "0")]
[EntityDescription("Indicates this gl account should hold the amount required to balance all gl entries for the transaction.")]
bool IsBalancingEntry { get; set; }
Property Value
Type Description
bool

LedgerID

[Key] Links to ILedger. The Ledger to specifically use for this GL Posting entry. This can be explicitly set to be different than the Ledger of the parent Transaction.

If left blank the GL Posting will automatically be in the same Ledger as the Transaction.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.Ledger, "ID", SingleJoinType.ZeroToOne, "Ledger", "Transaction Code GL Entries", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = true)]
[EntityKeyProperty]
[EntityDescription("Indicates which ledger to use. If not specified it automatically inherits the ledger from the transaction code.")]
Guid? LedgerID { get; set; }
Property Value
Type Description
Guid?

LocalCurrencyFormula

A formula used to evaluate which currency the local gl entry is against. By default (if formula is empty) it is the transaction currency. Functional is always the currency of the entry this gl entry is against.

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula used to evaluate which currency the local gl entry is against. By default (if formula is empty) it is the transaction currency. Functional is always the currency of the entry this gl entry is against.")]
string LocalCurrencyFormula { get; set; }
Property Value
Type Description
string

RelatedEntityFormula

A formula used to evaluate which related entity this gl entry is against.

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula used to evaluate which related entity this gl entry is against.")]
string RelatedEntityFormula { get; set; }
Property Value
Type Description
string

SelectableBankAccount

Indicates the gl account is a selectable bank account owned by the entity.

Declaration
[EntityProperty(SQLType.Bit, false, "0")]
[EntityDescription("Indicates the gl account is a selectable bank account owned by the entity.")]
bool SelectableBankAccount { get; set; }
Property Value
Type Description
bool

SubAccountFormula

A formula used to evaluate which sub account to use for the entry

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula used to evaluate which sub account to use for the entry.")]
string SubAccountFormula { get; set; }
Property Value
Type Description
string

SubAccountID

[Key] Links to IGLAccount. The Sub Account you want to automatically debit or credit, can be null and user selectable

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.GLAccount, "ID", SingleJoinType.ZeroToOne, "Sub Account", "Transaction Code GL Sub Account Entries", DeleteWithRelationship = true, PartOfParentSet = false, LinkToItemInSet = true, InheritPermissions = false)]
[RequiredNoDefaultIDValidation]
[EntityKeyProperty]
[EntityDescription("This indicates which sub account to create an entry with")]
Guid? SubAccountID { get; set; }
Property Value
Type Description
Guid?

TransactionCodeID

[Key] Links to ITransactionCode. This is a gl entry automatically created from a specified value on a transaction code

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.TransactionCode, "ID", SingleJoinType.ZeroToOne, "Transaction Code", "GL Entries", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = true)]
[EntityKeyProperty]
[EntityDescription("This is a gl entry automatically created from a specified value on a transaction code")]
Guid? TransactionCodeID { get; set; }
Property Value
Type Description
Guid?

TransactionTypeValueID

[Key] Links to ITransactionTypeValue. The Value from the Transaction the system should use to populate this GL Posting automatically with.

If this is against a Transaction Code you can pick from the Values this Transaction Code has configured to use.

If this is against a Transaction Type Value already this column will be hidden and will always just take the Value from that field anyway
Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.TransactionTypeValue, "ID", SingleJoinType.ZeroToOne, "Transaction Type Value", "Transaction Code GL Entries", DeleteWithRelationship = true, PartOfParentSet = false, LinkToItemInSet = true)]
[EntityKeyProperty]
[EntityDescription("This is a gl entry automatically created from a specified transaction type value.")]
Guid? TransactionTypeValueID { get; set; }
Property Value
Type Description
Guid?

ValueFunctionalFormula

A formula used to evaluate what functional value to use for the gl entry.

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula used to evaluate what functional value to use for the gl entry.")]
string ValueFunctionalFormula { get; set; }
Property Value
Type Description
string

ValueLocalFormula

A formula used to evaluate what local value to use for the gl entry.

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula used to evaluate what local value to use for the gl entry.")]
string ValueLocalFormula { get; set; }
Property Value
Type Description
string

ValueReportingFormula

A formula used to evaluate what reporting value to use for the gl entry.

Declaration
[EntityProperty(SQLType.NVarChar, true)]
[EntityDescription("A formula used to evaluate what reporting value to use for the gl entry.")]
string ValueReportingFormula { get; set; }
Property Value
Type Description
string

When

Indicates when this gl entry should be created

Declaration
[EntityProperty(SQLType.SmallInt, false, "0")]
[EntityDescription("Indicates when this gl entry should be created")]
[EntityKeyProperty]
TransactionGLMatch When { get; set; }
Property Value
Type Description
TransactionGLMatch

Extension Methods

See Also