Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 PROJECT nvarchar(100)   Default = '' Project field
 REFERENCE nvarchar(255)   Default = '' Reference field
 AMOUNT money   Default = 0 Amount
 ACCOUNT nvarchar(100)   Default = '' Account
 TRANSACTIONTYPECODE tinyint   Default = 0 The transaction type (debit or credit) for the record
 TRANSACTIONTYPE nvarchar(6) (Computed) CASE [TRANSACTIONTYPECODE] WHEN 0 THEN N'Debit' WHEN 1 THEN N'Credit' END Provides a translation for the 'TRANSACTIONTYPECODE' field.
 OUTDATED bit   Default = 0 Specifies whether or not this distribution is outdated.
 REVENUEID uniqueidentifier Logical foreign key to REVENUE table.
 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.
 FULLYPAIDSTATUS tinyint   Default = 0 Identifies Fully Paid benefit (0- none, 1-Fully Paid, 2-Fully Paid Backout).
 ORGANIZATIONAMOUNT money   Default = 0 The amount of the benefit GL distribution in organization currency.
 TRANSACTIONAMOUNT money   Default = 0 The amount of the benefit GL distribution in transaction currency.
 BENEFITTYPECODE tinyint   Default = 1 The transaction type (debit or credit) for the record
 BENEFITTYPE nvarchar(9) (Computed) CASE [BENEFITTYPECODE] WHEN 1 THEN N'Expense' WHEN 2 THEN N'Liability' WHEN 3 THEN N'Backout' END Provides a translation for the 'BENEFITTYPECODE' field.

Foreign Key Field Type Null Notes Description
 REVENUEBENEFITID uniqueidentifier REVENUEBENEFIT.ID ForeignKey to REVENUEBENEFIT table
 GLPAYMENTMETHODREVENUETYPEMAPPINGID uniqueidentifier   GLPAYMENTMETHODREVENUETYPEMAPPING.ID Foreign key to GLPaymentMethodRevenueTypeMapping table
 GLTRANSACTIONID uniqueidentifier GLTRANSACTION.ID Foreign key to the GLTRANSACTION table.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this benefit GL distribution.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert to organization amount.
 TRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this benefit GL distribution.
 BASEEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from transaction amount to amount.

Index Name Field(s) Unique Primary Clustered
 IX_BENEFITGLDISTRIBUTION_DATEADDED DATEADDED    
 IX_BENEFITGLDISTRIBUTION_DATECHANGED DATECHANGED      
 IX_BENEFITGLDISTRIBUTION_GLPAYMENTMETHODREVENUETYPEMAPPINGID GLPAYMENTMETHODREVENUETYPEMAPPINGID      
 IX_BENEFITGLDISTRIBUTION_GLTRANSACTIONID GLTRANSACTIONID      
 IX_BENEFITGLDISTRIBUTION_REVENUEBENEFITID REVENUEBENEFITID      
 IX_BENEFITGLDISTRIBUTION_REVENUEID REVENUEID      
 PK_BENEFITGLDISTRIBUTION ID  

Trigger Name Description
 TR_BENEFITGLDISTRIBUTION_INSERTUPDATE_CURRENCY
 TR_BENEFITGLDISTRIBUTION_DELETE_GLTRANSACTION
 TR_BENEFITGLDISTRIBUTION_UPDATE_GLTRANSACTION
 TR_BENEFITGLDISTRIBUTION_AUDIT_UPDATE
 TR_BENEFITGLDISTRIBUTION_AUDIT_DELETE

Entity-Relationship diagram of this table