Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Type: OM.Accounting.GLTrans

PropertyTypeForeigner IdFriendly code propertyComment
GLTransHeaderOM.Accounting.GLTransHeaderGLTransHeader_Id

BookPeriodOM.Accounting.BookPeriodBookPeriod_Id
Same as GLTransHeader.BookPeriod
CurrencyOM.CurrencyCurrency_IdCurrencyCodeCurrency of the folder or another currency (but not empty)
GLAccountOM.Accounting.GLAccountGLAccount_IdGLAccountCode
GLAccount2OM.Accounting.GLAccountGLAccount2_IdGLAccount2CodeUsed to show the contrapart account in the misc.op generated for the permanent inventory
(not used in BE legislation)
CentralAccountTypeOM.Accounting.CentralAccountTypeCentralAccountType_IdCentralAccountTypeCodeSame as GLAccount.CentralAccountType at the time of the booking
VatOM.Accounting.VatVat_IdVatCodeFor sales and purchase, the Vat:
  • has to be defined for the vat account (411000, 451000 for example)
  • could be defined for the sales or purchase account (604000, 700000 for example)
DeductibilityRateOM.Accounting.DeductibilityRateDeductibilityRate_IdDeductibilityRateCodeIf the VAT is partially deductible, this has to be defined
CustomerOM.CustomerCustomer_IdCustomerCodeFor sales, bank and misc.op. on customers
SupplierOM.SupplierSupplier_IdSupplierCodeFor purchases, bank and misc.op. on suppliers
GLTransOM.Accounting.GLTransGLTrans_Id
In case of the transaction is a sub transcation of a parent one (difference of payment for example), this is a reference to the parent one
GLMatchOM.Accounting.GLMatchGLMatch_IdGLMacthCodeIf the transaction is in a matching, this is the matching reference
CodaTransactionOM.Accounting.CodaTransactionCodaTransaction_Id

VatPeriodOM.Accounting.BookPeriodVatPeriod_Id

LineOrderint

For sales and purchase, LineOrder is going from 0 to N, by 1. The transaction on the customer or supplier has to be with LineOrder = 0.
For bank&cash and misc.op., LineOrder is going from 1000 to Nx1000, by 1000. In case if difference of payment, it's on the LineOrder xx20 for the transaction xx00. When we insert a transaction between 1000 and 2000, it will have the LineOrder 1500
ValueDateDateTime

For sales, purchase and misc.op. = GLTransHeader.BookDate
For bank, ValueDate can be different that the BookDate
OldestMatchedDateDateTime?

If the transaction is inside a matching
OldestMatchDate = GLMatch.OldestMatchDate
else
OldestMatchDate = ValueDate
Amountdecimal

Signed amount of the transaction. Debit = +, Credit = -
Amount2decimal?

If an alternative currency is defined for the folder (rarely done), it's the amount in the alternative currency at the rate of the booking
VatBaseAmountdecimal?


TurnOverAmountdecimal?


VatTaxAmountdecimal
?IsNegativeBookingboolIsVatInputByUserboolIsVatAllocationboolOldestMatchedDateDateTime
?


CurrencyAmountdecimal?


CurrencyRatedecimal?


CurrencyVatBaseAmountdecimal?


CurrencyVatTaxAmountdecimal?


CommentBookingstring


CommentBooking2string


CommentExternalstring


Referencestring


BankStatementReferencestring


VatDateDateTime?


VatEventshort

UnKnown
Delivery
Payment
IsNegativeBookingbool

Not use
IsVatInputByUserbool


IsVatAllocationbool


IsCodabool