Table

Change

ApiServiceHtml

Increased the type of HtmlDoc to be nvarchar (max) from varchar (8000) to accommodate larger data storage of Electronic and Online Payments processing (MOV-6905).

PlasticDeal

Increased the size of ResponseCode to 20 characters to accommodate larger data storage of Electronic and Online Payments processing (MOV-6905).

Added HppSessionID to store the session ID associated with a host page when processing Electronic and Online Payments transactions (MOV-6905).

Added MssTransactionID to store the internal transaction identifier associated with Electronic and Online Payments transactions (MOV-6905).

Added CurrencyCode to store the identifier of the currency associated with Electronic and Online Payments transactions (MOV-6905).

Added AuthorizationDate to store date the authorization is valid for authorization submitted through Electronic and Online Payments (MOV-6905).

Added AuthorizationByFID to link the authorization to a SysUser record as the person that submitted an authorization through Electronic and Online Payments (MOV-6905).

Added AuthorizationAmount to store amount of an authorization submitted through Electronic and Online Payments (MOV-6905).

Added AuthorizationTransID to store the identifier for the authorization submitted through Electronic and Online Payments (MOV-6905).

Added AuthorizationMssTransID to store the internal identifier for the authorization submitted through Electronic and Online Payments (MOV-6905).

Added OrderFID to link the authorization submitted through Electronic and Online Payments to an Orders record (MOV-6905).

Added CustomerNumber to link the authorization submitted through Electronic and Online Payments to a specific customer record (MOV-6905).

Added OrderFID to link the authorization submitted through Electronic and Online Payments to a Branch record (MOV-6905).

Added FinalizedDate to record the date that an authorization was captured through Electronic and Online Payments (MOV-6905).

Added FinalizedByFID to record the SysUser that captured the authorization through Electronic and Online Payments (MOV-6905).

PlasticInstrument

Added BillingAddress2 to store the second line of a billed address sent through Electronic and Online Payments (MOV-6905).

Added ExpirationDate to store the date a card expires. This value is visible through the Recurring Payment Processing screen available for Electronic and Online Payments (MOV-6905).

Added ConversionFID to store the temporary identifier needed when exporting and importing tokens for a new merchant account, refer to  Electronic and Online Payments (MOV-6905).

PlasticProvider

Added AllowAuthorizations to store what is set for the Allow Authorizations on Credit Cards flag within Electronic Merchant Setup to support Electronic and Online Payments (MOV-6905).

Added WarningCaptureDays to store what is set for the Number of Days Authorization Warning setting within Electronic Merchant Setup to support Electronic and Online Payments (MOV-6905).

Added MaxCaptureDays to store what is set for the Maximum Number of Days for Authorization setting within Electronic Merchant Setup to support Electronic and Online Payments (MOV-6905).

PlasticProviderType

Added SupportsAuthCapture flag. This is an internal flag indicating that the provider allows authorizations (if set) for credit card payment methods set up for Electronic and Online Payments (MOV-6905).

PlasticTokenAccountType

Added IsCreditCard flag. This is an internal flag indicating that the account is a credit card (when set) for credit card payment methods set up for Electronic and Online Payments (MOV-6905).

Storage

Added FirstRecurringTransInstrumentFID to link a storage billing record to identify the primary method set on an order. This value also links to the StoragePaymentTransactionTracking table needed when converting tokens from one merchant to another for Electronic and Online Payments (MOV-6905).

Added FirstRecurringTransID to capture the readable transaction identifier assigned to a storage billing record to identify the primary method set on an order. This value also links to the StoragePaymentTransactionTracking table needed when converting tokens from one merchant to another for Electronic and Online Payments (MOV-6905).

Validation

Added ExpirationDateUtc to store credit card expiration dates when validating the instrument for use with Electronic and Online Payments (MOV-6905).

PlasticDealAuthorization

New table storing the deal mappings for authorized credit cards used within Electronic and Online Payments (MOV-6905).

PlasticProviderHppAllowedTokenType

New table storing the various types of tokens supported for a provider for use within Electronic and Online Payments (MOV-6905).

PlasticProviderHppOptions

New table storing the values set for options managed through the Color Selector for use within Electronic and Online Payments (MOV-6905).

PlasticProviderTypeAllowedTokenType

New table storing the various types of tokens supported for a provider for use within Electronic and Online Payments (MOV-6905).

PlasticProviderTypeTokenType

New table storing the various types of tokens supported for a provider for use within Electronic and Online Payments (MOV-6905).

PlasticProviderTypeTransactionErrorProcessing

New table to store error information for reprocessing Electronic and Online Payments (MOV-6905).

StoragePaymentTransactionTracking

New table storing information needed when transferring tokens from one merchant account to another for use within Electronic and Online Payments (MOV-6905).