This table holds the terms for a specific membership level.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
TERMCODE
|
tinyint
|
false
|
|
The term for this membership level.
|
|
AMOUNT
|
money
|
false
|
|
The cost for the specific membership level term.
|
|
SEQUENCE
|
int
|
false
|
|
The sequence of terms for the level.
|
|
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.
|
|
TERM
|
nvarchar(8) (Computed)
|
true
|
|
Provides a translation for the 'TERMCODE' field.
|
|
ORGANIZATIONAMOUNT
|
money
|
false
|
|
Amount in organization currency.
|
|
TERMTIMELENGTH
|
smallint
|
false
|
|
|
|
TERMLENGTHCODE
|
tinyint
|
false
|
|
|
|
TERMLENGTH
|
nvarchar(8) (Computed)
|
true
|
|
|
|
LOWAMOUNT
|
money
|
false
|
|
|
|
ORGANIZATIONLOWAMOUNT
|
money
|
false
|
|
|
|
RECURRINGPAYMENTOPTIONCODE
|
tinyint
|
false
|
|
|
|
RECURRINGPAYMENTOPTION
|
nvarchar(13) (Computed)
|
true
|
|
|
|
LIFETIMEPAYMENTOPTIONCODE
|
tinyint
|
false
|
|
|
|
LIFETIMEPAYMENTOPTION
|
nvarchar(11) (Computed)
|
true
|
|
|
|
LIFETIMENUMBEROFPAYMENTS
|
smallint
|
false
|
|
|
|
ISACTIVE
|
bit
|
false
|
|
|
