rlt Table: Letters
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rlt Table: Letters

Indexes

Name Segment 1 Segment 2 Segment 3
rlt_idx0 lse_s d_run_s t_run_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
d_run_s
Run date
DATE no
t_run_s
Run time
CHAR(6) no
stamp_l
Record modification stamp
NUMBER(10) no
d_eff_s
Letter effective date
DATE yes
letter_s
Letter code
CHAR(8) yes
processed_c
Processed indicator (Y/N)
CHAR(1) yes
letter_num_s
Letter number
CHAR(3) yes
memo_s
Memo
VARCHAR2(250) yes
count_l
Count
NUMBER(10) yes
amt_d
Letter amount
NUMBER(15,2) yes