The absolute address (Internet or other) which can be used for electronic communication with the device. The address should contain communication protocol/type, colon, space, then the actual address. Addresses, which are local to a specific computer, should also include the computer name. For example: "COM: PC_WORK1:COM1", "HTTP: https://", etc.
The name of the protocol, which can be used to communicate with the device. NULL means that the protocol is unknown and programmatic communication with the device would not be performed.
Settings and operator access codes for the POS device. The data is stored as Json, encrypted for the current application server instance. NULL means that there are no settings for this device.
Columns
Device_Registration_No
The unique registration number of the device, assigned by the manufacturer. NULL means the number is unknown or N/A.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
32
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
nvarchar(32) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Device_Registration_No - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
Like
None
no
no
Device_Type
Type of the POS device. PAY=Payment Terminal; CSH=Cash Drawer; FIP=Fiscal Printer; OTH=Other.
Property
Value
Allowed Values
PAY, CSH, FIP, OTH
Auto Complete
no
Data Filter
no
Default Value
OTH
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
3
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
nvarchar(3)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Device_Type - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Electronic_Address
The absolute address (Internet or other) which can be used for electronic communication with the device. The address should contain communication protocol/type, colon, space, then the actual address. Addresses, which are local to a specific computer, should also include the computer name. For example: "COM: PC_WORK1:COM1", "HTTP: https://", etc.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
254
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
nvarchar(254) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Electronic_Address - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
yes
no
Like
None
no
no
Is_Active
Indicates whether the device is currently active and can be choosen from drop-downs in new records.
Property
Value
Auto Complete
no
Data Filter
no
Default Value
True
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
bit
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Is_Active - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Pos_Device_Id
Property
Value
Auto Complete
no
Data Filter
no
Default Value
NewGuid
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
yes (order: 1)
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
yes
Type
uniqueidentifier
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Pos_Device_Id - Supported Filters
Filter Type
Default
Include Nulls
Hidden by Default
Equals
NULL
no
no
Pos_Terminal_Id
The POS terminal, to which this device is attached.
The name of the protocol, which can be used to communicate with the device. NULL means that the protocol is unknown and programmatic communication with the device would not be performed.
Property
Value
Allowed Values
ERPNET_FP
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
32
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
nvarchar(32) (Allows NULL)
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
yes
Row_Version
Property
Value
Auto Complete
no
Data Filter
no
Default Value
None
Enter Stop
yes
Ignore for Insert Order
no
Is Entity Name
no
Max Length
-1
Order
2147483647
Ownership Reference
no
Pasword
no
Picture
no
Primary Key
no
Readonly
no
RTF
no
Sortable
no
Summary Type
None
Supports EQUALS_IN
no
Type
timestamp
UI Memo Editor
no
UI Width
Medium
User Login
no
Visible
no
Settings_Json
Settings and operator access codes for the POS device. The data is stored as Json, encrypted for the current application server instance. NULL means that there are no settings for this device.