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

Database Reference Oracle DBMS

rbc Table: Batch Cash Control

Indexes

Name Segment 1 Segment 2
rbc_idx0 d_batch_s batch_num_s

    
Columns
Name DescriptionDatatype ¿? Allow Null
d_batch_s
Batch date
DATE no
batch_num_s
Batch number
CHAR(6) no
stamp_l
Record modification stamp
NUMBER(10) no
total_d
Batch projected total
NUMBER(15,2) yes
status_s
Status (UNPR/SUBM/FAIL/IPRG/COMP)
  UNPR - unprocessed
  SUBM - submitted
  FAIL - failed (nothing processed)
  IPRG - in progress
  COMP - completed
CHAR(4) yes
count_l
Batch count total
NUMBER(10) yes
processed_cnt_l
Processed entries count
NUMBER(10) yes
processed_tot_d
Processed entries total
NUMBER(15,2) yes
d_run_s
Run date
DATE yes
t_run_s
Run time
CHAR(6) yes
opr_s
Operator initials
CHAR(3) yes
validated_c
Batch validated (Y/N)
CHAR(1) yes