Stores designation level financial batch information.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
STARTDATE
|
datetime
|
false
|
|
The first date in this financial information period.
|
|
ENDDATE
|
datetime
|
false
|
|
The final date in this financial information period.
|
|
BOOKVALUESTART
|
money
|
false
|
|
The book value of this purpose at the start of the period specified.
|
|
BOOKVALUEEND
|
money
|
false
|
|
The book value of this purpose at the end of the period specified.
|
|
MARKETVALUESTART
|
money
|
false
|
|
The market value of this purpose at the start of the period specified.
|
|
MARKETVALUEEND
|
money
|
false
|
|
The market value of this purpose at the end of the period specified.
|
|
TOTALGIFTREVENUE
|
money
|
false
|
|
The total amount of gifts given to this purpose.
|
|
PLEDGEBALANCE
|
money
|
false
|
|
The total amount of outstanding pledge gifts given to this purpose.
|
|
SEQUENCE
|
int
|
false
|
|
Indicates the sequence of this record in the batch.
|
|
CUSTOMIDENTIFIER
|
nvarchar(100)
|
false
|
|
User-definable custom identifier.
|
|
SEQUENCEID
|
int
|
false
|
|
Identity column used to increment the default lookupid.
|
|
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.
|
|
TOTALDISBURSEMENTS
|
money
|
false
|
|
The total amount of disbursements for this purpose.
|
|
LOOKUPID
|
nvarchar(100) (Computed)
|
true
|
|
Unique identifer that supports user defined values as well as system generated values.
|
