FS
FSVehicle
PX.Objects.FS85 of 85 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
RefNbr | nvarchar(15) | Vehicle ID | - | |
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 | - | |
Description:No description available | ||||
BranchLocationID | int | Branch Location | - | |
Description:No description available | ||||
Color | int | Color | - | |
Description:No description available | ||||
CpnyWarrantyEndDate | datetime2 | 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 | - | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
CustomerID | int | Customer | - | |
Description:No description available | ||||
CustomerLocationID | int | Location | - | |
Description:No description available | ||||
DateInstalled | datetime2 | Installation Date | - | |
Description:No description available | ||||
Descr | nvarchar(256) | Description | - | |
Description:No description available | ||||
DispAppointmentRefNbr | nvarchar(20) | Appointment Nbr. | - | |
Description:No description available | ||||
DisposalDate | datetime2 | Disposal Date | - | |
Description:No description available | ||||
DispServiceOrderRefNbr | nvarchar(15) | Service Order Nbr. | - | |
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 | nchar(15) | EquipmentTypeCD | - | |
Description:No description available | ||||
EquipmentTypeID | int | Equipment Type | - | |
Description:No description available | ||||
FixedAssetCDNonexistent in DB | nvarchar(MAX) | Fixed Asset | - | |
Description:No description available | ||||
FuelTank1 | decimal | Tank 1 - Gallons | - | |
Description:No description available | ||||
FuelTank2 | decimal | Tank 2 - Gallons | - | |
Description:No description available | ||||
FuelType | char(1) | Fuel Type | - | |
Description:No description available | ||||
GrossVehicleWeight | decimal | 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. | - | |
Description:No description available | ||||
InstServiceOrderRefNbr | nvarchar(15) | Service Order Nbr. | - | |
Description:No description available | ||||
InstSrvOrdType | char(4) | Service Order Type | - | |
Description:No description available | ||||
InventoryID | int | Model Equipment | - | |
Description:No description available | ||||
IsVehicle | bit | Vehicle | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LocationID | int | Warehouse Location | - | |
Description:No description available | ||||
LocationType | char(2) | Location Type | - | |
Description:No description available | ||||
ManufacturerID | int | Manufacturer | - | |
Description:No description available | ||||
ManufacturerModelID | int | Manufacturer Model | - | |
Description:No description available | ||||
ManufacturingYear | char(4) | Manufacturing Year | - | |
Description:No description available | ||||
MaxMiles | decimal | 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 | - | |
Description:No description available | ||||
OwnerType | char(2) | Owner Type | - | |
Description:No description available | ||||
PropertyType | char(2) | Property Type | - | |
Description:No description available | ||||
PurchAmount | decimal | Purchase Amount | - | |
Description:No description available | ||||
PurchDate | datetime2 | Purchase Date | - | |
Description:No description available | ||||
PurchPONumber | nvarchar(15) | Purchase Order Nbr. | - | |
Description:No description available | ||||
RegisteredDate | datetime2 | Registered Date | - | |
Description:No description available | ||||
RegistrationNbr | nvarchar(30) | License Nbr. | - | |
Description:No description available | ||||
ReplaceEquipmentID | int | Replacement Equipment Nbr. | - | |
Description:No description available | ||||
ReportSMEquipmentIDNonexistent in DB | int | - | ||
Description:No description available | ||||
RequireMaintenance | bit | Target Equipment | - | |
Description:No description available | ||||
ResourceEquipment | bit | Resource Equipment | - | |
Description:No description available | ||||
SalesDate | datetime2 | Sales Date | - | |
Description:No description available | ||||
SalesOrderNbr | varchar(15) | Sales Order Nbr. | - | |
Description:No description available | ||||
SalesOrderType | char(3) | Sales Order Type | - | |
Description:No description available | ||||
SerialNumber | nvarchar(100) | VIN | - | |
Description:No description available | ||||
SiteID | int | Warehouse | - | |
Description:No description available | ||||
SMEquipmentID | int | - | ||
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 | - | |
Description:No description available | ||||
TagNbr | nvarchar(20) | Tag Nbr. | - | |
Description:No description available | ||||
TareWeight | decimal | Tare Weight | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
VehicleTypeCD | nchar(15) | VehicleTypeCD | - | |
Description:No description available | ||||
VehicleTypeID | int | Vehicle Type ID | - | |
Description:No description available | ||||
VendorID | int | Vendor | - | |
Description:No description available | ||||
VendorWarrantyEndDate | datetime2 | 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 | Weight Capacity | - | |
Description:No description available | ||||