Interface IGLPosting

The system entity for a gl posting

See https://web.lemonedge.com/help/transaction-gl-postings-view/ for more information

Inherited Members
System.IEquatable<LemonEdge.API.Core.IBaseEntity>.Equals(LemonEdge.API.Core.IBaseEntity)
System.ComponentModel.INotifyPropertyChanged.PropertyChanged
System.ComponentModel.INotifyPropertyChanging.PropertyChanging
Namespace: LemonEdge.API.Entities
Assembly: API.dll
Syntax
[EntityDefinition(EntityID.GLPosting, "dbo.LT_GLPostings", "GLPosting", IsStandingDataEntity = false)]
[DefaultEntityIcon(ImageType.TransactionGL)]
public interface IGLPosting : ITransactionalEntity, ICanBeLocked, IBaseEntity, IEquatable<IBaseEntity>, INotifyPropertyChanged, INotifyPropertyChanging, ICloneableAsync, ICanTrackProperties

Properties

CurrencyID

Links to ICurrency. The local currency for this gl posting.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.Currency, "ID", SingleJoinType.One, "Currency", "IGLPosting", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityDescription("The local currency for this gl posting.")]
Guid CurrencyID { get; set; }
Property Value
Type Description
System.Guid

EntityID

[Key] Links to IObjectEntity. The entity this gl posting is against.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.ObjectEntity, "ID", SingleJoinType.One, "ObjectEntity", "IGLPosting", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityDescription("The entity this gl posting is against.")]
Guid EntityID { get; set; }
Property Value
Type Description
System.Guid

FinancialDate

The Financial Date for this GL Posting for the given legal Entity and Transaction Date

Declaration
[EntityProperty(SQLType.DateTimeOffset, false, IsDate = true)]
[EntityDescription("The gl financial date for this gl posting.")]
DateTimeOffset FinancialDate { get; set; }
Property Value
Type Description
System.DateTimeOffset

FuncAmount

The amount to be posted in functional currency against this GL Account

Declaration
[EntityProperty(SQLType.Decimal, (short)21, (short)3, false)]
[EntityDescription("The value in functional currency.")]
decimal FuncAmount { get; set; }
Property Value
Type Description
System.Decimal

FXRate

The FX Rate between Local and Functional currencies

Declaration
[EntityProperty(SQLType.Decimal, (short)21, (short)10, false)]
[EntityDescription("The exchange rate for this posting between the local and functional currency.")]
decimal FXRate { get; set; }
Property Value
Type Description
System.Decimal

GLAccountID

[Key] Links to IGLAccount. The gl account this posting is debiting or crediting

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.GLAccount, "ID", SingleJoinType.One, "GLAccount", "IGLPosting", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityDescription("The account for this gl posting.")]
Guid GLAccountID { get; set; }
Property Value
Type Description
System.Guid

InstrumentID

Links to IInstrument. The instrument to use to allocate this gl posting, through instrument mappings to allocation paths.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.Instrument, "ID", SingleJoinType.ZeroToOne, "Instrument", "IGLPosting", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityDescription("The instrument to use to allocate this gl posting, through instrument mappings to allocation paths.")]
Guid? InstrumentID { get; set; }
Property Value
Type Description
System.Nullable<System.Guid>

LedgerID

[Key] Links to ILedger. The ledger this gl posting is against.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.Ledger, "ID", SingleJoinType.One, "Ledger", "IGLPosting", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityDescription("The ledger this gl posting is against.")]
Guid LedgerID { get; set; }
Property Value
Type Description
System.Guid

LocalAmount

The amount to be posted in local currency against this GL Account

Declaration
[EntityProperty(SQLType.Decimal, (short)21, (short)3, false)]
[EntityDescription("The value in local currency.")]
decimal LocalAmount { get; set; }
Property Value
Type Description
System.Decimal

ManualPosting

Indicates if this GL Posting line was added manually by the user versus automatically according to the Transaction Code

Declaration
[EntityProperty(SQLType.Bit, false, "0")]
[EntityDescription("Indicates this posting was manually entered by the user rather than being automatically calculated from the transaction.")]
bool ManualPosting { get; set; }
Property Value
Type Description
System.Boolean

ParentTransactionID

[Key] Links to ITransaction. The direct parent transaction this gl posting is a child of

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.Transaction, "ID", SingleJoinType.One, "Transaction", "IGLPosting", DeleteWithRelationship = true, PartOfParentSet = true, LinkToItemInSet = false)]
[EntityDescription("The transaction this gl posting belongs to.")]
Guid ParentTransactionID { get; set; }
Property Value
Type Description
System.Guid

PathID

Links to IAllocationPath. The path to use to allocate this gl posting.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.AllocationPath, "ID", SingleJoinType.ZeroToOne, "AllocationPath", "IGLPosting", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityDescription("The path to use to allocate this gl posting.")]
Guid? PathID { get; set; }
Property Value
Type Description
System.Nullable<System.Guid>

ReportingAmount

The amount to be posted in reporting currency against this GL Account

Declaration
[EntityProperty(SQLType.Decimal, (short)21, (short)3, false, "FuncAmount")]
[EntityDescription("The value in reporting currency.")]
decimal ReportingAmount { get; set; }
Property Value
Type Description
System.Decimal

ReportingFXRate

The FX Rate between Local and Reporting currencies

Declaration
[EntityProperty(SQLType.Decimal, (short)21, (short)10, false, "0")]
[EntityDescription("The exchange rate for this posting between the local and reporting currency.")]
decimal ReportingFXRate { get; set; }
Property Value
Type Description
System.Decimal

RootTransactionID

[Key] Links to ITransaction. The root transaction this gl posting is a child of

Declaration
[EntityProperty(SQLType.UniqueIdentifier, false)]
[EntityRelationship(EntityID.Transaction, "ID", SingleJoinType.One, "Transaction", "IGLPosting", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = true, PreventAutoConstraint = true)]
[EntityDescription("The root transaction set this gl posting belongs to.")]
Guid RootTransactionID { get; set; }
Property Value
Type Description
System.Guid

TransactionCodeGLEntryID

[Key] Links to ITransactionCodeGLEntry. The transaction code gl entry setting this posting was automatically created from.

Declaration
[EntityProperty(SQLType.UniqueIdentifier, true)]
[EntityRelationship(EntityID.TransactionCodeGLEntry, "ID", SingleJoinType.ZeroToOne, "TransactionCodeGLEntry", "IGLPosting", DeleteWithRelationship = false, PartOfParentSet = false, LinkToItemInSet = false, InheritPermissions = false)]
[EntityDescription("The transaction code gl entry setting this posting was automatically created from.")]
Guid? TransactionCodeGLEntryID { get; set; }
Property Value
Type Description
System.Nullable<System.Guid>

TransactionDate

[Key] The Transaction Date for this GL Posting. Normally this would be the same as the Transaction Date of the Transaction, but can be configured to hold other values such as the Settlement Date

Declaration
[EntityProperty(SQLType.DateTimeOffset, false, IsDate = true)]
[EntityDescription("The transaction date of this gl posting.")]
DateTimeOffset TransactionDate { get; set; }
Property Value
Type Description
System.DateTimeOffset

Extension Methods

See Also