The following table lists the latest changes made to the MoversSuite database.
All changes are related to XLedger improvements and are related to yet-to-be released functionality.
NOTE: Please check any custom reports and processes that you may have to see if they reference the AlternateBillTo table. If they do, then check future releases for more information on accessing similar data through the new views.
|
Table |
Change |
|
AccountingCustomer |
Changed Name to a varchar(65) from a nvarchar(256). |
|
AccountingCustomerAddressType |
Changed TypeName to a varchar(15) from a nvarchar(32). |
|
AccountingVendor |
Changed Name to a varchar(65) from a nvarchar(256). Renamed Code to VendorNumber and changed type varchar(15) from a nvarchar(256). |
|
AccountingVendorAddress Type |
Changed TypeName to a varchar(15) from a nvarchar(32). |
|
AccountingVendorClass |
New table storing class information such as code and description. |
|
AccountProfiles |
Added AccountingCustomerAddressFid (int). This is a pointer to the selected address for a customer as referenced through the AccountingCustomerAddress table. |
|
AcctTransactions |
Removed AccountingCustomerFid and AccountingVendorFid. These specifications have been moved to other tables, such as the BillingMinorItem, CommStmtHeader, and InvoicedHeader tables. |
|
AdvanceSetup |
Added ExpenseAccountingAccountFId (int). New point to the expense account defined within your accounting system. |
|
AlternateBillTo |
Removed. This table stored information on what address types were available for each customer. This information was pulled from the vCustomerInformation view. |
|
ARCCustomerInformation |
Changed Name to a varchar(15) from a varchar(50). |
|
BATProcess |
Added the following pointers (all int): XglFid NominalAccountingAccountFid OpposingAccountingAccountFid NominalBranchFid OpposingBranchFid NominalDivisionFid OpposingDivisionFid
|
|
BillingMinorItem |
Removed ABTPrikey, pointer to the removed AlternateBillTo table. Added AlternateCustomerNumber (varchar(15)). Added AlternateCustomerAddressCode (varchar(15)). Added AlternateAcountingCustomerFid (int) Added AlternateAccountingCustomerAddressFid (int). |
|
ClaimSettlementClearingAccount |
Added AccountingAccountFid (int). |
|
CommStmtHeader |
AddedAccountingVendorClassFid (int). |
|
InvoicedHeader |
Removed AlternateBillToFID. Added AlternateCustomerNumber (varchar(15)). Added AlternateCustomerAddressCode (varchar(15)). Added AlternateAcountingCustomerFid (int) Added AlternateAccountingCustomerAddressFid (int). |
|
Orders |
Added AccountingCustomerAddressFid (int). This is a pointer to the selected address for a customer as referenced through the AccountingCustomerAddress table. |
|
StatementDocument |
Added AccountingCustomerFid (int). This is a pointer to the selected customer. |
|
Storage |
Removed ABTPrikey, pointer to the removed AlternateBillTo table. Added AlternateCustomerNumber (varchar(15)). Added AlternateCustomerAddressCode (varchar(15)). Added AlternateAcountingCustomerFid (int) Added AlternateAccountingCustomerAddressFid (int). |
|
SY01200 |
New table as a synonym table for Dynamics GP details, if Dynamics GP is the accounting system employed. |
|
XLedgerCustomer |
Added CreatedOn (datetimeoffset). Added LastImportedOn (datetimeoffset). |
|
XLedgerCustomerClass |
New table storing reference details for an XLedger customer. |
|
XLedgerCustomerPaymentTerms |
New table storing reference payment detail pointers for an XLedger customer. |
|
XLedgerGLARAP |
New admin table with pointers to the XLedger accounting system in use.
Coming soon. Refer to the GL System Accounts Setup for details. |
|
XLedgerJournalEntryBatch |
Updated SubmittedBySysUserFid to be NULL instead of NOT NULL. |
|
XLedgerLaborTypeToExpenseTypeMap |
New administrative table storing the link between Labor Type Setup records and XLedger expense types.
Coming soon. These details are managed through the Labor Type to Expense Type Map Setup. |
|
XLedgerSupplier |
Added CreatedOn (datetimeoffset). Added LastImportedOn (datetimeoffset). |
|
XLedgerSupplierClass |
New table storing reference details for an XLedger supplier. |
|
XLedgerXglToItemCodeMapping |
New admin table storing links between Item Codes and Xgl accounts from XLedger.
Coming soon. These details are managed through the XLedger Item Code Mappings. |
MOVERSSUITE DATABASE SCHEMA RESOURCES: