Stores direct debit detail information for a pledge or recurring gift record when the payment method is direct debit.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
REFERENCEDATE
|
UDT_FUZZYDATE
|
false
|
|
The date that the reference was made.
|
|
REFERENCENUMBER
|
nvarchar(20)
|
false
|
|
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
DIRECTDEBITRESULTCODE
|
nvarchar(10)
|
false
|
|
The result code from a direct debit return file.
|
|
DDISOURCEDATE
|
date
|
true
|
|
UK only paperless mandates DDI source date.
|
|
SENDPMINSTRUCTION
|
bit
|
false
|
|
UK only Indicates that a paperless mandate instruction should be sent for this record.
|
|
PMINSTRUCTIONTOSENDCODE
|
tinyint
|
false
|
|
UK only indicates the paperless mandate instruction that should be sent for this record.
|
|
PMINSTRUCTIONTOSEND
|
nvarchar(6) (Computed)
|
true
|
|
Provides a translation for the 'PMINSTRUCTIONTOSENDCODE' field.
|
|
PMINSTRUCTIONDATE_NEW
|
date
|
true
|
|
UK only indicates the date that a new paperless mandate instruction was sent for this record.
|
|
PMINSTRUCTIONDATE_CANCEL
|
date
|
true
|
|
UK only indicates the date that a cancel paperless mandate instruction was sent for this record.
|
|
PMINSTRUCTIONDATE_SETUP
|
date
|
true
|
|
UK only indicates the date that a set-up paperless mandate instruction was sent for this record.
|
|
PMADVANCENOTICESENTDATE
|
date
|
true
|
|
UK only indicates the date that a paperless mandate advance notice was sent to the constituent for this record.
|
