Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EQUIPMENT_LENDING_TRANSACTION_ID | int | 4 | null |
|
|
Unique ID of the table |
||
| FACILITY_ID | int | 4 | √ | null |
|
|
Facility ID of the equipment |
|
| TRANSACTION_TYPE | varchar | 200 | √ | null |
|
|
The transaction type of the transaction |
|
| TRANSACTION_ID | int | 4 | √ | null |
|
|
Transaction ID |
|
| QUANTITY | int | 4 | √ | null |
|
|
Quantity of the equipment checked out |
|
| STATUS_ID | smallint | 2 | √ | null |
|
|
Status ID |
|
| STATUS | varchar | 200 | √ | null |
|
|
STATUS description |
|
| TIME_STAMP | datetime | 16,3 | √ | null |
|
|
Check In/Check Out time of the Equipment |
|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
ID of the customer who loaned the Equipment |
|
| CUSTOMER_NAME | varchar | 511 | null |
|
|
Name of the customer |
||
| SITE_ID | int | 4 | √ | null |
|
|
ID of the site where the transaction was created |
|
| WORKSTATION_ID | int | 4 | √ | null |
|
|
ID of the workstation where the transaction was create |
|
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
Name of the workstation |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the user who created the transaction |
|
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
Name of the user who created the transaction |
||
| DESCRIPTION | varchar | 2000 | √ | null |
|
|
Description of the loan/return |
|
| ROOT_EQUIPMENT_LENDING_TRANSACTION_ID | int | 4 | √ | null |
|
|
Root EQUIPMENTLENDINGTRANSACTION_ID. Populated when equipment is returned. |
|
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |