Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| POS_CONTROL_CODE_ID | int | 4 | null |
|
|
The control code ID |
|||||
| POS_CONTROL_CODE_NAME | varchar | 50 | √ | null |
|
|
The control code name |
||||
| POP_CASH_DRAWER | varchar | 50 | √ | null |
|
|
The control codes to open the cash drawer |
||||
| SMALL_FONT | varchar | 50 | √ | null |
|
|
The control codes to print characters in a small sized font |
||||
| SMALL_FONT_CHARACTERS_PER_LINE | int | 4 | √ | null |
|
|
The number of characters that can be printed per line with the small sized font |
||||
| MEDIUM_FONT | varchar | 50 | √ | null |
|
|
The control codes to print characters in a medium sized font |
||||
| MEDIUM_FONT_CHARACTERS_PER_LINE | int | 4 | √ | null |
|
|
The number of characters that can be printed per line with the medium sized font |
||||
| LARGE_FONT | varchar | 50 | √ | null |
|
|
The control codes to print characters in a large sized font |
||||
| LARGE_FONT_CHARACTERS_PER_LINE | int | 4 | √ | null |
|
|
The number of characters that can be printed per line with the large sized font |
||||
| AUTO_CUT | varchar | 50 | √ | null |
|
|
The control codes to auto cut the paper |
||||
| EJECT_LINE_COUNT | int | 4 | √ | null |
|
|
The number of lines to eject when completing the receipt |
||||
| POLE_DISPLAY_SET_CURSOR_FIRST_LINE | varchar | 50 | √ | null |
|
|
The control codes to set the cursor onto the first line of the pole display |
||||
| POLE_DISPLAY_SET_CURSOR_SECOND_LINE | varchar | 50 | √ | null |
|
|
The control codes to set the cursor onto the second line of the pole display |
||||
| POLE_DISPLAY_CLEAR_DISPLAY | varchar | 50 | √ | null |
|
|
The control codes to clear the pole display |
||||
| POLE_DISPLAY_SCROLL_TEXT_FIRST_LINE | varchar | 50 | √ | null |
|
|
The control codes to scroll the first line of the pole display |
||||
| POLE_DISPLAY_SCROLL_TEXT_SECOND_LINE | varchar | 50 | √ | null |
|
|
The control codes to scroll the second line of the pole display |
||||
| POLE_DISPLAY_DISPLAY_CLOCK | varchar | 50 | √ | null |
|
|
The control codes to display the clock on the pole display |
||||
| POLE_DISPLAY_CHARACTER_BETWEEN_HOURS_AND_MINUTES | varchar | 50 | √ | null |
|
|
The control code for the character to display between the minutes and seconds on the clock on the pole display |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| POS_CONTROL_CODES_POS_CONTROL_CODE_ID_ORG_ID_PK | Primary key | Asc/Asc | POS_CONTROL_CODE_ID + ORG_ID |
| POS_CONTROL_CODES_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |