| BorrowID |
int(11) |
|
PRI |
|
|
|
|
|
| TimestampCreated |
datetime |
|
|
|
|
Created |
|
The timestamp the record was created. |
| TimestampModified |
datetime |
|
|
|
|
Last edited |
|
The timestamp the record was last modified. |
| Version |
int(11) |
|
|
|
|
Version |
|
version |
| CollectionMemberID |
int(11) |
|
MUL |
|
|
Collection Member Id |
|
collectionMemberId |
| CurrentDueDate |
date |
|
|
|
|
Current due date |
|
The date that borrowed material is due to be returned |
| DateClosed |
date |
|
|
|
|
Date closed |
|
The date the borrowed material was returned |
| InvoiceNumber |
varchar(50) |
|
MUL |
|
|
Invoice number |
|
The lending institution's loan number |
| IsClosed |
bit(1) |
|
|
|
|
Is closed |
|
Indicates whether the incoming loan has been returned |
| IsFinancialResponsibility |
bit(1) |
|
|
|
|
Is Financial Responsibility |
|
isFinancialResponsibility |
| Number1 |
float(20,10) |
|
|
|
|
MEL loan number |
|
The number assigned to a non-MEL loan at MEL |
| Number2 |
float(20,10) |
|
|
|
|
Number2 |
|
User definable. |
| OriginalDueDate |
date |
|
|
|
|
Original due date |
|
The date the borrowed material was originally due to be returned |
| ReceivedDate |
date |
|
MUL |
|
|
Received date |
|
The date the borrowed material was received at MEL |
| Text1 |
text |
|
|
|
|
Text1 |
|
User definable. |
| Text2 |
text |
|
|
|
|
Text2 |
|
User definable. |
| YesNo1 |
bit(1) |
|
|
|
|
Extension Granted |
|
User definable. |
| YesNo2 |
bit(1) |
|
|
|
|
Yes No2 |
|
User definable. |
| ModifiedByAgentID |
int(11) |
|
MUL |
|
|
|
|
|
| AddressOfRecordID |
int(11) |
|
MUL |
|
|
|
|
|
| CreatedByAgentID |
int(11) |
|
MUL |
|
|
|
|
|
| BorrowDate |
date |
|
|
|
|
Borrow Date |
|
borrowDate |
| BorrowDatePrecision |
tinyint(4) |
|
|
|
|
Borrow Date Precision |
|
borrowDatePrecision |
| NumberOfItemsBorrowed |
int(11) |
|
|
|
|
Number Of Items Borrowed |
|
numberOfItemsBorrowed |