LeasePak Database Objects
LeasePak Documentation Suite NETSOL website
Home Search Help
LeasePak Database Objects
Return to Top

LeasePak Database Objects Oracle DBMS

Index of Tables and Views

'm' Tables 'r' Tables Views


'm' Tables

mj ml ms mw mx


Name Description
mja Asset Notebook
mjc Client Notebook
mjl Lease Notebook
mlt Lease Letter
msg Custom Messages
msvb Next Enhanced Payment Reversal Batch Number
msvc Next Client Number
msvh Next Check Number
msvi Next Invoice Number
msvl Next Lease/Application Number
msvr Next Reference Number
msvs Next Suspense Number
msvu Next Asset Number
msvv Next Reversal Suspense Number
mwa Application Work Schedule
mwc Collection Work Schedule
mwi Insurance Work Schedule
mwk Collateral Work Schedule
mwm Maturing Lease Work Schedule
mwr Recovery Work Schedule
mws Customer Service Work Schedule
mxd Last Update By

 

'r' Tables

ra rb rc rd re rf rg rh ri rj rk rl rm rn ro rp rq rr rs rt ru rv rw rx ry rz


Name Description
raa Recovery Agency Assignment
rab Activity Status/Substatus
rac Preauthorized Payments Control
rad Auto-Decisioning
radr Auto-Decisioning Rule
raf Application Flow
rag Recovery Agency
rai Historical General Ledger
raia Historical General Ledger Account
raj Historical General Ledger Pool
raja Historical General Ledger Pool Account
ral Lessee/Co-Lessee
rale Lessee/Co-Lessee Employment
ram Asset Meter
rap Application
rapa Application 2
rapd Application Document
raph Application Status History
rapp Application Payment Schedule
rapr Application Recurring Charge
raps Application Salesperson
rapv Application Subvention
raq Application Asset
raqc Application Asset Condition
raqp Application Asset Payment Schedule
raqu Application Asset UCC
rar Accounts Receivable
rarb Accounts Receivable Assessment
ras EOP Accrual System
rase EOP Module
rat Asset Meter Transaction
rau Application User Profile
rax Automatic Lease Extension
raxp Automatic Lease Extension Payment Schedule
raxr Automatic Lease Extension Recurring Charge
rba Batch Sale of Asset
rbb Batch Sale of Asset Reversal
rbc Batch Cash Control
rbd Batch Cash Control Detail
rbg Batch General Ledger Adjustment
rbga Batch General Ledger Adjustment Detail
rbi Billing Manager Interface
rbk Broker
rbl Target Principal
rblt Target Principal Amount
rbm Batch Meter
rbp Batch Payment
rbr Batch Book Requirements
rbs Batch Assessment
rca Lease Form
rcb Client Billing Receivable
rcba Client Billing Receivable Assessment
rcc Custom Code
rcd Change Due Day Tracking
rce Custom Edit Check Codes
rcf Custom Letter
rcfa Custom Letter 2
rcfb Custom Letter 3
rcg Custom General
rcgb Custom General 2
rcgf Custom General Printer Form
rcgg Custom General Letter Group
rcgl Custom General Printer Device
rcgu Custom General Field Name 1
rcgv Custom General Field Name 2
rcgw Custom General Field Name 3
rcgx Custom General Field Name 4
rcgy Custom General Field Name 5
rcgz Custom General Field Name 6
rch Change Key History
rck Cashier Check
rcm Credit Bureau Extract Client Modification
rco Collection Status Defaults
rcp Collection User Profile
rcr Custom Report
rcs Historical Asset
rcu Customer
rcx Client Search
rcy Extended Code Type
rcz Extended Code
rdc Application Document List Header
rdcd Application Document List
rdf Deferred Lease Income
rdh Dealer Transaction History
rdl Vendor Total
rdm Demographic
rdmi Demographic Insurance
rdp Dealer Plan Code
rdq Reason/Condition
rdr Deferral Reversal
rdrp Deferral Reversal - Orig Pmt Sched
rdrq Deferral Reversal - New Pmt Sched
rds Document Data Definition SQL
rdt Dealer Transaction
rdu Deferral Reversal Asset
rdx Document
reo End of Period Order
rep End of Period
repe End of Period Status
req Asset
reqa Asset 2
reqc Asset Condition
reqp Asset Payment Schedule
requ Asset UCC
rer Application Entry Requirement
res Equity Movement Status
rfa File Attachments
rfl Group
rfp Former Lease For Pool Maintenance
rfs Application Field Security
rft Deferred Tax
rfu Cost of Funds
rfx Fax
rgc Co-Lessee/Guarantor/User Defined Client Cross-reference
rgg Gain/Loss Reconciliation
rgl General Ledger
rglc General Ledger Account
rgp General Ledger Pool
rgpc General Ledger Pool Account
rgr Guarantor
rha Historical Accounts Receivable
rhab Historical Accounts Receivable Assessment
rhb Historical Client Billing Receivable
rhba Historical Client Billing Receivable Assessment
rhc Historical Recurring Charge Payment Schedule for Lease Extension/Reversal Header
rhcp Historical Recurring Charge Payment Schedule for Lease Extension/Reversal
rhf Historical Lease for Accrual/Billing Cycle Change/Reversal
rhfa Historical Lease 2 for Accrual/Billing Cycle Change/Reversal
rhfb Historical Lease 3 for Accrual/Billing Cycle Change/Reversal
rhfc Historical Lease Partial Deduction for Accrual/Billing Cycle Change/Reversal
rhfd Historical Lease 4 for Accrual/Billing Cycle Change/Reversal
rhfp Historical Lease Payment Schedule for Accrual/Billing Cycle Change/Reversal
rhfr Historical Lease Recurring Charge for Accrual/Billing Cycle Change/Reversal
rhfs Historical Lease Salesperson for Accrual/Billing Cycle Change/Reversal
rhfv Historical Lease Subvention for Accrual/Billing Cycle Change/Reversal
rhg Historical General Ledger Name
rhh Historical Principal Change for Reschedule Reversal
rhi Historical Monthly Interest Income for Lease Extension/Reversal
rhl Historical Lessee
rho Historical Location
rhp Historical Note Payable
rhq Historical Asset for Lease Extension/Reversal
rhqa Historical Asset 2 for Lease Extension/Reversal
rhqc Historical Asset Condition for Lease Extension/Reversal
rhqp Historical Asset Payment Schedule for Lease Extension/Reversal
rhqu Historical Asset UCC for Lease Extension/Reversal
rhr Historical Tax Released for Use Tax Disbursal
rhs Historical Lease for Lease Extension/Reversal
rhsa Historical Lease 2 for Lease Extension/Reversal
rhsb Historical Lease 3 for Lease Extension/Reversal
rhsc Historical Lease Partial Deduction for Lease Extension/Reversal
rhsd Historical Lease 4 for Lease Extension/Reversal
rhsp Historical Lease Payment Schedule for Lease Extension/Reversal
rhsr Historical Lease Recurring Charge for Lease Extension/Reversal
rhss Historical Lease Salesperson for Lease Extension/Reversal
rhsv Historical Lease Subvention for Lease Extension/Reversal
rht Historical Payment
rhx Historical Transaction for Lease Extension/Reversal
rhy Lease Year to Date History
ria Invoice Assessment Description
rid Invoice Interest Detail
rig Investor Group
rin Investor
rip Insurance User Profile
ris Investor Settlement
rjp Automatic Payment Interval Schedule Header
rjps Automatic Payment Interval Schedule
rkp Collateral User Profile
rkr Credit Report
rlc Lease Meter Charge
rld Lease Deficiency
rldc Lease Deficiency Charge
rle Lender
rlec Lender Credit Line
rlh Asset License History
rli Leveraged Import
rlk Like-Kind Exchange
rll Lease Letter
rlm Lease Meter
rlo Location
rlr Vendor
rls Lease
rlsa Lease 2
rlsb Lease 3
rlsc Lease Partial Deduction
rlsd Lease 4
rlsp Lease Payment Schedule
rlsr Lease Recurring Charge
rlss Lease Salesperson
rlsv Lease Subvention
rlt Letters
rma Master Application/Lease Cross-reference
rmf Loan
rmfp Loan Payment Schedule
rmi Monthly Interest Income
rmo Metro2 File Format
rmp Maturing Lease User Profile
rmr Lease Meter Asset Reading
rmt Master Application Transaction
rna Non-Lease Address
rnc Note Payable Principal Change
rnh Note Payable Payment History
rnl Next Customer/Group
rnm Name
rno Note
rnon Note Payment Schedule
rnp Note Payable Payment
rns Note Payable Status
rnt Note Payable Transaction
roa Dead Application
rop Operator
rou Addresses for Asset
rpa Portfolio
rpar Porfolio Charge
rpay Portfolio 2
rpaz Portfolio 3
rpc Principal Change
rpd Payoff Quote
rpe Post-Delete Processing
rpf Portfolio Status Header
rpfa Portfolio Status
rph Payment History
rpha Payment History Assessment
rpi Premium Insurance
rpl Repo Lease
rpm Check Payment Master
rpn Check Payment Detail
rpo Repo Asset
rpp Participation Payable
rpr Daily Base Rate
rps Historical Lease
rpsp Historical Lease Payment Schedule
rpt Payment Hierarchy
rpu Payment Reschedule Reversal Asset
rpup Payment Reschedule Reversal Asset Payment Schedule
rpw Password History
rpx Batch Payoff Detail
rpy Batch Payoff
rpz Payoff Assessment History
rqd Asset Payoff/Termination
rqdp Asset Payoff/Termination Payment Schedule
rqm CCA Asset Master
rqp CCA Pool
rqr Asset Receivable
rqs CCA Notional Loan
rqt CCA Class
rqtr CCA Class Effective Rate
rqu Collection Queuing
rqx Asset Transaction
rqy CCA Master Year End
rqz CCA Pool Year End
rrc Recurring Charge Payment Schedule Header
rrcp Recurring Charge Payment Schedule
rrf Reference
rrg Rate Plan Group Header
rrgc Rate Plan Group
rrp Rate Plan
rrpf Rate Plan Payment Factor
rrr Reschedule Reversal
rrrp Reschedule Reversal - Orig Pmt Sched
rrrq Reschedule Reversal - New Pmt Sched
rru Recovery User Profile
rsa Sales Tax on Assessment
rsb Sales Tax Breakdown
rsc Operator Security
rsca Operator Security 2
rse Electronic Payment Service Account
rsf Daily Session
rsfs Daily Session Item
rsh Historical Sub Asset
rso Electronic Payment Source
rsp Customer Service User Profile
rsq Sub Asset
rsr Suspense Reversal
rst State
rsu Suspense
rtb Client Billing Transaction
rtd Table-Driven Depreciation
rtf Transaction Fee for Reversal
rtl Loan Transaction
rtm Team Header
rtmn Team
rtn Note Payable General Ledger Transaction
rtp Tax Payable
rtr Tax Released
rtx Monthly Transaction
rtz Time Zone
rua User Defined Asset Fields
ruaa User Defined Asset Fields 2
ruab User Defined Asset Fields 3
ruac User Defined Asset Fields 4
ruad User Defined Asset Fields 5
rub User Defined Asset Table Header
rubt User Defined Asset Table
ruc User Defined Client
rud User Defined Customer Fields
ruda User Defined Customer Fields 2
rudb User Defined Customer Fields 3
rudc User Defined Customer Fields 4
rudd User Defined Customer Fields 5
rue User Defined Customer Table Header
ruet User Defined Customer Table
ruf User Defined Fields Description
rufa User Defined Fields Description 2
rufb User Defined Fields Description 3
rufc User Defined Fields Description 4
rufd User Defined Fields Description 5
rug User Defined Lease Fields
ruga User Defined Lease Fields 2
rugb User Defined Lease Fields 3
rugc User Defined Lease Fields 4
rugd User Defined Lease Fields 5
ruh User Defined Lease Table Header
ruht User Defined Lease Table
ruj User Defined Application Fields
ruja User Defined Application Fields 2
rujb User Defined Application Fields 3
rujc User Defined Application Fields 4
rujd User Defined Application Fields 5
ruk User Defined Application Table Header
rukt User Defined Application Table
rum User Defined Lessee Fields
ruma User Defined Lessee Fields 2
rumb User Defined Lessee Fields 3
rumc User Defined Lessee Fields 4
rumd User Defined Lessee Fields 5
run User Defined Lessee Table Header
runt User Defined Lessee Table
ruo User Defined Vendor Fields
ruoa User Defined Vendor Fields 2
ruob User Defined Vendor Fields 3
ruoc User Defined Vendor Fields 4
ruod User Defined Vendor Fields 5
ruq User Defined Vendor Table Header
ruqt User Defined Vendor Table
rur User Defined Application Asset Fields
rura User Defined Application Asset Fields 2
rurb User Defined Application Asset Fields 3
rurc User Defined Application Asset Fields 4
rurd User Defined Application Asset Fields 5
rus User Defined Application Asset Table Header
rust User Defined Application Asset Table
rut User Defined Tables Description
rvd Asset Description
rvg Vertex Custom General
rvh Historical Vertex O Submission
rvl Vertex O Lease Invoice Parameters
rvp Vertex O Tax Payable
rvr Vertex O Tax Result
rvs Vertex O Submission
rvu Vertex O Invoice Parameters
rvuf Vertex O Invoice Flexible Fields
rvx Vertex O Transaction
rwh Vertex O Asset Level Transaction History
rwp Vertex O Asset Level Invoice Parameters
rwpf Vertex O Asset Level Unit Invoice Flexible Fields
rwr Vertex O Asset Level Tax Result
rws Vertex O Asset Level Submission
rwt Weighting
rwx Vertex O Asset Level Transaction
rxc Credit Bureau Extract Client
rxf Federal Highway Use Tax
rxl Credit Bureau Extract Lease
rxp EOP Synchronization
rxr Auto Lease Extension Recurring Charge Payment Schedule Header
rxrp Auto Lease Extension Recurring Charge Payment Schedule
rxu Auto Lease Extension Asset
rxup Auto Lease Extension Asset Payment Schedule
ryr End of Year Tax
rza Client Auditing
rzg General Ledger Name
rzga General Ledger Account Name
rzp Time Zone Zip
rzq Business Calendar
rzu Maintenance
rzz Server Auditing

 

Views


Name Description
vlo_city City
vlo_county County
vrar_tot_out A/R Total Outstanding
vrarb_tot A/R Totals by Invoice
vrcx_brk Broker Short Name
vrcx_cus Customer Short Name
vrcx_grt Guarantor Short Name
vrcx_hls Historical Lessee Short Name
vrcx_inv Investor Short Name
vrcx_len Lender Short Name
vrcx_les Lessee Short Name
vrcx_vnd Vendor Short Name
vrgc_col Co-Lessee Cross-reference
vrgc_grt Guarantor Cross-reference
vrgc_udc User Defined Client Cross-reference
vrls_billing Lease Billing Information
vrnm_com Company Name
vrnm_ct County Name
vrnm_cy City Name
vrnm_fin Financial Institution Name
vrnm_off Office Name
vrnm_offc Officer Name
vrnm_por Portfolio Name
vrnm_reg Region Name
vrnm_sales Salesperson Name
vrnm_tax Tax Entity Name
vrpa_client_assmt Client Assessment Name
vrtp_asset_fee Payable - Asset Fee
vrtp_fhut Payable - FHUT
vrtp_ptax Payable - Property Tax
vrtp_rcr Payable - Recurring Charge
vrtp_utax Payable - Use Tax
vrtr_asset_fee Payable Released - Asset Fee
vrtr_fhut Payable Released - FHUT
vrtr_ptax Payable Released - Property Tax
vrtr_rcr Payable Released - Recurring Charge
vrtr_utax Payable Released - Use/Sales Tax
vrvd_mdl Manufacturer/Model
vrvd_mnf Manufacturer