Table

Change

PlasticDeal

Updated Cost by increasing its size to 15 characters from 1.

Updated TransactionID by increasing its size to 30 characters from 40.

Added PurchaseOrderNo. This field stores a Purchase Order that associates with a Remedy transaction (up to 50 characters). This setting does not display in MoversSuite.

All changes were made to support Remedy Payments. (MOV-6442)

PlasticInstrument

Added HolderLastName to store the last name separately for Remedy Payments (up to 500 characters).

Added BillingCountry to store the country of a billing transaction address for Remedy Payments (up to 255 characters).

Added GatewayCustomerID to store the ID associated to an Electronic Merchant Setup record for a Remedy Payments (up to 40 characters).

All changes were made to support Remedy Payments. (MOV-6442)

PlasticProvider

Updated AccountCode by increasing its size to 20 characters from 50.

Added ClientID. This stores the value entered for the Merchant Gateway Code on an Electronic Merchant Setup record (up to 1000 characters).

Added DisableNewInstruments. This stores the flag set for Inactive under the Merchant’s Active Status on an Electronic Merchant Setup record.

Added DisableNewSales. This stores the flag set for Disable New Sales and New Online Links under the Merchant’s Active Status on an Electronic Merchant Setup record.

Added PreferenceOrder. This stores the value set for Merchant Preference Order on an Electronic Merchant Setup record.

Added CurrencyCode. This stores the value set for Currency Code on an Electronic Merchant Setup record.

Added UseProductionUrl. This stores the value set for the Use Production URL Order flag on an Electronic Merchant Setup record. When this flag is checked, the application assumes that the active payment record is pointing to the live merchant system. Uncheck this option to point to a test URL.

Added CalculateBestGuessDepositDate. This stores the value set for the Set Deposit Date Using Business Days Only flag on an Electronic Merchant Setup record.  Checking this flag allows you to set other items to estimate the deposit date of a charge or refund transaction.

Added AdjustmentDays. This stores the value set for the Add This Many Business Days setting on an Electronic Merchant Setup record.  This value is added to the transaction date to determine what you want recorded as an actual deposit date. Remedy does not provide the actual posting date, therefore we need to know this in order to determine when to expect the deposit for cash receipts.

Added CutoffTime. This stores the value set for the Daily Deposit Auto Close Time setting on an Electronic Merchant Setup record. This is the anticipated date that transaction receipt should be processed on. This time should be less than the cutoff time for the provider. For example, Remedy processes transaction batches at 7:00 p.m. Pacific Time, so you should submit a batch prior to this time, e.g., 6:00 p.m. Mountain Time.

Added IsSaturdayBusinessDay. This stores the value set for the Deposits Are Credited on Saturday flag on an Electronic Merchant Setup record.  If the merchant provider processes deposits on Saturdays, then check this flag.

Added IsSundayBusinessDay. This stores the value set for the Deposits Are Credited on Sunday flag on an Electronic Merchant Setup record.  If the merchant provider processes deposits on Sundays, then check this flag.

Added AdjustForHolidsays. This stores the value set for the Deposits Are Credited on Saturday flag on an Electronic Merchant Setup record.  If the merchant provider does not process payments on certain holidays, then check this flag and verify that holidays you define in Holiday Setup matches what the provider supports.

All changes were made to support Remedy Payments. (MOV-6442)

PlasticProviderBranchMapping

Added ProviderTypeFID linking a Branch Item set within Electronic Merchant Setup to the electronic service provider.

This changes was made to support Remedy Payments. (MOV-6442)

PlasticProviderType

Added Brand (up 10 characters).

Added ProdHppBaseURL (up 255 characters).

Added TestHppBaseURL (up 255 characters).

Added GatewaySubDir (up 50 characters).

Added UseSeparateNameFields (flag).

Add new fields store internal assignments necessary to support an Electronic Service set for an Electronic Merchant Setup record.

All changes were made to support Remedy Payments. (MOV-6442)

PlasticTokenTypeGatewayMap

New table storing internal values associated to a Remedy Payments transaction record. (MOV-6442)

PlasticWebDeal

Added SysEmailTypeCode to internally store the type of email that was sent out as part of an Online Payments transaction. This value relates back to System Email Setup values and was added as part of the project to support Remedy Payments. (MOV-6442)

PlasticWebDealDetail

Added OnlineResponseFID to internally store the ID of a response stored in MoversConnect as part of an Online Payments transaction. This value corresponds with what displays in the Electronic Merchant Payment Research screen and was added as part of the project to support Remedy Payments. (MOV-6442)

StatementHeader

Added ProviderTypeFID linking a cash receipt batch to an electronic service provider as defined in Electronic Merchant Setup.

This change was made to support Remedy Payments. (MOV-6442)

StorageInvHistCrBatch

Added ProviderTypeFID linking a cash receipt batch for a storage run to an electronic service provider as defined in Electronic Merchant Setup.

This change was made to support Remedy Payments. (MOV-6442)

SystemEmailType

Updated TypeDescription by increasing its size to 40 characters from 30 to accommodate the “Deactivated Electronic Merchant” email title available through System Email Setup.

This change was made to support Remedy Payments. (MOV-6442)

Validation

New table storing internal values associated to a Remedy Payments transaction record. (MOV-6442)