JOURNALENTRY_EXT (4.0)

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes
BATCHID	uniqueidentifier	true	GLBATCH.ID
REVERSEDGLTRANSACTIONID	uniqueidentifier	true	JOURNALENTRY.ID
REVENUEID	uniqueidentifier	true	FINANCIALTRANSACTION.ID
GLPAYMENTMETHODREVENUETYPEMAPPINGID	uniqueidentifier	true	GLPAYMENTMETHODREVENUETYPEMAPPING.ID
WRITEOFFID	uniqueidentifier	true	FINANCIALTRANSACTION.ID
PROPERTYDETAILID	uniqueidentifier	true	FINANCIALTRANSACTION.ID
STOCKSALEID	uniqueidentifier	true	FINANCIALTRANSACTION.ID
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID
GIFTINKINDSALEID	uniqueidentifier	true	FINANCIALTRANSACTION.ID
CREDITITEMID	uniqueidentifier	true	FINANCIALTRANSACTIONLINEITEM.ID
CREDITPAYMENTID	uniqueidentifier	true	CREDITPAYMENT.ID
DISCOUNTCREDITITEMID	uniqueidentifier	true	FINANCIALTRANSACTIONLINEITEM.ID
PLANNEDGIFTPAYOUTID	uniqueidentifier	true	FINANCIALTRANSACTION.ID
PRECALCORGANIZATIONEXCHANGERATEID	uniqueidentifier	true	CURRENCYEXCHANGERATE.ID
PRECALCBASEEXCHANGERATEID	uniqueidentifier	true	CURRENCYEXCHANGERATE.ID

Fields
Field	Field Type	Null	Notes
PROJECT	nvarchar(100)	false	''
JOURNAL	nvarchar(255)	false	''
TABLENAMECODE	tinyint	false	1
REVERSEDATE	datetime	true
DISTRIBUTIONTABLEID	uniqueidentifier	true
OUTDATED	bit	false	0
PAYMENTMETHODCODE	tinyint	false	1
DATEADDED	datetime	false	getdate()
DATECHANGED	datetime	false	getdate()
TS	timestamp	false
TSLONG	bigint (Computed)	true
TABLENAME	nvarchar(42) (Computed)	true
PAYMENTMETHOD	nvarchar(35) (Computed)	true
LOGICALREVENUEID	uniqueidentifier	true
REVENUESPLITGIFTFEEID	uniqueidentifier	true
REVENUESPLITGIFTAIDID	uniqueidentifier	true
ACCOUNT	nvarchar(100)	false	''
PRECALCPOSTSTATUSCODE	tinyint	false	1
PRECALCPOSTSTATUS	nvarchar(11) (Computed)	true
REVENUEPURCHASEID	uniqueidentifier	true
FULLYPAIDSTATUSCODE	tinyint	false	0
FULLYPAIDSTATUS	nvarchar(18) (Computed)	true
BENEFITTYPECODE	tinyint	false	4
BENEFITTYPE	nvarchar(9) (Computed)	true
GLTRANSACTIONID	uniqueidentifier (Computed)	false

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_JOURNALENTRY_EXT_CREDITITEMID	CREDITITEMID	False	False	False
IX_JOURNALENTRY_EXT_CREDITPAYMENTID	CREDITPAYMENTID	False	False	False
IX_JOURNALENTRY_EXT_DATEADDED	DATEADDED	False	False	True
IX_JOURNALENTRY_EXT_DATECHANGED	DATECHANGED	False	False	False
IX_JOURNALENTRY_EXT_DISCOUNTCREDITITEMID	DISCOUNTCREDITITEMID	False	False	False
IX_JOURNALENTRY_EXT_DISTRIBUTIONTABLEID	DISTRIBUTIONTABLEID	False	False	False
IX_JOURNALENTRY_EXT_GIFTINKINDSALEID	GIFTINKINDSALEID	False	False	False
IX_JOURNALENTRY_EXT_GLTRANSACTIONID	GLTRANSACTIONID	False	False	False
IX_JOURNALENTRY_EXT_ID	ID	False	False	False
IX_JOURNALENTRY_EXT_PLANNEDGIFTPAYOUTID	PLANNEDGIFTPAYOUTID	False	False	False
IX_JOURNALENTRY_EXT_PROPERTYDETAILID	PROPERTYDETAILID	False	False	False
IX_JOURNALENTRY_EXT_REVENUEID_TABLENAMECODE	REVENUEID TABLENAMECODE	False	False	False
IX_JOURNALENTRY_EXT_REVERSEDGLTRANSACTIONID	REVERSEDGLTRANSACTIONID	False	False	False
IX_JOURNALENTRY_EXT_STOCKSALEID	STOCKSALEID	False	False	False
IX_JOURNALENTRY_EXT_TABLENAMECODE_ID	TABLENAMECODE ID	False	False	False
IX_JOURNALENTRY_EXT_WRITEOFFID	WRITEOFFID	False	False	False
PK_JOURNALENTRY_EXT	ID	True	True	False

Triggers
Trigger Name	Description
TR_JOURNALENTRY_EXT_AUDIT_UPDATE
TR_JOURNALENTRY_EXT_AUDIT_DELETE