BATCHREVENUECONSTITUENTACCOUNT (4.0SP17)

ID

uniqueidentifier

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

BATCHID

uniqueidentifier

true

CONSTITUENTID

uniqueidentifier

false

The constituent to which this account belongs.

FINANCIALINSTITUTIONID

uniqueidentifier

false

The financial institution to which this account applies.

ACCOUNTNUMBER

nvarchar(4000)

false

This constituent's account number at this institution

ACCOUNTTYPECODE

tinyint

false

The type of this constituent's account at this institution.

EFTSTATUSCODE

tinyint

false

Indicates the EFT status of this account.

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.

ACCOUNTNUMBERINDEX

nvarchar(24)

true

ACCOUNTNAME

nvarchar(100)

false

The actual name on the account per the bank records.

ACCOUNTTYPE

nvarchar(8) (Computed)

true

Provides a translation for the 'ACCOUNTTYPECODE' field.

EFTSTATUS

nvarchar(10) (Computed)

true

Provides a translation for the 'EFTSTATUSCODE' field.

DESCRIPTION

nvarchar(254) (Computed)

true

Provides a tranlsation for this account.

IX_BATCHREVENUECONSTITUENTACCOUNT_ACCOUNTNUMBERINDEX

False

False

False

IX_BATCHREVENUECONSTITUENTACCOUNT_CONSTITUENTID

False

False

False

IX_BATCHREVENUECONSTITUENTACCOUNT_DATEADDED

False

False

True

IX_BATCHREVENUECONSTITUENTACCOUNT_DATECHANGED

False

False

False

PK_BATCHREVENUECONSTITUENTACCOUNT

True

True

False

TR_BATCHREVENUECONSTITUENTACCOUNT_AUDIT_UPDATE

TR_BATCHREVENUECONSTITUENTACCOUNT_AUDIT_DELETE

SEPAMANDATE

BATCHREVENUECONSTITUENTACCOUNTID