rwx Table: Vertex O Asset Level Transaction
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rwx Table: Vertex O Asset Level Transaction

Indexes

Name Segment 1 Segment 2 Segment 3
rwx_idx0 chrg_typ_c unit_s seq_num_s

   
Columns
Name DescriptionDatatype ¿? Allow Null
chrg_typ_c
Charge type (S/U)
  S - Sale of asset
  U - Upfront sales tax
CHAR(1) no
unit_s
Asset
CHAR(10) no
seq_num_s
Sequence number
CHAR(3) 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