rvx Table: Vertex O Transaction
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rvx Table: Vertex O Transaction

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rvx_idx0 lse_s invo_s unit_s item_chrg_typ_s
rvx_idx1 unit_s lse_s invo_s item_chrg_typ_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
lse_s
Lease
CHAR(10) no
invo_s
Invoice number
CHAR(8) no
unit_s
Asset
CHAR(10) no
item_chrg_typ_s
Invoice item charge type (A.TYP code or IC.TYP code)
CHAR(4) no
stamp_l
Record modification stamp
NUMBER(10) no
pmt_d
Payment amount
NUMBER(15,2) yes
stax_d
Sales tax amount
NUMBER(15,2) yes