rba Table: Batch Sale of Asset
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rba Table: Batch Sale of Asset

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5
rba_idx0 por_s com_s reg_s off_s unit_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
por_s
Portfolio
char(2) no
com_s
Company
char(2) no
reg_s
Region
char(2) no
off_s
Office
char(3) no
unit_s
Asset
char(10) no
timestamp
Record modification stamp
timestamp yes
d_run_s
Run date
datetime yes
t_run_s
Run time
char(6) yes
gp_typ_c
Gross profit type (R/U)
  R - related
  U - unrelated
char(1) yes
bank_s
Bank account GL vector
  '  1' - If multiple banks module is purchased
  '   ' - multiple banks module is not purchased
char(3) yes
chk_num_s
Check number
char(10) yes
susp_num_s
Suspense number
char(6) yes
st_s
State code (RST.ST_S code)
char(2) yes
ct_s
County location code
char(4) yes
cy_s
City location code
char(4) yes
allow_d
Allowance for bad debt
double precision yes
loss_on_sale_d
Loss on Sale
double precision yes
received_d
Amount received
double precision yes
p_payoff_st_rate_d
Payoff/sale state rate
double precision yes
p_payoff_ct_rate_d
Payoff/sale county rate
double precision yes
p_payoff_cy_rate_d
Payoff/sale city rate
double precision yes
payoff_tax_amt_d
Payoff/sale taxable amount
double precision yes