Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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.
 DIRECTDEBITRESULTCODE nvarchar(10)   Default = '' The result code from a direct debit return file.
 DDISOURCEDATE date UK only paperless mandates DDI source date.
 SENDPMINSTRUCTION bit   Default = 0 UK only Indicates that a paperless mandate instruction should be sent for this record.
 PMINSTRUCTIONTOSENDCODE tinyint   Default = 0 UK only indicates the paperless mandate instruction that should be sent for this record.
 PMINSTRUCTIONTOSEND nvarchar(6) (Computed) CASE [PMINSTRUCTIONTOSENDCODE] WHEN 0 THEN N'' WHEN 1 THEN N'New' WHEN 2 THEN N'Cancel' WHEN 3 THEN N'Set-up' END Provides a translation for the 'PMINSTRUCTIONTOSENDCODE' field.
 PMINSTRUCTIONDATE_NEW date UK only indicates the date that a new paperless mandate instruction was sent for this record.
 PMINSTRUCTIONDATE_CANCEL date UK only indicates the date that a cancel paperless mandate instruction was sent for this record.
 PMINSTRUCTIONDATE_SETUP date UK only indicates the date that a set-up paperless mandate instruction was sent for this record.
 PMADVANCENOTICESENTDATE date UK only indicates the date that a paperless mandate advance notice was sent to the constituent for this record.

Foreign Key Field Type Null Notes Description
 ID uniqueidentifier   REVENUESCHEDULE.ID Primary Key.
 CONSTITUENTACCOUNTID uniqueidentifier CONSTITUENTACCOUNT.ID FK to CONSTITUENTACCOUNT
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 DDISOURCECODEID uniqueidentifier DDISOURCECODE.ID UK only paperless mandates DDI source.

Index Name Field(s) Unique Primary Clustered
 IX_REVENUESCHEDULEDIRECTDEBITPAYMENT_DATEADDED DATEADDED    
 IX_REVENUESCHEDULEDIRECTDEBITPAYMENT_DATECHANGED DATECHANGED      
 PK_REVENUESCHEDULEDIRECTDEBITPAYMENT ID  

Trigger Name Description
 TR_REVENUESCHEDULEDIRECTDEBITPAYMENT_AUDIT_UPDATE
 TR_REVENUESCHEDULEDIRECTDEBITPAYMENT_AUDIT_DELETE

Entity-Relationship diagram of this table