Communication Device for ITS
Field Name |
Caption |
Mask |
Description |
Field Type |
DE_CO_ID |
Comm Rec # |
nnnnnnnn |
Long Integer |
|
DE_COMMENT1 |
Long Note |
|
Long Note |
Memo |
DE_CRT_BY |
Created By |
25x |
Created By |
String |
DE_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
DE_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
DE_EMAC |
Ethernet MAC |
50x |
Ethernet MAC |
String |
DE_END_DT |
End Date |
mm/dd/yyyy hh:mm am |
End Date |
DateTime |
DE_ESN |
ESN/IMEI/MEID |
20x |
ESN/IMEI/MEID |
String |
DE_ID |
Communication Device Record Number |
nnnnnnnn |
Communication Device Record Number |
Long Integer |
DE_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
DE_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
DE_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
DE_NOTES |
Notes or Short Comment |
255x |
Notes or Short Comment |
String |
DE_NUMBER |
Comm Device ID |
50x |
Comm Device ID |
String |
DE_ROWVER |
|
|
Rowversion for optimistic locking |
TimeStamp |
DE_SERIAL |
Serial Number |
50x |
Serial Number |
String |
DE_SIM |
SIM |
19x |
SIM |
String |
DE_STAT_CD |
Status |
nnn |
Status |
Integer |
DE_STAT_TY |
Status Text |
25x |
Status Text |
String |
DE_STRT_DT |
Start Date |
mm/dd/yyyy hh:mm am |
Start Date |
DateTime |
DE_SUSBMAC |
USB MAC |
50x |
USB MAC |
String |
DE_TYPE_CD |
Device Type |
nnn |
Device Type |
Integer |
DE_TYPE_TY |
Device Type Text |
50x |
Device Type Text |
String |
DE_USER10 |
User 10 |
mm/dd/yyyy hh:mm am |
User 10 |
DateTime |
DE_USER11 |
User 11 |
mm/dd/yyyy hh:mm am |
User 11 |
DateTime |
DE_USER12 |
User 12 |
mm/dd/yyyy hh:mm am |
User 12 |
DateTime |
DE_USER13 |
User 13 |
|
User 13 |
Boolean |
DE_USER14 |
User 14 |
|
User 14 |
Boolean |
DE_USER15 |
User 15 |
|
User 15 |
Boolean |
DE_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
DE_USER1TY |
User 1 Text |
25x |
User 1 Text |
String |
DE_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
DE_USER2TY |
User 2 Text |
25x |
User 2 Text |
String |
DE_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
DE_USER3TY |
User 3 Text |
25x |
User 3 Text |
String |
DE_USER4 |
User 4 |
50x |
User 4 |
String |
DE_USER5 |
User 5 |
50x |
User 5 |
String |
DE_USER6 |
User 6 |
50x |
User 6 |
String |
DE_USER7 |
User 7 |
nnnnnnnn.nn |
User 7 |
Double |
DE_USER8 |
User 8 |
nnnnnnnn.nn |
User 8 |
Double |
DE_USER9 |
User 9 |
nnnnnnnn.nn |
User 9 |
Double |
DE_VEND_CD |
Vendor |
nnn |
Vendor |
Integer |
DE_VEND_TY |
Vendor Text |
50x |
Vendor Text |
String |