rvp Table: Vertex O Tax Payable
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rvp Table: Vertex O Tax Payable

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4
rvp_idx0 lse_s invo_s unit_s item_chrg_typ_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
item_chrg_typ_s
Invoice item charge type (A.TYP code or IC.TYP code)
char(4) no
timestamp
Record modification stamp
timestamp 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
ovr_typ_c
Override type (' '/N)
  ' ' - override not used
  N - Nontaxable
char(1) yes
org_d
Original acquisition cost
double precision yes
d_create_s
Date created
datetime yes