LeasePak Database Objects

LeasePak Database Objects Sybase DBMS

Index of Tables and Views

'm' Tables

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