Tech Hardware Inventory
Field Name |
Caption |
Mask |
Description |
Field Type |
TH_ABITS_CD |
Architecture (Bits) |
nnn |
Architecture (Bits) |
integer |
TH_ABITS_TY |
Architecture (Bits) Text |
30x |
Architecture (Bits) Text |
String |
TH_AEMP_CD |
Assigned Employee |
20x |
Assigned Employee |
String |
TH_AEMP_TY |
Assigned Employee Text |
40x |
Assigned Employee Text |
String |
TH_ASSETID |
Unique Asset ID |
30x |
Unique Asset ID |
String |
TH_AST_CST |
Asset Cost |
nnnnnnnn.nn |
Asset Cost |
Double |
TH_AZONE_CD |
Alternate Zone |
10x |
Alternate Zone |
String |
TH_AZONE_TY |
Alternate Zone Text |
60x |
Alternate Zone Text |
String |
TH_BL_ID |
Link to Facility Building |
nnnnnnnn |
Long Integer |
|
TH_BR_CD |
Category |
10x |
Category |
String |
TH_BR_ID |
Link to Facility Room |
nnnnnnnn |
Link to Facility Room |
Long Integer |
TH_BR_TY |
Category Text |
60x |
Category Text |
String |
TH_CC_CD |
Cost Center |
10x |
Cost Center |
String |
TH_CC_TY |
Cost Center Text |
30x |
Cost Center Text |
String |
TH_CNAME |
Manufacturer Barcode |
30x |
Manufacturer Barcode |
String |
TH_COF |
Consequence of Failure |
nnnnnnnn.nn |
Consequence of Failure |
Double |
TH_CRT_BY |
Created By |
25x |
Created By |
String |
TH_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
TH_DEPT_CD |
Department Code |
nnn |
Department Code |
integer |
TH_DEPT_TY |
Department Text |
25x |
Department Text |
String |
TH_DOC_FLG |
Doc Available: Doc Flag |
|
Doc Available: Doc Flag |
Boolean |
TH_DRAWNO |
Drawing # |
30x |
Drawing # |
String |
TH_ELEV |
Elevation |
nnnnnnnn.nn |
Elevation |
Double |
TH_FASSET |
Fixed Asset ID |
nnnnnnnn |
Fixed Asset ID |
Long Integer |
TH_GPS_DT |
GPS Date |
mm/dd/yyyy hh:mm am |
GPS Date |
DateTime |
TH_GPS_TM |
GPS Time |
mm/dd/yyyy hh:mm am |
GPS Time |
DateTime |
TH_HOST |
Static IP Address |
30x |
Static IP Address |
String |
TH_ID |
Auto Number |
nnnnnnnn |
Tech Inv AutoID |
Long Integer |
TH_INMAP |
In Map |
|
In Map |
Boolean |
TH_INST_DT |
Installation Date |
mm/dd/yyyy hh:mm am |
Installation Date |
DateTime |
TH_INSTBY |
Installed By |
30x |
Installed By |
String |
TH_INVOICE |
Invoice # |
30x |
Invoice # |
String |
TH_IPADDR |
Host Name |
30x |
Host Name |
String |
TH_LIFEEXP |
Asset Life (Years) |
nnnnnnnn.nn |
Asset Life (Years) |
Double |
TH_LO_CD |
Leased or Owned |
nnn |
Leased or Owned |
integer |
TH_LO_TY |
Leased or Owned Text |
30x |
Leased or Owned Text |
String |
TH_LOCATION |
Location |
75x |
Location |
String |
TH_LWOT_DT |
Last WO Task Date |
mm/dd/yyyy hh:mm am |
Last WO Task Date |
DateTime |
TH_MAC |
MAC Address |
30x |
MAC Address |
String |
TH_MAIN_CD |
Maintained Code |
nnn |
Maintained Code |
integer |
TH_MAIN_TY |
Maintained Text |
25x |
Maintained Text |
String |
TH_MAN_CD |
Manufacturer |
nnn |
Manufacturer |
integer |
TH_MAN_TY |
Manufacturer Text |
25x |
Manufacturer Text |
String |
TH_MANBAR |
Computer Name |
30x |
Computer Name |
String |
TH_MAPNO |
Map Number |
30x |
Map Number |
String |
TH_MITIGAT |
Mitigation |
nnnnnnnn.nn |
Mitigation |
Double |
TH_MOD_BY |
Last Modified By: |
25x |
Last Modified By: |
String |
TH_MOD_DT |
Last Modified Date: |
mm/dd/yyyy hh:mm am |
Last Modified Date: |
DateTime |
TH_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
TH_MODEL |
Model |
30x |
Model |
String |
TH_MZONE_CD |
Maintenance Zone |
10x |
Maintenance Zone |
String |
TH_MZONE_TY |
Maintenance Zone Text |
60x |
Maintenance Zone Text |
String |
TH_NAME |
Name |
50x |
Name |
String |
TH_NOWORK |
No WO/PM/Req |
|
No WO/PM/Req |
Boolean |
TH_NUMBER |
Alt ID |
20x |
Tech Inv CommonID |
String |
TH_OSVEN_CD |
OS Vendor |
nnn |
OS Vendor |
integer |
TH_OSVEN_TY |
OS Vendor Text |
30x |
OS Vendor Text |
String |
TH_OSVER_CD |
OS Version |
nnn |
OS Version |
integer |
TH_OSVER_TY |
OS Version Text |
30x |
OS Version Text |
String |
TH_OWN_CD |
Owner Code |
nnn |
Owner Code |
integer |
TH_OWN_TY |
Owner Text |
25x |
Owner Text |
String |
TH_PCOST |
Purchase Price |
nnnnnnnn.nn |
Purchase Price |
Double |
TH_PMOD_CD |
Processor Model |
nnn |
Processor Model |
integer |
TH_PMOD_TY |
Processor Model Text |
30x |
Processor Model Text |
String |
TH_PO |
Purchase Order # |
30x |
Purchase Order # |
String |
TH_POF |
Probability of Failure |
nnnnnnnn.nn |
Probability of Failure |
Double |
TH_PROJNO |
Project Number |
30x |
Project Number |
String |
TH_PSPD |
Processor Speed |
30x |
Processor Speed |
String |
TH_PUR_DT |
Replacement Date |
mm/dd/yyyy hh:mm am |
Replacement Date |
DateTime |
TH_PVALUE |
Present Value |
nnnnnnnn.nn |
Present Value |
Double |
TH_RAM |
Processor Speed |
30x |
Processor Speed |
String |
TH_RCOST |
Storage Space - Additional |
nnnnnnnn.nn |
Storage Space - Additional |
Double |
TH_REPL_DT |
Purchase Date |
mm/dd/yyyy hh:mm am |
Purchase Date |
DateTime |
TH_RISK |
Risk |
nnnnnnnn.nn |
Risk |
Double |
TH_RLIFE |
Remaining Life |
nnnnnnnn.nn |
Remaining Life |
Double |
TH_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
TH_RVALUE |
Replacement Value |
nnnnnnnn.nn |
Replacement Value |
Double |
TH_SERIAL |
Serial Number |
30x |
Serial Number |
String |
TH_SPC_ADD |
Processor Speed |
30x |
Processor Speed |
String |
TH_SPC_INT |
Processor Speed |
30x |
Processor Speed |
String |
TH_SPC11_CD |
Spec 11 Code |
nnn |
Spec 11 Code |
integer |
TH_SPC11_TY |
Spec 11 Text |
50x |
Spec 11 Text |
String |
TH_SPC12_CD |
Spec 12 Code |
nnn |
Spec 12 Code |
integer |
TH_SPC12_TY |
Spec 12 Text |
50x |
Spec 12 Text |
String |
TH_SPC13_CD |
Spec 13 Code |
nnn |
Spec 13 Code |
integer |
TH_SPC13_TY |
Spec 13 Text |
50x |
Spec 13 Text |
String |
TH_SPC14_CD |
Spec 14 Code |
nnn |
Spec 14 Code |
integer |
TH_SPC14_TY |
Spec 14 Text |
50x |
Spec 14 Text |
String |
TH_SPC15_CD |
Spec 15 Code |
nnn |
Spec 15 Code |
integer |
TH_SPC15_TY |
Spec 15 Text |
50x |
Spec 15 Text |
String |
TH_SPC16_CD |
Spec 16 Code |
nnn |
Spec 16 Code |
integer |
TH_SPC16_TY |
Spec 16 Text |
50x |
Spec 16 Text |
String |
TH_SPC17_CD |
Spec 17 Code |
nnn |
Spec 17 Code |
integer |
TH_SPC17_TY |
Spec 17 Text |
50x |
Spec 17 Text |
String |
TH_SPC18_CD |
Spec 18 Code |
nnn |
Spec 18 Code |
integer |
TH_SPC18_TY |
Spec 18 Text |
50x |
Spec 18 Text |
String |
TH_SPC19_CD |
Spec 19 Code |
nnn |
Spec 19 Code |
integer |
TH_SPC19_TY |
Spec 19 Text |
50x |
Spec 19 Text |
String |
TH_SPC20_CD |
Spec 20 Code |
nnn |
Spec 20 Code |
integer |
TH_SPC20_TY |
Spec 20 Text |
50x |
Spec 20 Text |
String |
TH_SPEC1 |
Spec 1 |
30x |
Spec 1 |
String |
TH_SPEC10 |
Spec 10 |
30x |
Spec 10 |
String |
TH_SPEC2 |
Spec 2 |
30x |
Spec 2 |
String |
TH_SPEC3 |
Spec 3 |
30x |
Spec 3 |
String |
TH_SPEC4 |
Spec 4 |
30x |
Spec 4 |
String |
TH_SPEC5 |
Spec 5 |
30x |
Spec 5 |
String |
TH_SPEC6 |
Spec 6 |
30x |
Spec 6 |
String |
TH_SPEC7 |
Spec 7 |
30x |
Spec 7 |
String |
TH_SPEC8 |
Spec 8 |
30x |
Spec 8 |
String |
TH_SPEC9 |
Spec 9 |
30x |
Spec 9 |
String |
TH_STAT_CD |
Status |
nnn |
Status |
integer |
TH_STAT_TY |
Status Text |
25x |
Status Text |
String |
TH_SUBTY_CD |
Sub Type Code |
nnn |
Sub Type Code |
integer |
TH_SUBTY_TY |
Sub Type Text |
25x |
Sub Type Text |
String |
TH_SVALUE |
Salvage Value |
nnnnnnnn.nn |
Salvage Value |
Double |
TH_TYPE_CD |
Type Code |
nnn |
Type Code |
integer |
TH_TYPE_TY |
Type Text |
25x |
Type Text |
String |
TH_USER10 |
User 10 |
mm/dd/yyyy hh:mm am |
User 10 |
DateTime |
TH_USER11 |
User 11 |
mm/dd/yyyy hh:mm am |
User 11 |
DateTime |
TH_USER12 |
User 12 |
mm/dd/yyyy hh:mm am |
User 12 |
DateTime |
TH_USER13 |
User 13 |
|
User 13 |
Boolean |
TH_USER14 |
User 14 |
|
User 14 |
Boolean |
TH_USER15 |
User 15 |
|
User 15 |
Boolean |
TH_USER16CD |
User 16 |
nnn |
User 16 |
integer |
TH_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
TH_USER17CD |
User 17 |
nnn |
User 17 |
integer |
TH_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
TH_USER18CD |
User 18 |
nnn |
User 18 |
integer |
TH_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
TH_USER19CD |
User 19 |
nnn |
User 19 |
integer |
TH_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
TH_USER1CD |
User 1 Code |
nnn |
User 1 Code |
integer |
TH_USER1TY |
User 1 Text |
50x |
User 1 Text |
String |
TH_USER20CD |
User 20 |
nnn |
User 20 |
integer |
TH_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
TH_USER21 |
User 21 |
50x |
User 21 |
String |
TH_USER22 |
User 22 |
50x |
User 22 |
String |
TH_USER23 |
User 23 |
50x |
User 23 |
String |
TH_USER24 |
User 24 |
50x |
User 24 |
String |
TH_USER25 |
User 25 |
50x |
User 25 |
String |
TH_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
TH_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
TH_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
TH_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
TH_USER2CD |
User 2 Code |
nnn |
User 2 Code |
integer |
TH_USER2TY |
User 2 Text |
50x |
User 2 Text |
String |
TH_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
TH_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
TH_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
TH_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
TH_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
TH_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
TH_USER36 |
User 36 |
|
User 36 |
Boolean |
TH_USER37 |
User 37 |
|
User 37 |
Boolean |
TH_USER38 |
User 38 |
|
User 38 |
Boolean |
TH_USER39 |
User 39 |
|
User 39 |
Boolean |
TH_USER3CD |
User 3 Code |
nnn |
User 3 Code |
integer |
TH_USER3TY |
User 3 Text |
50x |
User 3 Text |
String |
TH_USER4 |
User 4 |
50x |
User 4 |
String |
TH_USER40 |
User 40 |
|
User 40 |
Boolean |
TH_USER41CD |
User 41 |
10x |
User 41 |
String |
TH_USER41TY |
User 41 Text |
60x |
User 41 Text |
String |
TH_USER42CD |
User 42 |
10x |
User 42 |
String |
TH_USER42TY |
User 42 Text |
60x |
User 42 Text |
String |
TH_USER43CD |
User 43 |
10x |
User 43 |
String |
TH_USER43TY |
User 43 Text |
60x |
User 43 Text |
String |
TH_USER44CD |
User 44 |
10x |
User 44 |
String |
TH_USER44TY |
User 44 Text |
60x |
User 44 Text |
String |
TH_USER45CD |
User 45 |
10x |
User 45 |
String |
TH_USER45TY |
User 45 Text |
60x |
User 45 Text |
String |
TH_USER46CD |
User 46 |
nnn |
User 46 |
integer |
TH_USER46TY |
User 46 Text |
50x |
User 46 Text |
String |
TH_USER47CD |
User 47 |
nnn |
User 47 |
integer |
TH_USER47TY |
User 47 Text |
50x |
User 47 Text |
String |
TH_USER48CD |
User 48 |
nnn |
User 48 |
integer |
TH_USER48TY |
User 48 Text |
50x |
User 48 Text |
String |
TH_USER49CD |
User 49 |
nnn |
User 49 |
integer |
TH_USER49TY |
User 49 Text |
50x |
User 49 Text |
String |
TH_USER5 |
User 5 |
50x |
User 5 |
String |
TH_USER50CD |
User 50 |
nnn |
User 50 |
integer |
TH_USER50TY |
User 50 Text |
50x |
User 50 Text |
String |
TH_USER51 |
User 21 |
50x |
User 21 |
String |
TH_USER52 |
User 22 |
50x |
User 22 |
String |
TH_USER53 |
User 23 |
50x |
User 23 |
String |
TH_USER54 |
User 24 |
50x |
User 24 |
String |
TH_USER55 |
User 25 |
50x |
User 25 |
String |
TH_USER56 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
TH_USER57 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
TH_USER58 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
TH_USER59 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
TH_USER6 |
User 6 |
50x |
User 6 |
String |
TH_USER60 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
TH_USER61 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
TH_USER62 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
TH_USER63 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
TH_USER64 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
TH_USER65 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
TH_USER66 |
User 36 |
|
User 36 |
Boolean |
TH_USER67 |
User 37 |
|
User 37 |
Boolean |
TH_USER68 |
User 38 |
|
User 38 |
Boolean |
TH_USER69 |
User 39 |
|
User 39 |
Boolean |
TH_USER7 |
User 7 |
nnnnnnnn.nn |
User 7 |
Double |
TH_USER70 |
User 40 |
|
User 40 |
Boolean |
TH_USER8 |
User 8 |
nnnnnnnn.nn |
User 8 |
Double |
TH_USER9 |
User 9 |
nnnnnnnn.nn |
User 9 |
Double |
TH_VEN_CD |
Vendor |
nnn |
Vendor |
integer |
TH_VEN_TY |
Vendor Text |
30x |
Vendor Text |
String |
TH_WO_COMM |
Short Work Order Comment |
255x |
Short Work Order Comment |
String |
TH_X |
X Coordinate |
nnnnnnnn.nn |
X Coordinate |
Double |
TH_Y |
Y Coordinate |
nnnnnnnn.nn |
Y Coordinate |
Double |