|
This data object is used to return all Preventive Maintenance information fromt he Fusion Business System.
This information can be found in the Preventive Maintenance application within Fusion.
URL
/frw/PreventiveMaintenance
Field Details…
| SQL Field Name | Field Type |
|---|---|
| CustomerID | int |
| AddressID | int |
| UnitID | int |
| RepairOrderID | int |
| RepairOrderTaskID | int |
| RepairTypeID | int |
| AddDate | datetime |
| LastUpdate | datetime |
| CustomerBaseBranch | varchar(10) |
| ServiceBranch | varchar(10) |
| CustomerNumber | varchar(10) |
| IsLeaseRentalCustomer | bit |
| CompanyName | varchar(100) |
| CustomerAddress | varchar(100) |
| CustomerCity | varchar(100) |
| CustomerRegion | varchar(6) |
| CustomerPostalCode | varchar(15) |
| CustomerCountry | varchar(35) |
| CompanyShopPhone | varchar(30) |
| OwningCustomerContact | varchar(201) |
| UnitNumber | varchar(20) |
| UnitYear | int |
| Make | varchar(50) |
| Model | varchar(50) |
| VIN | varchar(20) |
| Ownership | varchar(1) |
| PMServiceDue21Days | varchar(1) |
| StartingMeter | decimal |
| StartingDate | datetime |
| AverageDailyUsage | int |
| LastMeterDate | datetime |
| LastMeterReading | decimal |
| UnitType | varchar(20) |
| LastRepairOrder | int |
| LastInvoiceNumber | varchar(50) |
| LastInvoiceDate | datetime |
| PMDescription | varchar(50) |
| GraceDays | int |
| GraceMeter | decimal |
| PMBasis | varchar(50) |
| PMCode | varchar(20) |
| PMMeterInterval | decimal |
| PMTimeInterval | int |
| PMRepairTypeCode | varchar(12) |
| PMRepairTypeDescription | varchar(50) |
| PMLastCompletionMeter | decimal |
| PMLastCompletionDate | datetime |
| PMDateNextDue | datetime |
| PMNextMeterDue | decimal |
| PMServiceDueFlag | varchar(1) |
| PMServiceDue7Days | varchar(1) |
| PMServiceDue14Days | varchar(1) |
| RONumber | int |
| ROStatus | varchar(20) |
| RODateOpened | datetime |
| TaskNumber | smallint |
| TaskDescription | varchar(50) |
| TaskClockedOnTechnicians | nvarchar(max) |
| IsScheduled | bit |
| LastPMROBranch | varchar(10) |
| ContractNumber | int |
| ContractCompanyName | varchar(100) |
| ContractCustomerShopPhone | varchar(30) |
| BranchID | int |
| OpenPMROBranch | varchar(10) |
| ContractCustomerContact | varchar(201) |
| UnitInventoryID | int |
| UnitIndicator | varchar(50) |
| AddUser | varchar(20) |
| LastUpdateUser | varchar(20) |