New Table

Description

AccountingCustomer

This table stores the name of the customers that are defined within your chosen accounting system. Along with the name, this table stores a flag indicating whether the customer has been deleted within the accounting system.

Refer to Customer and Customer Find for more information.

AccountingCustomerAddress

The address associated with an AccountingCustomer record is stored in this table. The table populates from your chosen accounting system.

These addresses are available through the Choose Billing Address dialog.

AccountingCustomerAddressType

The types of address that is stored for the customer in AccountingCustomerAddress table are defined here. They include the following:

Billing

Main

Shipping

These types will be present through the Choose Billing Address dialog.

AccountingVendor

This table stores the name of the vendors that are defined within your chosen accounting system. Along with the name, this table stores a flag indicating whether the customer has been deleted within the accounting system along with vendor code.

Refer to Vendor Find for more information.

AccountingVendorAddress

The address associated with an AccountingVendor record is stored in this table. The table populates from your chosen accounting system.

These addresses are visible through the Vendor Find dialog.

AccountingVendorAddressType

The types of address that is stored for the vendor in AccountingVendorAddress table are defined here. They include the following:

Billing

Main

Shipping

XLedgerCustomer

This table links an AccountingCustomer to a particular external database reference, i.e., disparate Xledger accounting system. This table is referenced when updates occur that sync data between MoversSuite and the Xledger database.

XLedgerSupplier

This table links an AccountingVendor to a particular external database reference, i.e., disparate Xledger accounting system. This table is referenced when updates occur that sync data between MoversSuite and the Xledger database.

XLedgerSyncEntityType

The types of syncing that can occur between Xledger and MoversSuite are defined within this internal table. These currently consist of the following sync types:

Customer

Supplier

XLedgerSyncHistory

Historical information on when a sync (of types defined in XLedgerSyncEntityType) starts, is completed, along with an update timestamp are recorded in this table.

New Column

Description

AccountingCustomerFid

New identifier pointing to a AccountingCustomer record. This identifier has been added to the following tables:

AccountProfiles

AcctTransactions

AlternateBillTo

ARCActivity

ARCCustomerInformation

ARCTask

ARCTriggeredAlert

ARCTriggeredAlertOrderMap

BATProcess

ClaimHandlingRevenue

ClaimItemDueFrom

CustomerInvoiceProfile

CustomerInvoiceReport

CustomerNoteHeader

CustomerStatement

CustomerStatementRun

FactoringCustomer

GLControl

GPCustomer

GPWarehouse

InvoicedHeader

InvoiceRequirement

Orders

PlasticDeal

PlasticInstrument

PlasticWebDeal

PMImportDetail

StatementChargeBack

StatementDetail

StatementDetailDist

StatementDetailDistInvoice

VanLine

VanlineStatementDetail

VanlineStatementStageDetail

AccountingVendorFid

New identifier pointing to an AccountingVendor record. This identifier has been added to the following tables:

AcctTransactions

Advance

AdvanceBankingServiceProvider

Agent

BATProcess

ClaimHandlingExpense

ClaimLiability

ClaimSettlement

CommissionedDetail

CommStmtVendor

InternationalBOLConsignee

InternationalCarrier

InternationalConsolidator

InternationalCustomsAgent

InternationalLinehaulCarrier

OrderThirdPartys

PMImportDetail

QuoteDetail

QuoteGroup

SITInformation

SplitCommissions

StatementDetailDistVendor

StatementPayable

SysUserLaborTypeMap

TemporaryVendor

ThirdParty

VanLine

ClaimsAccountingCustomerFid

New identifier pointing to a AccountingCustomer record. This identifier has been added to the VanLine table for claims processing and is defined within Van Line Setup under the Claims Customer setting.

OriginalAccountingCustomerFid

New identifier pointing to a AccountingCustomer record. This identifier has been added to the InvoicedHeader to track what the prior customer may have been set to on and invoice. This is set upon a customer change within New Complete Invoice screen through the Select Customer feature.