| SEQUENCE |
int |
|
Default = 0 |
Row sequence field. |
| ORIGINALREVENUEID |
uniqueidentifier |
yes |
|
The revenue or revenue batch row corresponding the original direct debit transaction |
| INDIVIDUALIDENTIFICATIONNUMBER |
nvarchar(15) |
|
Default = '' |
The individual identification number of the entry detail record, which is the constituent lookup ID with all dashes removed. |
| INDIVIDUALNAME |
nvarchar(22) |
|
Default = '' |
The individual name of the entry detail record, which is the constituent key name followed by the first character of the first name. |
| ROUTINGNUMBER |
nvarchar(9) |
|
Default = '' |
The routing number of the authorizing institution that approves and authorizes all banking account transactions. |
| ACCOUNTNUMBER |
nvarchar(4000) |
|
Default = '' |
This constituent's account number at this institution |
| ACCOUNTNUMBERINDEX |
nvarchar(24) |
yes |
|
|
| AMOUNT |
money |
|
Default = 0 |
The amount of the original direct debit transaction |
| DIRECTDEBITRESULTCODE |
nvarchar(10) |
|
Default = '' |
The result code from a direct debit return file. |
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| ISREJECTED |
bit |
|
Default = 0 |
Indicates that the result code corresponds to a rejected transaction. |
| ENDTOENDID |
nvarchar(36) |
|
Default = '' |
|