OPSBKExtraWork

Name: Backup - Extra Work

Type: Application

Modules: OPS-Bidding

Description: Contains information about the extra work contained in the bid being backed up.

Field Documentation
BkBidId Unique identifier for an exported bid.
WorkName Name of the extra work.
WorkType Work type identifier from WorkSubtypes.Worktype. References the associated work type.
DivisionId Division identifier from MasterDivisions.DivisionId. References the associated division.
FromDate Start date of the validity period.
ToDate End date of the validity period.
WeekTemplate 7-character string indicating what days of the week the work occurs (e.g., 0011001 means Monday, Tuesday, and Friday).
ServiceGroupId Service group identifier from ServiceGroup.ServiceGroupId. References the associated service group.
SignOnTime Sign-on time for the extra work. Value is in seconds from midnight.
SignOffTime Sign-off time for the extra work. Value is in seconds from midnight.
FromTime Start time of the extra work. Value is in seconds from midnight.
ToTime End time of the extra work. Value is in seconds from midnight.
Comments Comments about the record.
FromLocation Starting location of the extra work.
ToLocation Ending location of the extra work.
NumberNeeded Number of employees needed to complete the work.
WorkSubtype Work subtype identifier from WorkSubtypes.WorkSubtype. References the associated work subtype.
CustomerId Customer identifier from Customers.CustomerId. References the associated customer.
UserDouble1 Client supplementary data.
UserDouble2 Client supplementary data.
UserDouble3 Client supplementary data.
UserDouble4 Client supplementary data.
UserDouble5 Client supplementary data.
UserDouble6 Client supplementary data.
UserDouble7 Client supplementary data.
UserLong1 Client supplementary data.
UserLong2 Client supplementary data.
UserShort1 Client supplementary data.
UserShort2 Client supplementary data.
UserShort3 Client supplementary data.
UserShort4 Client supplementary data.
UserShort5 Client supplementary data.
UserString1 Client supplementary data.
UserString2 Client supplementary data.
UserString3 Client supplementary data.
UserString4 Client supplementary data.
UserString5 Client supplementary data.
UserLongString1 Client supplementary data.
BusTypeId Bus type identifier from BusTypes.BusTypeId. References the associated bus type.
ExtraWorkStatus Extra work status identifier from TkExtraWorkStatus.ExtraWorkStatus. References the status of the extra work.
UserLong3 Client supplementary data.
Mileage Total mileage of the extra work (in meters).
UserDouble8 Client supplementary data.
UserDouble9 Client supplementary data.
SalesAgent Name of the sales agent.
ToCollect If true, money is to be collected.
AmountCollected Total amount collected.
ToPrepay If true, prepayment has to be made.
Prepayment Total amount of prepayment.
SupervisorRate Supervisor's payrate.
SupervisorTime Supervisor's total time in seconds.
FlatAmount Flat amount to be paid for the extra work.
AdditionalAmount Additional amount to be paid for the extra work.
FlatRate Flat rate to be paid for the extra work.
TotalTime Total time of the extra work in seconds.
AddComment Special comments about the extra work.
ContactName Name of the associated contact.
PayAmount Total pay amount for the exra work.
AdjustmentAmount Total adjustment amount for the extra work.
PickUpTime Pick-up time for the extra work. Value is in seconds from midnight.
PickUpLocation Pick-up location for the extra work.
DropOffTime Drop-off time for the extra work. Value is in seconds from midnight.
DropOffLocation Drop-off location for the extra work.
SpecialInstructionsMemoId Memo identifier from MemoValues.MemoId. References a memo with special instructions.
ReferenceText References a record or document associated with this record.
FromAddrType Type of the originating location (e.g., 'Garage').
FromNodeId Node identifier for start point from Nodes.NodeId. References the associated originating node.
ToAddrType Type of the destination location (e.g., 'Stop').
ToNodeId Node identifier for start point from Nodes.NodeId. References the associated destination node.
CustomerGroup Customer group.
VehicleType Vehicle type identifier from VehicleTypes.VehicleType. References the associated vehicle type.
StartWait Elapsed wait time in seconds associated with the beginning of the piece.
StartTravel Elapsed travel time in seconds associated with the beginning of the piece.
EndWait Elapsed wait time in seconds associated with the end of the piece.
EndTravel Elapsed travel time in seconds associated with the end of the piece.
MaxOBT Maximum allowable On Board Time on the vehicle of the client for the trip. Value is in seconds from midnight.
LineGroupAbbr Line group identifier from MasterLineGroup.LineGroupId. References the associated line group.
FromAddrId Unique identifier of the originating location.
ToAddrId Unique identifier of the destination location.
DestinationSign Text that is displayed on the sign of the assigned vehicle.
ModAction Last action performed on the record.
DayTypeGroup Associated day type group.
ShiftLayover Total shift layover time in seconds.
MakeupTime Total makeup time in seconds.
NonRevenueMileage Total calculated mileage in meters of all the non-revenue trips in the block between non-garage to garage nodes.
RevenueMileage Total calculated mileage in meters of all the revenue trips in the block between non-garage to non-garage nodes.
NonRevenueTime Total calculated time in seconds of all the non-revenue trips in the block between non-garage to garage nodes.
RevenueTime Total calculated time in seconds of all the revenue trips in the block between non-garage to non-garage nodes.
ActivityTypeId ActivityType identifier from OPSDailyActivityTypes.ActivityId
LineList List of lines in the extra work.
BreakStartTime Start of the break time. Value is in seconds from midnight.
BreakTime Total break time in seconds.
PayTime Total amount of payable time in seconds.
WorkTime Total work time in seconds.
PlatformTime Total amount of platform time in seconds.