rwp Table: Vertex O Asset Level Invoice Parameters
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rwp Table: Vertex O Asset Level Invoice Parameters

Child Tables

Name Description
rwpf Vertex O Asset Level Unit Invoice Flexible Fields

Indexes

Name Segment 1 Segment 2 Segment 3
rwp_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
timestamp
Record modification stamp
timestamp yes
d_org_pmtdu_s
Original payment due date
datetime yes
d_create_s
Date created
datetime yes
vtx_com_s
Vertex company
char(40) yes
vtx_div_s
Vertex division
char(3) yes
vtx_dept_s
Vertex department
char(3) yes
les_s
Lessee number
char(9) yes
lse_s
Lease
char(10) yes
dlr_s
Vendor
char(9) yes
part_num_s
Part number
char(25) yes
cls_s
Class (CLASS code)
char(4) yes
org_d
Original acquisition cost
double precision yes
fmv_d
Fair market value
double precision 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
char(60) yes
cty_a_s
City A
char(25) yes
add_a_s
Address A
char(36) yes
add2_a_s
Address 2 A
char(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
char(60) yes
cty_b_s
City B
char(25) yes
add_b_s
Address B
char(36) yes
add2_b_s
Address 2 B
char(36) yes
zip_b_s
Zip code B
char(9) yes
vtx_taid_c_s
Vertex tax area id C
char(10) yes
st_c_s
State code (RST.ST_S code) C
char(2) yes
cnty_c_s
County C
char(60) yes
cty_c_s
City C
char(25) yes
add_c_s
Address C
char(36) yes
add2_c_s
Address 2 C
char(36) yes
zip_c_s
Zip code C
char(9) yes
tax_a_d
Tax accrued
double precision yes
tax_p_d
Tax paid
double precision yes
pmt_a_d
Payment amount accrued
double precision yes
pmt_p_d
Payment amount paid
double precision yes
trans_typ_c
Transaction type (L/S)
  L - Lease
  S - Sale
char(1) yes
tax_exmpt_c
Tax exempt (Y/N)
char(1) yes
exmpt_rsn_s
Exemption reason
  NOEX - Exempt use and sale
  NOPF - Tax paid upfront
  NONR - Exempt and non rpt
  NOUT - Exempt use tax only
char(4) yes