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 |