Schema Changes Version 2016R13

 

The following table lists changes made to the MoversSuite database for this particular release.

 

Table

Change

ClaimStatus

Added LoadByDefault. New administrative setting that allows a company to determine which claims records appear by default when the Claims grid loads. This field stores the value set for the Load By Default setting within Claim Status Setup. (8229)

MoversConnectSetup

Added ExternalAccountIdentifier. This field is referenced by the Electronic Payments process to identify the messages a merchant service provider sends through MoversConnect. (7971)

PlasticBatchStatus

New table storing the status of Electronic Payments records processed through Recurring Billing. (7971)

PlasticDeal

Added StorageInvoiceFID. Links an Electronic Payments record to a particular storage invoice record. (7971)

Added BatchStatusFID and BatchErrorCodeFID. Links an Electronic Payments record to storage billing status and error code records. (7971)

Added WasReprossed. New internal flag that tracks when an Electronic Payments was reprocessed through a storage billing run. (7971)

Storage

Added EmailAddresses. This new field stores the email addresses linked to a storage billing record through the Payment Setup tab within Recurring Billing. (7971)

Added InstrumentFID. This new field links the storage billing record to a particular PlasticInstrument record, which is the payment record saved within the Payment Setup tab within Recurring Billing. (7971)

StorageInvHistCrBatch

New table storing information on invoices, branch, storage type, and statement information for a Recurring Billing run. (7971)

StorageInvoice

Added StorageFID. Link a Storage (Recurring Billing) record to a particular storage billing invoice. (7971)

StorageInvoiceHistorical

Added PaymentCount. New field storing the number of times a storage invoice was billed and paid. (7971)

StorageType

Added ShortDescription. New administrative field storing the text set for the Short Description (30 characters) setting within Storage Type Setup. This field is referenced for the invoice and payments made through Recurring Billing and allows the batch to process through Payment Management (description is limited to 30 characters). (7971)

 

View MoversSuite Database Tables (2016R13)

View MoversSuite Document Database Tables (2016R13)