rvu Table: Vertex O Invoice Parameters
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Oracle DBMS

rvu Table: Vertex O Invoice Parameters

Child Tables

Name Description
rvuf Vertex O Invoice Flexible Fields

Indexes

Name Segment 1 Segment 2 Segment 3
rvu_idx0 lse_s invo_s unit_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
stamp_l
Record modification stamp
NUMBER(10) no
dlr_s
Vendor
CHAR(9) yes
part_num_s
Part number
VARCHAR2(25) yes
cls_s
Class (CLASS code)
CHAR(4) yes
txp_s
Tax payment code (TXP code)
CHAR(4) yes
org_d
Original acquisition cost
NUMBER(15,2) yes
p_sch_d
Percentage of schedule amount
NUMBER(15,5) yes
vtx_taid_a_s
Vertex tax area id A
CHAR(10) yes
st_a_s
State code (RST.ST_S code) A
CHAR(2) yes
cnty_a_s
County A
VARCHAR2(60) yes
cty_a_s
City A
VARCHAR2(25) yes
add_a_s
Address A
VARCHAR2(36) yes
add2_a_s
Address 2 A
VARCHAR2(36) yes
zip_a_s
Zip code A
CHAR(9) yes
vtx_taid_b_s
Vertex tax area id B
CHAR(10) yes
st_b_s
State code (RST.ST_S code) B
CHAR(2) yes
cnty_b_s
County B
VARCHAR2(60) yes
cty_b_s
City B
VARCHAR2(25) yes
add_b_s
Address B
VARCHAR2(36) yes
add2_b_s
Address 2 B
VARCHAR2(36) yes
zip_b_s
Zip code B
CHAR(9) yes