Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TRANSACTIONAMOUNT money   Default = 0 The amount of the line item
 VISIBLE bit   Default = 1 Determines if the Detail is visible to the System.
 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.
 DESCRIPTION nvarchar(700)   Default = '' The description of the line item
 SEQUENCE int   Default = 0 The order that the line items are entered for the financial transaction
 TYPECODE tinyint   Default = 0 The type of the line item.
 POSTDATE date Post date of transaction
 POSTSTATUSCODE tinyint   Default = 1 Post status
 POSTSTATUS nvarchar(11) (Computed) CASE [POSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Posted' WHEN 3 THEN N'Do not post' END Provides a translation for the 'POSTSTATUSCODE' field.
 DELETEDON datetime Date and time line items was deleted.
 BASEAMOUNT money   Default = 0 The amount of the line item in base currency
 ORGAMOUNT money   Default = 0 The amount of the line item in organization currency
 QUANTITY decimal(20, 4)   Default = 1
 UNITVALUE money   Default = 0
 TYPE nvarchar(20) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Standard' WHEN 1 THEN N'Reversal' WHEN 2 THEN N'Application' WHEN 3 THEN N'AssociatedLineItem' WHEN 5 THEN N'Discount' WHEN 6 THEN N'Unrealized Gain/Loss' WHEN 7 THEN N'Fee' WHEN 8 THEN N'Tax' WHEN 98 THEN N'Combined' WHEN 99 THEN N'Orphaned' END

Foreign Key Field Type Null Notes Description
 FINANCIALTRANSACTIONID uniqueidentifier   FINANCIALTRANSACTION.ID The FK to the FinancialTransaction Table.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 REVERSEDLINEITEMID uniqueidentifier FINANCIALTRANSACTIONLINEITEM.ID Gives the reversed line item that this reversal line itme points to.
 SOURCELINEITEMID uniqueidentifier FINANCIALTRANSACTIONLINEITEM.ID Gives the line item this application is from, for instance a payment or credit.
 TARGETLINEITEMID uniqueidentifier FINANCIALTRANSACTIONLINEITEM.ID Gives the line item this application is applied to, for instance a charge.
 FINANCIALTRANSACTIONLINEITEMADJUSTMENTID uniqueidentifier FINANCIALTRANSACTIONLINEITEMADJUSTMENT.ID
 BATCHID uniqueidentifier BATCH.ID

Index Name Field(s) Unique Primary Clustered
 IX_FINANCIALTRANSACTIONLINEITEM_DATEADDED DATEADDED      
 IX_FINANCIALTRANSACTIONLINEITEM_DATECHANGED DATECHANGED      
 IX_FINANCIALTRANSACTIONLINEITEM_DATECHANGED_DELETEDON_TYPECODE DATECHANGED, DELETEDON, TYPECODE      
 IX_FINANCIALTRANSACTIONLINEITEM_DELETEDON_TYPECODE DELETEDON, TYPECODE      
 IX_FINANCIALTRANSACTIONLINEITEM_FINANCIALTRANSACTIONID FINANCIALTRANSACTIONID      
 IX_FINANCIALTRANSACTIONLINEITEM_FINANCIALTRANSACTIONID_TYPECODE FINANCIALTRANSACTIONID, TYPECODE    
 IX_FINANCIALTRANSACTIONLINEITEM_ID ID      
 IX_FINANCIALTRANSACTIONLINEITEM_POSTDATE POSTDATE      
 IX_FINANCIALTRANSACTIONLINEITEM_REVERSEDLINEITEMID REVERSEDLINEITEMID      
 IX_FINANCIALTRANSACTIONLINEITEM_SOURCELINEITEMID SOURCELINEITEMID      
 IX_FINANCIALTRANSACTIONLINEITEM_TARGETLINEITEMID TARGETLINEITEMID      
 IX_FINANCIALTRANSACTIONLINEITEM_TYPECODE_POSTSTATUSCODE_POSTDATE_DELETEDON TYPECODE, POSTSTATUSCODE, POSTDATE, DELETEDON      
 PK_FINANCIALTRANSACTIONLINEITEM ID  

Trigger Name Description
 TR_FINANCIALTRANSACTIONLINEITEM_AUDIT_ETLDELETEDID
 TR_FINANCIALTRANSACTIONLINEITEM_AUDIT_UPDATE
 TR_FINANCIALTRANSACTIONLINEITEM_AUDIT_DELETE
 TR_FINANCIALTRANSACTIONLINEITEM_REVENUESPLIT_I
 TR_FINANCIALTRANSACTIONLINEITEM_IUD

Referenced by Field
 AUCTIONITEMPURCHASE PURCHASEID
 CHARGELINEITEM ID
 CHARGELINEITEMRESPONSIBILITY FINANCIALTRANSACTIONLINEITEMID
 CREDITITEM_EXT ID
 CREDITITEMEVENTREGISTRATION ID
 CREDITITEMITEMDISCOUNT CREDITITEMID
 CREDITITEMMEMBERSHIP ID
 CREDITITEMMEMBERSHIPITEMPROMOTION CREDITITEMID
 CREDITPAYMENT REVENUESPLITID
 DONORCHALLENGEENCUMBERED REVENUESPLITID
 EVENTREGISTRANTPAYMENT PAYMENTID
 FAFGIFTACKNOWLEDGEMENT REVENUESPLITID
 INSTALLMENTSPLITPAYMENT PAYMENTID
 JOURNALENTRY FINANCIALTRANSACTIONLINEITEMID
 JOURNALENTRY_EXT CREDITITEMID
 JOURNALENTRY_EXT DISCOUNTCREDITITEMID
 MEMBERSHIPADDON REVENUESPLITID
 MEMBERSHIPCONTRIBUTIONPORTION FINANCIALTRANSACTIONLINEITEMID
 MEMBERSHIPPROGRAMCONTRIBUTIONREVENUE FINANCIALTRANSACTIONLINEITEMID
 MEMBERSHIPTRANSACTION REVENUESPLITID
 NAMINGOPPORTUNITYRECOGNITIONREVENUESPLIT REVENUESPLITID
 ORDERPAYMENTSPLIT PAYMENTID
 PLANNEDGIFTREVENUESPLIT REVENUESPLITID
 R68DETAIL REVENUESPLITID
 R68REFUNDDETAIL REVENUESPLITID
 RECEIVABLECREDITLINEITEM ID
 RECURRINGGIFTACTIVITY PAYMENTREVENUEID
 REVENUEBENEFIT_EXT ID
 REVENUEBENEFIT_EXT REVENUESPLITID
 REVENUECATEGORY ID
 REVENUEOPPORTUNITY ID
 REVENUERECOGNITION REVENUESPLITID
 REVENUESOLICITOR REVENUESPLITID
 REVENUESPLIT_EXT ID
 REVENUESPLITBUSINESSUNIT REVENUESPLITID
 REVENUESPLITCAMPAIGN REVENUESPLITID
 REVENUESPLITGIFTAID ID
 REVENUESPLITGIFTAIDREFUND REVENUESPLITID
 REVENUESPLITGIFTFEE ID
 REVENUESPLITORDER ID
 REVENUESPLITOTHER ID
 SALESORDERITEMDONATION REVENUESPLITID
 SPONSORSHIP REVENUESPLITID
 SPONSORSHIPPAYMENT ID

Entity-Relationship diagram of this table (AUCTIONITEMPURCHASE-JOURNALENTRY_EXT)
Entity-Relationship diagram of this table (MEMBERSHIPADDON-REVENUESPLIT_EXT)
Entity-Relationship diagram of this table (REVENUESPLITBUSINESSUNIT-SPONSORSHIPPAYMENT)