rbd Table: Batch Cash Control Detail
LeasePak Documentation Suite NETSOL website
LeasePak Database Objects

Database Reference Sybase DBMS

rbd Table: Batch Cash Control Detail

Indexes

Name Segment 1 Segment 2 Segment 3 Segment 4 Segment 5 Segment 6
rbd_idx0 d_batch_s batch_num_s batch_seq_num_s batch_det_num_s    
rbd_idx1 por_s lse_s d_batch_s batch_num_s batch_seq_num_s batch_det_num_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
d_batch_s
Batch date
datetime no
batch_num_s
Batch number
char(6) no
batch_seq_num_s
Batch sequence number
char(8) no
batch_det_num_s
Batch detail number
char(4) no
timestamp
Record modification stamp
timestamp yes
lse_s
Lease
char(10) no
invo_s
Invoice number
char(8) yes
amount_d
Payment amount
double precision yes
d_eff_s
Effective date of payment
datetime yes
clearing_c
Clearing indicator (Y/N)
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
tran_override_s
Transaction override
char(4) yes
processed_c
Processed indicator (Y/N)
char(1) yes
opr_s
Operator initials
char(3) yes
chk_num_s
Check number
char(10) yes
por_s
Portfolio
char(2) no