Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TRANSACTIONTYPECODE tinyint   Default = 1 Transaction Type - Debit or Credit
 TRANSACTIONTYPE nvarchar(6) (Computed) CASE [TRANSACTIONTYPECODE] WHEN 0 THEN N'Debit' WHEN 1 THEN N'Credit' END Provides a translation for the 'TRANSACTIONTYPECODE' field.
 CLASSCODE tinyint   Default = 1 Class
 CLASS nvarchar(33) (Computed) CASE [CLASSCODE] WHEN 0 THEN N'Unrestricted Net Assets' WHEN 1 THEN N'Temporarily Restricted Net Assets' WHEN 2 THEN N'Permanently Restricted Net Assets' END Provides a translation for the 'CLASSCODE' field.
 SEQUENCE int   Default = 0 Sequence of this journal entry within the parent line item.
 AMOUNT money   Default = 0 The amount of the journal entry in the base currency.
 PERCENTAGE decimal(20, 19)   Default = 0 Percentage used when recalculating distributions.
 COMMENT nvarchar(60)   Default = '' User defined comment associated with this journal entry.
 POSTDATE date Post date of the journal entry.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 SUBLEDGERTYPECODE tinyint   Default = 1 Transaction Type for the subledger- Debit or Credit
 SUBLEDGERTYPE nvarchar(6) (Computed) CASE [SUBLEDGERTYPECODE] WHEN 0 THEN N'Debit' WHEN 1 THEN N'Credit' END Provides a translation for the 'SUBLEDGERTYPECODE' field.
 BASEAMOUNT money   Default = 0 The amount of the journal entry in base currency
 ORGAMOUNT money   Default = 0 The amount of the journal entry in organization currency

Foreign Key Field Type Null Notes Description
 FINANCIALTRANSACTIONLINEITEMID uniqueidentifier FINANCIALTRANSACTIONLINEITEM.ID The FK to the FinancialTransactionLineItem Table.
 JOURNALCODEID uniqueidentifier JOURNALCODE.ID Journal
 SUMMARYID uniqueidentifier JOURNALENTRY.ID FK to the journal entry which summarizes this entry.
 BATCHID uniqueidentifier FINANCIALTRANSACTION.ID FK to the Financial Transaction (batch) this journal entry is part of. This is used by sub-ledgers during the posting process.
 DATAELEMENT1ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 1
 DATAELEMENT2ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 2
 DATAELEMENT3ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 3
 DATAELEMENT4ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 4
 DATAELEMENT5ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 5
 DATAELEMENT6ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 6
 DATAELEMENT7ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 7
 DATAELEMENT8ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 8
 DATAELEMENT9ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 9
 DATAELEMENT10ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 10
 DATAELEMENT11ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 11
 DATAELEMENT12ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 12
 DATAELEMENT13ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 13
 DATAELEMENT14ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 14
 DATAELEMENT15ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 15
 DATAELEMENT16ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 16
 DATAELEMENT17ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 17
 DATAELEMENT18ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 18
 DATAELEMENT19ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 19
 DATAELEMENT20ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 20
 DATAELEMENT21ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 21
 DATAELEMENT22ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 22
 DATAELEMENT23ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 23
 DATAELEMENT24ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 24
 DATAELEMENT25ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 25
 DATAELEMENT26ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 26
 DATAELEMENT27ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 27
 DATAELEMENT28ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 28
 DATAELEMENT29ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 29
 DATAELEMENT30ID uniqueidentifier PDACCOUNTSEGMENTVALUE.ID FK to the Data Element 30
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 FINANCIALBATCHID uniqueidentifier FINANCIALBATCH.ID FK to the Financial Batch table
 GLACCOUNTID uniqueidentifier GLACCOUNT.ID FK to GLACCOUNT

Index Name Field(s) Unique Primary Clustered
 IX_JOURNALENTRY_DATEADDED DATEADDED    
 IX_JOURNALENTRY_DATECHANGED DATECHANGED      
 PK_JOURNALENTRY ID  
 UIX_JOURNALENTRY_FINANCIALTRANSACTIONLINEITEMID_FINANCIALBATCHID_SEQUENCE FINANCIALTRANSACTIONLINEITEMID, FINANCIALBATCHID, SEQUENCE    

Trigger Name Description
 TR_JOURNALENTRY_AUDIT_UPDATE
 TR_JOURNALENTRY_AUDIT_DELETE
 TR_JOURNALENTRY_INSUPD

Referenced by Field
 JOURNALENTRYANNOTATION JOURNALENTRYID

Entity-Relationship diagram of this table