Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| LOCKER_SCHEDULE_ID | int | 4 | null |
|
|
The locker schedule ID |
|||||
| LOCKER_ID | int | 4 | √ | null |
|
|
The ID of the reserved locker |
||||
| LOCKER_NAME | varchar | 150 | √ | null |
|
|
The name of the reserved locker |
||||
| LOCKER_NUMBER | int | 4 | √ | null |
|
|
The number of the reserved locker |
||||
| LOCKER_ROOM_ID | int | 4 | √ | null |
|
|
The ID of the locker room containing the reserved locker |
||||
| LOCKER_ROOM_NAME | varchar | 150 | √ | null |
|
|
The name of the locker room containing the reserved locker |
||||
| LOCKER_BANK_ID | int | 4 | √ | null |
|
|
The ID of the locker bank containing the reserved locker |
||||
| LOCKER_BANK_NAME | varchar | 150 | √ | null |
|
|
The name of the locker bank containing the reserved locker |
||||
| START_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The start date and time of the locker reservation |
||||
| START_DATE_ONLY | date | 20 | √ | null |
|
|
The start date of the locker reservation (date only) |
||||
| END_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The end date and time of the locker reservation |
||||
| END_DATE_ONLY | date | 20 | √ | null |
|
|
The end date of the locker reservation (date only) |
||||
| LOCKER_SIZE_ID | int | 4 | √ | null |
|
|
The ID of the locker size of the reserved locker |
||||
| LOCKER_SIZE_NAME | varchar | 50 | √ | null |
|
|
The name of the locker size of the reserved locker |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
The transaction ID for the locker reservation |
||||
| RECEIPT_NUMBER | nvarchar | 8000 | √ | null |
|
|
The receipt number that the transaction belongs to |
||||
| CREATION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the transaction was created |
||||
| CREATION_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the transaction was created (date only) |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer who is the participant of the transaction |
||||
| CUSTOMER_NAME | varchar | 511 | null |
|
|
The name of the customer who is the participant of the transaction |
|||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company who is the owner of the transaction if applicable |
||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
The name of the company who is the owner of the transaction if applicable |
||||
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site where the locker reservation was created |
||||
| SITE_NAME | varchar | 255 | √ | null |
|
|
The name of the site where the locker reservation was created |
||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation where the locker reservation was created |
||||
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
The name of the workstation where the locker reservation was created |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who created the locker reservation |
||||
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
The name of the system user who created the locker reservation |
|||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
Date and time Hub record was last modified |
|||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
|||||
| source_id | int | 4 | null |
|
|
The ID value from the Active Net system |