WorldPay支付网关设计说明.doc

WorldPay支付网关设计说明需求概要说明1、 新增加WorldPay支付网关2、 运营商在选择该支付网关时填写该支付网关的相关信息。3、 用户在进行信用卡支付时，会根据用户所在的业务组所设定的支付网关进行支付。数据库结构1. WorldPay (VSP WorldPay 支付信息)说明：该表用于记录VSP所使用WorldPay支付网关的信息。NameFotmatRequestCommentsIDIntYesPrimary keyVMIDIntYesVSP IDInstallationIDInt(11)YesLogin into the WorldPay Administration Server. You can find the Installation ID in the lower right hand corner of the screen.CallBackPWVarcharYesThe callback password, if you have set it in the WorldPay database viaCMS. This is only available in the parameters sent in the callback. It isnot available for substitution into the page sent to the shopper.StatusInt(11)YesPaymentGateway status 1 normal 0 pause参数说明1.传递的参数列表NameFormatValuesCommentsinstIdIntInstallation ID Login into the WorldPay Administration Server. You can find the Installation ID in the lower right hand corner of the screen.cartIdVarcharA parameter for your own reference which allow you to track the order. It is returned to the merchant by email and / or server callback depending on how you have chosen be informed of the purchase.testmode Numeric.0,100,101For live transactions testMode is set 0. For normal testing which always results in a successful authorisation for the order, this is set to 100.For test non successful transactions the value is set to 101.Can be used by the merchant to put the account in to test mode. This allows test purchases to be made without using a credit cart.For normal testing which always results in a successful authorisation for the order, this is set to 100.For test non successful transactions the value is set to 101.For live transactions testMode is set 0. currencyAlphanumeric3 charactersA 3 letter ISO code representing currency used for payment. For example USD represents United States dollars, GBP British pounds and EUR Euros.A 3 letter ISO code representing currency used for payment. For example USD represents United States dollars, GBP British pounds and EUR Euros.descAlphanumericMax 100 charactersFree text description of goods orservices being purchasedA brief description of the items ordered (up to 255 characters). This is used in the order page, statements and emails for merchant and customer. If the description is more than 255 characters then the full details are sent via email.amountNumeric4 charactersA decimal number used by the shopping cart giving the total cost of the purchase in terms of the currency unit chosen by the merchant.2.返回的参数列表NameFormatValuesCommentstestMode intFor live transactions testMode is set 0. For normal testing which always results in a successful authorisation for the order, this is set to 100.For test non successful transactions the value is set to 101.Can be used by the merchant to put the account in to test mode. This allows test purchases to be made without using a credit cart.For normal testing which always results in a successful authorisation for the order, this is set to 100.For test non successful transactions the value is set to 101.For live transactions testMode is set 0. authCostvarcharA decimal number used by the shopping cart giving the total cost of the purchase in terms of the currency unit chosen by the merchant.currencyvarcharA 3 letter ISO code representing currency used for payment. For example USD represents United States dollars, GBP British pounds and EUR Euros.addressvarcharThe postal address ofthe shopper, asentered on thepayment form.countryStringvarcharThe full name of the country, derived from the country code submittedto initiate this purchase or supplied by the shoppercallbackPWVarcharThe callback password, if you have set it in the WorldPay database viaCMS. This is only available in the parameters sent in the callback. It isnot available for substitution into the page sent to the shopper.installationvarcharThe installation IDfaxvarcharThe fax number of theshopper, as enteredon the payment form.countryMatchvarcharY : matchN : no match (ie. mismatch)B : comparison not availableI : contact country not suppliedS : card issue country not availableA single character describing the result of the comparison of theshoppers contact country (where supplied) and the issue country of thecard used by the shopper (where available). Note that this parameter isretained for backward compatibilty - equivalent information is nowprovided as part of the AVS results (see AVS below).transIdVarcharThe WorldPay ID for this transactionAVSvarcharA 4-character string giving the results of 4 internal fraud-related checks.The characters respectively give the results of the following checks:amountStringvarcharAn HTML string produced from the amount and currency that weresubmitted to initiate this purchasepostcodevarcharThe postal code of theshoppers address, asentered on thepayment form.msgTypevarcharauthResultnamevarcharThe name of theshopper, as enteredon the payment form.telvarcharThe telephone numberof the shopper, asentered on thepayment form.transStatusVarcharResult of this transaction - Y for a successful payment authorisation,C for a cancelled payment (note that as a customer you will never seea declined payment as the shopper is always given the option ofretrying with another means of payment, or else cancelling thepayment).descIntCustomer IDcardTypeVarcharThe type of card used by the shopper.langvarcharShoppers language choice as 2 character ISO 639 code, withoptional regionalisation using 2 character country code separated byhyphen. For example en-GB specifies UK English. The shopper canalways choose a language on the WorldPay pages or via browserpreferences but if your site has already made this choice then youcan make things more convenient by submitting it to us.transTimeLong intTime of this transaction in milliseconds since the start of 1970 GMT. Thisis the standard system date in Java, and is also 1000x the standard Ctime_t time.authAmountStringVarcharHTML string produced from authorisation amount and currencyauthAmountdecimalAmount that this transaction was authorised for, in the currency givenas authCurrency.ipAddressvarcharThe ip address of shopper costvarcharA decimal number giving the cost of the purchase in terms of themajor currency unit e.g. 12.56 would mean 12 pounds and 56 penceif the currency were GBP (Pounds Sterling). Note that the decimalseparator must be a dot (.), regardless of the typical languageconvention for the chosen currency. The decimal separator does notneed to be included if the amount is an integral multiple of the majorcurrency unit. Do not include other separators, for example betweenthousands.instIdVarcharThe WorldPay ID for this installationamountvarcharA decimal number giving the cost of the purchase in terms of themajor currency unit e.g. 12.56 would mean 12 pounds and 56 penceif the currency were GBP (Pounds Sterling). Note that the decimalseparator must be a dot (.), regardless of the typical languageconvention for the chosen currency. The decimal separator does notneed to be included if the amount is an integral multiple of the majorcurrency unit. Do not include other separators, for example pNamevarcharName of the company associated with this installation countryvarcharThe 2-letter ISO codefor the country of theshopper, as selectedon the payment form.rawAuthMessageVarcharText received from the bank (typically including an authorisation code,or a reason for failure).emailvarcharThe email addressthe shopper, asentered on thepayment form.authCurrencyVarcharThe currency used for authorisation.rawAuthCodeVarcharA single-character bank (or internal WorldPay) authorisation code. Thisis retained for backward compatibility. A means authorised and isdirectly equivalent to transStatus=Y. Failed transactions may have avariety of auth codes which are usually explained more fully in therawAuthMessage parameter.cartIdvarcharThe unique referencesupplied by themerchant at the timeof the transaction.authModevarcharSpecifies the authorisation mode to use. This is only needed if youhave accounts with different authorisation modes, in order to specifywhich type of account to use. If there is no account with a matchingauthMode then the transaction is rejected. The values are A for afull auth, or E for a pre-auth. In the response, this parameter canalso take the value O when performing a post-auth (on