Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEQUENCE int   Default = 0
 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.
 MINIMUMENTRYAMOUNT decimal(20, 4)   Default = 0 The lowest base currency value needed to qualify for this row in the ask ladder.
 TYPECODE tinyint   Default = 0 The type of the ask ladder.
 ITEMVALUE1 decimal(20, 4)   Default = -1 The base currency value to be used for the first ask ladder item.
 ITEMVALUE2 decimal(20, 4)   Default = -1 The base currency value to be used for the second ask ladder item.
 ITEMVALUE3 decimal(20, 4)   Default = -1 The base currency value to be used for the third ask ladder item.
 ITEMVALUE4 decimal(20, 4)   Default = -1 The base currency value to be used for the fourth ask ladder item.
 ITEMVALUE5 decimal(20, 4)   Default = -1 The base currency value to be used for the fifth ask ladder item.
 WRITEINTEXT nvarchar(100)   Default = 'Other' The text used to indicate to the donor that he can specify an amount other than what is listed in the ask ladder.
 ROUNDTOAMOUNT money   Default = -1 The interval used to round off computed ask amounts.
 ORGANIZATIONMINIMUMENTRYAMOUNT decimal(20, 4)   Default = 0 The lowest organization currency value needed to qualify for this row in the ask ladder.
 ORGANIZATIONITEMVALUE1 decimal(20, 4)   Default = -1 The organizational currency value to be used for the first ask ladder item.
 ORGANIZATIONITEMVALUE2 decimal(20, 4)   Default = -1 The organization currency value to be used for the second ask ladder item.
 ORGANIZATIONITEMVALUE3 decimal(20, 4)   Default = -1 The organization currency value to be used for the third ask ladder item.
 ORGANIZATIONITEMVALUE4 decimal(20, 4)   Default = -1 The organization currency value to be used for the fourth ask ladder item.
 ORGANIZATIONITEMVALUE5 decimal(20, 4)   Default = -1 The organization currency value to be used for the fifth ask ladder item.
 NEXTMINIMUMENTRYAMOUNT decimal(20, 4) (Computed) dbo.[UFN_MKTASKLADDER_NEXTMINIMUMENTRYAMOUNT]([ASKLADDERID], [MINIMUMENTRYAMOUNT]) The minimum base currency entry amount for the next item in the ask ladder.
 ORGANIZATIONNEXTMINIMUMENTRYAMOUNT decimal(20, 4) (Computed) dbo.[UFN_MKTASKLADDER_ORGANIZATIONNEXTMINIMUMENTRYAMOUNT]([ASKLADDERID], [ORGANIZATIONMINIMUMENTRYAMOUNT]) The minimum organization currency entry amount for the next item in the ask ladder.
 TYPE nvarchar(8) (Computed) CASE [TYPECODE] WHEN 0 THEN N'Add' WHEN 1 THEN N'Multiply' WHEN 2 THEN N'Fixed' END

Foreign Key Field Type Null Notes Description
 ASKLADDERID uniqueidentifier MKTASKLADDER.ID The ask ladder to which this value information belongs.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency for this ask ladder item.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert the item amounts into their organizational currency equivalents.

Index Name Field(s) Unique Primary Clustered
 IX_MKTASKLADDERITEM_ASKLADDERID_SEQUENCE ASKLADDERID, SEQUENCE      
 IX_MKTASKLADDERITEM_BASECURRENCYID BASECURRENCYID      
 IX_MKTASKLADDERITEM_DATEADDED DATEADDED    
 IX_MKTASKLADDERITEM_DATECHANGED DATECHANGED      
 IX_MKTASKLADDERITEM_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 PK_MKTASKLADDERITEM ID  

Trigger Name Description
 TR_MKTASKLADDERITEM_AUDIT_UPDATE
 TR_MKTASKLADDERITEM_AUDIT_DELETE
 TR_MKTASKLADDERITEM_INSERTUPDATE_CURRENCY

Entity-Relationship diagram of this table