rws Table: Vertex O Asset Level Submission
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rws Table: Vertex O Asset Level Submission

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rws_idx0 chrg_typ_c unit_s seq_num_s d_run_s t_run_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
d_run_s
Run date
datetime no
t_run_s
Run time
char(6) no
timestamp
Record modification stamp
timestamp yes
vtx_status_c
Vertex submission status (C/I/S)
  C - completed
  I - in process
  S - submitted
char(1) yes
pmt_d
Payment amount
double precision yes
stax_d
Sales tax amount
double precision yes