View over the F1731 and F17311 for any Cantara Client Applications that use proximity based searching.
Fields
|
Name |
Alias |
Type |
Table |
|---|---|---|---|
|
UniqueKeyIDInternal |
UKID |
INTEGER |
F1731 |
|
UniqueKeyIDInternal1 |
UKID |
INTEGER |
F17311 |
|
Longitude |
LONG |
STRING |
F17311 |
|
Latitude |
LATT |
STRING |
F17311 |
|
EquipmentLocationElevation |
LEVAT |
STRING |
F17311 |
|
EquipmentLocationBuilding |
BUILD |
STRING |
F17311 |
|
EquipmentLocationFloor |
FLOOR |
STRING |
F17311 |
|
EquipmentLocationRoom |
ROOM1 |
STRING |
F17311 |
|
EquipmentLocationOther1 |
OTHR1 |
STRING |
F17311 |
|
EquipmentLocationOther2 |
OTHR2 |
STRING |
F17311 |
|
ContactName |
WHO |
STRING |
F17311 |
|
CaseFromPhoneCon1 |
CPHC1 |
STRING |
F17311 |
|
NameMailing |
MLNM |
STRING |
F17311 |
|
AddressLine1 |
ADD1 |
STRING |
F17311 |
|
AddressLine2 |
ADD2 |
STRING |
F17311 |
|
AddressLine3 |
ADD3 |
STRING |
F17311 |
|
AddressLine4 |
ADD4 |
STRING |
F17311 |
|
City |
CTY1 |
STRING |
F17311 |
|
CountyAddress |
COUN |
UDC |
F17311 |
|
State |
ADDS |
UDC |
F17311 |
|
ZipCodePostal |
ADDZ |
STRING |
F17311 |
|
Country |
CTR |
UDC |
F17311 |
|
CreationDate2 |
CADT |
DATE |
F17311 |
|
CreatedByUser |
CRTU |
STRING |
F17311 |
|
AssetItemNumber |
NUMB |
ASSETNUMBER |
F1731 |
|
AddressNumberLessor |
LANO |
ADDRESSNUMBER |
F1731 |
|
AddressNumber |
AN8 |
ADDRESSNUMBER |
F1731 |
|
CostCenterLocation |
LOC |
BUSINESSUNIT |
F1731 |
|
DocumentOrderInvoiceE |
DOCO |
INTEGER |
F1731 |
|
CompanyKey |
KCO |
COMPANY |
F1731 |
|
OrderType |
DCTO |
UDC |
F1731 |
|
LocationHistOrSched |
AL |
UDC |
F1731 |
|
NameRemark |
RMK |
STRING |
F1731 |
|
DateBeginningEffective |
EFTB |
DATE |
F1731 |
|
TimeStampBeginning |
DDTS |
INTEGER |
F1731 |
|
DateEnding |
END |
DATE |
F1731 |
|
TimeStampEnding |
DTSO |
INTEGER |
F1731 |
|
TransferNumber |
TRNN |
STRING |
F1731 |
|
TransferActionCode |
ROS |
UDC |
F1731 |
|
AssetItemNumber1 |
NUMB |
ASSETNUMBER |
F1201 |
|
UnitNumber |
APID |
STRING |
F1201 |
|
ParentNumber |
AAID |
INTEGER |
F1201 |
|
SerialTagNumber |
ASID |
STRING |
F1201 |
|
MajorClass |
ACL1 |
UDC |
F1201 |
|
SubClass |
ACL2 |
UDC |
F1201 |
|
Description001 |
DL01 |
STRING |
F1201 |
|
Description01002 |
DL02 |
STRING |
F1201 |
|
Description01003 |
DL03 |
STRING |
F1201 |
|
EquipmentStatus |
EQST |
UDC |
F1201 |
|
AddressNumberLessor1 |
LANO |
ADDRESSNUMBER |
F1201 |
|
Company |
CO |
COMPANY |
F1201 |
|
CostCenter |
MCU |
BUSINESSUNIT |
F1201 |
|
AddressNumber1 |
AN8 |
ADDRESSNUMBER |
F1201 |
|
ItemNumberShortKit |
KIT |
SHORTITEM |
F1201 |
|
ItemNumber2ndKit |
KITL |
STRING |
F1201 |