ss
Tables (50)
ACHSchedule
- amount — FLOAT
- startDate — VARCHAR(255)
- endDate — VARCHAR(255)
- frequency — VARCHAR(255)
- leadId — VARCHAR(255)
- paused — BOOLEAN
- bankId — VARCHAR(255)
- bankTxnProcessor — VARCHAR(255)
- bankTxnProcessorDescriptor — VARCHAR(255)
AMQCategorySum
- id — VARCHAR(255)
- count — INT
- category — VARCHAR(255)
AMQDealData
- leadId — VARCHAR(255)
- amStatusId — VARCHAR(255)
- entityName — VARCHAR(255)
- amStatus — VARCHAR(255)
- usersAssigned — TEXT
- eaAssigned — TEXT
- rtrBalance — INT
- lastPaymentDate — INT
- variance — INT
- antReceivedPercent — INT
- returnCount — INT
- recentReturnCount — INT
- lastReturnDate — INT
- followupCount — INT
- minFollowupDate — INT
- minFollowupNote — VARCHAR(255)
- lastReturnDatePretty — VARCHAR(255)
- lastPaymentDatePretty — VARCHAR(255)
- category — VARCHAR(255)
- dealStatus — VARCHAR(255)
- fundedDate — INT
- returnRate — INT
- recentReturnRate — INT
- countPaymentsAttempted — INT
- countPaymentsAttemptedLastMonth — INT
- amountPaymentsAttempted — INT
- amountPaymentsAttemptedLastMonth — INT
- returnAmount — INT
- recentReturnAmount — INT
- percentCollected — INT
- collectedAntPercent30 — INT
- linearSpeed — INT
- collected30 — INT
- antCollected30 — INT
- tags — TEXT
- writeoffAmount — FLOAT
- writeoffBalance — FLOAT
- writeoffDate — VARCHAR(255)
- originalTermDays — FLOAT
- totalCommissionAmount — FLOAT
- totalUpfrontFees — FLOAT
- paymentAmount — FLOAT
- paymentFrequency — VARCHAR(255)
- companyLienPosition — FLOAT
- borrowingBaseLienPosition — FLOAT
- expectedPayoffDate — VARCHAR(255)
- naicsCode — VARCHAR(255)
- lastPaymentAmount — FLOAT
- recentReturnCount7Days — INT
- recentReturnCount60Days — INT
- syndications — TEXT
- defaultDate — VARCHAR(255)
- defaultReason — VARCHAR(255)
- last7dayVariance — FLOAT
- last7dayVariancePercent — FLOAT
- last30dayVariance — FLOAT
- last30dayVariancePercent — FLOAT
- activeFeesBalance — FLOAT
- discounts — FLOAT
- antDays — FLOAT
- … +4
AMQueueData
- deals — TEXT
- catSums — TEXT
AMStatusHistory
- leadId — VARCHAR(255)
- status — VARCHAR(255)
- date — VARCHAR(255)
- isCurrent — FLOAT
- username — VARCHAR(255)
AccountMonitoringSnapshotQuery
- amStatusId — VARCHAR(255)
- wlpId — VARCHAR(255)
- includeClosedDeals — BOOLEAN
- includeWriteoffDeals — BOOLEAN
- leadId — INT
AdvancedSearchQuery
- lead — TEXT
- principal — TEXT
- offset — INT
- limit — INT
BankTransaction
- id — VARCHAR(255)
- dateSent — VARCHAR(255)
- dateSettled — VARCHAR(255)
- dateReturned — VARCHAR(255)
- dateReturnedProcessor — VARCHAR(255)
- status — VARCHAR(255)
- counterPartyType — VARCHAR(255)
- counterPartyId — VARCHAR(255)
- processor — VARCHAR(255)
- accountNumber — VARCHAR(255)
- routingNumber — VARCHAR(255)
- processorReferenceNumber1 — VARCHAR(255)
- amount — FLOAT
- returnCode — VARCHAR(255)
- achTrace — VARCHAR(255)
- achBankName — VARCHAR(255)
- transactionStatusCode — VARCHAR(255)
- transactionStatusDetail — VARCHAR(255)
- isSameDay — BOOLEAN
- txnEntryDescription — VARCHAR(255)
- achScheduleId — VARCHAR(255)
BankingInfo
- id — INT
- designation — VARCHAR(255)
- bankName — VARCHAR(255)
- customerName — VARCHAR(255)
- accountNumber — VARCHAR(255)
- routingNumber — VARCHAR(255)
- accountType — VARCHAR(255)
- achCode — VARCHAR(255)
BankingTotals
- year — FLOAT
- month — FLOAT
- avgBal — FLOAT
- deposits — FLOAT
- numDeposits — FLOAT
- end — FLOAT
- nsfs — FLOAT
- negativeDays — FLOAT
- negativeBusinessDays — FLOAT
- transfers — FLOAT
- advances — FLOAT
- advancePayments — FLOAT
- netDeposits — FLOAT
- nonBusinessRevenue — FLOAT
- trueNegativeDays — FLOAT
- collections — FLOAT
DealDeclineReason
- id — INT
- leadId — INT
- reasonId — INT
- reasonText — VARCHAR(255)
- timestamp — VARCHAR(255)
- username — VARCHAR(255)
- remarks — VARCHAR(255)
- exceptionCode — VARCHAR(255)
- exceptionName — VARCHAR(255)
- updatedOn — VARCHAR(255)
DealException
- id — VARCHAR(255)
- leadId — VARCHAR(255)
- createdOn — VARCHAR(255)
- createdBy — VARCHAR(255)
- approvedOn — VARCHAR(255)
- approvedBy — VARCHAR(255)
- parentType — VARCHAR(255)
- parentName — VARCHAR(255)
- exceptionCode — VARCHAR(255)
- exceptionName — VARCHAR(255)
EarlyPaymentTerms
- id — VARCHAR(255)
- minDays — FLOAT
- maxDays — FLOAT
- mode — VARCHAR(255)
- value — VARCHAR(255)
- termType — VARCHAR(255)
- clawbackPoints — FLOAT
ExternalData
- source — VARCHAR(255)
- product — VARCHAR(255)
- data — TEXT
FeeInfo
- leadId — VARCHAR(255)
- amount — FLOAT
- name — VARCHAR(255)
- dateAdded — VARCHAR(255)
- feeType — VARCHAR(255)
File
- id — INT
- leadId — VARCHAR(255)
- category — VARCHAR(255)
- content — VARCHAR(255)
- name — VARCHAR(255)
FlexACHProcessor
- leadId — VARCHAR(255)
- flexProcessorMid — VARCHAR(255)
- processorName — VARCHAR(255)
- processorUrl — VARCHAR(255)
- username — VARCHAR(255)
- password — VARCHAR(255)
- status — VARCHAR(255)
- cardType — TEXT
- createdOn — VARCHAR(255)
- note — VARCHAR(255)
- lastCompletePeriod — VARCHAR(255)
- lastPeriod — VARCHAR(255)
- bankId — INT
- collecting — BOOLEAN
FundingSnapshotQuery
- sdate — VARCHAR(255)
- edate — VARCHAR(255)
- leadId — INT
- assignPurposeId — VARCHAR(255)
- assignedUsername — VARCHAR(255)
- assignedUserId — VARCHAR(255)
FundingStat
- leadId — INT
- entityName — VARCHAR(255)
- fundingType — VARCHAR(255)
- fundingCompany — VARCHAR(255)
- fundedDate — VARCHAR(255)
- advance — FLOAT
- rtr — FLOAT
- upfrontComm — FLOAT
- upfrontCommAmount — FLOAT
- resComm — FLOAT
- backendComm — FLOAT
- mainIso — VARCHAR(255)
- isoRep — TEXT
- syndicated — FLOAT
- industryType — VARCHAR(255)
- industryTypeNaicsCategory — VARCHAR(255)
- sicCode — VARCHAR(255)
- antTermMonths — FLOAT
- lienPosition — FLOAT
- entityState — VARCHAR(255)
- ficoAvg — VARCHAR(255)
- entityTib — FLOAT
- naicsCode — FLOAT
- naicsName — VARCHAR(255)
- antDays — FLOAT
- upfrontFees — FLOAT
- expectedPayFrequency — VARCHAR(255)
- expectedPayAmount — FLOAT
- entityZip — VARCHAR(255)
- avgMonthlyRevenue — FLOAT
- collectionRate — FLOAT
- apr — FLOAT
- assignments — TEXT
History
- leadId — VARCHAR(255)
- timestamp — VARCHAR(255)
- username — VARCHAR(255)
- action — VARCHAR(255)
- oldObject — VARCHAR(255)
- newObject — VARCHAR(255)
- otherId — VARCHAR(255)
IsoInfo
- id — INT
- companyName — VARCHAR(255)
- companyDba — VARCHAR(255)
- email — TEXT
- upfrontCommissionPercent — FLOAT
- upfrontCommissionBase — VARCHAR(255)
- isActive — BOOLEAN
- isInternal — BOOLEAN
- isRenewal — BOOLEAN
- isWhitelabel — BOOLEAN
- priorityLevel — FLOAT
- otherEmails — TEXT
Lead
- leadId — VARCHAR(255)
- customerId — VARCHAR(255)
- dateSubmitted — VARCHAR(255)
- fundedDate — VARCHAR(255)
- entityName — VARCHAR(255)
- entityDba — VARCHAR(255)
- fein — VARCHAR(255)
- entityType — VARCHAR(255)
- entityAddress1 — VARCHAR(255)
- entityAddress2 — VARCHAR(255)
- entityCity — VARCHAR(255)
- entityState — VARCHAR(255)
- entityCounty — VARCHAR(255)
- entityZip — VARCHAR(255)
- entityTelephone — VARCHAR(255)
- salesVolume — FLOAT
- industryTypeNaicsId — VARCHAR(255)
- industryTypeNaicsName — VARCHAR(255)
- amountRequested — FLOAT
- loanPurpose — VARCHAR(255)
- entityStartDate — VARCHAR(255)
- lengthOfCurrentOwnership — VARCHAR(255)
- entityEmail — VARCHAR(255)
- principals — TEXT
- iso — VARCHAR(255)
- sicCode — VARCHAR(255)
- timestamp — VARCHAR(255)
- inactiveIsoSubmission — BOOLEAN
- assignments — TEXT
- totalERCClaimedRefund — FLOAT
- entityBillingAddress1 — VARCHAR(255)
- entityBillingAddress2 — VARCHAR(255)
- entityBillingCounty — VARCHAR(255)
- uwStatusName — VARCHAR(255)
- entityStateOfIncorporation — VARCHAR(255)
- updatedOn — VARCHAR(255)
- engagementType — VARCHAR(255)
- whitelabel — VARCHAR(255)
- Field
LeadContact
- leadId — VARCHAR(255)
- status — VARCHAR(255)
- contactType — VARCHAR(255)
- email — VARCHAR(255)
- phoneType — VARCHAR(255)
- phone — VARCHAR(255)
- zip — VARCHAR(255)
- state — VARCHAR(255)
- city — VARCHAR(255)
- address — VARCHAR(255)
- name — VARCHAR(255)
LeadIsoInfo
- leadId — VARCHAR(255)
- isoName — VARCHAR(255)
- residualComm — FLOAT
- upfrontComm — FLOAT
- backendComm — FLOAT
- baseFactor — FLOAT
- mainIso — VARCHAR(255)
- isoId — VARCHAR(255)
- isoCode — VARCHAR(255)
- leadSubmissionDate — VARCHAR(255)
- isActive — BOOLEAN
LeadQuery
- entityName — VARCHAR(255)
- entityDba — VARCHAR(255)
- entityFederalId — VARCHAR(255)
- entityTelephone — VARCHAR(255)
LeadTag
- leadId — INT
- tag — VARCHAR(255)
- assignedBy — VARCHAR(255)
- assignedOn — VARCHAR(255)
Note
- leadId — VARCHAR(255)
- timestamp — VARCHAR(255)
- note — VARCHAR(255)
- section — VARCHAR(255)
- isImportant — BOOLEAN
- enteredByUser — VARCHAR(255)
- tags — TEXT
OfferInfo
- id — VARCHAR(255)
- leadId — VARCHAR(255)
- advanceAmount — FLOAT
- selectedAdvance — FLOAT
- buyRate — FLOAT
- maxCommission — FLOAT
- position — INT
- paymentAmount — FLOAT
- payFrequency — VARCHAR(255)
- sellRate — FLOAT
- termMonths — FLOAT
- totalUpfrontFees — FLOAT
- productType — VARCHAR(255)
- commission — FLOAT
- numPayments — FLOAT
- timestamp — FLOAT
- selectedTimestamp — FLOAT
- mainIsoId — VARCHAR(255)
- uwStatusId — VARCHAR(255)
- uwStatusName — VARCHAR(255)
- links — TEXT
OfferLink
- id — INT
- link — VARCHAR(255)
- isoId — VARCHAR(255)
- expiresTimestamp — INT
- offerSelectedTimestamp — INT
PaymentPromise
- status — VARCHAR(255)
- amount — FLOAT
- dateDue — VARCHAR(255)
Position
- id — FLOAT
- companyName — VARCHAR(255)
- balance — FLOAT
- paymentAmount — FLOAT
- payFrequency — VARCHAR(255)
- termMonths — FLOAT
- isPayingOff — BOOLEAN
- fundedDate — VARCHAR(255)
- isCompetitor — BOOLEAN
- dealType — VARCHAR(255)
- leadId — VARCHAR(255)
- fundedAmount — FLOAT
Principal
- id — VARCHAR(255)
- leadId — VARCHAR(255)
- firstName — VARCHAR(255)
- lastName — VARCHAR(255)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- city — VARCHAR(255)
- state — VARCHAR(255)
- county — VARCHAR(255)
- zip — VARCHAR(255)
- phone — VARCHAR(255)
- email — VARCHAR(255)
- percentageOwnership — FLOAT
- ssn — VARCHAR(255)
- latestExperianScore — VARCHAR(255)
- latestExperianScoreDate — VARCHAR(255)
- principalType — VARCHAR(255)
- driversLicense — VARCHAR(255)
- driversLicenseState — VARCHAR(255)
- dob — VARCHAR(255)
- title — VARCHAR(255)
PrincipalQuery
- nameLast — VARCHAR(255)
- nameFirst — VARCHAR(255)
- socialSecurityNumber — VARCHAR(255)
- email — VARCHAR(255)
- cellPhone — VARCHAR(255)
- homePhone — VARCHAR(255)
- homeAddress — VARCHAR(255)
- city — VARCHAR(255)
- state — VARCHAR(255)
- zip — VARCHAR(255)
PromiseToPay
- leadId — VARCHAR(255)
- promiseAmt — FLOAT
- paymentMethod — VARCHAR(255)
- createdOn — VARCHAR(255)
- dueDate — VARCHAR(255)
- bankId — VARCHAR(255)
- amount — FLOAT
- status — VARCHAR(255)
- achStartDate — VARCHAR(255)
- achProcessorDescriptor — VARCHAR(255)
- createdBy — VARCHAR(255)
Stip
- name — VARCHAR(255)
- leadId — VARCHAR(255)
- status — VARCHAR(255)
- dateAdded — VARCHAR(255)
SyndicationInfo
- partnerName — VARCHAR(255)
- percent — FLOAT
- upfrontMgmtFee — FLOAT
- upfrontComm — FLOAT
- leadId — VARCHAR(255)
SyndicationPartner
- id — INT
- name — VARCHAR(255)
ThirdParty
- id — INT
- payee — VARCHAR(255)
- amount — FLOAT
- payType — VARCHAR(255)
Transaction
- id — VARCHAR(255)
- netCollection — FLOAT
- recoveries — FLOAT
- writeoffs — FLOAT
- customerId — VARCHAR(255)
- leadId — VARCHAR(255)
- date — VARCHAR(255)
- rtrBalance — FLOAT
- writeoffBalance — FLOAT
- antPaymentAmount — FLOAT
- feesAdded — FLOAT
- feesCollected — FLOAT
- revenueBalance — FLOAT
- advanceBalance — FLOAT
TransactionDetails
- id — VARCHAR(255)
- dateUploaded — VARCHAR(255)
- customerId — VARCHAR(255)
- leadId — VARCHAR(255)
- datePosted — VARCHAR(255)
- bank — VARCHAR(255)
- subBank — VARCHAR(255)
- amount — FLOAT
- feesCollected — FLOAT
- revenueCollected — FLOAT
- advanceCollected — FLOAT
- revenueCollectedRecoveries — FLOAT
- advanceCollectedRecoveries — FLOAT
- note — VARCHAR(255)
- returnCode — VARCHAR(255)
- achTrace — VARCHAR(255)
- achBankName — VARCHAR(255)
- achBankAccountNr — VARCHAR(255)
- achBankRoutingNr — VARCHAR(255)
- mid — VARCHAR(255)
- achProcessor — VARCHAR(255)
- achDescriptor — VARCHAR(255)
UWStatusHistory
- leadId — VARCHAR(255)
- status — VARCHAR(255)
- date — VARCHAR(255)
- isCurrent — FLOAT
- username — VARCHAR(255)
- isoId — VARCHAR(255)
- isoName — VARCHAR(255)
UnderwritingInfo
- leadId — VARCHAR(255)
- customerId — VARCHAR(255)
- status — VARCHAR(255)
- submissionDate — VARCHAR(255)
- updatedStatusDate — VARCHAR(255)
- uwStatus — VARCHAR(255)
- uwStatusEnteredDate — VARCHAR(255)
- uwStatusDate — VARCHAR(255)
- currentStatus — VARCHAR(255)
- statusList — TEXT
- positions — TEXT
- fundingType — VARCHAR(255)
- position — VARCHAR(255)
- monthlyBankingTotals — TEXT
- combinedBankingTotals — VARCHAR(255)
- stips — TEXT
- offers — TEXT
UnderwritingSnapshotQuery
- isoId — VARCHAR(255)
- isoIds — TEXT
- leadIds — TEXT
- leadSearchKeyword — VARCHAR(255)
- submissionTimestampStart — VARCHAR(255)
- submissionTimestampEnd — VARCHAR(255)
- status — VARCHAR(255)
- uwStatus — VARCHAR(255)
- uwStatuses — TEXT
- leadId — VARCHAR(255)
- assignPurposeId — VARCHAR(255)
- assignedUserId — VARCHAR(255)
- offset — FLOAT
- limit — FLOAT
UnderwritingStat
- leadId — VARCHAR(255)
- submissionTimestamp — VARCHAR(255)
- entityName — VARCHAR(255)
- offers — TEXT
- contractsOutDate — VARCHAR(255)
- contractsInDate — VARCHAR(255)
- fundedDate — VARCHAR(255)
- status — VARCHAR(255)
- uwStatus — VARCHAR(255)
- declineReasons — TEXT
- advanceAmount — FLOAT
- rtrAmount — FLOAT
- isoName — VARCHAR(255)
- isoId — VARCHAR(255)
- assignments — TEXT
UserAssignment
- userFirstName — VARCHAR(255)
- userLastName — VARCHAR(255)
- leadId — VARCHAR(255)
- username — VARCHAR(255)
- assignPurpose — VARCHAR(255)
- assignedBy — VARCHAR(255)
- note — VARCHAR(255)
- assignedOn — VARCHAR(255)
UserInfo
- id — VARCHAR(255)
- username — VARCHAR(255)
- nameFirst — VARCHAR(255)
- nameLast — VARCHAR(255)
Wallet
- id — INT
- name — VARCHAR(255)
- balance — FLOAT
- partnerType — VARCHAR(255)
- partnerId — VARCHAR(255)
- updatedOn — VARCHAR(255)
WorksheetDetails
- month — VARCHAR(255)
- year — FLOAT
- includeMonth — BOOLEAN
- openBalance — FLOAT
- deposits — FLOAT
- end — FLOAT
- nsfs — FLOAT
- negativeDays — FLOAT
- negativeBusinessDays — FLOAT
- numDeposits — FLOAT
- transfers — FLOAT
- advances — FLOAT
- advancePayments — FLOAT
- nonBusinessRevenue — FLOAT
- netDeposits — FLOAT
- collections — FLOAT
Worksheets
- leadId — VARCHAR(255)
- name — VARCHAR(255)
- accountNumber — FLOAT
- routingNumber — FLOAT
- customerName — VARCHAR(255)
- year — FLOAT
- worksheetDetails — TEXT
Writeoff
- id — VARCHAR(255)
- leadId — VARCHAR(255)
- writeoffDate — VARCHAR(255)
- writeoffAmount — FLOAT
- writeoffAmountAdvance — FLOAT
- writeoffAmountRevenue — FLOAT
- defaultDate — VARCHAR(255)
- defaultDescription — VARCHAR(255)
- recoveries — FLOAT
- recoveriesAdvance — FLOAT
- recoveriesRevenue — FLOAT
- writeoffBalance — FLOAT
- writeoffBalanceAdvance — FLOAT
- writeoffBalanceRevenue — FLOAT