Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|
| LOG_RECORD_ID | int | 4 | null |
|
|
Log record ID |
||
| DATESTAMP | datetime | 16,3 | √ | null |
|
|
||
| SERVICE_TYPE_ID | int | 4 | √ | null |
|
|
Service type from ClientApiLog (0=unknown, 1=ski lift ticket printer) |
|
| REQUEST_TYPE_ID | int | 4 | √ | null |
|
|
Request type ID from the ANET service integration implementation (0=unknown,1=print,2=reprint,3=print all) |
|
| REQUEST_DESCRIPTION | nvarchar | 2000 | √ | null |
|
|
Optional request description string |
|
| REQUEST_START_DATESTAMP | datetime | 16,3 | √ | null |
|
|
Datestamp when request to the client was sent |
|
| REQUEST_END_DATESTAMP | datetime | 16,3 | √ | null |
|
|
Datestamp when request response was received |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
Id of staff user that initiated the request |
|
| OVERRIDE_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
Id of staff user that provided override credentials if logged on user did not have permission |
|
| WORKSTATION_ID | int | 4 | √ | null |
|
|
Id of the ANET workstation where staff user was logged on |
|
| TRANSACTION_ID | int | 4 | √ | null |
|
|
Id of the transaction (for example, ski lift ticket sale transaction ID) |
|
| CLIENT_API_URL | nvarchar | 500 | √ | null |
|
|
Client API URL where the request was sent |
|
| REQUEST_STR | nvarchar | 8000 | √ | null |
|
|
Request sent to the client API URL (as string) |
|
| RESPONSE_STR | nvarchar | 8000 | √ | null |
|
|
Response received from the client API URL (as string) |
|
| IS_ERROR | smallint | 2 | √ | null |
|
|
Did the request get an error or exception |
|
| ERRORMSG | nvarchar | 8000 | √ | null |
|
|
Error or exception message (if any) |
|
| ERRORCODE | nvarchar | 80 | √ | null |
|
|
Error code returned from the API (if any) |
|
| REASON_ID | int | 4 | √ | null |
|
|
Id of record in the Anet REASONS table (if applicable) |
|
| REASON_TEXT | nvarchar | 8000 | √ | null |
|
|
Reason text provided by the staff user |
|
| QUANTITY | int | 4 | √ | null |
|
|
Override quantity for API call if less than transaction quantity |
|
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
||
| 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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| EXTERNAL_CLIENT_API_REQUEST_LOG_LOG_RECORD_ID_ORG_ID_PK | Primary key | Asc/Asc | LOG_RECORD_ID + ORG_ID |