Table

Field

Description

Advance

VendorID

Added VendorID to link this table to the vendor set for the driver in their Personnel Setup record (4716).

CommissionedDetail

VendorID

Added VendorID to link this table to the vendor set for the person in their Personnel Setup record (4716).

LaborTypesFID

Added LaborTypesFID (Labor Type Setup) to link this table to the Labor Type set for the person in their Personnel Setup record (4716).

LSCrew

LaborTypesFID

New key linking a Local Services assignment record to the Labor Type set for the person in their Personnel Setup record (4716).

SplitCommissions

VendorID

Added VendorID to link this table to the vendor set for the person in their Personnel Setup record (4716).

LaborTypesFID

Added LaborTypesFID (Labor Type Setup) to link this table to the Labor Type set for the person in their Personnel Setup record (4716).

Sysuser

USERTYPE

This field has been replaced by the new SysUserLaborTypeMap table (4716).

COMMENTS

Increased size of the comments for an employee from 60 to unlimited (4716).

VendorID

This key has been moved to the new SysUserLaborTypeMap table (4716).

DateBasisFID

This key has been moved to the new SysUserLaborTypeMap table (4716).

SysUserCPMasterMap

DELETED TABLE

Table renamed SysUserLaborTypeCPMaster (4716).

SysUserLaborTypeCPMaster

NEW TABLE

Formerly known as SysUserCPMasterMap (4716).

SysUserLaborTypeMap

NEW TABLE

This tables stores the Labor Type Items set within Personnel Setup (4716).

SysUserLaborTypeMapID

Identifier for the mapping (4716).

SysUserFID

Links this table to the SysUser table (Personnel Setup) (4716).

LaborTypeFID

Links this table to a LaborType item (Labor Type Setup) (4716).

VendorID

Stores the selection made for a Vendor for the record. Vendors link to Microsoft Dynamics GP.

DateBasisFID

Links this table to a particular DateBase value (set as the Effective Date Basis within (Personnel Setup) (4716).

Default

Flag indicating the default record used when assigning crew to services through Local Dispatch (4716).

XmlUserMap

LaborTypeFID

Links an Interface Mapping record (part of Personnel Setup) to a particular Labor Type (Labor Type Setup) (4716).

SysUserLaborTypeMapFID

Links the XmlUserMap table to SysUserLaborTypeMap record (4716).