BATCHREVENUESPLIT (4.0SP17)

ID

uniqueidentifier

BATCHREVENUEID

uniqueidentifier

false

FK to BATCHREVENUE

DESIGNATIONID

uniqueidentifier

false

FK to DESIGNATION

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

REVENUESPLITBUSINESSUNITOVERRIDECODEID

uniqueidentifier

true

Stores the reason for overriding business units on this revenue split record.

AMOUNT

money

false

SEQUENCE

int

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.

TYPECODE

tinyint

false

The type of revenue split.

APPLICATIONCODE

tinyint

false

What the revenue item is applied to.

DECLINESGIFTAID

bit

false

Indicates whether Gift Aid is declined for this split.

ISGIFTAIDSPONSORSHIP

bit

false

Indicates whether this split is a Gift Aid sponsorship.

REVENUESPLITID

uniqueidentifier

true

Split id for revenue update batch.

APPLICATION

nvarchar(18) (Computed)

true

Provides a translation for the 'APPLICATIONCODE' field.

OVERRIDEBUSINESSUNITS

bit

false

Boolean value to tell whether business units attached to the application/payment were overriden

TYPE

nvarchar(27) (Computed)

true

Provides a translation for the 'TYPECODE' field.

IX_BATCHREVENUESPLIT_BATCHREVENUEID

False

False

False

IX_BATCHREVENUESPLIT_DATEADDED

False

False

True

IX_BATCHREVENUESPLIT_DATECHANGED

False

False

False

PK_BATCHREVENUESPLIT

True

True

False

TR_BATCHREVENUESPLIT_AUDIT_UPDATE

TR_BATCHREVENUESPLIT_AUDIT_DELETE

BATCHREVENUESPLITBUSINESSUNIT

BATCHREVENUESPLITID

BATCHREVENUESPLITCAMPAIGN

BATCHREVENUESPLITID