rbs Table: Batch Assessment
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rbs Table: Batch Assessment

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7 Segment 8
rbs_idx0 por_s com_s reg_s off_s lse_s d_run_s t_run_s unique_s

     
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
CHAR(2) no
com_s
Company
CHAR(2) no
reg_s
Region
CHAR(2) no
off_s
Office
CHAR(3) 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
unit_s
Asset
CHAR(10) yes
a_typ_s
Assessment type
CHAR(4) yes
invo_s
Invoice number
CHAR(8) yes
trn_rsn_s
Transaction reason code (TRN.RSN code)
CHAR(4) yes
ptax_desc_s
Property tax description code
CHAR(4) yes
fhut_desc_s
Federal highway use tax (FHUT) description code
CHAR(4) yes
a_lvl_c
Assessment level
  L=Lease A=Asset
CHAR(1) yes
d_pmtdu_s
Payment due date
DATE yes
d_lien_s
Last lien date
DATE yes
aamt_b_d
Assessment amount billed
NUMBER(15,2) yes
assmt_desc_s
Assessment description
VARCHAR2(100) yes