LeasePak 5.1a Database Reference (Sybase)

HomeShortcutsTablesViews

Shortcuts to r-tables

A B C D E F G H I K L M N O P Q R S T U V W X Y Z

LeasePak Tables

Table Description
mcml Custom Module Letters
mcmu Custom Module User Defined Menu Options
mja Asset Notebook
mjc Client Notebook
mjl Lease Notebook
mlo_city Location City
mlo_county Location County
mlt Lease Letter
mpa_assmt Portfolio Assessments
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
mvd_mdl Manufacturer/Model
mvd_mnf Manufacturer
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
raa Recovery Agency Assignment
rab Account/Bankruptcy Status
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
ral Lessee/Co-Lessee
rale Lessee/Co-Lessee Employment
rap Application
rapa Application 2
rapd Application Document
raph Application Status History
rapp Application Payment Schedule
rapr Application Recurring Charge
raps Application Salesperson
raq Application Asset
raqc Application Asset Condition
raqu Application Asset UCC
rar Accounts Receivable
rarb Accounts Receivable Assessment
ras EOP Accrual System
rase EOP Module
rau Application User Profile
rax Automatic Lease Extension
raxp Automatic Lease Extension Payment Schedule
raxr Automatic Lease Extension Recurring Charge
rba TRW Activity Status
rbc Batch Cash Control
rbd Batch Cash Control Detail
rbi Billing Manager Interface
rbk Broker
rbl Target Principal
rblt Target Principal Amount
rbp Batch Payment
rbr Batch Book Requirements
rbs Batch Assessment
rca Lease Form
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
rcga Custom General Assessment
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
rco Collection Status Defaults
rcp Collection User Profile
rcr Custom Report
rcs Historical Asset
rcu Customer
rcx Client Search
rdc Document Header
rdcd Document
rdf Deferred Lease Income
rdg Document Generation
rdh Dealer Transaction History
rdl Vendor Total
rdm Demographic
rdmi Demographic Insurance
rdq Reason/Condition
rdr Deferral Reversal
rdrp Deferral Reversal - Orig Pmt Sched
rdrq Deferral Reversal - New Pmt Sched
rdt Dealer Transaction
rdu Deferral Reversal Asset
rep End of Period
repe End of Period Status
req Asset
reqa Asset 2
reqc Asset Condition
requ Asset UCC
rer Application Entry Requirement
res Equity Movement Status
rex Credit Bureau Extract
rfa File Attachments
rfl Group
rfs Application Field Security
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
rgr Guarantor
rha Historical Accounts Receivable
rhab Historical Accounts Receivable Assessment
rhe Historical Credit Bureau Extract
rhh Historical Principal Change for Reschedule Reversal
rhl Historical Lessee
rho Historical Location
rhp Historical Note Payable
rhq Historical Asset for Lease Extension/Reversal
rhqa Historical Asset for Lease Extension/Reversal 2
rhqc Historical Asset Condition 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 for Lease Extension/Reversal 2
rhsb Historical Lease for Lease Extension/Reversal 3
rhsc Historical Lease Partial Deduction 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
rht Historical Payment
rhx Historical Transaction for Lease Extension/Reversal
rhy Lease Year to Date History
rid Invoice Interest Detail
rig Investor Group
rin Investor
rip Insurance User Profile
ris Investor Settlement
rkp Collateral User Profile
rkr Credit Report
rle Lender
rlec Lender Credit Line
rlh Asset License History
rli Leveraged Import
rll Lease Letter
rlo Location
rlr Vendor
rls Lease
rlsa Lease 2
rlsb Lease 3
rlsc Lease Partial Deduction
rlsp Lease Payment Schedule
rlsr Lease Recurring Charge
rlss Lease Salesperson
rlt Letters
rmf Loan
rmfp Loan Payment Schedule
rmp Maturing Lease User Profile
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
rpa Portfolio
rpar Porfolio Recurring Charge
rpay Portfolio 2
rpaz Portfolio 3
rpc Principal Change
rpd Payoff Quote
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
rpu Payment Reschedule Reversal Asset
rpw Password History
rpx Batch Payoff Detail
rpy Batch Payoff
rpz Payoff Assessment History
rqm CCA Asset Master
rqp CCA Pool
rqs CCA Notional Loan
rqt CCA Class
rqtr CCA Class Effective Rate
rqu Collection Queuing
rqy CCA Master Year End
rqz CCA Pool Year End
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
rsf Daily Session
rsfs Daily Session Item
rsh Historical Sub Asset
rsp Customer Service User Profile
rsq Sub Asset
rsr Suspense Reversal
rst State
rsu Suspense
rtd Table-Driven Depreciation
rtl Loan Transaction
rtm Team Header
rtmn Team
rtn Note Payable General Ledger Transaction
rtp Tax Payable
rtr Tax Released
rtx Monthly Transaction
rty Lease Level Transaction
rtz Time Zone
rua User Defined Asset Fields
rub User Defined Asset Table Header
rubt User Defined Asset Table
ruc User Defined Client
rud User Defined Customer Fields
rue User Defined Customer Table Header
ruet User Defined Customer Table
ruf User Defined Fields Description
rug User Defined Lease Fields
ruh User Defined Lease Table Header
ruht User Defined Lease Table
ruj User Defined Application Fields
ruk User Defined Application Table Header
rukt User Defined Application Table
rum User Defined Lessee Fields
run User Defined Lessee Table Header
runt User Defined Lessee Table
ruo User Defined Vendor Fields
ruq User Defined Vendor Table Header
ruqt User Defined Vendor Table
rur User Defined Application Asset Fields
rus User Defined Application Asset Table Header
rust User Defined Application Asset Table
rut User Defined Tables Description
rvd Asset Description
rwt Weighting
rxf Federal Highway Use Tax
rxp EOP Synchronization
rxu Auto Lease Extension Asset
ryr End of Year Tax
rza Auditing Transaction
rzg General Ledger Name
rzga General Ledger Account Name
rzp Time Zone Zip
rzq Holiday
rzu Maintenance

LeasePak Views

View Description
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
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
vrtp_fhut Payable - FHUT
vrtp_ptax Payable - Property Tax
vrtp_rcr Payable - Recurring Charge
vrtp_utax Payable - Use Tax
vrtr_fhut Payable Released - FHUT
vrtr_ptax Payable Released - Property Tax
vrtr_rcr Payable Released - Recurring Charge
vrtr_utax Payable Released - Use/Sales Tax


HomeShortcutsTablesViews

(c) Copyright 2004 McCue Systems, Inc.