rgg Table: Gain/Loss Reconciliation
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rgg Table: Gain/Loss Reconciliation

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7 Segment 8
rgg_idx0 por_s com_s reg_s off_s lse_s unit_s d_run_s t_run_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
lse_s
Lease
char(10) no
unit_s
Asset
char(10) no
d_run_s
Run date
datetime no
t_run_s
Run time
char(6) no
timestamp
Record modification stamp
timestamp yes
allow_d
Allowance for bad debt
double precision yes
d_unit_disp_s
Asset disposition date
datetime yes
gain_d
Gain
double precision yes
gnls_orig_c
Gain/loss transaction originator (P/T/B/S/A)
  P - Payoff
  T - Termination
  B - Batch payoff
  S - Sale of asset
  A - GL adjustmnents
char(1) yes
loss_d
Loss
double precision yes
nbv_pay_d
Net book value at payoff
double precision yes
pro_sale_d
Proceeds of sale
double precision yes