# Generated by Django 5.0.1 on 2024-01-18 09:08 import django.utils.timezone import uuid from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='Application', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(default=django.utils.timezone.now, editable=False)), ('updated_at', models.DateTimeField(default=django.utils.timezone.now, editable=False)), ('status', models.CharField(choices=[('INC', 'Incomplete'), ('SUB', 'Submitted'), ('MAQ', 'Manual Query'), ('REJ', 'Rejected'), ('STB', 'Send To Bank'), ('RAR', 'Rate Received'), ('AUW', 'Approve By Underwriter'), ('ABA', 'Approve By Admin'), ('AAI', 'Approve By Admin By Pass Iso'), ('ABI', 'Approve By Iso'), ('NEG', 'Negotiable'), ('ABM', 'Approve By Merchant')], default='INC', max_length=3)), ('reason', models.TextField(default=0, help_text='Reason', null=True)), ], ), migrations.CreateModel( name='AssignToApplicationUnderwriter', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('date', models.DateField(blank=True, help_text='Assign To Application Underwriter Date', null=True)), ], ), migrations.CreateModel( name='BP', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('description_of_products', models.CharField(blank=True, help_text='Detailed description of products/services sold', max_length=200, verbose_name='Description Of Products')), ('length_of_time_business', models.CharField(blank=True, help_text='Length of time in business', max_length=20, verbose_name='Length Of Time Business')), ('website', models.URLField(blank=True, help_text='Website', verbose_name='Website')), ('login_details', models.BooleanField(default=False, help_text='Login details', null=True, verbose_name='Login Details')), ('username', models.CharField(blank=True, help_text='Username', max_length=50, verbose_name='Username')), ('password', models.CharField(blank=True, help_text='Password', max_length=50, verbose_name='Password')), ('beta_website', models.URLField(blank=True, help_text='Beta website', verbose_name='Beta Website')), ('descriptor', models.CharField(blank=True, help_text='Descriptor', max_length=50, verbose_name='Description')), ('city_field', models.CharField(blank=True, help_text='DBA/City field', max_length=20, verbose_name='City Field')), ('dynamic_descriptors', models.BooleanField(default=False, help_text="Will you use 'Dynamic Descriptors'?", null=True, verbose_name='Dynamic Description')), ('field_for_bankruptcy', models.BooleanField(default=False, help_text='Have you ever field for bankruptcy', null=True, verbose_name='Field For Bankruptcy')), ('field_for_bankruptcy_date', models.DateField(blank=True, help_text='Field for bankruptcy date', null=True, verbose_name='Field For Bankruptcy Date')), ('accepted_credit_cards', models.BooleanField(default=False, help_text='Have you previously accepted credit cards?', null=True, verbose_name='Accepted Credit Cards')), ('accepted_credit_cards_months', models.IntegerField(blank=True, help_text='Accepted credit cards months', null=True, verbose_name='Accepted Credit Cards Months')), ('card_scheme_program', models.BooleanField(default=False, help_text='Have you ever flagged or been in violation of any card scheme program?', null=True, verbose_name='Card Scheme Program')), ('card_scheme_program_provide_details', models.TextField(blank=True, help_text='Card scheme program provide details', verbose_name='Card Scheme Program Provide Details')), ('previous_payment_service_provider', models.CharField(blank=True, help_text='Current/previous Payment Service Provider/gateway', max_length=200, verbose_name='Previous Payment Service Provider')), ('previous_acquirer', models.CharField(blank=True, help_text='Current/previous accquirer', max_length=200, verbose_name='Previous Acquirer')), ('leaving_current_acquirer', models.CharField(blank=True, help_text='Reason for leaving current acquirer', max_length=200, verbose_name='Leaving Current Acquirer')), ('monthly_sales_volume', models.IntegerField(blank=True, help_text='Estimated monthly sales volume', null=True, verbose_name='Monthly Sales Volume')), ('currency', models.CharField(blank=True, help_text='Currency', max_length=20, verbose_name='Currency')), ('avg_transaction_value', models.IntegerField(blank=True, help_text='Average transaction value', null=True, verbose_name='Average Transaction Value')), ('highest_transaction_value', models.CharField(blank=True, help_text='Highest transaction value', max_length=50, verbose_name='Highest Transaction Value')), ('domestic', models.FloatField(blank=True, null=True, verbose_name='Domestic')), ('europe', models.FloatField(blank=True, null=True, verbose_name='Europe')), ('usa', models.FloatField(blank=True, null=True, verbose_name='USA')), ('asia', models.FloatField(blank=True, null=True, verbose_name='Asia')), ('rest_of_world', models.FloatField(blank=True, null=True, verbose_name='Rest Of Wold')), ('card_details', models.CharField(blank=True, help_text='Card Details', max_length=500, null=True, verbose_name='Card Details')), ('e_commerce', models.FloatField(blank=True, null=True, verbose_name='E-Commerce')), ('card_present', models.FloatField(blank=True, null=True, verbose_name='Card Present')), ('m_pos', models.FloatField(blank=True, null=True, verbose_name='M-POS')), ('m_commerce', models.FloatField(blank=True, null=True, verbose_name='M-Commerce')), ('moto', models.FloatField(blank=True, null=True, verbose_name='Moto')), ('in_app_commerce', models.FloatField(blank=True, null=True, verbose_name='In App Commerce')), ('upon_purchase', models.BooleanField(default=False, help_text='Upon Purchase', null=True, verbose_name='Upon Purchase')), ('with_download', models.BooleanField(default=False, help_text='With download', null=True, verbose_name='With Download')), ('on_delivery', models.BooleanField(default=False, help_text='On delivery', null=True, verbose_name='On Delivery')), ('others', models.BooleanField(default=False, help_text='other', null=True, verbose_name='Others')), ('other_details', models.CharField(blank=True, help_text='Other Details', max_length=500, verbose_name='Other Details')), ('one_time_payment', models.BooleanField(default=False, help_text='One Time Payment', null=True, verbose_name='One Time Payment')), ('recurring_payment', models.BooleanField(default=False, help_text='Recurring Payment', null=True, verbose_name='Recurring Payment')), ('immediately', models.FloatField(blank=True, null=True, verbose_name='Immediately')), ('within_four_weeks', models.FloatField(blank=True, null=True, verbose_name='Within Four Weeks')), ('within_5_14_weeks', models.FloatField(blank=True, null=True, verbose_name='Within 5 14 Weeks')), ('more_than_14_weeks', models.FloatField(blank=True, null=True, verbose_name='More Than 14 Weeks')), ('do_you_offer', models.BooleanField(default=False, help_text='Do you offer/make use of affiliate programs?', verbose_name='Do You Offer')), ('provide_details', models.TextField(blank=True, help_text='make use of affiliate programs', null=True, verbose_name='Provide Details')), ], options={ 'verbose_name': 'Business profile', 'verbose_name_plural': 'Business profiles', }, ), migrations.CreateModel( name='CCPH', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('number_of_transaction', models.IntegerField(blank=True, help_text='Number of transaction', null=True, verbose_name='Number Of Transaction')), ('transaction_volume', models.IntegerField(blank=True, help_text='Transaction volume', null=True, verbose_name='Transaction Volume')), ('number_of_chargeback', models.IntegerField(blank=True, help_text='Number of chargeback', null=True, verbose_name='Number of Chargeback')), ('chargeback_volume', models.IntegerField(blank=True, help_text='Chargeback volume', null=True, verbose_name='Chargeback Volume')), ('number_of_refunds', models.IntegerField(blank=True, help_text='Number of refunds', null=True, verbose_name='Number Of Refunds')), ('refund_volume', models.IntegerField(blank=True, help_text='Refund volume', null=True, verbose_name='Refund Volume')), ('months_ago', models.IntegerField(blank=True, help_text='Month ago', null=True, verbose_name='Month Ago')), ], ), migrations.CreateModel( name='COP', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('first_name', models.CharField(blank=True, help_text='First Name', max_length=50, verbose_name='First Name')), ('last_name', models.CharField(blank=True, help_text='Last Name', max_length=50, verbose_name='Last Name')), ('date_of_birth', models.DateField(blank=True, help_text='Date of birth', null=True, verbose_name='Date Of Birth')), ('ownership', models.FloatField(default=0.0, verbose_name='Ownership')), ('street_address', models.TextField(blank=True, help_text='Street address', verbose_name='Street Address')), ('house_number', models.CharField(blank=True, help_text='House number', max_length=10, verbose_name='House Number')), ('zip_code', models.CharField(blank=True, help_text='Zip code', max_length=20, verbose_name='Zip Code')), ('city', models.CharField(blank=True, help_text='City', max_length=50, verbose_name='City')), ('country', models.CharField(blank=True, help_text='Country', max_length=50, verbose_name='Country')), ('telephone_number', models.CharField(blank=True, help_text='Telephone number', max_length=20, verbose_name='Telephone Number')), ('passport', models.CharField(blank=True, help_text='Passport/ID number', max_length=20, verbose_name='Passport')), ('social_security_number', models.CharField(blank=True, help_text='Social security number', max_length=10, verbose_name='Social Security Number')), ('cop_type', models.IntegerField(choices=[(1, 'Director'), (2, 'UBO')], verbose_name='COP Type')), ('is_active', models.BooleanField(default=True)), ], options={ 'verbose_name': 'Company ownership profile', 'verbose_name_plural': 'Company ownership profiles', }, ), migrations.CreateModel( name='CouponCode', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('qb', models.IntegerField(blank=True, help_text='Quantity Based', null=True, verbose_name='Quantity Based')), ('tb', models.DateTimeField(default=django.utils.timezone.now, verbose_name='created_on')), ('qtb', models.CharField(blank=True, choices=[('Q', 'Quantity Based'), ('T', 'Time Based'), ('QT', 'Quantity and Time Based')], help_text='Quantity and Time Based', max_length=20, null=True, verbose_name='Quantity and Time Based')), ('cct', models.CharField(blank=True, choices=[('F', 'Flat'), ('P', 'Percentage')], help_text='Coupon Code Type', max_length=10, null=True, verbose_name='Coupon Code Type')), ('cc', models.CharField(blank=True, help_text='Coupon Code', max_length=20, null=True, verbose_name='Coupon Code')), ], ), migrations.CreateModel( name='CP', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('having_parent_company', models.BooleanField(default=False, help_text='Is Applying Company owned by a Parent Company?', null=True, verbose_name='Having Parent Company')), ('company_registration_no', models.CharField(blank=True, help_text='Company registration number', max_length=50, verbose_name='Company Registration Number')), ('legal_company_name', models.CharField(blank=True, help_text='Legal company name', max_length=50, verbose_name='Legal Company Name')), ('trade_name', models.CharField(blank=True, help_text='Registered DBA/trade name (if other than legal name)', max_length=50, verbose_name='Trade Name')), ('business_type', models.CharField(blank=True, help_text='Type of business (LLC, Ltd, Sole Proprietor, etc)', max_length=50, verbose_name='Business Type')), ('registered_street_address', models.TextField(blank=True, help_text='Registered street address (P.O. Box not acceptable)', verbose_name='Registered Street Address')), ('house_number', models.CharField(blank=True, help_text='House number', max_length=10, verbose_name='House Number')), ('zip_code', models.CharField(blank=True, help_text='Postcode / zip code', max_length=20, verbose_name='Zip Code')), ('city', models.CharField(blank=True, help_text='City', max_length=50, verbose_name='City')), ('state', models.CharField(blank=True, help_text=' (if applicable)', max_length=50, verbose_name='State')), ('country', models.CharField(blank=True, help_text='Country', max_length=50, verbose_name='Country')), ('telephone_number', models.CharField(blank=True, help_text='Telephone number', max_length=20, verbose_name='Telephone Number')), ('fax_number', models.IntegerField(blank=True, help_text='Fax number', null=True, verbose_name='Fax Number')), ('turnover_last_year', models.CharField(blank=True, help_text='Turnover last year (plus currency)', max_length=50, null=True, verbose_name='Turnover Last Year')), ('currency', models.CharField(blank=True, help_text='Currency', max_length=20, verbose_name='Currency')), ('incorporation_date', models.DateField(blank=True, help_text='Incorporation date 1 (YYYYMMDD)', null=True, verbose_name='Incorporation Date')), ('tax_identification_number', models.CharField(blank=True, help_text='VAT / Tax Identification number', max_length=50, null=True, verbose_name='Tax Identification Number')), ('stock_exchange', models.BooleanField(default=False, help_text='Is company publicly listed on a stock exchange?', null=True, verbose_name='Stock Exchange')), ('not_for_profit', models.BooleanField(default=False, help_text='Is company a registered ‘not-for-profit’ organization?', null=True, verbose_name='Not For Profit')), ('billing_registered_address', models.BooleanField(default=False, help_text='Is billing address different from registered address?', null=True, verbose_name='Billing Registered Address')), ('billing_street_address', models.TextField(blank=True, help_text='Street address (for billing purposes)', verbose_name='Billing Street Address')), ('billing_house_no', models.CharField(blank=True, help_text='House number', max_length=10, verbose_name='Billing House Number')), ('billing_post_code', models.CharField(blank=True, help_text='Postcode / zip code', max_length=20, verbose_name='Billing Post Code')), ('billing_city', models.CharField(blank=True, help_text='City', max_length=50, verbose_name='Billing City')), ('billing_state', models.CharField(blank=True, help_text='State', max_length=50, verbose_name='Billing State')), ('billing_country', models.CharField(blank=True, help_text='Country', max_length=50, verbose_name='Billing Country')), ], options={ 'verbose_name': 'Company profile', 'verbose_name_plural': 'Company profiles', }, ), migrations.CreateModel( name='ManualQueryTemplate', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('title', models.CharField(blank=True, help_text='Title', max_length=200, verbose_name='Title')), ('descriptor', models.TextField(blank=True, null=True, verbose_name='Descriptor')), ], ), migrations.CreateModel( name='MC', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('first_name', models.CharField(blank=True, help_text='First name', max_length=20, verbose_name='First Name')), ('last_name', models.CharField(blank=True, help_text='Last name', max_length=20, verbose_name='Last Name')), ('email_address', models.EmailField(blank=True, help_text='Email address', max_length=254, verbose_name='Email Address')), ('telephone_number', models.CharField(blank=True, help_text='Telephone number', max_length=20, verbose_name='Telephone Number')), ('fax_number', models.CharField(blank=True, help_text='Fax number', max_length=20, verbose_name='Fax Number')), ('further_info', models.TextField(blank=True, default=None, help_text='Please let us know if you have any further comments or information', null=True, verbose_name='Further Info')), ('contact_type', models.CharField(choices=[(1, 'General Contact'), (2, 'Technical Contact'), (3, 'Financial Contact'), (4, 'Chargeback Contact'), (5, 'Additional Comments')], default='1', help_text='Contact Type', max_length=3, verbose_name='Contact Type')), ], options={ 'verbose_name': 'Merchant contact', 'verbose_name_plural': 'Merchant contacts', }, ), migrations.CreateModel( name='MerchantBankBuyRate', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('acquiring_bank_field', models.TextField(blank=True, help_text='Acquiring Bank Field', verbose_name='Acquiring Bank Field')), ('acquiring_bank', models.CharField(blank=True, help_text='Acquiring Bank', max_length=50, verbose_name='Acquiring Bank')), ('generated_name', models.CharField(blank=True, help_text='Generated Name', max_length=50, verbose_name='Generated Name')), ('created_at', models.DateTimeField(default=django.utils.timezone.now, editable=False)), ('merchant_category_code', models.CharField(blank=True, help_text='Merchant Category Code', max_length=50, verbose_name='Merchant Category Code')), ('merchant_type', models.CharField(blank=True, help_text='Merchant Type', max_length=50, verbose_name='Merchant Type')), ('setup_charge', models.FloatField(blank=True, null=True, verbose_name='Setup Charge')), ('currency', models.CharField(blank=True, help_text='Currency', max_length=50, verbose_name='Currency')), ('payment_services_field', models.TextField(blank=True, help_text='Payment Services', verbose_name='Payment Services Field')), ('payment_services', models.CharField(blank=True, help_text='Payment Services', max_length=255, verbose_name='Payment Services')), ('settlement', models.CharField(blank=True, help_text='Settlement', max_length=50, verbose_name='Settlement')), ('credit_card', models.CharField(blank=True, help_text='Credit Card', max_length=50, verbose_name='Credit Card')), ('reserve_rate', models.FloatField(blank=True, null=True, verbose_name='Reserve Rate')), ('monthly_fees', models.FloatField(blank=True, null=True, verbose_name='Monthly Fees')), ('gateway_transaction_fees', models.FloatField(blank=True, null=True, verbose_name='Gateway Transaction Fees')), ('fraud_scrub_fees', models.FloatField(blank=True, null=True, verbose_name='Fraud Scrub Fees')), ('monthly_maintenance_fees', models.FloatField(blank=True, null=True, verbose_name='Monthly Maintenance Fees')), ('batch_upload', models.FloatField(blank=True, null=True, verbose_name='Batch Upload')), ('refund_charge', models.FloatField(blank=True, null=True, verbose_name='Refund Charge')), ('wire_domestic_fees', models.FloatField(blank=True, null=True, verbose_name='Wire Domestic Fees')), ('wire_international', models.FloatField(blank=True, null=True, verbose_name='Wire International')), ('chargeback_charge_0_2', models.FloatField(blank=True, null=True, verbose_name='Chargeback charge 0 2')), ('chargeback_charge_2_5', models.FloatField(blank=True, null=True, verbose_name='Chargeback charge 2 5')), ('chargeback_charge_5_10', models.FloatField(blank=True, null=True, verbose_name='Chargeback charge 5 10')), ('gateway_fees', models.FloatField(blank=True, null=True, verbose_name='Gateway Fees')), ('gateway_monthly_fees', models.FloatField(blank=True, null=True, verbose_name='Gateway Monthly Fees')), ('return_charges', models.FloatField(blank=True, null=True, verbose_name='Return Charges')), ('verification_fees', models.FloatField(blank=True, null=True, verbose_name='Verification Fees')), ('allow', models.BooleanField(default=False, verbose_name='Allow')), ('cash_discount', models.BooleanField(default=False, verbose_name='Cash Discount')), ('split_rates', models.IntegerField(blank=True, choices=[(1, 'Flat'), (2, 'Recurring'), (3, 'Split')], null=True, verbose_name='Split Rates')), ('value', models.FloatField(blank=True, null=True, verbose_name='Value')), ('maximum_ticket_size', models.CharField(blank=True, help_text='Maximum Ticket Size', max_length=50, verbose_name='Maximum Ticket Size')), ('minimum_ticket_size', models.CharField(blank=True, help_text='Minimum Ticket Size', max_length=50, verbose_name='Minimum Ticket Size')), ('reject_percent', models.FloatField(blank=True, null=True, verbose_name='Reject Percent')), ('declined_percent', models.FloatField(blank=True, null=True, verbose_name='Declined Percent')), ('refund_percent', models.FloatField(blank=True, null=True, verbose_name='Refund Percent')), ('chargeback_percent', models.FloatField(blank=True, null=True, verbose_name='Chargeback Percent')), ('block_type', models.IntegerField(choices=[(1, 'count'), (2, 'value'), (3, 'both')], verbose_name='Block Type')), ('virtual_terminal', models.BooleanField(default=False, verbose_name='Virtual Terminal')), ('transaction_fees', models.FloatField(blank=True, null=True, verbose_name='Transaction Fees')), ('load_balancing', models.BooleanField(default=False, verbose_name='Load Balancing')), ], ), migrations.CreateModel( name='MerchantBankSaleRate', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('acquiring_bank_field', models.TextField(blank=True, help_text='Acquiring Bank Field', verbose_name='Acquiring Bank Field')), ('acquiring_bank', models.CharField(blank=True, help_text='Acquiring Bank', max_length=50, verbose_name='Acquiring Bank')), ('generated_name', models.CharField(blank=True, help_text='Generated Name', max_length=50, verbose_name='Generated Name')), ('merchant_category_code', models.CharField(blank=True, help_text='Merchant Category Code', max_length=50, verbose_name='Merchant Category Code')), ('merchant_type', models.CharField(blank=True, help_text='Merchant Type', max_length=50, verbose_name='Merchant Type')), ('setup_charge', models.FloatField(blank=True, null=True, verbose_name='Setup Charge')), ('reserve_rate', models.FloatField(blank=True, null=True, verbose_name='Reserve Rate')), ('gateway_fees', models.FloatField(blank=True, null=True, verbose_name='Gateway Fees')), ('gateway_monthly_fees', models.FloatField(blank=True, null=True, verbose_name='Gateway Monthly Fees')), ('return_charges', models.FloatField(blank=True, null=True, verbose_name='Return Charges')), ('fraud_scrub_fees', models.FloatField(blank=True, null=True, verbose_name='Fraud Scrub Fees')), ('verification_fees', models.FloatField(blank=True, null=True, verbose_name='Verification Fees')), ('batch_upload', models.FloatField(blank=True, null=True, verbose_name='Batch Upload')), ('refund_charge', models.FloatField(blank=True, null=True, verbose_name='Refund Charge')), ('wire_domestic_fees', models.FloatField(blank=True, null=True, verbose_name='Wire Domestic Fees')), ('chargeback_charge_0_2', models.FloatField(blank=True, null=True, verbose_name='Chargeback charge 0 2')), ('chargeback_charge_2_5', models.FloatField(blank=True, null=True, verbose_name='Chargeback charge 2 5')), ('chargeback_charge_5_10', models.FloatField(blank=True, null=True, verbose_name='Chargeback charge 5 10')), ('allow', models.BooleanField(default=False, verbose_name='Allow')), ('cash_discount', models.BooleanField(default=False, verbose_name='Cash Discount')), ('currency', models.CharField(blank=True, help_text='Currency', max_length=50, verbose_name='Currency')), ('payment_services_field', models.TextField(blank=True, help_text='Payment Services Field', verbose_name='Payment Services Field')), ('payment_services', models.CharField(blank=True, help_text='Payment Services', max_length=255, verbose_name='Payment Services')), ('settlement', models.CharField(blank=True, help_text='Settlement', max_length=50, verbose_name='Settlement')), ('split_rates', models.IntegerField(blank=True, choices=[(1, 'Flat'), (2, 'Recurring'), (3, 'Split')], null=True, verbose_name='Split Rates')), ('value', models.FloatField(blank=True, null=True, verbose_name='Value')), ('maximum_ticket_size', models.CharField(blank=True, help_text='Maximum Ticket Size', max_length=50, verbose_name='Maximum Ticket Size')), ('minimum_ticket_size', models.CharField(blank=True, help_text='Minimum Ticket Size', max_length=50, verbose_name='Minimum Ticket Size')), ('reject_percent', models.FloatField(blank=True, null=True, verbose_name='Reject Percent')), ('declined_percent', models.FloatField(blank=True, null=True, verbose_name='Declined Percent')), ('chargeback_percent', models.FloatField(blank=True, null=True, verbose_name='Chargeback Percent')), ('block_type', models.IntegerField(choices=[(1, 'count'), (2, 'value'), (3, 'both')], verbose_name='Block Type')), ('virtual_terminal', models.BooleanField(default=False, verbose_name='Virtual Terminal')), ('refund_percent', models.FloatField(blank=True, null=True, verbose_name='Refund Percent')), ('credit_card', models.CharField(blank=True, help_text='Credit Card', max_length=50, verbose_name='Credit Card')), ('monthly_fees', models.FloatField(blank=True, null=True, verbose_name='Monthly Fees')), ('gateway_transaction_fees', models.FloatField(blank=True, null=True, verbose_name='Gateway Transaction Fees')), ('monthly_maintenance_fees', models.FloatField(blank=True, null=True, verbose_name='Monthly Maintenance Fees')), ('wire_international', models.FloatField(blank=True, null=True, verbose_name='Wire International')), ('load_balancing', models.BooleanField(default=False, verbose_name='Load Balancing')), ('transaction_fees', models.FloatField(blank=True, null=True, verbose_name='Transaction Fees')), ], ), migrations.CreateModel( name='MerchantSetting', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('mid', models.IntegerField(blank=True, help_text='Merchant ID')), ('email', models.EmailField(blank=True, help_text='Merchant Email', max_length=254, verbose_name='Email')), ('phone', models.CharField(blank=True, help_text='Merchant Phone Number', max_length=20, verbose_name='Phone')), ('date_time_stamp', models.DateTimeField(blank=True, default=django.utils.timezone.now, help_text='Merchant Date Time Stamp', null=True, verbose_name='Date Time Stamp')), ('terminal_id', models.IntegerField(blank=True, default=0, help_text='Terminal ID', verbose_name='Terminal id')), ('bank_credential', models.CharField(blank=True, help_text='Bank Credential', max_length=50, verbose_name='Bank Credential')), ('test_api_key', models.CharField(blank=True, help_text='Test API Key', max_length=255, verbose_name='Test API Key')), ('product_api_key', models.CharField(blank=True, help_text='Product API Key', max_length=255, verbose_name='Product API Key')), ('internal_mid', models.IntegerField(blank=True, default=0, help_text='Internal Mid', verbose_name='Internal mid')), ('charge', models.IntegerField(blank=True, default=0, help_text='Charge', verbose_name='Charge')), ], options={ 'verbose_name': 'Merchant Setting', 'verbose_name_plural': 'Merchant Settings', }, ), migrations.CreateModel( name='NewCustomer', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(default=django.utils.timezone.now, editable=False)), ('fn', models.CharField(blank=True, help_text='First Name', max_length=50, verbose_name='First Name')), ('ln', models.CharField(blank=True, help_text='Last Name', max_length=50, verbose_name='Last Name')), ('pn', models.CharField(blank=True, help_text='Phone Number', max_length=50, verbose_name='Phone Number')), ('ed', models.EmailField(blank=True, help_text='Email Address', max_length=254, verbose_name='Email Address')), ('ad', models.TextField(blank=True, help_text='Address', verbose_name='Address')), ('cn', models.CharField(blank=True, help_text='City Name', max_length=50, verbose_name='City Name')), ('sn', models.CharField(blank=True, help_text='State Name', max_length=50, verbose_name='State Name')), ('cnn', models.CharField(blank=True, help_text='Country Name', max_length=50, verbose_name='Country Name')), ('zp', models.CharField(blank=True, help_text='Zip Code', max_length=20, verbose_name='Zip Code')), ], ), migrations.CreateModel( name='NewProduct', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(default=django.utils.timezone.now, editable=False)), ('pn', models.CharField(blank=True, help_text='Product Name', max_length=50, verbose_name='Product Name')), ('pd', models.TextField(blank=True, help_text='Product Description', verbose_name='Product Description')), ('pc', models.CharField(blank=True, help_text='Parent Category', max_length=50, verbose_name='Product Category')), ('pt', models.CharField(blank=True, help_text='Taxes', max_length=50, verbose_name='Product Tax')), ('pi', models.FileField(blank=True, null=True, upload_to='product_image', verbose_name='Product Image')), ], ), migrations.CreateModel( name='NewProductPrice', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('mpie', models.CharField(choices=[('I', 'Inclusive'), ('E', 'Exclusive')], max_length=10, verbose_name='MRP Price Including Inclusive/Exclusive')), ('ps', models.CharField(blank=True, help_text='Package Size', max_length=50, verbose_name='Package Size')), ('mt', models.CharField(blank=True, help_text='Measurement Type', max_length=20, verbose_name='Measurement Type')), ('sp', models.CharField(blank=True, help_text='Selling Price', max_length=20, verbose_name='Selling Price')), ('pt', models.FloatField(blank=True, null=True, verbose_name='Product Tax')), ], ), migrations.CreateModel( name='Note', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('description', models.TextField(help_text='Description')), ('created_on', models.DateTimeField(default=django.utils.timezone.now, verbose_name='created_on')), ], ), migrations.CreateModel( name='PointOfSale', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(default=django.utils.timezone.now, editable=False)), ('si', models.CharField(blank=True, help_text='Search Item', max_length=50, null=True, verbose_name='Search Item')), ('ccn', models.CharField(blank=True, help_text='Customer Contact Number', max_length=50, null=True, verbose_name='Customer Contact Number')), ('ca', models.TextField(blank=True, help_text='Customer Address', null=True, verbose_name='Customer Address')), ('qty', models.IntegerField(blank=True, help_text='Quantity', null=True, verbose_name='Quantity')), ('pp', models.FloatField(blank=True, null=True, verbose_name='Pri ce')), ('st', models.FloatField(blank=True, null=True, verbose_name='Sub Total')), ('gst', models.FloatField(blank=True, null=True, verbose_name='GST')), ('gt', models.FloatField(blank=True, null=True, verbose_name='Grant Total')), ('ivc', models.CharField(blank=True, help_text='Invoice Number', max_length=50, null=True, verbose_name='Invoice Number')), ('ivd', models.DateField(blank=True, help_text='Invoice Date', null=True, verbose_name='Invoice Date')), ('dc', models.FloatField(blank=True, null=True, verbose_name='Discount')), ('dt', models.CharField(choices=[('F', 'Flat'), ('P', 'Percentage'), ('C', 'Coupon')], max_length=10, verbose_name='Discount Type')), ], ), migrations.CreateModel( name='ProductCategory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(default=django.utils.timezone.now, editable=False)), ('pc', models.CharField(blank=True, help_text='Product Category', max_length=50, verbose_name='Product Category')), ('cn', models.CharField(blank=True, help_text='Category Code', max_length=50, verbose_name='Category Code')), ], ), migrations.CreateModel( name='ProductInventory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('mi', models.BooleanField(default=False, help_text='Manage Inventory', null=True, verbose_name='Manage Inventory')), ('tie', models.CharField(choices=[('I', 'Inclusive'), ('E', 'Exclusive')], max_length=2, verbose_name='Tax Inclusive OR Exclusive')), ('vcn', models.CharField(blank=True, help_text='Vendor Company Name', max_length=50, verbose_name='Vendor Company Name')), ('vea', models.EmailField(blank=True, help_text='Vendor Email Address', max_length=254, verbose_name='Vendor Email Address')), ('vcno', models.CharField(blank=True, help_text='Vendor Contact Number', max_length=50, verbose_name='Vendor Contact Number')), ('vcp', models.CharField(blank=True, help_text='Vendor Contact Person', max_length=50, verbose_name='Vendor Contact Person')), ], ), migrations.CreateModel( name='ProductTaxes', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(default=django.utils.timezone.now, editable=False)), ('tn', models.CharField(blank=True, help_text='Tax Name', max_length=50, verbose_name='Tax Name')), ('tt', models.IntegerField(choices=[(1, 'Percentage'), (2, 'Flat Amount')], verbose_name='Tax Type')), ('tv', models.FloatField(blank=True, null=True, verbose_name='Tax Value')), ], ), migrations.CreateModel( name='Query', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('query_type', models.BooleanField(default=False, help_text='Query Type', verbose_name='Query Type')), ('query_list', models.TextField(help_text='Query List', verbose_name='Query List')), ('query_generation_time', models.DateTimeField(default=django.utils.timezone.now, verbose_name='created_on')), ('response', models.CharField(help_text='Response', max_length=50, verbose_name='Response')), ('solved_query', models.IntegerField(help_text='Solved Query', verbose_name='Solved Query')), ('date_time', models.DateTimeField(default=django.utils.timezone.now, verbose_name='created_on')), ], ), migrations.CreateModel( name='SBD', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('processing_currency', models.TextField(blank=True, help_text='Processing Currency', verbose_name='Processing Currency')), ('bank_name', models.CharField(blank=True, help_text='Bank name', max_length=20, verbose_name='Bank Name')), ('bank_address', models.TextField(blank=True, help_text='Bank address', verbose_name='Bank Address')), ('zip_code', models.CharField(blank=True, help_text='Zip code', max_length=20, verbose_name='Zip Code')), ('city', models.CharField(blank=True, help_text='City', max_length=20, verbose_name='City')), ('country', models.CharField(blank=True, help_text='Country', max_length=20, verbose_name='Country')), ('bank_telephone_number', models.CharField(blank=True, help_text='Bank telephone number', max_length=20, verbose_name='Bank Telephone Number')), ('settlement_currency', models.CharField(blank=True, help_text='Settlement Currency', max_length=50, verbose_name='Settlement Currency')), ('bank_account_holder', models.CharField(blank=True, help_text='Bank account holder', max_length=20, verbose_name='Bank Account Holder')), ('bank_account_number', models.CharField(blank=True, help_text='Bank account number', max_length=50, verbose_name='Bank Account Number')), ('bic_code', models.CharField(blank=True, help_text='BIC/SWIFT code', max_length=20, verbose_name='BIC Code')), ('iban_number', models.CharField(blank=True, help_text='IBAN number', max_length=50, verbose_name='IBAN Number')), ('bank_sort_code', models.CharField(blank=True, help_text='Bank sort code', max_length=20, verbose_name='Bank Sort Code')), ('routing_number', models.CharField(blank=True, help_text='Routing number', max_length=50, verbose_name='Routing Number')), ('is_active', models.BooleanField(default=True)), ], options={ 'verbose_name': 'Settlement bank detail', 'verbose_name_plural': 'Settlement bank details', }, ), migrations.CreateModel( name='SM', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('created_at', models.DateTimeField(blank=True, editable=False, null=True)), ('chargeback_handling', models.CharField(blank=True, help_text='Describe ALL security measures AND fraud/chargeback handling', max_length=200, verbose_name='Chargeback Handling')), ('apply_for_3d_secure', models.BooleanField(default=False, help_text='Would you like to apply for 3D Secure', null=True, verbose_name='Apply for 3D secure')), ('card_verification_code', models.BooleanField(default=False, help_text='Will you use CVC', null=True, verbose_name='Card Verification Code')), ('apply_for_avs', models.BooleanField(default=False, help_text='Would you like to apply for AVS', null=True, verbose_name='Apply for AVS')), ('mpi_used', models.CharField(blank=True, help_text='If yes, what MPI will be used?', max_length=200, verbose_name='MPI Used')), ], options={ 'verbose_name': 'Security measure', 'verbose_name_plural': 'Security measures', }, ), migrations.CreateModel( name='Timeline', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('query_rest', models.TextField(blank=True, help_text='Query rest', verbose_name='Query rest')), ('query_type', models.CharField(default='manual', help_text='Query type', max_length=50, verbose_name='Query Type')), ('time', models.DateTimeField(default=django.utils.timezone.now, verbose_name='created_on')), ('query_raised_by_underwriter', models.BooleanField(default=False, help_text='Query Read by Underwriter', null=True, verbose_name='Query Raised By Underwriter')), ('query_raised_by_merchant', models.BooleanField(default=False, help_text='Query Read by Applicant', null=True, verbose_name='Query Raised By Merchant')), ('mark_read_as_underwriter', models.BooleanField(default=False, help_text='Mark Read as Underwriter', null=True, verbose_name='Mark Read as Underwriter')), ('mark_read_as_merchant', models.BooleanField(default=False, help_text='Mark Read as Applicant', null=True, verbose_name='Mark Read as Merchant')), ], ), migrations.CreateModel( name='UploadedDocument', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uid', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)), ('document', models.FileField(blank=True, null=True, upload_to='document/', verbose_name='Document')), ('is_received', models.BooleanField(default=False, verbose_name='Is Received')), ('document_type', models.CharField(choices=[('personal_id', 'Personal Id'), ('bank_statement', 'Bank Statement'), ('corporate_documents', 'Corporate Documents'), ('utility_bill', 'Utility Bill'), ('creditcard_statement', 'CreditCard Statement'), ('cancel_cheque', 'Cancel Cheque')], max_length=30, verbose_name='Document Type')), ], options={ 'verbose_name': 'Uploaded Document', 'verbose_name_plural': 'Uploaded Documents', }, ), migrations.CreateModel( name='VirtualTerminal', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('first_name', models.CharField(blank=True, help_text='First Name', max_length=20, verbose_name='First Name')), ('last_name', models.CharField(blank=True, help_text='Last Name', max_length=20, verbose_name='Last Name')), ('address', models.TextField(blank=True, help_text='Address', verbose_name='Address')), ('city', models.CharField(blank=True, help_text='City', max_length=20, verbose_name='City')), ('state', models.CharField(blank=True, help_text='State', max_length=20, verbose_name='State')), ('country', models.CharField(blank=True, help_text='Country', max_length=20, verbose_name='Country')), ('zip_code', models.CharField(blank=True, help_text='Postcode / Zipcode', max_length=15, verbose_name='Zip Code')), ('contact_number', models.CharField(blank=True, help_text='Contact Number', max_length=20, verbose_name='Contact Number')), ('email_address', models.EmailField(blank=True, help_text='Email Address', max_length=254, verbose_name='Email Address')), ('product', models.CharField(blank=True, help_text='Product', max_length=20, verbose_name='Product')), ('amount', models.CharField(blank=True, help_text='Amount', max_length=20, verbose_name='Amount')), ('credit_card', models.BooleanField(default=False, help_text='Mode Of Payment Credit Card ', null=True, verbose_name='Credit Card')), ('ach', models.BooleanField(default=False, help_text='Mode Of Payment ACH', null=True, verbose_name='ACH')), ('sepa', models.BooleanField(default=False, help_text='Mode Of Payment SEPA', null=True, verbose_name='Sepa')), ('upi', models.BooleanField(default=False, help_text='Mode Of Payment UPI', null=True, verbose_name='UPI')), ('ewallet', models.BooleanField(default=False, help_text='Mode Of Payment EWallet', null=True, verbose_name='E-wallet')), ('card_number', models.IntegerField(blank=True, help_text='Card Number', verbose_name='Card Number')), ('expiration_month', models.CharField(blank=True, help_text='Expiration Month', max_length=50, null=True, verbose_name='Expiration Month')), ('expiration_year', models.IntegerField(default=False, help_text='Expiration Year', verbose_name='Expiration Year')), ('cvv2_number', models.IntegerField(blank=True, help_text='CVV/CVV2 Number', verbose_name='CVV2 Number')), ('card_type', models.CharField(blank=True, help_text='Card Type', max_length=50, verbose_name='Card Type')), ('name_of_card', models.CharField(blank=True, help_text='Name Of Card', max_length=50, verbose_name='Name Of Card')), ('issuing_bank', models.CharField(blank=True, help_text='Issuing Bank', max_length=50, verbose_name='Issuing Bank')), ('bank_name', models.CharField(blank=True, help_text='Bank Name', max_length=20, verbose_name='Bank Name')), ('name_on_account', models.CharField(blank=True, help_text='Name On Account', max_length=50, verbose_name='Name On Account')), ('routing_number', models.IntegerField(blank=True, help_text='Routing Number', verbose_name='Routing Number')), ('account_number', models.IntegerField(blank=True, help_text='Account Number', verbose_name='Account Number')), ('cheque_number', models.IntegerField(blank=True, help_text='Cheque Number', verbose_name='Cheque Number')), ], ), ]