Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 AMOUNT money   Default = 0 The installment amount for the commitment.
 FREQUENCYCODE tinyint   Default = 0 0=Annually, 1=Semi-annually, 2=Quarterly, 3=Monthly, 4=Irregular, 5=Single Installment, 6=Bimonthly, 7=Semi-Monthly, 8=Biweekly, 9=Weekly
 FREQUENCY nvarchar(18) (Computed) CASE [FREQUENCYCODE] WHEN 0 THEN N'Annually' WHEN 1 THEN N'Semi-annually' WHEN 2 THEN N'Quarterly' WHEN 3 THEN N'Monthly' WHEN 4 THEN N'Irregular' WHEN 5 THEN N'Single Installment' WHEN 6 THEN N'Bimonthly' WHEN 7 THEN N'Semi-Monthly' WHEN 8 THEN N'Biweekly' WHEN 9 THEN N'Weekly' END Provides a translation for the 'FREQUENCYCODE' field.
 SCHEDULESTARTDATE date  
 AUTOPAY bit   Default = 0
 PAYMENTMETHODCODE tinyint   Default = 2 2=Credit card, 3=Direct debit
 PAYMENTMETHOD nvarchar(12) (Computed) CASE [PAYMENTMETHODCODE] WHEN 2 THEN N'Credit card' WHEN 3 THEN N'Direct debit' END Provides a translation for the 'PAYMENTMETHODCODE' field.
 CARDHOLDERNAME nvarchar(255)   Default = '' The name on the credit card.
 CREDITCARDPARTIALNUMBER nvarchar(4)   Default = '' Stores the last four digits of a credit card number
 EXPIRESON UDT_FUZZYDATE   Default = '00000000' The expiration date of the credit card.
 CREDITCARDTOKEN uniqueidentifier The token used to identify the card on the BBPS service.
 REFERENCEDATE UDT_FUZZYDATE   Default = '00000000' The date that the reference was made.
 REFERENCENUMBER nvarchar(20)   Default = ''
 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.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   SALESORDERITEM.ID Primary Key.
 CREDITTYPECODEID uniqueidentifier CREDITTYPECODE.ID The type of credit card used when making a credit card payment.
 CONSTITUENTACCOUNTID uniqueidentifier CONSTITUENTACCOUNT.ID FK to CONSTITUENTACCOUNT
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_SALESORDERITEMREVENUESCHEDULE_DATEADDED DATEADDED    
 IX_SALESORDERITEMREVENUESCHEDULE_DATECHANGED DATECHANGED      
 PK_SALESORDERITEMREVENUESCHEDULE ID  

Trigger Name Description
 TR_SALESORDERITEMREVENUESCHEDULE_AUDIT_UPDATE
 TR_SALESORDERITEMREVENUESCHEDULE_AUDIT_DELETE

Entity-Relationship diagram of this table