VQ351731 - Q35 Equipment Location
Business 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 |