rdh Table: Dealer Transaction History
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rdh Table: Dealer Transaction History

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7
rdh_idx0 d_dis_s por_s dlr_s lse_s d_run_s t_run_s unique_s
rdh_idx1 por_s lse_s d_dis_s dlr_s d_run_s t_run_s unique_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
d_dis_s
Disbursement date
datetime no
por_s
Portfolio
char(2) no
dlr_s
Vendor
char(9) no
lse_s
Lease
char(10) no
d_run_s
Run date
datetime no
t_run_s
Run time
char(6) no
unique_s
Unique portion for key
char(5) no
timestamp
Record modification stamp
timestamp yes
tran_s
Transaction type
char(4) yes
trn_rsn_s
Transaction reason code (TRN.RSN code)
char(4) yes
t_dis_s
Disbursement time
char(6) yes
d_printed_s
Date cashier's check was printed
datetime yes
t_printed_s
Time cashier's check was printed
char(6) yes
d_rev_s
Reversal date
datetime yes
chk_s
Check number
char(6) yes
tx_d
Transaction amount
double precision yes
unit_s
Asset
char(10) yes
rev_trn_rsn_s
Transaction reversal reason code (REV.TR.RSN code)
char(4) yes