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

Database Reference

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
unit_s
Asset
seq_num_s
Sequence number
Record modification stamp
d_org_pmtdu_s
Original payment due date
d_create_s
Date created
vtx_com_s
Vertex company
vtx_div_s
Vertex division
vtx_dept_s
Vertex department
les_s
Lessee number
lse_s
Lease
dlr_s
Vendor
part_num_s
Part number
cls_s
Class (CLASS code)
org_d
Original acquisition cost
fmv_d
Fair market value
vtx_taid_a_s
Vertex tax area id A
st_a_s
State code (RST.ST_S code) A
cnty_a_s
County A
cty_a_s
City A
add_a_s
Address A
add2_a_s
Address 2 A
zip_a_s
Zip code A
vtx_taid_b_s
Vertex tax area id B
st_b_s
State code (RST.ST_S code) B
cnty_b_s
County B
cty_b_s
City B
add_b_s
Address B
add2_b_s
Address 2 B
zip_b_s
Zip code B
vtx_taid_c_s
Vertex tax area id C
st_c_s
State code (RST.ST_S code) C
cnty_c_s
County C
cty_c_s
City C
add_c_s
Address C
add2_c_s
Address 2 C
zip_c_s
Zip code C
tax_a_d
Tax accrued
tax_p_d
Tax paid
pmt_a_d
Payment amount accrued
pmt_p_d
Payment amount paid
trans_typ_c
Transaction type (L/S)
  L - Lease
  S - Sale
tax_exmpt_c
Tax exempt (Y/N)
exmpt_rsn_s
Exemption reason
  NOEX - Exempt use and sale
  NOPF - Tax paid upfront
  NONR - Exempt and non rpt
  NOUT - Exempt use tax only