View Categories

JournalEntry

Sub tables:

  • JournalCreditLineRet
  • JournalDebitLineRet
FIELD NAMEFIELD NAME (old)QUERYABLEUPDATEABLEREQUIRED
ON UPDATE
INSERTABLEREQUIRED
ON INSERT
TxnIDtrue
TimeCreatedtrue
TimeModifiedtrue
EditSequencetrue
TxnNumbertrue
TxnDatetrue
RefNumbertrue
Memotrue
IsAdjustmenttrue
IsHomeCurrencyAdjustmenttrue
IsAmountsEnteredInHomeCurrencytrue
CurrencyRef_ListIDtrue
CurrencyRef_FullNametrue
ExchangeRatetrue
ExternalGUIDtrue
UserDatauser field
Operationadd, update, delete, refresh, void