Table

Change

LocServ

Updated CapacityBucketFID. Changed the field size from 16 to 64 characters to accommodate a larger Sort1 value within the Dispatch Center. (4964)

PlasticDeal

Updated TransactionCode. Changed the field size from 25 to 50 characters to accommodate a larger transaction identifier associated to an Electronic and Online Payments transaction. (4955)

Removed ReferenceNumber. This value is now stored within the TransactionID column provider. (4955)

Added TransactionID. New column storing the external transaction identifier for an Electronic and Online Payments transaction. (4955)

PlasticProvider

Added PaymentNoteTypeID. New column storing the external identifier for the type of payment note processed. (4955)

PlasticWebDeal

Added PaymentNotification. New column storing the setting associated to the Request Payment Notification flag within the Setup Credit Card/Bank Online Payment screen.

PlasticWebProvider

Removed OnlinePaymentNoteTypeFID. This column moved to the   PlasticProvider table. (4955)

PointToPointType

New internal table providing the options available to the Point To Point Type option within Rate Plan Setup. (4942)

RatePlans

Added PointToPointTypeFID. New administrative column storing the entry selected for the Point To Point Type within Rate Plan Setup. (4942)

Rates

Added Section. New administrative setting storing the entry made for the Section within Add Rate. (4942)

Added OriginStateFID. New administrative setting storing the entry selected for the Origin State within Add Rate. (4942)

Added DestinationStateFID. New administrative setting storing the entry selected for the Destination State within Add Rate. (4942)

Added OriginAirportFID. New administrative setting storing the entry selected for the Origin Airport within Add Rate. (4942)

Added DestinationAirportFID. New administrative setting storing the entry selected for the Destination Airport within Add Rate. (4942)

Added OriginCountryFID. New administrative setting storing the entry selected for the Origin Country within Add Rate. (4942)

Added DestinationCountryFID. New administrative setting storing the entry selected for the Destination Country within Add Rate. (4942)

Added OriginPostalCode. New administrative setting storing the entry made for the Origin Postal Code within Add Rate. (4942)

Added DestinationPostalCode. New administrative setting storing the entry made for the Destination Postal Code within Add Rate. (4942)

Added MinCharge. New administrative setting storing the entry made for the Minimum Charge within Add Rate. (4942)

Added MaxCharge. New administrative setting storing the entry made for the Maximum Charge within Add Rate. (4942)

Added Note. New administrative setting storing the entry made for the Notes within Add Rate. (4942)

Added ForeignID. New administrative setting storing the entry made for the Foreign ID within Add Rate. (4942)

SystemEmail

Updated Subject, BodyText, and HyperlinkText to nvarchar from varchar and set the length of BodyTextto max from 4096 to accommodate new email usage associated to an Electronic Payments with email notifications. (4955)

SystemEmailType

Updated DefaultSubject, DefaultBodyText, and DefaultHyperlinkText to nvarchar from varchar and set the length of DefaultBodyTextto 4000 from 4096 to accommodate new email usage associated to an Electronic Payments with email notifications. (4955)