FS
FSEquipment
PX.Objects.FSView API Entity: Equipment
/entity/Default/24.200.001/Equipment84 of 84 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RefNbr | nvarchar(15) | Equipment Nbr. | - | |
Description:No description available | ||||
ARTranLineNbr | int | - | ||
Description:No description available | ||||
Axles | smallint | Axles | - | |
Description:No description available | ||||
Barcode | nvarchar(20) | Barcode | - | |
Description:No description available | ||||
BranchID | int | Branch | Branch | |
Description:No description available | ||||
BranchLocationID | int | Branch Location | FSBranchLocation | |
Description:No description available | ||||
Color | int | Color | - | |
Description:No description available | ||||
CpnyWarrantyEndDate | datetime | Company Warranty End Date | - | |
Description:No description available | ||||
CpnyWarrantyType | char(1) | CpnyWarrantyType | - | |
Description:No description available | ||||
CpnyWarrantyValue | int | Company Warranty | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CustomerID | int | Customer | Customer | |
Description:No description available | ||||
CustomerLocationID | int | Location | Location | |
Description:No description available | ||||
DateInstalled | datetime | Installation Date | - | |
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
DispAppointmentRefNbr | nvarchar(20) | Appointment Nbr. | FSAppointment | |
Description:No description available | ||||
DisposalDate | datetime | Disposal Date | - | |
Description:No description available | ||||
DispServiceOrderRefNbr | nvarchar(15) | Service Order Nbr. | FSServiceOrder | |
Description:No description available | ||||
DispSrvOrdType | char(4) | Service Order Type | - | |
Description:No description available | ||||
EngineNo | nvarchar(30) | Engine Nbr. | - | |
Description:No description available | ||||
EquipmentReplacedID | int | Equipment Replaced | - | |
Description:No description available | ||||
EquipmentTypeCD | nvarchar(15) | EquipmentTypeCD | - | |
Description:No description available | ||||
EquipmentTypeID | int | Equipment Type | FSEquipmentType | |
Description:No description available | ||||
FixedAssetCDNonexistent in DB | nvarchar(MAX) | Fixed Asset | - | |
Description:No description available | ||||
FuelTank1 | decimal(19, 4) | Tank 1 - Gallons | - | |
Description:No description available | ||||
FuelTank2 | decimal(19, 4) | Tank 2 - Gallons | - | |
Description:No description available | ||||
FuelType | char(1) | Fuel Type | - | |
Description:No description available | ||||
GrossVehicleWeight | decimal(19, 4) | Gross Vehicle Weight | - | |
Description:No description available | ||||
ImageUrl | nvarchar(255) | Image | - | |
Description:No description available | ||||
INSerialNumber | nvarchar(100) | Model Serial Nbr. | - | |
Description:No description available | ||||
InstAppointmentRefNbr | nvarchar(20) | Appointment Nbr. | FSAppointment | |
Description:No description available | ||||
InstServiceOrderRefNbr | nvarchar(15) | Service Order Nbr. | FSServiceOrder | |
Description:No description available | ||||
InstSrvOrdType | char(4) | Service Order Type | - | |
Description:No description available | ||||
InventoryID | int | Model Equipment | InventoryItem | |
Description:No description available | ||||
IsVehicle | bit | Vehicle | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LocationID | int | Warehouse Location | INLocation | |
Description:No description available | ||||
LocationType | char(2) | Location Type | - | |
Description:No description available | ||||
ManufacturerID | int | Manufacturer | FSManufacturer | |
Description:No description available | ||||
ManufacturerModelID | int | Manufacturer Model | FSManufacturerModel | |
Description:No description available | ||||
ManufacturingYear | char(4) | Manufacturing Year | - | |
Description:No description available | ||||
MaxMiles | decimal(19, 4) | Max Miles | - | |
Description:No description available | ||||
MemDescrAdditionalVehicle1Nonexistent in DB | nvarchar(MAX) | Additional Vehicle 1 Description | - | |
Description:No description available | ||||
MemDescriptionNonexistent in DB | nvarchar(255) | Equipment Description | - | |
Description:No description available | ||||
MemDescrVehicleNonexistent in DB | nvarchar(MAX) | Vehicle Description | - | |
Description:No description available | ||||
MemReplacedEquipmentNonexistent in DB | nvarchar(MAX) | Suspended Target Equipment ID | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | NoteID | - | |
Description:No description available | ||||
OwnerID | int | Customer | Customer | |
Description:No description available | ||||
OwnerType | char(2) | Owner Type | - | |
Description:No description available | ||||
PropertyType | char(2) | Property Type | - | |
Description:No description available | ||||
PurchAmount | decimal(19, 6) | Purchase Amount | - | |
Description:No description available | ||||
PurchDate | datetime | Purchase Date | - | |
Description:No description available | ||||
PurchPONumber | nvarchar(15) | Purchase Order Nbr. | - | |
Description:No description available | ||||
RegisteredDate | datetime | Registered Date | - | |
Description:No description available | ||||
RegistrationNbr | nvarchar(30) | Registration Nbr. | - | |
Description:No description available | ||||
ReplaceEquipmentID | int | Replacement Equipment Nbr. | - | |
Description:No description available | ||||
ReportSMEquipmentIDNonexistent in DB | int | FSEquipment | ||
Description:No description available | ||||
RequireMaintenance | bit | Target Equipment | - | |
Description:No description available | ||||
ResourceEquipment | bit | Resource Equipment | - | |
Description:No description available | ||||
SalesDate | datetime | Sales Date | - | |
Description:No description available | ||||
SalesOrderNbr | varchar(15) | Sales Order Nbr. | SOOrder | |
Description:No description available | ||||
SalesOrderType | char(3) | Sales Order Type | - | |
Description:No description available | ||||
SerialNumber | nvarchar(100) | Serial Nbr. | - | |
Description:No description available | ||||
SiteID | int | Warehouse | INSite | |
Description:No description available | ||||
SMEquipmentID | int | FSEquipment | ||
Description:No description available | ||||
SourceDocType | char(3) | Document Type | - | |
Description:No description available | ||||
SourceID | int | - | ||
Description:No description available | ||||
SourceRefNbr | nvarchar(15) | Document Ref. Nbr. | - | |
Description:No description available | ||||
SourceType | char(3) | Document Type | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
SubItemID | int | Subitem | INSubItem | |
Description:No description available | ||||
TagNbr | nvarchar(20) | Tag Nbr. | - | |
Description:No description available | ||||
TareWeight | decimal(19, 4) | Tare Weight | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VehicleTypeID | int | Vehicle Type ID | FSVehicleType | |
Description:No description available | ||||
VendorID | int | Vendor | Vendor | |
Description:No description available | ||||
VendorWarrantyEndDate | datetime | Vendor Warranty End Date | - | |
Description:No description available | ||||
VendorWarrantyType | char(1) | VendorWarrantyType | - | |
Description:No description available | ||||
VendorWarrantyValue | int | Vendor Warranty | - | |
Description:No description available | ||||
WeightCapacity | decimal(19, 4) | Weight Capacity | - | |
Description:No description available | ||||