rtb Table: Client Billing Transaction
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rtb Table: Client Billing Transaction

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6 Segment 7 Segment 8
rtb_idx0 por_s com_s reg_s off_s client_id_s d_run_s t_run_s trn_count_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
client_id_s
Client
char(9) no
d_run_s
Run date
datetime no
t_run_s
Run time
char(6) no
trn_count_s
Transaction counter
char(2) no
timestamp
Record modification stamp
timestamp yes
client_rel_s
Client relation
  CUS - Customer
  LES - Lessee/Co-lessee
  HLS - Historical Lessee/Co-lessee
  INV - Investor
  BRK - Broker
  VND - Vendor
  GRT - Guarantor
  LEN - Lender
  *** - User-defined
char(3) yes
invo_s
Invoice number
char(8) yes
bank_s
Bank account GL vector
  '  1' - If multiple banks module is purchased
  '   ' - multiple banks module is not purchased
char(3) yes
opr_s
Operator initials
char(3) yes
d_eff_s
Effective date
datetime yes
d_indu_s
Invoice due date
datetime yes
chk_num_s
Check number
char(10) yes
trn_s
Transaction code
char(4) yes
crdt_l
Account credit vector
integer yes
dbt_l
Account debit vector
integer yes
chg_d
Amount of money change
double precision yes