LeasePak 5.2a Database Reference (Oracle)

HomeTableIndexes

rbc Table: Batch Cash Control

Description Column Datatype
Batch date d_batch_s date
Batch number batch_num_s char (6)
Oracle row stamp stamp_l number (10)
Batch projected total total_d number (15,2)
Status (UNPR/SUBM/FAIL/IPRG/COMP)
  UNPR - unprocessed
  SUBM - submitted
  FAIL - failed (nothing processed)
  IPRG - in progress
  COMP - completed
status_s char (4)
Batch count total count_l number (10)
Processed entries count processed_cnt_l number (10)
Processed entries total processed_tot_d number (15,2)
Run date d_run_s date
Run time t_run_s char (6)
Operator initials opr_s char (3)
Batch validated (Y/N) validated_c char (1)

rbc Indexes:

Index name Piece 1 Piece 2
rbc_idx0 d_batch_s batch_num_s


HomeTableIndexes