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

Database Reference Oracle 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
DATE no
por_s
Portfolio
CHAR(2) no
dlr_s
Vendor
CHAR(9) no
lse_s
Lease
CHAR(10) no
d_run_s
Run date
DATE no
t_run_s
Run time
CHAR(6) no
unique_s
Unique portion for key
CHAR(5) no
stamp_l
Record modification stamp
NUMBER(10) no
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
DATE yes
t_printed_s
Time cashier's check was printed
CHAR(6) yes
d_rev_s
Reversal date
DATE yes
chk_s
Check number
CHAR(6) yes
tx_d
Transaction amount
NUMBER(15,2) yes
unit_s
Asset
CHAR(10) yes
rev_trn_rsn_s
Transaction reversal reason code (REV.TR.RSN code)
CHAR(4) yes