Stores information about memberships records added during the revenue batch process.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
MEMBERSHIPID
|
uniqueidentifier
|
true
|
|
Indicates the membership to which a payment is being applied.
|
|
NUMBEROFCHILDREN
|
smallint
|
false
|
|
The number of children allowed on this membership.
|
|
COMMENTS
|
nvarchar(1000)
|
false
|
|
Remarks about this membership.
|
|
ISGIFT
|
bit
|
false
|
|
Denotes that this membership is a gift.
|
|
SENDRENEWALCODE
|
tinyint
|
false
|
|
Specifies who to send renewals if this membership is a gift.
|
|
SENDRENEWAL
|
nvarchar(24) (Computed)
|
true
|
|
Provides a translation for the 'SENDRENEWALCODE' field.
|
|
GIVENBYID
|
uniqueidentifier
|
true
|
|
The constituent that is responsible for giving the membership as a gift.
|
|
JOINDATE
|
datetime
|
true
|
|
The join date of this membership.
|
|
EXPIRATIONDATE
|
datetime
|
true
|
|
The expiration date of this membership.
|
|
LASTRENEWEDON
|
datetime
|
true
|
|
The date this membership was last renewed.
|
|
STATUSCODE
|
tinyint
|
false
|
|
The status of the membership: 0 - Active, 2 - Pending
|
|
STATUS
|
nvarchar(7) (Computed)
|
true
|
|
Provides a translation for the 'STATUSCODE' field.
|
|
MEMBERS
|
xml
|
true
|
|
XML collection of members for this membership.
|
|
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.
|
