| EQUIPID |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| SERLNMBR |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| ITEMNMBR |
char(31)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| REFRENCE |
char(31)
''
|
Reference:...(more) Join Now
|
POP30300.REFRENCE
|
|
|
| Version |
char(21)
''
|
|
|
|
|
| SRLSTAT |
char(11)
''
|
|
|
|
|
| INSTDTE |
datetime
'1/1/1900'
|
|
|
|
|
| CUSTNMBR |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADRSCODE |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS1 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| ADDRESS2 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| CITY |
char(35)
''
|
Field Type...(more) Join Now
|
|
|
|
| STATE |
char(29)
''
|
Field Type...(more) Join Now
|
|
|
|
| ZIP |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| COUNTRY |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| CNTCPRSN |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| LSTPMDTE |
datetime
'1/1/1900'
|
|
|
|
|
| LSTSRVDTE |
datetime
'1/1/1900'
|
|
|
|
|
| TECHID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| TECHID2 |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| OFFID |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVCAREA |
char(11)
''
|
Field Type...(more) Join Now
|
|
|
|
| TIMEZONE |
char(3)
''
|
Field Type...(more) Join Now
|
|
|
|
| WARRCDE |
char(11)
''
|
|
|
|
|
| WARREND |
datetime
'1/1/1900'
|
|
|
|
|
| WARRSTART |
datetime
'1/1/1900'
|
|
|
|
|
| SLRWARR |
char(11)
''
|
|
|
|
|
| SLRWEND |
datetime
'1/1/1900'
|
|
|
|
|
| SLRWSTART |
datetime
'1/1/1900'
|
|
|
|
|
| NOTEINDX |
numeric(19,5)
0.00
|
Note Index...(more) Join Now
|
|
|
join ... more text available
|
| MTTR |
numeric(19,5)
0.00
|
|
|
|
|
| MTBF |
numeric(19,5)
0.00
|
|
|
|
|
| MTBI |
numeric(19,5)
0.00
|
|
|
|
|
| Last_Calc_Date |
datetime
'1/1/1900'
|
|
|
|
|
| Meters_1 |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| Meters_2 |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| Meters_3 |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| Meters_4 |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| Meters_5 |
int
0
|
Field Type...(more) Join Now
|
|
|
|
| Dailys_1 |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Dailys_2 |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Dailys_3 |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Dailys_4 |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| Dailys_5 |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| MTBFs_1 |
numeric(19,5)
0.00
|
|
|
|
|
| MTBFs_2 |
numeric(19,5)
0.00
|
|
|
|
|
| MTBFs_3 |
numeric(19,5)
0.00
|
|
|
|
|
| MTBFs_4 |
numeric(19,5)
0.00
|
|
|
|
|
| MTBFs_5 |
numeric(19,5)
0.00
|
|
|
|
|
| Meter_Deltas_1 |
int
0
|
|
|
|
|
| Meter_Deltas_2 |
int
0
|
|
|
|
|
| Meter_Deltas_3 |
int
0
|
|
|
|
|
| Meter_Deltas_4 |
int
0
|
|
|
|
|
| Meter_Deltas_5 |
int
0
|
|
|
|
|
| SVC_PM_Date |
smallint
0
|
|
|
|
|
| SVC_PM_Day |
smallint
0
|
|
|
|
|
| VENDORID |
char(15)
''
|
Field Type...(more) Join Now
|
|
|
join ... more text available
|
| ADDRESS3 |
char(61)
''
|
Field Type...(more) Join Now
|
|
|
|
| USERDEF1 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USERDEF2 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USRDEF03 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USRDEF04 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| USRDEF05 |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Serial_ID |
char(21)
''
|
|
|
|
|
| QUANTITY |
numeric(19,5)
0.00
|
Field Type...(more) Join Now
|
|
|
|
| SVC_Asset_Tag |
char(21)
''
|
|
|
|
|
| Shipped_Date |
datetime
'1/1/1900'
|
|
|
|
|
| SVC_Register_Date |
datetime
'1/1/1900'
|
|
|
|
|
| SOPNUMBE |
char(21)
''
|
Field Type...(more) Join Now
|
|
|
|
| DEX_ROW_ID |
int
auto number (1,1)
|
Unique ide...(more) Join Now
|
|
|
|