Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EQUIPMENTLENDINGTRANSACTION_ID | int | 4 | null |
|
|
Unique ID of the table |
||
| EQUIPMENT_ID | int | 4 | √ | null |
|
|
Facility ID of the equipment |
|
| TRANSACTION_TYPE | smallint | 2 | √ | 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 |
|
| 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 |
|
| 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 |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the user who created the transaction |
|
| DESCRIPTION | varchar | 2000 | √ | null |
|
|
Description of the loan/return |
|
| ROOT_ID | int | 4 | √ | null |
|
|
Root EQUIPMENTLENDINGTRANSACTION_ID. Populated when equipment is returned. |
|
| ROW_VERSION | binary | 8 | √ | null |
|
|
System TIME_STAMP (for internal use) |
|
| ORG_ID | int | 4 | null |
|
|
|||
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
|||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| EQUIPMENTLENDINGTRANSACTIONS_EQUIPMENTLENDINGTRANSACTION_ID_ORG_ID_PK | Primary key | Asc/Asc | EQUIPMENTLENDINGTRANSACTION_ID + ORG_ID |