o e+@s6ddlZddlZddlmZmZGdddejZdS)N) migrationsmodelsc=@s,$eZdZdZgZejddejdddddfdej e j dddfd ej e jjjdd fd ej e jjjdd fd ejgd dddfdejddddfgdejddejdddddfdej e j dddfdejddddfgdejdgdejdddddfdej e j dddfd ej ddddfdejddddd fd!ejdd"d#d$d fd%ejdd&d&d'fd(ejdd)dd*d+fd,ejdd-d.d-d fd/ejdd0d.d0d fd1ejdd2d3d'fd4ejdd5d.d6d fd7ejdd8d#d9d fd:ejdd;dddd?d+fd@ejddAddBdCfdDejddEddFd+fdGejddHddIdCfdJejddKddLd+fdMejddNdOd'fdPejddQddRd fdSejddTddUd fdVejddWddXd fdYejddZdd[dCfd\ejdd]d#d]d fd^ejdd_dd`dCfdaejddbd.dcd fddejdddedffdgejdddhdffdiejdddjdffdkejdddldffdmejdddndffdoejddpdqddpdrfdsejdddtdffduejdddvdffdwejdddxdffdyejdddzdffd{ejddd|dffd}ejddd~dffdejddddd+fdejddddd+fdejddddd+fdejddddd+fdejdddqdd fdejddddd+fdejddddd+fdejddddffdejddddffdejddddffdejddddffdejddddfdejdddddCfddddejddejdddddfdej e j dddfdejdddddCfdejdddddCfdejdddddCfdejdddddCfdejdddddCfdejdddddCfdejdddddCfg dejddejdddddfdej e j dddfd ej ddddfdejddd.dd fdejddd.dd fdejdddddCfdejdddčfdejdddd'fdejddddd fdejddd#dd fdejddd.dd fdejddd.dd fdejddd#dd fdejddd#dd fdejddddd fdejddgddfdejddfgddddejddejdddddfdej e j dddfdejdddddCfdej e jjjddčfdejdgddd#dddfdejdddgdddddfdejddd#dddrfgdejddejdddddfdej e j dddfd ej ddddfdejddddd+fdejddd.dd fdejddd.dd fdejddd.dd fdejddd.dd fdejdddd'fdejddddd fdejddd#dd fdejddd.dd fdejdd d.d d fdejddd.dd fdejddd#dd fd ejdd dd dCfdejddd.dddrfd\ejdd]d#d]d fdejdddddCfdejddd.dddrfdejddddd+fdejddddd+fdejddddd+fd ejdd!d"d'fd#ejdddʐd$d fd%ejddd#d&d fd'ejddd.d(d fd)ejdd d.d*d fd+ejddd.d,d fgd-d.ddejd/dejdddddfdej e j dddfd0ejdd1dd1d fd4ejddd5dffgdejd2dejdddddfdej e j dddfd ej ddddfdejdd3d#dd fdejdd4d#dd fd5ejdd6d7d8d fdejddd#dd fd ejdd d#d d fd9ejdd:d;dd<d=fd>ejgd?d@dAddAdBfg dCdDddejdEgdejdddddfdej e j dddfdFejddGdGd'fdHejddId.dId fdJejddKd.dKd fd ej e jjjdd fdLejddMd.dMd fdNejddOd.dOd fdPejdddQdffd\ejdd]d.d]d fdRejddSdTd'fdUejddSdVdSd fdWejddXd.dXd fdYejddZd.dZd fd[ejddd\dffd]ejddd^dffd_ejddd`dffdaejdddbdffdcejdddddffdeejdddfdffdgejdddhdffdiejdddjdffdkejdddldffdmejdddndffdoejdddpdffdqejdddrdffdsejdddtdffduejdddvdffdwejdddxdffdyejdddzdffd{ejdd|dčfd}ejdd~dčfdejdgddddfdejddddffdejddd.dd fdejddd.dd fdejddddffdejddddffdejddddffdejddddffdejgdddfdejdddčfdejddddffdejdddčfdejdgdejdddddfdej e j dddfdFejddGdGd'fdHejddId.dId fdJejddKd.dKd fdLejddMd.dMd fdNejddOd.dOd fdPejdddQdffd[ejddd\dffdsejdddtdffduejdddvdffdwejdddxdffdaejdddbdffdyejdddzdffdeejdddfdffdgejdddhdffdiejdddjdffdmejdddndffdoejdddpdffdqejdddrdffd{ejdd|dčfd}ejdd~dčfd\ejdd]d.d]d fdRejddTdTd'fdUejddSdVdSd fdWejddXd.dXd fdejdgddddfdejddddffdejddd.dd fdejddd.dd fdejddddffdejddddffdejddddffdejgdddfdejdddčfdejddddffdYejddZd.dZd fd]ejddd^dffd_ejddd`dffdcejdddddffdkejdddldffdejdddčfdejddddffdejddejdddddfdejdddfdejddd7dd fdejddd#dd fdej de jjjdddd=fdejdddddfdejddd.dd fdejdddVdd fdejdddVdd fdejdddddfdejdddddfg ddddejddejdddddfdej e j dddfd ej e jjjdd fdejddd.dd fdejddd.dd fdejddd.dd fdejdd8d7d8d fdejdddd'fdejddd.dd fdejddd.dd fdejddd.dd fdejddd#dd fg dejddejdddddfdej e j dddfd ej e jjjdd fdejddd.dd fdejddːdd'fdejddd.dd fdejddd.dd fdejdddӐdԐdՍfgdejddejdddddfdej e j dddfdejdؐdgdʐdڐdۍfdejddd.dd fdejddd#dd fdejddd#dd fdejddddffgdejddejdddddfdej e j dddfdejd6dfdej e jjjddčfgdejddejdddddfdej e j dddfd ej e jjjdd fdejddd.dddrfdejddd.dddrfdejdddddCfdejdddddCfdejddddffdejddddffdejddddffdejddddffdejddd.dddrfdejdddddCfdejddddffdejgddʐddۍfgdejddejdddddfdej e j dddfd ej e jjjdd fdejddd.dd fdejddd.dd fgdejddejdddddfdej e j dddfdejddddd+fdejdؐdgdddۍfdejddd.dd fd ejdd d7d d fd ejdd d.d d fd ejddd.dd fgdejddejdddddfdej e j dddfd ej e jjjdd fdejddd.dd fdejddgddfdejddddffgdejddejdddddfdej e j dddfdejddddfdejdddfdej e jjjddčfdejd d.d d!fd"ejd#d#dfd$ej e jjjddčfgdejd%dejdddddfdej e j dddfd ej ddddfd&ejdd'd'd'fd(ejdd)d#d*d fd+ejdd,d-d'fdejddd#dd fdejddd#dd fdejddd#dd fd.ejdd/d#d0d fd1ejdd2d.d2d fd3ejdd4d#d5d fd6ejdd7d.d8d fd9ejdd:d#d;d fdd fd?ejdd@d#dAd fdBejddCd.dDd fdejddfgdEdFddejdGdejdddddfdej e j dddfd ej ddddfdHejddIddJd fdKejddLddMd+fdNejddOddPd+fdQejddRddSd+fdTejddUddVd fgdWdXddejdYdejdddddfdej e j dddfdZejdd[d[d'fdejd\d]d.dd^fd_ej e jjjddčfd`ejddaddbd+fdcejddddded+fdfejddgddgd+fdhejddiddjd+fg dejdkdejdddddfdej e j dddfdlejdddmdndՍfdoejddpdčfdqejgdrdsdtdۍfgdudvddejdwdejdddddfdejddd#dd fdejddd#dd fdxejdddd'fdejddd#dd fdejdd d#d d fdejddd#dd fdejddydzdd fd{ejdd|d#d|d fd5ejdd8d7d8d fd}ejdd~d#d~d fdejddd#dd fdYejddddZd+fdejddddd+fdejddddd+fdejddddd+fdejddddd+fdejdddd'fdejddd.dddrfdejddddfdejdddd'fdejddd.dd fdejddd.dd fdejddd.dd fd(ejdd*d#d*d fdejddd.dd fdBejddDdDd'fdejdddd'fdejdddd'fgdgZd:S( MigrationT ApplicationidFID) auto_created primary_key serialize verbose_nameuid)defaulteditableunique created_at)r r updated_atstatus) )INC Incomplete)SUB Submitted)MAQz Manual Query)REJRejected)STBz Send To Bank)RARz Rate Received)AUWzApprove By Underwriter)ABAzApprove By Admin)AAIzApprove By Admin By Pass Iso)ABIzApprove By Iso)NEG Negotiable)ABMzApprove By Merchantr)choicesr max_lengthreasonrReason)r help_textnull)namefieldsAssignToApplicationUnderwriterdatez&Assign To Application Underwriter Date)blankr(r)BP)r.rr)description_of_productsz.Detailed description of products/services soldzDescription Of Products)r.r(r%r length_of_time_businesszLength of time in businesszLength Of Time BusinesswebsiteWebsite)r.r(r login_detailsz Login detailsz Login Details)r r(r)r usernameUsername2passwordPassword beta_websitez Beta websitez Beta Website descriptor Descriptor Description city_fieldzDBA/City fieldz City Fielddynamic_descriptorsz#Will you use 'Dynamic Descriptors'?zDynamic Descriptionfield_for_bankruptcyz"Have you ever field for bankruptcyzField For Bankruptcyfield_for_bankruptcy_datezField for bankruptcy datezField For Bankruptcy Date)r.r(r)r accepted_credit_cardsz*Have you previously accepted credit cards?zAccepted Credit Cardsaccepted_credit_cards_monthszAccepted credit cards monthszAccepted Credit Cards Monthscard_scheme_programzFHave you ever flagged or been in violation of any card scheme program?zCard Scheme Program#card_scheme_program_provide_detailsz#Card scheme program provide detailsz#Card Scheme Program Provide Details!previous_payment_service_providerz1Current/previous Payment Service Provider/gatewayz!Previous Payment Service Providerprevious_acquirerzCurrent/previous accquirerzPrevious Acquirerleaving_current_acquirerz#Reason for leaving current acquirerzLeaving Current Acquirermonthly_sales_volumezEstimated monthly sales volumezMonthly Sales VolumecurrencyCurrencyavg_transaction_valuezAverage transaction valuezAverage Transaction Valuehighest_transaction_valuezHighest transaction valuezHighest Transaction ValuedomesticDomestic)r.r)r europeEuropeusaUSAasiaAsia rest_of_worldz Rest Of Wold card_detailsz Card Detailsi)r.r(r%r)r e_commercez E-Commerce card_presentz Card Presentm_poszM-POS m_commercez M-CommercemotoMotoin_app_commercezIn App Commerce upon_purchasez Upon Purchase with_downloadz With downloadz With Download on_deliveryz On deliveryz On DeliveryothersotherOthers other_detailsz Other Detailsone_time_paymentzOne Time Paymentrecurring_paymentzRecurring Payment immediately Immediatelywithin_four_weekszWithin Four Weekswithin_5_14_weekszWithin 5 14 Weeksmore_than_14_weekszMore Than 14 Weeks do_you_offerz,Do you offer/make use of affiliate programs?z Do You Offer)r r(r provide_detailszmake use of affiliate programszProvide DetailszBusiness profilezBusiness profiles)r verbose_name_plural)r*r+optionsCCPHnumber_of_transactionzNumber of transactionzNumber Of Transactiontransaction_volumezTransaction volumezTransaction Volumenumber_of_chargebackzNumber of chargebackzNumber of Chargebackchargeback_volumezChargeback volumezChargeback Volumenumber_of_refundszNumber of refundszNumber Of Refunds refund_volumez Refund volumez Refund Volume months_agoz Month agoz Month AgoCOP first_namez First Name last_namez Last Name date_of_birthz Date of birthz Date Of Birth ownershipg Ownership)r r street_addresszStreet addresszStreet Address house_numberz House number z House Numberzip_codezZip codezZip CodecityCitycountryCountrytelephone_numberzTelephone numberzTelephone NumberpassportzPassport/ID numberPassportsocial_security_numberzSocial security numberzSocial Security Numbercop_type)Director)UBOzCOP Type)r$r is_active)r zCompany ownership profilezCompany ownership profiles CouponCodeqbQuantity Basedtb created_onqtb))Qr)Tz Time Based)QTQuantity and Time Basedr)r.r$r(r%r)r cctFFlatP PercentagezCoupon Code Typeccz Coupon CodeCPhaving_parent_companyz.Is Applying Company owned by a Parent Company?zHaving Parent Companycompany_registration_nozCompany registration numberzCompany Registration Numberlegal_company_namezLegal company namezLegal Company Name trade_namez4Registered DBA/trade name (if other than legal name)z Trade Name business_typez1Type of business (LLC, Ltd, Sole Proprietor, etc)z Business Typeregistered_street_addressz3Registered street address (P.O. Box not acceptable)zRegistered Street AddresszPostcode / zip codestatez (if applicable)State fax_numberz Fax numberz Fax Numberturnover_last_yearz"Turnover last year (plus currency)zTurnover Last Yearincorporation_datezIncorporation date 1 (YYYYMMDD)zIncorporation Datetax_identification_numberzVAT / Tax Identification numberzTax Identification Numberstock_exchangez/Is company publicly listed on a stock exchange?zStock Exchangenot_for_profitu:Is company a registered ‘not-for-profit’ organization?zNot For Profitbilling_registered_addressz5Is billing address different from registered address?zBilling Registered Addressbilling_street_addressz%Street address (for billing purposes)zBilling Street Addressbilling_house_nozBilling House Numberbilling_post_codezBilling Post Code billing_cityz Billing City billing_statez Billing Statebilling_countryzBilling CountryzCompany profilezCompany profilesManualQueryTemplatetitleTitleMCz First namez Last name email_addressz Email addressz Email Address further_infoNzBPlease let us know if you have any further comments or informationz Further Info)r.r r(r)r contact_type))rzGeneral Contact)rzTechnical Contact)r#zFinancial Contact)zChargeback Contact)zAdditional Comments1z Contact Type)r$r r(r%r zMerchant contactzMerchant contactsMerchantBankBuyRateacquiring_bank_fieldzAcquiring Bank Fieldacquiring_bankzAcquiring Bankgenerated_namezGenerated Namemerchant_category_codezMerchant Category Code merchant_typez Merchant Type setup_chargez Setup Chargepayment_services_fieldzPayment ServiceszPayment Services Fieldpayment_services settlement Settlement credit_cardz Credit Card reserve_ratez Reserve Rate monthly_feesz Monthly Feesgateway_transaction_feeszGateway Transaction Feesfraud_scrub_feeszFraud Scrub Feesmonthly_maintenance_feeszMonthly Maintenance Fees batch_uploadz Batch Upload refund_chargez Refund Chargewire_domestic_feeszWire Domestic Feeswire_internationalzWire Internationalchargeback_charge_0_2zChargeback charge 0 2chargeback_charge_2_5zChargeback charge 2 5chargeback_charge_5_10zChargeback charge 5 10 gateway_feesz Gateway Feesgateway_monthly_feeszGateway Monthly Feesreturn_chargeszReturn Chargesverification_feeszVerification FeesallowAllow cash_discountz Cash Discount split_rates))rr)r Recurring)r#Splitz Split Rates)r.r$r)r valueValuemaximum_ticket_sizezMaximum Ticket Sizeminimum_ticket_sizezMinimum Ticket Sizereject_percentzReject Percentdeclined_percentzDeclined Percentrefund_percentzRefund Percentchargeback_percentzChargeback Percent block_type))rcount)rr)r#bothz Block Typevirtual_terminalzVirtual Terminaltransaction_feeszTransaction Feesload_balancingzLoad BalancingMerchantBankSaleRateMerchantSettingmidz Merchant ID)r.r(emailzMerchant EmailEmailphonezMerchant Phone NumberPhonedate_time_stampzMerchant Date Time StampzDate Time Stamp terminal_idz Terminal IDz Terminal id)r.r r(r bank_credentialzBank Credential test_api_keyz Test API Keyproduct_api_keyzProduct API Key internal_midz Internal Midz Internal midchargeChargezMerchant SettingzMerchant Settings NewCustomerfnlnpnz Phone NumberedadAddresscnz City Namesnz State Namecnnz Country Namezp NewProductz Product NamepdzProduct DescriptionpczParent CategoryzProduct CategoryptTaxesz Product Taxpi product_imagez Product Image)r.r) upload_tor NewProductPricempie)I Inclusive)E Exclusivez'MRP Price Including Inclusive/Exclusive)r$r%r psz Package SizemtzMeasurement Typespz Selling PriceNote description)r( PointOfSalesiz Search ItemccnzCustomer Contact NumbercazCustomer AddressqtyQuantityppz Pri cestz Sub TotalgstGSTgtz Grant TotalivczInvoice Numberivdz Invoice DatedcDiscountdt)rr)CCouponz Discount TypeProductCategoryz Category CodeProductInventorymizManage InventorytierzTax Inclusive OR ExclusivevcnzVendor Company NameveazVendor Email AddressvcnozVendor Contact NumbervcpzVendor Contact Person ProductTaxestnzTax Namett)rr)rz Flat AmountzTax Typetvz Tax ValueQuery query_typez Query Type query_listz Query List)r(r query_generation_timeresponseResponse)r(r%r solved_queryz Solved Query date_timeSBDprocessing_currencyzProcessing Currency bank_namez Bank namez Bank Name bank_addressz Bank addressz Bank Addressbank_telephone_numberzBank telephone numberzBank Telephone Numbersettlement_currencyzSettlement Currencybank_account_holderzBank account holderzBank Account Holderbank_account_numberzBank account numberzBank Account Numberbic_codezBIC/SWIFT codezBIC Code iban_numberz IBAN numberz IBAN Numberbank_sort_codezBank sort codezBank Sort Coderouting_numberzRouting numberzRouting NumberzSettlement bank detailzSettlement bank detailsSMchargeback_handlingzs