Takes one parameter, QueryName

Description:

Creates a new Query Object, named as per the QueryName parameter, with the correct Fields to be used with the ProcECom command.

Input and Output Fields

The following Fields are mandatory inputs:

• ECom.Provider (must be set to "Moneris")
• ECom.EComKey (must be provided by Cnawlece Incorporated)
• ECom.StorePwd (the Store's current password)
• ECom.MerchantRefNum (your system's own reference number)
• ECom.Amount
• ECom.CardNum
• ECom.CardExpiryMonth (two digits)
• ECom.CardExpiryYear (two or four digits)
• ECom.CVD (the three digits on the back of the card)
• ECom.FirstName
• ECom.LastName
• ECom.Street
• ECom.City
• ECom.State
• ECom.Country (two letter code such as CA or US. Values of Canada, USA, United Sates, and United States of America are auto-swapped to the correct two letter code)
• ECom.Zip
• ECom.Phone
• ECom.Email

The following Fields are used as Return values. Typically, check that ECom.Err is blank, then act on the value of ECom.Decision, and if Declined, display the value of ECom.Description. When Approved, be sure to save ECom.ConfirmationNumber.

• ECom.Err (should be checked first, and should be blank if all is good)
• ECom.Complete (should be non-zero, below zero indicates an error, a value of 1 indicates complete.)
• ECom.ConfirmationNumber (when approved, this should be saved)
• ECom.Decision (if no error, will be either Approved or Declined)
• ECom.Code (as provided by Moneris)
• ECom.ActionCode (as provided by Moneris)
• ECom.Description (as provided by Moneris but cleaned up to display to user)
• ECom.AuthCode (as provided by Moneris)
• ECom.TxnTime (as provided by Moneris)

The following Fields are optional inputs:

• ECom.Test (leave blank for normal operation, set to 1 to use test server)
• ECom.Util (will be preserved and returned. Note that any other Fields that are not part of the ECom system will be lost when ProcECom is called)
• ECom.CVDIndicator (leave blank to use CVD as normal, other values as per Moneris)
• ECom.CardPayMethod (leave blank to use WEB as normal, other values as per Moneris)

ECommerce and Merchant Accounts

As per the Moxie License Agreement, the ECom system in Moxie is tied directly to one or more service providers supported by Cnawlece Incorporated. At present, the sole provider is Moneris. A Credit Card Merchant Account by Moneris is resold by Cnawlece Incorporated, whom receives commission for this sale. The proceeds from this commission pay for the development of Moxie; which is otherwise provided free of charge.