Table

Field

Description

CPDetail

EffectiveStart

EffectiveEnd

New date fields were added to this table for the Commission Plan Effective Dates enhancement (4431, 5949, 6110). These dates store the date range a commission plan is in effect (as defined within Commission Plan Setup).

CPMaster

DateBasisFID

New field storing the Effective Date Basis assigned to a Commission Plan within Commission Plan Setup.

DateBasis

New table replacing the ReductionTemplateDateBasis table for the Commission Plan Effective Dates enhancement (4431, 5949, 6110).

ReductionTemplateDateBasis

This table is replaced by the DateBasis table.

ReductionTemplateHeader

DateBasisFID

ReductionTemplateBasisFID

DateBasisFID replaces ReductionTemplateBasisFID as a pointer for the Effective Date Basis setting within Reduction Template Setup.

ReportSystemCommissionStatement VendorSummary

SortBy

Renamed to IsOrder. This bit field identifies the record as a MoversSuite order (when set) or not (not set). This change affects the Vendor Summary of the Commission Statement Report (6109).

SafetySystemPersonnel

LastMVRDate

New fields added to the Safety tab in Personnel Setup and visible through Safety Information (Personnel).

BackgroundCheckCID length is 64 characters.

NextMVRDate

LastBackgroundCheckDate

NextBackgroundCheckDate

BackgroundCheckCID

ShipmentStatusHistory

VanNo

Increased the size of this field from 10 characters to 12 (Ref.#6403.4.84)

StatementChargeback

OrigAR

Replaces SDDPriKey

SDDPriKey

New key linking this table to the StatementDetailDist table

VLCustomerNumber

VLARAccount

Fields replaced by fields in the new StatementPayable table

StatementChargebackDetail

Table replaced by StatementPayable.

StatementDetail

StatementDetailDist

AccountSeg

SubAccountSeg

GLNumberAgg

Fields moved to the StatementGLAllocation table.

1099Flag

Field value now set through the new StatementPayable table (see below).

UnappliedBranchFID

New field linking this table to the Branch table. This is used to identify the branch associated to an Unapplied Amount in Payment Application.

UnappliedDivisionFID

New field linking this table to the Division table. This is used to identify the division associated to an Unapplied Amount in Payment Application.

VendorID

Field value now set through the new StatementPayable table (see below).

StatementGLAllocation

AccountSeg

SubAccountSeg

New GLAccountNumber field (varchar (66)) replaces both AccountSeg and SubAccountSeg for the Payment Application changes.

GLAccountNumber

StatementPayable

New table replacing StatementChargeBackDetail as part of the New Payment Application Screen in Payment Management enhancement (5188)

SysFile

CPPriKey

Field replaced by new SysUserCPMasterMapID table.

DateBasisFID

New field storing the basis selected for the employee within the Accounting tab in Personnel Setup as part of the Commission Plan Effective Dates enhancement.

IgnoreRatingOrderPostDel

New flag to control whether order data updates after the actual delivery date is set on a UniGroup Rating Send.

This flag is administered through System Wide Options.

Sysuser

VANNO

Increased the size of this field from 10 characters to 12 (Ref.#6403.4.84)

SysUserCPMasterMapID

New table storing the effective dates that a particular commission plan is in effect for a particular user.

Refer to Commission Plan Details within the Accounting tab in for Personnel Setup details.

ToDo

DependencyDateID

New pointer to the DependencyDate table, which identifies which MoversSuite date affects the task item.

Refer to the Dependency Date field in Tasks Setup for more information.

DueDays

New field storing the Due Days set for the task item.

Refer to the Due Days field in Tasks Setup for more information.

DueType

New field storing the Due Type set for the task item.

Refer to the Due Type field in Tasks Setup for more information.

DueDate

New field storing the actual date the item is due on.

Refer to the Add Task for more information.

TaskUserFID

New field that links this record to the type of user associated to the task and defined within CoordinatorType table.

CoordinatorType is defined for each task through the Responsible Role setting in Tasks Setup.

UserAccess

UserID

Expanded the field size from 12 to 32 characters. This field stores the value set for the User ID in the User tab in Personnel Setup.

WebAccess

UserID

Expanded the field size from 12 to 32 characters. This field stores the value set for the User ID in the Web User tab in Personnel Setup.