Schema Changes Version 2016R11

 

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

 

Table

Change

LocalServiceEquipmentRequest

New table storing the equipment requested for a particular local service through the Equipment Request dialog. (7941)

LocalServiceLaborRequest

New table storing the number of workers requested for a particular local service through the Labor Request dialog. (7941)

PlasticCanceledDeal

New internal table storing data of an Electronic Payments record that is cancelled or voided. (7936)

PlasticDeal

New internal table storing the processing data of an Electronic Payments record. (7936)

PlasticInstrument

New internal table storing payment information for an Electronic Payments records. This table includes billing address, token type, customer, and order data. (7936)

PlasticOrigin

New internal table storing the type of transaction action needed to support and identify electronic payments. (7936)

PlasticOriginMapping

New internal table linking a PlasticOrigin record to a PlasticProviderType record along with an assigned ExternalCode for each mapping. (7936)

PlasticProvider

New administrative table storing the data set for an Electronic Merchant Setup record. (7936)

PlasticProviderBranchMapping

New administrative table linking Branch records (Branch Setup) to a PlasticProvider table (Electronic Merchant Setup). (7936)

PlasticProviderType

New table storing the Electronic Service values available to an Electronic Merchant Setup record. (7936)

PlasticTokenAccountType

New internal table storing the account types available to an Electronic Payments, e.g. Credit Card (R), Bank Checking (c), Bank Savings (s). (7936)

PlasticTokenType

New internal table storing the supported merchant types available to an Electronic Payments, and for which Token Account Type the associate, e.g. Visa Credit Card (VC) with Token Account Type linked to Credit Card. (7936)

StatementDetail

Increased the size of the field to 100 characters (from 20) to accommodate a larger confirmation number for Electronic Payments. (7936)

StatementHeader

Added IsPPBatch and IsGp2015Batch flags to identify a payment as related to Electronic Payments or as one related to Microsoft Dynamics GP. (7936)

 

View MoversSuite Database Tables (2016R11)

View MoversSuite Document Database Tables (2016R11)