automaster_fields = {
    'firstnamefield': 'CustomerFirstName',
    'lastnamefield': 'CustomerLastName',
    'middlenamefield': 'CustomerMiddleName',
    'applicationtypefield': 'ApplicationType',
    'phonefield': 'CustomerPhoneNumber',
    'mobilephonefield': 'CustomerCellPhoneNumber',
    'phonebillfield': 'PhoneBillTo',
    'emailfield': 'CustomerEmail',
    'datepicker': 'CustomerDateOfBirth',
    'ssnfield': 'CustomerSSN',
    'driverlicensefield': 'CustomerDLNumber',
    'driverlicensestatefield': 'CustomerDLState',
    'maritalstatusfield': 'MaritalStatus',
    # 'dependentsfield': '?????',
    # 'dependentagesfield': '?????',
    'streetfield': 'CustomerAddress',
    'citytfield': 'CustomerAddressCity',
    'statefield': 'CustomerAddressState',
    'zipfield': 'CustomerZipCode',
    'countyfield': 'CustomerCounty',
    'townshipfield': 'CustomerTownship',
    'addressyearstotalfield': 'CustomerYearsAtAddress',
    'addressmonthstotalfield': 'CustomerMonthsAtAddress',
    'landlordfield': 'CustomerLandlordName',
    'landlordphonefield': 'CustomerLandlordPhone',
    'rentorownfield': 'CustomerHousingStatus',
    'monthlypaymentfield': 'CustomerRentAmount',
    'previousstreetfield': 'CustomerPriorAddress',
    'previouscitytfield': 'CustomerPriorAddressCity',
    'previousstatefield': 'CustomerPriorAddressState',
    'previouszipfield': 'CustomerPriorAddressZipcode',
    'previousaddressyearstotalfield': 'CustomerYearsAtPriorAddress',
    'previousaddressmonthstotalfield':  'CustomerMonthsAtPriorAddress',
    'employerfield':  'CustomerEmploymentName',
    'employeraddressfield':  'CustomerEmploymentAddress',
    'employercitytfield':  'CustomerEmploymentCity',
    'employerstatefield':  'CustomerEmploymentState',
    'employerzipfield':  'CustomerEmploymentCityZipCode',
    'titlefield':  'CustomerEmploymentTitle',
    'employmentyearsfield':  'CustomerYearsAtEmployment',
    'employmentmonthsfield':  'CustomerMonthsAtEmployment',
    'workphonefield':  'CustomerEmploymentPhone',
    'incomefield':  'CustomerEmploymentSalary',
    'hourlypayfield':  'HourlyPay',
    'hoursworkedfield':  'HoursWorked',
    'payperiodfield':  'CustomerEmploymentPayday',
    'additionalincomefield':  'CustomerOtherIncomeAmount',
    'additionalincomesourcefield':  'CustomerOtherIncome',
    'formeremployerfield':  'CustomerPriorEmployment',
    'formeremployerpositionfield':  'CustomerPriorEmploymentTitle',
    'formeremployertimefield':  'CustomerYearsAtPriorEmployment',
    'formeremployertimemonthsfield':  'CustomerMonthsAtPriorEmployment',
    'formeremployerphonefield':  'CustomerPriorEmploymentPhone',
    'formeremployerleavereasonfield':  'ReasonForLiving/ReasonForLeaving',
    # 'maintenancepaymentfield':  '?????',
    # 'childsupportagesfield':  '?????',
    'bankruptcyfield':  'Bankruptcy',
    'bankruptcydischargedatefield':  'BankruptcyDate',
    # 'bankruptcychapterfield':  '?????',
    'repossessionfield':  'Repo',
    'repossessiondatefield':  'RepoDate',
    'repossessiontypefield':  'RepoReason',
    # 'priorvehiclecreditborrowedfield':  '?????',
    # 'amountowedfield':  '?????',
    # 'loanwithwhomfield':  '?????',
    'banknamefield':  'BankName',
    'bankcityfield':  'BankCity',
    'checkingbalancefield':  'Checking',
    'savingbalancefield':  'Savings',
    'utilitiespaymentfield':  'UtilitiesAmount',
    'childcarepaymentfield':  'CustomerChildCareFrequency',
    # 'cabletvpaymentfield':  '?????',
    'downpaymentfield':  'DownPayment',
    'cosignerfirstnamefield':  'CoApplicantFirstName',
    'cosignermiddlenamefield':  'CoApplicantMiddleName',
    'ccosignerlastnamefield':  'CoApplicantLastName',
    'cosignerphonefield':  'CoApplicantPhone',
    'cosignermobilephonefield':  'CoApplicantCell',
    'cosignerphonebillfield':  'CoApplicantPhoneBillTo',
    'cosigneremailfield': 'CoApplicantEmail',
    'cosignerdateofbirthfield': 'CoApplicantDateOfBirth',
    'cosignerssnfield': 'CoApplicantSSN',
    'codriverlicensefield': 'CoApplicantDLNumber',
    'codriverlicensestatefield': 'CoApplicantDLState',
    'cosignermaritalstatusfield': 'CoApplicantMaritalStatus',
    # 'cosignerdependentsfield': '?????',
    # 'cosignerdependentagesfield': '?????',
    'cosignerstreetfield': 'CoApplicantAddress',
    'cosignercitytfield': 'CoApplicantCity',
    'cosignerstatefield': 'CoApplicantState',
    'cosignerzipfield': 'CoApplicantZipCode',
    'cosignercountyfield': 'CoApplicantCounty',
    'cosignertownshipfield': 'CoApplicantTownship',
    'cosignerrentorownfield': 'CoApplicantHousingStatus',
    'cosignermonthlypaymentfield': 'CoApplicantRentAmount',
    'cosigneraddressyearstotalfield': 'CoApplicantYearsAtAddress',
    'cosigneraddressmonthstotalfield': 'CoApplicantMonthsAtAddress',
    'cosignerlandlordfield': 'CoApplicantLandlordPhone',
    'cosignerlandlordphonefield': 'CoApplicantLandlordPhone',
    'cosignerpreviousstreetfield': 'CoApplicantPriorAddress',
    'cosignerpreviouscitytfield': 'CoApplicantPriorCity',
    'cosignerpreviousstatefield': 'CoApplicantPriorState',
    'cosignerpreviouszipfield': 'CoApplicantPriorZipcode',
    'cosignerpreviousaddressyearstotalfield': 'CoApplicantYearsAtPriorAddress',
    'cosignerpreviousaddressmonthstotalfield': 'CoApplicantMonthsAtPriorAddress',
    'cosigneremployerfield': 'CoApplicantEmploymentName',
    'cosigneremployeraddressfield': 'CoApplicantEmploymentAddress',
    'cosigneremployercityfield': 'CoApplicantEmploymentCity',
    'cosigneremployerstatefield': 'CoApplicantEmploymentState',
    'cosigneremployerzipfield': 'CoApplicantEmploymentZipCode',
    'cosignerpositionfield': 'CoApplicantEmploymentTitle',
    'cosigneremploymentlengthyearsfield': 'CoApplicantYearsAtEmployment',
    'cosigneremploymentmonthsfield': 'CoApplicantMonthsAtEmployment',
    'cosigneremploymerphonefield': 'CoApplicantEmploymentPhone',
    'cosignerhourlypayfield': 'CoApplicantHourlyPay',
    'cosignerhoursworkedfield': 'CoApplicantHoursWorked',
    'cosignerpayperiodfield': 'CoApplicantEmploymentPayday',
    'cosigneradditionalincomefield': 'CoApplicantOtherIncomeAmount',
    'cosigneradditionalincomesourcefield': 'CoApplicantOtherIncomeSource',
    'cosignerformeremployerfield': 'CustomerPriorEmployment',
    'cosignerformeremployerpositionfield': 'CustomerPriorEmploymentTitle',
    'cosignerformeremployertimefield': 'CustomerYearsAtPriorEmployment',
    'cosignerformeremployertimemonthsfield': 'CustomerMonthsAtPriorEmployment',
    'cosignerformeremployerphonefield': 'CustomerPriorEmploymentPhone',
    'cosignerformeremployerleavereasonfield': 'CoApplicantReasonForLeaving',
    # 'cosignermaintenancepaymentfield': '?????',
    # 'cosignerchildsupportagesfield': '?????',
    'cosignerbankruptcyfield': 'CoApplicantBankruptcy',
    'cosignerbankruptcydischargedatefield': 'CoApplicantBankruptcyDate',
    # 'cosignerbankruptcychapterfield': '?????',
    'cosignerrepossessionfield': 'CoApplicantRepo',
    'cosignerrepossessiondatefield': 'CoApplicantRepoDate',
    'cosignerrepossessiontypefield': 'CoApplicantRepoReason',
    # 'cosignerpriorvehiclecreditborrowedfield': '?????',
    # 'cosigneramountowedfield': '?????',
    # 'cosignerloanwithwhomfield': '?????',
    'cosignerbanknamefield': 'CoApplicantBankName',
    'cosignerbankcityfield': 'CoApplicantBankCity',
    'cosignercheckingbalancefield': 'CoApplicantChecking',
    'cosignersavingbalancefield': 'CoApplicantSavings',
    'cosignerutilitiespaymentfield': 'CoApplicantUtilitiesAmount',
    'cosignerchildcarepaymentfield': 'CoApplicantChildCare',
    # 'cosignercabletvpaymentfield': '?????',
    # 'cosignerdownpaymentfield': '?????',
    # 'additionalinformationfield': '?????',
    # 'privacypolicyfield': '?????',
    # 'statusnote': '?????',
    'dealerlotfield':  'Lot'
}

automaster_field_details = {
    'CustomerFirstName':  '15',
    'CustomerLastName':  '20',
    'CustomerMiddleName':  '15',
    'ApplicationType':  '20',
    'CustomerPhoneNumber':  '12',
    'CustomerCellPhoneNumber':  '12',
    'PhoneBillTo':  '40',
    'CustomerEmail':  '100',
    'CustomerDateOfBirth':  'DateTime',
    'CustomerSSN':  '11',
    'CustomerDLNumber':  '20',
    'CustomerDLState':  '20',
    'MaritalStatus':  '10',
    'CustomerAddress':  '30',
    'CustomerAddressCity':  '45',
    'CustomerAddressState':  '2',
    'CustomerZipCode':  '10',
    'CustomerCounty':  '20',
    'CustomerTownship':  '20',
    'CustomerYearsAtAddress':  'decimal',
    'CustomerMonthsAtAddress':  'decimal',
    'CustomerLandlordName':  '30',
    'CustomerLandlordPhone':  '12',
    'CustomerHousingStatus':  '20',
    'CustomerRentAmount':  'decimal',
    'CustomerPriorAddress':  '20',
    'CustomerPriorAddressCity':  '45',
    'CustomerPriorAddressState':  '2',
    'CustomerPriorAddressZipcode':  '10',
    'CustomerYearsAtPriorAddress':  'decimal',
    'CustomerMonthsAtPriorAddress':  'decimal',
    'CustomerEmploymentName':  '25',
    'CustomerEmploymentAddress':  '100',
    'CustomerEmploymentCity':  '25',
    'CustomerEmploymentState':  '2',
    'CustomerEmploymentCityZipCode':  '10',
    'CustomerEmploymentTitle':  '15',
    'CustomerYearsAtEmployment':  '10',
    'CustomerMonthsAtEmployment':  '10',
    'CustomerEmploymentPhone':  '12',
    'CustomerEmploymentSalary':  'decimal',
    'HourlyPay':  'decimal',
    'HoursWorked':  'decimal',
    'CustomerEmploymentPayday':  '10',
    'CustomerOtherIncomeAmount':  'decimal',
    'CustomerOtherIncome':  '25',
    'CustomerPriorEmployment':  '25',
    'CustomerPriorEmploymentTitle':  '15',
    'CustomerYearsAtPriorEmployment':  '10',
    'CustomerMonthsAtPriorEmployment':  '10',
    'CustomerPriorEmploymentPhone':  '12',
    'ReasonForLiving/ReasonForLeaving':  '50',
    'Bankruptcy':  '3',
    'BankruptcyDate':  'Datetime',
    'Repo':  '3',
    'RepoDate':  'Datetime',
    'RepoReason':  '400',
    'BankName':  '20',
    'BankCity':  '20',
    'Checking':  '20',
    'Savings':  '20',
    'UtilitiesAmount':  'decimal',
    'CustomerChildCareFrequency':  '20',
    'DownPayment':  'decimal',
    'CoApplicantFirstName':  '15',
    'CoApplicantMiddleName':  '15',
    'CoApplicantLastName':  '20',
    'CoApplicantPhone':  '12',
    'CoApplicantCell':  '12',
    'CoApplicantPhoneBillTo':  '40',
    'CoApplicantEmail':  '100',
    'CoApplicantDateOfBirth':  'datetime',
    'CoApplicantSSN':  '10',
    'CoApplicantDLNumber':  '20',
    'CoApplicantDLState':  '20',
    'CoApplicantMaritalStatus':  '10',
    'CoApplicantAddress':  '30',
    'CoApplicantCity':  '20',
    'CoApplicantState':  '2',
    'CoApplicantZipCode':  '10',
    'CoApplicantCounty':  '20',
    'CoApplicantTownship':  '20',
    'CoApplicantHousingStatus':  '20',
    'CoApplicantRentAmount':  'decimal',
    'CoApplicantYearsAtAddress':  'decimal',
    'CoApplicantMonthsAtAddress':  'decimal',
    'CoApplicantLandlordPhone':  '30',
    'CoApplicantPriorAddress':  '20',
    'CoApplicantPriorCity':  '25',
    'CoApplicantPriorState':  '2',
    'CoApplicantPriorZipcode':  '10',
    'CoApplicantYearsAtPriorAddress':  'decimal',
    'CoApplicantMonthsAtPriorAddress':  'decimal',
    'CoApplicantEmploymentName':  '25',
    'CoApplicantEmploymentAddress':  '10',
    'CoApplicantEmploymentCity':  '25',
    'CoApplicantEmploymentState':  '2',
    'CoApplicantEmploymentZipCode':  '10',
    'CoApplicantEmploymentTitle':  '15',
    'CoApplicantYearsAtEmployment':  'decimal',
    'CoApplicantMonthsAtEmployment':  'decimal',
    'CoApplicantEmploymentPhone':  '12',
    'CoApplicantHourlyPay':  'decimal',
    'CoApplicantHoursWorked':  'decimal',
    'CoApplicantEmploymentPayday':  '10',
    'CoApplicantOtherIncomeAmount':  'decimal',
    'CoApplicantOtherIncomeSource':  '25',
    'CoApplicantReasonForLeaving':  '50',
    'CoApplicantBankruptcy':  '3',
    'CoApplicantBankruptcyDate':  'datetime',
    'CoApplicantRepo':  '3',
    'CoApplicantRepoDate':  'datetime',
    'CoApplicantRepoReason':  '400',
    'CoApplicantBankName':  '20',
    'CoApplicantBankCity':  '15',
    'CoApplicantChecking':  '20',
    'CoApplicantSavings':  '20',
    'CoApplicantUtilitiesAmount':  'decimal',
    'CoApplicantChildCare':  '20',
    'Lot':  '4'
}