Listed in the table below are the database changes made at this version MoversSuite.
|
Table |
Field |
Description |
|
Branch |
CostBenefitsPercentage |
Added field to store the Job Costing value assigned to this branch through the Cost/Benefits Percentage value within Branch Setup (6542) |
|
CommType |
CommodityCode |
Field replaced by new functionality stored within the new XmlInterfaceCommTypeMap table (7200). |
|
EqType |
AverageCost |
New field capturing the Job Costing value assigned to the Equipment Type Setup records through the Average Cost field. (6542) |
|
ExpenseCategory |
|
New table storing the expense (cost) for a particular category (currently Labor, Equipment, Material, and Third Party) used when computing through the Job Costing screen. (6542) |
|
JobCostingItem |
|
New table that stores the Job Costing data for a particular order. (6542) |
|
JobCostingRevenueType |
|
New table containing the values available through the Revenue selector within the Job Costing screen. (6542) |
|
LaborType |
AverageHourlyWage |
New field capturing the Job Costing value assigned to the Labor Type Setup records through the Average Hourly Wage field. (6542) |
|
MaterialType |
ItemCost |
New field capturing the Job Costing value assigned to the Material Type Setup records through the Item Cost (each) field. (6542) |
|
MilitaryCarrier |
BranchFID |
New field added to Carrier Setup (Military/Government) in order to link a branch to the SCAC Code. (7200) |
|
MilitaryOrder |
SurveyCompleted |
New fields added to document the scoring available through the new Scoring Information section within the Military/Government tab as part of EasyDPS Integration. (7200) |
|
TspScore | ||
|
PackQuality | ||
|
LoadCourtesy | ||
|
PickupTimeliness | ||
|
DestCourtesy | ||
|
DelvryTimeliness | ||
|
Overall | ||
|
Order |
GrossMargin |
New field that stores the gross margin amount computed for an order through Job Costing. (6542) |
|
ProfitOrLoss |
New field that stores the profit/loss amount computed for an order through Job Costing. (6542) | |
|
JobCostingCalculated |
New flag to indicate that Job Costing has been calculated for the order. (6542) | |
|
JobCostingRevenueTypeFID |
New field storing the Revenue type set for the Job Costing calculated for the order. (6542) | |
|
JobCostingManualRevenue |
New field storing the manually entered revenue amount set for Job Costing. (6542) | |
|
JobCostingRevenueAmount |
New field storing the computed amount referenced for Job Costing calculations. (6542) | |
|
JobCostingFinalizedRevenue |
New field storing the computed and finalized revenue amount referenced for Job Costing calculations. This the amount revenue for the order is based. (6542) | |
|
OrderPredatesJobCosting |
New flag to indicate that revenue has already been recorded for the order prior to Job Costing calculations. (6542) | |
|
OrderThirdPartys |
Date |
New field to store the Invoice Date for a third party item (see Add Third Party Item (Revenue Entry)). (6542) |
|
SysUserLaborTypeMap |
HourlyWage |
New field capturing the Job Costing value assigned to the Personnel Setup records through the Hourly Wage field (assigned to a Labor Type Item). (6542) |
|
XmlInterfaceCommTypeMap |
|
New table storing the External Code assigned to an Interface Item through Commodity Type Setup to support easyDPS integration. (7200) |
Click here for a graphical interpretation of the MoversSuite database schema (5.18).