The following table lists the latest changes made to the MoversSuite database.
All changes are related to Xledger improvements and are related to functionality that will be in available soon.
|
Table |
Change |
|
AccountingAccount |
New table storing details on accounts associated with an accounting system. This table also includes flags that determine whether the account be posted to or is visible within MoversSuite. |
|
AccountingCustomerClass |
New table storing the customer classes associated with an accounting system. |
|
AccountingCustomerPaymentTerms |
New table storing the payment (invoice) terms associated a customer class. Days due, late amount charge, minimum charge, and conditions are available through this table. |
|
XLedgerAccount |
New table that links the accounting accounts to those defined specifically within the Xledger accounting system. |
|
XLedgerAccountingPeriod |
New tables that provides posting details on Xledger periods. Details include the open status of the period, date of the last import, and date of last change. |
|
XLedgerItemCodeMap |
New administrative table that defines a link between Item Codes defined in MoversSuite and Xledger accounts. This setup area will be available in a future release. |
|
XLedgerItemCodeMapAccountType |
New administrative table storing the values available for the types that can be assigned to Item Codes. These types include: Revenue Commissions ThirdParty The admin defined mappins will be stored within the XLedgerItemCodeMap table. |
|
XLedgerJournalEntryBatch |
New table that stores the master identifier for a batch of accounting items. Batches are exchanged between MoversSuite and Xledger with details populating the XLedgerJournalEntry tables. |
|
XLedgerJournalEntryBatchItem |
New table that links MoversSuite transactions to Xledger ones. |
|
XLedgerJournalEntryBatchQueue |
New table storing the state of imports to Xledger. This table include whether the batch has been processed and when it was enqueued. |
MOVERSSUITE DATABASE SCHEMA RESOURCES:
All changes are related to Xledger improvements to support foreign keys as noted under case MOV-7354. 57 tables have been updated along with ten new tables being added.
The following new tables have been added to the system:
|
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. |