RdsDiagram
Company
id: INTEGER
address1: VARCHAR(255)
name: VARCHAR(255)
address2: VARCHAR(255)
city: VARCHAR(255)
countryID: INTEGER
email: VARCHAR(255)
phone: VARCHAR(255)
contactname: VARCHAR(255)
APR: DECIMAL(18,2)
staff
id: INTEGER
role: INTEGER
company_id: INTEGER
company_branch_id: INTEGER
lastlogin: datetime
dateadded: datetime
lastupdated: datetime
active: bit
datestarted: datetime
dateended: datetime
password: VARCHAR(255)
emailx: VARCHAR(255)
namex: VARCHAR(250)
ipaddress: VARCHAR(250)
imagex: VARCHAR(250)
UpdateDate: DATE
staff_logs
id: INTEGER
staff_id: INTEGER
notesx: TEXT
whenx: datetime
company_id: INTEGER
Payment_Methods
id: INTEGER
Name: VARCHAR(255)
company_id: INTEGER
whenx: DATE
Country
id: INTEGER
name: VARCHAR(255)
Exception
Ex_Id: INTEGER
whenx: Datetime
Error: VARCHAR(500)
Error_Details: Text
Source_page: VARCHAR(500)
source_Event: VARCHAR(255)
CompanyID: INTEGER
Action
Action_ID: INTEGER
Action_Name: VARCHAR(255)
whenX: DATE
isActive: bit
Action_Details
Action_Detail_ID: INTEGER
Action_ID: INTEGER
Action_Name: VARCHAR(255)
Action_Date: DATE
isActive: bit
Notes: VARCHAR(8000)
Computer_Details: Text
UID: INTEGER
Accounts
AccNo: nvarchar
company_branch_id: INTEGER
AccountNumber: VARCHAR(255)
AccountType: nvarchar
AccountName: nvarchar
Address Line1: nvarchar
DD Signed: bit
Address Line2: nvarchar
Address Line3: nvarchar
PhoneWork: bit
MobWork: bit
WorkWork: bit
IncExp: datetime
Town: nvarchar
Post Code: VARCHAR(50)
Country/Region: nvarchar
Home Tel: nvarchar
Mobile: nvarchar
Work Tel: nvarchar
Job: nvarchar
Job Type: nvarchar
Email: nvarchar
Employer: nvarchar
Emp Add L1: nvarchar
Emp Add L2: nvarchar
Emp Add L3: nvarchar
Emp Town: nvarchar
Emp Post Code: nvarchar
Emp Tel: nvarchar
Partner Name: nvarchar
Family: nvarchar
DOB: nvarchar
PayCodeID: INTEGER
PayDate: datetime
PayFreq: nvarchar
Bank: nvarchar
Bank Address: nvarchar
Bank Tel: nvarchar
Bank Account: nvarchar
Bank Sort Code: nvarchar
Bank Roll Number: nvarchar
ClientType: nvarchar
ClientCatType: nvarchar
PPP: bit
Life: bit
Redundancy: bit
Health: bit
Personal Comments: nvarchar
Notes: nvarchar
LastComm: nvarchar
Date of LastComm: nvarchar
Rem: nvarchar
Sec
Rpt
Gar
Diary
DateAdded
BACSOfficeID
BACSUniquenessChar
BACSAmount
BACSStartDate
BACSFreq
BACSDayofMonth
BACSDateofMonth
BACSNextDate
AccountType
AccountType: nvarchar
Type: nvarchar
Accounts_ExportErrors
Error: nvarchar
Field: nvarchar
Row: INTEGER
Add Charges Batches
Batch Number: INTEGER
Week Number: INTEGER
Payment Type Id: INTEGER
Amount: NUMERIC(18,2)
AccountNumber: nvarchar
Flag: nvarchar
Bal: NUMERIC(18,2)
Date: datetime
Arr: NUMERIC(18,2)
Arrears
AccountNumber: nvarchar
AcountType: nvarchar
PayFreq: nvarchar
Pay: nvarchar
Wk
Mnth
Arrs
Act
ActC
ActP
MArr
TArr
LFlag
OFlag
PFlag
DFlag
AFlag
EstPay
BACSPost
AccountNumber: nvarchar
BACSAmount: NUMERIC(18,2)
Balance to Date: NUMERIC(18,2)
BACSPostImport
AccountNumber: nvarchar
BACSAmount: NUMERIC(18,2)
Batch Number: nvarchar
Week Number: nvarchar
company_branch_id: INTEGER
BACSPostingLog
ID: INTEGER
BACSPostfilename: nvarchar
BACSPostDate: datetime
BACSREportTable
ID: INTEGER
AccountNumber: nvarchar
AccountName: nvarchar
Bank Account: nvarchar
Bank Sort Code: nvarchar
BACSAmount: NUMERIC(18,2)
BACSDate: datetime
BACSTable
ID: INTEGER
AccountNo: nvarchar
AccountNumber: nvarchar
AccountName: nvarchar
Bank Account
Bank Sort Code
BACSAmount
BACSFreq
BACSDayofMonth
BACSDateofMonth
BACSNextDate
Balance to Date
Bad Debts
ID: INTEGER
BadAcc: nvarchar
Original Type
Date
Balanced
Balances
ID: INTEGER
AccountID: nvarchar
Credit Limit: NUMERIC(18,2)
Opening Balance: NUMERIC(18,2)
Date of Commencement
Date due to End
Estimated Payment
Number of Estimated Payments
Made
Number of Actual Payments
Made
Value of Estimated Payments
Made
Value of Actual Payments Made
Week Number of Last Actual
Payment Made
Arrears
Balance To Date
Date of Last Payment
Actual Last pay
Pay Type
Date of Last Loan
Tot Last Loan
RemFlag
APR
Batch Payment Types
Payment Type Id: INTEGER
Payment Text: nvarchar
Batches
Batch Number: INTEGER
Week Number: INTEGER
column: INTEGER
Payment Type Id
Amount
Int
Ins
Tot
AccountNumber
Flag
Bal
Date
Agreed Pay
No of Pays
Arr
company_branch_id
ClientCatTypes
ClientTypeID: INTEGER
ClientType: nvarchar
ClientOrgTypes
ClientNum: INTEGER
ClientTypeID: INTEGER
ClientType: INTEGER
ClientScreenDump
AccountNumber: nvarchar
CommunicationType: INTEGER
Date of Comm: datetime
Loan Amount: NUMERIC(-18,2)
Discount Batches
Batch Number: INTEGER
Week Number: INTEGER
Payment Type Id
Amount
AccountNumber
Flag
Bal
Date
Arr
Guarantors
ID: INTEGER
Account Number: nvarchar
Guarantor Name: nvarchar
Address Line1
Address Line2
Address Line3
Town
PostCode
Region
Home Tel
Mobile
Work tel
Employer
Employer Address
Job Description
List
AccNo: INTEGER
AccountNumber: nvarchar
AccountName: nvarchar
Address Line1
Address Line2
Address Line3
Post Code
Loans Batch
Batch Number: nvarchar
Account Id: nvarchar
Loan Amount
Loan Insurance
Loan Interest
Loan Total
Date Opened
Week Number
Agreed Pay
Number of Pays Due
Flag
Bal
Settled Date
Arr
Loans Settled
Batch Number: nvarchar
Account Id: nvarchar
Loan Amount: NUMERIC(18,2)
Loan Insurance
Loan Interest
Loan Total
Date Opened
Week Number
Agreed Pay
Number of Pays Due
Date Settled
MonthlyArrearsPressTracking
ID: INTEGER
TimePressed: datetime
MSysCompactError
ErrorCode: INTEGER
ErrorDescription: text
ErrorRecid: BINARY(500)
ErrorTable: nvarchar
OpeningBals
Batch Number: nvarchar
Week Number: INTEGER
Payment Type Id
Amount
Int
Ins
Tot
AccountNumber
Flag
Bal
Date
Agreed Pay
No of Pays
PayCodes
PayCodeID: INTEGER
PayMethod: nvarchar
Payment Batches History
Batch Number: nvarchar
Week Number: INTEGER
Payment Type Id
Amount
Int
Ins
Tot
AccountNumber
Flag
Bal
Date
Agreed Pay
No of Pays
Settled Date
Payment Batches
Batch Number: nvarchar
Week Number: INTEGER
Payment Type Id
Amount
Int
Ins
Tot
AccountNumber
Flag
Bal
Date
Agreed Pay
No of Pays
PArr
Trxno
Arr
Payment__Batches_History_ExportErrors
Error: nvarchar
Field: nvarchar
Row: INTEGER
Payment_Batches_ExportErrors
Error: nvarchar
Field: nvarchar
Row: INTEGER
Posted
PostingFlag: nvarchar
Batch Number: nvarchar
Week Number
Payment Type Id
Amount
AccountNumber
Balance after Posting
Posting Table
PostingFlag: nvarchar
Batch Number: nvarchar
Week Number
Payment Type Id
Amount
AccountNumber
Balance after Posting
PPP Batches
Batch Number: nvarchar
Week Number: INTEGER
Payment Type Id
Amount
Int
Ins
Tot
AccountNumber
Flag
Bal
Date
Agreed Pay
No of Pays
Arr
Private List
AccNo: bit
AccountNumber: nvarchar
AccountName
Address Line1
Address Line2
Address Line3
Post Code
SecondNameAccounts
AccNo: INTEGER
AccountNumber: nvarchar
AccountName2
Address Line1
Address Line2
Address Line3
Town
Post Code
Country/Region
Home Tel
Mobile
Work Tel
Job
Job Type
Employer
Emp Add L1
Emp Add L2
Emp Add L3
Emp Town
Emp Post Code
Emp Tel
Notes
Selection
AccNo: nvarchar
TbMailHistory
CommID: INTEGER
AccountId
CommType
CommDate
WeekNo
tbMailMerge
AccNo: nvarchar
MMID: INTEGER
tbMailTypes
CommsTypes: INTEGER
CommsTypesDescriptives: nvarchar
To Post Table
Batch Number: nvarchar
Week Number: INTEGER
Payment Type Id
Amount
AccountNumber
Balance after Posting
PostingFlag
TrackArrearsBttnPressed
ID: INTEGER
Track New Button Pressed: datetime
Transaction File
WkNum: INTEGER
TBF: NUMERIC(18,2)
TLoan
TInt
TIns
TTotal
TPays
TDiscs
TAdd
TArrears
TCF
StartDate
EndDate
Transaction File BD
WkNum: INTEGER
TBF: NUMERIC(18,2)
TLoan
TInt
TIns
TTotal
TPays
TDiscs
TAdd
TArrears
TCF
StartDate
EndDate
Weekly Reconciliation File
Week Number: INTEGER
Brought Forward: NUMERIC(18,2)
Loan
Interest
Insurance
TotalLoans
Payments
Discounts
AddCharges
Arrears
Carried Forward
Reconciled
Next Week Number
company_branch_id
Weekly Reconciliation File BD
Week Number: INTEGER
Brought Forward: NUMERIC(18,2)
Loan
Interest
Insurance
TotalLoans
Payments
Discounts
AddCharges
Arrears
Carried Forward
Reconciled
Next Week Number
company_branch_id
Yearly Reconciliation File
Year Number: INTEGER
Brought Forward: NUMERIC(18,2)
Loan
Interest
Insurance
TotalLoans
Payments
Discounts
AddCharges
Arrears
BadDebt
Carried Forward
Reconciled
Next Year Number
StartDate
EndDate
Company_branch
id: INTEGER
company_id: INTEGER
branch_name: VARCHAR(255)
branch_manager_name: VARCHAR(255)
add_line1: VARCHAR(255)
add_line2: VARCHAR(255)
city: VARCHAR(255)
post_code: VARCHAR(255)
tel_num: VARCHAR(20)
mobile_no: VARCHAR(20)
Accounts_extra
id: INTEGER
accountsNo: nvarchar
Loan_amount_option: INTEGER
Purpose_of_Loan: VARCHAR(255)
how_you_hear_about_us: VARCHAR(255)
joint_applicant_name: VARCHAR(255)
relationship: VARCHAR(255)
Joint_Applicant_DOB: datetime
Marital_status: VARCHAR(255)
add1_time_of_add_year: VARCHAR(255)
add1_time_of_add_month: VARCHAR(255)
add1_home_status: VARCHAR(255)
prev_add_line1: VARCHAR(255)
prev_add_line2: VARCHAR(255)
prev_add_town: VARCHAR(255)
prev_add_postcode: VARCHAR(255)
prev_add_time_of_add_year: VARCHAR(255)
prev_add_time_of_add_month: VARCHAR(255)
prev_add_home_status: VARCHAR(255)
prev_add_contact_phone_number: VARCHAR(255)
prev_add_contact_mobile_number: VARCHAR(255)
prev_add_email: VARCHAR(255)
Occupation1_work_email: VARCHAR(255)
Occupation1_time_in_job_year: VARCHAR(255)
Occupation1_time_in_job_months: VARCHAR(255)
Occupation2_jobtitle: VARCHAR(255)
Occupation2_Employer_name: VARCHAR(255)
Occupation2_Employer_tel_number: VARCHAR(255)
Occupation2_work_email: VARCHAR(255)
Occupation2_time_in_job_year: VARCHAR(255)
Occupation2_time_in_job_months: VARCHAR(255)
Income_net_wage: VARCHAR(255)
income_tax_credits: VARCHAR(255)
Income_child_benefit: VARCHAR(255)
income_pension: VARCHAR(255)
income_partner: VARCHAR(255)
total_income: VARCHAR(255)
Expenditure_rent_mortage_dig: VARCHAR(255)
Expenditure_council_tax: VARCHAR(255)
Expenditure_gas_electric: VARCHAR(255)
Expenditure_tv_licence: VARCHAR(255)
Expenditure_bank_loan: VARCHAR(255)
Expenditure_car_loan: VARCHAR(255)
Expenditure_other_loan1: VARCHAR(255)
Expenditure_other_loan2: VARCHAR(255)
Expenditure_credit_card1: VARCHAR(255)
Expenditure_credit_card2: VARCHAR(255)
Expenditure_store_card: VARCHAR(255)
Expenditure_catelogue: VARCHAR(255)
Expenditure_cable_satellite_tv: VARCHAR(255)
Expenditure_broadband: VARCHAR(255)
Expenditure_tel: VARCHAR(255)
Expenditure_mobile: VARCHAR(255)
Expenditure_insurance: VARCHAR(255)
Expenditure_other: VARCHAR(255)
company_branch_id: INTEGER
whenx: datetime
update_date: datetime
isDeleted: bit
totel_expend: VARCHAR(255)
surplus_income: VARCHAR(255)
JobTitle_Joint: VARCHAR(255)
Employer2: VARCHAR(255)
Employer2_address1: VARCHAR(255)
Employer2_address2: VARCHAR(255)
Employer2_address3: VARCHAR(255)
Employer2_postcode: VARCHAR(255)
TCName: VARCHAR(255)
TCAddress1: VARCHAR(255)
TCAddress2: VARCHAR(255)
TCAddress3: VARCHAR(255)
TCPostCode: VARCHAR(255)
AC_Connection1: VARCHAR(255)
AC_Connection1_Relationship: VARCHAR(255)
AC_Connection2: VARCHAR(255)
AC_Connection2_Relationship: VARCHAR(255)
AC_Connection3: VARCHAR(255)
AC_Connection3_Relationship: VARCHAR(255)
BACsNarrative: nvarchar
Other_Information: nvarchar
Universal_Credit: VARCHAR(255)
universl_credit_amt: DECIMAL(18,2)
Net_Wage_freq: VARCHAR(255)
Child_Benefit_freq: VARCHAR(255)
Partner_freq: VARCHAR(255)
Tax_Credits_freq: VARCHAR(255)
Pension_other_freq: VARCHAR(255)
Trace_Check_telephone: VARCHAR(255)
applicant_prev_addline1: VARCHAR(255)
applicant_prev_addline2: VARCHAR(255)
applicant_prev_add_town: VARCHAR(50)
applicant_prev_add_postcode: VARCHAR(30)
Subject_Notes_for_application
ID: INTEGER
Subject: VARCHAR(500)
Notes: text
whenx: datetime
communication_master
id: INTEGER
company_id: INTEGER
client_id: INTEGER
communication_type_id: INTEGER
communication_template_id: INTEGER
contact_date: DATE
staff_id: INTEGER
subject_id: INTEGER
chase_date: datetime
chase_notes: text
notesx: text
whenx: datetime
with_who: VARCHAR(255)
where_is: VARCHAR(255)
isArchived: bit
textx: VARCHAR(255)
communication_type
id: INTEGER
company_id: INTEGER
descx: text
whenx: datetime
communication_template
id: INTEGER
company_id: INTEGER
html_location: VARCHAR(255)
sms_text: text
whenx: datetime
communication_type_id: INTEGER
BacsFiles
ID: INTEGER
refnumber: VARCHAR(255)
surname: VARCHAR(50)
name: VARCHAR(255)
bank_account_number: VARCHAR(255)
bank_sort_code: VARCHAR(255)
bacs_amount: NUMERIC(18,2)
bacs_next_date: datetime
company_branch_id: INTEGER
whenx: datetime
updatedate: datetime
filename: VARCHAR(255)
account_balance_history
id: INTEGER
accountsNo: nvarchar
balance: DECIMAL(182,0)
whenx: datetime
mail_master_main
id: INTEGER
campaign_name: VARCHAR(255)
mail_master_campaign_id: INTEGER
staff_id: INTEGER
whenx: datetime
statusx: INTEGER
typex: bit
number_sent: INTEGER
whenx_sent: datetime
mail_master_statusx
id: INTEGER
descx: VARCHAR(255)
1 = created, 2=send in progress,
3=ALL sent successfully, 4=ALL
sent with errrors
mail_master_campaign_emails
id: INTEGER
mail_master_main_id: INTEGER
emailx_smsx: VARCHAR(255)
whenx: datetime
sentx: bit
mail_master_response: text
accounts_id: INTEGER
typex: bit
textx: text
unique_id_plivo: VARCHAR(255)
typex 0=email, 1=sms
typex 0=email, 1= sms,
number_sent only for SMS
screen_flag
ID: INTEGER
whenx: datetime
accountsNo: nvarchar
posx: INTEGER
screen_id: INTEGER